-- 人员信息管理预置编码规则
-- 主表
DELETE FROM t_cr_coderule WHERE FID = '3DO03MOQNQIF';
INSERT INTO t_cr_coderule(FEXAMPLE,FAPPMODE,FISADDVIEW,FISAPPCONDITION,FMASTERID,FISUNIQUE,FRULETYPE,FISMODIFIABLE,FCREATETIME,FBIZOBJECTID,FENABLE,FISUPDATERECOVER,FISAPPORG,FISSERIALNUMBER,FDISABLERID,FISCHECKCODE,FID,FSPLITSIGN,FCTRLMODE,FDISABLEDATE,FISLOG,FSTATUS,FNUMBER,FEXAMPLELENGTH,FISFAST,FMODIFIERID,FISNONBREAK,FMODIFYTIME,FCREATORID) VALUES (' ','2','1','0','3DO03MOQNQIF','0',NULL,'1',{ts'2023-07-06  00:00:00'},'bos_user_infocleanscheme','1','0','1','1',NULL,'0','3DO03MOQNQIF','-','1',NULL,'0','C','3DO/HC2/0V+5',' ','1',13466739,'0',{ts'2023-07-06  00:00:00'},0); 

-- 多语言表
DELETE FROM t_cr_coderule_l WHERE FPKID = '3DO03MOU=GHV';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3DO03MOQNQIF','3DO03MOU=GHV','zh_CN','人员信息管理编码规则'); 
DELETE FROM t_cr_coderule_l WHERE FPKID = '3DO03MOU=GHU';
INSERT INTO t_cr_coderule_l(FID,FPKID,FLOCALEID,FNAME) VALUES ('3DO03MOQNQIF','3DO03MOU=GHU','zh_TW','人員信息管理編碼規則'); 

-- 分录表
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '3DO03MQOTFK7';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3DO03MOQNQIF',1,'1',' ','0','3DO03MQOTFK7',1,'1','1',0,8,'1','DP',' ','1',' ','0',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '3DO03MQOTFK8';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3DO03MOQNQIF',1,'2','-','0','3DO03MQOTFK8',1,'1',' ',1,8,'1','yyyyMMdd',' ','1','createtime','1',' '); 
DELETE FROM t_cr_coderuleentry WHERE FENTRYID = '3DO03MQOTFK9';
INSERT INTO t_cr_coderuleentry(FID,FINITIAL,FATTRIBUTETYPE,FSPLITSIGN,FISSORTITEM,FENTRYID,FSTEP,FCUTSTYLE,FATTUSINGMODE,FSEQ,FLENGTH,FISVISABLE,FFORMAT,FSETTINGVALUE,FADDSTYLE,FVALUEATRIBUTE,FISSPLITSIGN,FADDCHAR) VALUES ('3DO03MOQNQIF',1,'16','-','0','3DO03MQOTFK9',1,'1',' ',2,3,'1',' ',' ','1',' ','1',' '); 