ShipmentsouterPackingUnitsinnerPackingUnits
ShipmentsouterPackingUnitsinnerPackingUnits
Columns
Name | Type | Description |
ShipmentsDeliveryId [KEY] | Long | ShipmentsDeliveryId of ShipmentsouterPackingUnitsinnerPackingUnits |
OuterpackingunitsLPNId [KEY] | Long | OuterpackingunitsLPNId of ShipmentsouterPackingUnitsinnerPackingUnits |
LPNId [KEY] | Long | LPNId of ShipmentsouterPackingUnitsinnerPackingUnits |
LicensePlateNumber | String | LicensePlateNumber of ShipmentsouterPackingUnitsinnerPackingUnits |
TrackingNumber | String | TrackingNumber of ShipmentsouterPackingUnitsinnerPackingUnits |
MasterSerialNumber | String | MasterSerialNumber of ShipmentsouterPackingUnitsinnerPackingUnits |
SealNumber | String | SealNumber of ShipmentsouterPackingUnitsinnerPackingUnits |
InventoryItemId | Long | InventoryItemId of ShipmentsouterPackingUnitsinnerPackingUnits |
ContainerItem | String | ContainerItem of ShipmentsouterPackingUnitsinnerPackingUnits |
ContainerItemDescription | String | ContainerItemDescription of ShipmentsouterPackingUnitsinnerPackingUnits |
ContainerVolume | Double | ContainerVolume of ShipmentsouterPackingUnitsinnerPackingUnits |
ContainerVolumeUOMCode | String | ContainerVolumeUOMCode of ShipmentsouterPackingUnitsinnerPackingUnits |
ContainerVolumeUOM | String | ContainerVolumeUOM of ShipmentsouterPackingUnitsinnerPackingUnits |
FOBCode | String | FOBCode of ShipmentsouterPackingUnitsinnerPackingUnits |
FOB | String | FOB of ShipmentsouterPackingUnitsinnerPackingUnits |
GrossWeight | Double | GrossWeight of ShipmentsouterPackingUnitsinnerPackingUnits |
GrossWeightUOMCode | String | GrossWeightUOMCode of ShipmentsouterPackingUnitsinnerPackingUnits |
GrossWeightUOM | String | GrossWeightUOM of ShipmentsouterPackingUnitsinnerPackingUnits |
TareWeight | Double | TareWeight of ShipmentsouterPackingUnitsinnerPackingUnits |
TareWeightUOMCode | String | TareWeightUOMCode of ShipmentsouterPackingUnitsinnerPackingUnits |
TareWeightUOM | String | TareWeightUOM of ShipmentsouterPackingUnitsinnerPackingUnits |
NetWeight | Double | NetWeight of ShipmentsouterPackingUnitsinnerPackingUnits |
NetWeightUOMCode | String | NetWeightUOMCode of ShipmentsouterPackingUnitsinnerPackingUnits |
NetWeightUOM | String | NetWeightUOM of ShipmentsouterPackingUnitsinnerPackingUnits |
PackingUnitCategoryCode | String | PackingUnitCategoryCode of ShipmentsouterPackingUnitsinnerPackingUnits |
PackingUnitCategory | String | PackingUnitCategory of ShipmentsouterPackingUnitsinnerPackingUnits |
UnitHeight | Double | UnitHeight of ShipmentsouterPackingUnitsinnerPackingUnits |
UnitLength | Double | UnitLength of ShipmentsouterPackingUnitsinnerPackingUnits |
UnitWidth | Double | UnitWidth of ShipmentsouterPackingUnitsinnerPackingUnits |
DimensionUOMCode | String | DimensionUOMCode of ShipmentsouterPackingUnitsinnerPackingUnits |
DimensionUOM | String | DimensionUOM of ShipmentsouterPackingUnitsinnerPackingUnits |
ParentLPNId | Long | ParentLPNId of ShipmentsouterPackingUnitsinnerPackingUnits |
ParentPackingUnit | String | ParentPackingUnit of ShipmentsouterPackingUnitsinnerPackingUnits |
OutermostPackingUnitId | Long | OutermostPackingUnitId of ShipmentsouterPackingUnitsinnerPackingUnits |
OutermostPackingUnit | String | OutermostPackingUnit of ShipmentsouterPackingUnitsinnerPackingUnits |
PercentageFilled | Long | PercentageFilled of ShipmentsouterPackingUnitsinnerPackingUnits |
VolumeFilled | Long | VolumeFilled of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipFromLocationId | Long | ShipFromLocationId of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipToLocationId | Long | ShipToLocationId of ShipmentsouterPackingUnitsinnerPackingUnits |
CarrierId | Long | CarrierId of ShipmentsouterPackingUnitsinnerPackingUnits |
Carrier | String | Carrier of ShipmentsouterPackingUnitsinnerPackingUnits |
CarrierNumber | String | CarrierNumber of ShipmentsouterPackingUnitsinnerPackingUnits |
ServiceLevelCode | String | ServiceLevelCode of ShipmentsouterPackingUnitsinnerPackingUnits |
ServiceLevel | String | ServiceLevel of ShipmentsouterPackingUnitsinnerPackingUnits |
ModeOfTransportCode | String | ModeOfTransportCode of ShipmentsouterPackingUnitsinnerPackingUnits |
ModeOfTransport | String | ModeOfTransport of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipFromAddress1 | String | ShipFromAddress1 of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipFromAddress2 | String | ShipFromAddress2 of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipFromAddress3 | String | ShipFromAddress3 of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipFromAddress4 | String | ShipFromAddress4 of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipFromCity | String | ShipFromCity of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipFromCounty | String | ShipFromCounty of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipFromState | String | ShipFromState of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipFromRegion | String | ShipFromRegion of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipFromCountry | String | ShipFromCountry of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipFromPostalCode | String | ShipFromPostalCode of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipToAddress1 | String | ShipToAddress1 of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipToAddress2 | String | ShipToAddress2 of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipToAddress3 | String | ShipToAddress3 of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipToAddress4 | String | ShipToAddress4 of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipToCity | String | ShipToCity of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipToCounty | String | ShipToCounty of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipToState | String | ShipToState of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipToRegion | String | ShipToRegion of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipToCountry | String | ShipToCountry of ShipmentsouterPackingUnitsinnerPackingUnits |
ShipToPostalCode | String | ShipToPostalCode of ShipmentsouterPackingUnitsinnerPackingUnits |
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 |
BaseItem | String | BaseItem |
DeliveryId | Long | DeliveryId |
EndAssemblyItemNumber | String | EndAssemblyItemNumber |
IntegrationStatus | String | IntegrationStatus |
Item | String | Item |
LineStatus | String | LineStatus |
OrderNumber | String | OrderNumber |
OrderType | String | OrderType |
OrderTypeCode | String | OrderTypeCode |
PickWave | String | PickWave |
QuickShipStatus | String | QuickShipStatus |
RcvShipmentLineId | Long | RcvShipmentLineId |
ShipToCustomer | String | ShipToCustomer |
ShipToPartyId | String | ShipToPartyId |
Shipment | String | Shipment |
ShipmentSet | String | ShipmentSet |
SourceOrder | String | SourceOrder |
SourceOrderFulfillmentLine | String | SourceOrderFulfillmentLine |
SourceOrderFulfillmentLineId | String | SourceOrderFulfillmentLineId |
SourceOrderLine | String | SourceOrderLine |
SourceSystemId | String | SourceSystemId |
TradeComplianceStatus | String | TradeComplianceStatus |
TransportationPlanningStatus | String | TransportationPlanningStatus |
Finder | String | finder |