Tableau Connector for Sage Intacct

Build 21.0.7930

ExpenseAdjustmentsItem

Retrieves ExpenseAdjustmentsItem report data.

Columns

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

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930