Sales Order Headers

The Sales Order Headers view object extracts header details from the sales orders, such as customers, order type, business unit, and so on.

Data Store Key : FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.HeaderExtractPVO

Primary Keys : HeaderId

Initial Extract Date : HeaderCreationDate

Incremental Extract Date : HeaderLastUpdateDate

Attributes

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

Name	Description
HeaderAgreementHeaderId	Value that identifies the sales agreement on the sales order header.
HeaderAgreementVersionNumber	Version number of the sales agreement on the sales order header.
HeaderAllowCurrencyOverrideFlag	Value that identifies whether you can override the currency on the sales order. If true, then you can override the currency. If false, then you can't override the currency.
HeaderAppliedCurrencyCode	Value that identifies the currency that pricing applied.
HeaderApprovalSequenceNumber	Value that identifies the sequence number of the approval request sent to the Approval Management system for the sales order.
HeaderBatchId	Value that uniquely identifies the batch that was used for importing the sales order.
HeaderCancelReasonCode	Code that identifies the reason to cancel the sales order. A list of accepted values is defined in the lookup type DOO_RETURN_REASON.
HeaderCanceledFlag	Indicates whether the sales order was canceled. A list of accepted values is defined in the lookup type YES_NO. The default value is N.
HeaderCarrierId	Value that identifies the shipping carrier who delivers the item.
HeaderChangeVersionNumber	Value that identifies the version number of the sales order.
HeaderComments	Comments that the user enters on the sales order.
HeaderConversionDate	Date when the foreign exchange rate is valid.
HeaderConversionRate	Foreign exchange conversion rate that pricing used to convert the transaction currency into the item currency.
HeaderConversionTypeCode	Describes the type of the conversion rate that the application uses when it converts currency.
HeaderConversionTypeCodeDerived	Value that identifies the corresponding currency conversion type code as defined in the application. Tax exemption reason code is a collected entity. The value of this attribute denotes the value derived from the collected value stored by Planning.
HeaderCreatedBy	User who created the sales order header row.
HeaderCreatedInRelease	Value that identifies the application release in which the sales order was created.
HeaderCreationDate	Date when the sales order header row was created.
HeaderCreationMode	Value that identifies the interface using which the sales order was captured.
HeaderCustomerPoNumber	Number of the purchase order on the sales order header.
HeaderDemandClassCode	Value that identifies the demand class. A list of accepted values is defined in the lookup type ORA_DOO_DEMAND_CLASS.
HeaderEarliestAcceptArrivalDate	Value that identifies the earliest date when the customer is willing to receive the item.
HeaderEarliestAcceptableShipDate	Value that identifies the earliest date when the customer is willing to allow the warehouse to ship the item.
HeaderFobPointCode	Value that identifies the freight on board. A list of accepted values is defined in the lookup type ORA_FOB.
HeaderFreezePriceFlag	Value that identifies whether Pricing should price the sales order. If true, then price the sales order. If false, then don't price the sales order.
HeaderFreezeShippingChargeFlag	Value that identifies whether shipping charges should be calculated for the sales order. If true, then calculate shipping charges for the sales order. If false, then don't calculate shipping charges.
HeaderFreezeTaxFlag	Value that identifies whether taxes should be calculated for the sales order. If true, then calculate taxes for the sales order. If false, then don't calculate taxes.
HeaderFreightTermsCode	Value that identifies the terms for paying freight charges.
HeaderFulfillOrgId	Value that uniquely identifies the organization that ships the order shipment.
HeaderId	Value that uniquely identifies the sales order header. This is the primary key of the Sales Order Headers view object.
HeaderInternalComments	Comments that Oracle uses to monitor data for an item when processing a sales order. This is strictly for internal use only.
HeaderIsEditable	Indicates whether the sales order is editable.
HeaderLastUpdateDate	Date when the sales order header row was last updated.
HeaderLastUpdateLogin	Session login associated to the user who most recently updated the sales order header row.
HeaderLastUpdatedBy	User who most recently updated the sales order header row.
HeaderLatestAcceptArrivalDate	Value that identifies the latest date when the customer is willing to receive the item.
HeaderLatestAcceptableShipDate	Value that identifies the latest date when the customer is willing to allow the warehouse to ship the item.
HeaderLegalEntityId	Value that identifies the legal entity who formed a contract with the customer. The contracting party on the order is the legal entity.
HeaderMdoFlag	Indicates the orchestration mode of the sales order. If true, then the orchestration mode is meta-data driven. If false, the orchestration mode is regular.
HeaderModifiedFlag	Indicates whether the user modified the sales order. If true, then the user modified the sales order. If false, then the user didn't modify the sales order.
HeaderObjectVersionNumber	Number of times the sales order header row has been updated.
HeaderOnHold	Indicates whether the sales order is on hold. A list of accepted values is defined in the lookup type YES_NO. The default value is N.
HeaderOpenFlag	Indicates whether the sales order is open. A list of accepted values is defined in the lookup type YES_NO.
HeaderOrderNumber	Number of the sales order.
HeaderOrderTypeCode	Code that identifies the type of sales order. A list of accepted values is defined in the lookup type ORA_DOO_ORDER_TYPES.
HeaderOrderedDate	Date and time when the transaction starts. The date occurs when the customer commits to purchase the items that the sales order contains. The date can occur in the past or future, depending on when the customer places the sales order.
HeaderOrgId	Value that identifies the business unit that sells the sales order.
HeaderOrigSysDocumentRef	Original reference for the source order from the source system.
HeaderOwnerId	Value that identifies the owner of the sales order.
HeaderPackingInstructions	Value that describes how to pack the item.
HeaderPartialShipAllowedFlag	Indicates whether the shipping system can split a shipment for the ship items in the sales order. A list of accepted values is defined in the lookup type YES_NO. The default value is Y.
HeaderPaymentTermId	Value that identifies the payment term on the sales order header.
HeaderPaymentTermIdDerived	Value that identifies the corresponding payment term defined in the Oracle Fusion application.
HeaderPreCreditCheckedFlag	Value that identifies whether an application outside Oracle Fusion is allowed to perform credit check. If true, then allow an application outside Oracle Fusion to perform credit check. If false, then don't allow.
HeaderPricedOn	Value that identifies the date when pricing priced the sales order. This attribute contains the system date at the beginning of the price calculation.
HeaderPricingSegmentCode	Value that identifies the pricing segment.
HeaderPricingSegmentExplanation	Explanation of why pricing applied the pricing segment.
HeaderPricingStrategyExplanation	Explanation of why pricing applied the pricing strategy.
HeaderPricingStrategyId	Value that uniquely identifies the pricing strategy.
HeaderReferenceHeaderId	Value that identifies the previous sales order header. Order Management uses this value when processing change orders.
HeaderRequestArrivalDate	Date when the customer requested the item to arrive.
HeaderRequestCancelDate	Date when the customer requested to cancel the sales order.
HeaderRequestShipDate	Date when the customer requested to ship the item.
HeaderRevisionSourceOrderSystem	Value that identifies the source application that sent a revision of the sales order.
HeaderSalesChannelCode	Code that identifies the sales channel on the sales order header. For example, web or phone. A list of accepted values is defined in the lookup type ORA_QP_CHANNEL_METHODS.
HeaderSalespersonId	Value that identifies the primary sales person for the sales order.
HeaderSegmentExplanationMsgName	Value that identifies the name of the message for the pricing segment. You can use the message name to get the message text.
HeaderShipClassOfService	Value that identifies the level of service for the shipping that delivers the shipment. A list of accepted values is defined in the lookup type WSH_SERVICE_LEVELS.
HeaderShipModeOfTransport	Value that identifies the mode of shipping that delivers the item. A list of accepted values is defined in the lookup type WSH_MODE_OF_TRANSPORT.
HeaderShipmentPriorityCode	Value that identifies the priority of the shipment. A list of accepted values is defined in the lookup type WSH_SHIPPING_PRIORITY.
HeaderShippingInstructions	Value that identifies the detailed instructions about cargo and other requirements for shipping.
HeaderShipsetFlag	Value that identifies whether a group of sales order lines should be shipped together. If true, then ship a group of order lines in the sales order together from a single location to a single destination, and ship them all on the same scheduled ship date. If false, then don't ship them as a group.
HeaderSoldToContactId	Value that identifies the contact of the sold-to account.
HeaderSoldToCustomerId	Value that identifies the account of the sold-to customer.
HeaderSoldToPartyContactId	Value that identifies the person who placed the sales order or is the primary contact for the sales order.
HeaderSoldToPartyContactPointId	Value that identifies the contact point for the sold-to contact.
HeaderSoldToPartyId	Value that identifies the sold-to customer. This value contains the person, company, or organization who placed the sales order.
HeaderSourceDocumentTypeCode	Code that identifies the type of original source order. For example, internal material transfer, sales order, and so on. A list of accepted values is defined in the lookup type ORA_DOO_SRC_DOC_TYPE_FOR_SETUP. The default value is SO (Sales Order).
HeaderSourceOrderId	Value that uniquely identifies the transaction from the source system.
HeaderSourceOrderNumber	Number of the source order.
HeaderSourceOrderSystem	Code that identifies the source system that created the source order.
HeaderSourceOrgId	Value that identifies the business unit for the source order.
HeaderSourceRevisionNumber	Value that identifies the revision number of the source sales order.
HeaderStatusCode	Code that identifies the status of the sales order header.
HeaderStrategyExplanationMsgName	Value that identifies the name of the pricing strategy message. You can use the message name to get the message text.
HeaderSubinventory	Value that identifies the physical or logical location of the item.
HeaderSubmittedBy	User who submitted the sales order.
HeaderSubmittedDate	Date when the sales order was submitted.
HeaderSubmittedFlag	Indicates whether the sales order was validated and submitted. A list of accepted values is defined in the lookup type YES_NO.
HeaderSubstituteAllowedFlag	Indicates whether a substitute item can be fulfilled on the order. If true, then allow the application to substitute an item on the fulfillment line for some reason, such as shortage of material or goodwill gesture to the customer. If false, then don't allow the application to substitute.
HeaderSupplierId	Value that identifies the supplier for the purchase order.
HeaderSupplierSiteId	Value that identifies the supplier site for the purchase order.
HeaderTradeComplianceResultCode	Value that identifies the result of trade compliance screening of the order.
HeaderTransactionalCurrencyCode	Code that identifies the currency for the sales order.
HeaderTransactionalCurrencyCodeDerived	Value that identifies the corresponding transactional currency code as defined in the application. Currency code is a collected entity. The value of this attribute denotes the value derived from the collected value stored by Planning.