|
字段名 |
中文名称 |
数据类型 |
长度 |
精度 |
是否主键 |
是否外键 |
是否非空 |
|
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_wa_item |
pk_wa_item |
varchar(100) |
100 |
|
|
|
|
|
begindate |
begindate |
char(10) |
10 |
|
|
|
|
|
enddate |
enddate |
char(10) |
10 |
|
|
|
|
|
negotiation |
negotiation |
char(1) |
1 |
|
|
|
|
|
wa_apply_monty |
wa_apply_monty |
decimal(16,4) |
16 |
4 |
|
|
|
|
wa_approve_money |
wa_approve_money |
decimal(16,4) |
16 |
4 |
|
|
|
|
wa_apply_reason |
wa_apply_reason |
varchar(100) |
100 |
|
|
|
|