JDBC Driver for Oracle Fusion Cloud SCM

Build 23.0.8839

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

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
FromDate Date FromDate
OrderKey String OrderKey
OrderNumber String OrderNumber
ToDate Date ToDate
Finder String finder

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839