SalesOrdersForOrderHublines
SalesOrdersForOrderHublines
Columns
Name | Type | Description |
SalesOrdersForOrderHubHeaderId [KEY] | Long | SalesOrdersForOrderHubHeaderId of SalesOrdersForOrderHublines |
HeaderId | Long | HeaderId of SalesOrdersForOrderHublines |
LineId | Long | LineId of SalesOrdersForOrderHublines |
FulfillLineId [KEY] | Long | FulfillLineId of SalesOrdersForOrderHublines |
SourceTransactionLineId | String | Value that uniquely identifies the transaction line from the source application. |
SourceTransactionLineNumber | String | Number of the transaction line from the source application. |
SourceTransactionId | String | SourceTransactionId of SalesOrdersForOrderHublines |
SourceTransactionNumber | String | SourceTransactionNumber of SalesOrdersForOrderHublines |
SourceTransactionSystem | String | SourceTransactionSystem of SalesOrdersForOrderHublines |
RequestingBusinessUnitId | Long | RequestingBusinessUnitId of SalesOrdersForOrderHublines |
RequestingBusinessUnitName | String | RequestingBusinessUnitName of SalesOrdersForOrderHublines |
AccountingRuleCode | String | Abbreviation that identifies the accounting rule. |
AccountingRule | String | Accounting rule that determines the accounting timeframe or timeframes to use when distributing revenue for an invoice line. |
ActionTypeCode | String | Abbreviation that identifies the type of action with respect to the coverage or the subscription product on fulfillment line. Say Add, Update, Renew in case of coverage. Resume, Suspend, terminate in case of subscriptions. A list of accepted values is defined in the lookup type ORA_QP_ACTION_TYPES. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
ActionType | String | Value that identifies the type of the action with respect to the coverage or the subscription product on fulfillment line. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
ActualCompletionDate | Datetime | ActualCompletionDate of SalesOrdersForOrderHublines |
ActualShipDate | Datetime | ActualShipDate of SalesOrdersForOrderHublines |
AppliedPriceListId | Long | AppliedPriceListId of SalesOrdersForOrderHublines |
AppliedPriceListName | String | AppliedPriceListName of SalesOrdersForOrderHublines |
AssessableValue | Double | Price that a tax authority uses to value, and then tax the item. |
AssetGroupNumber | String | Value that groups customer assets into different categories. |
AssetTrackedFlag | Bool | Abbreviation that identifies whether the fulfill line is eligible to be interfaced to asset management for tracking customer assets that are created from order processing. This attribute is not currently used. |
AssetTrackingCode | String | Abbreviation that identifies whether the fulfill line is eligible to be interfaced to asset management for tracking customer assets that are created from order processing. A list of accepted values is defined in the lookup type ORA_EGP_ASSET_TRACKING. |
AssetTracking | String | AssetTracking of SalesOrdersForOrderHublines |
BillingTransactionTypeId | Long | Value that identifies the billing type. |
BillingTransactionTypeName | String | Name of the billing type. |
BuyerId | Long | Buyer details for a schedule. This attribute references the Buyer Public View that the application publishes for the item on the purchase order. |
BuyerName | String | BuyerName of SalesOrdersForOrderHublines |
BuyerFirstName | String | BuyerFirstName of SalesOrdersForOrderHublines |
BuyerLastName | String | BuyerLastName of SalesOrdersForOrderHublines |
BuyerMiddleName | String | BuyerMiddleName of SalesOrdersForOrderHublines |
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. |
CanceledFlag | Bool | Contains one of the following values: true or false. If true, then the application canceled the sales order line. If false, then not canceled. The default value is false. |
CanceledQuantity | Double | CanceledQuantity of SalesOrdersForOrderHublines |
ShippingCarrierId | Long | Abbreviation that identifies the carrier who delivers the item. |
ShippingCarrier | String | Carrier who delivers the item. |
TransactionCategoryCode | String | Abbreviation that identifies whether the line is a return. Values include RETURN or ORDER. |
Comments | String | Comments for the order line. |
ComponentIdPath | String | Value that identifies the path from the inventory item to the parent of this configured item on the order line. |
ConfigCreationDate | Datetime | Date when the user created the configured item. |
ConfigHeaderId | Long | Value that identifies the order header of the sales order that contains the configured item. |
ConfigInventoryItemId | Long | Inventory item for an assemble-to-order, configured item that the application can ship. A contract or a sales agreement is an example of an item that the application cannot ship. |
ConfigInventoryItemNumber | String | ConfigInventoryItemNumber of SalesOrdersForOrderHublines |
ConfigInventoryItemDescription | String | ConfigInventoryItemDescription of SalesOrdersForOrderHublines |
ConfigItemReference | String | Reference to the finished configured item. |
ConfigRevisionNumber | Long | Revision number of the configured item. The configurator sets the value of this attribute to the configured item. It does not set it to a configure option. |
ConfigTradeComplianceResultCode | String | ConfigTradeComplianceResultCode of SalesOrdersForOrderHublines |
ConfigTradeComplianceResult | String | ConfigTradeComplianceResult of SalesOrdersForOrderHublines |
ConfiguratorPath | String | Path that identifies the inventory item for the configure option. Path format is |
ContractEndDate | Date | End date of the contract, according to the start date and duration. You can use Manage Time Units Mappings to map time units to the units of measure that the application uses. |
ContractStartDate | Date | Start date of the contract. |
CreatedBy | String | CreatedBy of SalesOrdersForOrderHublines |
CreationDate | Datetime | CreationDate of SalesOrdersForOrderHublines |
CreditCheckAuthExpiryDate | Datetime | Date when the approved credit authorization expires. |
CreditCheckAuthorizationNumber | String | Value that uniquely identifies the approved credit authorization that the credit management system created on the authorized amount for the customer account. This attribute applies on credit checks only for authorization or reauthorization. |
CustomerProductId | Long | Value that uniquely identifies the customer item. |
CustomerProductNumber | String | Number of the customer item. |
CustomerProductDescription | String | Description of the customer item. |
CustomerPOLineNumber | String | Value that uniquely identifies the purchase order line. The purchase order line describes the item or service, and it includes the price and quantity ordered. |
CustomerPONumber | String | Number that identifies the purchase order that the application uses to request that the seller supply the item or service in return for payment. |
CustomerPOScheduleNumber | String | Number that identifies the schedule for the shipment that ships the purchase order. This is an optional attribute that the user can specify when submitting the sales order. |
DefaultTaxationCountry | String | Country that the tax authority uses to calculate tax. |
DefaultTaxationCountryShortName | String | Short name of the country that the tax authority uses to calculate tax. |
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 Order 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 Order Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
DestinationLocationId | Long | Value that identifies the destination location where the application ships the item. |
DestinationShippingOrganizationId | Long | Value that identifies the destination organization where the application ships the item. |
DestinationShippingOrganizationCode | String | Abbreviation that identifies the destination organization where the application ships the item. |
DestinationShippingOrganizationName | String | Name of the destination organization where the application ships the item. |
DocumentSubtype | String | Tax classification for tax reporting. This attribute depends on the requirements for each country. |
DocumentSubtypeName | String | Name of the tax classification for tax reporting. This attribute depends on the requirements for each country. |
EarliestAcceptableShipDate | Datetime | Earliest date when the customer is willing to receive shipment. |
EstimateFulfillmentCost | Double | Estimated cost to deliver the fulfillment line to the customer. This value includes item cost and shipping cost. |
EstimateMargin | Double | Estimated margin expected when shipping the fulfillment line. |
ExemptionCertificateNumber | String | Certification number that the taxing authority provides for tax exemption for each customer who is eligible for tax exemption. |
ExtendedAmount | Double | Monetary amount of the order line. |
FinalDischargeLocationId | Long | Value that identifies the final destination location for the purchase. |
FinalDischargeLocationAddressLine1 | String | First line of the final destination location for the purchase. |
FinalDischargeLocationAddressLine2 | String | Second line of the final destination location for the purchase. |
FinalDischargeLocationAddressLine3 | String | Third line of the final destination location for the purchase. |
FinalDischargeLocationAddressLine4 | String | Fourth line of the final destination location for the purchase. |
FinalDischargeLocationAddressCity | String | City of the final destination location for the purchase. |
FinalDischargeLocationAddressPostalCode | String | Postal code of the final destination location for the purchase. |
FinalDischargeLocationAddressState | String | State of the final destination location for the purchase. |
FinalDischargeLocationAddressProvince | String | Province of the final destination location for the purchase. |
FinalDischargeLocationAddressCounty | String | County of the final destination location for the purchase. |
FinalDischargeLocationAddressCountry | String | Country of the final destination location for the purchase. |
FirstPartyTaxRegistration | Long | Registration number that the application provides to the supplier. The supplier uses this number to tax the transaction. |
FirstPartyTaxRegistrationNumber | String | Value that identifies registration number. |
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 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. |
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. |
FulfillInstanceId | Long | FulfillInstanceId of SalesOrdersForOrderHublines |
FulfillLineNumber | String | FulfillLineNumber of SalesOrdersForOrderHublines |
RequestedFulfillmentOrganizationId | Long | Value that uniquely identifies the organization that fulfills the item. If the item is shippable, then this value references the warehouse that ships the item. A contract or an agreement is an example of an item that is not shippable. |
RequestedFulfillmentOrganizationCode | String | Abbreviation that identifies the organization that fulfills the item. If the item is shippable, then this value references the warehouse that ships the item. A contract or an agreement is an example of an item that is not shippable. |
RequestedFulfillmentOrganizationName | String | Name of the organization that fulfills the item. If the item is shippable, then this value references the warehouse that ships the item. A contract or an agreement is an example of an item that is not shippable. |
RequestedFulfillmentOrganizationAddress1 | String | RequestedFulfillmentOrganizationAddress1 of SalesOrdersForOrderHublines |
RequestedFulfillmentOrganizationAddress2 | String | RequestedFulfillmentOrganizationAddress2 of SalesOrdersForOrderHublines |
RequestedFulfillmentOrganizationAddress3 | String | RequestedFulfillmentOrganizationAddress3 of SalesOrdersForOrderHublines |
RequestedFulfillmentOrganizationAddress4 | String | RequestedFulfillmentOrganizationAddress4 of SalesOrdersForOrderHublines |
RequestedFulfillmentOrganizationCity | String | RequestedFulfillmentOrganizationCity of SalesOrdersForOrderHublines |
RequestedFulfillmentOrganizationState | String | RequestedFulfillmentOrganizationState of SalesOrdersForOrderHublines |
RequestedFulfillmentOrganizationPostalCode | String | RequestedFulfillmentOrganizationPostalCode of SalesOrdersForOrderHublines |
RequestedFulfillmentOrganizationCounty | String | RequestedFulfillmentOrganizationCounty of SalesOrdersForOrderHublines |
RequestedFulfillmentOrganizationProvince | String | RequestedFulfillmentOrganizationProvince of SalesOrdersForOrderHublines |
RequestedFulfillmentOrganizationCountry | String | RequestedFulfillmentOrganizationCountry of SalesOrdersForOrderHublines |
OverFulfillmentTolerance | Double | OverFulfillmentTolerance of SalesOrdersForOrderHublines |
UnderFulfillmentTolerance | Double | UnderFulfillmentTolerance of SalesOrdersForOrderHublines |
FulfilledQuantity | Double | FulfilledQuantity of SalesOrdersForOrderHublines |
SecondaryFulfilledQuantity | Double | SecondaryFulfilledQuantity of SalesOrdersForOrderHublines |
FulfillmentDate | Datetime | FulfillmentDate of SalesOrdersForOrderHublines |
FulfillmentMode | String | FulfillmentMode of SalesOrdersForOrderHublines |
FulfillmentSplitReferenceId | Long | FulfillmentSplitReferenceId of SalesOrdersForOrderHublines |
GopReferenceId | String | GopReferenceId of SalesOrdersForOrderHublines |
GopRequestRegion | String | GopRequestRegion of SalesOrdersForOrderHublines |
IntendedUseClassificationId | Long | Value that uniquely identifies intended use of the item. For tax calculation. |
IntendedUseClassificationName | String | Classification name for the intended use of the item. For tax calculation. |
ProductId | Long | Value that uniquely identifies the inventory item. |
ProductNumber | String | Stock keeping unit for the item that the application fulfills. |
ProductDescription | String | Description of the item that the application fulfills. |
InventoryOrganizationId | Long | InventoryOrganizationId of SalesOrdersForOrderHublines |
InventoryOrganizationCode | String | InventoryOrganizationCode of SalesOrdersForOrderHublines |
InventoryOrganizationName | String | InventoryOrganizationName of SalesOrdersForOrderHublines |
InvoiceEnabledFlag | Bool | InvoiceEnabledFlag of SalesOrdersForOrderHublines |
InvoiceInterfacedFlag | Bool | InvoiceInterfacedFlag of SalesOrdersForOrderHublines |
InvoiceableItemFlag | Bool | InvoiceableItemFlag of SalesOrdersForOrderHublines |
InvoicingRuleCode | String | Abbreviation that identifies invoicing rules that determine when to recognize a receivable for invoice. |
InvoicingRule | String | Invoicing rule that determines when to recognize a receivable for invoice. |
ItemSubTypeCode | String | ItemSubTypeCode of SalesOrdersForOrderHublines |
ItemSubType | String | ItemSubType of SalesOrdersForOrderHublines |
ItemTypeCode | String | ItemTypeCode of SalesOrdersForOrderHublines |
LastUpdateDate | Datetime | LastUpdateDate of SalesOrdersForOrderHublines |
LastUpdateLogin | String | LastUpdateLogin of SalesOrdersForOrderHublines |
LastUpdatedBy | String | LastUpdatedBy of SalesOrdersForOrderHublines |
LatestAcceptableArrivalDate | Datetime | Latest date when the customer is willing to receive the item. |
LatestAcceptableShipDate | Datetime | Latest date when the customer is willing to allow the warehouse to ship the item. |
TransactionLineTypeCode | String | Type of action in the channel system. For example, buy, replace with, return for credit, upgrade, and so on. |
TransactionLineType | String | Defines behavior for the fulfillment line. For example, required values, default values, display values, and so on. |
OnHoldFlag | Bool | OnHoldFlag of SalesOrdersForOrderHublines |
OpenFlag | Bool | OpenFlag of SalesOrdersForOrderHublines |
OrderedQuantity | Double | Quantity of the item or service on the fulfillment line. |
SecondaryOrderedQuantity | Double | SecondaryOrderedQuantity of SalesOrdersForOrderHublines |
OrderedUOMCode | String | Abbreviation that identifies the unit of measure for the ordered quantity. |
OrderedUOM | String | Unit of measure for the ordered quantity. For example, length, time, heat, value, and so on. |
SecondaryUOMCode | String | SecondaryUOMCode of SalesOrdersForOrderHublines |
SecondaryUOM | String | Secondary unit of measure for the ordered quantity on the fulfillment line. This attribute is applicable when more than one unit of measure is used to measure and track the item. |
BusinessUnitId | Long | BusinessUnitId of SalesOrdersForOrderHublines |
BusinessUnitName | String | BusinessUnitName of SalesOrdersForOrderHublines |
OrigSystemDocumentLineReference | String | Original document reference of the order line in the source application. |
OrigSystemDocumentReference | String | Original document reference of the source order in the source application. |
OriginalProductId | Long | Value that uniquely identifies the inventory item that the fulfillment line contained before the application substituted the item. |
OriginalProductNumber | String | Number of the inventory item that the fulfillment line contained before the application substituted the item. |
OriginalProductDescription | String | Description of the inventory item that the fulfillment line contained before the application substituted the item. |
OverrideScheduleDateFlag | Bool | Contains one of the following values: true or false. If true, then the user can manually override the schedule date. If false, then user cannot override. The default value is false. |
OwnerId | Long | User who is responsible for the order line. |
PackingInstructions | String | Document that contains packing details for the item. |
ParentFulfillLineId | Long | ParentFulfillLineId of SalesOrdersForOrderHublines |
PartialShipAllowedFlag | Bool | Contains one of the following values: true or false. If true, then ship items in the sales order in more than one shipment. If false, then ship items in the sales order in one shipment. The default value is false. |
PaymentTermsCode | Long | Abbreviation that identifies payment terms. |
PaymentTerms | String | Payment terms to use to collect payment. |
POStatusCode | String | Status of the purchase order. |
PricedOn | Datetime | Date when pricing priced the order line. The application sets this date to the system date when pricing begins pricing the order line. |
ProcessNumber | String | ProcessNumber of SalesOrdersForOrderHublines |
ProductFiscalCategoryId | Long | Value that uniquely identifies the tax classification. |
ProductFiscalCategory | String | Tax classification of the item that the tax authority uses to tax the item. |
ProductCategory | String | Item classification that the tax authority uses to tax the item. |
ProductCategoryName | String | Classifies the item for tax. Order management uses this attribute when you do not install Oracle Fusion Inventory in your deployment, or when you installed it but you do not use it to classify items for tax. |
ProductType | String | Type of item classification in Oracle Fusion Tax. The value of the item type specifies whether the transaction line is for an item or service, or whether it is a memo line. |
ProductTypeName | String | Name of the item classification in Oracle Fusion Tax. The value of the item type specifies whether the transaction line is for an item or service, or whether it is a memo line. |
PromiseArrivalDate | Datetime | Date when global order promising promised to the customer that the item will arrive. |
PromiseShipDate | Datetime | Date when global order promising promised to the customer that the item will ship. |
PurchasingEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the purchase order can include the item on the fulfillment line. If false, then the purchase order cannot include the item on the fulfillment line. The default value is set based on the item setup. This attribute is read-only. |
PurchasingUOMCode | String | Abbreviation that identifies the unit of measure that procurement set on the purchase order for the supplier. |
PurchasingUOM | String | Unit of measure that procurement set on the purchase order for the supplier. |
QuantityForEachModel | Double | Quantity for a configure option on a single configured item. |
ReceivablesOrgId | Long | Receivables business unit. |
ReceivablesOrgName | String | ReceivablesOrgName of SalesOrdersForOrderHublines |
RemnantFlag | Bool | RemnantFlag of SalesOrdersForOrderHublines |
RequestedArrivalDate | Datetime | Original date when the customer requested for the item to arrive. |
RequestedCancelDate | Datetime | Date when the customer canceled the order line. |
RequestedShipDate | Datetime | Original date when the customer requested for the item to ship. |
RequiredFulfillmentDate | Datetime | Date when the customer requires fulfillment. |
RequisitionBusinessUnitId | Long | RequisitionBusinessUnitId of SalesOrdersForOrderHublines |
RequisitionBusinessUnitName | String | RequisitionBusinessUnitName of SalesOrdersForOrderHublines |
RequisitionInventoryOrganizationId | Long | RequisitionInventoryOrganizationId of SalesOrdersForOrderHublines |
RequisitionInventoryOrganizationCode | String | RequisitionInventoryOrganizationCode of SalesOrdersForOrderHublines |
RequisitionInventoryOrganizationName | String | RequisitionInventoryOrganizationName of SalesOrdersForOrderHublines |
ReservableFlag | Bool | ReservableFlag of SalesOrdersForOrderHublines |
ReservationId | Long | ReservationId of SalesOrdersForOrderHublines |
ReservedQuantity | Double | ReservedQuantity of SalesOrdersForOrderHublines |
ReturnReasonCode | String | Abbreviation that identifies the reason to return an item. |
ReturnReason | String | Reason that the customer provided to return the item. |
ReturnableFlag | Bool | ReturnableFlag of SalesOrdersForOrderHublines |
RMADeliveredQuantity | Double | RMADeliveredQuantity of SalesOrdersForOrderHublines |
SecondaryRMADeliveredQuantity | Double | SecondaryRMADeliveredQuantity of SalesOrdersForOrderHublines |
RootParentFulfillLineId | Long | RootParentFulfillLineId of SalesOrdersForOrderHublines |
SalesProductTypeCode | String | SalesProductTypeCode of SalesOrdersForOrderHublines |
SalesProductType | String | SalesProductType of SalesOrdersForOrderHublines |
SalespersonId | Long | Value that identifies the primary salesperson. |
Salesperson | String | Person who is responsible for the sale of the sales order. |
ScheduleArrivalDate | Datetime | Date when the application scheduled the shipment to arrive. |
ScheduleShipDate | Datetime | Date when the application scheduled the shipment to ship. |
SchedulingReason | String | Value of the scheduling reason. |
SchedulingReasonCode | String | Abbreviation that identifies the scheduling reason. |
ServiceDuration | Double | Duration for the coverage item or subscription item on the fulfillment line. |
ServiceDurationPeriodCode | String | Abbreviation that identifies the unit of measure for the coverage item or subscription item on the fulfillment line. |
ServiceDurationPeriodName | String | Name of the unit of measure for the coverage item or subscription item on the fulfillment line. |
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 Manage Shipping Lookups task. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
ShipSetName | String | Group of order lines in the sales order that must ship together from one location to one destination, and that use the same scheduled ship date. |
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. To collect data for this attribute, use the Collect Order Reference Data task for Fusion Source. |
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. |
ShippableFlag | Bool | ShippableFlag of SalesOrdersForOrderHublines |
ShippedQuantity | Double | ShippedQuantity of SalesOrdersForOrderHublines |
SecondaryShippedQuantity | Double | SecondaryShippedQuantity of SalesOrdersForOrderHublines |
ShippedUOMCode | String | ShippedUOMCode of SalesOrdersForOrderHublines |
ShippedUOM | String | ShippedUOM of SalesOrdersForOrderHublines |
ShippingInstructions | String | Detailed instructions about cargo and other requirements for shipping. |
ShowInSales | Int | Specifies how to display a configured item on the Sales Summary page and on the Configurator summary page. You can set this attribute to one of the following values. Yes: display the configured item, but do not display the configure options. This is the default value. Hide Self: display the configure options, but do not display the configured item. Hide Self and Descendants: do not display the configured item or the configure options. You define this attribute for the configure options in Oracle Product Lifecycle Management Cloud. This attribute controls only the display. It does not filter items from the configurator. |
SourceTransactionRevisionNumber | Long | Revision number of the transaction in the source application. |
SourceTransactionScheduleId | String | Value that uniquely identifies the schedule, shipment, or subline. The source application assigns this value. |
SourceScheduleNumber | String | Number that the source application assigns for the schedule, shipment, or subline. |
SplitFromFlineId | Long | SplitFromFlineId of SalesOrdersForOrderHublines |
StatusCode | String | StatusCode of SalesOrdersForOrderHublines |
Status | String | Status of SalesOrdersForOrderHublines |
SubinventoryCode | String | Abbreviation that identifies the physical or logical location of the item. |
Subinventory | String | Physical or logical location of the item. |
SubstitutionAllowedFlag | Bool | Contains one of the following values: true or false. 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 do not allow the application to substitute. This attribute does not have a default value. |
SubstitutionReasonCode | String | Abbreviation that describes why the application substituted the item on the fulfillment line. |
SubstitutionReason | String | Describes why the application substituted the item on the fulfillment line. |
SupplierId | Long | Supplier for the purchase order. |
SupplierName | String | Name of the supplier that the application requested. |
SupplierSiteId | Long | Supplier site for the purchase order. |
SupplierSiteName | String | Name of the supplier site for the purchase order. |
SupplyStatusCode | String | Status of the supply for the fulfillment line. |
TaxClassificationCode | String | Abbreviation that identifies a group of taxes. |
TaxClassification | String | Group of taxes for reporting and processing. |
TaxExemptFlag | Bool | Abbreviation that identifies the tax exemption. This attribute is not currently used. |
TaxExemptCode | String | Abbreviation that identifies whether the fulfillment line is exempt from tax. Valid values include S and E. If S, then calculate standard tax. If E, then exempt from tax. A list of accepted values is defined in the lookup type ZX_EXEMPTION_CONTROL. |
TaxExempt | String | TaxExempt of SalesOrdersForOrderHublines |
TaxExemptReasonCode | String | Abbreviation that identifies the reason for the tax exemption. |
TaxExemptReason | String | Reason for the tax exemption. |
TaxInvoiceDate | Date | Tax invoice date that tax reporting uses depending on the requirements of different countries. |
TaxInvoiceNumber | String | Invoice number that tax reporting uses depending on the requirements of different countries. |
ThirdPartyTaxRegistration | Long | Registration number that the customer specifies in the purchase order. |
ThirdPartyTaxRegistrationNumber | String | Customer registration number that the customer specifies in the purchase order. |
TotalContractAmount | Double | Total amount for the contract duration according to the total contract quantity. |
TotalContractQuantity | Double | Total quantity for the contract duration including the number of timeframes for recurring billing. |
TradeComplianceDate | Datetime | TradeComplianceDate of SalesOrdersForOrderHublines |
TradeComplianceResultCode | String | TradeComplianceResultCode of SalesOrdersForOrderHublines |
TradeComplianceResult | String | TradeComplianceResult of SalesOrdersForOrderHublines |
TransportationPlannedFlag | Bool | Contains one of the following values: true or false. If true, then the transportation planning system plans the fulfillment line. If false, then the transportation planning system does not plan the fulfillment line. The default value is false. |
TransportationPlannedStatusCode | String | Abbreviation that indicates that a transportation planning application plans the fulfillment line. A list of accepted values is defined in the lookup type ORA_DOO_TP_STATUS. |
TransactionBusinessCategory | String | Tax classification that the tax authority requires. |
TransactionBusinessCategoryName | String | Name of the tax classification that the tax authority requires. |
UnitListPrice | Double | Selling price for each unit of the item before applying discounts. |
UnitQuantity | Double | Number of units for the item. |
UnitSellingPrice | Double | Price that the buyer pays for one unit of the item. |
UserDefinedFiscalClass | String | Tax classification that the user defines. |
UserDefinedFiscalClassName | String | Name of the tax classification that the user defines. |
ValidConfigurationFlag | Bool | Contains one of the following values: true or false. If true, then the configured item is valid. If false, then the configured item is not valid. The default value is set only for root lines based on configuration validation. This attribute is read-only. |
LineNumber | Int | LineNumber of SalesOrdersForOrderHublines |
DisplayLineNumber | String | DisplayLineNumber of SalesOrdersForOrderHublines |
ParentSourceTransactionLineId | String | Value that uniquely identifies the parent transaction line from the source application. This value describes the transaction line hierarchy for a configured item. |
TransformFromLineId | Long | TransformFromLineId of SalesOrdersForOrderHublines |
UnreferencedReturnFlag | Bool | UnreferencedReturnFlag of SalesOrdersForOrderHublines |
ServiceCancelDate | Datetime | Date when the customer canceled the coverage item or subscription item on the fulfillment line. |
CoveredProductId | Long | Value that uniquely identifies the inventory item that the coverage item covers. |
CoveredProductNumber | String | Number that identifies the inventory item that the coverage item covers. |
CoveredProductDescription | String | Description of the inventory item that the coverage item covers. |
CoveredCustomerProductId | Long | Value that uniquely identifies the customer item that the coverage item covers. |
CoveredCustomerProductNumber | String | Number that identifies the customer item that the coverage item covers. |
CoveredCustomerProductDescription | String | Description of the customer item that the coverage item covers. |
JeopardyPriorityCode | String | JeopardyPriorityCode of SalesOrdersForOrderHublines |
JeopardyPriority | String | JeopardyPriority of SalesOrdersForOrderHublines |
AgreementHeaderId | Long | Value that uniquely identifies the sales agreement on the order line. |
AgreementLineId | Long | AgreementLineId of SalesOrdersForOrderHublines |
AgreementLineNumber | String | AgreementLineNumber of SalesOrdersForOrderHublines |
AgreementVersionNumber | Long | AgreementVersionNumber of SalesOrdersForOrderHublines |
AgreementNumber | String | Number that identifies the sales agreement on the order line. |
SellingProfitCenterBusinessUnitId | Long | Value that uniquely identifies the selling profit center business unit. |
SellingProfitCenterBusinessUnitName | String | Name of the selling profit center business unit. |
TransportationPlanningOrder | String | TransportationPlanningOrder of SalesOrdersForOrderHublines |
ContractEndDateTime | Datetime | Date and time when the contract will end, according to the contract start date and time and duration. Review and update the value to map time units to the units of measure that the application uses using the Setup and Maintenance work area, and the Manage Time Units Mappings task. |
ContractStartDateTime | Datetime | Date and time when the contract is effective. |
SubscriptionProfileId | Long | Value that uniquely identifies the subscription profile. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
SubscriptionProfileName | String | Name of the subscription profile. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
ExternalPriceBookName | String | Name of the price book or price list in the external pricing application. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
EndReasonCode | String | Abbreviation that identifies the reason for ending or closing the subscription. A list of accepted values is defined in the lookup type ORA_OSS_CLOSE_REASONS. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
EndReason | String | Value that identifies the reason for ending or closing the subscription. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
EndCreditMethodCode | String | Abbreviation that identifies the credit method used for ending or closing the subscription. A list of accepted values is defined in the lookup type ORA_OSS_CLOSE_CREDIT_METHOD. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
EndCreditMethod | String | Value that identifies the credit method used for ending or closing the subscription. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
EndDate | Datetime | Date when the subscription ends. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
InventoryTransactionFlag | Bool | Contains one of the following values: true or false. If true, then Oracle Order Management Cloud sends a request to Oracle Inventory Management Cloud to perform an inventory transaction when fulfilling the order line instead of using the pick wave, pick, pack, and ship flow. If false, then Order Management uses the pick wave, pick, pack, and ship flow to fulfill the order line. The default value is false. |
InventoryInterfacedFlag | Bool | InventoryInterfacedFlag of SalesOrdersForOrderHublines |
PriceUsingSecondaryUOMFlag | Bool | PriceUsingSecondaryUOMFlag of SalesOrdersForOrderHublines |
SubscriptionInterfacedFlag | Bool | SubscriptionInterfacedFlag of SalesOrdersForOrderHublines |
SupplierAddress1 | String | SupplierAddress1 of SalesOrdersForOrderHublines |
SupplierAddress2 | String | SupplierAddress2 of SalesOrdersForOrderHublines |
SupplierAddress3 | String | SupplierAddress3 of SalesOrdersForOrderHublines |
SupplierAddress4 | String | SupplierAddress4 of SalesOrdersForOrderHublines |
SupplierCity | String | SupplierCity of SalesOrdersForOrderHublines |
SupplierState | String | SupplierState of SalesOrdersForOrderHublines |
SupplierPostalCode | String | SupplierPostalCode of SalesOrdersForOrderHublines |
SupplierProvince | String | SupplierProvince of SalesOrdersForOrderHublines |
SupplierCounty | String | SupplierCounty of SalesOrdersForOrderHublines |
SupplierCountry | String | SupplierCountry of SalesOrdersForOrderHublines |
RatePlanDocumentId | Long | RatePlanDocumentId of SalesOrdersForOrderHublines |
RatePlanDocument | String | Rate plan document in JSON format encoded using Base64. The rate plan document will be desupported in 23C. |
OrchestrationProcessName | String | Name of the orchestration process to assign to the line. |
IntegrateSubscriptionFlag | Bool | IntegrateSubscriptionFlag of SalesOrdersForOrderHublines |
DemandSourceLineReference | String | Value that uniquely identifies demand, such as the order line in a shopping cart on a web store or in an ecommerce application. For example, you create a sales order in a web store. Then the web store sends a request to Oracle Fusion Cloud Global Order Promising to schedule it. Oracle Global Order Promising schedules the demand and sends a reply to the web store. The web store then sends the sales order to Oracle Fusion Cloud Order Management. Finally, Oracle Order Management manages the order through fulfilment. |
DemandSourceScheduledFlag | Bool | DemandSourceScheduledFlag of SalesOrdersForOrderHublines |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
FromDate | Date | FromDate |
OrderKey | String | OrderKey |
OrderNumber | String | OrderNumber |
ToDate | Date | ToDate |
Finder | String | finder |