PayablesPaymentTermLine

A payment term line stores detailed information about payment terms, outlining the timing and method of payments. These terms are assigned to suppliers and invoices, automatically generating payment installments when a Payables Invoice is created. Each payment term consists of one or more lines, with each line specifying a due date or discount date, and creating a corresponding installment.

Expand all

Collapse all

Business Views

** Available for extracting data

• payablesPaymentTermLinesExtract**

  A payment term line stores detailed information about payment terms, outlining the timing and method of payments. These terms are assigned to suppliers and invoices, automatically generating payment installments when a Payables Invoice is created. Each payment term consists of one or more lines, with each line specifying a due date or discount date, and creating a corresponding installment.

  Label, Plural Label

  Payables Payment Term Lines, Payables Payment Term Lines

  Data Source

  Read-optimized data store

  Expand all

  Collapse all

  Fields

  • calendar (string)

    The name of the special calendar associated with the term line.

    Label

    Calendar

  • createdBy (string)

    The user who created the record.

    Label

    Created By

    Properties

    • not nullable
  • discountDayOfMonth (big-decimal)

    The day of the month used to calculate the discount date for an invoice payment line.

    Label

    First Discount Day of Month

  • discountDays (big-decimal)

    The number of days after the terms date, used to calculate a discount date for an invoice payment line.

    Label

    First Discount Days

  • discountMonthsForward (big-decimal)

    The number of months ahead used to calculate the discount date the for invoice payment line.

    Label

    First Discount Months Ahead

  • discountPercent (big-decimal)

    The percentage used to calculate the discount available for an invoice payment line.

    Label

    Discount

  • dueAmount (big-decimal)

    The maximum payment amount that's due by a certain date.

    Label

    Amount Due

  • dueDayOfMonth (big-decimal)

    The day of the month used to calculate the due date of an invoice payment line.

    Label

    Day of Month

  • dueDays (big-decimal)

    The number of days after the terms date, used to calculate the due date of an invoice payment line.

    Label

    Days

  • dueMonthsForward (big-decimal)

    The number of months ahead, used to calculate the due date of an invoice payment line.

    Label

    Months Ahead

  • duePercent (big-decimal)

    The percentage of a payment due by a certain date.

    Label

    Due

  • fixedDate (date)

    The payment term attribute that indicates the payment due date.

    Label

    Fixed Date

  • secondDiscountDayOfMonth (big-decimal)

    The day of the month used to calculate a second discount available for an invoice payment line.

    Label

    Second Discount Day of Month

  • secondDiscountDays (big-decimal)

    The number of days after the terms date, used to calculate a second discount available for an invoice payment line.

    Label

    Second Discount Days

  • secondDiscountMonthsForward (big-decimal)

    The number of months ahead, used to calculate the second discount available for an invoice payment line.

    Label

    Second Discount Months Ahead

  • secondDiscountPercent (big-decimal)

    The percentage used to calculate the second discount available for an invoice payment line.

    Label

    Second Discount Percentage

  • sequenceNumber (int64)

    The number of the payment term line. This attribute is a part of the composite key of the Payment Terms Details view object.

    Label

    Payment Term Line Number

    Properties

    • searchable
    • sortable
    • not nullable
  • termId (int64)

    The unique identifier of the payment term line. This attribute is a part of the composite key of the Payment Terms Details view object.

    Label

    Payment Term Identifier

    Properties

    • searchable
    • sortable
    • not nullable
  • thirdDiscountDays (big-decimal)

    The number of days after the terms date, used to calculate a third discount for an invoice payment line.

    Label

    Third Discount Days

  • thirdDiscountPercent (big-decimal)

    The percentage used to calculate a third discount available for an invoice payment line.

    Label

    Third Discount Percentage

  • timeCreated (date-time)

    The date and time when the record was created.

    Label

    Creation Date

    Properties

    • searchable
    • not nullable
  • timeUpdated (date-time)

    The date and time when the record was last updated.

    Label

    Last Updated Date

    Properties

    • searchable
    • not nullable
  • updatedBy (string)

    The user who last updated the record.

    Label

    Last Updated By

    Properties

    • not nullable

  Expand all

  Collapse all

  Reference Object

  • paymentTerm (PayablesPaymentTerm)

    The payment terms specify the timing of payments, including due dates and discount periods. They're assigned to suppliers and invoices, automatically creating payment installments when an invoice is generated. Each payment term consists of one or more lines, with each line corresponding to a separate installment and specifying a due date or discount date. Payment terms are predefined and selected when entering suppliers or invoices to ensure scheduled payments are generated accordingly.

    Business Object

    PayablesPaymentTerm

    Expand all

    Collapse all

    Fields

    • termId (int64)

      The unique identifier of the payment term line. This attribute is a part of the composite key of the payment terms details view object.

      Label

      Payment Terms

      Properties

      • searchable
      • sortable
      • not nullable

Back to Top