|
字段名 |
中文名称 |
数据类型 |
长度 |
精度 |
是否主键 |
是否外键 |
是否非空 |
|
BP1 |
BP1 |
varchar(30) |
30 |
|
|
|
|
|
BP2 |
BP2 |
varchar(30) |
30 |
|
|
|
|
|
BP3 |
BP3 |
varchar(30) |
30 |
|
|
|
|
|
CONADDR |
CONADDR |
varchar(60) |
60 |
|
|
|
|
|
CORRESPONDUNIT |
CORRESPONDUNIT |
varchar(20) |
20 |
|
|
|
|
|
CREDITMNY |
CREDITMNY |
decimal(20,8) |
20 |
8 |
|
|
|
|
CUSTCODE |
CUSTCODE |
varchar(40) |
40 |
|
|
|
|
|
CUSTNAME |
CUSTNAME |
varchar(200) |
200 |
|
|
|
|
|
CUSTPROP |
CUSTPROP |
int |
|
|
|
|
|
|
CUSTSHORTNAME |
CUSTSHORTNAME |
varchar(200) |
200 |
|
|
|
|
|
DEF1 |
DEF1 |
varchar(100) |
100 |
|
|
|
|
|
DEF2 |
DEF2 |
varchar(100) |
100 |
|
|
|
|
|
DEF3 |
DEF3 |
varchar(100) |
100 |
|
|
|
|
|
DEF4 |
DEF4 |
varchar(100) |
100 |
|
|
|
|
|
DEF5 |
DEF5 |
varchar(100) |
100 |
|
|
|
|
|
DEF6 |
DEF6 |
varchar(100) |
100 |
|
|
|
|
|
DEF7 |
DEF7 |
varchar(100) |
100 |
|
|
|
|
|
DEF8 |
DEF8 |
varchar(100) |
100 |
|
|
|
|
|
DEF9 |
DEF9 |
varchar(100) |
100 |
|
|
|
|
|
DEF10 |
DEF10 |
varchar(100) |
100 |
|
|
|
|
|
DEF11 |
DEF11 |
varchar(100) |
100 |
|
|
|
|
|
DEF12 |
DEF12 |
varchar(100) |
100 |
|
|
|
|
|
DEF13 |
DEF13 |
varchar(100) |
100 |
|
|
|
|
|
DEF14 |
DEF14 |
varchar(100) |
100 |
|
|
|
|
|
DEF15 |
DEF15 |
varchar(100) |
100 |
|
|
|
|
|
DEF16 |
DEF16 |
varchar(100) |
100 |
|
|
|
|
|
DEF17 |
DEF17 |
varchar(100) |
100 |
|
|
|
|
|
DEF18 |
DEF18 |
varchar(100) |
100 |
|
|
|
|
|
DEF19 |
DEF19 |
varchar(100) |
100 |
|
|
|
|
|
DEF20 |
DEF20 |
varchar(100) |
100 |
|
|
|
|
|
DRPNODEFLAG |
DRPNODEFLAG |
char(1) |
1 |
|
|
|
|
|
ECOTYPESINCEVFIVE |
ECOTYPESINCEVFIVE |
char(20) |
20 |
|
|
|
|
|
|
|
varchar(50) |
50 |
|
|
|
|
|
ENGNAME |
ENGNAME |
varchar(60) |
60 |
|
|
|
|
|
FAX1 |
FAX1 |
varchar(30) |
30 |
|
|
|
|
|
FAX2 |
FAX2 |
varchar(30) |
30 |
|
|
|
|
|
FREECUSTFLAG |
FREECUSTFLAG |
char(1) |
1 |
|
|
|
|
|
ISCONNFLAG |
ISCONNFLAG |
char(1) |
1 |
|
|
|
|
|
LEGALBODY |
LEGALBODY |
varchar(16) |
16 |
|
|
|
|
|
LINKMAN1 |
LINKMAN1 |
varchar(25) |
25 |
|
|
|
|
|
LINKMAN2 |
LINKMAN2 |
varchar(25) |
25 |
|
|
|
|
|
LINKMAN3 |
LINKMAN3 |
varchar(25) |
25 |
|
|
|
|
|
MEMO |
MEMO |
varchar(100) |
100 |
|
|
|
|
|
MNECODE |
MNECODE |
varchar(50) |
50 |
|
|
|
|
|
MOBILEPHONE1 |
MOBILEPHONE1 |
varchar(30) |
30 |
|
|
|
|
|
MOBILEPHONE2 |
MOBILEPHONE2 |
varchar(30) |
30 |
|
|
|
|
|
MOBILEPHONE3 |
MOBILEPHONE3 |
varchar(30) |
30 |
|
|
|
|
|
PHONE1 |
PHONE1 |
varchar(30) |
30 |
|
|
|
|
|
PHONE2 |
PHONE2 |
varchar(30) |
30 |
|
|
|
|
|
PHONE3 |
PHONE3 |
varchar(30) |
30 |
|
|
|
|
|
PK_AREACL |
PK_AREACL |
char(20) |
20 |
|
|
|
|
|
PK_CORP |
PK_CORP |
char(20) |
20 |
|
|
|
|
|
PK_CORP1 |
PK_CORP1 |
char(20) |
20 |
|
|
|
|
|
PK_CUBASDOC |
PK_CUBASDOC |
char(20) |
20 |
|
是 |
|
是 |
|
PK_CUBASDOC1 |
PK_CUBASDOC1 |
char(20) |
20 |
|
|
|
|
|
PK_PRICEGROUP |
PK_PRICEGROUP |
char(20) |
20 |
|
|
|
|
|
REGISTERFUND |
REGISTERFUND |
decimal(20,8) |
20 |
8 |
|
|
|
|
SALEADDR |
SALEADDR |
varchar(60) |
60 |
|
|
|
|
|
SEALFLAG |
SEALFLAG |
char(10) |
10 |
|
|
|
|
|
TAXPAYERID |
TAXPAYERID |
char(20) |
20 |
|
|
|
|
|
TRADE |
TRADE |
char(20) |
20 |
|
|
|
|
|
URL |
URL |
varchar(60) |
60 |
|
|
|
|
|
ZIPCODE |
ZIPCODE |
char(6) |
6 |
|
|
|
|