Table: document_type_invc_fltr

Previous: deposit_included

Unanet Data Model

Next: email_template

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	invc_sect_fmt_key	decimal(15)		invc_sect_fmt	fk_document_type_invc_fltr1
2.	PK	document_type	varchar(2)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
invc_sect_fmt_key	invc_sect_fmt	invc_sect_fmt_key	fk_document_type_invc_fltr1

Check Constraints

Name	Definition
cc_doc_type_invc_fltr1	([document_type]='TS' OR [document_type]='VP' OR [document_type]='VI' OR [document_type]='JE' OR [document_type]='ER' OR [document_type]='D' OR [document_type]='CP')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_document_type_invc_fltr	true	invc_sect_fmt_key	Asc
		document_type