Table: vendor_payment_unapplied

Previous: vendor_payment_included

Unanet Data Model

Next: vi_cust_approval_status

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	fin_document_key	decimal(15)		vendor_payment	fk_vendor_payment_unapplied1
2.		organization_key	decimal(15)		customer	fk_vendor_payment_unapplied2
3.		account_key	decimal(15)		account	fk_vendor_payment_unapplied3
4.		general_ledger_key	decimal(15)		general_ledger	fk_vendor_payment_unapplied4

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
account_key	account	account_key	fk_vendor_payment_unapplied3
organization_key	customer	customer_key	fk_vendor_payment_unapplied2
general_ledger_key	general_ledger	general_ledger_key	fk_vendor_payment_unapplied4
fin_document_key	vendor_payment	fin_document_key	fk_vendor_payment_unapplied1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_vendor_payment_unapplied	true	fin_document_key	Asc
idx_vendor_payment_unapplied1	false	organization_key	Asc
idx_vendor_payment_unapplied2	false	account_key	Asc
idx_vendor_payment_unapplied3	false	general_ledger_key	Asc