Items

The Item Fields custom field is available for the Items table.

Columns

Name	Type	Length	Precision	Scale	References	In	Description
allow_drop_ship	VARCHAR2	3					Drop ship item
alt_demand_source_item_id	NUMBER		39	0			Alternative demand source item ID
asset_account_id	NUMBER		39	0			Asset account ID
atp_lead_time	NUMBER		39	0			ATP lead time
atp_method	VARCHAR2	150					ATP method
available_to_partners	VARCHAR2	3					Available to partners
averagecost	NUMBER		30	15			Average cost
backward_consumption_days	NUMBER		39	0			Backward consumption days
bill_exch_rate_var_account_id	NUMBER		39	0			Bill exchange rate variance account ID
bill_price_variance_account_id	NUMBER		39	0			Bill price variance account ID
bill_qty_variance_account_id	NUMBER		39	0			Bill quantity variance account ID
build_sub_assemblies	VARCHAR2	1					Build sub-assemblies
class_id	NUMBER		39	0			Class ID
cost_0	NUMBER		30	15			Cost
cost_category	VARCHAR2	50					Cost category
cost_estimate_type	VARCHAR2	200					Cost estimate type
costing_method	VARCHAR2	16					Costing method
country_of_manufacture	VARCHAR2	6					Country of manufacture
create_plan_on_event_type	VARCHAR2	128					Whether to create a revenue recognition plan on the event type
created	TIMESTAMP						Date created (GMT)
current_on_order_count	NUMBER		21	11			Quantity on order
custreturn_variance_account_id	NUMBER		39	0			Customer return variance account ID
date_last_modified	TIMESTAMP						Date last modified
date_of_last_transaction	TIMESTAMP						Date of last transaction
default_return_cost	NUMBER		30	15			Default return cost
deferred_expense_account_id	NUMBER		39	0			ID of Deferred Expense Account
deferred_revenue_account_id	NUMBER		39	0			ID of Deferred Revenue Account
demand_source	VARCHAR2	50					Demand source
demand_time_fence	NUMBER		39	0			Demand time fence
department_id	NUMBER		39	0			Department ID
deposit	VARCHAR2	3					Deposit
displayname	VARCHAR2	4000					Store display name
distribution_category	VARCHAR2	60					Distribution category
distribution_network	VARCHAR2	100					Distribution network
dropship_expense_account_id	NUMBER		39	0			Dropship expense account ID
effective_bom_control_type	VARCHAR2	150					Effective BOM lot type
expense_account_id	NUMBER		39	0			Expense account
featureddescription	VARCHAR2	65534					Featured description
featureditem	VARCHAR2	3					Featured item
fixed_lot_size	NUMBER		39	0			Fixed lot size
forward_consumption_days	NUMBER		39	0			Forward consumption days
fraud_risk	VARCHAR2	128					Fraud risk
full_name	VARCHAR2	600					Full name
fx_adjustment_account_id	NUMBER		39	0			Foreign exchange adjustment account ID
gain_loss_account_id	NUMBER		39	0			Gain loss account ID
handling_cost	NUMBER		30	15			Handling cost
hazmat	VARCHAR2	1					Hazmat
hazmat_hazard_class	VARCHAR2	50					Hazmat hazard class
hazmat_id	VARCHAR2	50					Hazmat ID
hazmat_item_units	VARCHAR2	20					Hazmat item units
hazmat_item_units_qty	NUMBER		39	0			Hazmat item units quantity
hazmat_packing_group	VARCHAR2	10					Hazmat packing group
hazmat_shipping_name	VARCHAR2	100					Hazmat shipping name
include_child_subsidiaries	VARCHAR2	3					Include child subsidiaries
income_account_id	NUMBER		39	0			Income account
interco_expense_account_id	NUMBER		39	0			Intercompany expense account ID
interco_income_account_id	NUMBER		39	0			Intercompany income account ID
invt_count_classification	NUMBER		39	0			Inventory count classification
invt_count_interval	NUMBER		39	0			Inventory count interval
is_cont_rev_handling	VARCHAR2	3					Whether the book is subject to contingent revenue handling
is_enforce_min_qty_internally	VARCHAR2	3					Whether the minimum quantity should be enforced on all orders
is_hold_rev_rec	VARCHAR2	3					Whether to put revenue recognition plan on hold
is_moss	VARCHAR2	3					Whether requires the MOSS taxation scheme
is_phantom	VARCHAR2	3					Whether the item produces phantom income
is_special_order_item	VARCHAR2	3					Whether the item is a special order item
isinactive	VARCHAR2	3					Item is inactive
isonline	VARCHAR2	3					Display in web site
istaxable	VARCHAR2	3					Taxable
item_defined_cost	NUMBER		30	15			Item defined cost
item_extid	VARCHAR2	255					Item external ID
item_id	NUMBER		39	0			Item ID
item_revenue_category	VARCHAR2	250					Item revenue category
last_cogs_correction	TIMESTAMP						Last COGS correction
last_invt_count_date	TIMESTAMP						Last inventory count days
last_purchase_price	NUMBER		39	0			Last purchase price
location_id	NUMBER		39	0			Location ID
lot_numbered_item	VARCHAR2	1					Lot numbered item
lot_sizing_method	VARCHAR2	50					Lot sizing method
manufacturer	VARCHAR2	200					Manufacturer
manufacturing_charge_item	VARCHAR2	3					Manufacturing charge item
match_bill_to_receipt	VARCHAR2	1					Match bill to receipt
maximum_quantity	NUMBER		39	0			Maximum quantity
minimum_quantity	NUMBER		39	0			Minimum quantity
modified	TIMESTAMP						Modified (GMT)
mpn	VARCHAR2	100					MPN
name	VARCHAR2	180					Name
next_invt_count_date	TIMESTAMP						Next inventory count days
ns_lead_time	NUMBER		39	0			NetSuite lead time
offersupport	VARCHAR2	3					Offer support
onspecial	VARCHAR2	3					On special
overhead_type	VARCHAR2	100					Overhead type
parent_id	NUMBER		39	0			Subitem of
payment_method_id	NUMBER		39	0			Payment method ID
periodic_lot_size_days	NUMBER		39	0			Periodic lot size days
periodic_lot_size_type	VARCHAR2	50					Periodic lot size type
pref_purchase_tax_id	NUMBER		39	0			Preferred purchase tax ID
pref_sale_tax_id	NUMBER		39	0			Preferred sales tax ID
pref_stock_level	NUMBER		39	0			Preferred stock level
prices_include_tax	VARCHAR2	1					Prices include tax
pricing_group_id	NUMBER		39	0			Pricing Group ID
print_sub_items	VARCHAR2	3					Print sub items
prod_price_var_account_id	NUMBER		39	0			product price variance account ID
prod_qty_var_account_id	NUMBER		39	0			product quantity variance account ID
purchase_price_var_account_id	NUMBER		39	0			Purchase price variance account ID
purchase_unit_id	NUMBER		39	0			Purchase unit ID
purchasedescription	VARCHAR2	4000					Purchase description
purchaseorderamount	NUMBER		20	2			Purchase order amount
purchaseorderquantity	NUMBER		18	8			Purchase order quantity
purchaseorderquantitydiff	NUMBER		18	8			Purchase order quantity difference
quantityavailable	NUMBER		39	0			Quantity available
quantitybackordered	NUMBER		39	0			Quantity back ordered
quantityonhand	NUMBER		21	11			Quantity on hand
receiptamount	NUMBER		20	2			Receipt amount
receiptquantity	NUMBER		18	8			Receipt quantity
receiptquantitydiff	NUMBER		18	8			Receipt quantity difference
reorder_multiple	NUMBER		39	0			Re-order multiple
reorderpoint	NUMBER		21	11			Reorder point
replenishment_method	VARCHAR2	50					Replenishment method
resalable	VARCHAR2	3					Resalable
reschedule_in_days	NUMBER		39	0			Reschedule in days
reschedule_out_days	NUMBER		39	0			Reschedule out days
rev_rec_forecast_rule_id	NUMBER		39	0			Revenue recognition forecast rule ID
rev_rec_rule_id	NUMBER		39	0			Revenue recognition rule ID
revenue_allocation_group	VARCHAR2	60					Revenue allocation group
round_up_as_component	VARCHAR2	3					Round up as component
safety_stock_days	NUMBER		39	0			Safety stock days
safety_stock_level	NUMBER		39	0			Safety stock level
sale_unit_id	NUMBER		39	0			Sale unit ID
salesdescription	VARCHAR2	4000					Sales description
salesprice	VARCHAR2	42					Sales price
scrap_account_id	NUMBER		39	0			Scrap account ID
serialized_item	VARCHAR2	1					Serialized item
shippingcost	NUMBER		30	15			Shipping cost
special_work_order_item	VARCHAR2	1					Special work order Item
specialsdescription	VARCHAR2	65534					Specials description
stock_unit_id	NUMBER		39	0			Stock unit ID
storedescription	VARCHAR2	4000					Store description
storedetaileddescription	VARCHAR2	65534					Detailed description
storedisplayname	VARCHAR2	4000					Store display name
subtype	VARCHAR2	10					Subtype
supply_time_fence	NUMBER		39	0			Supply time fence
supply_type	VARCHAR2	50					Supply type
tax_item_id	NUMBER		39	0			Tax item ID
totalvalue	NUMBER		29	11			Total value
transferprice	NUMBER		30	15			Transfer price
type_name	VARCHAR2	128					Type name
unbuild_variance_account_id	NUMBER		39	0			Un-build variance account ID
units_type_id	NUMBER		39	0			Units type used by the item
upc_code	VARCHAR2	180					UPC code
use_component_yield	VARCHAR2	3					Use component yield
vendor_id	NUMBER		39	0			Vendor ID
vendorname	VARCHAR2	60					Vendor name
vendreturn_variance_account_id	NUMBER		39	0			Vendor return variance account ID
vsoe_deferral	VARCHAR2	28					VSOE deferral
vsoe_delivered	VARCHAR2	3					VSOE delivered
vsoe_discount	VARCHAR2	12					VSOE discount
vsoe_price	NUMBER		30	15			VSOE price
weight	NUMBER		21	11			Item weight
weight_in_user_defined_unit	NUMBER		39	0			Weight in user defined unit
weight_unit_index	NUMBER		39	0			Weight unit index
wip_account_id	NUMBER		39	0			Wip account ID
wip_cost_variance_account_id	NUMBER		39	0			Wip cost variance account ID
work_order_lead_time	NUMBER		39	0			Work order — lead time

Primary key

PK Column Name
item_id

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Billing_subscription_lines_items_fk	item_id	Billing_subscription_lines	item_id	1
Campaignitem_items_fk	item_id	Campaignitem	item_id	1
Customers_items_fk	item_id	Customers	tax_item_id	1
Item_subsidiary_map_items_fk	item_id	Item_subsidiary_map	item_id	1
Item_vendor_map_items_fk	item_id	Item_vendor_map	item_id	1
Item_vendor_pricing_items_fk	item_id	Item_vendor_pricing	item_id	1
Notes_system_custom_items_fk	item_id	Notes_system_custom	item_id	1
Notes_system_items_fk	item_id	Notes_system	item_id	1
Notes_user_items_fk	item_id	Notes_user	item_id	1
Opportunity_lines_items_fk	item_id	Opportunity_lines	item_id	1
Opportunity_lines_items_fk_2	item_id	Opportunity_lines	tax_item_id	1
Posting_account_activity_items_fk	item_id	Posting_account_activity	item_id	1
Subscription_co_lines_items_fk	item_id	Subscription_co_lines	plan_item_id	1
Subscription_plan_lines_items_fk	item_id	Subscription_plan_lines	item_id	1
Support_incidents_items_fk	item_id	Support_incidents	item_id	1
System_notes_custom_items_fk	item_id	System_notes_custom	item_id	1
System_notes_items_fk	item_id	System_notes	item_id	1
Transaction_tax_detail_items_fk	item_id	Transaction_tax_detail	tax_item_id	1