fbm_cubasdoc - 票据客商基本档案
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | bp1 | BP1 | VARCHAR | | 30 | 0 | | | | |
bp2 | BP2 | VARCHAR | | 30 | 0 | | | | |
bp3 | BP3 | VARCHAR | | 30 | 0 | | | | |
conaddr | CONADDR | VARCHAR | | 60 | 0 | | | | |
correspondunit | CORRESPONDUNIT | VARCHAR | | 20 | 0 | | | | |
creditmny | CREDITMNY | DECIMAL | | 20 | 8 | | | | |
custcode | CUSTCODE | VARCHAR | | 40 | 0 | | | | |
custname | CUSTNAME | VARCHAR | | 200 | 0 | | | | |
custprop | CUSTPROP | INT | | 4 | 0 | | | | |
custshortname | CUSTSHORTNAME | VARCHAR | | 200 | 0 | | | | |
def1 | DEF1 | VARCHAR | | 100 | 0 | | | | |
def10 | DEF10 | VARCHAR | | 100 | 0 | | | | |
def11 | DEF11 | VARCHAR | | 100 | 0 | | | | |
def12 | DEF12 | VARCHAR | | 100 | 0 | | | | |
def13 | DEF13 | VARCHAR | | 100 | 0 | | | | |
def14 | DEF14 | VARCHAR | | 100 | 0 | | | | |
def15 | DEF15 | VARCHAR | | 100 | 0 | | | | |
def16 | DEF16 | VARCHAR | | 100 | 0 | | | | |
def17 | DEF17 | VARCHAR | | 100 | 0 | | | | |
def18 | DEF18 | VARCHAR | | 100 | 0 | | | | |
def19 | DEF19 | VARCHAR | | 100 | 0 | | | | |
def2 | DEF2 | VARCHAR | | 100 | 0 | | | | |
def20 | DEF20 | VARCHAR | | 100 | 0 | | | | |
def3 | DEF3 | VARCHAR | | 100 | 0 | | | | |
def4 | DEF4 | VARCHAR | | 100 | 0 | | | | |
def5 | DEF5 | VARCHAR | | 100 | 0 | | | | |
def6 | DEF6 | VARCHAR | | 100 | 0 | | | | |
def7 | DEF7 | VARCHAR | | 100 | 0 | | | | |
def8 | DEF8 | VARCHAR | | 100 | 0 | | | | |
def9 | DEF9 | VARCHAR | | 100 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
drpnodeflag | DRPNODEFLAG | CHAR | | 1 | 0 | | | | |
ecotypesincevfive | ECOTYPESINCEVFIVE | CHAR | | 20 | 0 | | | | |
email | EMAIL | VARCHAR | | 50 | 0 | | | | |
engname | ENGNAME | VARCHAR | | 60 | 0 | | | | |
fax1 | FAX1 | VARCHAR | | 30 | 0 | | | | |
fax2 | FAX2 | VARCHAR | | 30 | 0 | | | | |
freecustflag | FREECUSTFLAG | CHAR | | 1 | 0 | | | | |
isconnflag | ISCONNFLAG | CHAR | | 1 | 0 | | | | |
legalbody | LEGALBODY | VARCHAR | | 16 | 0 | | | | |
linkman1 | LINKMAN1 | VARCHAR | | 25 | 0 | | | | |
linkman2 | LINKMAN2 | VARCHAR | | 25 | 0 | | | | |
linkman3 | LINKMAN3 | VARCHAR | | 25 | 0 | | | | |
memo | MEMO | VARCHAR | | 100 | 0 | | | | |
mnecode | MNECODE | VARCHAR | | 50 | 0 | | | | |
mobilephone1 | MOBILEPHONE1 | VARCHAR | | 30 | 0 | | | | |
mobilephone2 | MOBILEPHONE2 | VARCHAR | | 30 | 0 | | | | |
mobilephone3 | MOBILEPHONE3 | VARCHAR | | 30 | 0 | | | | |
phone1 | PHONE1 | VARCHAR | | 30 | 0 | | | | |
phone2 | PHONE2 | VARCHAR | | 30 | 0 | | | | |
phone3 | PHONE3 | VARCHAR | | 30 | 0 | | | | |
pk_areacl | PK_AREACL | CHAR | | 20 | 0 | | | | |
pk_corp | PK_CORP | CHAR | | 20 | 0 | | | | |
pk_corp1 | PK_CORP1 | CHAR | | 20 | 0 | | | | |
pk_cubasdoc | PK_CUBASDOC | CHAR | | 20 | 0 | | | | |
pk_cubasdoc1 | PK_CUBASDOC1 | CHAR | | 20 | 0 | | | | |
pk_pricegroup | PK_PRICEGROUP | CHAR | | 20 | 0 | | | | |
registerfund | REGISTERFUND | DECIMAL | | 20 | 8 | | | | |
saleaddr | SALEADDR | VARCHAR | | 60 | 0 | | | | |
sealflag | SEALFLAG | CHAR | | 10 | 0 | | | | |
taxpayerid | TAXPAYERID | CHAR | | 20 | 0 | | | | |
trade | TRADE | CHAR | | 20 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
url | URL | VARCHAR | | 60 | 0 | | | | |
zipcode | ZIPCODE | CHAR | | 6 | 0 | | | | |
外键列表
索引列表