TrunkStocks

Columns


Name	Type	Description
StockLocationId	Long	StockLocationId of TrunkStocks
OrganizationId [KEY]	Long	OrganizationId of TrunkStocks
OrganizationCode	String	OrganizationCode of TrunkStocks
Subinventory [KEY]	String	Subinventory of TrunkStocks
InventoryItemId [KEY]	Long	InventoryItemId of TrunkStocks
ItemNumber	String	ItemNumber of TrunkStocks
Revision	String	Revision of TrunkStocks
ItemSerialControl	Double	ItemSerialControl of TrunkStocks
UOMCode	String	UOMCode of TrunkStocks
UnitOfMeasure	String	UnitOfMeasure of TrunkStocks
TotalQoh	Double	TotalQoh of TrunkStocks
TotalAvailable	Double	TotalAvailable of TrunkStocks
RecoveredPartDispCode	String	RecoveredPartDispCode of TrunkStocks
SerialNumber [KEY]	String	SerialNumber of TrunkStocks
TransactionDate	Datetime	TransactionDate of TrunkStocks
ItemDescription	String	ItemDescription of TrunkStocks

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