Power BI Connector for Sage Intacct

Build 25.0.9454

ARInvoice

Manages accounts receivable invoices, including customer details, payment terms, and transaction specifics.

Table Specific Information

Insert

Insert is only supported when UseLegacy=True. The following example illustrates how to insert into ARInvoice table: 

INSERT INTO ARInvoice (CustomerID, Itemaggregate, Whencreated, Whendue) VALUES('BES001',  '<lineitem><accountlabel>SALES</accountlabel><amount>100</amount></lineitem><lineitem><accountlabel>SALES</accountlabel><amount>300</amount></lineitem>', '2015-07-20', '2015-07-20');

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

Unique identifier for the AR invoice.

Recordtype String False

Type of record for the AR invoice.

Recordid String False

Record ID for the AR invoice in the system.

State String False

Current state of the invoice (e.g., Open, Paid).

Rawstate String False

System-specific state for the invoice.

Entity String False

Entity associated with the invoice.

Custentity String False

Customer entity linked to the invoice.

Customerid String False

Customer ID for the invoice.

Customername String False

Name of the customer for this invoice.

Trx_entitydue Double False

Amount due for the invoice in the transaction currency.

Custmessageid String False

Customer message ID associated with this invoice.

Delivery_options String False

Delivery options specified for this invoice.

Docnumber String False

Document number assigned to the invoice.

Description String False

Primary description for the invoice.

Description2 String False

Additional description for the invoice.

Termname String False

Name of the payment terms for this invoice.

Termkey Int64 False

Key representing the payment terms.

Whencreated Datetime False

Timestamp for when the invoice was created.

Whenposted Datetime False

Timestamp for when the invoice was posted.

Whendiscount Datetime False

Discount eligibility date for the invoice.

Whendue Datetime False

Due date for the invoice payment.

Whenpaid Datetime False

Payment date for the invoice.

Basecurr String False

Base currency for the invoice.

Currency String False

Currency in which the invoice is issued.

Exch_rate_date Datetime False

Exchange rate date applicable to this invoice.

Exch_rate_type_id Int64 False

Type ID for the exchange rate used.

Exchange_rate Double False

Exchange rate applied to the invoice.

Totalentered Double False

Total amount entered for the invoice.

Totalselected Double False

Total selected amount for this invoice.

Totalpaid Double False

Total amount paid for this invoice.

Totaldue Double False

Total amount due for this invoice.

Trx_totalentered Double False

Total entered amount in transaction currency.

Trx_totalselected Double False

Total selected amount in transaction currency.

Trx_totalpaid Double False

Total paid amount in transaction currency.

Trx_totaldue Double False

Total due amount in transaction currency.

Billtopaytocontactname String False

Contact name for billing or payments.

Shiptoreturntocontactname String False

Contact name for shipping or returns.

Billtopaytokey Int64 False

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

Shiptoreturntokey Int64 False

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

Contact_contactname String False

Name of the contact associated with this AR invoice.

Contact_prefix String False

Prefix (e.g., Mr., Ms.) for the contact name.

Contact_firstname String False

First name of the contact associated with the AR invoice.

Contact_initial String False

Middle initial of the contact associated with the AR invoice.

Contact_lastname String False

Last name of the contact linked to the AR invoice.

Contact_companyname String False

Company name associated with the contact.

Contact_printas String False

Formatted name to print for the contact.

Contact_phone1 String False

Primary phone number for the contact.

Contact_phone2 String False

Secondary phone number for the contact.

Contact_cellphone String False

Mobile phone number for the contact.

Contact_pager String False

Pager number for the contact, if applicable.

Contact_fax String False

Fax number for the contact.

Contact_email1 String False

Primary email address for the contact.

Contact_email2 String False

Secondary email address for the contact.

Contact_url1 String False

Primary website or URL related to the contact.

Contact_url2 String False

Secondary website or URL related to the contact.

Contact_visible Boolean False

Indicates whether the contact is visible in the system.

Contact_mailaddress_address1 String False

First line of the mail address for the contact.

Contact_mailaddress_address2 String False

Second line of the mail address for the contact.

Contact_mailaddress_city String False

City of the mail address for the contact.

Contact_mailaddress_state String False

State of the mail address for the contact.

Contact_mailaddress_zip String False

Postal code of the mail address for the contact.

Contact_mailaddress_country String False

Country of the mail address for the contact.

Contact_mailaddress_countrycode String False

Country code for the mail address of the contact.

Shipto_contactname String False

Name of the shipping contact associated with the AR invoice.

Shipto_prefix String False

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

Shipto_firstname String False

First name of the shipping contact associated with the AR invoice.

Shipto_initial String False

Middle initial of the shipping contact associated with the AR invoice.

Shipto_lastname String False

Last name of the shipping contact associated with the AR invoice.

Shipto_companyname String False

Company name associated with the shipping contact.

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_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

Name of the billing contact associated with the AR invoice.

Billto_prefix String False

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

Billto_firstname String False

First name of the billing contact associated with the AR invoice.

Billto_initial String False

Middle initial of the billing contact associated with the AR invoice.

Billto_lastname String False

Last name of the billing contact associated with the AR invoice.

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_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 invoice process.

Prbatchkey Int64 False

Key for the batch associated with the AR invoice.

Modulekey String False

Key for the module associated with the invoice.

Schopkey Int64 False

Key representing schedule operations associated with the AR invoice.

Systemgenerated String False

Indicates whether the invoice was system-generated.

Haspostedrevrec String False

Indicates if the revenue recognition has been posted for this invoice.

Auwhencreated Datetime False

Audit timestamp for when the invoice was created.

Whenmodified Datetime False

Timestamp for the last modification to the invoice.

Createdby Int64 False

User ID of the person who created the invoice.

Modifiedby Int64 False

User ID of the person who last modified the invoice.

Megaentitykey Int64 False

Key representing the mega entity associated with this invoice.

Megaentityid String False

ID of the mega entity associated with this invoice.

Record_url String False

URL to view this invoice record in the system.

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