Lockbox Interface Table and Column Descriptions


	Previous	Next		Contents	Index	Glossary	Library

Lockbox Interface Table and Column Descriptions

When you run the Import step of AutoLockbox, Receivables stores receipt data from your bank file in the Lockbox Interface table AR_PAYMENTS_INTERFACE. Following is a detailed description of this table.

Each column in AR_PAYMENTS_INTERFACE has important, detailed information you need to successfully run Lockbox.

Column Name
Value
STATUS
There are five possible status values for data converted from the Zengin file format:
AR_PLB_ALT_MATCH_MANUAL: The user selected manual processing.
AR_PLB_ALT_MATCH_NONE: Lockbox could not find a match for this receipt in the Alternate Names table.
AR_PLB_ALT_MATCH_MULTIPLE: Lockbox found more than one match for this receipt in the Alternate Names table.
AR_PLB_ALT_MATCH_VERIFY: Lockbox found a single, exact match for this receipt in the Alternate Names table.
AR_PLB_ALT_MATCH_CONFIRMED: The receipt was either matched manually in the Lockbox Transmission Data window or it was matched automatically and then confirmed in the Lockbox Transmission Data window.
DEPOSIT_DATE
Enter the date on which this transmission was actually deposited into your bank account. The Japanese file conversion program automatically converts Heisei imperial era dates to Oracle date format.

Assigning Values to Lockbox Header or Trailer Records

If your record type is either a Lockbox Header or a Lockbox Trailer, enter the following columns with the values described.

Column Name
Value
ORIGINATION
Enter the sending bank's transit routing number. The restriction that this value must be the same as that included in a Transmission Header or Trailer does not apply to Zengin file format.
Assigning Values to Receipt Records

If your record type is a Payment, you can enter the following columns with the values described below.

Column Name
Value
LOCKBOX_NUMBER
For the Zengin file format, this number is system-generated.
ITEM_NUMBER
For the Zengin file format, this number is system-generated.
CHECK_NUMBER
For the Zengin file format, this number is system-generated.
CUSTOMER_NUMBER
For Zengin file formats, the system looks up this value in the Alternate Names table.
CUSTOMER_NAME_ALT
The customer's alternate name from the Zengin bank file.
STATUS
The system assigns one of the following values:
Manual: The user selected manual processing.
None: Lockbox could not find a match for this receipt in the Alternate Names table.
Multiple: Lockbox found more than one match for this receipt in the Alternate Names table.
Verify: Lockbox found a single, exact match in the Alternate Names table.

Contents

Index

Glossary

Library

Column Name	Value
STATUS	There are five possible status values for data converted from the Zengin file format: AR_PLB_ALT_MATCH_MANUAL: The user selected manual processing. AR_PLB_ALT_MATCH_NONE: Lockbox could not find a match for this receipt in the Alternate Names table. AR_PLB_ALT_MATCH_MULTIPLE: Lockbox found more than one match for this receipt in the Alternate Names table. AR_PLB_ALT_MATCH_VERIFY: Lockbox found a single, exact match for this receipt in the Alternate Names table. AR_PLB_ALT_MATCH_CONFIRMED: The receipt was either matched manually in the Lockbox Transmission Data window or it was matched automatically and then confirmed in the Lockbox Transmission Data window.
DEPOSIT_DATE	Enter the date on which this transmission was actually deposited into your bank account. The Japanese file conversion program automatically converts Heisei imperial era dates to Oracle date format.

Column Name	Value
ORIGINATION	Enter the sending bank's transit routing number. The restriction that this value must be the same as that included in a Transmission Header or Trailer does not apply to Zengin file format.

Column Name	Value
LOCKBOX_NUMBER	For the Zengin file format, this number is system-generated.
ITEM_NUMBER	For the Zengin file format, this number is system-generated.
CHECK_NUMBER	For the Zengin file format, this number is system-generated.
CUSTOMER_NUMBER	For Zengin file formats, the system looks up this value in the Alternate Names table.
CUSTOMER_NAME_ALT	The customer's alternate name from the Zengin bank file.
STATUS	The system assigns one of the following values: Manual: The user selected manual processing. None: Lockbox could not find a match for this receipt in the Alternate Names table. Multiple: Lockbox found more than one match for this receipt in the Alternate Names table. Verify: Lockbox found a single, exact match in the Alternate Names table.