Fulfillment Line Information in Fulfillment System Response
Processing details that the fulfillment system sends about the fulfillment line, such as the status of the fulfillment transaction.
QName: {http://xmlns.oracle.com/apps/scm/doo/taskLayer/commonService/}FulfillLine
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 |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
ActualCompletionDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when fulfillment line is processed completely. |
|
ActualShippedDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date the shipment was actually sent. |
|
AdditionalFulfillLineInformationCategories |
Provides information on the FulfillLine Eff Categories. |
|
|
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. |
|
BuyerName |
string |
Name of the buyer responsible for a drop ship purchase order. |
|
Charge |
Details about charges that the fulfillment system sends in the context of the fulfillment transaction. |
|
|
ConfigItemReference |
string |
Reference to the identifier of the finished ATO item in an ERP system where the fulfillment of the finished item is done by that ERP system. |
|
CreditChkAuthExpDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date on which the approved credit authorization will expire. |
|
CreditChkAuthNumber |
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. |
|
DefaultTaxationCountry |
string |
Country used for tax calculation purposes. |
|
DefaultTaxationCountryShortName |
string |
Short name of the country used for tax calculation purposes. |
|
DocumentSubType |
string |
Classification that is used for tax calculation and tax reporting, depending upon the requirements of different countries. |
|
DocumentSubTypeName |
string |
Name of Document Sub Type used for tax calculation and tax reporting depending upon the requirements of different countries. |
|
DownstreamSalesOrderLineNumber |
string |
Reference to the order line created in the external fulfillment system for this fulfillment line. |
|
DownstreamSalesOrderNumber |
string |
Reference to the order created in the external fulfillment system for this fulfillment line. |
|
EBSOrderIdentifier |
string |
Identifier of the order created in EBS for fulfillment of this line in that application. |
|
EBSOrderLineIdentifier |
string |
Identifier of the order line created in EBS for fulfillment of this line in that application. |
|
EarliestAcceptableShipDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Earliest date that the customer is willing to receive a shipment. |
|
EstimatedFulfillmentCostAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The estimated cost it will take to deliver a fulfillment line to a customer. The figure includes item cost as well as shipping cost. NOTE: DO NOT map the currencyCode attribute since this amount is always expressed in the transactional currency of the order. If currencyCode is populated, it will be ignored. |
|
EstimatedMarginAmount |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
The estimated margin expected when shipping the fulfillment line. NOTE: DO NOT map the currencyCode attribute since this amount is always expressed in the transactional currency of the order. If currencyCode is populated, it will be ignored. |
|
ExemptionCertificateNumber |
string |
Tax exemption certificate number. |
|
ExtendedFulfillmentLineNumber |
long |
Extended fulfill line key that is used for communication with fulfillment systems. |
|
ExternalInteractionKey |
string |
An alternate way of uniquely identifying an object instance. |
|
FinalDischargeLocationAddressLine1 |
string |
Address Line 1 of the final destination location for the purchases made by the customer. |
|
FinalDischargeLocationAddressLine2 |
string |
Address Line 2 of the final destination location for the purchases made by the customer. |
|
FinalDischargeLocationAddressLine3 |
string |
Address Line 3 of the final destination location for the purchases made by the customer. |
|
FinalDischargeLocationAddressLine4 |
string |
Address Line 4 of the final destination location for the purchases made by the customer. |
|
FinalDischargeLocationCity |
string |
City of the final destination location for the purchases made by the customer. |
|
FinalDischargeLocationCountry |
string |
Country of the final destination location for the purchases made by the customer. |
|
FinalDischargeLocationCounty |
string |
County of the final destination location for the purchases made by the customer. |
|
FinalDischargeLocationIdentifier |
long |
This is the final destination location for the purchases made by the customer. |
|
FinalDischargeLocationPostalCode |
string |
Postal code of the final destination location for the purchases made by the customer. |
|
FinalDischargeLocationProvince |
string |
Province of the final destination location for the purchases made by the customer. |
|
FinalDischargeLocationState |
string |
State of the final destination location for the purchases made by the customer. |
|
FirstPartyTaxRegistrationIdentifier |
long |
Unique identifier of the registration number that is quoted to the supplier. 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. |
|
FulfillLineIdentifier |
long |
Unique Identifier for a fulfillment line.
|
|
FulfillLineNumber |
int |
Numerical value associated to fulfillment line. It is defaulted to 1 and increments in integers as fulfillment lines split. |
|
FulfillmentDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date when the fulfillment task is completed. |
|
FulfillmentDetail |
Fulfillment details that the fulfillment system sends about the fulfillment transaction. |
|
|
FulfillmentOrganizationCode |
string |
Code that represents the organization from which the product was shipped. |
|
FulfillmentOrganizationIdentifier |
long |
Unique identifier of the fulfillment organization. |
|
FulfillmentOrganizationName |
string |
Name that represents the organization from which the product was shipped. |
|
FulfillmentSplitReferenceIdentifier |
long |
If the fulfillment system splits their transaction line corresponding to the original fulfillment line, when they send the new transaction line, this will be the identifier of the original fulfillment line. |
|
FulfillmentSystemInteractionIdentifier |
long |
Identifier used for interaction with the fulfillment system. |
|
FulfillmentTransactionLineQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Quantity of the transaction line in the fulfillment system. For split cases, each transaction line should be sent back as a FulfillLine and the sum of this field across all transaction lines should equal the ordered quantity. NOTE: DO NOT map the unitCode attribute since this quantity is always expressed in the Ordered unit of measure. If unitCode is populated, it will be ignored. |
|
IntendedUseClassificationIdentifier |
long |
Unique identifier of the classification for intended use of the item for tax calculation purposes. |
|
IntendedUseClassificationName |
string |
The classification for intended use for tax calculation purposes. |
|
InventoryReservationIdentifier |
long |
Reference to the unique identifier for the inventory reservation. |
|
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. |
|
LineNumber |
int |
Representation of a sales order line used in communication with fulfillment systems. |
|
LotSerial |
Lot number and serial number details that the fulfillment system sends about the fulfillment transaction. |
|
|
OrderNumber |
string |
Representation of a sales order used in communication with fulfillment systems. |
|
OriginalFulfillmentOrganizationIdentifier |
long |
Unique identifier of the original fulfillment organization sent by Planning to compare with the current value in Order Management to ensure that planning was not done on stale data. |
|
OriginalOrderedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Original value of the Ordered Quantity sent by Planning to compare with the current value in Order Management to ensure that planning was not done on stale data. |
|
OriginalProductIdentifier |
long |
Unique identifier of the original inventory item sent by Planning to compare with the current value in Order Management to ensure that planning was not done on stale data. |
|
OriginalProductNumber |
string |
SKU of the original product that was ordered. This is sent by Planning to compare with the current value in Order Management to ensure that planning was not done on stale data. |
|
OriginalScheduledArrivalDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Original value of the Scheduled Arrival Date sent by Planning to compare with the current value in Order Management to ensure that planning was not done on stale data. |
|
OriginalScheduledShipDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Original value of the Scheduled Ship Date sent by Planning to compare with the current value in Order Management to ensure that planning was not done on stale data. |
|
OriginalShippingCarrierCode |
string |
Original value of the Shipping Carrier Code sent by Planning to compare with the current value in Order Management to ensure that planning was not done on stale data. |
|
OriginalShippingModeCode |
string |
Original value of the Shipping Mode Code sent by Planning to compare with the current value in Order Management to ensure that planning was not done on stale data. |
|
OriginalShippingServiceLevelCode |
string |
Original value of the Shipping Service Level Code sent by Planning to compare with the current value in Order Management to ensure that planning was not done on stale data. |
|
OriginalSupplierCode |
string |
This holds the original value of the supplier to whom Purchase Order was to be issued. This is sent by Planning to compare with the current value in Order Management to ensure that planning was not done on stale data. |
|
OriginalSupplierSiteCode |
string |
This holds the original value of the Supplier Site against which a Purchase Order was to be created. This is sent by Planning to compare with the current value in Order Management to ensure that planning was not done on stale data. |
|
OverrideScheduleDateFlag |
boolean |
This attribute indicates that the user can override the scheduling data manually. |
|
PackingInstructions |
string |
A message that provides information concerning the packing of an item. |
|
ProductCategory |
string |
Product classification for tax purposes. |
|
ProductCategoryName |
string |
A classification of 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 name 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 |
A product related classification in Oracle Fusion Tax that specifies whether the transaction line is for a good, or a service, or it is a memo line. |
|
PromisedArrivalDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date that was promised to the customer that the item would arrive. |
|
PromisedShipDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date that was promised to the customer that the item would ship. |
|
PurchaseOrderIdentifier |
string |
Unique identifier of the Purchase Order in an external system for dropshipment of this fulfillment line. |
|
PurchaseOrderLineIdentifier |
string |
Unique identifier of the Purchase Order Line in an external system for dropshipment of this fulfillment line. |
|
PurchaseOrderLineNumber |
string |
Reference to the Purchase Order Line Number in an external system for dropshipment of this fulfillment line. |
|
PurchaseOrderNumber |
string |
Reference to the Purchase Order Number in an external system for dropshipment of this fulfillment line. |
|
PurchaseOrderRevisionNumber |
string |
Reference to the revision number of the Purchase Order in an external system for dropshipment of this fulfillment line. |
|
PurchaseOrderScheduleIdentifier |
string |
Unique identifier of the Purchase Order Schedule in an external system for dropshipment of this fulfillment line. |
|
PurchaseOrderScheduleNumber |
string |
Reference to the Purchase Order Schedule Number in an external system for dropshipment of this fulfillment line. |
|
PurchasingActionCode |
string |
In the case of drop shipment, the Purchasing system may specify the action that occurred within that system. The possible values are REQ_LINE_SPLIT, PO_IMPLEMENTED, PO_CO_IMPLEMENTED, or PO_CO_RESCINDED. |
|
PurchasingChangeTypeCode |
string |
Changes to a drop ship Purchase Order may be communicated by a Purchasing system with a change type to distinguish different types of changes. The possible values are CHANGED, SPLIT, REQUEST_CANCELED, ORDER_CANCELED. |
|
PurchasingUOM |
string |
Meaning of the unit of measure code in which the quantity is expressed on the Purchase Order. |
|
PurchasingUOMCode |
string |
Unit of measure in which the Procurement system placed the Purchase Order with the supplier. |
|
RMADeliveredQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The quantity delivered against the receipt line. NOTE: DO NOT map the unitCode attribute since this quantity is always expressed in the Ordered unit of measure. If unitCode is populated, it will be ignored. |
|
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. |
|
RequestedShipDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Original date the customer requested the item to ship. |
|
RequiredFulfillmentDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Customer required fulfillment date. |
|
RequisitionIdentifier |
string |
Unique identifier of the Requisition in an external system for dropshipment of this fulfillment line. |
|
RequisitionLineIdentifier |
string |
Unique identifier of the Requisition Line in an external system for dropshipment of this fulfillment line. |
|
RequisitionLineNumber |
string |
Reference to the Requisition Line Number in an external system for dropshipment of this fulfillment line. |
|
RequisitionNumber |
string |
Reference to the Requisition Number in an external system for dropshipment of this fulfillment line. |
|
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. NOTE: DO NOT map the unitCode attribute since this quantity is always expressed in the Ordered unit of measure. If unitCode is populated, it will be ignored. |
|
ScheduledArrivalDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date the shipment is scheduled to arrive. |
|
ScheduledShipDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date when goods are expected to be shipped. |
|
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 is applicable when more than one unit of measure is used 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 is applicable when more than one unit of measure is used to measure and track the item. |
|
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. |
|
SecondaryUOMCode |
string |
Abbreviation that identifies the 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. |
|
ShippedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Quantity of product on an order line that is shipped. NOTE: DO NOT map the unitCode attribute other than for drop shipment since this quantity is always expressed in the Ordered unit of measure. If unitCode is populated, it will be ignored for all cases other than drop shipment. |
|
ShippedUOM |
string |
Meaning of the unit of measure code in which the shipped quantity is expressed. NOTE: For drop shipment this may be different from Ordered UOM. You need not pass this for all other sources of fulfillment or it should match the Ordered UOM. |
|
ShippingCarrier |
string |
Shipping carrier that delivered the goods. |
|
ShippingCarrierCode |
string |
Code that represents the shipping carrier that delivered the goods. |
|
ShippingCost |
Shipping cost details that the fulfillment system sends about the fulfillment transaction. |
|
|
ShippingInstructions |
string |
A message 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. |
|
SplitFromExternalInteractionKey |
string |
Reference to the transaction line from which it was split in the fulfillment system. |
|
SubInventory |
string |
Physical or logical location of the item. |
|
SubInventoryCode |
string |
Abbreviation that identifies the physical or logical location of the item. |
|
SubstitutionReason |
string |
Reason that describes why an item was substituted on a fulfillment line. |
|
SubstitutionReasonCode |
string |
Code that describes why an item was substituted on a fulfillment line. |
|
SupplierAddressCity |
string |
City from where supplier will ship the goods. |
|
SupplierAddressCountry |
string |
Country from where supplier will ship the goods. |
|
SupplierAddressCounty |
string |
County from where supplier will ship the goods. |
|
SupplierAddressLine1 |
string |
First line of the supplier address from where goods will be shipped. |
|
SupplierAddressLine2 |
string |
Second line of the supplier address from where goods will be shipped. |
|
SupplierAddressLine3 |
string |
Third line of the supplier address from where goods will be shipped. |
|
SupplierAddressLine4 |
string |
Fourth line of the supplier address from where goods will be shipped. |
|
SupplierAddressPostalCode |
string |
Postal code from where supplier will ship the goods. |
|
SupplierAddressProvince |
string |
Province from where supplier will ship the goods. |
|
SupplierAddressState |
string |
State from where supplier will ship the goods. |
|
SupplierCode |
string |
This will hold the value for Supplier on whom Purchase Order is created. |
|
SupplierName |
string |
Name of the supplier who will ship the goods to the customer. |
|
SupplierNumber |
string |
Supplier number responsible for shipment of the product. |
|
SupplierSiteCode |
string |
This will hold the value for Supplier Site on whom Purchase Order is created. |
|
SupplyOrderNumber |
string |
Reference to the Supply Order Number in an external system for back-to-back fulfillment of this fulfillment line. |
|
SupplyStatusCode |
string |
Status of the supply for fulfilling the line. |
|
TaskInstanceStatusCode |
string |
Status of the fulfillment line in the context of the task instance. |
|
TaxAssessedPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Price at which a product is valued by a tax authority for a given tax. NOTE: DO NOT map the currencyCode attribute since this price is always expressed in the transactional currency of the order. If currencyCode is populated, it will be ignored. |
|
TaxInvoiceDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Invoice date used for tax reporting. |
|
TaxInvoiceNumber |
string |
Invoice number used for tax reporting. |
|
ThirdPartyTaxRegistrationIdentifier |
long |
Unique identifier of the customer registration number that is specified by the customer on the purchase order. |
|
ThirdPartyTaxRegistrationNumber |
string |
Customer registration number specified by the customer in the purchase order. |
|
TradeComplianceScreeningDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date on which the line was last screened for trade compliance. |
|
TradeComplianceScreeningResultCode |
string |
Result of trade compliance screening across all applicable compliance types. |
|
TransactionBusinessCategoryCode |
string |
Code used to group and process journal entries with similar characteristics, such as adjustments, accruals, or reclassifications. |
|
TransactionBusinessCategoryName |
string |
Name of the classification or categorization of a transaction for tax purposes as required by a tax authority. |
|
TransportationOrderReleaseIdentifier |
string |
Unique identifier of the order release in the transportation management system corresponding to a fulfillment line. |
|
UserDefinedFiscalClassification |
string |
Classification of the transaction into different categories for tax purposes. |
|
UserDefinedFiscalClassificationName |
string |
Name of another classification of the transaction into different categories for tax purposes. |
|
VerifyOriginalAttributesFlag |
boolean |
Indicates whether Order Management should compare the original attribute values with the current values. A planning system may use this to verify that it is making recommendations based on the latest data snapshot. |