ShipmentsunpackedShipmentLinesshipmentLineSerials

Columns


Name	Type	Description
ShipmentsDeliveryId [KEY]	Long	ShipmentsDeliveryId of ShipmentsunpackedShipmentLinesshipmentLineSerials
UnpackedshipmentlinesShipmentLine [KEY]	Long	UnpackedshipmentlinesShipmentLine of ShipmentsunpackedShipmentLinesshipmentLineSerials
FromSerialNumber [KEY]	String	FromSerialNumber of ShipmentsunpackedShipmentLinesshipmentLineSerials
ToSerialNumber	String	ToSerialNumber of ShipmentsunpackedShipmentLinesshipmentLineSerials
UniqueLineNumber [KEY]	Long	UniqueLineNumber of ShipmentsunpackedShipmentLinesshipmentLineSerials
TransactionTempId	Double	TransactionTempId of ShipmentsunpackedShipmentLinesshipmentLineSerials
DeliveryDetailId	Double	DeliveryDetailId of ShipmentsunpackedShipmentLinesshipmentLineSerials
SupplierSerialNumber	String	SupplierSerialNumber of ShipmentsunpackedShipmentLinesshipmentLineSerials

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