oracle存储过程旬频度的数据抽取实例

最新推荐文章于 2023-11-14 11:33:41 发布

知而无涯

最新推荐文章于 2023-11-14 11:33:41 发布

阅读量812

点赞数

分类专栏： Oracle数据库文章标签： oracle数据库数据抽取

本文链接：https://blog.csdn.net/qq_26963433/article/details/96742992

版权

Oracle数据库专栏收录该内容

41 篇文章 0 订阅

订阅专栏

一:创建表

-- Create table
create table SRPT_ZZB
(
jrjgdm VARCHAR2(30),
nbjgh VARCHAR2(30),
jgmc VARCHAR2(200),
kmbh VARCHAR2(60),
kmmc VARCHAR2(200),
kmjc NUMBER(2),
kmlx NUMBER(2),
ncjfye NUMBER(38,2),
ncdfye NUMBER(38,2),
qcjfye NUMBER(38,2),
qcdfye NUMBER(38,2),
bqjffse NUMBER(38,2),
bqdffse NUMBER(38,2),
qmjfye NUMBER(38,2),
qmdfye NUMBER(38,2),
jffse_by NUMBER(38,2),
dffse_by NUMBER(38,2),
jffse_bj NUMBER(38,2),
dffse_bj NUMBER(38,2),
jffse_bn NUMBER(38,2),
dffse_bn NUMBER(38,2),
bz VARCHAR2(3),
dqdm VARCHAR2(30),
rq VARCHAR2(8),
autoid VARCHAR2(32 CHAR)
)
tablespace ZKBBPT_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64M
next 1M
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table SRPT_ZZB
is '总账表';
-- Add comments to the columns
comment on column SRPT_ZZB.jrjgdm
is '金融机构代码';
comment on column SRPT_ZZB.nbjgh
is '内部机构号';
comment on column SRPT_ZZB.jgmc
is '机构名称';
comment on column SRPT_ZZB.kmbh
is '科目编号';
comment on column SRPT_ZZB.kmmc
is '科目名称';
comment on column SRPT_ZZB.kmjc
is '科目级次';
comment on column SRPT_ZZB.kmlx
is '科目类型';
comment on column SRPT_ZZB.ncjfye
is '年初借方余额';
comment on column SRPT_ZZB.ncdfye
is '年初贷方余额';
comment on column SRPT_ZZB.qcjfye
is '期初借方余额';
comment on column SRPT_ZZB.qcdfye
is '期初贷方余额';
comment on column SRPT_ZZB.bqjffse
is '本期借方发生额';
comment on column SRPT_ZZB.bqdffse
is '本期贷方发生额';
comment on column SRPT_ZZB.qmjfye
is '期末借方余额';
comment on column SRPT_ZZB.qmdfye
is '期末贷方余额';
comment on column SRPT_ZZB.jffse_by
is '借方发生额_本月';
comment on column SRPT_ZZB.dffse_by
is '贷方发生额_本月';
comment on column SRPT_ZZB.jffse_bj
is '借方发生额_本季';
comment on column SRPT_ZZB.dffse_bj
is '贷方发生额_本季';
comment on column SRPT_ZZB.jffse_bn
is '借方发生额_本年';
comment on column SRPT_ZZB.dffse_bn
is '贷方发生额_本年';
comment on column SRPT_ZZB.bz
is '币种';
comment on column SRPT_ZZB.dqdm
is '地区代码';
comment on column SRPT_ZZB.rq
is '日期';
二:插入测试数据

prompt Importing table srpt_zzb...
set feedback off
set define off
insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '201203', '通知存款', 2, null, 0.00, 5500000.00, null, null, 0.00, 0.00, 0.00, 4500000.00, 3500000.00, 2000000.00, 6000000.00, 2000000.00, 6500000.00, 5500000.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '20120301', '一天通知', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '20120302', '七天通知', 3, null, 0.00, 5500000.00, null, null, 0.00, 0.00, 0.00, 4500000.00, 3500000.00, 2000000.00, 6000000.00, 2000000.00, 6500000.00, 5500000.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '2021', '贴现负债', 1, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '202101', '转贴现', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '20210101', '面值', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '611106', '应收款项类投资', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660238', '会务费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '602109', '智能存款服务费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '10110211', '江苏银行', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '400102', '深圳赤湾港航股份有限公司', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '400103', '深圳赤湾石油基地股份有限公司', 2, null, 0.00, 100000000.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 100000000.00, 0.00, 100000000.00, 0.00, 100000000.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '400104', '雅致集成房屋股份有限公司', 2, null, 0.00, 100000000.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 100000000.00, 0.00, 100000000.00, 0.00, 100000000.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '4002', '资本公积', 1, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '400201', '资本溢价', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66021904', '工作服', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 43249.00, 0.00, 0.00, 0.00, 43249.00, 0.00, 43249.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660240', '招聘费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66021101', '办公维修费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 7142.45, 0.00, 283.94, 0.00, 1404.63, 0.00, 7142.45, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66021102', '软件维护费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 63295.62, 0.00, 161.08, 0.00, 161.08, 0.00, 46314.49, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66021103', '硬件维修费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 126213.73, 0.00, 29940.48, 0.00, 64602.74, 0.00, 126213.73, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '10110115', '邮储银行', 3, null, 1.02, 0.00, null, null, 0.00, 0.00, 2.02, 0.00, 0.00, 0.00, 1.00, 0.00, 1.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1011011501', '结算户', 4, null, 1.02, 0.00, null, null, 0.00, 0.00, 2.02, 0.00, 0.00, 0.00, 1.00, 0.00, 1.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '10110215', '邮储银行', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '10110315', '邮储银行', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '10110415', '邮储银行', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022404', '网络费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 164444.49, 0.00, 26618.56, 0.00, 77738.56, 0.00, 164444.49, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '13030103', '固定资产贷款', 3, null, 100000000.00, 0.00, null, null, 0.00, 0.00, 99000000.00, 0.00, 0.00, 1000000.00, 0.00, 1000000.00, 0.00, 1000000.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110103', '固定资产贷款', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60113351', '固定资产贷款-价', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110153', '固定资产贷款-价', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 2489622.63, 0.00, 424056.60, 0.00, 1258490.56, 0.00, 2489622.63, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110251', '流动资金贷款-价', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 15392875.42, 0.00, 4285829.41, 0.00, 8651821.28, 0.00, 15392875.42, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '222107020304', '手续费', 5, null, 0.00, 0.01, null, null, 0.00, 0.00, 0.00, 0.01, 138.19, 138.19, 138.19, 138.19, 216.91, 216.91, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '222107020305', '企业刊物费', 5, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 250.57, 250.57, 250.57, 250.57, 250.57, 250.57, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '15030412', '兴业银行', 3, null, 99520537.67, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 695900.00, 100000000.00, 695900.00, 100000000.00, 101483600.00, 201004137.67, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '15030414', '北京银行', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '15030415', '邮储银行', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '15030417', '上海银行', 3, null, 199509041.30, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 708700.00, 100000000.00, 708700.00, 100000000.00, 102288300.00, 301797341.30, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '222107010412', '会务费', 5, null, 0.00, 684.91, null, null, 0.00, 0.00, 0.00, 684.91, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040101', '成本', 4, null, 100000000.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 100000000.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040102', '利息调整', 4, null, 0.00, 1594700.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 1594700.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040103', '应计利息', 4, null, 657158.68, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 657158.68, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040104', '公允价值变动', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040201', '成本', 4, null, 100000000.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 100000000.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '6011010201', '代理银团贷款', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '6011010202', '非代理银团贷款', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '601102', '中长期贷款', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 55616190.02, 0.00, 11681109.09, 0.00, 30631315.17, 0.00, 55616190.02, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110201', '流动资金贷款', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110202', '固定资产贷款', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 40223314.60, 0.00, 7395279.68, 0.00, 21979493.89, 0.00, 40223314.60, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '6011020201', '一般固定资产贷款', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '6011020202', '项目贷款', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110203', '银团贷款', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '6011020301', '代理银团贷款', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '6011020302', '非代理银团贷款', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '601103', '保理融资', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '601104', '存放同业', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 11390428.67, 0.00, 6395319.36, 0.00, 6395319.36, 0.00, 11390428.67, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110401', '活期存款', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 11390428.67, 0.00, 6395319.36, 0.00, 6395319.36, 0.00, 11390428.67, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110402', '定期存款', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110403', '通知存款', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110404', '协议存款', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '601105', '拆出资金', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '601106', '贴现资产', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110601', '银行承兑汇票', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110602', '商业承兑汇票', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660219', '办公费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 105022.63, 0.00, 4128.23, 0.00, 63249.61, 0.00, 105619.73, 280.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66021901', '办公用品费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 35657.13, 0.00, 4128.23, 0.00, 20000.61, 0.00, 36254.23, 280.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66021902', '书报资料费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1306020201', '一般固定资产贷款', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66021903', '印刷费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1306020202', '项目贷款', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66021999', '其他', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 26116.50, 0.00, 0.00, 0.00, 0.00, 0.00, 26116.50, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660220', '房水电费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 1088470.69, 0.00, 193612.37, 0.00, 610240.24, 0.00, 1088470.69, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022001', '房租', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 820446.99, 0.00, 151318.85, 0.00, 445039.18, 0.00, 820446.99, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022002', '水费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 9513.22, 0.00, 1092.90, 0.00, 1291.13, 0.00, 9513.22, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022003', '电费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 36107.39, 0.00, 4837.49, 0.00, 35570.57, 0.00, 36107.39, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022004', '管理费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 222403.09, 0.00, 36363.13, 0.00, 128339.36, 0.00, 222403.09, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660221', '汽车费用', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 95262.74, 0.00, 20424.59, 0.00, 55703.91, 0.00, 95722.74, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '13060203', '银团贷款', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022101', '燃润料费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 40336.77, 0.00, 1147.00, 0.00, 20506.82, 0.00, 40336.77, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022102', '修理费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 21743.00, 0.00, 8062.00, 0.00, 10326.00, 0.00, 21743.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022103', '保险费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 4813.54, 0.00, 4813.54, 0.00, 4813.54, 0.00, 4813.54, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022104', '停车过桥洗车费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 23341.56, 0.00, 3476.56, 0.00, 16371.56, 0.00, 23801.56, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022199', '其他', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 5027.87, 0.00, 2925.49, 0.00, 3685.99, 0.00, 5027.87, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660222', '业务招待费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 101475.55, 0.00, 24718.00, 0.00, 42412.99, 0.00, 101020.55, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660223', '差旅费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 52725.60, 0.00, 12604.11, 0.00, 38096.34, 0.00, 52725.60, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660224', '邮电通讯费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 180774.82, 0.00, 27783.54, 0.00, 84000.06, 0.00, 181460.82, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022401', '手机费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 1500.00, 0.00, 0.00, 0.00, 0.00, 0.00, 1500.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022402', '电话费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 7706.83, 0.00, 0.00, 0.00, 2598.50, 0.00, 7706.83, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1306020301', '代理银团贷款', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022403', '邮递费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 7123.50, 0.00, 1164.98, 0.00, 3663.00, 0.00, 7809.50, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660225', '口岸费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1306020302', '非代理银团贷款', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660226', '顾问咨询费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 307573.92, 0.00, 2880.18, 0.00, 306502.81, 0.00, 307573.92, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660227', '广告宣传展览费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '130603', '保理融资', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022701', '广告费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66022702', '宣传展览费', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660228', '股证事务费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1307', '贸易融资', 1, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660229', '协会费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 150000.00, 0.00, 0.00, 0.00, 0.00, 0.00, 150000.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660230', '董事费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '130701', '国内贸易融资', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '60110151', '流动资金贷款-价', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 19322637.69, 0.00, 1798955.86, 0.00, 8894603.79, 0.00, 19322637.69, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '6011020251', '一般固贷资产贷款-价', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 33217649.38, 0.00, 5773590.41, 0.00, 16764182.50, 0.00, 33217649.38, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '602152', '委托贷款手续费-价', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 65377.36, 0.00, 5283.02, 0.00, 6509.44, 0.00, 65377.36, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '602155', '担保手续费-价', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 606.04, 0.00, 0.00, 0.00, 606.04, 0.00, 606.04, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '611151', '交易性金融资产-价', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '611156', '应收款项类投资-价', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '222107030103', '流贷利息应交增值税-预提税额', 5, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, -82232.52, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '222107030104', '固贷利息应交增值税-预提税额', 5, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, -428385.41, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '6421', '手续费及佣金支出', 1, null, 0.00, 0.00, null, null, 0.00, 0.00, 379646.95, 0.00, 137478.03, 0.00, 70674.44, 0.00, 379740.11, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '642101', '结算手续费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 378397.95, 0.00, 137427.03, 0.00, 70532.44, 0.00, 378491.11, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '642102', '担保手续费', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '642108', '佣金支出', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1305020201', '一般固定资产贷款', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '642199', '其他', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 1249.00, 0.00, 51.00, 0.00, 142.00, 0.00, 1249.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1305020202', '项目贷款', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '6602', '业务及管理费', 1, null, 0.00, 0.00, null, null, 0.00, 0.00, 12807051.04, 0.00, 4613974.22, 0.00, 7537647.51, 0.00, 12386534.81, 280.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '660201', '工资及奖金', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 8343321.31, 0.00, 3906321.74, 0.00, 5210899.64, 0.00, 7943434.11, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66020101', '基本工资', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 2817709.86, 0.00, 398892.00, 0.00, 1215676.79, 0.00, 2822726.26, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66020102', '岗位工资', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '13050203', '银团贷款', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66020103', '效益工资', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66020104', '加班工资', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 28015.11, 0.00, 1700.14, 0.00, 5100.42, 0.00, 28015.11, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '66020105', '双薪', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040202', '利息调整', 4, null, 0.00, 1618800.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 1618800.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040203', '应计利息', 4, null, 667105.40, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 667105.40, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040204', '公允价值变动', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040301', '成本', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040302', '利息调整', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040303', '应计利息', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040304', '公允价值变动', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040401', '成本', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 100000000.00, 100000000.00, 100000000.00, 100000000.00, 100000000.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040402', '利息调整', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 748500.00, 0.00, 748500.00, 748500.00, 748500.00, 748500.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040403', '应计利息', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040404', '公允价值变动', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040501', '成本', 4, null, 300000000.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 100000000.00, 100000000.00, 100000000.00, 100000000.00, 400000000.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040502', '利息调整', 4, null, 0.00, 2770074.59, null, null, 0.00, 0.00, 0.00, 0.00, 748500.00, 0.00, 748500.00, 748500.00, 3518574.59, 748500.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040503', '应计利息', 4, null, 974715.89, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 974715.89, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040504', '公允价值变动', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040601', '成本', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040602', '利息调整', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040603', '应计利息', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040604', '公允价值变动', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040701', '成本', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040702', '利息调整', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040703', '应计利息', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040704', '公允价值变动', 4, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040801', '成本', 4, null, 100000000.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 100000000.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040802', '利息调整', 4, null, 0.00, 793200.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 793200.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '1503040803', '应计利息', 4, null, 454448.68, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 454448.68, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '222107010606', '网络费', 5, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 45.44, 45.44, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '671102', '非流动资产处置损失', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '630110', '违约金收入', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '630199', '其它收入', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 6000.00, 0.00, 6000.00, 0.00, 6000.00, 0.00, 6000.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '6402', '其他业务成本', 1, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '6403', '税金及附加', 1, null, 0.00, 0.00, null, null, 0.00, 0.00, 721295.69, 0.00, 345493.77, 0.00, 350857.26, 0.00, 721295.69, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '13050102', '银团贷款', 3, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '640301', '营业税', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 'CNY', null, '20190630', null);

insert into srpt_zzb (JRJGDM, NBJGH, JGMC, KMBH, KMMC, KMJC, KMLX, NCJFYE, NCDFYE, QCJFYE, QCDFYE, BQJFFSE, BQDFFSE, QMJFYE, QMDFYE, JFFSE_BY, DFFSE_BY, JFFSE_BJ, DFFSE_BJ, JFFSE_BN, DFFSE_BN, BZ, DQDM, RQ, AUTOID)
values ('001', 'ck0g4403000', '中开财务有限责任公司', '640302', '城市维护建设税', 2, null, 0.00, 0.00, null, null, 0.00, 0.00, 348068.81, 0.00, 196787.54, 0.00, 196787.53, 0.00, 348068.81, 0.00, 'CNY', null, '20190630', null);

prompt Done.

三:SQL语句编写

insert into srpt_tybsb(NBJGH, KMBH, BZ, RQ, BBMC, ZBH, ZBL, SL, JE)

select

'ck0g4403000' as NBJGH,

2012 as KMBH, --科目编号

'BWB' AS BZ, --币种

RDTDATE AS RQ, --日期

'G2200' AS BBMC, --报表名称

'5' AS ZBH, --行号

'C' AS ZBL, --列号

0 AS SL, --数量

case when substr(RDTDATE,7,2)>=1 and substr(RDTDATE,7,2)<=4

then

(select nvl(avg(qmdfye)*0.06,0) from SRPT_ZZB where BZ = 'CNY' and KMBH= '2012' AND -- 1-4的应交存准金 5.11-5.20吸收存款（2012）平均余额*6% 上月中旬

RQ>=to_char(add_months (trunc(to_date(RDTDATE,'yyyymmdd')),-1),'yyyymm')　||'11' and

RQ<=to_char(add_months (trunc(to_date(RDTDATE,'yyyymmdd')),-1),'yyyymm')　||'20' )

when substr(RDTDATE,7,2)>=5 and substr(RDTDATE,7,2)<=14 then ---5-14的应交存准金 5.21-5.31吸收存款（2012）平均余额*6% 上月下旬

(select nvl(avg(qmdfye)*0.06,0) from SRPT_ZZB where BZ = 'CNY' and KMBH= '2012' AND

RQ>=to_char(add_months (trunc(to_date(RDTDATE,'yyyymmdd')),-1),'yyyymm')　||'21' and

RQ<=to_char(add_months (trunc(to_date(RDTDATE,'yyyymmdd')),-1),'yyyymm')　||'31')

when substr(RDTDATE,7,2)>=15 and substr(RDTDATE,7,2)<=24 then -- 15-24的应交存准金 6.1-6.10吸收存款（2012）平均余额*6% 本月上旬

(select nvl(avg(qmdfye)*0.06,0) from SRPT_ZZB where BZ = 'CNY' and KMBH= '2012' AND

RQ>=to_char((trunc(to_date(RDTDATE,'yyyymmdd'))),'yyyymm') ||'01' and

RQ<=to_char((trunc(to_date(RDTDATE,'yyyymmdd'))),'yyyymm') ||'10')

when substr(RDTDATE,7,2)>=25 and -- 25-4的应交存准金 6.11-6.20吸收存款（2012）平均余额*6% 本月中旬

substr(RDTDATE,7,2)<=substr(to_char(last_day(to_date(to_char(trunc(to_date(RDTDATE,'yyyymmdd')),'yyyymmdd'),'yyyymmdd')), 'yyyymmdd'),7,2)

then (select nvl(avg(qmdfye)*0.06,0) from SRPT_ZZB where BZ = 'CNY' and KMBH= '2012' AND

RQ>=to_char((trunc(to_date(RDTDATE,'yyyymmdd'))),'yyyymm') ||'11' and

RQ<=to_char((trunc(to_date(RDTDATE,'yyyymmdd'))),'yyyymm') ||'20')

end

as je from dual;

知而无涯

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
oracle存储过程旬频度的数据抽取实例

一:创建表-- Create tablecreate table SRPT_ZZB( jrjgdm VARCHAR2(30), nbjgh VARCHAR2(30), jgmc VARCHAR2(200), kmbh VARCHAR2(60), kmmc VARCHAR2(200), kmjc NUMBER(2), kml...
复制链接

扫一扫

专栏目录