Shipments

The Shipments view object contains information of shipments of goods and material to be carried under the terms of a single bill of lading.

Data Store Key : FscmTopModelAM.ScmExtractAM.WshBiccExtractAM.DeliveryExtractPVO

Primary Keys : DeliveryPEODeliveryId

Initial Extract Date : DeliveryPEOCreationDate

Incremental Extract Date : DeliveryPEOLastUpdateDate

Attributes

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

Name	Description
DeliveryPEOActualShipDate	Date when the shipment was actually sent.
DeliveryPEOAdditionalShipmentInfo	Text for the additional shipment information.
DeliveryPEOApBatchId	Value that identifies the batch used for autopacking.
DeliveryPEOAsnDateSent	Date when the advanced shipment notice was transmitted.
DeliveryPEOAsnSeqNumber	Number that identifies the sequence on the advanced shipment notice.
DeliveryPEOAsnStatusCode	Code that identifies the state or condition of the advanced shipment notice.
DeliveryPEOAutoApExcludeFlag	Contains one of the following values: true or false. If true, then the shipment is eligible for packing by the batch program. If false, then the shipment isn't eligible for packing by the batch program. This attribute doesn't have a default value.
DeliveryPEOAutoScExcludeFlag	Contains one of the following values: true or false. If true, then the shipment is eligible for shipping using the batch program. If false, then the shipment isn't eligible for shipping using the batch program. This attribute doesn't have a default value.
DeliveryPEOBatchId	Value that uniquely identifies the pick release batch that created this shipment.
DeliveryPEOBillOfLadingNumber	Number that identifies the receipt given by the carrier to the shipper acknowledging the receipt of goods being shipped and specifying the terms of shipment.
DeliveryPEOBillOfLadingSeqId	Value that uniquely identifies the document sequence assignment used for the bill of lading.
DeliveryPEOBillOfLadingSignature	Hash signature for the bill of lading.
DeliveryPEOCarrierId	Value that uniquely identifies the carrier.
DeliveryPEOCertificateNumber	Number that identifies the certificate of readiness of the shipment.
DeliveryPEOCloseBatchId	Value that uniquely identifies the batch used for closing this shipment.
DeliveryPEOCodAmount	Amount to be collected on delivery.
DeliveryPEOCodChargePaidBy	Person or party who paid the collect on delivery amount.
DeliveryPEOCodCurrencyCode	Code that identifies the currency for collect on delivery amount.
DeliveryPEOCodRemitTo	Person or party to whom the collect on delivery amount is to be remitted.
DeliveryPEOCommercialInvoiceNumber	Number identifying the commercial invoice for the shipment.
DeliveryPEOCommercialInvoiceSeqId	Value that uniquely identifies the document sequence assignment used for commercial invoice.
DeliveryPEOCommercialInvoiceSignature	Hash signature for the commercial invoice.
DeliveryPEOConfirmDate	Date when the shipment was ship confirmed.
DeliveryPEOConfirmedBy	Person or user who confirmed a shipment.
DeliveryPEOCreatedBy	User who created the shipment.
DeliveryPEOCreationDate	Date when the user created the shipment.
DeliveryPEOCurrencyCode	Code that identifies the currency for the freight costs.
DeliveryPEODeliveryId	Value that uniquely identifies the shipment.
DeliveryPEODeliveryName	Name of the separately identifiable collection of goods or materials to be carried under the terms of a single bill of lading.
DeliveryPEODeliveryType	Type of delivery whether it's standard or consolidated.
DeliveryPEODescription	Description for the shipment.
DeliveryPEODockCode	Code that identifies the platform or place for loading or unloading cargo or other materials from trucks, trains, ships, or an aircraft.
DeliveryPEOERecordId	Value that uniquely identifies the electronic record capturing the signature.
DeliveryPEOEarliestDropoffDate	Earliest date when the shipper can deliver the shipment to the customer.
DeliveryPEOEarliestPickupDate	Earliest date when the shipper can pick up the shipment.
DeliveryPEOExternalSysTxnReference	Value that contains reference information for the corresponding transaction in external applications.
DeliveryPEOFdProcessingStatus	Processing status associated with the fiscal document.
DeliveryPEOFobCode	Code that identifies free on board, which indicates the ownership of the goods in-transit.
DeliveryPEOFobLocationId	Value that uniquely identifies the free on board location.
DeliveryPEOFreightTermsCode	Code that identifies the agreement indicating whether the buyer or the seller pays the shipping costs of an order and when payment is due.
DeliveryPEOGrossAmount	Gross amount for the shipment.
DeliveryPEOGrossWeight	Weight of the loaded equipment, vehicle, container, or item, including packed items and packaging material.
DeliveryPEOHashString	Hash string of the shipment grouping attributes.
DeliveryPEOHashValue	Hash value of the shipment grouping attributes.
DeliveryPEOInitialPickupDate	Date when the shipment is planned to be shipped.
DeliveryPEOInitialPickupLocationId	Value that uniquely identifies the location from which goods are to be shipped.
DeliveryPEOInterfaceBatchId	Value that uniquely identifies the batch used to interface the shipment.
DeliveryPEOJobSetName	Name of the job set that created or most recently modified the shipment.
DeliveryPEOJobSetPackageName	Name of the job set package that created or most recently modified the shipment.
DeliveryPEOJobSetProcessId	Value that uniquely identifies the object to store the document job set process.
DeliveryPEOKeyVersion	Key version of the certificate number.
DeliveryPEOLastUpdateDate	Date when the record was most recently processed.
DeliveryPEOLastUpdateLogin	Session login associated with the user who most recently updated the shipment.
DeliveryPEOLastUpdatedBy	User who most recently updated the shipment.
DeliveryPEOLatestDropoffDate	Last date when the shipper can deliver the shipment to the customer.
DeliveryPEOLatestPickupDate	Last date when the shipper can pick up the shipment.
DeliveryPEOLoadingOrderFlag	Represents the rule to be applied on shipment lines for loading into the truck. For example: forward, reverse, and so on.
DeliveryPEOLoadingSequence	Sequence in which the shipment is loaded in a truck.
DeliveryPEOModeOfTransport	Mode of transportation to ship the goods. A list of accepted values is defined in the lookup type WSH_MODE_OF_TRANSPORT.
DeliveryPEONetAmount	Net amount of the shipment.
DeliveryPEONetWeight	Weight of the products being shipped without considering the packaging.
DeliveryPEONumberOfLpn	Number of packing units on a shipment.
DeliveryPEOObjectVersionNumber	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.
DeliveryPEOOrganizationId	Value that uniquely identifies the inventory organization.
DeliveryPEOPackingSlipNumber	Number that identifies the document that itemizes in detail the contents of the shipment.
DeliveryPEOPackingSlipSeqId	Value that uniquely identifies the document sequence assignment used for the packing slip.
DeliveryPEOPackingSlipSignature	Hash signature for the packing slip.
DeliveryPEOPackingSlipStatus	State or condition of the packing slip, for example, final or draft.
DeliveryPEOPendingInterfaceFlag	Contains one of the following values: true or false. If true, then the shipment has lines to be interfaced to inventory. If false, then the shipment doesn't have lines to be interfaced to inventory. This attribute doesn't have a default value.
DeliveryPEOPlannedFlag	Contains one of the following values: true or false. If true, then the contents of the shipment are planned. If false, then the contents of the shipment aren't planned. The default value is false.
DeliveryPEOProblemContactReference	Person to contact in case of a problem with a shipment.
DeliveryPEORcvShipmentHeaderId	Value that uniquely identifies the supplier advanced shipment notice in receiving.
DeliveryPEORcvShipmentNum	Number that identifies the supplier advanced shipment notice.
DeliveryPEOReasonOfTransport	Justification that users select when confirming shipments to indicate special situations or exceptions, such as when material is transferred, returned, or sent as a sample.
DeliveryPEORequestId	Value that uniquely identifies the request of the scheduled process that created or last modified the shipment.
DeliveryPEORoutingInstructions	Document or text that contains information concerning the shipping route of a shipment.
DeliveryPEOSealCode	Code that identifies the device used for packing units, lockers, or trucks to prove to relevant parties that they have remained closed during transport.
DeliveryPEOServiceLevel	Abbreviation that identifies the service level for the shipping method. A list of accepted values is defined in the lookup type WSH_SERVICE_LEVELS.
DeliveryPEOShipMethodCode	Code that identifies the ship method.
DeliveryPEOShipToLocationType	Type of the ship-to location.
DeliveryPEOShipToPartyId	Value that uniquely identifies the customer.
DeliveryPEOShippingMarks	Mark of identification shown on individual package to help in moving it without delay or confusion to its final destination and to enable the checking of cargo against documents.
DeliveryPEOSoldToPartyId	Value that uniquely identifies the sold-to party.
DeliveryPEOSourceHeaderId	Value that uniquely identifies the source order.
DeliveryPEOSourceLineType	Type of order such as sales order or transfer order.
DeliveryPEOStatusCode	Code that identifies the state or condition of the shipment. A list of accepted values is defined in the lookup type WSH_DELIVERY_STATUS.
DeliveryPEOTpShipmentNumber	Number that identifies the planned shipment from the transportation management system.
DeliveryPEOUltimateDropoffDate	Date when the shipment is expected to arrive at the customer's location. This is calculated by adding the transit time to the shipped date.
DeliveryPEOUltimateDropoffLocationId	Value that uniquely identifies the customer location where a supplier sends shipments for goods or services.
DeliveryPEOVehicleItemId	Value that uniquely identifies the type of vehicle or equipment, which transports the shipment.
DeliveryPEOVehicleNumber	Number that identifies the registration of the vehicle or equipment that's used to transport the shipment.
DeliveryPEOVolume	Volume of the shipment.
DeliveryPEOVolumeUomCode	Code that identifies the unit of measure to use for volume.
DeliveryPEOWaybill	Nonnegotiable document describing the contract for transporting cargo.
DeliveryPEOWeightUomCode	Code that identifies the unit of measure to use for weight.
DeliveryPEOWvFrozenFlag	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.