Lockbox Transmission Format Field Types
Enter the lockbox transmission field types to use to identify the characteristics of each lockbox transmission record type.
You specify the size, order, and format of each transmission record. The lockbox transmission program only validates the fields that you define in your transmission format. The transmission format must be fully compatible with how you organize data in your lockbox file.
Field Types
Account
Your customer bank account. The bank account number and the transit routing number make up your customer MICR number.
Alternate Name
The alternate name for this customer.
Amount Applied 1 to 8
The amount applied to each invoice, debit memo, or chargeback. Each payment or overflow payment record can accommodate up to eight debit item numbers. For cross-currency applications, this is the amount to apply in the transaction currency.
Amount Applied From 1 to 8
Used for cross-currency receipt applications, this is the amount applied to each transaction in the receipt currency. Each payment or overflow payment record can accommodate up to eight debit item numbers.
Attribute 1 to 15
Use attributes to enter descriptive flexfield segments. Attributes can only be assigned to payment records.
Bank Transaction Code
A code defined for each account, used by your bank to uniquely identify the kind of transaction in a bank statement (for example, debit, credit, void). This is also used by Cash Management to determine the receipt effective date.
Batch Amount
The total receipt batch amount for a specific bank batch.
Batch Name
The name of the batch for a specific bank batch.
Batch Record Count
The total number of payment records in a specific bank batch. The total number of all batch record counts equals the Lockbox Record Count. This doesn't include overflow payments, headers, or trailers.
Billing Location
Your bank transmits the billing location of the payment. You must only specify the field name and the field positions that the billing location occupies in the transmitted data file.
Comment
Any comments you want to associate with this transmission.
Conversion Rate
The conversion rate associated with this payment, if you’re using lockbox to import foreign currency receipts.
Conversion Type
The conversion type used to convert a foreign currency receipt to the ledger currency.
Currency
The currency of the payment. For cross-currency payments, you can also enter the Invoice Currency. If you don't enter a value in this field, lockbox derives the currency from the information provided in the Amount Applied 1 to 8 and Amount Applied From 1 to 8 fields.
Customer Bank Branch Name
The name of the customer bank branch.
Customer Bank Name
The name of the customer bank.
Customer Number
The identification number of the customer who submitted a payment.
Customer Reason 1 to 8
The customer reason why a payment shows a discrepancy.
Customer Reference 1 to 8
Customer comments about this payment.
Deposit Date
The date the bank receives and deposits the customer payment.
Deposit Time
The time the bank receives and deposits the customer payment.
Destination Account
Your business bank account. Your business may have more than one bank account.
Effective Date
The date on which the bank determines a customer balance to apply interest (used by Cash Management).
Invoice 1 to 8
The invoices, debit memos, and chargebacks to which you apply your payment. Each payment or overflow payment record can accommodate up to eight debit item numbers.
Invoice 1 to 8 Installment
The installment number for this invoice.
Invoice Currency 1 to 8
The currency of the transaction. This field is used for cross-currency receipt applications. This field is optional.
Item Number
A sequence number that your bank assigns to a specific payment. This number associates an invoice with a receipt.
Lockbox Amount
The total payment amount in a specific lockbox.
Lockbox Batch Count
The total number of bank batches in a specific lockbox.
Lockbox Number
The identification number for a specific lockbox.
Lockbox Record Count
The number of payment records in a specific lockbox. This doesn't include overflow payments, headers, or trailers.
Matching Date 1-8
The dates to use to match receipts with transactions, if you’re using the Match on Corresponding Date option for this lockbox.
Origination
The bank origination number provided by your bank. This number uniquely identifies the bank branch that sends you lockbox information.
Overflow Indicator
Indicates any additional overflow records for this payment.
Overflow Sequence
A sequence number that your bank assigns to each overflow payment.
Receipt Method
The receipt method associated with this lockbox.
Payment Number
The identification number of a payment. For example, a check number.
Receipt Date
The date your customer made a payment.
Record Identifier
A number that identifies the kind of transmission record.
Remittance Amount
The amount of a payment.
Remittance Bank Branch Name
The name of the bank branch from which this payment originated.
Remittance Bank Name
The name of the bank from which this payment originated.
Status
The status of this payment.
Total Record Count
The total number of transmission records in a bank file. This includes headers, trailers, payments, and overflow records.
Trans to Receipt Rate 1 to 8
The conversion rate used to convert the receipt amount from the receipt currency to the transaction currency. This field is used for cross-currency receipt applications, when the receipt and transaction currencies don't have a fixed rate. If the currencies have a fixed rate, this field is optional (in this case, lockbox derives the rate to use).
Transit Routing Number
The number that uniquely identifies your customer bank. The transit routing number and the customer bank account number make up the customer MICR number.
Transmission Amount
The total amount of payments for a bank file.