Table: customer_payment_unapplied

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