Table Definitions: Business Profiles

column	type	null	unique	references	since_version	description
pkey	pkey	false	true		1.0a100	a unique primary key
accounting	accounting	false	false	businesses.accounting	1.0a100	the accounting code of the business
priority	int	false	false		1.0a100	the highest priority profile is used
name	string	false	false		1.0a100	the name of the business
private	boolean	false	false		1.0a100	indicates if the business should not be listed in publicly available lists
phone	phone	false	false		1.0a100	the phone number
fax	phone	true	false		1.0a100	the fax number
address1	string	false	false		1.0a100	the street address of the business
address2	string	true	false		1.0a100	the street address of the business
city	string	false	false		1.69	the city
state	string	true	false		1.69	the state or providence
country	string	false	false	country_codes.code	1.69	the two-character country code
zip	string	true	false		1.69	the zip code
send_invoice	boolean	false	false		1.0a100	indicates to send a monthly invoice via regular mail
created	time	false	false		1.0a100	the time this entry was created
billing_contact	string	false	false		1.0a100	the name to contact for billing information
billing_email	string	false	false		1.0a100	the email address to notify for billing
billingEmailFormat	string	false	false		1.81.20	the format for billing notification emails
technical_contact	string	false	false		1.0a100	the name to contact for technical information
technical_email	string	false	false		1.0a100	the email address to notify for technical
technicalEmailFormat	string	false	false		1.81.20	the format for technical notification emails

TABLE NAME