FARMLVD_LOCKBOX_ITEM_REF

Lockbox's Payment Advice Item reference details from file | view: FMLVPALBXITR | Extraction: Not supported | Component: Financial Cash Application Intelligence
  • 🔑 Keys
  • 💰 Amounts
  • ∑ Quantities
  • 📅 Dates
  • ☰ Categorical
  • Other (23)
  • 🔗 Relations
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
LockboxFileCheckUUID NodeID /BOBF/CONF_KEY
RecordType_h Record Type for Lockbox NUM01
LockboxBatch_h Batch Number for Lockbox (Bundle Number) NUM3
AmountInTransactionCurrency Remittance Amount (Payment Amount) for Lockbox NUM10
PartnerBank Remitter Identifier 1: Transit Routing Number for Lockbox CHAR9
PartnerBankAccount Remitter Identifier 2: Account Number for Lockbox CHAR10
Cheque Check Number NUM9
LockboxFreeText_h Data Element Type CHAR Length 35 CHAR35
LockboxBatchInternalKey Short Key for Bank Statement (Surrogate Key) KUKEY_EB
LockboxBatchItem_h Memo Record Number (Line Item Number in Bank Statement) NUM5
PaymentAdviceItem null
LockboxFileReferenceUUID NodeID /BOBF/CONF_KEY
RecordType Record Type for Lockbox NUM01
LockboxBatch Batch Number for Lockbox (Bundle Number) NUM3
LockboxBatchItem Batch Item Number for Lockbox NUM3
OverflowType Type of Overflow(Recd Type 4 Still Belongs to a Recd Type 6) NUM1
SequenceNumber Sequence Number - Serial Number of Record Type 4 NUM2
LckbxBtchItmRfrncEndIndicator End Indicator ('9' the Last Record of a Type 4 Series) NUM1
Invoice Invoice Number CHAR16
PaymentAmount Payment Amount NUM10
DeductionAmountInPaytCurrency Deduction Amount NUM10
PaymentDifferenceReason External Reason Code for Payment Differences CHAR3
LockboxFreeText 30 Characters CHAR30