| Previous: vat_location | Unanet Data Model | Next: vendor_invoice |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | vendor_key | decimal(15) | |||
| 2. | name | varchar(255) | ||||
| 3. | prefered | char(1) | ||||
| Table | Column | Foreign Key Name |
| billing_info | vendor_key | fk_billing_info1 |
| expense_data | vendor_key | fk_expense_data3 |
| expense_type_vendor_assignment | vendor_key | fk_etype_vendor_assignment1 |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_vendor | true | vendor_key | Asc |
| idx_vendor1 | true | name | Asc |