| 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) | ||||
| 15. | po_key | decimal(15) | purchase_order | fk_vendor_invoice7 | ||
| 16. | controller_key | decimal(15) | person | fk_vendor_invoice8 | ||
| 17. | receiver_key | decimal(15) | person | fk_vendor_invoice9 | ||
| 18. | chain_key | decimal(15) | chain | fk_vendor_invoice10 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| account_key | account | account_key | fk_vendor_invoice4 |
| chain_key | chain | chain_key | fk_vendor_invoice10 |
| 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 |
| controller_key | person | person_key | fk_vendor_invoice8 |
| receiver_key | person | person_key | fk_vendor_invoice9 |
| po_key | purchase_order | po_key | fk_vendor_invoice7 |
| Table | Column | Foreign Key Name |
| expense_data_allocation | vendor_invoice_key | fk_expense_data_allocation11 |
| person_time_data | vendor_invoice_key | fk_person_time_data14 |
| vi_cust_approval_status | fin_document_key | fk_vi_cust_approval_status1 |
| vi_funding_cap_adjustment | fin_document_key | fk_vi_funding_cap_adjustment1 |
| vi_included_expense | vendor_invoice_key | fk_vi_included_expense1 |
| vi_included_time | vendor_invoice_key | fk_vi_included_time1 |
| vi_pm_approval_status | fin_document_key | fk_vi_pm_approval_status1 |
| 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 |
| idx_vendor_invoice6 | false | po_key | Asc |
| idx_vendor_invoice7 | false | controller_key | Asc |
| idx_vendor_invoice8 | false | receiver_key | Asc |
| idx_vendor_invoice9 | false | chain_key | Asc |
| View Name |
| vendor_invoice_activity |
| vendor_payment_1099_view |