Excel Add-In for Oracle Fusion Cloud Financials

Build 24.0.9175

PayablesPaymentTerms

Defines the rules (for example, net 30, net 60) for paying a supplier, setting installment schedules and discount opportunities.

Columns

Name Type Description
TermsId [KEY] Long The unique identifier of the payment terms in the payables system.
Name String The name of the payment terms for the supplier or customer in the payables system.
EnabledFlag Bool Indicates whether the payment terms are enabled or active in the system.
FromDate Date The start date from which the payment terms are effective.
ToDate Date The end date until which the payment terms are valid.
CutoffDay Int The day of the month when the cutoff for the payment terms occurs. Typically, this defines the day when payments are due.
Rank Long The rank or priority of the payment terms, typically used to determine precedence when multiple terms are applicable.
CreatedBy String The name of the user who created the payment terms.
CreationDate Datetime The date and time when the payment terms were created in the system.
LastUpdateDate Datetime The date and time when the payment terms were last updated.
LastUpdateLogin String The login session of the user who last updated the payment terms.
LastUpdatedBy String The name of the user who last updated the payment terms.
Description String A brief description of the payment terms, outlining the payment conditions.
SetId Long The identifier of the set of payment terms, which may group related payment terms together.
Finder String Search term or keyword used for finding the payment terms in the system.

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