Shipment Lines

The Shipment Lines view object contains information lines for a specific quantity of an item to be transported from one specific location to another with an availability date and time, or with a shipment deadline.

Data Store Key : FscmTopModelAM.ScmExtractAM.WshBiccExtractAM.DeliveryLineExtractPVO

Primary Keys : DeliveryLinePEODeliveryDetailId

Initial Extract Date : DeliveryLinePEOCreationDate

Incremental Extract Date : DeliveryLinePEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
DeliveryLinePEOAllowItemSubstitutionFlag	Contains one of the following values: Y, N or null. If Y, then item substitution is allowed. If N or null, then item substitution isn't allowed. This value will default from the same attribute on the transfer order line.
DeliveryLinePEOAssessableValue	Value of the item. Each tax authority can use a different assessable value for each item. The tax authority uses this attribute for taxation purposes.
DeliveryLinePEOBaseItemId	Value that uniquely identifies the model to use for an assemble-to-order configured item.
DeliveryLinePEOBatchId	Value that uniquely identifies the group of sales orders that the application released into picking.
DeliveryLinePEOBillToContactId	Value that uniquely identifies the bill-to contact for the order line.
DeliveryLinePEOBillToLocationId	Value that uniquely identifies the bill-to location for the order line.
DeliveryLinePEOBillToPartyId	Value that uniquely identifies the bill-to party for the order line.
DeliveryLinePEOBillToPartySiteId	Value that uniquely identifies the bill-to party site.
DeliveryLinePEOCalcWndWddDate	Date when the material for the order line is picked up from the warehouse. When the line is assigned to a shipment, this value is same as the shipment's initial pick up date. If the line isn't assigned to a shipment, this value is the same as the scheduled ship date.
DeliveryLinePEOCancelledQuantity	Quantity that was canceled.
DeliveryLinePEOCancelledQuantity2	Canceled quantity in the secondary unit of measure for the item.
DeliveryLinePEOCarrierId	Value that uniquely identifies the carrier.
DeliveryLinePEOCategoryId	Value that uniquely identifies the product fiscal classification.
DeliveryLinePEOConversionDate	Date when the currency conversion occurred.
DeliveryLinePEOConversionRate	Rate of the currency conversion.
DeliveryLinePEOConversionType	Type of the currency conversion. If the sales order doesn't use the same currency that the shipping cost uses, then this attribute specifies the currency conversion type to use when converting the currency.
DeliveryLinePEOConvertedQuantity	Shipped or backordered quantity that the application converted into ordered quantity.
DeliveryLinePEOConvertedQuantity2	Converted quantity in the secondary unit of measure for the item.
DeliveryLinePEOConvertedRequestedQuantity	Requested quantity of the shipment line in order UOM.
DeliveryLinePEOCreatedBy	User who created the shipment line.
DeliveryLinePEOCreationDate	Date when the application created the shipment line.
DeliveryLinePEOCurrencyCode	Code that identifies the currency of the shipment line.
DeliveryLinePEOCustPoNumber	Number that identifies the customer purchase order.
DeliveryLinePEOCustomerItemId	Value that uniquely identifies the customer item.
DeliveryLinePEOCycleCountQuantity	Quantity on a shipment line that was withheld from processing until the inventory becomes available.
DeliveryLinePEOCycleCountQuantity2	Quantity in the item's secondary unit of measure that was withheld from processing until the inventory becomes available.
DeliveryLinePEODateRequested	Date when the customer requested to ship the order line.
DeliveryLinePEODateScheduled	Date when the order line is scheduled to ship.
DeliveryLinePEODefaultTaxationCountry	Country where the transaction occurs. The tax authority uses this attribute for taxation purposes.
DeliveryLinePEODeliveredQuantity	Quantity that the shipper delivers.
DeliveryLinePEODeliveredQuantity2	Delivered quantity in the secondary unit of measure for the item.
DeliveryLinePEODeliveryDetailId	Value that uniquely identifies the shipment line.
DeliveryLinePEODetailContainerItemId	Value that uniquely identifies the detail container.
DeliveryLinePEODoNotShipAfterDate	Date after when the shipper must ship.
DeliveryLinePEODoNotShipBeforeDate	Date before when the shipper must ship.
DeliveryLinePEODocumentSubType	Type of the document fiscal classification.
DeliveryLinePEOEarliestDropoffDate	Earliest date when the line needs to be delivered.
DeliveryLinePEOEarliestPickupDate	Date when the line is to be first picked up.
DeliveryLinePEOEndAssemblyItemNumber	Number that identifies the finished, assembled item to build, using the item shipped on this shipment line.
DeliveryLinePEOExemptCertificateNumber	Number that identifies the certificate for tax exemption. The tax authority uses this attribute for taxation purposes.
DeliveryLinePEOExemptReasonCode	Code that identifies the reason for tax exemption. The tax authority uses this attribute for taxation purposes.
DeliveryLinePEOFinalDischargeLocationId	Value that uniquely identifies the location of the final discharge.
DeliveryLinePEOFirstPtyRegId	Value that uniquely identifies tax registration for the first party of the transaction. The tax authority uses this attribute for taxation purposes.
DeliveryLinePEOFiscalDocHeaderId	Value that uniquely identifies the fiscal document header.
DeliveryLinePEOFiscalDocLineId	Value that uniquely identifies the fiscal document line.
DeliveryLinePEOFobCode	Code that indicates the ownership of the items that are in transit. A list of accepted values is defined in the lookup type FOB.
DeliveryLinePEOFreightTermsCode	Code that identifies the freight terms. A list of accepted values is defined in the lookup type WSH_FREIGHT_CHARGE_TERMS.
DeliveryLinePEOGrossWeight	Weight of the loaded equipment, packing unit, or item, including packed items and packaging material.
DeliveryLinePEOIntendedUseClassifId	Value that uniquely identifies the Intended use classification.
DeliveryLinePEOInvInterfacedFlag	Contains one of the following values: true or false. If true, then the line is interfaced to inventory. If false, then the line isn't interfaced to inventory. This attribute doesn't have a default value.
DeliveryLinePEOInventoryItemId	Value that uniquely identifies the inventory item.
DeliveryLinePEOItemDescription	Description of the inventory item.
DeliveryLinePEOLastUpdateDate	Date when the user most recently updated the shipment line.
DeliveryLinePEOLastUpdateLogin	Login that the user used when updating the shipment line.
DeliveryLinePEOLastUpdatedBy	User who most recently updated the shipment line.
DeliveryLinePEOLatestDropoffDate	Latest date when this line is to be delivered to customer.
DeliveryLinePEOLatestPickupDate	Latest date when this line can be picked up.
DeliveryLinePEOLoadSeqNumber	Sequence in which the lines will be loaded onto the equipment, for example, truck.
DeliveryLinePEOLocatorId	Value that uniquely identifies the item locator for the shipment line.
DeliveryLinePEOLotNumber	Number that identifies the lot for the item. The application uses this attribute when the warehouse places the item under lot control.
DeliveryLinePEOModeOfTransport	Mode of transportation that ships the item. A list of accepted values is defined in the lookup type WSH_MODE_OF_TRANSPORT.
DeliveryLinePEOMoveOrderLineId	Value that uniquely identifies the movement request line within a movement request corresponding to the shipment line.
DeliveryLinePEOMovementId	Value that identifies the movement statistics for the shipment line.
DeliveryLinePEOMvtStatStatus	Status of the movement statistics for the shipment line.
DeliveryLinePEONetWeight	Weight of the products being shipped without considering the packaging.
DeliveryLinePEONewSourceShipmentId	Value that uniquely identifies the fulfillment line that was subject to a change in Oracle Fusion Cloud Order Management after a partial shipment.
DeliveryLinePEONewSourceShipmentNumber	Value that identifies the fulfillment line number that was subject to a change in Oracle Fusion Cloud Order Management after a partial shipment.
DeliveryLinePEOObjectVersionNumber	Number of times the object row has been updated. This attribute is used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
DeliveryLinePEOOrgId	Value that uniquely identifies the selling business unit.
DeliveryLinePEOOrganizationId	Value that uniquely identifies the inventory organization.
DeliveryLinePEOOriginalDeliveryDetailId	Value that uniquely identifies the shipment line of the original item for this item substitution.
DeliveryLinePEOOriginalItemConvertedQty	Quantity represented in the original item unit of measure for this item substitution.
DeliveryLinePEOOriginalItemId	Value that uniquely identifies the original item for this item substitution.
DeliveryLinePEOOriginalSubinventory	If material is available, then this attribute contains the subinventory that the warehouse uses to pick the requested item.
DeliveryLinePEOPackingInstructions	Document or text that contains information concerning the packing of an item.
DeliveryLinePEOParentInventoryItemId	Value that uniquely identifies the parent item.
DeliveryLinePEOParentLpnId	Value that uniquely identifies the parent packing unit to which the shipment line is packed.
DeliveryLinePEOParentSourceShipmentId	Value that uniquely identifies the source shipment of the parent item.
DeliveryLinePEOPickableFlag	Contains one of the following values: true or false. If true, then the shipment line can be picked. If false, then the shipment line can't be picked. This attribute doesn't have a default value.
DeliveryLinePEOPickedFromSubinventory	Subinventory from where the item was picked for this shipment line.
DeliveryLinePEOPickedQuantity	Quantity that was brought to the staging location to fulfill an order.
DeliveryLinePEOPickedQuantity2	Picked quantity in the item's secondary unit of measure that was taken from the warehouse supply to fulfill an order.
DeliveryLinePEOPjcProjectId	Value that uniquely identifies the project for standardized project cost collection. This attribute is associated with a feature that requires opt in.
DeliveryLinePEOPjcTaskId	Value that uniquely identifies the task for standardized project cost collection. This attribute is associated with a feature that requires opt in.
DeliveryLinePEOPreferredGrade	Abbreviation that identifies the preferred grade of the item.
DeliveryLinePEOProductCategory	Product category of the transaction line for determining taxes.
DeliveryLinePEOProductType	Type of product of the inventory item. The tax authority uses this attribute for taxation purposes.
DeliveryLinePEOProjectExpenseFlag	Contains one of the following values: true or false. If true, then project details available with source application. If false, then project details aren't available with source application. This attribute doesn't have a default value.
DeliveryLinePEOQuickShipStatus	Status of the quick ship process for the shipment line.
DeliveryLinePEORcvShipmentLineId	Value that uniquely identifies the advanced shipment notice for the shipment line that the supplier supplies in receiving.
DeliveryLinePEOReleasedStatus	Value that indicates the status of the shipment line. Valid values include ready to release, released, staged, shipped, or backordered. A list of accepted values is defined in the lookup type WSH_PICK_STATUS.
DeliveryLinePEORequestDateTypeCode	Code that indicates whether the requested date occurs when the material ships or when it arrives.
DeliveryLinePEORequestId	Value that uniquely identifies the request of the scheduled process that created or last modified the shipment line.
DeliveryLinePEORequestedQuantity	Quantity of the item that the sales order line requests, in the primary unit of measure.
DeliveryLinePEORequestedQuantity2	Quantity of the item requested on the sales order line, in the secondary unit of measure.
DeliveryLinePEORequestedQuantityUom	Code that identifies the primary unit of measure for the requested quantity.
DeliveryLinePEORequestedQuantityUom2	Code that identifies the secondary unit of measure for the requested quantity.
DeliveryLinePEORequisitionHeaderId	Value that uniquely identifies the requisition header for the shipment line.
DeliveryLinePEORequisitionLineId	Value that uniquely identifies the requisition line for the shipment line.
DeliveryLinePEORevision	Revision of the item.
DeliveryLinePEOSalesOrderLineNumber	Number that identifies the order line from the order capture application.
DeliveryLinePEOSalesOrderNumber	Number that identifies the order from the order capture application.
DeliveryLinePEOSalesOrderShipmentNumber	Number that identifies the order shipment from the order capture application.
DeliveryLinePEOSealCode	Code that identifies the seal on a packing unit, locker, or truck to prove that the container remained closed during transport.
DeliveryLinePEOSellingPrice	Selling price of the item.
DeliveryLinePEOServiceLevel	Code that identifies the service level for the shipping method. A list of accepted values is defined in the lookup type WSH_SERVICE_LEVELS.
DeliveryLinePEOShipFromLocationId	Value that uniquely identifies the ship-from location.
DeliveryLinePEOShipMethodCode	Code that identifies the transportation method for the shipment line.
DeliveryLinePEOShipSetName	Shipment set that contains the shipment line among the group of order lines within an order that need to ship together from their common origin to a common destination and have the same scheduled ship date.
DeliveryLinePEOShipToContactId	Value that uniquely identifies the contact at the ship-to location.
DeliveryLinePEOShipToLocationId	Value that uniquely identifies the ship-to location.
DeliveryLinePEOShipToLocationType	Type of the ship-to location.
DeliveryLinePEOShipToPartyId	Value that uniquely identifies the ship-to party.
DeliveryLinePEOShipToPartySiteId	Value that uniquely identifies the ship-to party site.
DeliveryLinePEOShipToSiteUseId	Value that uniquely identifies the site for ship to destination.
DeliveryLinePEOShipToleranceAbove	Maximum percent above the requested quantity that can be shipped on a shipment line.
DeliveryLinePEOShipToleranceBelow	Maximum percent below the requested quantity that can be shipped on a shipment line.
DeliveryLinePEOShipmentAdviceStatus	Contains one of the following values: true or false. If true, then the application sent the shipment advice for the shipped line to the source application. If false, then shipment advice not sent. The default value is false.
DeliveryLinePEOShipmentPriorityCode	Code that identifies the priority of the demand lines to ship. A list of accepted values is defined in the lookup type WSH_SHIPPING_PRIORITY.
DeliveryLinePEOShippedQuantity	Shipped quantity for the shipment line, in the requested unit of measure.
DeliveryLinePEOShippedQuantity2	Shipped quantity for the shipment line, in the secondary unit of measure.
DeliveryLinePEOShippingInstructions	Document or text that contains information concerning the shipping of an item.
DeliveryLinePEOSoldToContactId	Value that uniquely identifies the sold-to contact for the shipment line.
DeliveryLinePEOSoldToPartyId	Value that uniquely identifies the sold-to party.
DeliveryLinePEOSourceDocumentTypeId	Value that uniquely identifies the type of source document.
DeliveryLinePEOSourceHeaderId	Value that uniquely identifies the source order for reservation purposes.
DeliveryLinePEOSourceHeaderNumber	Number that identifies the source order header.
DeliveryLinePEOSourceLineId	Value that uniquely identifies the source order line for reservation purposes. Usually same as the shipment line identifier.
DeliveryLinePEOSourceLineNumber	Number that identifies the source order line in the source order header.
DeliveryLinePEOSourceLineType	Type of the source line.
DeliveryLinePEOSourceLineUpdateDate	Date when the application most recently updated the source line.
DeliveryLinePEOSourceShipmentId	Value that uniquely identifies the fulfillment line in source order.
DeliveryLinePEOSourceShipmentNumber	Number that identifies the fulfillment line for the order line in the source order.
DeliveryLinePEOSourceSystemId	Value that uniquely identifies the source application.
DeliveryLinePEOSplitFromDeliveryDetailId	Value that uniquely identifies the shipment line that the application originally split this line from.
DeliveryLinePEOSrcRequestedQuantity	Quantity that the customer requested on the source order line.
DeliveryLinePEOSrcRequestedQuantity2	Quantity that the customer requested on the source order line in secondary unit of measure.
DeliveryLinePEOSrcRequestedQuantityUom	Code that identifies the unit of measure for the requested quantity on the source order line.
DeliveryLinePEOSrcRequestedQuantityUom2	Code that identifies the secondary unit of measure for the requested quantity on the source order line.
DeliveryLinePEOSubinventory	Subinventory to use when fulfilling the item to shipped.
DeliveryLinePEOTaxClassificationCode	Code that identifies a group of taxes for reporting and processing. The tax authority uses this attribute for taxation purposes.
DeliveryLinePEOTaxInvoiceDate	Date and time of the tax invoice that you use to meet tax reporting that different countries require.
DeliveryLinePEOTaxInvoiceNumber	Number of the tax invoice that you use to meet tax reporting that different countries require.
DeliveryLinePEOThirdPtyRegId	Value that uniquely identifies tax registration for the third party of the transaction. The tax authority uses this attribute for taxation purposes.
DeliveryLinePEOTpInitialLegDestLocId	Value that uniquely identifies the first leg of transportation that the transportation management application planned to deliver the shipment to the final destination.
DeliveryLinePEOTpReceivedDate	Date when the application received transportation planning for the shipment line.
DeliveryLinePEOTpShipmentLine	Value that identifies the planned shipment line that the transportation management application provides.
DeliveryLinePEOTpShipmentNumber	Number that identifies the planned shipment that the transportation management application provides.
DeliveryLinePEOTpStatusCode	Code that indicates the status of transportation planning for the shipment line. A list of accepted values is defined in the lookup type ORA_WSH_TRAN_PLAN_STATUS.
DeliveryLinePEOTrackingNumber	Number that uniquely identifies the tracking for the shipment during transportation. The carrier provides this number.
DeliveryLinePEOTradeComplianceDate	Date when the application updated the trade compliance status.
DeliveryLinePEOTradeComplianceMethod	Code that identifies the method the application uses to screen the order line for trade compliance. A list of accepted values is defined in the lookup type ORA_WSH_TRD_COMP_SCRN_MTHD.
DeliveryLinePEOTradeComplianceReason	Reason for the trade compliance screening status of the shipment line.
DeliveryLinePEOTradeComplianceStatus	Trade compliance screening status for the shipment line from the trade management system. Valid values are Not applicable, Pending, Requested, Hold, Pass, and Fail.
DeliveryLinePEOTransactionId	Value that uniquely identifies the shipping service transaction.
DeliveryLinePEOTransactionTempId	Value that uniquely identifies the corresponding inventory transaction.
DeliveryLinePEOTrxBusinessCategory	Code that identifies the business classification. Oracle Tax Cloud uses this value to identify and categorize each transaction that resides outside of Oracle Tax Cloud into a transaction that resides inside Oracle Tax Cloud .
DeliveryLinePEOUnitPrice	Price of item for each unit.
DeliveryLinePEOUnitVolume	Unit volume of the item on the shipment line.
DeliveryLinePEOUnitWeight	Unit weight of the item on the shipment line.
DeliveryLinePEOUserDefinedFiscClass	Code that identifies the classification for each tax requirement that you can't define using the fiscal classification types that already exist.
DeliveryLinePEOVolume	Volume of the material for the shipment line.
DeliveryLinePEOVolumeUomCode	Code that identifies the unit of measure to use for volume.
DeliveryLinePEOWeightUomCode	Code that identifies the unit of measure to use for weight.
DeliveryLinePEOWmsInterfacedFlag	Abbreviation that identifies the integration status of a shipment line in an application that resides outside of Oracle applications. A list of accepted values is defined in the lookup type ORA_RCV_EXT_SYS_INTG_STATUS.
DeliveryLinePEOWmsShipToleranceAbove	Value that identifies the overshipment tolerance percentage for the third-party system.
DeliveryLinePEOWmsShipToleranceBelow	Value that identifies the undershipment tolerance percentage for the third-party system.
DeliveryLinePEOWvFrozenFlag	Contains one of the following values: true or false. If true, then the weight or volume was entered by user. If false, then the weight or volume wasn't entered by user. This attribute doesn't have a default value.