-- 卡片编号
DELETE from t_cr_coderule where fid = '3Q6TJHFKC6QM';
INSERT INTO t_cr_coderule(FID, FNUMBER, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FMASTERID, FISUPDATERECOVER, FISNONBREAK, FISCHECKCODE, FISAPPCONDITION, FISAPPORG, FISLOG, FISSERIALNUMBER, FISUNIQUE, FISMODIFIABLE, FISADDVIEW, FFILTERCONDITION, FCONDITIONDESC, FISFAST) VALUES ( '3Q6TJHFKC6QM','3Q6TD7JI3CS3','fa_card_real','-','1','2',' ',' ','0','C', 0,{ts'2023-11-24 10:15:37'},1188421630645258240,{ts'2023-11-24 10:19:39'},'3Q6TJHFKC6QM','1','1','0','0','1','0','1','0','0','0','{"filterRow":[{"id":"3Q6TK=4TPLIF","leftBracket":"","compareType":"105","fieldName":"billnocoderule","rightBracket":"","logic":"0","value":[{"id":"3Q6TK=4TROA7","value":"1"}],"baseDataIds":[]}],"forList":false}',' ','1');
DELETE from t_cr_coderule_l where fid = '3Q6TJHFKC6QM';
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('3Q6TJHFKA3YW','3Q6TJHFKC6QM','zh_CN','实物卡片卡片编号编码规则（新）');
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('3Q6TJHFKA3YV','3Q6TJHFKC6QM','zh_TW','實物卡片卡片編號編碼規則（新）');
DELETE from t_cr_coderuleentry where fid = '3Q6TJHFKC6QM';
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3Q6TY983H0W=','3Q6TJHFKC6QM',0,'8','3','org.number',' ',' ',8,1,1,' ','0','1','1','0',' ','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3Q6TY983H0WA','3Q6TJHFKC6QM',1,'8','3','assetcat.number',' ',' ',8,1,1,' ','1','1','1','0','-','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3Q6TY983H0WB','3Q6TJHFKC6QM',2,'2',' ','realaccountdate','yyMM',' ',8,1,1,' ','1','1','1','0','-','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3Q6TY983H0WC','3Q6TJHFKC6QM',3,'16',' ',' ',' ',' ',4,1,1,' ','1','1','1','0','-','1');

-- 资产编码
DELETE from t_cr_coderule where fid = '3Q6SZ=ME63QO';
INSERT INTO t_cr_coderule(FID, FNUMBER, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FMASTERID, FISUPDATERECOVER, FISNONBREAK, FISCHECKCODE, FISAPPCONDITION, FISAPPORG, FISLOG, FISSERIALNUMBER, FISUNIQUE, FISMODIFIABLE, FISADDVIEW, FFILTERCONDITION, FCONDITIONDESC, FISFAST) VALUES ( '3Q6SZ=ME63QO','3Q6S8P00+IHZ','fa_card_real','-','1','2',' ',' ','0','C', 0,{ts'2023-11-24 10:09:17'},1188421630645258240,{ts'2023-11-24 10:19:33'},'3Q6SZ=ME63QO','1','1','0','0','1','0','1','0','0','0','{"filterRow":[{"id":"3Q6TCW3P/2O3","leftBracket":"","compareType":"105","fieldName":"numberrule","rightBracket":"","logic":"0","value":[{"id":"3Q6TCW3P15FW","value":"1"}],"baseDataIds":[]}],"forList":false}',' ','1');
DELETE from t_cr_coderule_l where fid = '3Q6SZ=ME63QO';
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('3Q6SZ=ME40YY','3Q6SZ=ME63QO','zh_CN','实物卡片资产编码编码规则（新）');
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('3Q6SZ=ME40YX','3Q6SZ=ME63QO','zh_TW','實物卡片資產編碼編碼規則（新）');
DELETE from t_cr_coderuleentry where fid = '3Q6SZ=ME63QO';
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3Q6TXXH3EFAW','3Q6SZ=ME63QO',0,'8','3','org.number',' ',' ',8,1,1,' ','0','1','1','1',' ','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3Q6TXXH3EFAX','3Q6SZ=ME63QO',1,'8','3','assetcat.number',' ',' ',8,1,1,' ','1','1','1','1','-','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3Q6TXXH3EFAY','3Q6SZ=ME63QO',2,'2',' ','realaccountdate','yyMM',' ',8,1,1,' ','1','1','1','1','-','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3Q6TXXH3EFAZ','3Q6SZ=ME63QO',3,'16',' ',' ',' ',' ',4,1,1,' ','1','1','1','0','-','1');

-- 条形码
DELETE from t_cr_coderule where fid = '3Q6TS2SQNTRQ';
INSERT INTO t_cr_coderule(FID, FNUMBER, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FMASTERID, FISUPDATERECOVER, FISNONBREAK, FISCHECKCODE, FISAPPCONDITION, FISAPPORG, FISLOG, FISSERIALNUMBER, FISUNIQUE, FISMODIFIABLE, FISADDVIEW, FFILTERCONDITION, FCONDITIONDESC, FISFAST) VALUES ( '3Q6TS2SQNTRQ','3Q6TKU/+0+3B','fa_card_real','-','1','2',' ',' ','0','C', 0,{ts'2023-11-24 10:17:58'},1188421630645258240,{ts'2023-11-24 10:19:51'},'3Q6TS2SQNTRQ','1','1','1','0','1','0','1','0','0','0','{"filterRow":[{"id":"3Q6TYWH4BNZ8","leftBracket":"","compareType":"105","fieldName":"barcoderule","rightBracket":"","logic":"0","value":[{"id":"3Q6TYWH4DQR/","value":"1"}],"baseDataIds":[]}],"forList":false}',' ','1');
DELETE from t_cr_coderule_l where fid = '3Q6TS2SQNTRQ';
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('3Q6TS2SQPWJI','3Q6TS2SQNTRQ','zh_CN','实物卡片条形码编码规则（新）');
INSERT INTO t_cr_coderule_l(FPKID, FID, FLOCALEID, FNAME) VALUES ('3Q6TS2SQPWJH','3Q6TS2SQNTRQ','zh_TW','實物卡片條形碼編碼規則（新）');
DELETE from t_cr_coderuleentry where fid = '3Q6TS2SQNTRQ';
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3Q6TZ02IZ08M','3Q6TS2SQNTRQ',0,'1','1',' ','8009',' ',8,1,1,' ','0','1','1','0',' ','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3Q6TZ02IZ08N','3Q6TS2SQNTRQ',1,'16',' ',' ',' ',' ',8,1,1,' ','0','1','1','0',' ','1');
INSERT t_cr_coderuleentry(FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('3Q6TZ02IZ08O','3Q6TS2SQNTRQ',2,'128',' ',' ',' ',' ',8,1,1,' ','0','1','1','0',' ','1');
