DepositEntry
Provides detailed line items for deposits, including accounts, amounts, and transaction metadata.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | The unique identifier for the deposit entry record. |
| Recordkey | Int64 | The key for the deposit entry record. |
| Recordtype | String | The type of deposit entry record. |
| Accountkey | Int64 | The internal key of the associated account. |
| Accountno | String | The account number associated with the deposit entry. |
| Accounttitle | String | The title of the account associated with the deposit entry. |
| Accountlabel | String | The label of the account associated with the deposit entry. |
| Accountlabelkey | Int64 | The internal key of the account label. |
| Amount | Double | The amount for the deposit entry. |
| Trx_amount | Double | The transaction amount for the deposit entry. |
| DeptNUM | Int64 | The department number associated with the deposit entry. |
| Deptkey | Int64 | The internal key of the associated department. |
| Departmentid | String | The ID of the associated department. |
| Departmentname | String | The name of the associated department. |
| LocationNUM | Int64 | The location number associated with the deposit entry. |
| Locationkey | Int64 | The internal key of the associated location. |
| Locationid | String | The ID of the associated location. |
| Locationname | String | The name of the associated location. |
| Description | String | A description of the deposit entry. |
| Exch_rate_date | Datetime | The exchange rate date for the deposit entry. |
| Exch_rate_type_id | Int64 | The ID of the exchange rate type for the deposit entry. |
| Exchange_rate | Double | The exchange rate for the deposit entry. |
| Lineitem | String | The line item associated with the deposit entry. |
| Currency | String | The currency of the deposit entry. |
| Basecurr | String | The base currency of the deposit entry. |
| Baselocation | Int64 | The base location associated with the deposit entry. |
| Status | String | The status of the deposit entry. |
| Whencreated | Datetime | The date and time when the deposit entry was created. |
| Whenmodified | Datetime | The date and time when the deposit entry was last modified. |
| Createdby | Int64 | The ID of the user who created the deposit entry. |
| Modifiedby | Int64 | The ID of the user who last modified the deposit entry. |
| Projectdimkey | Int64 | The internal key of the associated project dimension. |
| Projectid | String | The ID of the associated project. |
| Projectname | String | The name of the associated project. |
| Customerdimkey | Int64 | The internal key of the associated customer dimension. |
| Customerid | String | The ID of the associated customer. |
| Customername | String | The name of the associated customer. |
| Vendordimkey | Int64 | The internal key of the associated vendor dimension. |
| Vendorid | String | The ID of the associated vendor. |
| Vendorname | String | The name of the associated vendor. |
| Employeedimkey | Int64 | The internal key of the associated employee dimension. |
| Employeeid | String | The ID of the associated employee. |
| Employeename | String | The name of the associated employee. |
| Itemdimkey | Int64 | The internal key of the associated item dimension. |
| Itemid | String | The ID of the associated item. |
| Itemname | String | The name of the associated item. |
| Classdimkey | Int64 | The internal key of the associated class dimension. |
| Classid | String | The ID of the associated class. |
| Classname | String | The name of the associated class. |
| Record_url | String | The URL link to the deposit entry record. |