InventoryItemSerialNumbers
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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| BindInventoryItemId | Long | bindInventoryItemId |
| BindItemNumber | String | bindItemNumber |
| BindLotNumber | String | bindLotNumber |
| BindOrganizationCode | String | bindOrganizationCode |
| BindSerialNumber | String | bindSerialNumber |
| Finder | String | finder |