JDBC Driver for Sage Intacct

Build 22.0.8462

APAdjustment

Retrieves APAdjustment report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

The Recordno field of the APAdjustment object.

Recordtype String False

The Recordtype field of the APAdjustment object.

Recordid String False

The Recordid field of the APAdjustment object.

State String False

The State field of the APAdjustment object.

Rawstate String False

The Rawstate field of the APAdjustment object.

Entity String False

The Entity field of the APAdjustment object.

Vendorid String False

The Vendorid field of the APAdjustment object.

Vendorname String False

The Vendorname field of the APAdjustment object.

Trx_entitydue Double False

The Trx_entitydue field of the APAdjustment object.

Docnumber String False

The Docnumber field of the APAdjustment object.

Description String False

The Description field of the APAdjustment object.

Whencreated Datetime False

The Whencreated field of the APAdjustment object.

Whenposted Datetime False

The Whenposted field of the APAdjustment object.

Whenpaid Datetime False

The Whenpaid field of the APAdjustment object.

Basecurr String False

The Basecurr field of the APAdjustment object.

Currency String False

The Currency field of the APAdjustment object.

Exch_rate_date Datetime False

The Exch_rate_date field of the APAdjustment object.

Exch_rate_type_id Int64 False

The Exch_rate_type_id field of the APAdjustment object.

Exchange_rate Double False

The Exchange_rate field of the APAdjustment object.

Totalentered Double False

The Totalentered field of the APAdjustment object.

Totalselected Double False

The Totalselected field of the APAdjustment object.

Totalpaid Double False

The Totalpaid field of the APAdjustment object.

Totaldue Double False

The Totaldue field of the APAdjustment object.

Trx_totalentered Double False

The Trx_totalentered field of the APAdjustment object.

Trx_totalselected Double False

The Trx_totalselected field of the APAdjustment object.

Trx_totalpaid Double False

The Trx_totalpaid field of the APAdjustment object.

Trx_totaldue Double False

The Trx_totaldue field of the APAdjustment object.

Billtopaytocontactname String False

The Billtopaytocontactname field of the APAdjustment object.

Shiptoreturntocontactname String False

The Shiptoreturntocontactname field of the APAdjustment object.

Billtopaytokey Int64 False

The Billtopaytokey field of the APAdjustment object.

Shiptoreturntokey Int64 False

The Shiptoreturntokey field of the APAdjustment object.

Prbatch String False

The Prbatch field of the APAdjustment object.

Prbatchkey Int64 False

The Prbatchkey field of the APAdjustment object.

Prbatch_open String False

The Prbatch_open field of the APAdjustment object.

Prbatch_nogl Boolean False

The Prbatch_nogl field of the APAdjustment object.

Modulekey String False

The Modulekey field of the APAdjustment object.

Auwhencreated Datetime False

The Auwhencreated field of the APAdjustment object.

Whenmodified Datetime False

The Whenmodified field of the APAdjustment object.

Createdby Int64 False

The Createdby field of the APAdjustment object.

Modifiedby Int64 False

The Modifiedby field of the APAdjustment object.

Megaentitykey Int64 False

The Megaentitykey field of the APAdjustment object.

Megaentityid String False

The Megaentityid field of the APAdjustment object.

Record_url String False

The Record_url field of the APAdjustment object.

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