Inventory_statuses

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.

Columns

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)

Primary key

PK Column Name
inventorystatus_id