Table: customer_payment_unapplied

Previous: customer_payment_included_pmt

Unanet Data Model

Next: customer_type

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	fin_document_key	decimal(15)		customer_payment	fk_customer_payment_unapplied1
2.		organization_key	decimal(15)		customer	fk_customer_payment_unapplied2
3.		account_key	decimal(15)		account	fk_customer_payment_unapplied3
4.		general_ledger_key	decimal(15)		general_ledger	fk_customer_payment_unapplied4

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
account_key	account	account_key	fk_customer_payment_unapplied3
organization_key	customer	customer_key	fk_customer_payment_unapplied2
fin_document_key	customer_payment	fin_document_key	fk_customer_payment_unapplied1
general_ledger_key	general_ledger	general_ledger_key	fk_customer_payment_unapplied4

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_customer_payment_unapplied	true	fin_document_key	Asc
idx_cust_payment_unapplied1	false	organization_key	Asc
idx_cust_payment_unapplied2	false	account_key	Asc
idx_cust_payment_unapplied3	false	general_ledger_key	Asc