EExpensesItem
Retrieves EExpensesItem report data.
Columns
Name | Type | Description |
Recordno [KEY] | String | The Recordno field of the EExpensesItem object. |
Recordkey | Int64 | The Recordkey field of the EExpensesItem object. |
Accountkey | Int64 | The Accountkey field of the EExpensesItem object. |
Entry_date | Datetime | The Entry_date field of the EExpensesItem object. |
Description | String | The Description field of the EExpensesItem object. |
Description2 | String | The Description2 field of the EExpensesItem object. |
Glaccountno | String | The Glaccountno field of the EExpensesItem object. |
Glaccounttitle | String | The Glaccounttitle field of the EExpensesItem object. |
Amount | Double | The Amount field of the EExpensesItem object. |
Locationid | String | The Locationid field of the EExpensesItem object. |
Locationname | String | The Locationname field of the EExpensesItem object. |
Departmentid | String | The Departmentid field of the EExpensesItem object. |
Departmentname | String | The Departmentname field of the EExpensesItem object. |
Line_no | String | The Line_no field of the EExpensesItem object. |
Accountlabel | String | The Accountlabel field of the EExpensesItem object. |
Totalselected | Double | The Totalselected field of the EExpensesItem object. |
Totalpaid | Double | The Totalpaid field of the EExpensesItem object. |
Trx_amount | Double | The Trx_amount field of the EExpensesItem object. |
Trx_totalselected | Double | The Trx_totalselected field of the EExpensesItem object. |
Trx_totalpaid | Double | The Trx_totalpaid field of the EExpensesItem object. |
Billable | Boolean | The Billable field of the EExpensesItem object. |
Billed | Boolean | The Billed field of the EExpensesItem object. |
State | String | The State field of the EExpensesItem object. |
Form1099 | String | The Form1099 field of the EExpensesItem object. |
Exppmttypekey | Int64 | The Exppmttypekey field of the EExpensesItem object. |
Exppmttype | String | The Exppmttype field of the EExpensesItem object. |
Nonreimbursable | Boolean | The Nonreimbursable field of the EExpensesItem object. |
Nr_amount | Double | The Nr_amount field of the EExpensesItem object. |
Nr_trx_amount | Double | The Nr_trx_amount field of the EExpensesItem object. |
Quantity | Double | The Quantity field of the EExpensesItem object. |
Unitrate | String | The Unitrate field of the EExpensesItem object. |
Createdby | Int64 | The Createdby field of the EExpensesItem object. |
Modifiedby | Int64 | The Modifiedby field of the EExpensesItem object. |
Whencreated | Datetime | The Whencreated field of the EExpensesItem object. |
Whenmodified | Datetime | The Whenmodified field of the EExpensesItem object. |
Recordtype | String | The Recordtype field of the EExpensesItem object. |
Projectdimkey | Int64 | The Projectdimkey field of the EExpensesItem object. |
Projectid | String | The Projectid field of the EExpensesItem object. |
Projectname | String | The Projectname field of the EExpensesItem object. |
Customerdimkey | Int64 | The Customerdimkey field of the EExpensesItem object. |
Customerid | String | The Customerid field of the EExpensesItem object. |
Customername | String | The Customername field of the EExpensesItem object. |
Vendordimkey | Int64 | The Vendordimkey field of the EExpensesItem object. |
Vendorid | String | The Vendorid field of the EExpensesItem object. |
Vendorname | String | The Vendorname field of the EExpensesItem object. |
Itemdimkey | Int64 | The Itemdimkey field of the EExpensesItem object. |
Itemid | String | The Itemid field of the EExpensesItem object. |
Itemname | String | The Itemname field of the EExpensesItem object. |
Classdimkey | Int64 | The Classdimkey field of the EExpensesItem object. |
Classid | String | The Classid field of the EExpensesItem object. |
Classname | String | The Classname field of the EExpensesItem object. |
Record_url | String | The Record_url field of the EExpensesItem object. |