| Previous: customer_org | Unanet Data Model | Next: customer_payment_included_inv |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | fin_document_key | decimal(15) | fin_document | fk_customer_payment1 | |
| 2. | customer_org_key | decimal(15) | customer | fk_customer_payment2 | ||
| 3. | payment_amount | decimal(18,2) | ||||
| 4. | payment_method_key | decimal(15) | payment_method | fk_customer_payment3 | ||
| 5. | bank_account_key | decimal(15) | bank_account | fk_customer_payment4 | ||
| 6. | account_key | decimal(15) | account | fk_customer_payment8 | ||
| 7. | organization_key | decimal(15) | customer | fk_customer_payment9 | ||
| 8. | general_ledger_key | decimal(15) | general_ledger | fk_customer_payment5 | ||
| 9. | applied_fin_document_key | decimal(15) | customer_payment | fk_customer_payment6 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| account_key | account | account_key | fk_customer_payment8 |
| bank_account_key | bank_account | bank_account_key | fk_customer_payment4 |
| customer_org_key | customer | customer_key | fk_customer_payment2 |
| organization_key | customer | customer_key | fk_customer_payment9 |
| applied_fin_document_key | customer_payment | fin_document_key | fk_customer_payment6 |
| fin_document_key | fin_document | fin_document_key | fk_customer_payment1 |
| general_ledger_key | general_ledger | general_ledger_key | fk_customer_payment5 |
| payment_method_key | payment_method | payment_method_key | fk_customer_payment3 |
| Table | Column | Foreign Key Name |
| customer_payment | applied_fin_document_key | fk_customer_payment6 |
| customer_payment_included_inv | fin_document_key | fk_cust_payment_included_inv1 |
| customer_payment_included_pmt | fin_document_key | fk_cust_payment_included_pmt1 |
| customer_payment_included_pmt | included_fin_document_key | fk_cust_payment_included_pmt2 |
| customer_payment_unapplied | fin_document_key | fk_customer_payment_unapplied1 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_customer_payment | true | fin_document_key | Asc |
| idx_customer_payment1 | false | customer_org_key | Asc |
| idx_customer_payment2 | false | bank_account_key | Asc |
| idx_customer_payment3 | false | applied_fin_document_key | Asc |
| idx_customer_payment4 | false | payment_method_key | Asc |
| idx_customer_payment5 | false | general_ledger_key | Asc |
| idx_customer_payment6 | false | account_key | Asc |
| idx_customer_payment7 | false | organization_key | Asc |
| View Name |
| customer_payment_activity |
| customer_payment_export_view |