|
req_id
|
int(8)
|
|
|
|
|
req_type
|
varchar(80)
|
utf8_general_ci
|
|
|
|
customer_code
|
varchar(80)
|
utf8_general_ci
|
|
|
|
customer_name
|
varchar(80)
|
utf8_general_ci
|
|
|
|
customer_addr1
|
varchar(80)
|
utf8_general_ci
|
|
|
|
customer_addr2
|
varchar(80)
|
utf8_general_ci
|
|
|
|
customer_city
|
varchar(80)
|
utf8_general_ci
|
|
|
|
customer_state
|
varchar(2)
|
utf8_general_ci
|
|
|
|
customer_zip
|
varchar(10)
|
utf8_general_ci
|
|
|
|
customer_country
|
varchar(30)
|
utf8_general_ci
|
|
|
|
customer_phone
|
varchar(15)
|
utf8_general_ci
|
|
|
|
customer_fax
|
varchar(15)
|
utf8_general_ci
|
|
|
|
attn
|
varchar(80)
|
utf8_general_ci
|
|
|
|
title
|
varchar(80)
|
utf8_general_ci
|
|
|
|
email
|
varchar(128)
|
utf8_general_ci
|
|
|
|
email_subject
|
varchar(128)
|
utf8_general_ci
|
|
|
|
doc_type
|
varchar(30)
|
utf8_general_ci
|
|
|
|
user
|
varchar(30)
|
utf8_general_ci
|
|
|
|
user_level
|
tinyint(2)
|
|
|
|
|
assi
|
varchar(30)
|
utf8_general_ci
|
|
|
|
assi_email
|
varchar(128)
|
utf8_general_ci
|
|
|
|
due_date
|
varchar(16)
|
utf8_general_ci
|
|
|
|
duedate
|
date
|
|
|
|
|
create_date
|
timestamp
|
|
|
|
|
comp_date
|
timestamp
|
|
|
|
|
appr_date
|
timestamp
|
|
|
|
|
sent_date
|
timestamp
|
|
|
|
|
status
|
varchar(30)
|
utf8_general_ci
|
|
|
|
stscde
|
tinyint(2)
|
|
|
|
|
branch
|
varchar(32)
|
utf8_general_ci
|
|
|
|
active
|
tinyint(2)
|
|
|
|
