Inventory Item
InventoryItem
34 columns Fetched February 27, 2026
Columns
IV_Item_RecID Numeric
Item_ID Text nullable
Description Text nullable
IV_Type_RecID Numeric nullable
Also in 2 reports
IV_SubCat_RecID Numeric nullable
Also in 2 reports
Short_Name Numeric nullable
IV_UOM_RecID Numeric nullable
Also in 1 report
Std_Cost Numeric nullable
Current_Cost Numeric nullable
List_Price Numeric
Taxable_Flag Boolean
Min_SO_Qty Numeric nullable
Max_SO_Qty Numeric nullable
Alt_Item_ID Numeric nullable
Mfg_Item_ID Text nullable
Inactive_Flag Boolean
Long_Description Text nullable
Serialized_Flag Boolean nullable
Average_Value Numeric nullable
IV_Class_ID Text nullable
Manufacturer_RecID Numeric nullable
Also in 3 reports
Vendor_RecID Numeric nullable
Also in 1 report
Vendor_SKU Text nullable
Notes Text nullable
Minimum_Stock Numeric nullable
IV_Price_Attribute_ID Text nullable
Calc_Price_Flag Boolean
Calc_Cost_Flag Boolean
SerializedCost_Flag Boolean
Phase_Product_Flag Boolean
Updated_By Text nullable
Last_Update DateTime
Date_Entered_UTC DateTime
Time_Zone Text nullable
| Name | Type | Nullable | Also In |
|---|---|---|---|
| IV_Item_RecID | Numeric | No | |
| Item_ID | Text | Yes | unique |
| Description | Text | Yes | unique |
| IV_Type_RecID | Numeric | Yes | 2 reports |
| IV_SubCat_RecID | Numeric | Yes | 2 reports |
| Short_Name | Numeric | Yes | unique |
| IV_UOM_RecID | Numeric | Yes | 1 report |
| Std_Cost | Numeric | Yes | unique |
| Current_Cost | Numeric | Yes | unique |
| List_Price | Numeric | No | unique |
| Taxable_Flag | Boolean | No | unique |
| Min_SO_Qty | Numeric | Yes | unique |
| Max_SO_Qty | Numeric | Yes | unique |
| Alt_Item_ID | Numeric | Yes | unique |
| Mfg_Item_ID | Text | Yes | unique |
| Inactive_Flag | Boolean | No | unique |
| Long_Description | Text | Yes | unique |
| Serialized_Flag | Boolean | Yes | unique |
| Average_Value | Numeric | Yes | unique |
| IV_Class_ID | Text | Yes | unique |
| Manufacturer_RecID | Numeric | Yes | 3 reports |
| Vendor_RecID | Numeric | Yes | 1 report |
| Vendor_SKU | Text | Yes | unique |
| Notes | Text | Yes | unique |
| Minimum_Stock | Numeric | Yes | unique |
| IV_Price_Attribute_ID | Text | Yes | unique |
| Calc_Price_Flag | Boolean | No | unique |
| Calc_Cost_Flag | Boolean | No | unique |
| SerializedCost_Flag | Boolean | No | unique |
| Phase_Product_Flag | Boolean | No | unique |
| Updated_By | Text | Yes | unique |
| Last_Update | DateTime | No | unique |
| Date_Entered_UTC | DateTime | No | unique |
| Time_Zone | Text | Yes | unique |