Table: invc_sect_fmt

Previous: imported_lodging_detail

Unanet Data Model

Next: invc_sect_fmt_tot_grp

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	invc_sect_fmt_key	decimal(15)
2.		invoice_format_key	decimal(15)		invoice_format	fk_invc_sect_fmt1
3.		type	tinyint
4.		label	varchar(50)
5.		sequence	tinyint
6.		show_amount	char(1)	('Y')
7.		show_section_total	char(1)	('Y')
8.		filter_sequence	tinyint
9.		filter_type	tinyint
10.		col1_field	tinyint
11.		col1_heading	varchar(40)
12.		col1_subtotal	char(1)	('N')
13.		col2_field	tinyint
14.		col2_heading	varchar(40)
15.		col2_subtotal	char(1)	('N')
16.		col3_field	tinyint
17.		col3_heading	varchar(40)
18.		col3_subtotal	char(1)	('N')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
invoice_format_key	invoice_format	invoice_format_key	fk_invc_sect_fmt1

Referenced from

Table	Column	Foreign Key Name
cost_element_invc_fltr	invc_sect_fmt_key	fk_cost_element_invc_fltr1
cost_element_type_invc_fltr	invc_sect_fmt_key	fk_cost_elem_type_invc_fltr1
cost_plus_invc_sect_fmt	invc_sect_fmt_key	fk_cost_plus_invc_sect_fmt1
expense_invc_sect_fmt	invc_sect_fmt_key	fk_exp_invc_sect_fmt1
expense_type_invc_fltr	invc_sect_fmt_key	fk_expense_type_invc_fltr1
fixed_price_invc_sect_fmt	invc_sect_fmt_key	fk_fixed_price_invc_sect_fmt1
labor_category_invc_fltr	invc_sect_fmt_key	fk_labor_category_invc_fltr1
labor_invc_sect_fmt	invc_sect_fmt_key	fk_labor_invc_sect_fmt1
onetime_charge_type_invc_fltr	invc_sect_fmt_key	fk_onetime_chrg_ty_invc_fltr1
prebill_invc_sect_fmt	invc_sect_fmt_key	fk_prebill_invc_sect_fmt1

Check Constraints

Name	Definition
cc_invc_sect_fmt_col1_field	([col1_field]>=(0) AND [col1_field]<=(14))
cc_invc_sect_fmt_col1_subtot	([col1_subtotal]='N' OR [col1_subtotal]='Y')
cc_invc_sect_fmt_col2_field	([col2_field]>=(0) AND [col2_field]<=(14))
cc_invc_sect_fmt_col2_subtot	([col2_subtotal]='N' OR [col2_subtotal]='Y')
cc_invc_sect_fmt_col3_field	([col3_field]>=(0) AND [col3_field]<=(14))
cc_invc_sect_fmt_col3_subtot	([col3_subtotal]='N' OR [col3_subtotal]='Y')
cc_invc_sect_fmt_filter_seq	([filter_sequence]>=(0) AND [filter_sequence]<=(99))
cc_invc_sect_fmt_filter_type	([filter_type]>=(0) AND [filter_type]<=(7))
cc_invc_sect_fmt_sequence	([sequence]>=(0) AND [sequence]<=(99))
cc_invc_sect_fmt_show_amount	([show_amount]='N' OR [show_amount]='Y')
cc_invc_sect_fmt_show_sect_tot	([show_section_total]='N' OR [show_section_total]='Y')
cc_invc_sect_fmt_type	([type]>=(1) AND [type]<=(10))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_invc_sect_fmt	true	invc_sect_fmt_key	Asc
idx_invc_sect_fmt1	false	invoice_format_key	Asc