|
id
|
int(11)
|
|
|
|
|
group_id
|
int(10) unsigned
|
|
|
|
|
group_name
|
varchar(20)
|
|
|
|
|
customer_group_id
|
int(11)
|
|
|
|
|
customer_group_name
|
varchar(100)
|
|
|
|
|
name
|
varchar(55)
|
|
|
|
|
company
|
varchar(255)
|
|
|
|
|
vat_no
|
varchar(100)
|
|
|
|
|
address
|
varchar(255)
|
|
|
|
|
city
|
varchar(55)
|
|
|
|
|
state
|
varchar(55)
|
|
|
|
|
postal_code
|
varchar(8)
|
|
|
|
|
country
|
varchar(100)
|
|
|
|
|
phone
|
varchar(20)
|
|
|
|
|
email
|
varchar(100)
|
|
|
|
|
cf1
|
varchar(100)
|
|
|
|
|
cf2
|
varchar(100)
|
|
|
|
|
cf3
|
varchar(100)
|
|
|
|
|
cf4
|
varchar(100)
|
|
|
|
|
cf5
|
varchar(100)
|
|
|
|
|
cf6
|
varchar(100)
|
|
|
|
|
invoice_footer
|
text
|
|
|
|
|
payment_term
|
int(11)
|
|
|
0
|
|
logo
|
varchar(255)
|
|
|
logo.png
|
|
award_points
|
int(11)
|
|
|
0
|
|
deposit_amount
|
decimal(25,4)
|
|
|
|
|
price_group_id
|
int(11)
|
|
|
|
|
price_group_name
|
varchar(50)
|
|
|
|
|
gst_no
|
varchar(100)
|
|
|
|