InventoryCompletedTransactionslots

Columns


Name	Type	Description
InventoryCompletedTransactionsTransactionId [KEY]	Long	InventoryCompletedTransactionsTransactionId of InventoryCompletedTransactionslots
LotNumber [KEY]	String	LotNumber of InventoryCompletedTransactionslots
ParentLot	String	ParentLot of InventoryCompletedTransactionslots
TransactionQuantity	Double	TransactionQuantity of InventoryCompletedTransactionslots
Status	String	Status of InventoryCompletedTransactionslots
StatusId	Long	StatusId of InventoryCompletedTransactionslots
SupplierLotNumber	String	SupplierLotNumber of InventoryCompletedTransactionslots
GradeCode	String	GradeCode of InventoryCompletedTransactionslots
OriginationTypeCode	Long	OriginationTypeCode of InventoryCompletedTransactionslots
OriginationType	String	OriginationType of InventoryCompletedTransactionslots
OriginationDate	Date	OriginationDate of InventoryCompletedTransactionslots
RetestDate	Date	RetestDate of InventoryCompletedTransactionslots
ExpirationActionCode	String	ExpirationActionCode of InventoryCompletedTransactionslots
ExpirationAction	String	ExpirationAction of InventoryCompletedTransactionslots
ExpirationActionDate	Date	ExpirationActionDate of InventoryCompletedTransactionslots
HoldDate	Date	HoldDate of InventoryCompletedTransactionslots
MaturityDate	Date	MaturityDate of InventoryCompletedTransactionslots
Reason	String	Reason of InventoryCompletedTransactionslots
ReasonId	Long	ReasonId of InventoryCompletedTransactionslots

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