ShipmentTransactionRequestsshipmentsouterPackingUnits
ShipmentTransactionRequestsshipmentsouterPackingUnits
Columns
Name | Type | Description |
ShipmentTransactionRequestsTransactionId [KEY] | Long | ShipmentTransactionRequestsTransactionId of ShipmentTransactionRequestsshipmentsouterPackingUnits |
ShipmentsDeliveryInterfaceId [KEY] | Long | ShipmentsDeliveryInterfaceId of ShipmentTransactionRequestsshipmentsouterPackingUnits |
LPNInterfaceId [KEY] | Long | LPNInterfaceId of ShipmentTransactionRequestsshipmentsouterPackingUnits |
PackingUnit | String | Name of the packing unit. |
TrackingNumber | String | Tracking number of the packing unit. |
MasterSerialNumber | String | Master serial number that identifies the packing unit. |
SealNumber | String | Number that identifies the seal on a packing unit, locker, or truck to prove that the container remained closed during transport. |
PackingUnitType | String | Item defining characteristics of a packing unit. |
FOBCode | String | Abbreviation that identifies ownership of the items that are in-transit. A list of accepted values is defined in the lookup type FOB. |
Volume | Double | Volume of material that the packing unit can hold. |
VolumeUOMCode | String | Code that identifies the unit of measure that the container volume uses for the packing unit. |
VolumeUOM | String | Unit of measure that the container volume uses for the packing unit. |
GrossWeight | Double | Weight of the packing unit including contents. |
GrossWeightUOMCode | String | Code that identifies the unit of measure of the gross weight of the packing unit. |
GrossWeightUOM | String | Unit of measure of the gross weight of the packing unit. |
TareWeight | Double | Weight of the container that contains the packing unit. |
TareWeightUOMCode | String | Code that identifies the unit of measure that the tare weight uses for the packing unit. |
TareWeightUOM | String | Unit of measure that the tare weight uses for the packing unit. |
CreatedBy | String | CreatedBy of ShipmentTransactionRequestsshipmentsouterPackingUnits |
CreationDate | Datetime | CreationDate of ShipmentTransactionRequestsshipmentsouterPackingUnits |
LastUpdatedBy | String | LastUpdatedBy of ShipmentTransactionRequestsshipmentsouterPackingUnits |
LastUpdateDate | Datetime | LastUpdateDate of ShipmentTransactionRequestsshipmentsouterPackingUnits |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Carrier | String | Carrier |
ExternalSystemTransactionReference | String | ExternalSystemTransactionReference |
FromActualShipDate | Datetime | FromActualShipDate |
FromInitialShipDate | Datetime | FromInitialShipDate |
Item | String | Item |
ModeOfTransportCode | String | ModeOfTransportCode |
Order | String | Order |
ServiceLevelCode | String | ServiceLevelCode |
ShipFromOrganizationCode | String | ShipFromOrganizationCode |
Shipment | String | Shipment |
ShipmentLine | Long | ShipmentLine |
SoldToCustomer | String | SoldToCustomer |
ToActualShipDate | Datetime | ToActualShipDate |
ToInitialShipDate | Datetime | ToInitialShipDate |
TransactionId | Long | TransactionId |
Finder | String | finder |