|
req_id
|
int(4)
|
|
|
|
|
job_id
|
varchar(16)
|
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(7)
|
utf8_general_ci
|
|
|
|
customer_zip
|
varchar(10)
|
utf8_general_ci
|
|
|
|
customer_country
|
varchar(30)
|
utf8_general_ci
|
|
|
|
customer_phone
|
varchar(15)
|
utf8_general_ci
|
|
|
|
attn
|
varchar(80)
|
utf8_general_ci
|
|
|
|
email
|
varchar(128)
|
utf8_general_ci
|
|
|
|
broker
|
varchar(128)
|
utf8_general_ci
|
|
|
|
spec_sht
|
varchar(16)
|
utf8_general_ci
|
|
|
|
tracking_no
|
varchar(128)
|
utf8_general_ci
|
|
|
|
purpose
|
varchar(256)
|
utf8_general_ci
|
|
|
|
rd_desc
|
varchar(64)
|
utf8_general_ci
|
|
|
|
other_desc
|
varchar(64)
|
utf8_general_ci
|
|
|
|
shipvia
|
varchar(80)
|
utf8_general_ci
|
|
|
|
shipdate
|
datetime
|
|
|
|
|
due_date
|
date
|
|
|
|
|
user
|
varchar(30)
|
utf8_general_ci
|
|
|
|
user_level
|
tinyint(2)
|
|
|
|
|
branch
|
varchar(80)
|
utf8_general_ci
|
|
|
|
approvedby
|
varchar(60)
|
utf8_general_ci
|
|
|
|
approvedate
|
datetime
|
|
|
|
|
create_date
|
datetime
|
|
|
|
|
comp_date
|
datetime
|
|
|
|
|
status
|
varchar(30)
|
utf8_general_ci
|
|
|
|
active
|
tinyint(2)
|
|
|
|
