Power BI Connector for Sage Intacct

Build 25.0.9454

ARAdjustment

Manages AR adjustment records, allowing for retrieval and modification of details related to adjustments in the Accounts Receivable module.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

Unique identifier for the AR adjustment record.

Recordtype String False

The type of record associated with the adjustment (for example, Credit, Debit).

Recordid String False

Unique ID for the adjustment record within the system.

State String False

The current state of the AR adjustment (for example, Open, Closed).

Rawstate String False

The raw state of the adjustment, used for internal processing.

Entity String False

Entity associated with this AR adjustment.

Customerid String False

The customer ID associated with this adjustment.

Customername String False

The name of the customer linked to this adjustment.

Trx_entitydue Double False

Transaction amount due for the entity related to this adjustment.

Docnumber String False

Document number for tracking the adjustment.

Description String False

A description or note regarding the AR adjustment.

Whencreated Datetime False

Date and time when the adjustment was created.

Whenposted Datetime False

Date and time when the adjustment was posted.

Whenpaid Datetime False

Date and time when the adjustment was paid.

Basecurr String False

The base currency of the adjustment.

Currency String False

The currency in which the adjustment is denominated.

Exch_rate_date Datetime False

Date for the applicable exchange rate.

Exch_rate_type_id String False

Identifier for the exchange rate type applied.

Exchange_rate Double False

Exchange rate applied to the adjustment.

Totalentered Double False

Total amount entered for the adjustment.

Totalselected Double False

Total selected amount for the adjustment.

Totalpaid Double False

Total amount paid towards this adjustment.

Totaldue String False

Total amount still due for the adjustment.

Trx_totalentered Double False

Transaction total amount entered for the adjustment.

Trx_totalselected Double False

Transaction total selected amount for the adjustment.

Trx_totalpaid Double False

Transaction total amount paid.

Trx_totaldue Double False

Transaction total amount still due.

Billtopaytocontactname String False

Contact name for billing related to the AR adjustment.

Shiptoreturntocontactname String False

Contact name for shipping returns associated with the AR adjustment.

Billtopaytokey Int64 False

Key for billing to pay-to contact related to the AR adjustment.

Shiptoreturntokey Int64 False

Key for shipping or return-to contact related to the AR adjustment.

Shipto_contactname String False

Contact name for the shipping address associated with the AR adjustment.

Shipto_prefix String False

Prefix (for example, Mr., Ms.) for the shipping contact name.

Shipto_firstname String False

First name of the shipping contact.

Shipto_initial String False

Middle initial of the shipping contact.

Shipto_lastname String False

Last name of the shipping contact.

Shipto_companyname String False

Company name associated with the shipping address.

Shipto_printas String False

Formatted name to print for the shipping contact.

Shipto_phone1 String False

Primary phone number for the shipping contact.

Shipto_phone2 String False

Secondary phone number for the shipping contact.

Shipto_cellphone String False

Mobile phone number for the shipping contact.

Shipto_pager String False

Pager number for the shipping contact, if applicable.

Shipto_fax String False

Fax number for the shipping contact.

Shipto_email1 String False

Primary email address for the shipping contact.

Shipto_email2 String False

Secondary email address for the shipping contact.

Shipto_url1 String False

Primary website or URL related to the shipping contact.

Shipto_url2 String False

Secondary website or URL related to the shipping contact.

Shipto_visible Boolean False

Indicates whether the shipping contact is visible in the system.

Shipto_mailaddress_recordkey Int64 False

Key for the mail address record of the shipping contact.

Shipto_mailaddress_address1 String False

First line of the mail address for the shipping contact.

Shipto_mailaddress_address2 String False

Second line of the mail address for the shipping contact.

Shipto_mailaddress_city String False

City of the mail address for the shipping contact.

Shipto_mailaddress_state String False

State of the mail address for the shipping contact.

Shipto_mailaddress_zip String False

Postal code of the mail address for the shipping contact.

Shipto_mailaddress_country String False

Country of the mail address for the shipping contact.

Shipto_mailaddress_countrycode String False

Country code for the mail address of the shipping contact.

Billto_contactname String False

Contact name for the billing address related to the AR adjustment.

Billto_prefix String False

Prefix (for example, Mr., Ms.) for the billing contact name.

Billto_firstname String False

First name of the billing contact.

Billto_initial String False

Middle initial of the billing contact.

Billto_lastname String False

Last name of the billing contact.

Billto_companyname String False

Company name associated with the billing contact.

Billto_printas String False

Formatted name to print for the billing contact.

Billto_phone1 String False

Primary phone number for the billing contact.

Billto_phone2 String False

Secondary phone number for the billing contact.

Billto_cellphone String False

Mobile phone number for the billing contact.

Billto_pager String False

Pager number for the billing contact, if applicable.

Billto_fax String False

Fax number for the billing contact.

Billto_email1 String False

Primary email address for the billing contact.

Billto_email2 String False

Secondary email address for the billing contact.

Billto_url1 String False

Primary website or URL related to the billing contact.

Billto_url2 String False

Secondary website or URL related to the billing contact.

Billto_visible Boolean False

Indicates whether the billing contact is visible in the system.

Billto_mailaddress_recordkey Int64 False

Key for the mail address record of the billing contact.

Billto_mailaddress_address1 String False

First line of the mail address for the billing contact.

Billto_mailaddress_address2 String False

Second line of the mail address for the billing contact.

Billto_mailaddress_city String False

City of the mail address for the billing contact.

Billto_mailaddress_state String False

State of the mail address for the billing contact.

Billto_mailaddress_zip String False

Postal code of the mail address for the billing contact.

Billto_mailaddress_country String False

Country of the mail address for the billing contact.

Billto_mailaddress_countrycode String False

Country code for the mail address of the billing contact.

Prbatch String False

Batch identifier for the AR adjustment process.

Prbatchkey Int64 False

Key for the batch associated with the AR adjustment.

Modulekey String False

Key identifying the module to which the AR adjustment belongs.

Auwhencreated Datetime False

Timestamp for when the AR adjustment audit record was created.

Whenmodified Datetime False

Timestamp indicating the last modification date of the AR adjustment.

Createdby Int64 False

Identifier for the user who created the AR adjustment.

Modifiedby Int64 False

Identifier for the user who last modified the AR adjustment.

Megaentitykey Int64 False

Key for the mega entity related to the AR adjustment.

Megaentityid String False

ID for the mega entity associated with the AR adjustment.

Record_url String False

URL link to the record associated with the AR adjustment.

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