Table: deposit

Previous: dbversion_patch

Unanet Data Model

Next: deposit_included

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	fin_document_key	decimal(15)		fin_document	fk_deposit1
2.		bank_account_key	decimal(15)		bank_account	fk_deposit2
3.		account_key	decimal(15)		account	fk_deposit3
4.		organization_key	decimal(15)		customer	fk_deposit4
5.		general_ledger_key	decimal(15)		general_ledger	fk_deposit5
6.		deposit_amount	decimal(18,2)	((0))

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
account_key	account	account_key	fk_deposit3
bank_account_key	bank_account	bank_account_key	fk_deposit2
organization_key	customer	customer_key	fk_deposit4
fin_document_key	fin_document	fin_document_key	fk_deposit1
general_ledger_key	general_ledger	general_ledger_key	fk_deposit5

Referenced from

Table	Column	Foreign Key Name
deposit_included	fin_document_key	fk_deposit_included1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_deposit	true	fin_document_key	Asc
idx_deposit1	false	bank_account_key	Asc
idx_deposit2	false	account_key	Asc
idx_deposit3	false	organization_key	Asc
idx_deposit4	false	general_ledger_key	Asc