|
字段名 |
中文名称 |
数据类型 |
长度 |
精度 |
是否主键 |
是否外键 |
是否非空 |
|
pk_selfdef_form |
pk_selfdef_form |
varchar(100) |
100 |
|
|
|
|
|
pk_selfdef_form_p |
pk_selfdef_form_p |
varchar(100) |
100 |
|
|
|
|
|
approve_date |
approve_date |
char(10) |
10 |
|
|
|
|
|
approve_note |
approve_note |
varchar(100) |
100 |
|
|
|
|
|
approver |
approver |
varchar(20) |
20 |
|
|
|
|
|
bill_submit_date |
bill_submit_date |
char(10) |
10 |
|
|
|
|
|
bill_submitter |
bill_submitter |
varchar(20) |
20 |
|
|
|
|
|
billmakedate |
billmakedate |
char(10) |
10 |
|
|
|
|
|
bill_writer |
bill_writer |
varchar(20) |
20 |
|
|
|
|
|
billname |
billname |
varchar(100) |
100 |
|
|
|
|
|
bill_code |
bill_code |
varchar(20) |
20 |
|
|
|
|
|
approve_state |
approve_state |
int |
|
|
|
|
|
|
memo |
memo |
varchar(1000) |
1,000 |
|
|
|
|
|
bill_type |
bill_type |
varchar(20) |
20 |
|
|
|
|
|
pk_corp |
pk_corp |
char(4) |
4 |
|
|
|
|
|
approved |
approved |
char(1) |
1 |
|
|
|
|
|
querycondition |
querycondition |
varchar(1000) |
1,000 |
|
|
|
|
|
ishistory |
ishistory |
char(1) |
1 |
|
|
|
|
|
pk_busitype |
pk_busitype |
varchar(20) |
20 |
|
|
|
|
|
pk_businesstype |
pk_businesstype |
varchar(100) |
100 |
|
|
|
|
|
pk_sttype |
pk_sttype |
varchar(100) |
100 |
|
|
|
|
|
sreason |
sreason |
varchar(100) |
100 |
|
|
|
|
|
effectdate |
effectdate |
char(10) |
10 |
|
|
|
|
|
psncode |
psncode |
varchar(100) |
100 |
|
|
|
|
|
psnname |
psnname |
varchar(100) |
100 |
|
|
|
|
|
src_corp |
src_corp |
varchar(100) |
100 |
|
|
|
|
|
tgt_corp |
tgt_corp |
varchar(100) |
100 |
|
|
|
|
|
tgtold_psncl |
tgtold_psncl |
varchar(100) |
100 |
|
|
|
|
|
src_dept |
src_dept |
varchar(100) |
100 |
|
|
|
|
|
tgt_dept |
tgt_dept |
varchar(100) |
100 |
|
|
|
|
|
src_psncl |
src_psncl |
varchar(100) |
100 |
|
|
|
|
|
tgtnew_psncl |
tgtnew_psncl |
varchar(100) |
100 |
|
|
|
|
|
src_job |
src_job |
varchar(100) |
100 |
|
|
|
|
|
tgt_job |
tgt_job |
varchar(100) |
100 |
|
|
|
|
|
src_jobs |
src_jobs |
varchar(100) |
100 |
|
|
|
|
|
tgt_jobs |
tgt_jobs |
varchar(100) |
100 |
|
|
|
|
|
src_job_level |
src_job_level |
varchar(100) |
100 |
|
|
|
|
|
tgt_job_level |
tgt_job_level |
varchar(100) |
100 |
|
|
|
|