Accounting Data Dictionary

codaBankReconciliation__c

Label: Bank Reconciliation

Stores the master details of a bank reconciliation.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
BankAccountCurrency__c Bank Account Currency Pre-Spring 2018 Formula:
BankAccount__r.BankAccountCurrency__r.Name
Text
BankAccountNumber__c Bank Account Number Pre-Spring 2018 Formula:
BankAccount__r.AccountNumber__c
Text
BankAccount__c Bank Account Pre-Spring 2018 Looks up to: codaBankAccount__c
Lookup
BankChargesAndInterest__c Bank Charges and Interest Pre-Spring 2018 Formula:
InterestReceived__c + InterestPaid__c + BankCharges__c
Number(18,2)
BankCharges__c Bank Charges Pre-Spring 2018 Summary
ClearedBalance__c Cleared Balance Pre-Spring 2018 Formula:
OpeningBalance__c + TotalReconciled__c
Number(18,2)
ClosingBalance__c Closing Balance Pre-Spring 2018 Number(18,2)
Difference__c Difference Pre-Spring 2018 Formula:
ClosingBalance__c - ClearedBalance__c
Number(18,2)
ErrorMessage__c Error Message Summer 2022 Used to store the description of the error that occurred in the reconciliation queue.

TextArea
InterestPaid__c Interest Paid Pre-Spring 2018 Summary
InterestReceived__c Interest Received Pre-Spring 2018 Summary
OpeningBalance__c Opening Balance Pre-Spring 2018 Formula:
PreviousReconciliation__r.ClosingBalance__c
Number(18,2)
OwnerCompany__c Company Pre-Spring 2018 Looks up to: codaCompany__c
Lookup
PreviousReconciliation__c Previous Reconciliation Pre-Spring 2018 Looks up to: codaBankReconciliation__c
Lookup
ReconciledItems__c Reconciled Items Pre-Spring 2018 Summary
ReconciliationStatus__c Reconciliation Status Pre-Spring 2018 Picklist:
Committing
Complete
Error
In Progress
Reconciling
StatementDate__c Statement Date Pre-Spring 2018 Date true
TotalReconciled__c Total Reconciled Pre-Spring 2018 Formula:
ReconciledItems__c + BankChargesAndInterest__c
Number(18,2)
TotalRunningProcesses__c Total Running Processes Winter 2023 Number(18,0) 0
UnitOfWork__c Unit of Work Pre-Spring 2018 Number(18,0)


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