Bank Statement Item
API Name: BankStatementItem__c
A bank statement item represents a single money transfer as reported by the bank.
| Label | API Name | Type | Description |
|---|---|---|---|
| Bank Statement Item Name | Name |
AutoNumber | |
| Additional Information | AdditionalInformation__c |
LongTextArea(500) | Additional information as reported by the bank. |
| Amount Indication | AmountCDI__c |
Picklist | Credit or debit indicator for the absolute total amount. Credit: incoming money, Debit: outgoing money. |
| Total Amount | Amount__c |
Currency(13, 5) | The absolute total amount as reported by the bank including charges and interests. |
| Bank Account Name | BankAccountName__c |
Text(255) | The name of the bank account to which this bank statement item relates. |
| Bank Account | BankAccount__c |
Lookup(BankAccount__c) | The bank account to which this bank statement item relates. |
| Bank Statement | BankStatement__c |
Lookup(BankStatement__c) | The bank statement through which this bank statement detail has been retrieved. |
| Bank Transaction Code | BankTransactionCode__c |
Picklist | The bank transaction code indicates the type of business transaction that this bank statement item represents. May be required for further processing. Picklist values: N/A |
| Batch Message Id | BatchMessageId__c |
Text(255) | The unique ID assigned to the batch booking by the sending party. |
| Batch Payment Information | BatchPaymentInformation__c |
Text(255) | The payment information in case of batch booking. |
| Booking Date | BookingDate__c |
Date | The date on which the transaction was registered. For booked transactions, this is the actual booking date. For pending or future transactions, it is the expected booking date. |
| Payment Fault Reason Code | ChargebackReason__c |
Text(255) | The SEPA return reason code for the return registered with this bank statement detail. |
| Creditor IBAN | CreditorIBAN__c |
Text(34) | The International Bank Account Number of the bank account (according to ISO 13616) of the creditor. |
| Creditor Id | CreditorId__c |
Text(255) | The creditor ID in case of SEPA direct debit. |
| Creditor Name | CreditorName__c |
Text(255) | The name of the creditor. |
| Cumulated Charges Indication | CumulatedChargesCDI__c |
Picklist | Credit or debit indicator for cumulated charges. Credit: increase, Debit: decrease. |
| Cumulated Charges | CumulatedCharges__c |
Currency(16, 2) | Charges that are included in the transaction represented by this bank statement item. |
| Cumulated Interests Indication | CumulatedInterestsCDI__c |
Picklist | Credit or debit indicator for cumulated interests. Credit: increase, Debit: decrease. |
| Cumulated Interests | CumulatedInterests__c |
Currency(16, 2) | Interests that are included in the transaction represented by this bank statement item. |
| Debtor IBAN | DebtorIBAN__c |
Text(34) | The International Bank Account Number of the bank account (according to ISO 13616) of the debtor. |
| Debtor Name | DebtorName__c |
Text(255) | The name of the debtor. |
| Effective Amount Indication | EffectiveAmountCDI__c |
Picklist | Credit or debit indicator for the absolute effective amount. Credit: incoming money, Debit: outgoing money. |
| Effective Amount | EffectiveAmount__c |
Currency(13, 5) | The absolute amount without charges and interests. |
| End-to-End Id | EndToEndId__c |
Text(255) | Unique identifier set for SDD and SCT orders to uniquely identify the transaction for downstream payment/entry assignments. |
| From Batch | FromBatch__c |
Checkbox | Indicates whether this transaction is part of a batch booking. |
| Full Reference | FullReference__c |
LongTextArea(131072) | The unabridged remittance information of the original payment transaction. |
| IBAN | IBAN__c |
Text(34) | The International Bank Account Number of the bank account (according to ISO 13616) to which the bank statement item relates. |
| Instructed Amount Currency | InstructedAmountCurrency__c |
Text(3) | The currency ISO code for the instructed amount as ordered by the initiating party. The currency can differ from the reported currency. |
| Instructed Amount | InstructedAmount__c |
Number(16, 2) | The initiated amount of money before charges deduction in the currency as ordered by the initiating party. The currency can differ from the reported currency. |
| Item Id | ItemId__c |
Text(255) | The unique ID for bank statement item record in Salesforce. |
| Mandate Reference | MandateReference__c |
Text(255) | The SEPA mandate reference. |
| Matching Result | MatchingResult__c |
Text | The status of the settlement process of the related payment. “Settled” indicates a successful settlement, other values suggest further investigation. |
| Payment Conversion Date | PaymentConversionDate__c |
DateTime | The date of the automatic settlement that has processed this bank statement item. |
| Payment Conversion | PaymentConversion__c |
Picklist | Indicates the status of the payment or refund creation or association as a result of the automatic settlement. Picklist values: Ignored by Status Code, Filtered, Payment Created |
| Payment | Payment__c |
Lookup(Payment__c) | The payment to which this bank statement item relates. |
| 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 item relates, used as fallback if the IBAN is not available. |
| Proprietary Bank Transaction Code | PropBankTransactionCode__c |
Text(255) | Bank-specific code for the type of the transaction represented by this bank statement item. |
| Raw Entry | RawEntry__c |
LongTextArea(131072) | The raw XML contents of this bank statement item (the Ntry tag of the CAMT.053 message) for debugging purposes. |
| Reference | Reference__c |
Text(255) | The remittance information of the original payment transaction, cut to 255 characters. Find the complete information in the field Full Reference. |
| Refund | Refund__c |
Lookup(Refund__c) | The refund to which this bank statement item relates. |
| Reported Currency | ReportedCurrency__c |
Text(3) | The currency ISO code as reported by the bank. |
| Payment Fault Details | ReturnReason__c |
Text(255) | Additional information on the return of this transaction in a human-readable form. |
| Status Code | StatusCode__c |
Picklist | The status of the original transaction. BOOKed transactions have been completed, PenDiNG or FUTuRe transactions refer to a value date in the future. Picklist values: BOOK, PDNG, INFO |
| Transaction Amount | TransactionAmount__c |
Currency(13, 5) | The amount of money of the underlying bank transaction plus internal charges. External charges are not included. |
| Value Date | ValueDate__c |
Date | The date on which the original transaction is effective so the amount becomes available. For pending and future transactions, the value date is the expected or requested value date. |