InventoryStagedTransactionslotslotSerials

Columns


Name	Type	Description
InventoryStagedTransactionsTransactionInterfaceId [KEY]	Long	InventoryStagedTransactionsTransactionInterfaceId of InventoryStagedTransactionslotslotSerials
LotsLotNumber [KEY]	String	LotsLotNumber of InventoryStagedTransactionslotslotSerials
LotsTransactionInterfaceId [KEY]	Long	LotsTransactionInterfaceId of InventoryStagedTransactionslotslotSerials
TransactionInterfaceId [KEY]	Long	Value that uniquely identifies the transaction.
FmSerialNumber [KEY]	String	Starting serial number in a range of serial numbers.
ToSerialNumber	String	Ending serial number in a range of serial numbers.
SourceCode	String	Abbreviation that identifies the source.
SourceLineId	Long	Value that uniquely identifies the source line.
ErrorCode	String	Abbreviation that identifies the error.
OriginationDate	Date	Date when this lot serial originated.
StatusId	Long	Value that uniquely identifies the status.
StatusName	String	Description of the status.
StatusCode	String	Abbreviation that identifies the status.

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