FundsTransfer
Tracks fund transfers between accounts, including amounts, currencies, and transaction statuses.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the funds transfer record. |
| Recordtype | String | Type of record associated with the funds transfer. |
| Whencreated | Datetime | Timestamp when the funds transfer record was created. |
| Fromaccountid | String | Identifier for the account from which funds are transferred. |
| Toaccountid | String | Identifier for the account to which funds are transferred. |
| Fromaccountname | String | Name of the account from which funds are transferred. |
| Toaccountname | String | Name of the account to which funds are transferred. |
| Fromglaccountno | String | General ledger account number for the source account. |
| Toglaccountno | String | General ledger account number for the destination account. |
| Fromaccountcurr | String | Currency of the source account. |
| Toaccountcurr | String | Currency of the destination account. |
| Recordid | String | Identifier for the funds transfer within the system. |
| Description | String | Description or notes for the funds transfer. |
| Totalentered | Double | Total amount entered for the funds transfer. |
| Trx_totalentered | Double | Transaction amount entered for the funds transfer in its original currency. |
| Basecurr | String | Base currency used for the funds transfer. |
| Currency | String | Currency used for the funds transfer. |
| Exch_rate_date | Datetime | Date when the exchange rate was applied for the funds transfer. |
| Exch_rate_type_id | String | Identifier for the type of exchange rate applied. |
| Exchange_rate | Double | Exchange rate applied to the funds transfer. |
| Recon_date | Datetime | Reconciliation date for the funds transfer. |
| Reversalkey | Int64 | Key referencing the reversal associated with the funds transfer. |
| Reversaldate | String | Date when the funds transfer was reversed. |
| Reversedkey | Int64 | Key referencing the funds transfer that was reversed. |
| Reverseddate | String | Date when the reversed funds transfer was recorded. |
| State | String | Current state or status of the funds transfer. |
| Rawstate | String | Raw state of the funds transfer, providing detailed status information. |
| Cleared | String | Indicates whether the funds transfer has been cleared. |
| Auwhencreated | Datetime | Audit timestamp when the funds transfer record was created. |
| Whenmodified | Datetime | Timestamp when the funds transfer record was last modified. |
| Createdby | Int64 | Identifier of the user who created the funds transfer record. |
| Modifiedby | Int64 | Identifier of the user who last modified the funds transfer record. |
| Megaentitykey | Int64 | Key referencing the mega-entity associated with the funds transfer. |
| Megaentityid | String | Identifier of the mega-entity associated with the funds transfer. |
| Megaentityname | String | URL link to the funds transfer record in the system. |