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
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 |