EExpensesItem
Provides line-level details for employee expense items, documenting allocations and related projects.
Columns
| Name | Type | Description |
| Recordno [KEY] | String | The unique identifier for the employee expense item record. |
| Recordkey | Int64 | The internal key for the employee expense item record. |
| Accountkey | Int64 | The internal key of the associated account. |
| Entry_date | Datetime | The date of the expense entry. |
| Description | String | A description of the expense item. |
| Description2 | String | An additional description of the expense item. |
| Glaccountno | String | The general ledger account number associated with the expense item. |
| Glaccounttitle | String | The title of the general ledger account associated with the expense item. |
| Amount | Double | The amount of the expense item. |
| Locationid | String | The ID of the location associated with the expense item. |
| Locationname | String | The name of the location associated with the expense item. |
| Departmentid | String | The ID of the department associated with the expense item. |
| Departmentname | String | The name of the department associated with the expense item. |
| Line_no | String | The line number of the expense item record. |
| Accountlabel | String | The label of the account associated with the expense item. |
| Totalselected | Double | The total amount selected for the expense item. |
| Totalpaid | Double | The total amount paid for the expense item. |
| Trx_amount | Double | The transaction amount for the expense item. |
| Trx_totalselected | Double | The transaction total selected for the expense item. |
| Trx_totalpaid | Double | The transaction total paid for the expense item. |
| Billable | Boolean | Indicates if the expense item is billable. |
| Billed | Boolean | Indicates if the expense item has been billed. |
| State | String | The state of the expense item. |
| Form1099 | String | Indicates if the expense item is subject to Form 1099 reporting. |
| Exppmttypekey | Int64 | The key of the expense payment type associated with the expense item. |
| Exppmttype | String | The type of expense payment associated with the expense item. |
| Nonreimbursable | Boolean | Indicates if the expense item is non-reimbursable. |
| Nr_amount | Double | The non-reporting currency amount for the expense item. |
| Nr_trx_amount | Double | The non-reporting transaction amount for the expense item. |
| Quantity | Double | The quantity associated with the expense item. |
| Unitrate | String | The unit rate associated with the expense item. |
| Createdby | Int64 | The ID of the user who created the expense item record. |
| Modifiedby | Int64 | The ID of the user who last modified the expense item record. |
| Whencreated | Datetime | The date and time when the expense item record was created. |
| Whenmodified | Datetime | The date and time when the expense item record was last modified. |
| Recordtype | String | The type of record associated with the expense item. |
| Projectdimkey | Int64 | The internal key of the project dimension associated with the expense item. |
| Projectid | String | The ID of the project associated with the expense item. |
| Projectname | String | The name of the project associated with the expense item. |
| Customerdimkey | Int64 | The internal key of the customer dimension associated with the expense item. |
| Customerid | String | The ID of the customer associated with the expense item. |
| Customername | String | The name of the customer associated with the expense item. |
| Vendordimkey | Int64 | The internal key of the vendor dimension associated with the expense item. |
| Vendorid | String | The ID of the vendor associated with the expense item. |
| Vendorname | String | The name of the vendor associated with the expense item. |
| Itemdimkey | Int64 | The internal key of the item dimension associated with the expense item. |
| Itemid | String | The ID of the item associated with the expense item. |
| Itemname | String | The name of the item associated with the expense item. |
| Classdimkey | Int64 | The internal key of the class dimension associated with the expense item. |
| Classid | String | The ID of the class associated with the expense item. |
| Classname | String | The name of the class associated with the expense item. |
| Record_url | String | The URL link to the expense item record. |