Bank Statement
API Name: BankStatement__c
A bank statement holds summarized data for a particular bank account at a specific date.
| Label | API Name | Type | Description |
|---|---|---|---|
| Bank Statement Name | Name |
Text | |
| BIC | BIC__c |
Text(11) | The Business Identifier Code of the bank (according to ISO 9362) that holds the bank account to which this bank statement relates. |
| Bank Account Name | BankAccountName__c |
Text(255) | The name of the bank account to which this bank statement relates. |
| Bank Account Owner | BankAccountOwner__c |
Text(255) | The name of the bank account owner as reported by the bank. |
| Bank Account | BankAccount__c |
Lookup(BankAccount__c) | The bank account to which this bank statement relates. |
| Closing Available Balance Indication | ClosingAvailableBalanceCDI__c |
Picklist | The indication for the closing available balance. Credit: the account is funded, Debit: the account is not covered |
| Closing Available Balance Amount | ClosingAvailableBalance__c |
Currency(13, 5) | The (absolute) closing balance of the amount of money that is at the disposal of the account owner on the specified date (CLAV). |
| Closing Balance Indication | ClosingBalanceCDI__c |
Picklist | The indication for the closing balance. Credit: the account is funded, Debit: the account is in not covered |
| Closing Balance Amount | ClosingBalance__c |
Currency(13, 5) | The booked (absolute) balance of the account at the end of reporting period (CLBD), the sum of the opening balance and all transactions in the reporting period. |
| Date | Date__c |
Text | The date range of the reporting period of this bank statement for display purposes. Bank statements for a single day only show one date instead of a range. |
| From Date | FromDate__c |
Date | The starting date of the reporting period of this bank statement. |
| IBAN | IBAN__c |
Text(34) | The International Bank Account Number of the bank account (according to ISO 13616) to which this bank statement relates. |
| Job Id | JobId__c |
Text(255) | The internal ID of the bank data retrieval job. |
| Last Closing Balance Indication | LastClosingBalanceCDI__c |
Picklist | The indication for the last closing balance. Credit: the account is funded, Debit: the account is not covered |
| Last Closing Balance Amount | LastClosingBalance__c |
Currency(13, 5) | The (absolute) closing balance booked for the previous reporting period (PRCD). The opening balance of the current reporting period always equals this balance. |
| Opening Available Balance Indication | OpeningAvailableBalanceCDI__c |
Picklist | The indication for the opening available balance. Credit: the account is funded, Debit: the account is not covered |
| Opening Available Balance Amount | OpeningAvailableBalance__c |
Currency(13, 5) | The (absolute) opening balance of amount of money that is at the disposal of the account owner on the specified date (OPAV). |
| Opening Balance Indication | OpeningBalanceCDI__c |
Picklist | The indication for the opening balance. |
| Opening Balance Amount | OpeningBalance__c |
Currency(13, 5) | The booked (absolute) balance of the account at the beginning of reporting period (OPBD), always equals the closing balance of the previous reporting period. |
| Proprietary Bank Account Identifier | PropBankAccountIdentifier__c |
Text(34) | The proprietary bank account identifier provided by the bank for the bank account to which this bank statement relates, used as fallback if the IBAN is not available. |
| Raw Statement | RawStatement__c |
LongTextArea(131072) | The raw XML contents of this bank statement (the Stmt tag of the CAMT.053 message) for debugging purposes. |
| Reported Currency | ReportedCurrency__c |
Text(3) | The currency ISO code as reported by the bank. |
| Sequence Number | SequenceNumber__c |
Text(255) | A unique, consecutive number provided by the bank. It can be used to identify data retrieval gaps that may indicate missing account statements and account statement items. |
| Closing Available Balance | SignedClosingAvailableBalance__c |
Currency(16, 2) | The (signed) closing balance of the amount of money that is at the disposal of the account owner on the specified date (CLAV). |
| Closing Balance | SignedClosingBalance__c |
Currency(16, 2) | The booked (signed) balance of the account at the end of reporting period (CLBD), the sum of the opening balance and all transactions in the reporting period. |
| Last Closing Balance | SignedLastClosingBalance__c |
Currency(16, 2) | The (signed) closing balance booked for the previous reporting period (PRCD). The opening balance of the current reporting period always equals this balance. |
| Opening Available Balance | SignedOpeningAvailableBalance__c |
Currency(16, 2) | The (signed) opening balance of amount of money that is at the disposal of the account owner on the specified date (OPAV). |
| Opening Balance | SignedOpeningBalance__c |
Currency(16, 2) | The booked (signed) balance of the account at the beginning of reporting period (OPBD), always equals the closing balance of the previous reporting period. |
| Statement Id | StatementId__c |
Text(255) | The unique ID for bank statement record in Salesforce. |
| To Date | ToDate__c |
Date | The starting date of the reporting period of this bank statement. |