ADO.NET Provider for Sage Intacct

Build 26.0.9655

PaymentDetail

Represents the detail records associated with a payment, linking applied bills, advances, adjustments, and inline transactions with their corresponding payment amounts and currencies.

Columns

Name Type Description
apAdvanceLine_Href String The URL of the AP advance line associated with this payment detail.
apAdvanceLine_Id String The Id of the AP advance line associated with this payment detail.
apAdvanceLine_Key String The system-assigned key of the AP advance line associated with this payment detail.
apAdvance_Href String The URL of the AP advance associated with this payment detail.
apAdvance_Id String The Id of the AP advance associated with this payment detail.
apAdvance_Key String The system-assigned key of the AP advance associated with this payment detail.
apCreditAdjustmentLine_Href String The URL of the AP credit adjustment line associated with this payment detail.
apCreditAdjustmentLine_Id String The Id of the AP credit adjustment line associated with this payment detail.
apCreditAdjustmentLine_Key String The system-assigned key of the AP credit adjustment line associated with this payment detail.
apCreditAdjustment_Href String The URL of the AP credit adjustment associated with this payment detail.
apCreditAdjustment_Id String The Id of the AP credit adjustment associated with this payment detail.
apCreditAdjustment_Key String The system-assigned key of the AP credit adjustment associated with this payment detail.
apDebitAdjustmentLine_Href String The URL of the AP debit adjustment line associated with this payment detail.
apDebitAdjustmentLine_Id String The Id of the AP debit adjustment line associated with this payment detail.
apDebitAdjustmentLine_Key String The system-assigned key of the AP debit adjustment line associated with this payment detail.
apDebitAdjustment_Href String The URL of the AP debit adjustment associated with this payment detail.
apDebitAdjustment_Id String The Id of the AP debit adjustment associated with this payment detail.
apDebitAdjustment_Key String The system-assigned key of the AP debit adjustment associated with this payment detail.
apPaymentLine_Href String The URL of the AP payment line associated with this payment detail.
apPaymentLine_Id String The Id of the AP payment line associated with this payment detail.
apPaymentLine_Key String The system-assigned key of the AP payment line associated with this payment detail.
apPayment_Href String The URL of the AP payment associated with this payment detail.
apPayment_Id String The Id of the AP payment associated with this payment detail.
apPayment_Key String The system-assigned key of the AP payment associated with this payment detail.
apPostedAdvanceLine_Href String The URL of the AP posted advance line associated with this payment detail.
apPostedAdvanceLine_Id String The Id of the AP posted advance line associated with this payment detail.
apPostedAdvanceLine_Key String The system-assigned key of the AP posted advance line associated with this payment detail.
apPostedAdvance_Href String The URL of the AP posted advance associated with this payment detail.
apPostedAdvance_Id String The Id of the AP posted advance associated with this payment detail.
apPostedAdvance_Key String The system-assigned key of the AP posted advance associated with this payment detail.
auditCreatedBy String The user who created the payment detail.
auditCreatedDateTime Datetime The date and time when the payment detail was created.
auditModifiedBy String The user who last modified the payment detail.
auditModifiedDateTime Datetime The date and time when the payment detail was last modified.
baseCurrencyAdjustmentAmount Decimal The adjustment amount for this payment detail in the base currency.
baseCurrencyDiscountAmount Decimal The discount amount applied to this payment detail in the base currency.
baseCurrencyInlineAmount Decimal The inline bill amount applied to this payment detail in the base currency.
baseCurrencyPaymentAmount Decimal The payment amount for this payment detail in the base currency.
baseCurrencyPostedAdvanceAmount Decimal The posted advance amount applied to this payment detail in the base currency.
billLine_Href String The URL of the bill line associated with this payment detail.
billLine_Id String The Id of the bill line associated with this payment detail.
billLine_Key String The system-assigned key of the bill line associated with this payment detail.
bill_Href String The URL of the bill associated with this payment detail.
bill_Id String The Id of the bill associated with this payment detail.
bill_Key String The system-assigned key of the bill associated with this payment detail.
discountDate Date The date on which the discount for this payment detail is applied.
href String The URL of the payment detail resource.
id String The unique identifier of the payment detail record.
inlineBillLine_Href String The URL of the inline bill line associated with this payment detail.
inlineBillLine_Id String The Id of the inline bill line associated with this payment detail.
inlineBillLine_Key String The system-assigned key of the inline bill line associated with this payment detail.
inlineBill_Href String The URL of the inline bill associated with this payment detail.
inlineBill_Id String The Id of the inline bill associated with this payment detail.
inlineBill_Key String The system-assigned key of the inline bill associated with this payment detail.
jointPayee_Href String The URL of the joint payee associated with this payment detail.
jointPayee_Id String The Id of the joint payee associated with this payment detail.
jointPayee_Key String The system-assigned key of the joint payee associated with this payment detail.
jointPayee_PrintAs String The print-as name of the joint payee associated with this payment detail.
key [KEY] String The system-assigned key that uniquely identifies the payment detail record.
moduleKey String The key of the module associated with this payment detail.
paymentDate Date The date on which this payment was made.
state String The current state of this payment detail, such as draft, submitted, or posted.
txnCurrencyAdjustmentAmount Decimal The adjustment amount for this payment detail in the transaction currency.
txnCurrencyCurrency String The transaction currency code for this payment detail.
txnCurrencyDiscountAmount Decimal The discount amount applied to this payment detail in the transaction currency.
txnCurrencyInlineAmount Decimal The inline bill amount applied to this payment detail in the transaction currency.
txnCurrencyPaymentAmount Decimal The payment amount for this payment detail in the transaction currency.
txnCurrencyPostedAdvanceAmount Decimal The posted advance amount applied to this payment detail in the transaction currency.

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