Order Totals

The Order Totals view object that extracts order total details from the sales orders, such as total list price, total tax, total shipping charge, and so on.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.OrderTotalExtractPVO

Primary Keys : OrderTotalId

Initial Extract Date : OrderTotalCreationDate

Incremental Extract Date : OrderTotalLastUpdateDate

Attributes

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

Name	Description
OrderTotalCreatedBy	User who created the order total row.
OrderTotalCreationDate	Date when the order total row was created.
OrderTotalCurrencyCode	Code that identifies the currency to use for the charge.
OrderTotalDisplayName	Name of the total.
OrderTotalEstimatedFlag	Indicates whether the total amount is estimated. A list of accepted values is defined in the lookup type YES_NO.
OrderTotalHeaderId	Value that identifies the sales order header associated to the order total row. This is a foreign key to the Sales Order Headers view object.
OrderTotalId	Value that uniquely identifies the order total. This is the primary key of the Order Totals view object.
OrderTotalLastUpdateDate	Date when the order total row was last updated.
OrderTotalLastUpdateLogin	Session login associated to the user who most recently updated the order total row.
OrderTotalLastUpdatedBy	User who most recently updated the order total. row.
OrderTotalObjectVersionNumber	Number of times the order total row has been updated.
OrderTotalPrimaryFlag	Indicates whether the total is primary. A list of accepted values is defined in the lookup type YES_NO.
OrderTotalTotalAmount	Aggregated amount for the total.
OrderTotalTotalCode	Code that identifies the definition of the total. For example, total list price, total selling price, total tax, and so on.
OrderTotalTotalGroup	Value that identifies the group of related totals.