

CREATE TABLE REC_LOAN_LAST."biz_hxdata_correct_accrual_info" (
	"id" VARCHAR(64) NOT NULL,
	"duebill_no" VARCHAR(32),
	"jtlx" DEC,
	"jtfx" DEC,
	"term_type" VARCHAR(4),
	"data_type" VARCHAR(4),
	"create_date" DATE,
	"create_time" TIMESTAMP,
	"update_date" DATE,
	"update_time" TIMESTAMP,
	CONSTRAINT "biz_hxdata_correct_accrual_info" PRIMARY KEY ("id")
);
CREATE UNIQUE INDEX INDEX33565950 ON REC_LOAN_LAST."biz_hxdata_correct_accrual_info" ("id");
CREATE INDEX "index_biz_hxdata_correct_accrual_info_duebiull_no" ON REC_LOAN_LAST."biz_hxdata_correct_accrual_info" ("duebill_no");
COMMENT ON TABLE biz_hxdata_correct_accrual_info IS '校正核心计提文件表';
COMMENT ON COLUMN biz_hxdata_correct_accrual_info.duebill_no IS '借据号';
COMMENT ON COLUMN biz_hxdata_correct_accrual_info.jtlx IS '计提利息';
COMMENT ON COLUMN biz_hxdata_correct_accrual_info.jtfx IS '计提罚息';
COMMENT ON COLUMN biz_hxdata_correct_accrual_info.term_type IS '期数信息，1：短期，2：中长期';
COMMENT ON COLUMN biz_hxdata_correct_accrual_info.data_type IS '修正类型：1：新增，2：修改';



CREATE TABLE REC_LOAN_LAST."biz_hxdata_correct_repay_info" (
	"id" VARCHAR(64) NOT NULL,
	"duebill_no" VARCHAR(32),
	"repay_normal_bj" DEC,
	"repay_over_bj" DEC,
	"repay_interest" DEC,
	"repay_penalty_inte" DEC,
	"term_type" VARCHAR(4),
	"data_type" VARCHAR(4),
	"create_date" DATE,
	"create_time" TIMESTAMP,
	"update_date" DATE,
	"update_time" TIMESTAMP,
	CONSTRAINT "biz_hxdata_correct_repay_info" PRIMARY KEY ("id")
);
CREATE UNIQUE INDEX INDEX33565951 ON REC_LOAN_LAST."biz_hxdata_correct_repay_info" ("id");
CREATE INDEX "index_biz_hxdata_correct_repay_info_duebiull_no" ON REC_LOAN_LAST."biz_hxdata_correct_repay_info" ("duebill_no");

COMMENT ON TABLE biz_hxdata_correct_repay_info IS '校正核心还款明细文件表';
COMMENT ON COLUMN biz_hxdata_correct_repay_info.duebill_no IS '借据号';
COMMENT ON COLUMN biz_hxdata_correct_repay_info.repay_normal_bj IS '实还正常本金';
COMMENT ON COLUMN biz_hxdata_correct_repay_info.repay_over_bj IS '实还逾期本金';
COMMENT ON COLUMN biz_hxdata_correct_repay_info.repay_interest IS '实还利息';
COMMENT ON COLUMN biz_hxdata_correct_repay_info.repay_penalty_inte IS '实还罚息';
COMMENT ON COLUMN biz_hxdata_correct_repay_info.term_type IS '期数信息，1：短期，2：中长期';
COMMENT ON COLUMN biz_hxdata_correct_repay_info.data_type IS '修正类型：1：新增，2：修改';



insert into  biz_hxdata_correct_repay_info (id,duebill_no,repay_normal_bj,repay_over_bj,repay_interest,repay_penalty_inte,data_type,term_type) values ( 1,	'MS202303060000000177', -11.39,0,0,0,2,1);
insert into  biz_hxdata_correct_repay_info (id,duebill_no,repay_normal_bj,repay_over_bj,repay_interest,repay_penalty_inte,data_type,term_type) values ( 2,	'MS202303230000000061', -832.21,0,0,0,2,1);
insert into  biz_hxdata_correct_repay_info (id,duebill_no,repay_normal_bj,repay_over_bj,repay_interest,repay_penalty_inte,data_type,term_type) values ( 3,	'MS202303230000000103', -371.53,0,0,0,2,1);
insert into  biz_hxdata_correct_repay_info (id,duebill_no,repay_normal_bj,repay_over_bj,repay_interest,repay_penalty_inte,data_type,term_type) values ( 4,	'MS202303260000000251', -1290.97,0,0,0,2,1);
insert into  biz_hxdata_correct_repay_info (id,duebill_no,repay_normal_bj,repay_over_bj,repay_interest,repay_penalty_inte,data_type,term_type) values ( 5,	'MS202303270000000161', -56.8,0,0,0,2,1);
insert into  biz_hxdata_correct_repay_info (id,duebill_no,repay_normal_bj,repay_over_bj,repay_interest,repay_penalty_inte,data_type,term_type) values ( 6,	'MS202303280000000225', -567.99,0,0,0,2,1);
insert into  biz_hxdata_correct_repay_info (id,duebill_no,repay_normal_bj,repay_over_bj,repay_interest,repay_penalty_inte,data_type,term_type) values ( 7,	'MS202304010000000373', -494.15,0,0,0,2,1);
insert into  biz_hxdata_correct_repay_info (id,duebill_no,repay_normal_bj,repay_over_bj,repay_interest,repay_penalty_inte,data_type,term_type) values ( 8,	'MS202304020000000385', -255.43,0,0,0,2,1);
insert into  biz_hxdata_correct_repay_info (id,duebill_no,repay_normal_bj,repay_over_bj,repay_interest,repay_penalty_inte,data_type,term_type) values ( 9,	'MS202304030000000569', -193.12,0,0,0,2,1);
insert into  biz_hxdata_correct_repay_info (id,duebill_no,repay_normal_bj,repay_over_bj,repay_interest,repay_penalty_inte,data_type,term_type) values ( 10,	'MS202304050000000104', -840.62,0,0,0,2,1);
insert into  biz_hxdata_correct_repay_info (id,duebill_no,repay_normal_bj,repay_over_bj,repay_interest,repay_penalty_inte,data_type,term_type) values ( 11,	'MS202304070000000608', -507.17,0,0,0,2,1);
insert into  biz_hxdata_correct_repay_info (id,duebill_no,repay_normal_bj,repay_over_bj,repay_interest,repay_penalty_inte,data_type,term_type) values ( 12,	'MS202304140000000160', -28.4,0,0,0,2,1);
