Table Details

Name:
item_option_new
Label:
Variable (en)
Created On:
2022.03.18 03:13:31
Created By:
system
Updated On:
2022.03.18 03:10:41
Updated By:
system
Column Updated On:
2022.03.18 03:32:34
Column Updated By:
system
Scope Name:
Global
Scope:
global
Listing:
open
Dictionary:
open

Columns

+ Status Name Label Datatype Length Scope Reference Included By
  active
Active boolean 40 Global question
  attributes
Variable attributes string 255 Global question
  category
Category reference[choice] 32 Global item_option_category item_option_new
  cat_item
Catalog item reference 32 Global sc_cat_item item_option_new
  choice_direction
Choice direction string[choice] 40 Global question
  choice_field
Choice field field_name 80 Global question
  choice_table
Choice table table_name 80 Global question
  create_roles
Create roles user_roles 255 Global question
  default_html_value
Default HTML html 65536 Global question
  default_value
Default value string 512 Global question
  delete_roles
Delete roles user_roles 255 Global question
  delivery_plan
Delivery plan reference 32 Global sc_cat_item_delivery_plan item_option_new
  description
Description html 8000 Global item_option_new
  display_title
Display title boolean 40 Global question
  do_not_select_first
Do not select the first choice boolean 40 Global question
  dynamic_default_value
Dynamic default value reference 32 Global sys_filter_option_dynamic question
  dynamic_ref_qual
Dynamic reference qualifier reference 32 Global sys_filter_option_dynamic question
  enable_also_request_for
Enable also request for boolean 40 Global item_option_new
  example_text
Example Text translated_field 255 Global question
  field
Field field_name 80 Global question
  global
Global boolean 40 Global item_option_new
  help_tag
Help tag translated_field 100 Global question
  help_text
Help text translated_text 4000 Global question
  hidden
Hidden boolean 40 Global question
  include_none
Include none boolean 40 Global question
  instructions
Instructions translated_html 65536 Global item_option_new
  layout
Layout string[choice] 40 Global question
  list_table
List table table_name 80 Global question
  lookup_label
Lookup label field(s) string 80 Global question
  lookup_price
Lookup price field field_name 80 Global question
  lookup_table
Lookup from table table_name 80 Global question
  lookup_unique
Unique values only boolean 40 Global question
  lookup_value
Lookup value field field_name 80 Global question
  macro
Macro reference 32 Global sys_ui_macro question
  macroponent
Macroponent reference 32 Global sys_ux_macroponent item_option_new
  mandatory
Mandatory boolean 40 Global question
  map_to_field
Map to field boolean 40 Global question
  mask_use_confirmation
Use confirmation boolean 40 Global question
  mask_use_encryption
Use encryption boolean 40 Global question
  name
Name string 100 Global question
  order
Order integer 40 Global question
  price_if_checked
Price if checked price 20 Global question
  pricing_implications
Pricing implications boolean 40 Global question
  published_ref
Published option reference 32 Global item_option_new item_option_new
 
D
question_text
Question translated_field 255 Global question
  read_only
Read only boolean 40 Global question
  read_roles
Read roles user_roles 255 Global question
  read_script
Read Script script_plain 8000 Global item_option_new
  record
Record string 40 Global question
  record_producer_table
Record producer table string 80 Global question
  rec_lookup_price
Lookup recurring price field field_name 80 Global question
  rec_price_if_checked
Recurring price if checked price 20 Global question
  reference
Reference table_name 80 Global question
  reference_qual
Reference qualifier string 4000 Global question
  reference_qual_condition
Reference qualifier condition conditions 4000 Global question
  rich_text
Rich Text translated_html 65536 Global item_option_new
  roles_to_use_also_request_for
Roles to use also request for user_roles 255 Global item_option_new
  save_script
Save Script script_plain 8000 Global item_option_new
  scale_max
Scale max integer 40 Global question
  scale_min
Scale min integer 40 Global question
  show_help
Show help boolean 40 Global question
  show_help_on_load
Always Expanded boolean 40 Global question
  sp_widget
Widget reference 32 Global sp_widget item_option_new
  summary_macro
Summary macro reference 32 Global sys_ui_macro question
  sys_class_name
Class sys_class_name[choice] 80 Global sys_metadata
  sys_created_by
Created by string 40 Global sys_metadata
  sys_created_on
Created glide_date_time 40 Global sys_metadata
 
K
sys_id
Sys ID GUID 32 Global item_option_new
  sys_mod_count
Updates integer 40 Global sys_metadata
  sys_name
Display name string 255 Global sys_metadata
  sys_package
Package reference 32 Global sys_package sys_metadata
  sys_policy
Protection policy string[choice] 40 Global sys_metadata
  sys_scope
Application reference 32 Global sys_scope sys_metadata
  sys_updated_by
Updated by string 40 Global sys_metadata
  sys_updated_on
Updated glide_date_time 40 Global sys_metadata
  sys_update_name
Update name string 250 Global sys_metadata
  table
Table table_name 80 Global question
  tooltip
Tooltip translated_field 40 Global question
  type
Type string[choice] 40 Global question
  ui_page
UI page reference 32 Global sys_ui_page question
  unique
Unique boolean 40 Global item_option_new
  use_dynamic_default
Use dynamic default boolean 40 Global question
  use_reference_qualifier
Use reference qualifier string[choice] 40 Global question
  validate_regex
Validation Regex reference[choice] 32 Global question_regex item_option_new
  variable_name
Variable name string 80 Global question
  variable_set
Variable set reference 32 Global item_option_new_set item_option_new
  variable_width
Variable Width string[choice] 40 Global item_option_new
  visibility
Visibility string[choice] 40 Global item_option_new
  visible_bundle
Visible on Bundles boolean 40 Global item_option_new
  visible_guide
Visible on Guides boolean 40 Global item_option_new
  visible_standalone
Visible Elsewhere boolean 40 Global item_option_new
  visible_summary
Visible on Summaries boolean 40 Global item_option_new
  write_roles
Write roles user_roles 255 Global question
P
Passive
M
Mandatory
D
Display Value
K
Key
U
Unique
X
Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column Current Environment Washington Vancouver Uta Tokyo (Vanilla) Tokyo
dynamic_value_dot_walk_path missing missing missing
dynamic_value_field missing missing missing
post_insert_script missing

Referenced

item_option_new referenced from table:
aisa_rp_config, cxs_rp_config, cxs_rp_fltr_condition, item_option_layout, item_option_new, sc_dp_datum_task, sc_item_option, sc_item_variables_task, sc_item_variable_assignment, sc_multi_row_question_answer, sc_template_detail, sc_wizard_question, sn_apptmnt_booking_service_config
question referenced from table:
question_answer, question_choice
sys_metadata referenced from table:
sys_delete_recovery, sys_metadata_delete, sys_metadata_delete_related

shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out