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

Manual Price Adjustment Information

Contains

Header Information for Price Waterfall

Contains

Sales Credit Information

Contains

Document References

Contains

Project Details

Contains

Billing Plan Information

Contains

Shipping and Billing Information

Contains

Payment Detail Information

Contains

Attribute Values for Transactional Items for Order Lines

Contains

Price Adjustment Information

Contains

Details About Holds on Order Lines

Contains

Attachment Information for Order and Order Lines

Contains

Price Validation Information

Contains

Serial Number Information for Returned Items

Contains

Extensible Flexfield Contexts, Grouped for Order Line

Contains

Attribute Details for Channel Programs

Contains

Asset Transaction Details

Contains

Subscription Term

Contained by

Order Header Information

Handled by

Order Information Service

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

Extensible Flexfield Contexts, Grouped for Order Line

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

Attribute Details for Channel Programs

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
  • Primary Key

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

Asset transaction details to support License Migration orders.

LineAttachment

Attachment Information for Order and Order Lines

It displays Attachment

LineBillingPlan

Billing Plan Information

Billing Plan of the line for tracking the recurring billing details

LineCharge

Header Information for Price Waterfall

Holds the header information for the pricing waterfall of a line

LineDetail

Shipping and Billing Information

Provides details of the Line with respect to the details for shipping & billing

LineDocumentReference

Document References

Provides various document references such as original order

LineHold

Details About Holds on Order Lines

Information that describes the holds on the order line.

LineIdentifier

long

Reference to the unique identifier for the orchestration order line

LineLotSerial

Serial Number Information for Returned Items

Lot Serial Information for returns

LineManualPriceAdjustment

Manual Price Adjustment Information

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 Detail Information

Payment information for the line

LinePriceAdjustment

Price Adjustment Information

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

Price Validation information for the line

LineSalesCredit

Sales Credit Information

Sales credit to track the credit that salespersons receives for this line

LineTransactionItemAttribute

Attribute Values for Transactional Items for Order Lines

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

Project Details

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.
  • Primary Key

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.
  • Primary Key

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

Subscription Term

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.