Power BI Connector for Sage Intacct

Build 25.0.9454

APBill

Contains information on accounts payable bills, including vendor data, payment terms, and outstanding balances.

Table Specific Information

Insert

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

INSERT INTO APBill (Vendorid, Whencreated, Recordid, Description, Whendue, Paymentpriority, Basecurr, ItemAggregate) VALUES('V100', '06/28/2024', '9874', 'This is a test', '5/31/2025', 'high', 'USD', '<apbillitem><accountno>1130</accountno><trx_amount>750.75</trx_amount><entrydescription>Bill test</entrydescription><locationid>400</locationid><departmentid>35</departmentid></apbillitem>');

Note: Inserts are not supported with the Legacy API.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

A unique identifier for the accounts payable bill record.

Recordtype String False

The type of record associated with the accounts payable bill.

Recordid String False

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

Financialentity String False

The financial entity associated with the accounts payable bill.

State String False

The current state or status of the accounts payable bill.

Rawstate String False

The raw state data associated with the accounts payable bill.

Entity String False

The entity associated with the accounts payable bill.

Vendorid String False

The vendor identifier linked to the accounts payable bill.

Vendorname String False

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

Form1099type String False

The 1099 form type associated with the vendor for the bill.

Vendtype1099type String False

The vendor type or 1099 form type associated with the accounts payable bill.

Trx_entitydue Double False

The amount due from the entity associated with the bill.

Docnumber String False

The document number associated with the accounts payable bill.

Description String False

A brief description of the accounts payable bill.

Description2 String False

An additional description or notes about the accounts payable bill.

Termname String False

The payment terms name associated with the accounts payable bill.

Termkey Int64 False

The unique key for the payment terms linked to the bill.

Whencreated Datetime False

The timestamp indicating when the accounts payable bill was created.

Whenposted Datetime False

The timestamp indicating when the accounts payable bill was posted.

Whendiscount Datetime False

The discount date for the accounts payable bill.

Whendue Datetime False

The due date for the accounts payable bill.

Whenpaid Datetime False

The date when the accounts payable bill was paid.

Recpaymentdate Datetime False

The recommended payment date for the accounts payable bill.

Paymentpriority String False

The payment priority level for the accounts payable bill.

Onhold Boolean False

Indicates whether the accounts payable bill is on hold.

Basecurr String False

The base currency for the accounts payable bill.

Currency String False

The currency in which the accounts payable bill is recorded.

Exch_rate_date Datetime False

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

Exch_rate_type_id Int64 False

The unique identifier for the exchange rate type applied to the bill.

Exchange_rate Double False

The exchange rate applied to the accounts payable bill.

Totalentered Double False

The total amount entered for the accounts payable bill.

Totalselected Double False

The total amount selected for payment for the bill.

Totalpaid Double False

The total amount paid for the accounts payable bill.

Totaldue String False

The total amount due for the accounts payable bill.

Trx_totalentered Double False

The total transaction amount entered for the bill.

Trx_totalselected Double False

The total transaction amount selected for payment for the bill.

Trx_totalpaid Double False

The total transaction amount paid for the bill.

Trx_totaldue Double False

The total transaction amount due for the bill.

Billtopaytocontactname String False

The name of the contact responsible for paying the bill.

Shiptoreturntocontactname String False

The name of the contact for shipping or returns related to the bill.

Billtopaytokey Int64 False

The unique key identifying the billing contact for the bill.

Shiptoreturntokey Int64 False

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

Prbatch String False

The identifier for the batch associated with the bill.

Prbatchkey Int64 False

The unique key for the batch associated with the bill.

Modulekey String False

The module key linked to the accounts payable bill.

Schopkey Int64 False

The schedule operation key associated with the bill.

Systemgenerated String False

Indicates whether the accounts payable bill was system-generated.

Auwhencreated Datetime False

The timestamp indicating when the accounts payable bill was audited.

Whenmodified Datetime False

The timestamp indicating when the accounts payable bill was last modified.

Createdby Int64 False

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

Modifiedby Int64 False

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

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 bill.

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