Table: bank_reconciliation

Previous: bank_account

Unanet Data Model

Next: bank_reconciliation_detail

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	bank_reconciliation_key	decimal(15)
2.		legal_entity_key	decimal(15)		customer	fk_bank_rec1
3.		bank_account_key	decimal(15)		bank_account	fk_bank_rec2
4.		statement_date	datetime
5.		beginning_balance	decimal(18,3)
6.		ending_balance	decimal(18,3)
7.		created_by	decimal(15)		person	fk_bank_rec3
8.		created_timestamp	datetime
9.		reconciled_by	decimal(15)		person	fk_bank_rec4
10.		reconciled_timestamp	datetime

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
bank_account_key	bank_account	bank_account_key	fk_bank_rec2
legal_entity_key	customer	customer_key	fk_bank_rec1
created_by	person	person_key	fk_bank_rec3
reconciled_by	person	person_key	fk_bank_rec4

Referenced from

Table	Column	Foreign Key Name
bank_reconciliation_detail	bank_reconciliation_key	fk_bank_rec_dtl1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_bank_reconciliation	true	bank_reconciliation_key	Asc
idx_bank_reconciliation1	false	legal_entity_key	Asc
idx_bank_reconciliation2	false	bank_account_key	Asc
idx_bank_reconciliation3	false	created_by	Asc
idx_bank_reconciliation4	false	reconciled_by	Asc