| Previous: vendor | Unanet Data Model | Next: vendor_org |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | fin_document_key | decimal(15) | fin_document | fk_vendor_invoice1 | |
| 2. | vendor_org_key | decimal(15) | customer | fk_vendor_invoice2 | ||
| 3. | invoice_amount | decimal(18,2) | ||||
| 4. | invoice_date | datetime | ||||
| 5. | payment_term_key | decimal(15) | payment_term | fk_vendor_invoice3 | ||
| 6. | due_date | datetime | ||||
| 7. | discount_amount | decimal(18,2) | ||||
| 8. | discount_date | datetime | ||||
| 9. | separate_payment | char(1) | ('N') | |||
| 10. | account_key | decimal(15) | account | fk_vendor_invoice4 | ||
| 11. | organization_key | decimal(15) | customer | fk_vendor_invoice5 | ||
| 12. | payment_on_hold | char(1) | ('N') | |||
| 13. | general_ledger_key | decimal(15) | general_ledger | fk_vendor_invoice6 | ||
| 14. | hold_reason | varchar(255) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| account_key | account | account_key | fk_vendor_invoice4 |
| organization_key | customer | customer_key | fk_vendor_invoice5 |
| vendor_org_key | customer | customer_key | fk_vendor_invoice2 |
| fin_document_key | fin_document | fin_document_key | fk_vendor_invoice1 |
| general_ledger_key | general_ledger | general_ledger_key | fk_vendor_invoice6 |
| payment_term_key | payment_term | payment_term_key | fk_vendor_invoice3 |
| Table | Column | Foreign Key Name |
| expense_data_allocation | vendor_invoice_key | fk_expense_data_allocation11 |
| Name | Definition |
| cc_vi_discount_date | ([discount_date]>='1900-01-01' AND [discount_date]<='2099-12-31') |
| cc_vi_due_date | ([due_date]>='1900-01-01' AND [due_date]<='2099-12-31') |
| cc_vi_invoice_date | ([invoice_date]>='1900-01-01' AND [invoice_date]<='2099-12-31') |
| cc_vi_payment_on_hold | ([payment_on_hold]='N' OR [payment_on_hold]='Y') |
| cc_vi_separate_payment | ([separate_payment]='N' OR [separate_payment]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_vendor_invoice | true | fin_document_key | Asc |
| idx_vendor_invoice1 | false | vendor_org_key | Asc |
| idx_vendor_invoice2 | false | payment_term_key | Asc |
| idx_vendor_invoice3 | false | account_key | Asc |
| idx_vendor_invoice4 | false | organization_key | Asc |
| idx_vendor_invoice5 | false | general_ledger_key | Asc |
| View Name |
| vendor_invoice_activity |
| vendor_payment_1099_view |