ADO.NET Provider for Oracle Fusion Cloud Financials

Build 24.0.9175

PayablesPaymentTermspayablesPaymentTermsLines

Specifies the line-level breakdown of each payment term, detailing how installments or discounts are structured across due dates.

Columns

Name Type Description
PayablesPaymentTermstermsId [KEY] Long The unique identifier for the payment terms associated with the payment terms line.
DuePercent Decimal The percentage of the total due amount for the payment terms line.
AmountDue Decimal The total amount due for the payment terms line.
Days Int The number of days until payment is due for the payment terms line.
DayOfMonth Int The specific day of the month on which the payment is due.
MonthsAhead Int The number of months ahead from the invoice date when the payment terms line applies.
FirstDiscountPercent Decimal The discount percentage applied to the payment if paid by the first discount date.
FirstDiscountDays Int The number of days after the invoice date by which the first discount must be paid.
FirstDiscountDayOfMonth Int The specific day of the month when the first discount can be applied.
FirstDiscountMonthsForward Int The number of months ahead from the invoice date when the first discount is available.
SecondDiscountPercent Decimal The discount percentage applied to the payment if paid by the second discount date.
SecondDiscountDays Int The number of days after the invoice date by which the second discount must be paid.
SecondDiscountDayOfMonth Int The specific day of the month when the second discount can be applied.
SecondDiscountMonthsForward Int The number of months ahead from the invoice date when the second discount is available.
ThirdDiscountPercent Decimal The discount percentage applied to the payment if paid by the third discount date.
ThirdDiscountDays Int The number of days after the invoice date by which the third discount must be paid.
ThirdDiscountDayOfMonth Int The specific day of the month when the third discount can be applied.
ThirdDiscountMonthsForward Int The number of months ahead from the invoice date when the third discount is available.
FixedDate Date The fixed date used for calculating the payment terms, if applicable.
Calendar String The calendar associated with the payment terms line, used to define payment due dates.
SequenceNumber [KEY] Int The sequence number indicating the order of the payment terms line within the set of terms.
TermsId [KEY] Long The identifier of the payment terms set to which the line belongs.
Finder String A search term or keyword used for identifying the payment terms line.
FromDate Date The start date when the payment terms line becomes effective.
ToDate Date The end date when the payment terms line is no longer effective.

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