FundsTransferEntry
Provides detailed line items for fund transfers, documenting accounts, amounts, and dimensions.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | Unique identifier for the funds transfer entry record. |
| Recordkey | Int64 | Key referencing the specific record within the funds transfer. |
| Recordtype | String | Type of record associated with the funds transfer entry. |
| Accountkey | Int64 | Key identifying the account associated with the funds transfer entry. |
| Accountno | String | Account number associated with the funds transfer entry. |
| Accounttitle | String | Title or name of the account associated with the funds transfer entry. |
| Amount | Double | Amount for the funds transfer entry. |
| Trx_amount | Double | Transaction amount in the original currency for the funds transfer entry. |
| DeptNUM | Int64 | Department number associated with the funds transfer entry. |
| Departmentid | String | Identifier for the department associated with the funds transfer entry. |
| Departmentname | String | Name of the department associated with the funds transfer entry. |
| LocationNUM | Int64 | Location number associated with the funds transfer entry. |
| Locationid | String | Identifier for the location associated with the funds transfer entry. |
| Locationname | String | Name of the location associated with the funds transfer entry. |
| Exch_rate_date | Datetime | Date when the exchange rate was applied for the funds transfer entry. |
| Exch_rate_type_id | String | Identifier for the type of exchange rate applied to the funds transfer entry. |
| Exchange_rate | Double | Exchange rate applied to the funds transfer entry. |
| Lineitem | String | Details of the specific line item in the funds transfer entry. |
| Currency | String | Currency used for the funds transfer entry. |
| Basecurr | String | Base currency used for the funds transfer entry. |
| Status | String | Current status of the funds transfer entry. |
| Totalpaid | Double | Total amount paid for the funds transfer entry. |
| Trx_totalpaid | Double | Total paid amount in the original currency for the funds transfer entry. |
| Whencreated | Datetime | Timestamp when the funds transfer entry was created. |
| Whenmodified | Datetime | Timestamp when the funds transfer entry was last modified. |
| Createdby | Int64 | Identifier of the user who created the funds transfer entry. |
| Modifiedby | Int64 | Identifier of the user who last modified the funds transfer entry. |
| Departmentkey | Int64 | Key referencing the department associated with the funds transfer entry. |
| Locationkey | Int64 | Key referencing the location associated with the funds transfer entry. |
| Projectdimkey | Int64 | Key referencing the project dimension associated with the funds transfer entry. |
| Projectid | String | Identifier for the project associated with the funds transfer entry. |
| Projectname | String | Name of the project associated with the funds transfer entry. |
| Customerdimkey | Int64 | Key referencing the customer dimension associated with the funds transfer entry. |
| Customerid | String | Identifier for the customer associated with the funds transfer entry. |
| Customername | String | Name of the customer associated with the funds transfer entry. |
| Vendordimkey | Int64 | Key referencing the vendor dimension associated with the funds transfer entry. |
| Vendorid | String | Identifier for the vendor associated with the funds transfer entry. |
| Vendorname | String | Name of the vendor associated with the funds transfer entry. |
| Employeedimkey | Int64 | Key referencing the employee dimension associated with the funds transfer entry. |
| Employeeid | String | Identifier for the employee associated with the funds transfer entry. |
| Employeename | String | Name of the employee associated with the funds transfer entry. |
| Itemdimkey | Int64 | Key referencing the item dimension associated with the funds transfer entry. |
| Itemid | String | Identifier for the item associated with the funds transfer entry. |
| Itemname | String | Name of the item associated with the funds transfer entry. |
| Classdimkey | Int64 | Key referencing the class dimension associated with the funds transfer entry. |
| Classid | String | Identifier for the class associated with the funds transfer entry. |
| Classname | String | Name of the class associated with the funds transfer entry. |
| Record_url | String | URL link to the funds transfer entry record in the system. |