Table: export_template_data

Previous: export_template

Unanet Data Model

Next: fee_cap_adjustment

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	export_template_data_key	decimal(15)
2.		export_template_key	decimal(15)		export_template	fk_export_template_data1
3.		record_type	decimal(5)
4.		field_number	int
5.		field_name	varchar(60)
6.		value	varchar(4000)
7.		length	int
8.		format	varchar(256)
9.		alignment	varchar(10)	('LEFT')
10.		null_value	varchar(256)
11.		notes	varchar(2000)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
export_template_key	export_template	export_template_key	fk_export_template_data1

Check Constraints

Name	Definition
cc_template_align	([alignment]='CENTER' OR [alignment]='RIGHT' OR [alignment]='LEFT')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_export_template_data	true	export_template_data_key	Asc
idx_export_template_data1	false	export_template_key	Asc