Product

Product

55 columns Fetched February 27, 2026

n8n

Columns

Sub_Number Numeric
IsParent Numeric
parent_recid Numeric nullable
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
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