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