BankFeeEntry
Captures line-level data for bank fees, detailing amounts, allocations, and relevant dimensions.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | A unique identifier for the bank fee entry. |
| Recordkey | Int64 | The key identifying the specific bank fee entry. |
| Recordtype | String | The type of record for the bank fee entry. |
| Accountkey | Int64 | The key identifying the associated account. |
| Accountno | String | The account number associated with the bank fee entry. |
| Accounttitle | String | The title of the account linked to the bank fee entry. |
| Accountlabelkey | Int64 | The key identifying the label of the associated account. |
| Accountlabel | String | The label of the account linked to the bank fee entry. |
| Amount | Double | The amount recorded for the bank fee entry. |
| Trx_amount | Double | The transaction amount for the bank fee entry in its original currency. |
| DeptNUM | Int64 | The department key associated with the bank fee entry. |
| Departmentid | String | The ID of the department linked to the bank fee entry. |
| Departmentname | String | The name of the department linked to the bank fee entry. |
| LocationNUM | Int64 | The location key associated with the bank fee entry. |
| Locationid | String | The ID of the location linked to the bank fee entry. |
| Locationname | String | The name of the location linked to the bank fee entry. |
| Description | String | A description of the bank fee entry. |
| Exch_rate_date | Datetime | The date used for calculating the exchange rate. |
| Exch_rate_type_id | String | The identifier for the exchange rate type applied. |
| Exchange_rate | Double | The exchange rate used for the transaction. |
| Lineitem | String | The line item description for the bank fee entry. |
| Line_no | String | The line number for the bank fee entry. |
| Currency | String | The currency used for the bank fee entry. |
| Basecurr | String | The base currency for the bank fee entry. |
| Baselocation | Int64 | The key identifying the base location for the bank fee entry. |
| Status | String | The current status of the bank fee entry. |
| Whencreated | Datetime | The date and time when the bank fee entry was created. |
| Whenmodified | Datetime | The date and time when the bank fee entry was last modified. |
| Createdby | Int64 | The user or process ID that created the bank fee entry. |
| Modifiedby | Int64 | The user or process ID that last modified the bank fee entry. |
| Departmentkey | Int64 | The key identifying the department linked to the bank fee entry. |
| Locationkey | Int64 | The key identifying the location linked to the bank fee entry. |
| Projectdimkey | Int64 | The key identifying the project dimension associated with the bank fee entry. |
| Projectid | String | The ID of the project associated with the bank fee entry. |
| Projectname | String | The name of the project associated with the bank fee entry. |
| Customerdimkey | Int64 | The key identifying the customer dimension associated with the bank fee entry. |
| Customerid | String | The ID of the customer associated with the bank fee entry. |
| Customername | String | The name of the customer associated with the bank fee entry. |
| Vendordimkey | Int64 | The key identifying the vendor dimension associated with the bank fee entry. |
| Vendorid | String | The ID of the vendor associated with the bank fee entry. |
| Vendorname | String | The name of the vendor associated with the bank fee entry. |
| Employeedimkey | Int64 | The key identifying the employee dimension associated with the bank fee entry. |
| Employeeid | String | The ID of the employee associated with the bank fee entry. |
| Employeename | String | The name of the employee associated with the bank fee entry. |
| Itemdimkey | Int64 | The key identifying the item dimension associated with the bank fee entry. |
| Itemid | String | The ID of the item associated with the bank fee entry. |
| Itemname | String | The name of the item associated with the bank fee entry. |
| Classdimkey | Int64 | The key identifying the class dimension associated with the bank fee entry. |
| Classid | String | The ID of the class associated with the bank fee entry. |
| Classname | String | The name of the class associated with the bank fee entry. |
| Record_url | String | A URL providing direct access to the bank fee entry record. |