Table: journal_entry

Previous: journal_document_expense

Unanet Data Model

Next: journal_expense

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	fin_document_key	decimal(15)		fin_document	fk_journal_entry1
2.		reversing	char(1)	('N')
3.		reversing_date	datetime
4.		reversing_fin_document_key	decimal(15)		journal_entry	fk_journal_entry2

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
fin_document_key	fin_document	fin_document_key	fk_journal_entry1
reversing_fin_document_key	journal_entry	fin_document_key	fk_journal_entry2

Referenced from

Table	Column	Foreign Key Name
journal_entry	reversing_fin_document_key	fk_journal_entry2

Check Constraints

Name	Definition
cc_je_reversing	([reversing]='N' OR [reversing]='Y')
cc_je_reversing_date	([reversing_date]>='1900-01-01' AND [reversing_date]<='2099-12-31')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_journal_entry	true	fin_document_key	Asc