Tableau Connector for Sage Intacct

Build 21.0.7930

ARPaymentItem

Retrieves ARPaymentItem report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the ARPaymentItem object.
Recordtype String The Recordtype field of the ARPaymentItem object.
Entry_date Datetime The Entry_date field of the ARPaymentItem object.
Recordkey Int64 The Recordkey field of the ARPaymentItem object.
Vendoracctnokeyversion Int64 The Vendoracctnokeyversion field of the ARPaymentItem object.
Entrydescription String The Entrydescription field of the ARPaymentItem object.
Accountkey Int64 The Accountkey field of the ARPaymentItem object.
Glaccountno String The Glaccountno field of the ARPaymentItem object.
Glaccounttitle String The Glaccounttitle field of the ARPaymentItem object.
Amount Double The Amount field of the ARPaymentItem object.
Locationid String The Locationid field of the ARPaymentItem object.
Locationname String The Locationname field of the ARPaymentItem object.
Departmentid String The Departmentid field of the ARPaymentItem object.
Departmentname String The Departmentname field of the ARPaymentItem object.
Line_no String The Line_no field of the ARPaymentItem object.
Form1099 String The Form1099 field of the ARPaymentItem object.
Accountlabel String The Accountlabel field of the ARPaymentItem object.
Totalselected Double The Totalselected field of the ARPaymentItem object.
Totalpaid Double The Totalpaid field of the ARPaymentItem object.
Parententry Int64 The Parententry field of the ARPaymentItem object.
Lineitem String The Lineitem field of the ARPaymentItem object.
Gloffset Int64 The Gloffset field of the ARPaymentItem object.
Baselocation Int64 The Baselocation field of the ARPaymentItem object.
Allocationkey Int64 The Allocationkey field of the ARPaymentItem object.
Allocation String The Allocation field of the ARPaymentItem object.
Subtotal String The Subtotal field of the ARPaymentItem object.
Deferrevenue Boolean The Deferrevenue field of the ARPaymentItem object.
Revrectemplatekey Int64 The Revrectemplatekey field of the ARPaymentItem object.
Revrectemplate String The Revrectemplate field of the ARPaymentItem object.
Deferredrevacctkey Int64 The Deferredrevacctkey field of the ARPaymentItem object.
Deferredrevacctno String The Deferredrevacctno field of the ARPaymentItem object.
Deferredrevaccttitle String The Deferredrevaccttitle field of the ARPaymentItem object.
Revrecstartdate Datetime The Revrecstartdate field of the ARPaymentItem object.
Revrecenddate Datetime The Revrecenddate field of the ARPaymentItem object.
Entrycurrency String The Entrycurrency field of the ARPaymentItem object.
Entryexchratedate Datetime The Entryexchratedate field of the ARPaymentItem object.
Entryexchratetype Int64 The Entryexchratetype field of the ARPaymentItem object.
Entryexchrate Double The Entryexchrate field of the ARPaymentItem object.
Trx_amount Double The Trx_amount field of the ARPaymentItem object.
Trx_totalselected Double The Trx_totalselected field of the ARPaymentItem object.
Trx_totalpaid Double The Trx_totalpaid field of the ARPaymentItem object.
Billable Boolean The Billable field of the ARPaymentItem object.
Billed Boolean The Billed field of the ARPaymentItem object.
State String The State field of the ARPaymentItem object.
Releasetopay Boolean The Releasetopay field of the ARPaymentItem object.
Whencreated Datetime The Whencreated field of the ARPaymentItem object.
Whenmodified Datetime The Whenmodified field of the ARPaymentItem object.
Createdby Int64 The Createdby field of the ARPaymentItem object.
Modifiedby Int64 The Modifiedby field of the ARPaymentItem object.
Locationkey Int64 The Locationkey field of the ARPaymentItem object.
Departmentkey Int64 The Departmentkey field of the ARPaymentItem object.
Currency String The Currency field of the ARPaymentItem object.
Accountno String The Accountno field of the ARPaymentItem object.
Accounttitle String The Accounttitle field of the ARPaymentItem object.
Exch_rate_date Datetime The Exch_rate_date field of the ARPaymentItem object.
Exch_rate_type_id Int64 The Exch_rate_type_id field of the ARPaymentItem object.
Exchange_rate Double The Exchange_rate field of the ARPaymentItem object.
Projectdimkey Int64 The Projectdimkey field of the ARPaymentItem object.
Projectid String The Projectid field of the ARPaymentItem object.
Projectname String The Projectname field of the ARPaymentItem object.
Vendordimkey Int64 The Vendordimkey field of the ARPaymentItem object.
Vendorid String The Vendorid field of the ARPaymentItem object.
Vendorname String The Vendorname field of the ARPaymentItem object.
Employeedimkey Int64 The Employeedimkey field of the ARPaymentItem object.
Employeeid String The Employeeid field of the ARPaymentItem object.
Employeename String The Employeename field of the ARPaymentItem object.
Itemdimkey Int64 The Itemdimkey field of the ARPaymentItem object.
Itemid String The Itemid field of the ARPaymentItem object.
Itemname String The Itemname field of the ARPaymentItem object.
Record_url String The Record_url field of the ARPaymentItem object.

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