Tableau Connector for Sage Intacct

Build 21.0.7930

EPPaymentItem

Retrieves EPPaymentItem report data.

Columns

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

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