Previous	Next		Contents	Index	Navigation	Glossary	Library

Bank Origination Number: The bank origination number of the bank that transmitted this lockbox file. Receivables determines the Bank Origination number from the remittance bank account you entered in the Lockboxes window. This field is in the Lockbox Control window.

Control File: (Submit Lockbox Processing window) Receivables uses SQL *Loader to load information from your operating system files into the Receivables database. The control file is used by SQL *Loader to map the data in the bank file to tables and columns in the Oracle database. You need to create a control file for each bank file that uses a different transmission format. For SQL *Loader to load your bank file properly, each logical record that your bank sends to you must end with a carriage return. If each record does not end with a carriage return, SQL *Loader displays an error message when you submit AutoLockbox.

Suggestion: If you are using Receivables Multiple Organizations Support feature, we recommend that you create a different control file for each of your organizations. Each control file should populate the default org_id column for that organization in the ar_payments_interface table. Additionally, if your existing control files use the date format 'YY' for the year, we recommend that you change this to 'RR'.

Data File: The path name and the filename of the bank file you are transferring into Receivables. This is the file that contains payment data you receive from the bank. Receivables lets you store the file in any directory. This field is in the Submit Lockbox Processing window.

Destination Account: (Lockbox Control window) The bank account into which this receipt was deposited.

Item Number: (Lockbox Transmission Data window) The item number associated with this receipt. If you have multiple receipts in a batch, you might include this in your transmission format to order receipts in a batch.

Lockbox Batch Count: (Lockbox Control window) The total number of bank batches associated with this lockbox.

Lockbox Receipt Count: (Lockbox Control window) The total number of receipts associated with this lockbox. This count does not include overflow receipts, headers, or trailers.

Overflow Sequence: (Lockbox Transmission Data window) A type of bank file record that stores additional receipt information that could not fit on the receipt record. Each Overflow record must have a receipt record as a parent. Typically, an Overflow record will store additional invoice numbers and the amount of the receipt to apply to each invoice. If there are multiple overflow records for a receipt record, each overflow record will have an overflow sequence.

Record Count: (Lockbox Control window) The total number of records in this lockbox transmission.

Record Identifier: (Lockbox Transmission Data window) A record identifier consists of at most two characters which Receivables uses to identify each record type. For example, Receivables can identify a receipt record in BAI bank files because this record always starts with the character '6'. You define valid record identifiers in the Transmission Formats window.

Transmission Format: (Submit Lockbox Processing window) A transmission format defines what data your bank is sending in the bank file, and how that data is organized so Receivables can successfully import this data. You must work with your bank to determine the content of your transmission format. Your transmission format must match each bank control file that you create, so the number of control files that you use must correspond to the number of transmission formats that you define. Receivables provides two sample formats: 'CONVERT, (arconv.ctl)' and 'DEFAULT, (ardeft.ctl)'. You can modify these transmission formats or create new ones.

See Also

Running AutoLockbox

Lockbox Execution Report