ShipmentsouterPackingUnits
ShipmentsouterPackingUnits
Columns
| Name | Type | Description |
| ShipmentsDeliveryId [KEY] | Long | ShipmentsDeliveryId of ShipmentsouterPackingUnits |
| LPNId [KEY] | Long | LPNId of ShipmentsouterPackingUnits |
| LicensePlateNumber | String | LicensePlateNumber of ShipmentsouterPackingUnits |
| TrackingNumber | String | TrackingNumber of ShipmentsouterPackingUnits |
| MasterSerialNumber | String | MasterSerialNumber of ShipmentsouterPackingUnits |
| SealNumber | String | SealNumber of ShipmentsouterPackingUnits |
| InventoryItemId | Long | InventoryItemId of ShipmentsouterPackingUnits |
| ContainerItem | String | ContainerItem of ShipmentsouterPackingUnits |
| ContainerItemDescription | String | ContainerItemDescription of ShipmentsouterPackingUnits |
| ContainerVolume | Double | ContainerVolume of ShipmentsouterPackingUnits |
| ContainerVolumeUOMCode | String | ContainerVolumeUOMCode of ShipmentsouterPackingUnits |
| ContainerVolumeUOM | String | ContainerVolumeUOM of ShipmentsouterPackingUnits |
| FOBCode | String | FOBCode of ShipmentsouterPackingUnits |
| FOB | String | FOB of ShipmentsouterPackingUnits |
| GrossWeight | Double | GrossWeight of ShipmentsouterPackingUnits |
| GrossWeightUOMCode | String | GrossWeightUOMCode of ShipmentsouterPackingUnits |
| GrossWeightUOM | String | GrossWeightUOM of ShipmentsouterPackingUnits |
| TareWeight | Double | TareWeight of ShipmentsouterPackingUnits |
| TareWeightUOMCode | String | TareWeightUOMCode of ShipmentsouterPackingUnits |
| TareWeightUOM | String | TareWeightUOM of ShipmentsouterPackingUnits |
| NetWeight | Double | NetWeight of ShipmentsouterPackingUnits |
| NetWeightUOMCode | String | NetWeightUOMCode of ShipmentsouterPackingUnits |
| NetWeightUOM | String | NetWeightUOM of ShipmentsouterPackingUnits |
| PackingUnitCategoryCode | String | PackingUnitCategoryCode of ShipmentsouterPackingUnits |
| PackingUnitCategory | String | PackingUnitCategory of ShipmentsouterPackingUnits |
| UnitHeight | Double | UnitHeight of ShipmentsouterPackingUnits |
| UnitLength | Double | UnitLength of ShipmentsouterPackingUnits |
| UnitWidth | Double | UnitWidth of ShipmentsouterPackingUnits |
| DimensionUOMCode | String | DimensionUOMCode of ShipmentsouterPackingUnits |
| DimensionUOM | String | DimensionUOM of ShipmentsouterPackingUnits |
| ParentLPNId | Long | ParentLPNId of ShipmentsouterPackingUnits |
| ParentPackingUnit | String | ParentPackingUnit of ShipmentsouterPackingUnits |
| OutermostPackingUnitId | Long | OutermostPackingUnitId of ShipmentsouterPackingUnits |
| OutermostPackingUnit | String | OutermostPackingUnit of ShipmentsouterPackingUnits |
| PercentageFilled | Long | PercentageFilled of ShipmentsouterPackingUnits |
| VolumeFilled | Long | VolumeFilled of ShipmentsouterPackingUnits |
| ShipFromLocationId | Long | ShipFromLocationId of ShipmentsouterPackingUnits |
| ShipToLocationId | Long | ShipToLocationId of ShipmentsouterPackingUnits |
| CarrierId | Long | CarrierId of ShipmentsouterPackingUnits |
| Carrier | String | Carrier of ShipmentsouterPackingUnits |
| CarrierNumber | String | CarrierNumber of ShipmentsouterPackingUnits |
| ServiceLevelCode | String | ServiceLevelCode of ShipmentsouterPackingUnits |
| ServiceLevel | String | ServiceLevel of ShipmentsouterPackingUnits |
| ModeOfTransportCode | String | ModeOfTransportCode of ShipmentsouterPackingUnits |
| ModeOfTransport | String | ModeOfTransport of ShipmentsouterPackingUnits |
| ShipFromAddress1 | String | ShipFromAddress1 of ShipmentsouterPackingUnits |
| ShipFromAddress2 | String | ShipFromAddress2 of ShipmentsouterPackingUnits |
| ShipFromAddress3 | String | ShipFromAddress3 of ShipmentsouterPackingUnits |
| ShipFromAddress4 | String | ShipFromAddress4 of ShipmentsouterPackingUnits |
| ShipFromCity | String | ShipFromCity of ShipmentsouterPackingUnits |
| ShipFromCounty | String | ShipFromCounty of ShipmentsouterPackingUnits |
| ShipFromState | String | ShipFromState of ShipmentsouterPackingUnits |
| ShipFromRegion | String | ShipFromRegion of ShipmentsouterPackingUnits |
| ShipFromCountry | String | ShipFromCountry of ShipmentsouterPackingUnits |
| ShipFromPostalCode | String | ShipFromPostalCode of ShipmentsouterPackingUnits |
| ShipToAddress1 | String | ShipToAddress1 of ShipmentsouterPackingUnits |
| ShipToAddress2 | String | ShipToAddress2 of ShipmentsouterPackingUnits |
| ShipToAddress3 | String | ShipToAddress3 of ShipmentsouterPackingUnits |
| ShipToAddress4 | String | ShipToAddress4 of ShipmentsouterPackingUnits |
| ShipToCity | String | ShipToCity of ShipmentsouterPackingUnits |
| ShipToCounty | String | ShipToCounty of ShipmentsouterPackingUnits |
| ShipToState | String | ShipToState of ShipmentsouterPackingUnits |
| ShipToRegion | String | ShipToRegion of ShipmentsouterPackingUnits |
| ShipToCountry | String | ShipToCountry of ShipmentsouterPackingUnits |
| ShipToPostalCode | String | ShipToPostalCode of ShipmentsouterPackingUnits |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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 |