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