FinancialAccountTransaction
Represents transactions related to a financial account. There can be various types of transactions such as credit, debit, and so forth. Provided in the Financial Services Cloud Data Kit. This DMO is available in API version 58 and later.
Columns
| Name | Type | References | Description |
| Acquiring Bank Name | Varchar | The acquiring bank name. | |
| Authorization Record Text | Varchar | The transaction authorization code (if credit or debit). | |
| Card Scheme Name | Varchar | The card name. | |
| Cash Flow Type | Varchar | The direction of the transaction from the perspective of the account holder: inflow or outflow. | |
| Currency | Varchar | The associated currency. | |
| Description | Varchar | The financial account transaction description. | |
| Financial Account ID | Varchar | The associated financial account. | |
| FinancialAccountTransactionType__c | Varchar | The transaction type. | |
| ForexConversionChargeAmount__c | Double | The amount of charge within the transaction relating to Forex conversion. | |
| Financial Transaction ID | Varchar | The primary key. | |
| Issuing Bank Name | Varchar | The credit or debit card issuing bank name. | |
| Merchant Category Code | Varchar | The merchant identifier. | |
| Merchant Name | Varchar | The merchant accepting payment of debit or credit card. | |
| Name | Varchar | The financial account transaction name. | |
| Running Balance Amount | Double | The running balance of the transaction. | |
| Secret Key Identifier | Varchar | The secret identifier if the transaction is from open banking. | |
| Source System Identifier | Varchar | The external data source record ID. | |
| Source Transaction Identifier | Varchar | The external data source unique identifier. | |
| Source Transaction Type Code | Varchar | The external data source transaction type. | |
| Target Account Identifier | Varchar | The payment target account unique identifier. | |
| Transaction Amount | Double | The transaction amount. | |
| Transaction Date | Varchar | The transaction date. | |
| Transaction Location Name | Varchar | The transaction location name. | |
| Transaction Posted Date | Varchar | The transaction posted date. |