Table: fin_document_recurring

Previous: fin_document_detail_project

Unanet Data Model

Next: fiscal_month

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	fin_document_key	decimal(15)		fin_document	fk_fin_document_recurring1
2.		orig_fin_document_key	decimal(15)
3.		created_by_fin_document_key	decimal(15)		fin_document	fk_fin_document_recurring2
4.		max_occurrences	int
5.		sequence	int

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
fin_document_key	fin_document	fin_document_key	fk_fin_document_recurring1
created_by_fin_document_key	fin_document	fin_document_key	fk_fin_document_recurring2

Check Constraints

Name	Definition
cc_fdr_max_occurrences	([max_occurrences] IS NULL OR [max_occurrences]>(0))
cc_fdr_sequence	([sequence]>(0) AND ([max_occurrences] IS NULL OR [sequence]<=[max_occurrences]))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_fin_document_recurring	true	fin_document_key	Asc
idx_fin_document_recurring1	false	created_by_fin_document_key	Asc