Table: expense_invc_sect_fmt

Columns
  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')    
Foreign Keys
Column References Foreign Key Name
Table Column
invc_sect_fmt_key invc_sect_fmt invc_sect_fmt_key fk_exp_invc_sect_fmt1
Check Constraints
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')
Indices
Index Name Unique Column Name Asc Or Desc
pk_exp_invc_sect_fmt true invc_sect_fmt_key Asc