Previous: customer_payment_included_pmt | Unanet Data Model | Next: customer_type |
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 |
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 |
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 |