| Previous: labor_category_rate | Unanet Data Model | Next: leave_request |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | invc_sect_fmt_key | decimal(15) | invc_sect_fmt | fk_labor_invc_sect_fmt1 | |
| 2. | show_comment | char(1) | ('N') | |||
| 3. | show_date | char(1) | ('N') | |||
| 4. | show_hours | char(1) | ('N') | |||
| 5. | show_rate | char(1) | ('N') | |||
| 6. | inception_to_date_hours | char(1) | ('N') | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| invc_sect_fmt_key | invc_sect_fmt | invc_sect_fmt_key | fk_labor_invc_sect_fmt1 |
| Name | Definition |
| cc_l_invc_sect_fmt_incep_hrs | ([inception_to_date_hours]='N' OR [inception_to_date_hours]='Y') |
| cc_l_invc_sect_fmt_show_cmnt | ([show_comment]='N' OR [show_comment]='Y') |
| cc_l_invc_sect_fmt_show_date | ([show_date]='N' OR [show_date]='Y') |
| cc_l_invc_sect_fmt_show_hrs | ([show_hours]='N' OR [show_hours]='Y') |
| cc_l_invc_sect_fmt_show_rate | ([show_rate]='N' OR [show_rate]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_labor_invc_sect_fmt | true | invc_sect_fmt_key | Asc |