table - ast_contract «Contract»

Derivation Hierarchy

ast_contract
«Contract»

Global

Subclasses:: ast_service, ast_warranty, ast_lease
Siblings:: No Siblings

Table Details

Name:: ast_contract
Label:: Contract (en)

Created On:: 2022.09.17 02:10:49
Created By:: system

Updated On:: 2022.09.17 02:54:45
Updated By:: system

Column Updated On:: 2022.09.17 02:31:44
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		ast_contract
	applicable_taxes	Applicable taxes	string[choice]	40	Global		ast_contract
	application_model	Application model	reference	32	Global	cmdb_application_product_model	ast_contract
	approval_history	Approval History	journal	4000	Global		ast_contract
	approver	Approver	reference	32	Global	sys_user	ast_contract
	business_owner	Business owner	reference	32	Global	sys_user	ast_contract
	commitment	Commitment	currency	20	Global		ast_contract
	contract_administrator	Contract administrator	reference	32	Global	sys_user	ast_contract
M	contract_model	Contract model	reference	32	Global	cmdb_model	ast_contract
	cost_adjustment	Cost adjustment amount	decimal	15	Global		ast_contract
	cost_adjustment_percentage	Cost adjustment percentage	decimal	15	Global		ast_contract
	cost_adjustment_reason	Cost adjustment reason	string	40	Global		ast_contract
	cost_adjustment_type	Cost adjustment type	string[choice]	40	Global		ast_contract
	cost_center	Cost center	reference	32	Global	cmn_cost_center	ast_contract
	cost_per_unit	Cost per unit	currency	20	Global		ast_contract
	covers	Covers	string	4000	Global		ast_contract
	customer	Customer	reference	32	Global	core_company	ast_contract
	description	Description	string	4000	Global		ast_contract
	discount	Discount	decimal	15	Global		ast_contract
	ends	End date	glide_date	40	Global		ast_contract
	expiration	Expiration	reference	32	Global	clm_condition_checker	ast_contract
	invoice_payment_terms	Invoice payment terms	string[choice]	40	Global		ast_contract
	license_quantity_entitled	License quantity entitled	integer	40	Global		ast_contract
	license_type	Agreement type	string[choice]	40	Global		ast_contract
	lifetime_cost	Lifetime cost	currency	20	Global		ast_contract
	life_cycle_stage	Life Cycle Stage	reference	40	Global	life_cycle_stage	ast_contract
	life_cycle_stage_status	Life Cycle Stage Status	reference	40	Global	life_cycle_stage_status	ast_contract
	location	Location	reference	32	Global	cmn_location	ast_contract
	monthly_cost	Monthly cost	currency	20	Global		ast_contract
	number	Number	string	40	Global		ast_contract
	parent_contract	Parent contract	reference	32	Global	ast_contract	ast_contract
	payment_amount	Payment amount	currency	20	Global		ast_contract
	payment_schedule	Payment schedule	string[choice]	40	Global		ast_contract
	po_number	PO Number	string	40	Global		ast_contract
	process	Process	string[choice]	40	Global		ast_contract
	process_non_contractual_slas	Process non-contractual SLAs	boolean	40	Global		ast_contract
	ratecard	Has rate card	boolean	40	Global		ast_contract
	renewable	Automatically renew	boolean	40	Global		ast_contract
	renewal_contact	Renewal/Extension contact	reference	32	Global	sys_user	ast_contract
	renewal_date	Renewal start date	glide_date	40	Global		ast_contract
	renewal_end_date	Renewal end date	glide_date	40	Global		ast_contract
	renewal_options	Options	string[choice]	40	Global		ast_contract
	sales_tax	Sales tax	boolean	40	Global		ast_contract
	short_description	Name	string	100	Global		ast_contract
	starts	Start date	glide_date	40	Global		ast_contract
	state	State	string[choice]	40	Global		ast_contract
	substate	Substate	string[choice]	40	Global		ast_contract
	sub_total_cost	Sub total cost	currency	20	Global		ast_contract
	sys_class_name	Contract type	sys_class_name[choice]	80	Global		ast_contract
	sys_created_by	Created by	string	40	Global		ast_contract
	sys_created_on	Created	glide_date_time	40	Global		ast_contract
	sys_domain	Domain	domain_id	32	Global		ast_contract
	sys_domain_path	Domain Path	domain_path	255	Global		ast_contract
K	sys_id	Sys ID	GUID	32	Global		ast_contract
	sys_mod_count	Updates	integer	40	Global		ast_contract
	sys_updated_by	Updated by	string	40	Global		ast_contract
	sys_updated_on	Updated	glide_date_time	40	Global		ast_contract
	tax_cost	Tax cost	currency	20	Global		ast_contract
	tax_exempt	Tax exempt	boolean	40	Global		ast_contract
	tax_rate	Effective tax rate	decimal	15	Global		ast_contract
	terms_and_conditions	Terms and conditions	translated_html	10000	Global		ast_contract
	total_cost	Total cost	currency	20	Global		ast_contract
	vendor	Vendor	reference	32	Global	core_company	ast_contract
	vendor_account	Vendor account	string	40	Global		ast_contract
M D	vendor_contract	Contract number	string	40	Global		ast_contract
	yearly_cost	Yearly cost	currency	20	Global		ast_contract

Passive

Mandatory

Display Value

Key

Unique

Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column	Current Environment	Washington	Tokyo (Vanilla)	Sandiego
account	missing	missing	missing	missing
consumer	missing	missing	missing	missing
contract_composite	missing	missing	missing	missing

Referenced

ast_contract referenced from table:: ast_contract, ast_contract_instance, clm_contract_history, clm_m2m_contract_and_terms, clm_m2m_contract_asset, clm_m2m_contract_user, clm_terms_and_conditions, contract_rel_ci, contract_rel_contract_sla, contract_rel_group, contract_rel_location, contract_rel_user, fm_expense_line, service_commitment, service_offering, sla, task

Diagram ast_contract «Contract» / Global (global)

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