Order Terms

The Order Terms view object contains details about terms for sales orders such as pricing terms.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.OrderTermExtractPVO

Primary Keys : OrderTermId

Initial Extract Date : OrderTermCreationDate

Incremental Extract Date : OrderTermLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
OrderTermCreatedBy	User who created the order term row.
OrderTermCreationDate	Date when the order term row was created.
OrderTermDeltaType	Internal column used by change processing framework for tracking type of change like update, cancel, and so on.
OrderTermHeaderId	Value that uniquely identifies the sales order.
OrderTermId	Value that uniquely identifies the term.
OrderTermLastUpdateDate	Date when the order term row was last updated.
OrderTermLastUpdateLogin	Session login associated with the user who most recently updated the order term row.
OrderTermLastUpdatedBy	User who most recently updated the order term row.
OrderTermModifiedFlag	Value that indicates that the row has been modified in the current submitted version.
OrderTermObjectVersionNumber	Value that identifies the number of times the order term row has been updated.
OrderTermParentEntityCode	Value that identifies the entity to which term is applied.
OrderTermParentEntityId	Value that uniquely identifies the entity against which term is applied.
OrderTermReferenceOrderTermId	Used by change management to associate the change order's term ID with the original order's term ID.
OrderTermSourceOrderTermId	Value that uniquely identifies the order term in the source application.
OrderTermTermApplicationMethod	Value that identifies the method of application for the term. For a subscription, a list of accepted values is defined in the lookup type ORA_OSS_RNWL_PRICE_ADJ_TYPE.
OrderTermTermApplicationValuePct	Value that identifies the percent of adjustment for the term.
OrderTermTermDuration	Value that identifies the duration for the term, for example, a subscription term.
OrderTermTermEndDate	Date when the term ends, for example, a subscription term.
OrderTermTermPeriod	Value that identifies the time unit of measure for the order term, such as a pricing term for a subscription.
OrderTermTermStartDate	Date when the term starts, for example, subscription term.
OrderTermTermSubtypeCode	Value that identifies the subtype of the term. For example, renewal or ramp-up.
OrderTermTermTypeCode	Value that identifies the type of the term. For example, a subscription.