JDBC Driver for Sage Intacct

Build 22.0.8462

ARAdjustment

Retrieves ARAdjustment report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

The Recordno field of the ARAdjustment object.

Recordtype String False

The Recordtype field of the ARAdjustment object.

Recordid String False

The Recordid field of the ARAdjustment object.

State String False

The State field of the ARAdjustment object.

Rawstate String False

The Rawstate field of the ARAdjustment object.

Entity String False

The Entity field of the ARAdjustment object.

Customerid String False

The Customerid field of the ARAdjustment object.

Customername String False

The Customername field of the ARAdjustment object.

Trx_entitydue Double False

The Trx_entitydue field of the ARAdjustment object.

Docnumber String False

The Docnumber field of the ARAdjustment object.

Description String False

The Description field of the ARAdjustment object.

Whencreated Datetime False

The Whencreated field of the ARAdjustment object.

Whenposted Datetime False

The Whenposted field of the ARAdjustment object.

Whenpaid Datetime False

The Whenpaid field of the ARAdjustment object.

Basecurr String False

The Basecurr field of the ARAdjustment object.

Currency String False

The Currency field of the ARAdjustment object.

Exch_rate_date Datetime False

The Exch_rate_date field of the ARAdjustment object.

Exch_rate_type_id String False

The Exch_rate_type_id field of the ARAdjustment object.

Exchange_rate Double False

The Exchange_rate field of the ARAdjustment object.

Totalentered Double False

The Totalentered field of the ARAdjustment object.

Totalselected Double False

The Totalselected field of the ARAdjustment object.

Totalpaid Double False

The Totalpaid field of the ARAdjustment object.

Totaldue String False

The Totaldue field of the ARAdjustment object.

Trx_totalentered Double False

The Trx_totalentered field of the ARAdjustment object.

Trx_totalselected Double False

The Trx_totalselected field of the ARAdjustment object.

Trx_totalpaid Double False

The Trx_totalpaid field of the ARAdjustment object.

Trx_totaldue Double False

The Trx_totaldue field of the ARAdjustment object.

Billtopaytocontactname String False

The Billtopaytocontactname field of the ARAdjustment object.

Shiptoreturntocontactname String False

The Shiptoreturntocontactname field of the ARAdjustment object.

Billtopaytokey Int64 False

The Billtopaytokey field of the ARAdjustment object.

Shiptoreturntokey Int64 False

The Shiptoreturntokey field of the ARAdjustment object.

Shipto_contactname String False

The Shipto_contactname field of the ARAdjustment object.

Shipto_prefix String False

The Shipto_prefix field of the ARAdjustment object.

Shipto_firstname String False

The Shipto_firstname field of the ARAdjustment object.

Shipto_initial String False

The Shipto_initial field of the ARAdjustment object.

Shipto_lastname String False

The Shipto_lastname field of the ARAdjustment object.

Shipto_companyname String False

The Shipto_companyname field of the ARAdjustment object.

Shipto_printas String False

The Shipto_printas field of the ARAdjustment object.

Shipto_phone1 String False

The Shipto_phone1 field of the ARAdjustment object.

Shipto_phone2 String False

The Shipto_phone2 field of the ARAdjustment object.

Shipto_cellphone String False

The Shipto_cellphone field of the ARAdjustment object.

Shipto_pager String False

The Shipto_pager field of the ARAdjustment object.

Shipto_fax String False

The Shipto_fax field of the ARAdjustment object.

Shipto_email1 String False

The Shipto_email1 field of the ARAdjustment object.

Shipto_email2 String False

The Shipto_email2 field of the ARAdjustment object.

Shipto_url1 String False

The Shipto_url1 field of the ARAdjustment object.

Shipto_url2 String False

The Shipto_url2 field of the ARAdjustment object.

Shipto_visible Boolean False

The Shipto_visible field of the ARAdjustment object.

Shipto_mailaddress_recordkey Int64 False

The Shipto_mailaddress_recordkey field of the ARAdjustment object.

Shipto_mailaddress_address1 String False

The Shipto_mailaddress_address1 field of the ARAdjustment object.

Shipto_mailaddress_address2 String False

The Shipto_mailaddress_address2 field of the ARAdjustment object.

Shipto_mailaddress_city String False

The Shipto_mailaddress_city field of the ARAdjustment object.

Shipto_mailaddress_state String False

The Shipto_mailaddress_state field of the ARAdjustment object.

Shipto_mailaddress_zip String False

The Shipto_mailaddress_zip field of the ARAdjustment object.

Shipto_mailaddress_country String False

The Shipto_mailaddress_country field of the ARAdjustment object.

Shipto_mailaddress_countrycode String False

The Shipto_mailaddress_countrycode field of the ARAdjustment object.

Billto_contactname String False

The Billto_contactname field of the ARAdjustment object.

Billto_prefix String False

The Billto_prefix field of the ARAdjustment object.

Billto_firstname String False

The Billto_firstname field of the ARAdjustment object.

Billto_initial String False

The Billto_initial field of the ARAdjustment object.

Billto_lastname String False

The Billto_lastname field of the ARAdjustment object.

Billto_companyname String False

The Billto_companyname field of the ARAdjustment object.

Billto_printas String False

The Billto_printas field of the ARAdjustment object.

Billto_phone1 String False

The Billto_phone1 field of the ARAdjustment object.

Billto_phone2 String False

The Billto_phone2 field of the ARAdjustment object.

Billto_cellphone String False

The Billto_cellphone field of the ARAdjustment object.

Billto_pager String False

The Billto_pager field of the ARAdjustment object.

Billto_fax String False

The Billto_fax field of the ARAdjustment object.

Billto_email1 String False

The Billto_email1 field of the ARAdjustment object.

Billto_email2 String False

The Billto_email2 field of the ARAdjustment object.

Billto_url1 String False

The Billto_url1 field of the ARAdjustment object.

Billto_url2 String False

The Billto_url2 field of the ARAdjustment object.

Billto_visible Boolean False

The Billto_visible field of the ARAdjustment object.

Billto_mailaddress_recordkey Int64 False

The Billto_mailaddress_recordkey field of the ARAdjustment object.

Billto_mailaddress_address1 String False

The Billto_mailaddress_address1 field of the ARAdjustment object.

Billto_mailaddress_address2 String False

The Billto_mailaddress_address2 field of the ARAdjustment object.

Billto_mailaddress_city String False

The Billto_mailaddress_city field of the ARAdjustment object.

Billto_mailaddress_state String False

The Billto_mailaddress_state field of the ARAdjustment object.

Billto_mailaddress_zip String False

The Billto_mailaddress_zip field of the ARAdjustment object.

Billto_mailaddress_country String False

The Billto_mailaddress_country field of the ARAdjustment object.

Billto_mailaddress_countrycode String False

The Billto_mailaddress_countrycode field of the ARAdjustment object.

Prbatch String False

The Prbatch field of the ARAdjustment object.

Prbatchkey Int64 False

The Prbatchkey field of the ARAdjustment object.

Modulekey String False

The Modulekey field of the ARAdjustment object.

Auwhencreated Datetime False

The Auwhencreated field of the ARAdjustment object.

Whenmodified Datetime False

The Whenmodified field of the ARAdjustment object.

Createdby Int64 False

The Createdby field of the ARAdjustment object.

Modifiedby Int64 False

The Modifiedby field of the ARAdjustment object.

Megaentitykey Int64 False

The Megaentitykey field of the ARAdjustment object.

Megaentityid String False

The Megaentityid field of the ARAdjustment object.

Record_url String False

The Record_url field of the ARAdjustment object.

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