| Previous: expense_history | Unanet Data Model | Next: expense_plan |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | invc_sect_fmt_key | decimal(15) | invc_sect_fmt | fk_exp_invc_sect_fmt1 | |
| 2. | show_comment | char(1) | ('N') | |||
| 3. | show_cost | char(1) | ('N') | |||
| 4. | show_date | char(1) | ('N') | |||
| 5. | show_markup_percent | char(1) | ('N') | |||
| 6. | show_markup_multiplier | char(1) | ('N') | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| invc_sect_fmt_key | invc_sect_fmt | invc_sect_fmt_key | fk_exp_invc_sect_fmt1 |
| Name | Definition |
| cc_e_invc_sect_fmt_markup | (NOT ([show_markup_multiplier]='Y' AND [show_markup_percent]='Y')) |
| cc_e_invc_sect_fmt_markup_mlt | ([show_markup_multiplier]='N' OR [show_markup_multiplier]='Y') |
| cc_e_invc_sect_fmt_markup_pct | ([show_markup_percent]='N' OR [show_markup_percent]='Y') |
| cc_e_invc_sect_fmt_show_cmnt | ([show_comment]='N' OR [show_comment]='Y') |
| cc_e_invc_sect_fmt_show_cost | ([show_cost]='N' OR [show_cost]='Y') |
| cc_e_invc_sect_fmt_show_date | ([show_date]='N' OR [show_date]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_exp_invc_sect_fmt | true | invc_sect_fmt_key | Asc |