Table: billing_info

Previous: bill_by_method_type_invc_fltr

Unanet Data Model

Next: billing_setup

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	vendor_key	decimal(15)		vendor	fk_billing_info1
2.		contact_first_name	varchar(50)
3.		contact_last_name	varchar(50)
4.		street1	varchar(100)
5.		street2	varchar(100)
6.		city	varchar(50)
7.		state	varchar(5)
8.		zip	varchar(9)
9.		account_number	varchar(255)
10.		email	varchar(100)
11.		phone	varchar(25)
12.		fax	varchar(25)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
vendor_key	vendor	vendor_key	fk_billing_info1

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_billing_info	true	vendor_key	Asc