Product
Product
55 columns Fetched February 27, 2026
Columns
Sub_Number Numeric
IsParent Numeric
parent_recid Numeric nullable
IV_Product_RecID Numeric
iv_item_recid Numeric
item_id Text nullable
item_desc Text nullable
item_category Text nullable
item_subcategory Text nullable
owner_level_recid Numeric
Location Text nullable
billing_log_recid Numeric nullable
BusGroup Text nullable
company_recid Numeric nullable
company_name Text nullable
te_status_id Numeric
time_status Text nullable
option_id Text nullable
billable_flag Boolean
invoice_flag Boolean
Date_Entered DateTime nullable
Quantity Numeric nullable
uom Text nullable
unit_cost Numeric nullable
unit_price Numeric nullable
Billable_Amt Numeric nullable
NonBillable_Amt Numeric nullable
Extended_Cost Numeric nullable
Quantity_Picked_Extended_Cost Numeric nullable
Quantity_Shipped_Extended_Cost Numeric nullable
AgrAmtCovered Numeric
Agreement Text nullable
pm_project_recid Numeric nullable
project_name Text nullable
sr_service_recid Numeric nullable
sr_summary Text nullable
sr_status Text nullable
charge_to Text nullable
invoice_number Text nullable
date_invoice DateTime nullable
Line_Desc Text nullable
territory Text nullable
serial_number Text nullable
Opportunity_RecID Numeric nullable
Manufacturer_RecID Numeric nullable
Also in 3 reports
IsPhaseProduct Boolean
Updated_By Text nullable
Last_Update DateTime
Time_Zone Text nullable
Quantity_Picked Numeric
Quantity_Shipped Numeric
IV_Class_ID Text nullable
AGR_Detail_RecID Numeric nullable
Also in 1 report
Extended_Price_Amount Numeric nullable
Sequence_Number Numeric
| Name | Type | Nullable | Also In |
|---|---|---|---|
| Sub_Number | Numeric | No | unique |
| IsParent | Numeric | No | unique |
| parent_recid | Numeric | Yes | unique |
| IV_Product_RecID | Numeric | No | |
| iv_item_recid | Numeric | No | unique |
| item_id | Text | Yes | unique |
| item_desc | Text | Yes | unique |
| item_category | Text | Yes | unique |
| item_subcategory | Text | Yes | unique |
| owner_level_recid | Numeric | No | unique |
| Location | Text | Yes | unique |
| billing_log_recid | Numeric | Yes | unique |
| BusGroup | Text | Yes | unique |
| company_recid | Numeric | Yes | unique |
| company_name | Text | Yes | unique |
| te_status_id | Numeric | No | unique |
| time_status | Text | Yes | unique |
| option_id | Text | Yes | unique |
| billable_flag | Boolean | No | unique |
| invoice_flag | Boolean | No | unique |
| Date_Entered | DateTime | Yes | unique |
| Quantity | Numeric | Yes | unique |
| uom | Text | Yes | unique |
| unit_cost | Numeric | Yes | unique |
| unit_price | Numeric | Yes | unique |
| Billable_Amt | Numeric | Yes | unique |
| NonBillable_Amt | Numeric | Yes | unique |
| Extended_Cost | Numeric | Yes | unique |
| Quantity_Picked_Extended_Cost | Numeric | Yes | unique |
| Quantity_Shipped_Extended_Cost | Numeric | Yes | unique |
| AgrAmtCovered | Numeric | No | unique |
| Agreement | Text | Yes | unique |
| pm_project_recid | Numeric | Yes | unique |
| project_name | Text | Yes | unique |
| sr_service_recid | Numeric | Yes | unique |
| sr_summary | Text | Yes | unique |
| sr_status | Text | Yes | unique |
| charge_to | Text | Yes | unique |
| invoice_number | Text | Yes | unique |
| date_invoice | DateTime | Yes | unique |
| Line_Desc | Text | Yes | unique |
| territory | Text | Yes | unique |
| serial_number | Text | Yes | unique |
| Opportunity_RecID | Numeric | Yes | |
| Manufacturer_RecID | Numeric | Yes | 3 reports |
| IsPhaseProduct | Boolean | No | unique |
| Updated_By | Text | Yes | unique |
| Last_Update | DateTime | No | unique |
| Time_Zone | Text | Yes | unique |
| Quantity_Picked | Numeric | No | unique |
| Quantity_Shipped | Numeric | No | unique |
| IV_Class_ID | Text | Yes | unique |
| AGR_Detail_RecID | Numeric | Yes | 1 report |
| Extended_Price_Amount | Numeric | Yes | unique |
| Sequence_Number | Numeric | No | unique |