account_moving.txt

企业端数据申报系统：单位管理模块 单位查询. 业务申报模块 在线数据下载 在线数据上传 在线业务申核 申报业务查询 磁盘数据导出 磁盘数据导入 在线业务模块 在线业务

create table Account_Moving(
opseno numeric(13),
psseno numeric(8) not null,
psname varchar(20),
iscode varchar(20),
sjjf  varchar(20),
stjf  varchar(20),
out_unit varchar(60),
in_unit varchar(60),
deaddate varchar(20),
yjfgzjs numeric(10,2),
out_esiis varchar(60),
out_account_name varchar(60),
out_zip varchar(10),
out_account varchar(30),
out_address varchar(60),
in_esiis varchar(60),
in_account_name varchar(60),
in_zip varchar(10),
in_account varchar(30),
in_address varchar(60),
account_1 numeric(10,2),
account_2 numeric(10,2),
account_3 numeric(6,4),
account_4 numeric(10,2),
account_5 numeric(10,2),
account_6 numeric(10,2),
account_7 numeric(10,2),
account_8 numeric(10,2),
account_9 numeric(10,2),
memo varchar(100),
Account_Setup varchar(10),
opcode   varchar(30) not null,
opdate datetime not null,
procflg char(1),
ckcode  varchar(10),
ckdate  datetime,
notpassnotes varchar(500));
create index idx_Account_Moving on Account_Moving(psseno);

sbdb_rtarch追加一个字段dapay numeric(13,2),加在最后,允许为空,表示2003年12月31日按行业单位过度内计发计算的基本养老金

//20040804 异地转入接续
create table sbdz_InEsiis(
opseno numeric(13),
psseno numeric(8) not null,
cpseno numeric(8) not null,
iscode varchar(18),
agcardno char(8),
psname  varchar(10),
sex    char(1),
bdate  datetime,
household char(1),
wkattr char(1),
identity char(1),
pflg char(1),
wkdate datetime,
joindate datetime,
bfidyears numeric(4,2),
bfrpyears numeric(4,2),
status char(1),
pskind char(1),
notes varchar(200),
dept varchar(40),
nacode char(2),
bgjfdate datetime,
months integer,
psdate datetime,
address varchar(80),
tel varchar(15),
zip varchar(6),
indate datetime,
tot numeric(13,2),
cymonths numeric(2),
ly     numeric(13,2),
lyps   numeric(13,2),
lycp   numeric(13,2),
t2tot  numeric(13,2),
t2ps   numeric(13,2),
t2cp   numeric(13,2),
rewage numeric(13,2),
lyrewage numeric(13,2),
upflag char(1)  not null,
opcode char(30) not null,
opdate datetime not null,
procflg char(1),
ckcode  varchar(10),
ckdate datetime,
notpassnotes varchar(500) );

create index idx_InEsiis on sbdz_InEsiis(psseno);

//20040810 并规办法计发养老金,待上传的表

create table sbdz_rtwage(
opseno numeric(13),
psseno numeric(8) not null,
psname varchar(10),
iscode varchar(18),
stjf   numeric(5,2),
pyitem77 numeric(13,2),
pyitem78 numeric(13,2),
pyitem79 numeric(13,2),
opcode   varchar(30) not null,
opdate datetime not null,
procflg char(1),
ckcode  varchar(10),
ckdate  datetime,
notpassnotes varchar(500));

create index idx_sbdz_rtwage on sbdz_rtwage(psseno);

//account_moving里增加了审核字段,opseno,删除以前的表,重新运行脚本.
//sbdb_psarch psdate字段为字符窜!以前的为datetime,应为varchar(200)