JDBC Driver for Sage Intacct

Build 22.0.8462

APPaymentItem

Retrieves APPaymentItem report data.

Columns

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

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