CashExternalTransactions
CashExternalTransactions
Columns
| Name | Type | Description |
| AccountingFlag | Bool | The option that indicates whether the accounting event is raised when the external transaction is reconciled. |
| Amount | String | The transaction amount of the external transaction. |
| ClearedDate | Date | The date when the external transaction is cleared. |
| CreatedBy | String | The user who created the external transaction. |
| CreationDate | Datetime | The date and time when the external transaction was created. |
| CurrencyCode | String | The currency code of the external transaction. |
| Description | String | The description of the external transaction. |
| ExternalTransactionId [KEY] | String | The unique identifier of the external transaction. |
| LastUpdateDate | Datetime | The date and time when the external transaction was last updated. |
| LastUpdateLogin | String | The session login associated with the user who last updated the external transaction. |
| LastUpdatedBy | String | The user who last updated the external transaction. |
| ReferenceText | String | The reconciliation reference of the external transaction. |
| Source | String | The source of the external transaction. The default value is Imported. |
| Status | String | The status of the external transaction. The default value is UNR for Unreconciled. Unreconciled external transactions can be rendered as void by updating this attribute to VOID. |
| TransactionDate | Date | The date when the external transaction is created. |
| TransactionId | String | The sequence number transaction identifier of the external transaction. |
| TransactionType | String | The transaction type of the external transaction. Examples include Bank adjustment, Fee, Check, Electronic funds transfer, Interest, Zero balancing, Lockbox, Miscellaneous, and Automated clearing house. A list of accepted values is defined in the lookup type CE_TRX_TYPE. |
| ValueDate | Date | The actual value date of the external transaction. |
| AssetAccountCombination | String | The cash general ledger account code combination of the external transaction. |
| OffsetAccountCombination | String | The offset general ledger account code combination of the external transaction. |
| BusinessUnitName | String | The name of the business unit associated to the external transaction. |
| LegalEntityName | String | The name of the legal entity associated to the external transaction. |
| BankAccountName | String | The name of the bank account associated to the external transaction. |
| BankConversionRate | String | The accounting conversion rate used to convert the external transaction amount from the bank account currency to the ledger currency. |
| BankConversionRateType | String | The accounting conversion rate type used to convert the external transaction amount from the bank account currency to the ledger currency. |
| TransferId | String | The unique identifier of the bank account transfer or the ad hoc payment that created the external transaction. |
| AccntServicerReference | String | The reference number assigned by the account servicing institution for the underlying payment, receipt, external transaction, or payroll payment. |
| AddendaTxt | String | Additional information about the entry details. |
| CheckNumber | String | The check number of the underlying transaction. |
| ClearingSystemReference | String | The unique identifier assigned by the clearing system to a payment instruction. |
| CustomerReference | String | The customer reference used by BAI format. |
| EndToEndId | String | The unique identification assigned by the initiating party to the transaction. It is passed on unchanged throughout the entire end to end chain. |
| InstructionIdentification | String | The unique identification which is a point to point reference used between the instructing party and the instructed party to refer to an individual instruction. It is assigned by the instructing party to the instructed party and can be included in several messages related to the instruction. |
| ReconReference | String | The reference to the underlying transaction information. |
| StructuredPaymentReference | String | The structured payment reference or receipt reference on the bank statement line. |
| BankTransactionId | String | Unique identifier of the bank transaction on the statement line. |