The Item Number Fields and Item Fields custom fields are available for the Inventory Number table. Inventory number is another term for serial number or lot number.
| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| available_count | NUMBER | 39 | 0 | Available count | |||
| date_last_modified | TIMESTAMP | Date last modified | |||||
| expiration_date | TIMESTAMP | Expiration date | |||||
| in_transit_count | NUMBER | 39 | 0 | In transit count | |||
| inventory_number | VARCHAR2 | 100 | Inventory number or serial number | ||||
| inventory_number_id | NUMBER | 39 | 0 | Inventory number ID | |||
| item_id | NUMBER | 39 | 0 | Item ID | |||
| location_id | NUMBER | 39 | 0 | Location ID | |||
| memo | VARCHAR2 | 4000 | Memo | ||||
| number_type | VARCHAR2 | 6 | Number type | ||||
| on_hand_count | NUMBER | 39 | 0 | On hand count | |||
| on_order_count | NUMBER | 39 | 0 | On order count |