SalesOrdersForOrderHub.rsd
Usage information for the operation SalesOrdersForOrderHub.rsd.
Columns
| Name | Type | Description |
| HeaderId [KEY] | Long | Value that uniquely identifies the sales order header. The application creates this value when it creates the sales order. |
| OrderNumber | String | OrderNumber of SalesOrdersForOrderHub |
| SourceTransactionNumber | String | Value that uniquely identifies the transaction in the source application. The source application assigns this value as the order number. If your implementation interfaces to a quote and converts the quote to a sales order, then this attribute references the quote number. |
| SourceTransactionSystem | String | Source system that created the order. You use the Manage Trading Community Source Systems and Manage Upstream and Fulfillment Source Systems tasks to setup the source application. |
| SourceTransactionId | String | Value that uniquely identifies the transaction in the source application. If the source application does not contain a unique value for the transaction, then you can set this attribute to a user key that the source application contains, such as an order number or quote number. The application uses this attribute and the source transaction to uniquely identify the transaction and create the composite key for a change order. You must make sure that each change order uses the same value that the new sales order used. |
| BusinessUnitId | Long | Value that uniquely identifies the business unit that sold the sales order. The application also uses the business unit to implement data security and determine each sales order that the user can access. |
| BusinessUnitName | String | Name of the business unit that sold the sales order. |
| TransactionOn | Datetime | Date and time when the transaction started. 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 placed the sales order. |
| BuyingPartyId | Long | Value that uniquely identifies the sold-to customer. This value contains the person, company, or organization who placed the sales order. This value references the party identifier with usage of CUSTOMER. |
| BuyingPartyName | String | Name of the person or organization party who placed the sales order. This value identifies the sold-to customer. This points to the party name with usage of CUSTOMER. |
| BuyingPartyNumber | String | Number of the person or organization party who placed the sales order. This value identifies the sold-to customer. This value references the party name with usage of CUSTOMER. |
| BuyingPartyPersonFirstName | String | If a person placed the sales order, then this attribute contains the first name of the person. |
| BuyingPartyPersonLastName | String | If a person placed the sales order, then this attribute contains the last name of the person. |
| BuyingPartyPersonMiddleName | String | If a person placed the sales order, then this attribute contains the middle name of the person. |
| BuyingPartyPersonNameSuffix | String | If a person placed the sales order, then this attribute contains the name suffix of the person. |
| BuyingPartyPersonTitle | String | If a person placed the sales order, then this attribute contains the title of the person. |
| BuyingPartyContactId | Long | Value that uniquely identifies the person who placed the sales order or the sold-to contact to contact for the sales order. |
| BuyingPartyContactName | String | Name of the person who placed the sales order or the sold-to contact to contact for the sales order. |
| BuyingPartyContactNumber | String | Number of the person who placed the sales order or the sold-to contact to contact for the sales order. |
| BuyingPartyContactFirstName | String | First name of the person who placed the sales order or who is the person to contact for the sales order. |
| BuyingPartyContactLastName | String | Last name of the person who placed the sales order or who is the person to contact for the sales order. |
| BuyingPartyContactMiddleName | String | Middle name of the person who placed the sales order or who is the person to contact for the sales order. |
| BuyingPartyContactNameSuffix | String | Suffix of the name of the person who placed the sales order or who is the person to contact for the sales order. |
| BuyingPartyContactTitle | String | Title of the person who placed the sales order or who is the person to contact for the sales order. |
| PreferredSoldToContactPointId | Long | Value that uniquely identifies the preferred contact point for the sold-to contact. This value identifies the preferred email contact. |
| CustomerPONumber | String | Number that the customer sends for this purchase order. |
| TransactionTypeCode | String | Abbreviation that identifies the type of transaction. A list of accepted values is defined in the lookup type ORA_DOO_ORDER_TYPES. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Order Lookups task. |
| TransactionType | String | Name of the type of sales order. |
| SubstituteAllowedFlag | Bool | Contains one of the following values: true or false. If true, then you can substitute items on the fulfillment line for various reasons, such as shortage of material, or as a goodwill gesture to the customer. If false, then you cannot make these substitutions. This attribute does not have a default value. |
| PackingInstructions | String | Text that describes how to pack the item. |
| ShippingInstructions | String | Text that includes details about how to ship the item. |
| ShipsetFlag | Bool | Contains one of the following values: true or false. 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 do not ship them as a group. This attribute does not have a default value. |
| PartialShipAllowedFlag | Bool | Contains one of the following values: true or false. If true, then ship items on the sales order in more than one shipment. If false, then do not ship these items in one shipment. The default value is false. |
| RequestedShipDate | Datetime | Date when the customer requested to ship the item. |
| RequestedArrivalDate | Datetime | Date when the customer requested the item to arrive. |
| LatestAcceptableShipDate | Datetime | Date when the customer is willing to allow the warehouse to ship the item. |
| LatestAcceptableArrivalDate | Datetime | Date when the customer is willing to receive the item. |
| EarliestAcceptableShipDate | Datetime | Earliest date when the customer is willing to receive the shipment. |
| ShipmentPriorityCode | String | Abbreviation that identifies the priority of the shipment. A list of accepted values is defined in the lookup type WSH_SHIPPING_PRIORITY. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Lookups task. |
| ShipmentPriority | String | Priority of shipment that allows you to group shipments into different categories depending on the urgency. A list of accepted values is defined in the lookup type WSH_SHIPPING_PRIORITY. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source, or use Load Planning Data from Flat Files. |
| ShippingCarrierId | Long | Value that uniquely identifies the carrier who delivered the item. |
| ShippingCarrier | String | Carrier who delivered the item. |
| ShippingServiceLevelCode | String | Abbreviation that identifies the shipping level of service to use to deliver the shipment. A list of accepted values is defined in the lookup type WSH_SERVICE_LEVELS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| ShippingServiceLevel | String | Level of service for the shipping that delivers the shipment. A list of accepted values is defined in the lookup type WSH_SERVICE_LEVELS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| ShippingModeCode | String | Abbreviation that identifies the mode of shipping that delivers the shipment. A list of accepted values is defined in the lookup type WSH_MODE_OF_TRANSPORT. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| ShippingMode | String | Mode of shipping that delivers the item. A list of accepted values is defined in the lookup type WSH_MODE_OF_TRANSPORT. Review and update the value for this attribute using the Setup and Maintenance work area, and the V task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| FOBPointCode | String | Abbreviation that identifies the freight on board. A list of accepted values is defined in the lookup type ORA_FOB. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| FOBPoint | String | Freight on board. Identifies the ownership of the item while it is in transit. A list of accepted values is defined in the lookup type ORA_FOB. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| DemandClassCode | String | Abbreviation that identifies the demand class. A list of accepted values is defined in the lookup type ORA_DOO_DEMAND_CLASS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| DemandClass | String | Demand class that represents a group of customers, such as government, commercial, sales channel, or region. Demand class can represent different sources of demand, such as retail, mail order, or wholesale. A list of accepted values is defined in the lookup type ORA_DOO_DEMAND_CLASS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| FreightTermsCode | String | Abbreviation that identifies the terms for paying freight charges. For example, paid by shipper, collect, or prepaid. A list of accepted values is defined in the lookup type ORA_FREIGHT_TERMS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| FreightTerms | String | Terms for paying freight charges. For example, paid by shipper, collect, or prepaid. A list of accepted values is defined in the lookup type ORA_FREIGHT_TERMS. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Shipping Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| RequestedFulfillmentOrganizationId | Long | Value that uniquely identifies the organization that ships the shipment. |
| RequestedFulfillmentOrganizationCode | String | Abbreviation that identifies the organization that ships the shipment. |
| RequestedFulfillmentOrganizationName | String | Name of the organization that ships the shipment. |
| SupplierId | Long | Value that uniquely identifies the supplier who supplies the item. You can use a supplier according to the contractual obligations in drop ship. |
| SupplierName | String | Name of the supplier who supplies the item. You can use a supplier according to a contractual obligation in drop ship. |
| SupplierSiteId | Long | Value that uniquely identifies the supplier who supplies the item. |
| PaymentTermsCode | Long | Abbreviation that identifies the payment terms. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Receivables Payment Terms task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| PaymentTerms | String | Payment terms to apply to collect payment. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Receivables Payment Terms task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| SalespersonId | Long | Value that uniquely identifies the primary sales person. |
| Salesperson | String | Name of the primary sales person. |
| PricedOn | Datetime | Date when pricing priced the sales order. This attribute contains the system date at the beginning of the price calculation. |
| TransactionalCurrencyCode | String | Abbreviation that identifies the currency that pricing used to price the transaction. |
| TransactionalCurrencyName | String | Name of the currency that pricing used to price the transaction. |
| AppliedCurrencyCode | String | AppliedCurrencyCode of SalesOrdersForOrderHub |
| CurrencyConversionDate | Datetime | Date when the foreign exchange rate is valid. |
| CurrencyConversionRate | Double | Foreign exchange conversion rate that pricing used to convert the transaction currency into the item currency. |
| CurrencyConversionType | String | Describes the type of the conversion rate that the application uses when it converts currency. |
| PricingSegmentCode | String | Abbreviation that identifies the pricing segment. |
| PricingSegment | String | PricingSegment of SalesOrdersForOrderHub |
| PricingStrategyId | Long | Value that uniquely identifies the pricing strategy. |
| PricingStrategyName | String | Name of the pricing strategy. |
| AllowCurrencyOverrideFlag | Bool | Contains one of the following values: true or false. If true, then you can override the currency. If false, then you cannot override. The default value is true. |
| SegmentExplanationMessageName | String | Name of the message for the pricing segment strategy. You can use the message name to get the message text. |
| PricingSegmentExplanation | String | Explanation of why pricing applied the pricing segment. |
| StrategyExplanationMessageName | String | Name of the pricing strategy message. You can use the message name to get the message text. |
| PricingStrategyExplanation | String | Explanation of why pricing applied the pricing strategy. |
| SalesChannelCode | String | Abbreviation that identifies the sales channel. For example, web or phone. A list of accepted values is defined in the lookup type ORA_QP_CHANNEL_METHODS. |
| SalesChannel | String | Name of the sales channel. For example, web or phone. A list of accepted values is defined in the lookup type ORA_QP_CHANNEL_METHODS. |
| Comments | String | Comments that the user enters on the sales order. |
| StatusCode | String | StatusCode of SalesOrdersForOrderHub |
| Status | String | Status of SalesOrdersForOrderHub |
| OnHoldFlag | Bool | OnHoldFlag of SalesOrdersForOrderHub |
| CanceledFlag | Bool | Contains one of the following values: true or false. If true, then sales order canceled. If false, then sales order is not canceled. The default value is false. |
| CancelReasonCode | String | Abbreviation that identifies the reason to cancel the sales order. A list of accepted values is defined in the lookup type DOO_RETURN_REASON. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Order Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| CancelReason | String | Reason to cancel the sales order. A list of accepted values is defined in the lookup type DOO_RETURN_REASON. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Order Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
| RequestedCancelDate | Datetime | Date when the customer canceled the order line. |
| RequestingBusinessUnitId | Long | Value that uniquely identifies the business unit who requested the sales order. Assign a business unit for each role to each user to provide access to data in the business unit. |
| RequestingBusinessUnitName | String | Name of the business unit who requested the sales order. Assign a business unit for each role to each user to provide access to data in the business unit. |
| RequestingLegalEntityId | Long | Value that uniquely identifies the legal entity who formed a contract with the customer. The contracting party on the order is the legal entity. |
| RequestingLegalEntity | String | Legal entity who formed a contract with the customer for the sales order. The contracting party on the order is the legal entity. |
| FreezePriceFlag | Bool | Contains one of the following values: true or false. If true, then price the sales order. If false, then do not price. The default value is true. |
| FreezeShippingChargeFlag | Bool | Contains one of the following values: true or false. If true, then recalculate shipping charges for the sales order. If false, then do not recalculate. The default value is true. |
| FreezeTaxFlag | Bool | Contains one of the following values: true or false. If true, then calculate taxes for the sales. If false, then do not calculate. The default value is true. |
| SubmittedFlag | Bool | Contains one of the following values: true or false. If true, then the application validated and submitted the sales order. If false, then the application did not validate and submit. The sales order is in draft status. The default value is false. |
| SubmittedBy | String | SubmittedBy of SalesOrdersForOrderHub |
| SubmittedDate | Datetime | SubmittedDate of SalesOrdersForOrderHub |
| TransactionDocumentTypeCode | String | Abbreviation that identifies whether the request is a sales order, purchase order or internal material transfer. |
| PreCreditCheckedFlag | Bool | Contains one of the following values: true or false. If true, then allow an application outside Oracle Fusion to perform credit check. If false, then do not allow. The default value is false. |
| RevisionSourceSystem | String | Source application that sent a revision of the sales order. |
| SourceTransactionRevisionNumber | Long | Revision number of the transaction. |
| TradeComplianceResultCode | String | TradeComplianceResultCode of SalesOrdersForOrderHub |
| TradeComplianceResult | String | TradeComplianceResult of SalesOrdersForOrderHub |
| LastUpdatedBy | String | LastUpdatedBy of SalesOrdersForOrderHub |
| LastUpdateDate | Datetime | LastUpdateDate of SalesOrdersForOrderHub |
| CreatedBy | String | CreatedBy of SalesOrdersForOrderHub |
| CreationDate | Datetime | CreationDate of SalesOrdersForOrderHub |
| OpenFlag | Bool | OpenFlag of SalesOrdersForOrderHub |
| OrigSystemDocumentReference | String | Original reference for the source order from the source application. |
| AppliedCurrencyName | String | AppliedCurrencyName of SalesOrdersForOrderHub |
| SupplierSiteName | String | Value that uniquely identifies the supplier site that supplies the item. |
| MessageText | String | MessageText of SalesOrdersForOrderHub |
| AgreementHeaderId | Long | Value that uniquely identifies the sales agreement on the order header. |
| AgreementNumber | String | Number of the sales agreement on the order header. |
| AgreementVersionNumber | Long | AgreementVersionNumber of SalesOrdersForOrderHub |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| FromDate | Date | FromDate |
| ToDate | Date | ToDate |
| Finder | String | finder |