
DELETE FROM T_ER_SETTING_GROUP WHERE FID = 1701499111456886784;
DELETE FROM T_ER_SETTING_GROUP_L WHERE FID = 1701499111456886784;
DELETE FROM T_ER_BILL_SETTING WHERE FID IN(1701500728260415488,1701513525207245824);
DELETE FROM T_ER_BILL_SETTING_L WHERE FID IN(1701500728260415488,1701513525207245824);
DELETE FROM T_ER_BILL_SETTING_ENTRY WHERE FID IN(1701500728260415488,1701513525207245824);
DELETE FROM T_ER_BILL_SETTING_ENTRY_L WHERE FENTRYID IN (1701500728679845888,1701500728679845889,1701513525282743296,1701513525282743297);

INSERT INTO T_ER_SETTING_GROUP(FID,FCREATORID,FMODIFIERID,FMODIFYTIME,FENABLE,FNAME,FCREATETIME,FNUMBER,FSTATUS,FMASTERID) VALUES (1701499111456886784,1,1,{ts'2023-06-06  00:00:00'},'1','还款单',{ts'2023-06-06  00:00:00'},'er_repaymentbill','C',1701499111456886784);

INSERT INTO T_ER_SETTING_GROUP_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1701499111456886784,'3B+PSXSY9=L5','zh_CN','还款单');
INSERT INTO T_ER_SETTING_GROUP_L(FID,FPKID,FLOCALEID,FNAME) VALUES (1701499111456886784,'3B+PSXSY9=L6','zh_TW','還款單');

INSERT INTO T_ER_BILL_SETTING(FID,FBITINDEX,FFORMTITLE,FREIMBURSETYPE,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FGROUPID,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID) VALUES (1701500728260415488,0,'退款单','prepayrefund',100000,0,1701500728260415488,100000,'C','5','prepayrefund','预付退款',1701499111456886784,{ts'2023-06-06  00:00:00'},0,1,'1',{ts'2023-06-06  00:00:00'},1);
INSERT INTO T_ER_BILL_SETTING(FID,FBITINDEX,FFORMTITLE,FREIMBURSETYPE,FCREATEORGID,FSOURCEDATAID,FMASTERID,FORGID,FSTATUS,FCTRLSTRATEGY,FNUMBER,FNAME,FGROUPID,FCREATETIME,FSOURCEBITINDEX,FMODIFIERID,FENABLE,FMODIFYTIME,FCREATORID) VALUES (1701513525207245824,0,'还款单','repayment',100000,0,1701513525207245824,100000,'C','5','repayment','个人还款',1701499111456886784,{ts'2023-06-06  00:00:00'},0,1,'1',{ts'2023-06-06  00:00:00'},1);

INSERT INTO T_ER_BILL_SETTING_L(FID,FFORMTITLE,FPKID,FLOCALEID,FNAME) VALUES (1701500728260415488,'退款单','3B+Q2P=T0W1T','zh_CN','预付退款');
INSERT INTO T_ER_BILL_SETTING_L(FID,FFORMTITLE,FPKID,FLOCALEID,FNAME) VALUES (1701500728260415488,'退款單','3B+Q2P=T0W1U','zh_TW','預付退款');
INSERT INTO T_ER_BILL_SETTING_L(FID,FFORMTITLE,FPKID,FLOCALEID,FNAME) VALUES (1701513525207245824,'还款单','3B+SGZ+ZRRH1','zh_CN','个人还款');
INSERT INTO T_ER_BILL_SETTING_L(FID,FFORMTITLE,FPKID,FLOCALEID,FNAME) VALUES (1701513525207245824,'還款單','3B+SGZ+ZRRH2','zh_TW','個人還款');

INSERT INTO T_ER_BILL_SETTING_ENTRY(FID,FLOCKCONDITIONJSON,FHIDDEN,FENTRYID,FMUSTINPUT,FFIELDTYPE,FLOCKCONDITIONJSON_TAG,FLOCKCONDITIONEXPR,FDIYNAME,FLOCK,FFIELDNUMBER,FLOCKCONDITION,FSEQ,FFIELDNAME,FLOCKCONDITIONEXPR_TAG) VALUES (1701500728260415488,' ','0',1701500728679845888,'0','field',' ',' ','往来类型','0','billpayertype',' ',1,'单据头.往来类型',' ');
INSERT INTO T_ER_BILL_SETTING_ENTRY(FID,FLOCKCONDITIONJSON,FHIDDEN,FENTRYID,FMUSTINPUT,FFIELDTYPE,FLOCKCONDITIONJSON_TAG,FLOCKCONDITIONEXPR,FDIYNAME,FLOCK,FFIELDNUMBER,FLOCKCONDITION,FSEQ,FFIELDNAME,FLOCKCONDITIONEXPR_TAG) VALUES (1701500728260415488,' ','0',1701500728679845889,'0','field',' ',' ','往来单位','0','billpayerid',' ',2,'单据头.往来单位',' ');
INSERT INTO T_ER_BILL_SETTING_ENTRY(FID,FLOCKCONDITIONJSON,FHIDDEN,FENTRYID,FMUSTINPUT,FFIELDTYPE,FLOCKCONDITIONJSON_TAG,FLOCKCONDITIONEXPR,FDIYNAME,FLOCK,FFIELDNUMBER,FLOCKCONDITION,FSEQ,FFIELDNAME,FLOCKCONDITIONEXPR_TAG) VALUES (1701513525207245824,' ','1',1701513525282743296,'0','field',' ',' ','往来类型','0','billpayertype',' ',1,'单据头.往来类型',' ');
INSERT INTO T_ER_BILL_SETTING_ENTRY(FID,FLOCKCONDITIONJSON,FHIDDEN,FENTRYID,FMUSTINPUT,FFIELDTYPE,FLOCKCONDITIONJSON_TAG,FLOCKCONDITIONEXPR,FDIYNAME,FLOCK,FFIELDNUMBER,FLOCKCONDITION,FSEQ,FFIELDNAME,FLOCKCONDITIONEXPR_TAG) VALUES (1701513525207245824,' ','1',1701513525282743297,'0','field',' ',' ','往来单位','0','billpayerid',' ',2,'单据头.往来单位',' ');

INSERT INTO T_ER_BILL_SETTING_ENTRY_L(FPKID,FLOCALEID,FENTRYID,FDIYNAME) VALUES ('3B+Q2P=T0W1V','zh_CN',1701500728679845888,'往来类型');
INSERT INTO T_ER_BILL_SETTING_ENTRY_L(FPKID,FLOCALEID,FENTRYID,FDIYNAME) VALUES ('3B+Q2P=T0W1W','zh_TW',1701500728679845888,'往來類型');
INSERT INTO T_ER_BILL_SETTING_ENTRY_L(FPKID,FLOCALEID,FENTRYID,FDIYNAME) VALUES ('3B+Q2P=T0W1X','zh_CN',1701500728679845889,'往来单位');
INSERT INTO T_ER_BILL_SETTING_ENTRY_L(FPKID,FLOCALEID,FENTRYID,FDIYNAME) VALUES ('3B+Q2P=T0W1Y','zh_TW',1701500728679845889,'往來單位');
INSERT INTO T_ER_BILL_SETTING_ENTRY_L(FPKID,FLOCALEID,FENTRYID,FDIYNAME) VALUES ('3B+SGZ+ZRRH3','zh_CN',1701513525282743296,'往来类型');
INSERT INTO T_ER_BILL_SETTING_ENTRY_L(FPKID,FLOCALEID,FENTRYID,FDIYNAME) VALUES ('3B+SGZ+ZRRH4','zh_TW',1701513525282743296,'往來類型');
INSERT INTO T_ER_BILL_SETTING_ENTRY_L(FPKID,FLOCALEID,FENTRYID,FDIYNAME) VALUES ('3B+SGZ+ZRRH5','zh_CN',1701513525282743297,'往来单位');
INSERT INTO T_ER_BILL_SETTING_ENTRY_L(FPKID,FLOCALEID,FENTRYID,FDIYNAME) VALUES ('3B+SGZ+ZRRH6','zh_TW',1701513525282743297,'往來單位');







