|
dedid
|
char(15)
|
utf8_general_ci
|
|
|
|
ded_status
|
char(1)
|
utf8_general_ci
|
|
|
|
ded_date
|
date
|
|
|
|
|
ded_amount
|
decimal(12,2)
|
|
|
|
|
corpcustnum
|
char(8)
|
utf8_general_ci
|
|
|
|
corpcustname
|
varchar(40)
|
utf8_general_ci
|
|
|
|
ded_customer
|
char(8)
|
utf8_general_ci
|
|
|
|
ded_cust_name
|
varchar(40)
|
utf8_general_ci
|
|
|
|
ded_brokerid
|
int(4)
|
|
|
|
|
bkr_name
|
varchar(40)
|
utf8_general_ci
|
|
|
|
slsmnid
|
char(4)
|
utf8_general_ci
|
|
|
|
slsmnname
|
varchar(40)
|
utf8_general_ci
|
|
|
|
ded_location
|
char(3)
|
utf8_general_ci
|
|
|
|
ded_code
|
varchar(8)
|
utf8_general_ci
|
|
|
|
dc_desc
|
varchar(32)
|
utf8_general_ci
|
|
|
|
ded_reference
|
varchar(120)
|
utf8_general_ci
|
|
|
|
ded_checkno
|
varchar(20)
|
utf8_general_ci
|
|
|
|
ded_user
|
char(12)
|
utf8_general_ci
|
|
|
|
brk_id
|
char(12)
|
utf8_general_ci
|
|
|
|
brk_apprv_flag
|
char(1)
|
utf8_general_ci
|
|
|
|
brk_apprv_date
|
date
|
|
|
|
|
slsmgr
|
char(12)
|
utf8_general_ci
|
|
|
|
mgr_apprv_flag
|
char(1)
|
utf8_general_ci
|
|
|
|
mgr_apprv_date
|
date
|
|
|
|
|
correspondent
|
char(12)
|
utf8_general_ci
|
|
|
|
comments_flag
|
date
|
|
|
|
|
create_date
|
date
|
|
|
|
|
create_user
|
char(12)
|
utf8_general_ci
|
|
|
|
retrieved_flag
|
char(1)
|
utf8_general_ci
|
|
|
|
retrieved_date
|
date
|
|
|
|
|
retrieved_user
|
char(12)
|
utf8_general_ci
|
|
|
|
removed_date
|
date
|
|
|
|
|
removed_user
|
char(12)
|
utf8_general_ci
|
|
|
