Service_items

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

Columns

Name Type Length Precision Scale References In Description
cost_0 NUMBER 30 15 Cost
cost_category VARCHAR2 50 Cost category
create_plan_on_event_type VARCHAR2 128 Whether to create a revenue recognition plan on the event type
created TIMESTAMP Created (GMT)
date_last_modified TIMESTAMP Date last modified
date_of_last_transaction TIMESTAMP Date of last transaction
description VARCHAR2 4000 Description
displayname VARCHAR2 4000 Display name/code
expense_account_id NUMBER 39 0 Expense account ID
featureddescription VARCHAR2 65534 Featured description
full_name VARCHAR2 550 Full name
fx_adjustment_account_id NUMBER 39 0
include_child_subsidiaries VARCHAR2 3 Include child subsidiaries
income_account_id NUMBER 39 0 Income account ID
interco_expense_account_id NUMBER 39 0 Intercompany expense account ID
interco_income_account_id NUMBER 39 0 Intercompany income account ID
is_moss VARCHAR2 3 Is moss
isinactive VARCHAR2 3 Item is inactive
isonline VARCHAR2 3 Is online
istaxable VARCHAR2 3 Taxable
item_extid VARCHAR2 255 Item external ID
item_id NUMBER 39 0 Item ID
item_revenue_category VARCHAR2 250 Item revenue category
manufacturing_charge_item VARCHAR2 3 Manufacturing charge item
matrix_type VARCHAR2 6
modified TIMESTAMP Modified (GMT)
name VARCHAR2 250 Name
offersupport VARCHAR2 3 Offer support
onspecial VARCHAR2 3 On special
parent_id NUMBER 39 0 Subitem of
payment_method_id NUMBER 39 0 Payment method ID
pref_purchase_tax_id NUMBER 39 0 Preferred purchase tax ID
pref_sale_tax_id NUMBER 39 0 Preferred sales tax ID
prices_include_tax VARCHAR2 1 Prices include tax
print_sub_items VARCHAR2 3 Print sub items
purchasedescription VARCHAR2 4000 Purchase description
rate VARCHAR2 42 Rate
rev_rec_forecast_rule_id NUMBER 39 0 Revenue recognition forecast rule
rev_rec_rule_id NUMBER 39 0 Revenue recognition rule ID
revenue_allocation_group VARCHAR2 60 Revenue allocation group
specialsdescription VARCHAR2 65534 Specials description
storedescription VARCHAR2 4000 Store description
storedetaileddescription VARCHAR2 65534 Detailed description
storedisplayname VARCHAR2 4000 Store display name
subtype VARCHAR2 10 Subtype
upc_code VARCHAR2 180 UPC code
vendor_id NUMBER 39 0 Vendor ID
vendorname VARCHAR2 250 Vendor name
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

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
Employee_time_service_items_fk item_id Employee_time item_id 1
Item_billing_rates_service_items_fk item_id Item_billing_rates item_id 1
Project_revenue_rules_service_items_fk item_id Project_revenue_rules service_item_id 1