| Previous: vendor_payment_unapplied | Unanet Data Model | Next: vi_funding_cap_adjustment |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | fin_document_key | decimal(15) | vendor_invoice | fk_vi_cust_approval_status1 | |
| 2. | PK | project_key | decimal(15) | project | fk_vi_cust_approval_status2 | |
| 3. | customer_approves_first | char(1) | ||||
| 4. | approved | char(1) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| project_key | project | project_key | fk_vi_cust_approval_status2 |
| fin_document_key | vendor_invoice | fin_document_key | fk_vi_cust_approval_status1 |
| Name | Definition |
| cc_vcas_approved | ([approved]='N' OR [approved]='Y') |
| cc_vcas_cust_appr_first | ([customer_approves_first]='N' OR [customer_approves_first]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_vi_cust_approval_status | true | fin_document_key | Asc |
| project_key | |||
| idx_vi_cust_approval_status1 | false | project_key | Asc |