JDBC Driver for Sage Intacct

Build 20.0.7654

APBillItem

Retrieves APBillItem report data.

Columns

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654