ShipmentsouterPackingUnitsshipmentLineslinePackingInstructions

Columns


Name	Type	Description
ShipmentsDeliveryId [KEY]	Long	ShipmentsDeliveryId of ShipmentsouterPackingUnitsshipmentLineslinePackingInstructions
OuterpackingunitsLPNId [KEY]	Long	OuterpackingunitsLPNId of ShipmentsouterPackingUnitsshipmentLineslinePackingInstructions
ShipmentlinesShipmentLine [KEY]	Long	ShipmentlinesShipmentLine of ShipmentsouterPackingUnitsshipmentLineslinePackingInstructions
NoteId [KEY]	Long	NoteId of ShipmentsouterPackingUnitsshipmentLineslinePackingInstructions
PackingInstructions	String	PackingInstructions of ShipmentsouterPackingUnitsshipmentLineslinePackingInstructions

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