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

1. Banks

2. Receipt Class

3. Payment Method

4. Receipt Source

5. Lockbox

6. Transmission format

7. AutoCash Rule sets

Interface tables

1. AR_PAYMENTS_INTERFACE_ALL (Import data from bank file)

2. AR_INTERIM_CASH_RECEIPTS_ALL

3. AR_INTERIM_CASH_RCPT_LINES_ALL (Validate data in interface table and place in quick cash tables)

Base Tables

1. AR_CASH_RECEIPTS

2. AR_RECEIVABLES_APPLICATIONS

3. AR_ADJUSTMENTS

4. AR_DISTRIBUTIONS_ALL

5. AR_PAYMENT_SCHEDULES_ALL

Concurrent program

1. Lockbox

Validations

1. Check for valid record type, transmission record id.

2. Validate sum of the payments within the transmission.

3. Identify the lockbox number (no given by a bank to identify a lockbox)

Some important columns that need to be populated in the AR_PAYMENTS_INTERFACE_ALL tables

1. STATUS

2. RECORD_TYPE

3. LOCKBOX_NUMBER

4. BATCH_NAME

5. TRANSIT_ROUTING_NUMBER

6. ACCOUNT

7. CHECK_NUMBER

8. REMITTANCE_AMOUNT

9. DEPOSIT_DATE

10. ITEM_NUMBER

11. CURRENCY_CODE

12. DEPOSIT_TIME