Table: invoice_number

Previous: invoice_format

Unanet Data Model

Next: item

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	invoice_number_key	decimal(15)
2.		name	varchar(50)
3.		prefix	varchar(25)
4.		min_width	decimal(2)
5.		start_with	decimal(5)
6.		last_number	decimal(15)
7.		default_selected	char(1)
8.		active	char(1)

Referenced from

Table	Column	Foreign Key Name
project_invoice	invoice_number_key	fk_project_invoice4

Check Constraints

Name	Definition
cc_inv_num_fmt_active	([active]='N' OR [active]='Y')
cc_inv_num_fmt_default	([default_selected]='N' OR [default_selected]='Y')
cc_inv_num_fmt_start	([start_with]>=(0))
cc_inv_num_fmt_width	([min_width]>=(0) AND [min_width]<=(15))

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_invoice_number	true	invoice_number_key	Asc
idx_inv_num_fmt1	true	name	Asc