ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials
ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials
Columns
Name | Type | Description |
ShipmentsDeliveryId [KEY] | Long | ShipmentsDeliveryId of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials |
OuterpackingunitsLPNId [KEY] | Long | OuterpackingunitsLPNId of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials |
ShipmentlinesShipmentLine [KEY] | Long | ShipmentlinesShipmentLine of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials |
FromSerialNumber [KEY] | String | FromSerialNumber of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials |
ToSerialNumber | String | ToSerialNumber of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials |
UniqueLineNumber [KEY] | Long | UniqueLineNumber of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials |
TransactionTempId | Double | TransactionTempId of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials |
DeliveryDetailId | Double | DeliveryDetailId of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials |
SupplierSerialNumber | String | SupplierSerialNumber of ShipmentsouterPackingUnitsshipmentLinesshipmentLineSerials |
AttributeDFF | String | attributeDFF |
StandardDFF | String | standardDFF |
SerialNumbers | String | serialNumbers |
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 |