JDBC Driver for Sage Intacct

Build 22.0.8462

ARAdjustmentItem

Retrieves ARAdjustmentItem report data.

Columns

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

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