/*维度成员编码规则 added by qiheng_chen at 2019-5-23 */
DELETE FROM t_cr_coderule where FID = '/ZO74=3=Z4X=';
DELETE FROM t_cr_coderule_l where FID = '/ZO74=3=Z4X=';
DELETE FROM t_cr_coderuleentry where FID = '/ZO74=3=Z4X=';

DELETE FROM t_cr_coderule where FID = '/ZO5QFZKC3CN';
DELETE FROM t_cr_coderule_l where FID = '/ZO5QFZKC3CN';
DELETE FROM t_cr_coderuleentry where FID = '/ZO5QFZKC3CN'; 
	 
insert into t_cr_coderule (FID, FNUMBER, FRULETYPE, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FMASTERID, FISUPDATERECOVER)
values ('/ZO74=3=Z4X=', ' ', ' ', 'bcm_icmembertree', '.', '1', '3', ' ', ' ', '1', 'C', '76039534', {ts'2018-10-09 21:13:37'}, '76039534', {ts'2018-10-09 21:13:37'}, 0, NULL, '/ZO74=3=Z4X=', '0');
insert into t_cr_coderule_l (FPKID, FID, FLOCALEID, FNAME)
values ('/ZO74=3=Z4XB', '/ZO74=3=Z4X=', 'zh_CN', '往来组织编码规则');
insert into t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE)
values ('/ZOX9BIVH2PB', '/ZO74=3=Z4X=', '0', '8', '3', 'dimension.shortnumber', ' ', ' ', '8', '1', '1', ' ', '0', '1', '1', '0', ' ', '1');
INSERT INTO t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE)
VALUES ('/ZOX9BIVH2PC', '/ZO74=3=Z4X=', '1', '2', '1', 'createtime', 'yyMMdd', ' ', '8', '1', '1', ' ', '1', '1', '1', '1', ' ', '1');
insert into t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE)
values ('/ZOX9BIVH2PD', '/ZO74=3=Z4X=', '2', '16', '1', ' ', ' ', ' ', '5', '1', '1', ' ', '1', '1', '1', '0', ' ', '1');

insert into t_cr_coderule (FID, FNUMBER, FRULETYPE, FBIZOBJECTID, FSPLITSIGN, FCTRLMODE, FAPPMODE, FEXAMPLE, FEXAMPLELENGTH, FENABLE, FSTATUS, FCREATORID, FCREATETIME, FMODIFIERID, FMODIFYTIME, FDISABLERID, FDISABLEDATE, FMASTERID, FISUPDATERECOVER)
values ('/ZO5QFZKC3CN', ' ', ' ', 'bcm_userdefinedmembertree', '.', '1', '3', ' ', ' ', '1', 'C', '76039534', {ts'2018-10-09 21:13:37'}, '76039534', {ts'2018-10-09 21:13:37'}, 0, NULL, '/ZO5QFZKC3CN', '0');
insert into t_cr_coderule_l (FPKID, FID, FLOCALEID, FNAME)
values ('/ZO5QFZKC3CP', '/ZO5QFZKC3CN', 'zh_CN', '自定义维度编码规则');
insert into t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE)
values ('/ZOX87ORXDJ0', '/ZO5QFZKC3CN', '0', '8', '3', 'dimension.shortnumber', ' ', ' ', '8', '1', '1', ' ', '0', '1', '1', '0', ' ', '1');
INSERT INTO t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE)
     VALUES ('/ZOX87ORXDJ1', '/ZO5QFZKC3CN', '1', '2', '1', 'createtime', 'yyMMdd', ' ', '8', '1', '1', ' ', '1', '1', '1', '1', ' ', '1');
insert into t_cr_coderuleentry (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE)
values ('/ZOX87ORXDJ2', '/ZO5QFZKC3CN', '2', '16', '1', ' ', ' ', ' ', '5', '1', '1', ' ', '1', '1', '1', '0', ' ', '1');