ShipmentsouterPackingUnitspackingUnitCosts
ShipmentsouterPackingUnitspackingUnitCosts
Columns
| Name | Type | Description |
| ShipmentsDeliveryId [KEY] | Long | ShipmentsDeliveryId of ShipmentsouterPackingUnitspackingUnitCosts |
| OuterpackingunitsLPNId [KEY] | Long | OuterpackingunitsLPNId of ShipmentsouterPackingUnitspackingUnitCosts |
| FreightCostId [KEY] | Long | FreightCostId of ShipmentsouterPackingUnitspackingUnitCosts |
| DeliveryDetailId | Long | DeliveryDetailId of ShipmentsouterPackingUnitspackingUnitCosts |
| LPNId | Long | LPNId of ShipmentsouterPackingUnitspackingUnitCosts |
| PackingUnit | String | PackingUnit of ShipmentsouterPackingUnitspackingUnitCosts |
| ShippingCostTypeId | Long | ShippingCostTypeId of ShipmentsouterPackingUnitspackingUnitCosts |
| ShippingCost | String | ShippingCost of ShipmentsouterPackingUnitspackingUnitCosts |
| ShippingCostTypeCategoryCode | String | ShippingCostTypeCategoryCode of ShipmentsouterPackingUnitspackingUnitCosts |
| ShippingCostTypeCategory | String | ShippingCostTypeCategory of ShipmentsouterPackingUnitspackingUnitCosts |
| Amount | Double | Amount of ShipmentsouterPackingUnitspackingUnitCosts |
| CurrencyCode | String | CurrencyCode of ShipmentsouterPackingUnitspackingUnitCosts |
| CurrencyName | String | CurrencyName of ShipmentsouterPackingUnitspackingUnitCosts |
| ConversionRateTypeCode | String | ConversionRateTypeCode of ShipmentsouterPackingUnitspackingUnitCosts |
| ConversionRateType | String | ConversionRateType of ShipmentsouterPackingUnitspackingUnitCosts |
| ConversionRate | Double | ConversionRate of ShipmentsouterPackingUnitspackingUnitCosts |
| ConversionDate | Date | ConversionDate of ShipmentsouterPackingUnitspackingUnitCosts |
| CreatedBy | String | CreatedBy of ShipmentsouterPackingUnitspackingUnitCosts |
| CreationDate | Datetime | CreationDate of ShipmentsouterPackingUnitspackingUnitCosts |
| LastUpdatedBy | String | LastUpdatedBy of ShipmentsouterPackingUnitspackingUnitCosts |
| LastUpdateDate | Datetime | LastUpdateDate of ShipmentsouterPackingUnitspackingUnitCosts |
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 |
| ParentPackingUnit | String | ParentPackingUnit |
| 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 |