| Previous: vendor_org | Unanet Data Model | Next: vendor_payment_included |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | fin_document_key | decimal(15) | fin_document | fk_vendor_payment9 | |
| 2. | vendor_org_key | decimal(15) | customer | fk_vendor_payment1 | ||
| 3. | payment_amount | decimal(18,2) | ||||
| 4. | payment_method_key | decimal(15) | payment_method | fk_vendor_payment2 | ||
| 5. | bank_account_key | decimal(15) | bank_account | fk_vendor_payment3 | ||
| 6. | account_key | decimal(15) | account | fk_vendor_payment7 | ||
| 7. | organization_key | decimal(15) | customer | fk_vendor_payment8 | ||
| 8. | general_ledger_key | decimal(15) | general_ledger | fk_vendor_payment4 | ||
| 9. | applied_fin_document_key | decimal(15) | vendor_payment | fk_vendor_payment5 | ||
| 10. | payee | varchar(128) | ||||
| 11. | check_print_history_key | decimal(15) | check_print_history | fk_vendor_payment6 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| account_key | account | account_key | fk_vendor_payment7 |
| bank_account_key | bank_account | bank_account_key | fk_vendor_payment3 |
| check_print_history_key | check_print_history | check_print_history_key | fk_vendor_payment6 |
| organization_key | customer | customer_key | fk_vendor_payment8 |
| vendor_org_key | customer | customer_key | fk_vendor_payment1 |
| fin_document_key | fin_document | fin_document_key | fk_vendor_payment9 |
| general_ledger_key | general_ledger | general_ledger_key | fk_vendor_payment4 |
| payment_method_key | payment_method | payment_method_key | fk_vendor_payment2 |
| applied_fin_document_key | vendor_payment | fin_document_key | fk_vendor_payment5 |
| Table | Column | Foreign Key Name |
| vendor_payment | applied_fin_document_key | fk_vendor_payment5 |
| vendor_payment_included | fin_document_key | fk_vendor_payment_included1 |
| vendor_payment_unapplied | fin_document_key | fk_vendor_payment_unapplied1 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_vendor_payment | true | fin_document_key | Asc |
| idx_vendor_payment1 | false | vendor_org_key | Asc |
| idx_vendor_payment2 | false | bank_account_key | Asc |
| idx_vendor_payment3 | false | applied_fin_document_key | Asc |
| idx_vendor_payment4 | false | payment_method_key | Asc |
| idx_vendor_payment5 | false | general_ledger_key | Asc |
| idx_vendor_payment6 | false | check_print_history_key | Asc |
| idx_vendor_payment7 | false | account_key | Asc |
| idx_vendor_payment8 | false | organization_key | Asc |
| View Name |
| vendor_payment_1099_view |
| vendor_payment_activity |
| vendor_payment_export_view |