Table: invc_sect_fmt_tot_grp

Previous: invc_sect_fmt

Unanet Data Model

Next: invcd_cost_plus_post_detail

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	invoice_format_key	decimal(15)		invoice_format	fk_invc_sect_fmt_tot_grp1
2.	PK	type	tinyint
3.		label	varchar(50)
4.		show_qty	char(1)	('N')
5.		show_itd_qty	char(1)	('N')
6.		show_amount	char(1)	('Y')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
invoice_format_key	invoice_format	invoice_format_key	fk_invc_sect_fmt_tot_grp1

Check Constraints

Name	Definition
cc_invc_sect_fmt_tot_grp_amt	([show_amount]='N' OR [show_amount]='Y')
cc_invc_sect_fmt_tot_grp_itd	([show_itd_qty]='Y' AND ([type]=(5) OR [type]=(2) OR [type]=(1)) OR [show_itd_qty]='N')
cc_invc_sect_fmt_tot_grp_qty	([show_qty]='Y' AND ([type]=(5) OR [type]=(2) OR [type]=(1)) OR [show_qty]='N')
cc_invc_sect_fmt_tot_grp_show	([show_qty]='Y' OR [show_amount]='Y' OR [show_itd_qty]='Y')
cc_invc_sect_fmt_tot_grp_type	([type]>=(1) AND [type]<=(9))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_invc_sect_fmt_tot_grp	true	invoice_format_key	Asc
		type