Table: expense_invc_sect_fmt

Previous: expense_history

Unanet Data Model

Next: expense_plan

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')
7.		show_qty	char(1)	('N')
8.		inception_to_date_qty	char(1)	('N')
9.		show_cost_rate	char(1)	('N')
10.		show_bill_rate	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_incep_qty	([inception_to_date_qty]='N' OR [inception_to_date_qty]='Y')
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_bll_rt	([show_bill_rate]='N' OR [show_bill_rate]='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_cst_rt	([show_cost_rate]='N' OR [show_cost_rate]='Y')
cc_e_invc_sect_fmt_show_date	([show_date]='N' OR [show_date]='Y')
cc_e_invc_sect_fmt_show_qty	([show_qty]='N' OR [show_qty]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_exp_invc_sect_fmt	true	invc_sect_fmt_key	Asc