ADO.NET Provider for Sage Intacct

Build 26.0.9655

Bill

Represents accounts payable bill transactions, including vendor, payment, currency, retainage, and tax solution details.

Columns

Name Type ReadOnly Description
attachment_Href String True

The URL of the attachment associated with this bill.

attachment_Id String False

The Id of the attachment associated with this bill.

attachment_Key String False

The system-assigned key of the attachment associated with this bill.

auditCreatedBy String True

The user who created the bill.

auditCreatedDateTime Datetime True

The date and time when the bill was created.

auditModifiedBy String True

The user who last modified the bill.

auditModifiedDateTime Datetime True

The date and time when the bill was last modified.

billNumber String False

The bill number assigned to this bill transaction.

billSummary_Href String True

The URL of the bill summary associated with this bill.

billSummary_Id String False

The Id of the bill summary associated with this bill.

billSummary_IsSummaryOpen String True

Indicates whether the bill summary associated with this bill is open.

billSummary_IsSummaryPosted String True

Indicates whether the bill summary associated with this bill has been posted.

billSummary_Key String False

The system-assigned key of the bill summary associated with this bill.

billSummary_Name String True

The name of the bill summary associated with this bill.

createdDate Date False

The date on which the bill was created.

currencyBaseCurrency String False

The base currency used for this bill transaction.

currencyTxnCurrency String False

The transaction currency used for this bill.

description String False

The description of the bill.

discountCutOffDate Date False

The cut-off date after which early payment discounts no longer apply for this bill.

documentSource String True

The source from which this bill document originated.

dueDate Date False

The date by which payment of this bill is due.

dueInDays String True

The number of days until this bill is due.

eInvoiceStatus String True

The electronic invoice status of this bill.

entity_Href String True

The URL of the entity associated with this bill.

entity_Id String True

The Id of the entity associated with this bill.

entity_Key String True

The system-assigned key of the entity associated with this bill.

entity_Name String True

The name of the entity associated with this bill.

href String True

The URL of the bill resource.

id String True

The unique identifier of the bill.

importErrorMessage String True

The error message returned if the bill import failed.

importStatus String True

The import status of this bill.

invoiceMode String False

The invoice mode used for this bill, such as standard or credit.

invoiceType String False

The invoice type of this bill, such as vendor invoice or debit memo.

isOnHold Bool False

Indicates whether this bill is on hold and excluded from payment processing.

isSystemGenerated Bool True

Indicates whether this bill was generated by the system.

isTaxInclusive Bool False

Indicates whether the tax amount is included in the bill total.

key [KEY] String True

The system-assigned key that uniquely identifies the bill record.

moduleName String True

The name of the module from which this bill originated.

paymentInformationFullyPaidDate Date False

The date on which this bill was fully paid.

paymentInformationTotalBaseAmountPaid Decimal True

The total amount paid against this bill in the base currency.

paymentInformationTotalBaseAmountSelectedForPayment Decimal True

The total base currency amount selected for payment against this bill.

paymentInformationTotalTxnAmountPaid Decimal True

The total amount paid against this bill in the transaction currency.

paymentInformationTotalTxnAmountSelectedForPayment Decimal True

The total transaction currency amount selected for payment against this bill.

paymentPriority String False

The payment priority assigned to this bill, such as urgent or normal.

postingDate Date False

The date on which this bill was posted to the general ledger.

purchasingDocument_Href String True

The URL of the purchasing document associated with this bill.

purchasingDocument_Id String True

The Id of the purchasing document associated with this bill.

purchasingDocument_Key String True

The system-assigned key of the purchasing document associated with this bill.

purchasing_Href String True

The URL of the purchasing record associated with this bill.

purchasing_Id String False

The Id of the purchasing record associated with this bill.

purchasing_Key String True

The system-assigned key of the purchasing record associated with this bill.

recipientEmail String True

The email address of the recipient for this bill.

recommendedPaymentDate Date False

The recommended date for paying this bill.

recordType String True

The record type of this bill, indicating whether it is a standard bill or a credit memo.

recurringSchedule_Href String True

The URL of the recurring schedule associated with this bill.

recurringSchedule_Id String True

The Id of the recurring schedule associated with this bill.

recurringSchedule_Key String True

The system-assigned key of the recurring schedule associated with this bill.

referenceNumber String False

The vendor-assigned reference number for this bill.

retainageDefaultPercentage Decimal True

The default retainage percentage applied to line items on this bill.

retainageTotalBaseAmountRetained Decimal True

The total retainage amount retained from this bill in the base currency.

retainageTotalTxnAmountReleased Decimal True

The total retainage amount released from this bill in the transaction currency.

retainageTotalTxnAmountRetained Decimal True

The total retainage amount retained from this bill in the transaction currency.

senderEmail String True

The email address of the sender for this bill.

sourceModule String True

The source module from which this bill originated.

state String False

The posting state of the bill, such as draft or posted.

taxSolution_Href String True

The URL of the tax solution associated with this bill.

taxSolution_Id String False

The Id of the tax solution associated with this bill.

taxSolution_Key String False

The system-assigned key of the tax solution associated with this bill.

taxSolution_Method String True

The tax calculation method used by the tax solution associated with this bill.

taxSolution_ShowMultiLineTax String True

Indicates whether multi-line tax details are displayed for this bill's tax solution.

taxSolution_TaxCalculationMethod String True

The tax calculation method applied by the tax solution on this bill.

term_Href String True

The URL of the payment term associated with this bill.

term_Id String False

The Id of the payment term associated with this bill.

term_Key String False

The system-assigned key of the payment term associated with this bill.

totalBaseAmount Decimal True

The total amount of this bill in the base currency.

totalBaseAmountDue Decimal True

The total amount due on this bill in the base currency.

totalTxnAmount Decimal True

The total amount of this bill in the transaction currency.

totalTxnAmountDue Decimal True

The total amount due on this bill in the transaction currency.

vendor_Href String True

The URL of the vendor associated with this bill.

vendor_Id String False

The Id of the vendor associated with this bill.

vendor_Key String False

The system-assigned key of the vendor associated with this bill.

vendor_Name String True

The name of the vendor associated with this bill.

vendor_VendorDue Decimal True

The total amount due to the vendor associated with this bill.

webURL String True

The web URL for accessing this bill in the Sage Intacct user interface.

ListAggregate_Lines String False

The list of line items associated with this bill.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655