This table can be used to view the statuses available on the accounts. It contains inventory status data which is displayed as a column in the Inventory Detail subrecord when the Inventory Status feature is enabled.
Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
description | VARCHAR2 | 4000 | Description | ||||
description_translated | VARCHAR2 | 4000 | Description translated in the language available on the NetSuite account | ||||
inventorystatus_extid | VARCHAR2 | 255 | External ID of the inventory status | ||||
inventorystatus_id | NUMBER | 39 | 0 | Inventory Status ID | |||
is_inactive | VARCHAR2 | 3 | Is inactive | ||||
is_inventory_avail_allocation | VARCHAR2 | 3 | Whether the inventory associated with the status is available for order allocation | ||||
is_inventory_avail_commitment | VARCHAR2 | 3 | Whether the inventory associated with the status is available for order commitment | ||||
name | VARCHAR2 | 180 | Unique name for the inventory status | ||||
name_translated | VARCHAR2 | 180 | Name translated in the language available on the NetSuite account | ||||
state | VARCHAR2 | 1 | Whether the state is Active (A), Default (D), or Inactive (I) |
PK Column Name |
---|
inventorystatus_id |