Table: fixed_price_invc_sect_fmt

Previous: fixed_price

Unanet Data Model

Next: fleet

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	invc_sect_fmt_key	decimal(15)		invc_sect_fmt	fk_fixed_price_invc_sect_fmt1
2.		show_individually	char(1)	('N')
3.		show_bill_date	char(1)	('N')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
invc_sect_fmt_key	invc_sect_fmt	invc_sect_fmt_key	fk_fixed_price_invc_sect_fmt1

Check Constraints

Name	Definition
cc_fp_invc_sect_fmt_show_bdate	([show_bill_date]='N' OR [show_bill_date]='Y')
cc_fp_invc_sect_fmt_show_indiv	([show_individually]='N' OR [show_individually]='Y')

Indices

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