JDBC Driver for Sage Intacct

Build 22.0.8462

APAdjustmentItem

Retrieves APAdjustmentItem report data.

Columns

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

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