InventoryItemSerialNumbers

Columns


Name	Type	Description
OrganizationId [KEY]	Long	Value that uniquely identifies the organization.
OrganizationCode	String	Abbreviation that identifies the organization.
OrganizationName	String	Name of the organization.
InventoryItemId [KEY]	Long	Value that uniquely identifies the inventory item.
ItemNumber	String	Name of the inventory item.
ItemDescription	String	ItemDescription of InventoryItemSerialNumbers
SerialNumber [KEY]	String	Serial number that identifies the inventory item.
SubinventoryCode	String	SubinventoryCode of InventoryItemSerialNumbers
LocatorId	Long	LocatorId of InventoryItemSerialNumbers
Locator	String	Locator of InventoryItemSerialNumbers
LotNumber	String	LotNumber of InventoryItemSerialNumbers
Revision	String	Revision of InventoryItemSerialNumbers
StatusId	Long	Value that uniquely identifies the material status.
StatusCode	String	Abbreviation that identifies the status of the item.
UsageCode	String	UsageCode of InventoryItemSerialNumbers
Usage	String	Usage of InventoryItemSerialNumbers
ShippedDate	Datetime	ShippedDate of InventoryItemSerialNumbers
ReceiptDate	Datetime	ReceiptDate of InventoryItemSerialNumbers
Allocated	String	Allocated of InventoryItemSerialNumbers
Reserved	String	Reserved of InventoryItemSerialNumbers
Supplier	String	Name of the supplier.
SupplierLot	String	Number that identifies the supplier lot.
SupplierSerialNumber	String	Serial number assigned to the item by its supplier.

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