ShipmentsouterPackingUnitsshipmentLinesproratedCosts
ShipmentsouterPackingUnitsshipmentLinesproratedCosts
Columns
| Name | Type | Description |
| ShipmentsDeliveryId [KEY] | Long | ShipmentsDeliveryId of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| OuterpackingunitsLPNId [KEY] | Long | OuterpackingunitsLPNId of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| ShipmentlinesShipmentLine [KEY] | Long | ShipmentlinesShipmentLine of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| ProratedShippingCostId [KEY] | Long | ProratedShippingCostId of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| ShippingCostTypeId | Long | ShippingCostTypeId of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| ShippingCostType | String | ShippingCostType of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| ShippingCostTypeCategoryCode | String | ShippingCostTypeCategoryCode of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| ShippingCostTypeCategory | String | ShippingCostTypeCategory of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| ProratedAmount | Double | ProratedAmount of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| CurrencyCode | String | CurrencyCode of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| CurrencyName | String | CurrencyName of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| CreatedBy | String | CreatedBy of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| CreationDate | Datetime | CreationDate of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| LastUpdatedBy | String | LastUpdatedBy of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
| LastUpdateDate | Datetime | LastUpdateDate of ShipmentsouterPackingUnitsshipmentLinesproratedCosts |
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 |