JDBC Driver for Sage Intacct

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462