| Previous: cost_element_type_invc_fltr | Unanet Data Model | Next: cost_plus_post_detail |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | invc_sect_fmt_key | decimal(15) | invc_sect_fmt | fk_cost_plus_invc_sect_fmt1 | |
| 2. | show_comment | char(1) | ('N') | |||
| 3. | show_date | char(1) | ('N') | |||
| 4. | show_qty | char(1) | ('N') | |||
| 5. | show_rate | char(1) | ('N') | |||
| 6. | inception_to_date_qty | char(1) | ('N') | |||
| 7. | qty_tp_to_show | char(1) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| invc_sect_fmt_key | invc_sect_fmt | invc_sect_fmt_key | fk_cost_plus_invc_sect_fmt1 |
| Name | Definition |
| cc_cp_invc_sect_fmt_incep_qty | ([inception_to_date_qty]='N' OR [inception_to_date_qty]='Y') |
| cc_cp_invc_sect_fmt_qty_tp | ([qty_tp_to_show]='B' OR [qty_tp_to_show]='I' OR [qty_tp_to_show]='H') |
| cc_cp_invc_sect_fmt_show_cmnt | ([show_comment]='N' OR [show_comment]='Y') |
| cc_cp_invc_sect_fmt_show_date | ([show_date]='N' OR [show_date]='Y') |
| cc_cp_invc_sect_fmt_show_qty | ([show_qty]='N' OR [show_qty]='Y') |
| cc_cp_invc_sect_fmt_show_rate | ([show_rate]='N' OR [show_rate]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_cost_plus_invc_sect_fmt | true | invc_sect_fmt_key | Asc |