CData Python Connector for Sage Intacct

Build 25.0.9454

APAdjustment

Tracks accounts payable adjustments, including vendor interactions and changes to payment statuses.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

A unique identifier for the accounts payable adjustment record.

Recordtype String False

The type of record associated with the accounts payable adjustment.

Recordid String False

The unique identifier for the specific record type associated with the adjustment.

State String False

The current state or status of the accounts payable adjustment.

Rawstate String False

The raw state data associated with the accounts payable adjustment.

Entity String False

The entity associated with the accounts payable adjustment.

Vendorid String False

The vendor identifier linked to the accounts payable adjustment.

Vendorname String False

The name of the vendor linked to the accounts payable adjustment.

Trx_entitydue Double False

The amount due from the entity associated with the adjustment.

Docnumber String False

The document number associated with the accounts payable adjustment.

Description String False

A brief description of the accounts payable adjustment.

Whencreated Datetime False

The timestamp indicating when the accounts payable adjustment was created.

Whenposted Datetime False

The timestamp indicating when the accounts payable adjustment was posted.

Whenpaid Datetime False

The timestamp indicating when the accounts payable adjustment was paid.

Basecurr String False

The base currency used for the accounts payable adjustment.

Currency String False

The currency in which the accounts payable adjustment was made.

Exch_rate_date Datetime False

The date used for determining the exchange rate for the adjustment.

Exch_rate_type_id Int64 False

The identifier for the exchange rate type applied to the adjustment.

Exchange_rate Double False

The exchange rate applied to the accounts payable adjustment.

Totalentered Double False

The total amount entered for the accounts payable adjustment.

Totalselected Double False

The total amount selected for the accounts payable adjustment.

Totalpaid Double False

The total amount paid for the accounts payable adjustment.

Totaldue Double False

The total amount due for the accounts payable adjustment.

Trx_totalentered Double False

The total transaction amount entered for the adjustment.

Trx_totalselected Double False

The total transaction amount selected for the adjustment.

Trx_totalpaid Double False

The total transaction amount paid for the adjustment.

Trx_totaldue Double False

The total transaction amount due for the adjustment.

Billtopaytocontactname String False

The contact name for billing related to the accounts payable adjustment.

Shiptoreturntocontactname String False

The contact name for shipping or returns related to the accounts payable adjustment.

Billtopaytokey Int64 False

The unique key identifying the billing contact for the adjustment.

Shiptoreturntokey Int64 False

The unique key identifying the shipping/return contact for the adjustment.

Prbatch String False

The identifier for the batch associated with the adjustment.

Prbatchkey Int64 False

The unique key for the batch associated with the adjustment.

Prbatch_open String False

Indicates whether the batch associated with the adjustment is open.

Prbatch_nogl Boolean False

Indicates whether the batch adjustment affects the general ledger.

Modulekey String False

The key representing the module associated with the adjustment.

Auwhencreated Datetime False

The timestamp indicating when the adjustment was audited.

Whenmodified Datetime False

The timestamp indicating when the adjustment was last modified.

Createdby Int64 False

The identifier of the user or process that created the adjustment.

Modifiedby Int64 False

The identifier of the user or process that last modified the adjustment.

Megaentitykey Int64 False

The unique key representing the associated mega entity.

Megaentityid String False

The identifier for the associated mega entity.

Record_url String False

The URL linking to the detailed record of the accounts payable adjustment.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454