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

布满荆棘的人生 2021-11-29 08:08 234阅读 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, --数量