|
字段名 |
中文名称 |
数据类型 |
长度 |
精度 |
是否主键 |
是否外键 |
是否非空 |
|
PK_CORP |
公司编码 |
char(4) |
4 |
|
|
|
是 |
|
GCBM |
工厂编码 |
char(20) |
20 |
|
|
|
是 |
|
PK_GXJHID |
工序计划主键 |
char(20) |
20 |
|
|
|
是 |
|
PK_MOID |
生产订单主键 |
char(20) |
20 |
|
|
|
是 |
|
GXH |
工序号 |
varchar(10) |
10 |
|
|
|
是 |
|
GZZXBMID |
工作中心ID |
char(20) |
20 |
|
|
|
是 |
|
DDSJ |
DDSJ |
numeric(20,8) |
20 |
8 |
|
|
|
|
ZBSJ |
ZBSJ |
numeric(20,8) |
20 |
8 |
|
|
|
|
JGSJ |
JGSJ |
numeric(20,8) |
20 |
8 |
|
|
|
|
CXSJ |
CXSJ |
numeric(20,8) |
20 |
8 |
|
|
|
|
CSSJ |
CSSJ |
numeric(20,8) |
20 |
8 |
|
|
|
|
SFWX |
SFWX |
char(1) |
1 |
|
|
|
是 |
|
SFJC |
SFJC |
char(1) |
1 |
|
|
|
是 |
|
ZXCSSL |
ZXCSSL |
numeric(20,8) |
20 |
8 |
|
|
|
|
GDZQPL |
GDZQPL |
numeric(20,8) |
20 |
8 |
|
|
|
|
GYMS |
GYMS |
varchar(150) |
150 |
|
|
|
|
|
KZBZ |
KZBZ |
int |
|
|
|
|
是 |
|
SFJCD |
SFJCD |
char(1) |
1 |
|
|
|
|
|
SFJSD |
SFJSD |
char(1) |
1 |
|
|
|
|
|
SFJJD |
SFJJD |
char(1) |
1 |
|
|
|
|
|
SFDC |
SFDC |
char(1) |
1 |
|
|
|
|
|
HBH |
HBH |
varchar(10) |
10 |
|
|
|
|
|
CDL |
CDL |
numeric(7,4) |
7 |
4 |
|
|
|
|
JHKGRQ |
JHKGRQ |
char(10) |
10 |
|
|
|
|
|
JHWGRQ |
JHWGRQ |
char(10) |
10 |
|
|
|
|
|
JHKSSJ |
JHKSSJ |
char(8) |
8 |
|
|
|
|
|
JHJSSJ |
JHJSSJ |
char(8) |
8 |
|
|
|
|
|
JHWGSL |
JHWGSL |
numeric(20,8) |
20 |
8 |
|
|
|
|
ZDY1 |
ZDY1 |
varchar(20) |
20 |
|
|
|
|
|
ZDY2 |
ZDY2 |
varchar(20) |
20 |
|
|
|
|
|
ZDY3 |
ZDY3 |
varchar(20) |
20 |
|
|
|
|
|
ZDY4 |
ZDY4 |
varchar(20) |
20 |
|
|
|
|
|
ZDY5 |
ZDY5 |
varchar(20) |
20 |
|
|
|
|
|
ZT |
ZT |
varchar(2) |
2 |
|
|
|
是 |
|
JGBMID |
JGBMID |
char(20) |
20 |
|
|
|
|
|
FH |
FH |
numeric(20,8) |
20 |
8 |
|
|
|
|
FZXCSSL |
FZXCSSL |
numeric(20,8) |
20 |
8 |
|
|
|
|
FGDZQPL |
FGDZQPL |
numeric(20,8) |
20 |
8 |
|
|
|
|
FJHWGSL |
FJHWGS |
numeric(20,8) |
20 |
8 |
|
|
|
|
SJFS |
SJFS |
int |
|
|
|
|
|
|
GRAPH |
GRAPH |
varchar(50) |
50 |
|
|
|
|
|
REEDIT_VERSION |
REEDIT_VERSION |
int |
|
|
|
|
是 |
|
REEDIT_PEOPLE |
REEDIT_PEOPLE |
varchar(25) |
25 |
|
|
|
|
|
REEDIT_DATETIME |
REEDIT_DATETIME |
char(20) |
20 |
|
|
|
|
|
APPROVEPSN |
审批人 |
varchar(20) |
20 |
|
|
|
|
|
APPROVEDATE |
审批日期 |
varchar(20) |
20 |
|
|
|
|
|
UPDATEDATE |
修改日期 |
varchar(20) |
20 |
|
|
|
|
|
UPDATEPSN |
修改人 |
varchar(20) |
20 |
|
|
|
|
|
FACTORYERRORBOUND |
工厂误差 |
varchar(100) |
100 |
|
|
|
|
|
TECERRORBOUND |
技术误差 |
varchar(100) |
100 |
|
|
|
|
|
ISRUN |
ISRUN |
char(2) |
2 |
|
|
|
|
|
RESOURE |
RESOURE |
char(20) |
20 |
|
|
|
|
|
STANDARD |
标准 |
varchar(40) |
40 |
|
|
|
|
|
PK_RCID |
PK_RCID |
varchar(20) |
20 |
|
|
|
|
|
PK_RT_BID |
工艺路线子表ID |
varchar(20) |
20 |
|
|
|
|
|
ISSEAL |
是否封存 |
char(1) |
1 |
|
|
|
|
|
IMPORT |
重要度 |
char(1) |
1 |
|
|
|
|
|
SFHC |
SFHC |
char(1) |
1 |
|
|
|
|
|
JQGX |
JQGX |
varchar(20) |
20 |
|
|
|
|