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_tot_amount	char(1)	('Y')
8.		filter_sequence	tinyint
9.		filter_type	tinyint
10.		col1_field	tinyint
11.		col1_heading	varchar(40)
12.		col1_subtotal_amount	char(1)	('N')
13.		col2_field	tinyint
14.		col2_heading	varchar(40)
15.		col2_subtotal_amount	char(1)	('N')
16.		col3_field	tinyint
17.		col3_heading	varchar(40)
18.		col3_subtotal_amount	char(1)	('N')
19.		show_section_tot_qty	char(1)	('N')
20.		show_section_tot_itd_qty	char(1)	('N')
21.		col1_subtotal_qty	char(1)	('N')
22.		col2_subtotal_qty	char(1)	('N')
23.		col3_subtotal_qty	char(1)	('N')
24.		col1_subtotal_itd_qty	char(1)	('N')
25.		col2_subtotal_itd_qty	char(1)	('N')
26.		col3_subtotal_itd_qty	char(1)	('N')
27.		col4_field	tinyint
28.		col4_heading	varchar(40)
29.		col4_subtotal_amount	char(1)	('N')
30.		col4_subtotal_qty	char(1)	('N')
31.		col4_subtotal_itd_qty	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
bill_by_method_type_invc_fltr	invc_sect_fmt_key	fk_bill_by_mthd_tp_invc_fltr1
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
document_type_invc_fltr	invc_sect_fmt_key	fk_document_type_invc_fltr1
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]<=(18))
cc_invc_sect_fmt_col1_itd_qty	([col1_subtotal_itd_qty]='Y' AND ([type]=(5) OR [type]=(2) OR [type]=(1)) OR [col1_subtotal_itd_qty]='N')
cc_invc_sect_fmt_col1_qty	([col1_subtotal_qty]='Y' AND ([type]=(5) OR [type]=(2) OR [type]=(1)) OR [col1_subtotal_qty]='N')
cc_invc_sect_fmt_col1_subtot	([col1_subtotal_amount]='N' OR [col1_subtotal_amount]='Y')
cc_invc_sect_fmt_col2_field	([col2_field]>=(0) AND [col2_field]<=(18))
cc_invc_sect_fmt_col2_itd_qty	([col2_subtotal_itd_qty]='Y' AND ([type]=(5) OR [type]=(2) OR [type]=(1)) OR [col2_subtotal_itd_qty]='N')
cc_invc_sect_fmt_col2_qty	([col2_subtotal_qty]='Y' AND ([type]=(5) OR [type]=(2) OR [type]=(1)) OR [col2_subtotal_qty]='N')
cc_invc_sect_fmt_col2_subtot	([col2_subtotal_amount]='N' OR [col2_subtotal_amount]='Y')
cc_invc_sect_fmt_col3_field	([col3_field]>=(0) AND [col3_field]<=(18))
cc_invc_sect_fmt_col3_itd_qty	([col3_subtotal_itd_qty]='Y' AND ([type]=(5) OR [type]=(2) OR [type]=(1)) OR [col3_subtotal_itd_qty]='N')
cc_invc_sect_fmt_col3_qty	([col3_subtotal_qty]='Y' AND ([type]=(5) OR [type]=(2) OR [type]=(1)) OR [col3_subtotal_qty]='N')
cc_invc_sect_fmt_col3_subtot	([col3_subtotal_amount]='N' OR [col3_subtotal_amount]='Y')
cc_invc_sect_fmt_col4_field	([col4_field]>=(0) AND [col4_field]<=(18))
cc_invc_sect_fmt_col4_itd_qty	([col4_subtotal_itd_qty]='Y' AND ([type]=(5) OR [type]=(2) OR [type]=(1)) OR [col4_subtotal_itd_qty]='N')
cc_invc_sect_fmt_col4_qty	([col4_subtotal_qty]='Y' AND ([type]=(5) OR [type]=(2) OR [type]=(1)) OR [col4_subtotal_qty]='N')
cc_invc_sect_fmt_col4_subtot	([col4_subtotal_amount]='N' OR [col4_subtotal_amount]='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]<=(9))
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_tot_amount]='N' OR [show_section_tot_amount]='Y')
cc_invc_sect_fmt_tot_itd_qty	([show_section_tot_itd_qty]='Y' AND ([type]=(5) OR [type]=(2) OR [type]=(1)) OR [show_section_tot_itd_qty]='N')
cc_invc_sect_fmt_tot_qty	([show_section_tot_qty]='Y' AND ([type]=(5) OR [type]=(2) OR [type]=(1)) OR [show_section_tot_qty]='N')
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