InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials

Columns


Name	Type	Description
InventoryConsumptionAdvicesConsumptionHeaderId [KEY]	Long	InventoryConsumptionAdvicesConsumptionHeaderId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials
InventoryConsumptionAdvicesRevision [KEY]	Long	InventoryConsumptionAdvicesRevision of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials
ConsumptionadvicelinesConsumptionLineId [KEY]	Long	ConsumptionadvicelinesConsumptionLineId of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials
ConsumptionadvicelotsLotNumber [KEY]	String	ConsumptionadvicelotsLotNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials
SerialNumber [KEY]	String	SerialNumber of InventoryConsumptionAdvicesconsumptionAdviceLinesconsumptionAdviceLotsconsumptionAdviceLotsAndSerials

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。