atio
alitypho
e
home_pho
eoffice_pho
e1
office_pho
e2
zo
eoffice_faxmobil_pho
e
emailpost_code
cou
tryprovi
ce
cityhome_addroffice_addrcert_
umbercert_
ameoccupatio
_id
occupatio
educatio

date
umber52
umber52
varchar220varchar250varchar250varchar250
varchar250
varchar220varchar250varchar250varchar250varchar220varchar250varchar220varchar220varchar280varchar280varchar250varchar220
char4
varchar250varchar220
smalldatetimedec52
dec52
varchar20varchar50varchar50varchar50
varchar50
varchar20varchar50varchar50varchar50varchar20varchar50varchar20varchar20varchar80varchar80varchar50varchar20
char4
varchar50varchar20
单位为厘米
单位为公斤
要填满长度
93铺助信息常用字段
字段名称字段代码
记录状态
flag
标识
记录序号
id
ORACLESQLSERVER
char1
char1

umber
i
t
值AD…
说明
A有效；D：删除；S：暂停…
94业务信息常用字段
字段名称字段代码
ORACLESQLSERVER
值
业务发生oper_date
date
smalldate
日期
开始日期begi
_date
date
smalldate
结束日期e
d_date
date
smalldate
操作日期curr_date
date
smalldate
说明
f操作员编号
user_id
char4
char4
发生额余额描述
mo
eybala
cedescriptio

umber72
umber102varchar250
dec72dec102varchar50
附件1：数据库类型简写
编号１２３４
数据库SYBASEORACLEDB2SQLSERVER
类型简写SYBORADB2SQL
即为系统信息中的用户标识
fr