Table: bank_reconciliation_detail

Previous: bank_reconciliation

Unanet Data Model

Next: batch

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	general_ledger_key	decimal(15)		general_ledger	fk_bank_rec_dtl2
2.	PK	bank_reconciliation_key	decimal(15)		bank_reconciliation	fk_bank_rec_dtl1

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
bank_reconciliation_key	bank_reconciliation	bank_reconciliation_key	fk_bank_rec_dtl1
general_ledger_key	general_ledger	general_ledger_key	fk_bank_rec_dtl2

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_bank_reconciliation_detail	true	bank_reconciliation_key	Asc
		general_ledger_key