Lockbox interface

Lockbox interface

AutoLockbox lets us automatically process receipts that are sent directly to the bank instead of manually feeding them in Oracle Receivables.

AutoLockbox is a three step process:

1. Import: During this step, Lockbox reads and formats the data from your bank file into interface table AR_PAYMENTS_INTERFACE_ALL using a SQL *Loader script.
2. Validation: The validation program checks data in this interface table for compatibility with Receivables. Once validated, the data is transferred into QuickCash tables (AR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALL).
3. Post QuickCash: This step applies the receipts and updates your customer’s balances.

Pre-Requisites:

• Banks
• Receipt Class
• Payment Method
• Receipt Source
• Lockbox
• Transmission format
• AutoCash Rule sets

Interface tables:

• AR_PAYMENTS_INTERFACE_ALL (Import data from bank file)
• AR_INTERIM_CASH_RECEIPTS_ALL
• AR_INTERIM_CASH_RCPT_LINES_ALL (Validate data in interface table and place in quick cash tables)

Base Tables:

• AR_CASH_RECEIPTS
• AR_RECEIVABLES_APPLICATIONS
• AR_ADJUSTMENTS
• AR_DISTRIBUTIONS_ALL
• AR_PAYMENT_SCHEDULES_ALL

Concurrent program:

• Lockbox

Validations:

• Check for valid record type, transmission record id.
• Validate sum of the payments within the transmission.
• Identify the lockbox number (no given by a bank to identify a lockbox).

Important Columns:

Some important columns that need to be populated in the interface tables:

AR_PAYMENTS_INTERFACE_ALL:

• STATUS
• RECORD_TYPE
• LOCKBOX_NUMBER
• BATCH_NAME
• TRANSIT_ROUTING_NUMBER
• ACCOUNT
• CHECK_NUMBER
• REMITTANCE_AMOUNT
• DEPOSIT_DATE
• ITEM_NUMBER
• CURRENCY_CODE
• DEPOSIT_TIME