Table: udf_entity

Previous: time_period_setup

Unanet Data Model

Next: udf_option

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	entity_type	decimal(15)
2.		entity_name	varchar(25)
3.		udf_count	decimal(15)	((20))
4.		section_header	varchar(128)

Referenced from

Table	Column	Foreign Key Name
udf_setup	entity_type	fk_udf_setup1

Check Constraints

Name	Definition
cc_udf_entity_name	([entity_name]='purchase_order' OR [entity_name]='purchase_requisition' OR [entity_name]='shared_document' OR [entity_name]='org_contact' OR [entity_name]='vendor_org' OR [entity_name]='customer_org' OR [entity_name]='expense_type' OR [entity_name]='project_note' OR [entity_name]='task' OR [entity_name]='project' OR [entity_name]='person' OR [entity_name]='customer')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_udf_entity	true	entity_type	Asc