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. |