|
字段名 |
中文名称 |
数据类型 |
长度 |
精度 |
是否主键 |
是否外键 |
是否非空 |
|
PK_MTCONSUME |
PK_MTCONSUME |
char(20) |
20 |
|
是 |
|
是 |
|
PK_MTJOBTREE_B |
PK_MTJOBTREE_B |
char(20) |
20 |
|
|
|
|
|
PK_PRODUCE |
PK_PRODUCE |
char(20) |
20 |
|
|
|
|
|
PK_INVMANDOC |
PK_INVMANDOC |
char(20) |
20 |
|
|
|
|
|
PK_INVBASDOC |
PK_INVBASDOC |
char(20) |
20 |
|
|
|
|
|
PK_MEASDOC |
PK_MEASDOC |
char(20) |
20 |
|
|
|
|
|
NUM |
NUM |
numeric(6,2) |
6 |
2 |
|
|
|
|
FJLDWID |
FJLDWID |
char(20) |
20 |
|
|
|
|
|
FNUM |
FNUM |
numeric(6,2) |
6 |
2 |
|
|
|
|
HSL |
HSL |
numeric(6,2) |
6 |
2 |
|
|
|
|
ATTR |
ATTR |
varchar(40) |
40 |
|
|
|
|
|
ISSELED |
ISSELED |
char(1) |
1 |
|
|
|
|
|
GROUPNO |
GROUPNO |
varchar(40) |
40 |
|
|
|
|
|
EXCHGATTR |
EXCHGATTR |
int |
|
|
|
|
|
|
SFDC |
SFDC |
char(1) |
1 |
|
|
|
|
|
ZYX1 |
ZYX1 |
varchar(40) |
40 |
|
|
|
|
|
ZYX2 |
ZYX2 |
varchar(40) |
40 |
|
|
|
|
|
ZYX3 |
ZYX3 |
varchar(40) |
40 |
|
|
|
|
|
ZYX4 |
ZYX4 |
varchar(40) |
40 |
|
|
|
|
|
ZYX5 |
ZYX5 |
varchar(40) |
40 |
|
|
|
|
|
BLLY |
BLLY |
int |
|
|
|
|
|