Shipment Request Order Line Version 2
An object to store order line and item-level information. For example, item, requested quantity.
QName: {http://xmlns.oracle.com/apps/scm/shipping/shipConfirm/shipmentRequests/shipmentRequestServiceV2/}ShipmentRequestOrderLine
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 |
|
|
Contained by |
|
|
Handled by |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
ArrivalSetName |
string |
Arrival set identifier to which the order line belongs. |
|
AssessableValue |
decimal |
Deemed price at which a product is valued, by a tax authority, for tax calculation purposes. The same product can have more than one assessable value, as given by different tax authorities. |
|
BaseItemId |
long |
Foreign key to EGP_SYSTEM_ITEMS |
|
BaseItemNumber |
string |
Unique Identifier for Base Item |
|
BillToContactId |
long |
Unique identifier for bill-to site contact. |
|
BillToContactName |
string |
Person to be contacted at bill-to site. |
|
BillToContactNumber |
string |
Identifier for the person to be contacted at bill-to site. |
|
BillToPartyId |
long |
Unique identifier for bill-to party. |
|
BillToPartyName |
string |
Name for bill-to party. |
|
BillToPartyNumber |
string |
Identifier for bill-to party site. |
|
BillToPartySiteId |
long |
Unique identifier for bill-to party site. |
|
BillToPartySiteNumber |
string |
Identifier for bill-to party site. |
|
BusinessUnitName |
string |
Identifier for the business unit. |
|
CarrierPartyId |
long |
Unique identifier for a carrier. |
|
CarrierPartyName |
string |
Name for party created for a carrier. |
|
CarrierPartyNumber |
string |
Identifier for party created for a carrier. |
|
CategoryId |
long |
Classification used by a tax authority to categorize a product for a tax. |
|
CategoryName |
string |
Category Name |
|
CustomerItemNumber |
string |
Customer item number. |
|
CustomerPONumber |
string |
Customer purchase order identifier. |
|
DateRequested |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date on which the line is requested. |
|
DateScheduled |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date on which the line is scheduled. |
|
DefaultTaxationCountry |
string |
Country where the transaction is deemed to have taken place for taxation purposes. |
|
DoNotShipAfterDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
This column indicates the cutoff date after which the line cannot be shipped |
|
DoNotShipBeforeDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
This column indicates the cutoff date before which the line cannot be shipped |
|
DocumentSubType |
string |
Classification used by a tax authority to categorize a document associated with a transaction for a tax. |
|
EarliestDropoffDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Not currently used. |
|
EarliestPickupDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Not currently used. |
|
EndAssemblyItemNumber |
string |
End assembly item that will be built using the item shipped on this shipment line. |
|
ExemptCertificateNumber |
string |
Number associated with the tax certificate issued by the taxing authority. |
|
ExemptReasonCode |
string |
Code associated with the reason a tax exemption was granted and taken. |
|
FOBCode |
string |
Freight on board code. |
|
FinalDischargeLocCode |
string |
Final destination location code for the purchases made by the customer. The location code of the final customer or where the goods would be used is not necessarily the same as the initial ship-to location. |
|
FinalDischargeLocationId |
long |
Final destination location for the purchases made by the customer. The location of the final customer or where the goods would be used is not necessarily the same as the initial ship-to location. |
|
FirstPtyNumber |
string |
First Party Number, Needs to include tax_regime_code, tax_jurisdiction_code and tax as well. |
|
FirstPtyRegId |
long |
Unique sequence of letters and/or numbers assigned to a first party, by a tax authority, when it is registered and by which the first party registration will be identified. |
|
FreightTermsCode |
string |
Freight terms code. |
|
FromSubinventoryCode |
string |
Subinventory from which the requested item should be picked if the material is available. |
|
InitialDestinationLocationId |
long |
Destination location of the initial leg of the transportation planned to deliver the shipment to the final destination. |
|
IntendedUse |
string |
Intended Use |
|
IntendedUseClassifId |
decimal |
Tax classification based on the purpose for which a product is used. |
|
InventoryItemId |
long |
Unique identifier for an inventory item. |
|
ItemDescription |
string |
Item Description in case there is no INVENTORY_ITEM_ID value. |
|
ItemNumber |
string |
Indentifier for an item. |
|
LatestDropoffDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Not currently used. |
|
LatestPickupDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Not currently used. |
|
LineActionType |
string |
Line action type. |
|
ModeOfTransport |
string |
Mode of transport. |
|
OrderedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Ordered quantity. |
|
OrderedQuantityUOMName |
string |
Ordered quantity unit from the source system. |
|
OrgId |
long |
Unique identifier for the business unit. |
|
OrganizationCode |
string |
Inventory warehouse code. |
|
OrganizationId |
long |
Unique identifier for ship from organization. |
|
OrganizationName |
string |
Inventory warehouse name. |
|
PackingInstructions |
string |
Packing instructions. |
|
ParentInventoryItemId |
long |
Unique identifier for a parent item. |
|
ParentItemNumber |
string |
Parent item identifier, alternate key for PARENT_INVENTORY_ITEM_ID. |
|
ParentSourceShipmentId |
long |
Unique identifier for a parent shipment as received from source system. |
|
PreferredGrade |
string |
Preferred grade. |
|
ProductCategory |
string |
Type of product fiscal classification used to classify products. Related term(s): product fiscal classification. |
|
ProductType |
string |
Nature or the product involved in a taxable transaction. For example, goods or services |
|
ProjectCostingProjectId |
long |
DFF column to save project ID for standardized project cost collection. |
|
ProjectCostingProjectName |
string |
DFF column to save project name for standardized project cost collection. |
|
ProjectCostingProjectNumber |
string |
DFF column to save project number for standardized project cost collection. |
|
ProjectCostingTaskId |
long |
DFF column to save task ID for standardized project cost collection. |
|
ProjectCostingTaskName |
string |
DFF column to save task name for standardized project cost collection. |
|
ProjectCostingTaskNumber |
string |
DFF column to save task number for standardized project cost collection. |
|
ProjectExpenseIndicator |
string |
Allowed values are Y , N and null. Y means project details available with source system. N and null means project details are not available with source system. |
|
ReleaseLock |
string |
Allowed values are Y and N. Y means release any existing lock against the fulfillment lines. N means retain any existing locks. |
|
RequestDateTypeCode |
string |
Type of date requested. |
|
SalesOrderLineNumber |
string |
Order line number from the sales order system. |
|
SalesOrderShipmentNumber |
string |
Order line shipment number from the sales order system. |
|
SecondaryOrderedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Dual ordered quantity. |
|
SecondaryOrderedQuantityUOMName |
string |
Secondary ordered quantity unit of measure from the source system. |
|
SellingPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Actual selling price. |
|
ServiceLevel |
string |
Service level. |
|
ShipSetName |
string |
Ship set identifier to which the order line belongs. |
|
ShipToContactId |
long |
Unique identifier for ship-to contact. |
|
ShipToContactName |
string |
Person to be contacted at ship-to customer. |
|
ShipToContactNumber |
string |
Identifier for the person to be contacted at ship-to customer. |
|
ShipToPartyId |
long |
Unique identifier for ship-to party. |
|
ShipToPartyName |
string |
Name for ship-to party. |
|
ShipToPartyNumber |
string |
Identifier for ship-to party site. |
|
ShipToPartySiteId |
long |
Unique identifier for ship-to party site. |
|
ShipToPartySiteNumber |
string |
Identifier for ship-to party site. |
|
ShipToleranceAbove |
decimal |
Over shipment tolerance percentage |
|
ShipToleranceBelow |
decimal |
Under shipment tolerance percentage |
|
ShipmentPriorityCode |
string |
Shipment priority code. |
|
ShipmentRequestOrderLineHold |
Details of shipment request order line hold. |
|
|
ShippingInstructions |
string |
Shipping instructions. |
|
SoldToContactId |
long |
Unique identifier for sold-to contact. |
|
SoldToContactName |
string |
Person to be contacted at sold-to customer. |
|
SoldToContactNumber |
string |
Identifier for the person to be contacted at sold-to customer. |
|
SoldToPartyId |
long |
Unique identifier for sold-to party. |
|
SoldToPartyName |
string |
Name for sold-to party. |
|
SoldToPartyNumber |
string |
Identifier for sold-to party. |
|
SourceLineNumber |
string |
Identifier for a source order line. |
|
SourceLineUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Last update date and timestamp of the order line in source system. |
|
SourceShipmentId |
long |
Unique identifier for a shipment as received from source system. This does not have any internal usage in Oracle Fusion Shipping. It will be returned back to the source system in the outbound messages. |
|
SourceShipmentNumber |
string |
Identifier for a shipment as received from source system. |
|
SrcAttribute1 |
string |
Source system descriptive flexfield segment 1. |
|
SrcAttribute10 |
string |
Source system descriptive flexfield segment 10. |
|
SrcAttribute11 |
string |
Source system descriptive flexfield segment 11. |
|
SrcAttribute12 |
string |
Source system descriptive flexfield segment 12. |
|
SrcAttribute13 |
string |
Source system descriptive flexfield segment 13. |
|
SrcAttribute14 |
string |
Source system descriptive flexfield segment 14. |
|
SrcAttribute15 |
string |
Source system descriptive flexfield segment 15. |
|
SrcAttribute16 |
string |
Source system descriptive flexfield segment 16. |
|
SrcAttribute17 |
string |
Source system descriptive flexfield segment 17. |
|
SrcAttribute18 |
string |
Source system descriptive flexfield segment 18. |
|
SrcAttribute19 |
string |
Source system descriptive flexfield segment 19. |
|
SrcAttribute2 |
string |
Source system descriptive flexfield segment 2. |
|
SrcAttribute20 |
string |
Source system descriptive flexfield segment 20. |
|
SrcAttribute3 |
string |
Source system descriptive flexfield segment 3. |
|
SrcAttribute4 |
string |
Source system descriptive flexfield segment 4. |
|
SrcAttribute5 |
string |
Source system descriptive flexfield segment 5. |
|
SrcAttribute6 |
string |
Source system descriptive flexfield segment 6. |
|
SrcAttribute7 |
string |
Source system descriptive flexfield segment 7. |
|
SrcAttribute8 |
string |
Source system descriptive flexfield segment 8. |
|
SrcAttribute9 |
string |
Source system descriptive flexfield segment 9. |
|
SrcAttributeCategory |
string |
Source system descriptive flexfield structure definition. |
|
SrcAttributeDate1 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Source system descriptive flexfield date segment 1. |
|
SrcAttributeDate2 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Source system descriptive flexfield date segment 2. |
|
SrcAttributeDate3 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Source system descriptive flexfield date segment 3. |
|
SrcAttributeDate4 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Source system descriptive flexfield date segment 4. |
|
SrcAttributeDate5 |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Source system descriptive flexfield date segment 5. |
|
SrcAttributeNumber1 |
decimal |
Source system descriptive flexfield number segment 1. |
|
SrcAttributeNumber10 |
decimal |
Source system descriptive flexfield number segment 10. |
|
SrcAttributeNumber2 |
decimal |
Source system descriptive flexfield number segment 2. |
|
SrcAttributeNumber3 |
decimal |
Source system descriptive flexfield number segment 3. |
|
SrcAttributeNumber4 |
decimal |
Source system descriptive flexfield number segment 4. |
|
SrcAttributeNumber5 |
decimal |
Source system descriptive flexfield number segment 5. |
|
SrcAttributeNumber6 |
decimal |
Source system descriptive flexfield number segment 6. |
|
SrcAttributeNumber7 |
decimal |
Source system descriptive flexfield number segment 7. |
|
SrcAttributeNumber8 |
decimal |
Source system descriptive flexfield number segment 8. |
|
SrcAttributeNumber9 |
decimal |
Source system descriptive flexfield number segment 9. |
|
SrcAttributeTimestamp1 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Source system descriptive flexfield timestamp segment 1. |
|
SrcAttributeTimestamp2 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Source system descriptive flexfield timestamp segment 2. |
|
SrcAttributeTimestamp3 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Source system descriptive flexfield timestamp segment 3. |
|
SrcAttributeTimestamp4 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Source system descriptive flexfield timestamp segment 4. |
|
SrcAttributeTimestamp5 |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Source system descriptive flexfield timestamp segment 5. |
|
TaxClassificationCode |
string |
Code for the tax classification, a grouping of taxes for reporting and processing purposes. |
|
TaxInvoiceDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
Date of the tax invoice used to meet specific tax reporting requirements of different countries. |
|
TaxInvoiceNumber |
string |
Number of the tax invoice used to meet specific tax reporting requirements of different countries. |
|
ThirdPtyNumber |
string |
Third Party Number, Needs to include tax_regime_code, tax_jurisdiction_code, tax, third_party_code as well |
|
ThirdPtyRegId |
long |
Unique sequence of letters and/or numbers assigned to a third party or third party site, by a tax authority, when it is registered and by which the party or party site registration will be identified. |
|
TradeComplianceScreeningDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date when the trade compliance status is updated. |
|
TradeComplianceScreeningReason |
string |
Reason for the trade compliance screening status. |
|
TradeComplianceScreeningStatus |
string |
Status of the trade compliance screening of the shipment line. |
|
TransportationPlanningDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date when the transportation planning of the shipment line is received. |
|
TransportationPlanningStatus |
string |
Status of the transportation planning of the shipment line. |
|
TransportationShipment |
string |
Shipment planned by the transportation management system. |
|
TransportationShipmentLine |
string |
Shipment line planned by the transportation management system. |
|
TrxBusinessCategory |
string |
Business classification used by Oracle Fusion Tax to identify and categorize an external transaction into a Fusion Tax transaction. |
|
UnitPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Unit price. |
|
UserDefinedFiscClass |
string |
Classification for any tax requirement that you cannot define using the existing fiscal classification types. |