ShipmentTransactionRequestsshipmentsouterPackingUnitscosts
ShipmentTransactionRequestsshipmentsouterPackingUnitscosts
Columns
| Name | Type | Description |
| ShipmentTransactionRequestsTransactionId [KEY] | Long | ShipmentTransactionRequestsTransactionId of ShipmentTransactionRequestsshipmentsouterPackingUnitscosts |
| ShipmentsDeliveryInterfaceId [KEY] | Long | ShipmentsDeliveryInterfaceId of ShipmentTransactionRequestsshipmentsouterPackingUnitscosts |
| OuterpackingunitsLPNInterfaceId [KEY] | Long | OuterpackingunitsLPNInterfaceId of ShipmentTransactionRequestsshipmentsouterPackingUnitscosts |
| FreightCostInterfaceId [KEY] | Long | FreightCostInterfaceId of ShipmentTransactionRequestsshipmentsouterPackingUnitscosts |
| ShippingCostType | String | Type of cost that is predefined in the application. |
| Amount | Double | Amount for the shipping cost for each unit. |
| Currency | String | Abbreviation that identifies the currency of the shipping cost. |
| ConversionRate | Double | Rate of the currency conversion. |
| ConversionDate | Date | Date when the currency conversion occurred. |
| ConversionRateTypeCode | String | Abbreviation that identifies the type of currency conversion. |
| Subinventory | String | Subinventory to use when fulfilling the item to be shipped. |
| Locator | String | Concatenated name of the inventory locator that provides the source for material that ships. |
| CreatedBy | String | CreatedBy of ShipmentTransactionRequestsshipmentsouterPackingUnitscosts |
| CreationDate | Datetime | CreationDate of ShipmentTransactionRequestsshipmentsouterPackingUnitscosts |
| LastUpdatedBy | String | LastUpdatedBy of ShipmentTransactionRequestsshipmentsouterPackingUnitscosts |
| LastUpdateDate | Datetime | LastUpdateDate of ShipmentTransactionRequestsshipmentsouterPackingUnitscosts |
| Errors | String | errors |
| DFF | String | DFF |
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 |
| PackingUnit | String | PackingUnit |
| 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 |