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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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 |