Table Details

Name:
sc_cat_item_producer_service
Label:
Service (en)
Created On:
2022.03.18 03:14:30
Created By:
system
Updated On:
2022.03.18 03:14:30
Updated By:
system
Column Updated On:
2022.03.18 03:32:36
Column Updated By:
system
Scope Name:
Global
Scope:
global
Listing:
open
Dictionary:
open

Columns

+ Status Name Label Datatype Length Scope Reference Included By
  access_type
Access Type string[choice] 40 Global sc_cat_item
  active
Active boolean 40 Global sc_cat_item
  allow_edit
Allow edit boolean 40 Global sc_cat_item_producer
  availability
Availability string[choice] 40 Global sc_cat_item
  billable
Billable boolean 40 Global sc_cat_item
  can_cancel
Can cancel boolean 40 Global sc_cat_item_producer
  category
Category reference 32 Global sc_category sc_cat_item
  checked_out
Checked out string[choice] 40 Global sc_cat_item
  cost
Cost decimal 15 Global sc_cat_item
  custom_cart
Cart reference 32 Global sys_ui_macro sc_cat_item
  delivery_plan
Execution Plan reference 32 Global sc_cat_item_delivery_plan sc_cat_item
 
X
delivery_plan_script
Delivery plan script script_plain 4000 Global sc_cat_item
  delivery_time
Delivery time glide_duration 40 Global sc_cat_item
  description
Description translated_html 8000 Global sc_cat_item
  display_price_property
Display price property string 40 Global sc_cat_item
  entitlement_script
Entitlement script script_plain 4000 Global sc_cat_item
  flow_designer_flow
Flow reference 32 Global sys_hub_flow sc_cat_item
  fulfillment_automation_level
Fulfillment automation level string[choice] 40 Global sc_cat_item
  fulfillment_user
Fulfillment user reference 32 Global sys_user sc_cat_item_producer_service
  group
Fulfillment group reference 32 Global sys_user_group sc_cat_item
  hide_sp
Hide on Service Portal boolean 40 Global sc_cat_item
  icon
Icon user_image 40 Global sc_cat_item
  ignore_price
Ignore price boolean 40 Global sc_cat_item
  image
Image image 40 Global sc_cat_item
  list_price
List Price currency 20 Global sc_cat_item
  location
Location reference 32 Global cmn_location sc_cat_item
  mandatory_attachment
Mandatory Attachment boolean 40 Global sc_cat_item
  meta
Meta string 4000 Global sc_cat_item
  mobile_hide_price
Hide price (classic mobile listings) boolean 40 Global sc_cat_item
  mobile_picture
Classic Mobile Picture user_image 40 Global sc_cat_item
  mobile_picture_type
Classic Mobile Picture Type string[choice] 40 Global sc_cat_item
  model
Model reference 32 Global cmdb_model sc_cat_item
 
D
name
Name translated_text 100 Global sc_cat_item
  no_attachment_v2
Hide Attachment boolean 40 Global sc_cat_item
  no_cart
No cart boolean 40 Global sc_cat_item
  no_cart_v2
Hide 'Add to Cart' boolean 40 Global sc_cat_item
  no_delivery_time_v2
Hide Delivery time boolean 40 Global sc_cat_item
  no_order
No order boolean 40 Global sc_cat_item
  no_order_now
No order now boolean 40 Global sc_cat_item
  no_proceed_checkout
No proceed checkout boolean 40 Global sc_cat_item
  no_quantity
No quantity boolean 40 Global sc_cat_item
  no_quantity_v2
Hide Quantity boolean 40 Global sc_cat_item
  No search boolean 40 Global sc_cat_item
  no_wishlist_v2
Hide 'Add to Wish List' boolean 40 Global sc_cat_item
  omit_price
Omit price in cart boolean 40 Global sc_cat_item
  order
Order integer 40 Global sc_cat_item
  Ordered item link reference 32 Global sc_ordered_item_link sc_cat_item
  owner
Owner reference 32 Global sys_user sc_cat_item
  picture
Picture user_image 40 Global sc_cat_item
  post_insert_script
Post insert script script_plain 8000 Global sc_cat_item_producer
  preview
Preview link catalog_preview 255 Global sc_cat_item
  price
Price price 20 Global sc_cat_item
  processing_workflow
Processing workflow string 4000 Global sc_cat_item_producer_service
  published_ref
Published item reference 32 Global sc_cat_item sc_cat_item
  recurring_frequency
Recurring price frequency choice[choice] 40 Global sc_cat_item
  recurring_price
Recurring price price 20 Global sc_cat_item
  redirect_url
Redirect To string[choice] 40 Global sc_cat_item_producer
  request_method
Request method string[choice] 40 Global sc_cat_item
  roles
Roles user_roles 255 Global sc_cat_item
  save_options
Save Options string[choice] 40 Global sc_cat_item_producer
  save_script
Save Script script_plain 8000 Global sc_cat_item_producer
  script
Script script_plain 8000 Global sc_cat_item_producer
  sc_catalogs
Catalogs glide_list 4000 Global sc_catalog sc_cat_item
  sc_ic_item_staging
Created from item design reference 32 Global sc_ic_item_staging sc_cat_item
  sc_ic_version
Published version integer 40 Global sc_cat_item
  sc_template
Associated template reference 32 Global sc_template sc_cat_item
  short_description
Short description translated_text 200 Global sc_cat_item
  show_variable_help_on_load
Expand help for all questions boolean 40 Global sc_cat_item
  start_closed
Start closed boolean 40 Global sc_cat_item
  state
State string[choice] 40 Global sc_cat_item
  submission_message
Submission message translated_text 1000 Global sc_cat_item_producer_service
  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 sc_cat_item_producer_service
  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
 
M
table_name
Table name table_name 80 Global sc_cat_item_producer
  taxonomy_topic
Taxonomy topic reference 32 Global topic sc_cat_item
  template
Template reference 32 Global sys_template sc_cat_item
  template_manager_roles
Template Manager roles user_roles 255 Global sc_cat_item
  type
Type string[choice] 40 Global sc_cat_item
  use_sc_layout
Use cart layout boolean 40 Global sc_cat_item
  vendor
Vendor reference 32 Global core_company sc_cat_item
  view
View string 40 Global sc_cat_item_producer
  visible_bundle
Visible on Bundles boolean 40 Global sc_cat_item
  visible_guide
Visible on Guides boolean 40 Global sc_cat_item
  visible_standalone
Visible elsewhere boolean 40 Global sc_cat_item
  workflow
Workflow reference 32 Global wf_workflow sc_cat_item
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
additional_review missing missing missing missing
create_universal_request missing missing missing missing
delivery_plan_script missing missing missing missing missing
no_save_as_draft missing missing missing missing missing
version missing missing missing missing

Referenced

sc_cat_item referenced from table:
catalog_channel_analytics, catalog_dl_definition, catalog_dl_definition_rel_mat, catalog_dl_definition_rel_set, catalog_script_client, catalog_ui_policy, catalog_ui_policy_action, cmdb_model, expert_panel_c_item, io_set_item, item_option_new, kb_2_sc, m2m_connected_content, pc_vendor_cat_item, sc_2_kb, sc_2_sc, sc_cart, sc_cart_item, sc_cat_item, sc_cat_item_app_group, sc_cat_item_app_user, sc_cat_item_catalog, sc_cat_item_category, sc_cat_item_children, sc_cat_item_company_mtom, sc_cat_item_company_no_mtom, sc_cat_item_dept_mtom, sc_cat_item_dept_no_mtom, sc_cat_item_group_mtom, sc_cat_item_group_no_mtom, sc_cat_item_guide_items, sc_cat_item_location_mtom, sc_cat_item_location_no_mtom, sc_cat_item_option, sc_cat_item_review_flow_context_mtom, sc_cat_item_subscribe_mtom, sc_cat_item_subscribe_no_mtom, sc_cat_item_user_criteria_mtom, sc_cat_item_user_criteria_no_mtom, sc_cat_item_user_mtom, sc_cat_item_user_no_mtom, sc_ic_aprvl_defn, sc_ic_item_staging, sc_ic_task_defn, sc_req_item, sc_service_fulfillment_stage, sc_service_fulfillment_stage_data, sc_template, sn_ex_sp_quick_link, sn_prod_cat_rel_m2m_product_catalog_item, sp_instance_link, sp_rectangle_menu_item
sc_cat_item_producer referenced from table:
aisa_rp_config, cxs_rp_config, sc_item_produced_record, sc_service_fulfillment_step_configuration, sc_wizard, sn_apptmnt_booking_appointment_booking, sn_apptmnt_booking_service_config
sc_cat_item_producer_service referenced from table:
service_task, sys_service_app_log
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