Lockbox Data Dictionary

ReceiptLineItem__c

Label: AR Cash Transaction Line Item

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
AccountReference__c Account Reference Pre Summer 2019 Text(32)
Account__c Account Pre Summer 2019 Looks up to: Account

Lookup
Amount__c Amount Pre Summer 2019 Number(18,2)
AvailableAmount__c Available Amount Pre Summer 2019 Number(18,2)
AvailableDiscountAmount__c Available Discount Amount Pre Summer 2019 Number(18,2)
AvailableWriteOffAmount__c Available Write-Off Amount Pre Summer 2019 Number(18,2)
BankChargesAmount__c Bank Charges Amount Pre Summer 2019 Number(18,2)
CSVLineNumber__c CSV Line Number Pre Summer 2019 Number(6,0)
CashEntryLineItem__c Cash Entry Line Item Pre Summer 2019 Looks up to: c2g__codaCashEntryLineItem__c

Lookup
CashEntry__c Cash Entry Pre Summer 2019 Looks up to: c2g__codaCashEntry__c

Lookup
CreditDate__c Deposit Date Pre Summer 2019 Date
DiscountAmount__c Discount Amount Pre Summer 2019 Number(18,2)
DocumentAmount__c Document Amount Pre Summer 2019 Number(18,2)
DocumentNumberBD__c Document Number (BD) Summer 2019 Looks up to: fferpcore__BillingDocument__c

Lookup
DocumentNumberCRN__c Document Number (CRN) Pre Summer 2019 Looks up to: c2g__codaCreditNote__c

Lookup
DocumentNumberSIN__c Document Number (SIN) Pre Summer 2019 Looks up to: c2g__codaInvoice__c

Lookup
DocumentReference__c Document Reference Pre Summer 2019 Text(32)
DocumentType__c Document Type Pre Summer 2019 Formula:
IF(CONTAINS(DocumentReference__c, 'SIN'), 'Invoice', IF(CONTAINS(DocumentReference__c, 'SCR'), 'Credit Note', IF(CONTAINS(DocumentReference__c, 'BD'), IF(Amount__c >= 0, 'BDReceipt', 'BDRefund'), IF(Amount__c >= 0, 'Receipt', 'Refund'))))
Text
HasReference__c Has Reference Pre Summer 2019 Checkbox true
LockboxNumber__c Bank Lockbox Number Pre Summer 2019 Text(18)
Receipt__c AR Cash Transaction Pre Summer 2019 Looks up to: Receipt__c
MasterDetail
Reference__c Check Number Pre Summer 2019 Text(32)
Remitter__c Remitter Pre Summer 2019 Text(80)
Status__c Status Pre Summer 2019 Picklist:
Cash Entry Error
Cash Matching Error
Complete
Error
Imported
In Progress
Matched
Part Matched
TransactionLineItem__c Transaction Line Item Pre Summer 2019 Looks up to: c2g__codaTransactionLineItem__c

Lookup
Type__c Type Pre Summer 2019 Text(32)
WriteOffAmount__c Write-Off Amount Pre Summer 2019 Number(18,2)


© Copyright 2009–2025 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.