| Previous: customer_payment | Unanet Data Model | Next: customer_payment_included_pmt |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | fin_document_key | decimal(15) | customer_payment | fk_cust_payment_included_inv1 | |
| 2. | PK | invoice_key | decimal(15) | invoice | fk_cust_payment_included_inv2 | |
| 3. | applied_general_ledger_key | decimal(15) | general_ledger | fk_cust_payment_included_inv3 | ||
| 4. | discount_general_ledger_key | decimal(15) | general_ledger | fk_cust_payment_included_inv4 | ||
| 5. | writeoff_general_ledger_key | decimal(15) | general_ledger | fk_cust_payment_included_inv5 | ||
| 6. | applied_amount | decimal(18,2) | ((0)) | |||
| 7. | discount_amount | decimal(18,2) | ((0)) | |||
| 8. | writeoff_amount | decimal(18,2) | ((0)) | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| fin_document_key | customer_payment | fin_document_key | fk_cust_payment_included_inv1 |
| applied_general_ledger_key | general_ledger | general_ledger_key | fk_cust_payment_included_inv3 |
| discount_general_ledger_key | general_ledger | general_ledger_key | fk_cust_payment_included_inv4 |
| writeoff_general_ledger_key | general_ledger | general_ledger_key | fk_cust_payment_included_inv5 |
| invoice_key | invoice | invoice_key | fk_cust_payment_included_inv2 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_cust_payment_included_inv | true | fin_document_key | Asc |
| invoice_key | |||
| idx_cust_pmt_included_inv1 | false | invoice_key | Asc |
| idx_cust_pmt_included_inv2 | false | applied_general_ledger_key | Asc |
| idx_cust_pmt_included_inv3 | false | discount_general_ledger_key | Asc |
| idx_cust_pmt_included_inv4 | false | writeoff_general_ledger_key | Asc |
| View Name |
| customer_invoice_activity |
| customer_payment_activity |
| customer_payment_export_view |