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