Tableau Connector for Sage Intacct

Build 21.0.7930

ARInvoiceItem

Retrieves ARInvoiceItem report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the ARInvoiceItem object.
Recordkey Int64 The Recordkey field of the ARInvoiceItem object.
Accountkey Int64 The Accountkey field of the ARInvoiceItem object.
Accountno String The Accountno field of the ARInvoiceItem object.
Offsetglaccountno String The Offsetglaccountno field of the ARInvoiceItem object.
Offsetglaccounttitle String The Offsetglaccounttitle field of the ARInvoiceItem object.
Accounttitle String The Accounttitle field of the ARInvoiceItem object.
Accountlabelkey Int64 The Accountlabelkey field of the ARInvoiceItem object.
Accountlabel String The Accountlabel field of the ARInvoiceItem object.
Entry_date Datetime The Entry_date field of the ARInvoiceItem object.
Amount Double The Amount field of the ARInvoiceItem object.
Trx_amount Double The Trx_amount field of the ARInvoiceItem object.
Departmentid String The Departmentid field of the ARInvoiceItem object.
Departmentname String The Departmentname field of the ARInvoiceItem object.
Locationid String The Locationid field of the ARInvoiceItem object.
Locationname String The Locationname field of the ARInvoiceItem object.
Entrydescription String The Entrydescription field of the ARInvoiceItem object.
Exch_rate_date Datetime The Exch_rate_date field of the ARInvoiceItem object.
Exch_rate_type_id Int64 The Exch_rate_type_id field of the ARInvoiceItem object.
Exchange_rate Double The Exchange_rate field of the ARInvoiceItem object.
Allocationkey Int64 The Allocationkey field of the ARInvoiceItem object.
Allocation String The Allocation field of the ARInvoiceItem object.
Lineitem String The Lineitem field of the ARInvoiceItem object.
Line_no String The Line_no field of the ARInvoiceItem object.
Currency String The Currency field of the ARInvoiceItem object.
Basecurr String The Basecurr field of the ARInvoiceItem object.
Totalpaid Double The Totalpaid field of the ARInvoiceItem object.
Trx_totalpaid Double The Trx_totalpaid field of the ARInvoiceItem object.
Totalselected Double The Totalselected field of the ARInvoiceItem object.
Trx_totalselected Double The Trx_totalselected field of the ARInvoiceItem object.
Subtotal String The Subtotal field of the ARInvoiceItem object.
Parententry Int64 The Parententry field of the ARInvoiceItem object.
Deferrevenue Boolean The Deferrevenue field of the ARInvoiceItem object.
Revrectemplatekey Int64 The Revrectemplatekey field of the ARInvoiceItem object.
Revrectemplate String The Revrectemplate field of the ARInvoiceItem object.
Deferredrevacctkey Int64 The Deferredrevacctkey field of the ARInvoiceItem object.
Deferredrevacctno String The Deferredrevacctno field of the ARInvoiceItem object.
Deferredrevaccttitle String The Deferredrevaccttitle field of the ARInvoiceItem object.
Revrecstartdate Datetime The Revrecstartdate field of the ARInvoiceItem object.
Revrecenddate Datetime The Revrecenddate field of the ARInvoiceItem object.
Baselocation Int64 The Baselocation field of the ARInvoiceItem object.
State String The State field of the ARInvoiceItem object.
Recordtype String The Recordtype field of the ARInvoiceItem object.
Whencreated Datetime The Whencreated field of the ARInvoiceItem object.
Whenmodified Datetime The Whenmodified field of the ARInvoiceItem object.
Createdby Int64 The Createdby field of the ARInvoiceItem object.
Modifiedby Int64 The Modifiedby field of the ARInvoiceItem object.
Projectdimkey Int64 The Projectdimkey field of the ARInvoiceItem object.
Projectid String The Projectid field of the ARInvoiceItem object.
Projectname String The Projectname field of the ARInvoiceItem object.
Customerdimkey Int64 The Customerdimkey field of the ARInvoiceItem object.
Customerid String The Customerid field of the ARInvoiceItem object.
Customername String The Customername field of the ARInvoiceItem object.
Vendordimkey Int64 The Vendordimkey field of the ARInvoiceItem object.
Vendorid String The Vendorid field of the ARInvoiceItem object.
Vendorname String The Vendorname field of the ARInvoiceItem object.
Employeedimkey Int64 The Employeedimkey field of the ARInvoiceItem object.
Employeeid String The Employeeid field of the ARInvoiceItem object.
Employeename String The Employeename field of the ARInvoiceItem object.
Itemdimkey Int64 The Itemdimkey field of the ARInvoiceItem object.
Itemid String The Itemid field of the ARInvoiceItem object.
Itemname String The Itemname field of the ARInvoiceItem object.
Classdimkey Int64 The Classdimkey field of the ARInvoiceItem object.
Classid String The Classid field of the ARInvoiceItem object.
Classname String The Classname field of the ARInvoiceItem object.
Record_url String The Record_url field of the ARInvoiceItem object.

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