|
id
|
int(11)
|
|
|
|
|
vend_id
|
varchar(50)
|
|
|
|
|
vend_name
|
varchar(200)
|
|
|
|
|
vend_short_name
|
varchar(100)
|
|
|
|
|
vend_type
|
varchar(50)
|
|
|
|
|
vend_level
|
varchar(10)
|
|
|
|
|
industry
|
varchar(100)
|
|
|
|
|
main_contact
|
varchar(100)
|
|
|
|
|
main_phone
|
varchar(50)
|
|
|
|
|
main_email
|
varchar(200)
|
|
|
|
|
business_license
|
varchar(100)
|
|
|
|
|
tax_number
|
varchar(100)
|
|
|
|
|
bank_name
|
varchar(100)
|
|
|
|
|
bank_account
|
varchar(100)
|
|
|
|
|
cooperation_years
|
int(11)
|
|
|
0
|
|
credit_rating
|
varchar(20)
|
|
|
|
|
payment_terms
|
varchar(100)
|
|
|
|
|
delivery_terms
|
varchar(100)
|
|
|
|
|
purchaser
|
varchar(100)
|
|
|
|
|
source
|
varchar(50)
|
|
|
|
|
vend_sta
|
varchar(20)
|
|
|
active
|
|
is_active
|
tinyint(4)
|
|
|
1
|
|
vend_memo
|
text
|
|
|
|
|
cooperation_history
|
text
|
|
|
|
|
quality_notes
|
text
|
|
|
|
|
create_date
|
datetime
|
|
|
|
|
create_by
|
varchar(50)
|
|
|
|
|
last_modify_date
|
datetime
|
|
|
|
|
last_modify_by
|
varchar(50)
|
|
|
|
|
tag_id
|
int(11)
|
|
|
|