|
字段名 |
中文名称 |
数据类型 |
长度 |
精度 |
是否主键 |
是否外键 |
是否非空 |
|
ABCAREA |
ABCAREA |
char(20) |
20 |
|
|
|
|
|
ACCOPENDATE |
ACCOPENDATE |
char(10) |
10 |
|
|
|
|
|
ADDRESS |
ADDRESS |
varchar(60) |
60 |
|
|
|
|
|
ARAPPROP |
ARAPPROP |
int |
|
|
|
|
|
|
AREACODE |
AREACODE |
varchar(28) |
28 |
|
|
|
|
|
BANKACC |
BANKACC |
varchar(40) |
40 |
|
|
|
|
|
BANKAREA |
BANKAREA |
varchar(80) |
80 |
|
|
|
|
|
BANKNAME |
BANKNAME |
varchar(200) |
200 |
|
|
|
|
|
BANKOWNER |
BANKOWNER |
varchar(60) |
60 |
|
|
|
|
|
BANKTYPE |
BANKTYPE |
int |
|
|
|
|
|
|
BEGINMNY |
BEGINMNY |
decimal(20,8) |
20 |
8 |
|
|
|
|
BEGINMNYDATE |
BEGINMNYDATE |
char(10) |
10 |
|
|
|
|
|
BRANCHNAME |
BRANCHNAME |
varchar(80) |
80 |
|
|
|
|
|
CITY |
CITY |
varchar(80) |
80 |
|
|
|
|
|
COMBINEACCNUM |
COMBINEACCNUM |
varchar(80) |
80 |
|
|
|
|
|
CONTACTPSN |
CONTACTPSN |
varchar(25) |
25 |
|
|
|
|
|
CTLPROP |
CTLPROP |
int |
|
|
|
|
|
|
CUSTCODE |
CUSTCODE |
varchar(40) |
40 |
|
|
|
|
|
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 |
|
|
|
|
|
GENEBRANPROP |
GENEBRANPROP |
int |
|
|
|
|
|
|
GROUPACCOUNT |
GROUPACCOUNT |
int |
|
|
|
|
|
|
GROUPID |
GROUPID |
char(20) |
20 |
|
|
|
|
|
ISAUTORETURN |
ISAUTORETURN |
char(1) |
1 |
|
|
|
|
|
ISCONTROLLED |
ISCONTROLLED |
char(1) |
1 |
|
|
|
|
|
MEMO |
MEMO |
varchar(100) |
100 |
|
|
|
|
|
NETBANKFLAG |
NETBANKFLAG |
int |
|
|
|
|
|
|
NETQUERYFLAG |
NETQUERYFLAG |
int |
|
|
|
|
|
|
ORGNUMBER |
ORGNUMBER |
varchar(80) |
80 |
|
|
|
|
|
PK_ACCBANK |
PK_ACCBANK |
char(20) |
20 |
|
是 |
|
是 |
|
PK_ACCID |
PK_ACCID |
char(20) |
20 |
|
|
|
|
|
PK_CORP |
PK_CORP |
char(4) |
4 |
|
|
|
|
|
PK_CREATEUNIT |
PK_CREATEUNIT |
char(20) |
20 |
|
|
|
|
|
PK_CURRTYPE |
PK_CURRTYPE |
char(20) |
20 |
|
|
|
|
|
PK_SETTLECENT |
PK_SETTLECENT |
char(20) |
20 |
|
|
|
|
|
PK_SETTLEUNIT |
PK_SETTLEUNIT |
char(20) |
20 |
|
|
|
|
|
PROVINCE |
PROVINCE |
varchar(80) |
80 |
|
|
|
|
|
REMCODE |
REMCODE |
varchar(50) |
50 |
|
|
|
|
|
SEALFLAG |
SEALFLAG |
char(1) |
1 |
|
|
|
|
|
SIGNFLAG |
SIGNFLAG |
char(1) |
1 |
|
|
|
|
|
TEL |
TEL |
varchar(30) |
30 |
|
|
|
|
|
UNITNAME |
UNITNAME |
varchar(100) |
100 |
|
|
|
|