Table: invoice_format

Previous: invoice_addl_fmt

Unanet Data Model

Next: invoice_number

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	invoice_format_key	decimal(15)
2.		name	varchar(50)
3.		description	varchar(128)
4.		active	char(1)	('N')
5.		ar_balance	char(1)	('N')
6.		invoiced_to_date	char(1)	('N')
7.		inception_to_date	char(1)	('N')
8.		remit_to_one_line	char(1)	('N')
9.		group_by_project	char(1)	('N')
10.		show_project_funded_value	char(1)	('N')
11.		show_proj_rem_funded	char(1)	('N')
12.		show_project_order_number	char(1)	('N')
13.		project_show_customer_code	char(1)	('Y')
14.		project_show_project_code	char(1)	('Y')
15.		project_show_title	char(1)	('Y')
16.		group_by_task	char(1)	('N')
17.		show_task_funded_value	char(1)	('N')
18.		show_task_rem_funded	char(1)	('N')
19.		task_group_level	tinyint	((0))
20.		task_show_number	char(1)	('Y')
21.		task_show_name	char(1)	('Y')

Referenced from

Table	Column	Foreign Key Name
invc_sect_fmt	invoice_format_key	fk_invc_sect_fmt1
invc_sect_fmt_tot_grp	invoice_format_key	fk_invc_sect_fmt_tot_grp1
invoice	invoice_format_key	fk_invoice5
invoice_addl_fmt	invoice_format_key	fk_invoice_addl_fmt2
project_invoice	invoice_format_key	fk_project_invoice2
project_invoice_addl_fmt	invoice_format_key	fk_project_invoice_addl_fmt2

Check Constraints

Name	Definition
cc_invc_fmt_ar_balance	([ar_balance]='N' OR [ar_balance]='Y')
cc_invc_fmt_group_by_project	([group_by_project]='N' OR [group_by_project]='Y')
cc_invc_fmt_group_by_task	([group_by_task]='N' OR [group_by_task]='Y')
cc_invc_fmt_inception_to_date	([inception_to_date]='N' OR [inception_to_date]='Y')
cc_invc_fmt_inv_invcd_to_date	([invoiced_to_date]='N' OR [invoiced_to_date]='Y')
cc_invc_fmt_prj_show_cust_code	([project_show_customer_code]='N' OR [project_show_customer_code]='Y')
cc_invc_fmt_prj_show_prj_code	([project_show_project_code]='N' OR [project_show_project_code]='Y')
cc_invc_fmt_prj_show_title	([project_show_title]='N' OR [project_show_title]='Y')
cc_invc_fmt_proj_rem_funded	([show_proj_rem_funded]='N' OR [show_proj_rem_funded]='Y')
cc_invc_fmt_remit_to_one_line	([remit_to_one_line]='N' OR [remit_to_one_line]='Y')
cc_invc_fmt_show_prj_fnd_val	([show_project_funded_value]='N' OR [show_project_funded_value]='Y')
cc_invc_fmt_show_prj_ord_num	([show_project_order_number]='N' OR [show_project_order_number]='Y')
cc_invc_fmt_show_task_fnd_val	([show_task_funded_value]='N' OR [show_task_funded_value]='Y')
cc_invc_fmt_task_group_level	([task_group_level]>=(0) AND [task_group_level]<=(9))
cc_invc_fmt_task_rem_funded	([show_task_rem_funded]='N' OR [show_task_rem_funded]='Y')
cc_invc_fmt_task_show_name	([task_show_name]='N' OR [task_show_name]='Y')
cc_invc_fmt_task_show_number	([task_show_number]='N' OR [task_show_number]='Y')
cc_invoice_format_active	([active]='N' OR [active]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_invoice_format	true	invoice_format_key	Asc
idx_invoice_format1	true	name	Asc