Previous: expense_type_account | Unanet Data Model | Next: expense_type_vendor_assignment |
Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
1. | PK | invc_sect_fmt_key | decimal(15) | invc_sect_fmt | fk_expense_type_invc_fltr1 | |
2. | PK | expense_type_key | decimal(15) | expense_type | fk_expense_type_invc_fltr2 |
Column | References | Foreign Key Name | |
Table | Column | ||
expense_type_key | expense_type | expense_type_key | fk_expense_type_invc_fltr2 |
invc_sect_fmt_key | invc_sect_fmt | invc_sect_fmt_key | fk_expense_type_invc_fltr1 |
Index Name | Unique | Column Name | Asc Or Desc |
pk_expense_type_invc_fltr | true | invc_sect_fmt_key | Asc |
expense_type_key | |||
idx_expense_type_invc_fltr1 | false | expense_type_key | Asc |