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
consumption_unit_id NUMBER 39 0 Consumption unit 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 550 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
matrix_type VARCHAR2 6 If item is a matrix item, this field determines the item type. The Matrix Item type can be either Parent or Child. Otherwise the field is empty.
maximum_quantity NUMBER 39 0 Maximum quantity
metataghtml VARCHAR2 65534 Meta tag HTML field
minimum_quantity NUMBER 39 0 Minimum quantity
modified TIMESTAMP Modified (GMT)
mpn VARCHAR2 100 MPN
name VARCHAR2 250 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 500 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 4000 Type name If you want to retrieve results for a specific item type, the value you enter in your query must match the exact name of the item type that you see in the user interface. You can see all available item types in Lists > Accounting > Items > New. If the Advanced Bill of Materials feature is enabled, some names in the user interface may be different.
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 250 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
Assembly_boms_items_fk item_id Assembly_boms assembly_id 1
Bill_of_materials_items_fk item_id Bill_of_materials original_assembly_id 1
Billing_rate_cards_prices_items_fk item_id Billing_rate_cards_prices service_item_id 1
Billing_subscription_lines_items_fk item_id Billing_subscription_lines item_id 1
Bom_revision_components_items_fk item_id Bom_revision_components item_id 1
Budget_items_fk item_id Budget item_id 1
Campaignitem_items_fk item_id Campaignitem item_id 1
Customers_items_fk item_id Customers tax_item_id 1
Inbound_shipment_items_items_fk item_id Inbound_shipment_items item_id 1
Item_collection_item_map_items_fk item_id Item_collection_item_map item_id 1
Item_default_secondary_units_items_fk item_id Item_default_secondary_units item_id 1
Item_group_items_fk item_id Item_group parent_id 1
Item_price_history_items_fk item_id Item_price_history 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_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
Planned_standard_costs_items_fk item_id Planned_standard_costs item_id 1
Posting_account_activity_items_fk item_id Posting_account_activity item_id 1
Posting_account_activity_pe_items_fk item_id Posting_account_activity_pe item_id 1
Purchase_charge_rules_items_fk item_id Purchase_charge_rules mark_up_item_id 1
Standard_cost_components_items_fk item_id Standard_cost_components component_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

 

Generated on 09-26-2022 for version 2022.2