Shipment Line Data SDO
An object to stored the details of the shipment line
QName: {http://xmlns.oracle.com/apps/scm/shipping/shipConfirm/deliveries/shipmentLineService/}ShipmentLine
Logical Business Objects
-
SCM : Shipping : Shipment
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 |
|
|
Handled by |
Attributes
The following table describes attributes in the service data object.
| Name | Type | Description |
|---|---|---|
|
ArrivalSetName |
string |
Arrival Set Name for the order line. |
|
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. |
|
BillToAddressLine1 |
string |
First line of bill-to customer address. |
|
BillToAddressLine2 |
string |
Second line of bill-to customer address. |
|
BillToAddressLine3 |
string |
Thrid Line of bill-to customer address |
|
BillToAddressLine4 |
string |
Fourth line of bill-to customer address. |
|
BillToCity |
string |
City of bill-to customer address. |
|
BillToContactFirstName |
string |
First name of bill-to customer |
|
BillToContactId |
long |
Unique id of bill-to customer |
|
BillToContactLastName |
string |
Last name of bill-to customer |
|
BillToContactName |
string |
Contact name of bill-to customer |
|
BillToContactPhoneNumber |
string |
Phone number of bill-to party |
|
BillToCountry |
string |
Country of bill-to customer address. |
|
BillToCounty |
string |
County of bill-to customer address. |
|
BillToFax |
string |
Fax of bill-to party |
|
BillToLocationId |
long |
Unique identifier of bill-to customer |
|
BillToPartyId |
long |
Primary Key of Bill to Party |
|
BillToPartyName |
string |
Name of Bill to Party |
|
BillToPartyNumber |
string |
Unique identifier for Bill to Party |
|
BillToPartySiteId |
long |
Party Site id of Bill to party |
|
BillToPostalCode |
string |
Postal code of bill-to customer address. |
|
BillToRegion |
string |
Region for bill-to customer address |
|
BillToState |
string |
State of bill-to customer address. |
|
BillToURL |
string |
URL of bill-to party |
|
BusinessUnitId |
long |
Identifier of Business Unit |
|
BusinessUnitName |
string |
Name of Business Unit |
|
CancelledQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Quantity being cancelled |
|
CarrierId |
long |
Unique identifier for a Carrier |
|
CarrierName |
string |
Name of Carrier |
|
CarrierNumber |
string |
Identifier for Carrier |
|
CategoryId |
long |
Identifier for party created for a carrier. |
|
ConversionDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date to be used for the currency conversion. |
|
ConversionRate |
long |
Rate to be used for the currency conversion |
|
ConversionType |
string |
Currency conversion type to be used if order is in different currency than the currency of shipping costs. |
|
ConvertedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Shipped or backordered quantity converted into ordered quantity unit |
|
CurrencyCode |
string |
Unique identifier for Currency |
|
CurrencyName |
string |
Name of Currency |
|
CurrentBackorderQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Current Backordered quantity of shipment line. |
|
CustomerItemId |
long |
Unique identifier for Customer item |
|
CustomerItemName |
string |
Name of Customer item |
|
CustomerPONumber |
string |
Customer PO number |
|
CycleCountQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Quantity being Cycle Counted |
|
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. |
|
DeliveredQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Quantity being delivered |
|
DeliveryDetailId |
long |
Unique identifier for a shipment line.
|
|
DetailContainerItemId |
long |
Unique identifier for Detail container |
|
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 |
|
DocumberSubTypeName |
string |
Document Fiscal Classification Name |
|
DocumentSubType |
string |
Document Fiscal Classification Code |
|
EndAssemblyItemNumber |
string |
End assembly item that will be built using the item shipped on this shipment line. |
|
ExemptCertificateNumber |
string |
Tax exemption certificate number |
|
ExemptReasonCode |
string |
Tax exemption reason code. |
|
FOBCode |
string |
Code that determines freight on board. |
|
FOBName |
string |
Name that determines freight on board. |
|
FinalDischargeLocationId |
long |
The final discharge location identifier |
|
FinalDischargeLocationName |
string |
The final discharge location name |
|
FirstPartyRegistrationName |
string |
First Party Tax Registration Name for the transaction |
|
FirstPtyRegId |
long |
First Party Tax Registration ID for the transaction |
|
FreightTermsCode |
string |
Code that determines the freight terms. |
|
FreightTermsName |
string |
Name that determines the freight terms. |
|
GrossWeight |
decimal |
The weight of the loaded equipment, packing unit, or item, including packed items and packaging material. |
|
InitialDestinationLocationId |
long |
Destination location Id of the initial leg of the transportation planned to deliver the shipment to the final destination. |
|
InitialDestinationLocationName |
string |
Destination location name of the initial leg of the transportation planned to deliver the shipment to the final destination. |
|
IntendedUseClassifId |
decimal |
Intended use classification identifier. |
|
IntendedUseName |
string |
Intended use classification identifier name |
|
InventoryItemId |
long |
Unique identifier for inventory item |
|
ItemDescription |
string |
Description of inventory item |
|
ItemName |
string |
Name of Inventory item |
|
LegalEntity |
string |
Legal entity name |
|
LegalEntityId |
long |
Unique identifier for legal entity |
|
LineShipMethodName |
string |
Name of Shipping method |
|
LocatorId |
long |
Unique identifier for locator |
|
LotNumber |
string |
Lot number of item in the shipment line. |
|
ModeOfTransport |
string |
Mode of transport for the shipping method. |
|
ModeOfTransportName |
string |
Mode of transport name for the shipping method. |
|
NetWeight |
decimal |
Weight of the products being shipped without considering the packaging. |
|
OrderTypeCode |
string |
Order type code |
|
OrderTypeName |
string |
Order type name |
|
OrganizationCode |
string |
Organization Code |
|
OrganizationId |
long |
Unique identifier for organization |
|
OrganizationName |
string |
Name of the Organization |
|
OriginalLineId |
string |
Identifier of shipment line from which quantity got backordered. |
|
OriginalSourceShipmentId |
long |
Identifies the original shipment from the source system. |
|
OriginalSourceShipmentNumber |
string |
Original Shipment number from source system |
|
OriginalSubinventory |
string |
This is the original subinventory requested by the order system |
|
OutSourcerPartyNumber |
string |
Part number of the outsourcer who sent the order line |
|
OutsourcerPartyId |
long |
Party identifier of the outsourcer who sent the order line |
|
OutsourcerPartyName |
string |
Party name of the outsourcer who sent the order line |
|
POBillToBUId |
long |
Bill to Business Unit id of Purchase Order |
|
POHeaderId |
long |
Header id of Purchase Ofer |
|
POSoldToLEId |
long |
Purchase order sold to legal entity |
|
POVendorId |
long |
Vendor id of Purchase order |
|
POVendorPartyId |
long |
Vendor party id of Purchase order |
|
ParentInventoryItemDescription |
string |
Item Description of parent inventory item |
|
ParentInventoryItemId |
long |
Unique identifier for parent inventory item |
|
ParentInventoryItemNumber |
string |
Item number of parent inventory item |
|
ParentLPNId |
long |
Parent LPN / Container ID to which Detail Line is Packed. |
|
ParentLPNName |
string |
Name of the LPN/Container ID to which Detail Line is Packed |
|
ParentSourceShipmentId |
long |
Source shipment id of parent item |
|
PickedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Quantity that is picked for the shipment line. |
|
PjcProjectId |
long |
DFF column to save project ID for standardized project cost collection. |
|
PjcTaskId |
long |
DFF column to save task ID for standardized project cost collection. |
|
PreferredGrade |
string |
Preferred grade for the shipment line |
|
PreferredGradeName |
string |
Preferred grade name for the shipment line |
|
ProdCategoryName |
string |
Product category name of the transaction line. |
|
ProdFiscClassName |
string |
Product Fiscal Classificatin name of the transaction line. |
|
ProductCategory |
string |
Product category code of the transaction line. |
|
ProductType |
string |
Product type code of the inventory item. Possible values are GOODS and SERVICES. |
|
ProjectCostingProject |
string |
DFF column to save project number for standardized project cost collection. |
|
ProjectCostingProjectName |
string |
DFF column to save project name for standardized project cost collection. |
|
ProjectCostingTask |
string |
DFF column to save task number for standardized project cost collection. |
|
ProjectCostingTaskName |
string |
DFF column to save task name for standardized project cost collection. |
|
ReleasedStatus |
string |
Status that determines where the shipment line is in its lifecycle (ready to release, released, staged, shipped, or backordered). |
|
ReleasedStatusName |
string |
Name for Status that determines where the shipment line is in its lifecycle (ready to release, released, staged, shipped, or backordered). |
|
RequestDateTypeCode |
string |
Code that determines the type of date requested. |
|
RequestDateTypeName |
string |
Name that determines the type of date requested. |
|
RequestedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
As shipping quantity for customer. |
|
RequestedQuantityUOM |
string |
Unit of measure for requested quantity |
|
RequestedQuantityUOMName |
string |
Unit of measure name for requested quantity |
|
Revision |
string |
Revision of item. |
|
SalesOrderLineNumber |
string |
Sales Order line number from order capture system |
|
SalesOrderNumber |
string |
Sales Order number from order capture system |
|
SalesOrderShipmentNumber |
string |
Sales Order shipment number from order capture system |
|
SealCode |
string |
Seal code for the shipment line. |
|
SecondaryCancelledQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Secondary quantity of quanity being cancelled |
|
SecondaryConvertedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Secondary quantity of quanity being converted |
|
SecondaryCycleCountQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Secondary quantity of quanity being cycle counted |
|
SecondaryDeliveredQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Secondary quantity of quanity being delivered |
|
SecondaryPickedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Secondary quantity of quanity being picked |
|
SecondaryRequestedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Secondary quantity of requested quantity |
|
SecondaryRequestedQuantityUOM |
string |
UOM of secondary requested quantity |
|
SecondaryRequestedQuantityUOMName |
string |
UOM name of secondary requested quantity |
|
SecondaryShippedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The shipped quantity in the item's secondary unit of measure. |
|
SecondarySrcRequestedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Secondary quantity ordered by customer from the source system. |
|
SecondarySrcRequestedQuantityUOM |
string |
Secondary ordered quantity unit of measure from the source system |
|
SecondarySrcRequestedQuantityUOMName |
string |
Secondary ordered quantity unit of measure name from the source system |
|
SecondaryStagedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Staged quantity from Items secondary UOM |
|
SellingPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Saves the actual selling price as opposed to UNIT_PRICE |
|
ServiceLevel |
string |
Service Level of Mode of transport |
|
ServiceLevelName |
string |
Service Level Name of Mode of transport |
|
ShipFromAddressLine1 |
string |
First address line fo ship from address |
|
ShipFromAddressLine2 |
string |
Second address line fo ship from address |
|
ShipFromAddressLine3 |
string |
Third address line fo ship from address |
|
ShipFromAddressLine4 |
string |
Fourth address line fo ship from address |
|
ShipFromCity |
string |
City of ship from address |
|
ShipFromCountry |
string |
Country of ship from address |
|
ShipFromCounty |
string |
County of ship from address |
|
ShipFromLocationId |
long |
Unique identifier for Ship from location |
|
ShipFromPostalCode |
string |
Postal code of ship from address |
|
ShipFromProvince |
string |
Province of ship from address |
|
ShipFromState |
string |
State of ship from address |
|
ShipMethodCode |
string |
Ship method code of shipment line |
|
ShipSetName |
string |
Shipment set name of an order line. |
|
ShipToAddressLine1 |
string |
First line of Ship-to address |
|
ShipToAddressLine2 |
string |
Second line of ship-to address |
|
ShipToAddressLine3 |
string |
Third line of ship-to address |
|
ShipToAddressLine4 |
string |
Fourth line of ship-to address |
|
ShipToCity |
string |
City of ship-to address |
|
ShipToContactFirstName |
string |
First name of ship to contact persion |
|
ShipToContactId |
long |
Unique identifier for Ship to contact |
|
ShipToContactLastName |
string |
Last name of ship to contact persion |
|
ShipToContactName |
string |
Contact name of ship to contact persion |
|
ShipToContactPhoneNumber |
string |
Contact numbe of ship-to party |
|
ShipToCountry |
string |
Country name of ship to address |
|
ShipToCounty |
string |
County name of ship to address |
|
ShipToFax |
string |
Fax of ship-to party |
|
ShipToLocationId |
long |
Location identifier for ship to destination |
|
ShipToPartyId |
long |
Unique identifier of ship to party |
|
ShipToPartyName |
string |
Ship to party name |
|
ShipToPartyNumber |
string |
Ship to party number |
|
ShipToPartySiteId |
long |
Party site id of Ship to party |
|
ShipToPostalCode |
string |
Postal code of ship to address |
|
ShipToRegion |
string |
Region of ship-to address |
|
ShipToState |
string |
State fo ship to address |
|
ShipToURL |
string |
URL of Ship ot party |
|
ShipToleranceAbove |
long |
Over shipment tolerance percentage |
|
ShipToleranceBelow |
long |
Under shipment tolerance percentage |
|
ShipmentAdviceStatus |
string |
Status of Shipment advice |
|
ShipmentLineDFFVA |
Additional Information of the shipment line. |
|
|
ShipmentLineInvStripingDFFVA |
Additional Information of the shipment line. |
|
|
ShipmentPriorityCode |
string |
Shipment priority for the shipment line. |
|
ShipmentPriorityName |
string |
Shipment priority name for the shipment line. |
|
ShippedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
The quantity that was shipped for an order line. |
|
SoldToContactFirstName |
string |
First name of sold to contact |
|
SoldToContactId |
long |
Unique identifier for sold to contact |
|
SoldToContactLastName |
string |
Last name of sold to contact |
|
SoldToContactName |
string |
Contact name of sold to contact |
|
SoldToContactPhoneNumber |
string |
Phone number of Sold-to party |
|
SoldToFax |
string |
Fax of sold-to party |
|
SoldToPartyId |
long |
Unique identifier for Sold to party |
|
SoldToPartyName |
string |
Party name of Sold to party |
|
SoldToPartyNumber |
string |
Party number of Sold to party |
|
SoldToURL |
string |
URL of sold-to party |
|
SourceDocumentTypeId |
long |
Document type id of source |
|
SourceHeaderId |
long |
Header id of Order line |
|
SourceHeaderNumber |
string |
The user visible identifier for the header. |
|
SourceLineId |
long |
Unique identifier for a line in an order |
|
SourceLineNumber |
string |
User visible line number in source system |
|
SourceLineUpdateDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
The date when the source line was last updated. |
|
SourceShipmentId |
long |
Identifies the shipment from the source system. |
|
SourceShipmentNumber |
string |
Shipment number from source system |
|
SourceSystemId |
long |
Idenifier for source system of the order |
|
SourceSystemName |
string |
Name of the source system of the order |
|
SplitFromDeliveryDetailId |
long |
Unique identifier of shipment line from which it is split from. |
|
SrcRequestedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Quantity ordered by customer from the source system. |
|
SrcRequestedQuantityUOM |
string |
Ordered quantity unit of measure from the source system |
|
SrcRequestedQuantityUOMName |
string |
Ordered quantity unit of measure name from the source system |
|
StagedQuantity |
{http://xmlns.oracle.com/adf/svc/types/}MeasureType |
Staged quantity from Items in the order |
|
Subinventory |
string |
Subinventory from which the requested item should be picked if the material is available. |
|
SupplierName |
string |
Name of the supplier |
|
TareWeight |
decimal |
Tareweight of shipment line |
|
TaxClassificationCode |
string |
Code for the tax classification, a grouping of taxes for reporting and processing purposes. |
|
TaxClassificationName |
string |
Name for the tax classification, a grouping of taxes for reporting and processing purposes. |
|
TaxInvoiceDate |
{http://xmlns.oracle.com/adf/svc/types/}date-Date |
The date with time 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. |
|
TaxationCountryName |
string |
Country Name where the transaction is deemed to have taken place for taxation purposes. |
|
ThirdPartyRegistrationName |
string |
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. |
|
ThirdPtyRegistrationId |
long |
Third Party Tax Registration ID for the transaction |
|
TradeComplianceDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date when the trade compliance status is updated. |
|
TradeComplianceReason |
string |
Reason for the trade compliance screening status. |
|
TradeComplianceScreened |
string |
Indicates if shipment line was screened for trade compliance |
|
TradeComplianceScreeningMethodCode |
string |
Method code determining when the line to be screened for trade compliance. |
|
TradeComplianceScreeningMethodName |
string |
Method name determining when the line to be screened for trade compliance. |
|
TradeComplianceStatusCode |
string |
Status of the trade compliance screening of the shipment line. |
|
TradeComplianceStatusName |
string |
Status name of the trade compliance screening of the shipment line. |
|
TransactionBusinessCategory |
string |
Business classification used by Oracle Fusion Tax to identify and categorize an external transaction into a Fusion Tax transaction. |
|
TransactionBusinessCategoryName |
string |
Name of Business classification used by Oracle Fusion Tax to identify and categorize an external transaction into a Fusion Tax transaction. |
|
TransportationPlanningDate |
{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp |
Date when the transportation planning of the shipment line is received. |
|
TransportationPlanningStatusCode |
string |
Status of the transportation planning of the shipment line. |
|
TransportationPlanningStatusName |
string |
Status of the transportation planning of the shipment line. |
|
TransportationShipment |
string |
A shipment planned by the transportation management system. |
|
TransportationShipmentComplete |
string |
Indicates if the transportation shipment to be considered as completed |
|
TransportationShipmentLine |
string |
Shipment line planned by the transportation management system. |
|
UnitPrice |
{http://xmlns.oracle.com/adf/svc/types/}AmountType |
Unit price for the shipment line |
|
UnitVolume |
decimal |
Unit Volume of the item on this delivery detail |
|
UnitWeight |
decimal |
Unit Weight of the item on this delivery detail |
|
UserDefinedFiscalClass |
string |
User defined fiscal classification code |
|
UserDefinedFiscalClassName |
string |
Classification for any tax requirement that you cannot define using the existing fiscal classification types. |
|
Volume |
decimal |
Volume of the item in this shipment line. |
|
VolumeUOMCode |
string |
Unit of measure for Volume of the item in this shipment line. |
|
VolumeUOMName |
string |
Unit of measure name for Volume of the item in this shipment line. |
|
WeightUOMCode |
string |
Unit of measure for Weight of the item in this shipment line. |
|
WeightUOMName |
string |
Unit of measure name for Weight of the item in this shipment line. |
|
WmsInterfacedFlagDisplay |
string |
Display Name of delivery detail interface status |
|
WmsInterfacedIndicator |
string |
Indicates whether the delivery detail has been interfaced to WMS or not. |