Attribute Information for Order Lines
Contains Information about the line such as item, quantity and various other attributes
QName: {http://xmlns.oracle.com/apps/scm/doo/decomposition/orderDetailServices/orderInformationService/}Line
Relationships
The following table describes how this service data object is related to other service data objects or business object services.
Relationship Type | Object or Service |
---|---|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contains |
|
Contained by |
|
Handled by |
Attributes
The following table describes attributes in the service data object.
Name | Type | Description |
---|---|---|
AccountingRule |
string |
Accounting rule that determines the accounting period or periods in which the revenue distributions for an invoice line are recorded. |
AccountingRuleCode |
string |
Code that represents an accounting rule that determines the accounting period or periods in which the revenue distributions for an invoice line are recorded. |
ActionType |
string |
Value that identifies the type of the action with respect to the coverage or the subscription product on fulfillment 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. |
ActualCompletionDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date when fulfillment line is processed completely. |
ActualCompletionDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date and time when fulfillment line is processed completely. |
ActualShipDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date the shipment was actually sent. |
ActualShipDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date and time the shipment was actually sent. |
AdditionalOrderLineInformationCategories |
Provides information on the FulfillLine Eff Categories. |
|
AgreementHeaderId |
long |
Value that uniquely identifies the sales agreement on the order line. |
AgreementLineId |
long |
Value that uniquely identifies the sales agreement line on the order line. |
AgreementLineNumber |
string |
Number that identifies the applicable sales agreement line. |
AgreementNumber |
string |
Number that identifies the applicable sales agreement. |
AgreementVersionNumber |
long |
Number that identifies the applicable sales agreement version. |
AppliedPriceListIdentifier |
long |
Id of the price list that has been applied |
AssessableValue |
decimal |
Price at which a product is valued by a tax authority for a given tax. |
BillToAccountContactIdentifier |
long |
Reference to the unique identifier for the bill-to customer contact |
BillToAccountContactName |
string |
Reference to the BillToAccountContactName. |
BillToAccountContactNumber |
string |
Reference to the BillToAccountContactNumber. |
BillToAccountPersonFirstName |
string |
Reference to the BillToAccountPersonFirstName |
BillToAccountPersonLastName |
string |
Reference to the BillToAccountPersonLastName |
BillToAccountPersonMiddleName |
string |
Reference to the BillToAccountPersonMiddleName |
BillToAccountPersonNameSuffix |
string |
Reference to the BillToAccountPersonNameSuffix |
BillToAccountPersonTitle |
string |
Reference to the BillToAccountPersonTitle |
BillToAccountSiteUseIdentifier |
long |
Reference to the unique identifier for the bill-to customer location |
BillToAddress1 |
string |
Reference to the BillToAddress1 |
BillToAddress2 |
string |
Reference to the BillToAddress2 |
BillToAddress3 |
string |
Reference to the BillToAddress3 |
BillToAddress4 |
string |
Reference to the BillToAddress4 |
BillToCity |
string |
Reference to the BillToCity |
BillToContactFirstName |
string |
Reference to the BillToContactFistName |
BillToContactLastName |
string |
Reference to the BillToContactLastName |
BillToContactMiddleName |
string |
Reference to the BillToContactMiddleName |
BillToContactNameSuffix |
string |
Reference to the BillToContactNameSuffix |
BillToContactTitle |
string |
Reference to the BillToContactTitle |
BillToCountry |
string |
Reference to the BillToCountry |
BillToCounty |
string |
Reference to the BillToCounty |
BillToCustomerIdentifier |
long |
Identifier of the party legally responsible for the payment. |
BillToCustomerName |
string |
Reference to the BillToCustomerName. |
BillToCustomerNumber |
string |
Number of the party legally responsible for the payment. |
BillToPostalCode |
string |
Reference to the BillToPostalCode |
BillToProvince |
string |
Reference to the BillToProvince |
BillToState |
string |
Reference to the BillToState |
BuyerFirstName |
string |
Holds Buyer First Name information for a schedule. |
BuyerIdentifier |
long |
Holds Buyer information for a schedule, this is a reference column and it is referenced to BUYER PUBLIC VIEW that is published by purchase Order product. |
BuyerLastName |
string |
Holds Buyer Last Name information for a schedule |
BuyerMiddleName |
string |
Holds Buyer Middle Name information for a schedule |
BuyerName |
string |
Holds Buyer Full Name information for a schedule. |
CancelReason |
string |
Reason the line was canceled. |
CancelReasonCode |
string |
Code that represents the reason the line was canceled. |
CanceledFlag |
boolean |
Indicates that the order line is canceled. |
CanceledQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Canceled quantity. |
CancellationEffectiveDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date when the cancellation of the service item becomes effective. |
ChangeEligibleFlag |
boolean |
Indicates whether the Line as a whole is eligible for modification by the user. |
ChannelProgram |
The Channel Program resource manages the channel programs of a sales order line. |
|
Comments |
string |
Comments for the line. |
ComponentIdPath |
string |
Inventory item ID path to the parent of this item line. |
ConfigCreationDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when configuration is created. This attribute will be populated with the system date when a configuration is first created. |
ConfigHeaderIdentifier |
long |
Header Id of the configuration. |
ConfigInventoryItemDescription |
string |
Configuration Item that is being manufactured and shipped for the ATO models |
ConfigInventoryItemIdentifier |
long |
Inventory item of shippable ATO configuration |
ConfigInventoryItemNumber |
string |
Configuration Item that is being manufactured and shipped for the ATO models |
ConfigItemReference |
string |
Configuration Finished Good Reference. |
ConfigRevisionNumber |
long |
Revision number of the configuration. It is populated for the root line by Oracle Fusion Configurator. |
ConfiguratorPath |
string |
Runtime representation of the Inventory Item Id path to the component. Path format is ""."" Separated inventory item id. For multi-instantiable components instances are denoted by [<instance number>]. |
ContractEndDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
End date of the contract. |
ContractEndDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
End date and time of the contract. |
ContractStartDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Start date of the contract. |
ContractStartDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Start date and time of the contract. |
CoveredCustomerProductDescription |
string |
Product description of the customer item that the coverage item covers. |
CoveredCustomerProductId |
string |
Value that uniquely identifies the customer item that the coverage item covers. |
CoveredCustomerProductNumber |
string |
Product number of the customer item that the coverage item covers. |
CoveredProductDescription |
string |
Product description of the customer item that the coverage item covers. |
CoveredProductIdentifier |
string |
Value that uniquely identifies the inventory item that the coverage item covers. |
CoveredProductNumber |
string |
Stock keeping Unit (SKU) of the inventory item that the coverage item covers. |
CoveredProductSrcsysReference |
string |
Reference that represents the covered item in the system that captured the transaction |
CreditCheckAuthCode |
string |
The unique identifier for the approved credit authorization created in credit management system on the requested authorized amount for the customer account specified. This is only applicable for credit check of type `Authorization' and `Re-Authorization'. |
CreditCheckAuthExpiryDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date on which the approved credit authorization will expire. |
CustomerPOLineNumber |
string |
Unique identifier of the line record of a transaction. The purchase order line describes an item or service, with a price and quantity ordered. |
CustomerPONumber |
string |
Commercial document that is used to request that a seller supply a product or service in return for payment. |
CustomerPOScheduleNumber |
string |
Contains the customer's purchase order shipment schedule number, if specified, while submitting an order. |
CustomerProductDescription |
string |
Description of the customer item |
CustomerProductIdentifier |
long |
Unique identifier of the customer item. |
CustomerProductNumber |
string |
Number of the customer item |
DefaultTaxationCountry |
string |
Country used for tax calculation purposes. |
DefaultTaxationCountryShortName |
string |
Specifies the taxation country for tax calculation purposes. |
DemandClass |
string |
Grouping of customers. Demand classes can represent different sources of demand, such as retail, mail order, and wholesale. |
DemandClassCode |
string |
Demand class used by the order promising engine to consume target allocation amounts. |
DestinationShippingAddressCity |
string |
Reference to the DestinationShippingAddressCity |
DestinationShippingAddressCountry |
string |
Reference to the DestinationShippingAddressCountry |
DestinationShippingAddressCounty |
string |
Reference to the DestinationShippingAddressCounty |
DestinationShippingAddressLine1 |
string |
Reference to the DestinationShippingAddressLine1 |
DestinationShippingAddressLine2 |
string |
Reference to the DestinationShippingAddressLine2 |
DestinationShippingAddressLine3 |
string |
Reference to the DestinationShippingAddressLine3 |
DestinationShippingAddressLine4 |
string |
Reference to the DestinationShippingAddressLine4 |
DestinationShippingAddressPostalCode |
string |
Reference to the DestinationShippingAddressPostalCode |
DestinationShippingAddressProvince |
string |
Reference to the DestinationShippingAddressProvince |
DestinationShippingAddressState |
string |
Reference to the DestinationShippingAddressState |
DestinationShippingLocationIdentifier |
long |
Destination Location to which the product is Shipped |
DestinationShippingOrganizationCode |
string |
Reference to the DestinationShippingOrganizationCode. |
DestinationShippingOrganizationIdentifier |
long |
Destination Org to which the product is Shipped |
DestinationShippingOrganizationName |
string |
Reference to the DestinationShippingOrganizationName. |
DisplayLineNumber |
string |
Line number for display purposes |
DocumentSubType |
string |
Classification that is used for tax calculation and tax reporting, depending upon the requirements of different countries. |
DocumentSubTypeName |
string |
Used for tax calculation and tax reporting, depending upon the requirements of different countries. |
EarliestAcceptableShipDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
EarliestAcceptableShipDate Earliest date that the customer is willing to receive a shipment. EarliestAcceptableShipDate |
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. |
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. |
EndDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date when the subscription ends. 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. |
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. |
EstimateFulfillmentCost |
long |
The estimated cost it will take to deliver a fulfillment line to a customer. The figure includes item cost as well as shipping cost. |
EstimateMargin |
long |
The estimated margin expected when shipping a particular fulfillment line. |
ExtendedAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Monetary amount of the order line quantity. |
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. |
FOBPoint |
string |
Point at which the responsibility of the goods transfers from shipper to buyer. |
FOBPointCode |
string |
Code that indicates the point at which the responsibility of the goods transfers from shipper to buyer. |
FinalDischargeLocationAddressCity |
string |
Reference to the FinalDischargeLocationAddressCity. |
FinalDischargeLocationAddressCountry |
string |
Reference to the FinalDischargeLocationAddressCountry. |
FinalDischargeLocationAddressCounty |
string |
Reference to the FinalDischargeLocationAddressCounty. |
FinalDischargeLocationAddressLine1 |
string |
Reference to the FinalDischargeLocationAddressLine1. |
FinalDischargeLocationAddressLine2 |
string |
Reference to the FinalDischargeLocationAddressLine2. |
FinalDischargeLocationAddressLine3 |
string |
Reference to the FinalDischargeLocationAddressLine3. |
FinalDischargeLocationAddressLine4 |
string |
Reference to the FinalDischargeLocationAddressLine4. |
FinalDischargeLocationAddressPostalCode |
string |
Reference to the FinalDischargeLocationAddressPostalCode. |
FinalDischargeLocationAddressProvince |
string |
Reference to the FinalDischargeLocationAddressProvince. |
FinalDischargeLocationAddressState |
string |
Reference to the FinalDischargeLocationAddressState. |
FinalDischargeLocationIdentifier |
long |
This is the final destination location for the purchases made by the customer. |
FirstPartyTaxRegistration |
long |
Registration number that is quoted to the supplier. The supplier uses this number to tax the transaction. |
FirstPartyTaxRegistrationNumber |
string |
Registration number that is quoted to the supplier. Supplier uses this number to tax the transaction. |
FreightTerms |
string |
Terms specifying the responsibility for freight charges, such as paid by shipper, collect, or prepaid. |
FreightTermsCode |
string |
Code that represents the terms specifying the responsibility for freight charges. |
FulfillInstanceIdentifier |
long |
Reference to the unique identifier for the fulfillment instance |
FulfillLineIdentifier |
long |
Unique Identifier for a fulfillment line
|
FulfillLineNumber |
long |
Numerical value associated to fulfillment line. It is defaulted to 1 and increments in integers as fulfillment lines split. |
FulfillLineOnHoldFlag |
boolean |
Indicates fulfillment lines are not accepting further processing. |
FulfillToleranceAbove |
long |
Not supported |
FulfillToleranceBelow |
long |
Not supported |
FulfillUpdateParentReferenceId |
long |
Unique Identifier of the parent fulfillment line id which resulted the split after partial fulfillment. |
FulfilledQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Quantity used to fulfill the order line. |
FulfillmentDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date when the order line is fulfilled (Goods shipped, hardware installed etc.). |
FulfillmentDateTime |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date and Time when the order line is fulfilled (Goods shipped, hardware installed etc.). |
FulfillmentSplitReferenceIdentifier |
long |
Reference to the unique identifier of the source fulfillment line in the case of a split. |
HeaderIdentifier |
long |
Reference to the unique identifier for the orchestration order |
IntendedUseClassificationIdentifier |
long |
Unique identifier of the classification for intended use of the item for tax calculation purposes. |
IntendedUseClassificationName |
string |
Classification name for intended use for tax calculation purposes. |
InventoryInterfacedFlag |
boolean |
Contains one of the following values: true or false. If true, then Oracle Order Management Cloud successfully interfaced the fulfillment line to Oracle Inventory Management Cloud. If false, then Order Management didn't interface the fulfillment line. |
InventoryOrganization |
string |
Code of the inventory organization that the product belongs to. |
InventoryOrganizationIdentifier |
long |
Unique identifier of the inventory organization. |
InventoryOrganizationName |
string |
Name of the inventory organization that the product belongs to. |
InventoryTransactionFlag |
boolean |
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. |
InvoiceEnabledFlag |
boolean |
Indicator implying the line / item qualifies for billing |
InvoiceableItemFlag |
boolean |
This fulfillment line has an item that is enabled for billing or invoicing. |
InvoicingRule |
string |
Invoicing rule that determine when to recognize a receivable for invoices. |
InvoicingRuleCode |
string |
Code that represents invoicing rules that determine when to recognize a receivable for invoices. |
ItemSubTypeCode |
string |
More specific sub group for ITEM_TYPE_CODE. Model/Service/One-Time Item characteristic detail (like ATO, PTOSMC, PTONONSMC). |
ItemTypeCode |
string |
Indicates a grouping of all items of a particular type that share the same set of item attributes |
JeopardyPriority |
string |
The jeopardy priority associated with the line. |
LatestAcceptableArrivalDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Latest date that the customer is willing to receive a product. |
LatestAcceptableShipDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Latest date that the customer is willing to have a warehouse ship a product. |
LineAssetTransactionDetail |
Asset transaction details to support License Migration orders. |
|
LineAttachment |
It displays Attachment |
|
LineBillingPlan |
Billing Plan of the line for tracking the recurring billing details |
|
LineCharge |
Holds the header information for the pricing waterfall of a line |
|
LineDetail |
Provides details of the Line with respect to the details for shipping & billing |
|
LineDocumentReference |
Provides various document references such as original order |
|
LineHold |
Information that describes the holds on the order line. |
|
LineIdentifier |
long |
Reference to the unique identifier for the orchestration order line |
LineLotSerial |
Lot Serial Information for returns |
|
LineManualPriceAdjustment |
Manual Price Adjustment information for the line |
|
LineNumber |
long |
Representation of a sales order line used in communication with fulfillment systems. |
LineOnHoldFlag |
boolean |
Indicates an order line is not accepting further processing. |
LinePayment |
Payment information for the line |
|
LinePriceAdjustment |
Contain information on the Price Adjustments such as discounts, promotions of a Line in the older pricing model. The entity also stores the costs |
|
LinePriceValidation |
Price Validation information for the line |
|
LineSalesCredit |
Sales credit to track the credit that salespersons receives for this line |
|
LineTransactionItemAttribute |
Transaction Item Attributes of an item |
|
ModifiedFlag |
boolean |
Indicates that the row has been modified in the version currently submitted |
OpenFlag |
boolean |
Indicates that the status of an order line that is not closed or canceled. |
OrderProject |
Information on project attributes captured in the Sales Order |
|
OrderedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Quantity of an ordered good or service. |
OrderedUOM |
string |
Unit of measure for the quantity ordered. A predetermined amount, quantity, or quality that is adopted as a standard of measurement. Examples: length, time, heat, value. |
OrderedUOMCode |
string |
Unit of measure for the quantity ordered. A predetermined amount, quantity, or quality that is adopted as a standard of measurement. Examples: length, time, heat, value. |
OrigSystemDocumentLineReference |
string |
Original document reference of the order line in the system that captured the transaction. |
OrigSystemDocumentReference |
string |
Original document reference of the orchestration order in the system that captured the transaction. |
OverFulfillmentTolerance |
decimal |
Percentage of quantity that can be fulfilled above the ordered quantity. |
OverrideScheduleDateFlag |
boolean |
Indicates that the user can override the scheduling data manually. |
OwnerIdentifier |
long |
DOO user who is responsible for the orchestration order line |
PackingInstructions |
string |
Document that contains information concerning the packing of an item. |
ParentFulfillLineIdentifier |
long |
Used in fulfillment line hierarchies (models) to identify the immediate parent fulfillment line. |
ParentLineReference |
string |
Alphanumeric reference of the line that is the immediate parent of this line in a configurable product hierarchy or in any other situation with parent-child relationships. |
PartialShipAllowedFlag |
boolean |
Indicates that the items on the order can be shipped in multiple shipments, rather than as one shipment. |
PaymentTerms |
string |
Payment terms to apply to collect this payment. |
PaymentTermsCode |
string |
Code that represents payment terms to apply to collect this payment. |
PreferredBillToContactPointIdentifier |
long |
Identifier of a bill-to contact point. |
PreferredShipToContactPointIdentifier |
long |
Identifier of a ship-to contact point |
PriceUsingSecondaryUOMFlag |
boolean |
Contains Y, N, or empty. Y: Order management uses secondary ordered quantity and secondary unit of measure to price the order line. N or empty: Order management uses ordered quantity and ordered unit of measure to price the order line |
PricedOn |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the line is priced. This attribute will be populated with the system date at the beginning of a pricing process |
ProductCategory |
string |
Product classification for tax purposes. |
ProductCategoryName |
string |
Used to classify products for tax purposes. It is used where Oracle Fusion Inventory is not installed, or is installed but not used for classifying products for tax purposes. |
ProductDescription |
string |
Display Name of the product that is being fulfilled. |
ProductFiscalCategoryIdentifier |
long |
Unique identifier of the classification of the products by tax authority for tax purposes. |
ProductFiscalCategoryName |
string |
Classification of the product by tax authority for tax purposes. |
ProductIdentifier |
long |
Unique identifier of the inventory item. |
ProductNumber |
string |
SKU of product that is being fulfilled. |
ProductType |
string |
Product-related classification in Oracle Fusion Tax. The value of the product type specifies whether the transaction line is for a good or service, or whether it is a memo line. |
ProductTypeName |
string |
Product-related classification in Oracle Fusion Tax. The value of product type specifies whether the transaction line is for a good, or a service, or it is a memo line. |
PromiseArrivalDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date that was promised to the customer that the item would arrive. |
PromiseShipDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date that was promised to the customer that the item would ship. |
PurchasingEnabledFlag |
boolean |
"Indicates whether the item on the fulfillment line may be included on a Purchase Order for fulfilling the underlying source order line" |
PurchasingUOM |
string |
UOM Code in which the Procurement system placed the Purchase Order with the supplier |
QuantityPERModel |
decimal |
Component quantity for a single model. |
RMADeliveredQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The quantity delivered against the receipt line. |
RemnantFlag |
boolean |
Indicates that there was partial fulfillment of a model |
RequestCancelDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date that the customer canceled the line. |
RequestType |
string |
Indicates if the scheduling request is of type SHIP or ARRIVAL. |
RequestedArrivalDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Original date the customer requested the to item arrive. |
RequestedFulfillmentOrganizationAddress1 |
string |
Reference to the RequestedFulfillmentOrganizationAddress1. |
RequestedFulfillmentOrganizationAddress2 |
string |
Reference to the RequestedFulfillmentOrganizationAddress2. |
RequestedFulfillmentOrganizationAddress3 |
string |
Reference to the RequestedFulfillmentOrganizationAddress3. |
RequestedFulfillmentOrganizationAddress4 |
string |
Reference to the RequestedFulfillmentOrganizationAddress4. |
RequestedFulfillmentOrganizationCity |
string |
Reference to the RequestedFulfillmentOrganizationCity. |
RequestedFulfillmentOrganizationCode |
string |
Code that represents the organization from which the product was shipped. |
RequestedFulfillmentOrganizationCountry |
string |
Reference to the RequestedFulfillmentOrganizationCountry. |
RequestedFulfillmentOrganizationCounty |
string |
Reference to the RequestedFulfillmentOrganizationCounty. |
RequestedFulfillmentOrganizationIdentifier |
long |
Unique identifier of the fulfillment organization. |
RequestedFulfillmentOrganizationName |
string |
Name that represents the organization from which the product was shipped. |
RequestedFulfillmentOrganizationPostalCode |
string |
Reference to the RequestedFulfillmentOrganizationPostalCode. |
RequestedFulfillmentOrganizationProvince |
string |
Reference to the RequestedFulfillmentOrganizationProvince. |
RequestedFulfillmentOrganizationState |
string |
Reference to the RequestedFulfillmentOrganizationState. |
RequestedShipDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Original date the customer requested the item to ship. |
RequestedSupplierCode |
string |
This will hold the value for Supplier on whom Purchase Order is created. |
RequestedSupplierName |
string |
Reference to the RequestedSupplierName. |
RequestedSupplierNumber |
string |
Reference to the RequestedSupplierNumber. |
RequestedSupplierSiteCode |
string |
This will hold the value for Supplier Site on whom Purchase Order is created. |
RequiredFulfillmentDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Customer required fulfillment date. |
RequisitionBusinessUnitIdentifier |
long |
Maps to BU Id as per Fusion Enterprise structure. |
RequisitionInventoryOrganizationIdentifier |
long |
Maps to Organization Id as per Fusion Enterprise structure. |
ReservableFlag |
boolean |
Indicates that an item on the fulfillment line can be reserved. |
ReservationIdentifier |
string |
Reference to the unique identifier for the reservation. |
ReservedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Quantity of an item that was set aside in a warehouse specifically to fulfill the demand from a given fulfillment line. |
ReturnReason |
string |
Reason expressed by customer for wanting to return the product. |
ReturnReasonCode |
string |
Code that represents the justification for a return of a specific product. Many companies have standard reasons that are assigned to returns to be used to analyze the quantity and types of returns. |
ReturnableFlag |
boolean |
Indicates that the item can be returned to the supplier. |
RootParentFulfillLineIdentifier |
long |
Used in fulfillment line hierarchies (models) to identify the highest fulfillment line in the hierarchy. |
RootParentLineReference |
string |
Alphanumeric reference of the line at the root of the configurable product hierarchy that the line is a component of. |
Salesperson |
string |
A person who is responsible for the sale of the Order or Line. |
SalespersonIdentifier |
long |
Primary Sales person identifier. |
ScheduleArrivalDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date the shipment is scheduled to arrive. |
ScheduleShipDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date when goods are expected to be shipped. |
SchedulingReason |
string |
To capture Scheduling Reason |
SchedulingReasonCode |
string |
To capture Scheduling Reason |
SecondaryFulfilledQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Fulfilled quantity on the fulfillment line for the item or service in the secondary unit of measure. This attribute applies when you use more than one unit of measure to measure and track the item |
SecondaryOrderedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Ordered quantity on the fulfillment line for the item or service in the secondary unit of measure. This attribute applies when you use more than one unit of measure to measure and track the item. |
SecondaryRMADeliveredQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Delivered quantity on the fulfillment line for the returned item or service in the secondary unit of measure. This attribute applies when you use more than one unit of measure to measure and track the item. |
SecondaryShippedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Shipped quantity on the fulfillment line for the item or service in the secondary unit of measure. This attribute applies when you use more than one unit of measure to measure and track the item. |
SecondaryUOM |
string |
Secondary unit of measure for the ordered quantity on the fulfillment line. For example, length,time, heat, value, and so on. This attribute applies when you use more than one unit of measure to measure and track the item. |
SecondaryUOMCode |
string |
Secondary unit of measure for the ordered quantity on the fulfillment line. For example, length,time, heat, value, and so on. This attribute applies when you use more than one unit of measure to measure and track the item. |
SellingProfitCenterBusinessUnit |
string |
Selling profit center business unit for the transaction line. |
SellingProfitCenterBusinessUnitIdentifier |
long |
Uniquely identifies selling profit center business unit for the transaction line. |
ServiceDuration |
decimal |
Captures duration for the coverage or subscription product on the fulfillment line. |
ServiceDurationPeriodCode |
string |
Identifies duration unit of measure code for the coverage or subscription product on the fulfillment line. |
ServiceDurationPeriodName |
string |
Identifies duration unit of measure name for the coverage or subscription product on the fulfillment line. |
ShipSetName |
string |
Group of order lines within an order that need to ship together from their common origin to a common destination and which have the same scheduled ship date. |
ShipToAddress1 |
string |
Reference to the ShipToAddress1 |
ShipToAddress2 |
string |
Reference to the ShipToAddress2 |
ShipToAddress3 |
string |
Reference to the ShipToAddress3 |
ShipToAddress4 |
string |
Reference to the ShipToAddress4 |
ShipToAddressOrigSystemReference |
string |
Cross Reference Value for the Party site. |
ShipToCity |
string |
Reference to the ShipToCity |
ShipToContactFirstName |
string |
Reference to the ShipToContactFirstName |
ShipToContactLastName |
string |
Reference to the ShipToContactLastName |
ShipToContactMiddleName |
string |
Reference to the ShipToContactMiddleName |
ShipToContactNameSuffix |
string |
Reference to the ShipToContactNameSuffix |
ShipToContactTitle |
string |
Reference to the ShipToContactTitle |
ShipToCountry |
string |
Reference to the ShipToCountry |
ShipToCounty |
string |
Reference to the ShipToCounty |
ShipToPartyContactIdentifier |
long |
Reference to the unique identifier for the ship-to Party Contact. |
ShipToPartyContactName |
string |
Reference to the ShipToPartyContactName. |
ShipToPartyContactNumber |
string |
Reference to the ShipToPartyContactNumber. |
ShipToPartyContactOrigSystemReference |
string |
Cross Reference Value for the Party Contact. |
ShipToPartyIdentifier |
long |
Indicates the party the goods are to be sent. |
ShipToPartyName |
string |
Reference to the ShipToPartyName. |
ShipToPartyNumber |
string |
Indicates the party number the goods are to be sent. |
ShipToPartyPersonFirstName |
string |
Reference to the ShipToPartyPersonFirstName |
ShipToPartyPersonLastName |
string |
Reference to the ShipToPartyPersonLastName |
ShipToPartyPersonMiddleName |
string |
Reference to the ShipToPartyPersonMiddleName |
ShipToPartyPersonNameSuffix |
string |
Reference to the ShipToPartyPersonNameSuffix |
ShipToPartyPersonTitle |
string |
Reference to the ShipToPartyPersonTitle |
ShipToPartySiteIdentifier |
long |
Reference to the unique identifier for the ship-to Party Site. |
ShipToPostalCode |
string |
Reference to the ShipToPostalCode |
ShipToProvince |
string |
Reference to the ShipToProvince |
ShipToState |
string |
Reference to the ShipToState |
ShipmentPriority |
string |
Priority categorization that can be used to group shipments by urgency. |
ShipmentPriorityCode |
string |
Code that represents the priority of the fulfillment lines to be shipped. |
ShippableFlag |
boolean |
Indicates whether a line can be shipped to a customer. |
ShippedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Quantity of product on an order line that is shipped. |
ShippedUOM |
string |
Unit of Measure for the quantity shipped |
ShippingCarrier |
string |
Shipping carrier that delivered the goods. |
ShippingInstructions |
string |
Message on a document that provides details about cargo and any requirements for its physical movement. |
ShippingMode |
string |
Shipping mode that was actually used to deliver the goods. |
ShippingModeCode |
string |
Code that represents the type of transportation used to ship the product, such as truck, air, or boat. |
ShippingServiceLevel |
string |
Level of service to be used for delivery of the shipment. |
ShippingServiceLevelCode |
string |
Code that represents the priority of transportation that affects how quickly goods are transported. |
ShowInSales |
long |
"Indicates whether to show the Line Item in Sales Summary page including Configurator summary page. This is an Item component attribute defined in PIM during structure creation. This attribute only controls the display and does not filter Line Items from configurator output results. This column can have one of three values: 1: Yes - Item is always shown (default), 2: Hide Self - Item is hidden, child items will be moved up in the summary display, 3: Hide Self and Descendants - Item and its hierarchy will be hidden in summary display." |
SourceSystemProductReference |
string |
Reference that represents the product in the system that captured the transaction. |
SourceTransactionIdentifier |
string |
Unique identifier of the transaction in the system that captured the transaction. |
SourceTransactionLineIdentifier |
string |
Unique identifier of the transaction line from the system that captured the transaction.
|
SourceTransactionLineNumber |
string |
Number of the transaction line from the system that captured the transaction. |
SourceTransactionNumber |
string |
Order Capture order number that is the origin of the contract line. |
SourceTransactionScheduleIdentifier |
string |
Unique identifier of a schedule, shipment, or subline, as assigned by the system that captured the transaction.
|
SourceTransactionScheduleNumber |
string |
Number of a schedule, shipment, or subline, as assigned by the system that captured the transaction. |
SourceTransactionSystem |
string |
System or application that submitted the order request. |
SplitFromFlineIdentifier |
long |
Reference to the original fulfillment line in the event that splits occur. |
StatusCode |
string |
Status of the orchestration order line. |
SubInventory |
string |
Physical or logical location of the item. |
SubInventoryCode |
string |
Code that represents the physical or logical location of the item. |
SubscriptionInterfacedFlag |
boolean |
Contains one of the following values: true or false. If true, then the fulfillment line is interfaced to Oracle Subscription Management Cloud. If false, then the fulfillment line isn't interfaced to Subscription Management. The default value is false. This attribute is read-only. |
SubscriptionProfileIdentifier |
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. |
SubscriptionTerm |
Pricing term for the service items. This is available for use with the Integrate Order Management with Subscription Management to Process Subscriptions or Coverages features. |
|
SubstitutionAllowedFlag |
boolean |
Indicates that items on the fulfillment line can be substituted for various reasons like shortage of material, or as a goodwill gesture to the customer. |
SubstitutionReasonCode |
string |
Code that describes why an item was substituted on a fulfillment line. |
SupplierAddressCity |
string |
This will hold the value for Supplier City on whom Purchase Order is created. |
SupplierAddressCountry |
string |
This will hold the value for Supplier Country on whom Purchase Order is created. |
SupplierAddressCounty |
string |
This will hold the value for Supplier County on whom Purchase Order is created. |
SupplierAddressLine1 |
string |
This will hold the value for Supplier Address 1 on whom Purchase Order is created. |
SupplierAddressLine2 |
string |
This will hold the value for Supplier Address 2 on whom Purchase Order is created. |
SupplierAddressLine3 |
string |
This will hold the value for Supplier Address 3 on whom Purchase Order is created. |
SupplierAddressLine4 |
string |
This will hold the value for Supplier Address 4 on whom Purchase Order is created. |
SupplierAddressProvince |
string |
This will hold the value for Supplier Address Province on whom Purchase Order is created. |
SupplierAddressState |
string |
This will hold the value for Supplier State on whom Purchase Order is created. |
SupplierAddressZipCode |
string |
This will hold the value for Supplier Zip Code on whom Purchase Order is created. |
SupplyStatusCode |
string |
Status of the supply for the fulfillment line. |
TaxClassification |
string |
Grouping of taxes for reporting and processing purposes. |
TaxClassificationCode |
string |
Code that represents a grouping of taxes for reporting and processing purposes. |
TaxExempt |
string |
Indicates that a quote or fulfillment line is exempt from taxes. |
TaxExemptReason |
string |
Reason that a tax exemption was granted and taken. |
TaxExemptReasonCode |
string |
Code that represent the reason a tax exemption was granted and taken. |
TaxExemptionCertificateNumber |
string |
Certification number of tax exemption granted by taxing authority for tax exempt customers. |
ThirdPartyTaxRegistration |
long |
Registration number specified by the customer in the purchase order. |
ThirdPartyTaxRegistrationNumber |
string |
Customer registration number that is specified by the customer on the purchase order. |
TransactionBusinessCategory |
string |
Classification of a transaction for tax purposes as required by a tax authority. |
TransactionBusinessCategoryName |
string |
Classification or categorization of a transaction for tax purposes as required by a tax authority. |
TransactionCategoryCode |
string |
Code used to group and process journal entries with similar characteristics, such as adjustments, accruals, or reclassifications. |
TransactionLineType |
string |
Type of line or action in the channel system. Some example values are Buy, Replace With, Return For Credit, and Upgrade. |
TransactionLineTypeCode |
string |
Defines the system behavior for the order line transaction, in terms of values required, defaulted, and displayed. |
TransformFromLineIdentifier |
long |
Reference to the unique identifier for the orchestration order line ...Denotes the line id received from OC from which this particular lineid is derived |
TransportationPlanningStatus |
string |
Indicates the transportation planning status of the fulfillment line. |
UnderFulfillmentTolerance |
decimal |
Percentage of quantity that can be fulfilled below the ordered quantity. |
UnitListPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Base selling price before applying discounts. It typically defaults from the item definition. |
UnitQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Requested component quantity of a child option for one unit of a parent item component in a configuration. |
UnitSellingPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Price per unit that a buyer paid for an item. |
UnreferencedReturnFlag |
boolean |
Identify return that does not include a reference order. |
UserDefinedFiscClass |
string |
Classification of the transaction into different categories for tax purposes. |
UserDefinedFiscClassName |
string |
Classification of the transaction into different categories for tax purposes. |
ValidConfigurationFlag |
boolean |
Indicates the valid status of the configuration. This is populated only for the Root line. |