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
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 |