table - sc_cat_item_producer_service «Service»

Derivation Hierarchy

sys_metadata «Application File» Global
\| +—	sc_cat_item «Catalog Item» Global
	\| +—	sc_cat_item_producer «Record Producer» Global
		\| +—	sc_cat_item_producer_service «Service» Global

Subclasses:: No Subclasses
Siblings:: sc_cat_item_composite_producer, std_change_record_producer

Table Details

Name:: sc_cat_item_producer_service
Label:: Service (en)

Created On:: 2022.09.17 02:07:36
Created By:: system

Updated On:: 2022.09.17 02:07:36
Updated By:: system

Column Updated On:: 2022.09.17 03:00:42
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	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	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

Passive

Mandatory

Display Value

Key

Unique

Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column	Current Environment	Washington	Vancouver	Uta	Tokyo (Vanilla)	Sandiego
additional_review	missing	missing			missing	missing
create_universal_request	missing	missing			missing	missing
delivery_plan_script	missing	missing		missing	missing	missing
make_item_non_conversational	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_item_analytics, 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
sc_cat_item_producer_service referenced from table:: service_task, sys_service_app_log
sys_metadata referenced from table:: one_api_feature_provider, sys_delete_recovery, sys_metadata_delete, sys_metadata_delete_related

Diagram sc_cat_item_producer_service «Service» / Global (global)

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