-- 编码规则
DELETE FROM T_CR_CODERULE WHERE FID = '0APYAVFC5DGP';
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 ('0APYAVFC5DGP', ' ', null, 'im_assembbill', '-', '1', '2', ' ', ' ', '1', 'C', 1, TIMESTAMP '2019-10-28 10:00:33', 1, TIMESTAMP '2019-10-28 10:00:52', null, null, '0APYAVFC5DGP', '0');

DELETE FROM T_CR_CODERULE_L WHERE FID = '0APYAVFC5DGP';
INSERT INTO T_CR_CODERULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('0APYAVFFV1VU', '0APYAVFC5DGP', 'zh_CN', '组装单编码规则');
INSERT INTO T_CR_CODERULE_L (FPKID, FID, FLOCALEID, FNAME) VALUES ('0APYAVFFV1VT', '0APYAVFC5DGP', 'zh_TW', '組裝單編碼規則');


DELETE FROM T_CR_CODERULEENTRY WHERE FID = '0APYAVFC5DGP';
INSERT INTO T_CR_CODERULEENTRY (FENTRYID, FID, FSEQ, FATTRIBUTETYPE, FATTUSINGMODE, FVALUEATRIBUTE, FFORMAT, FSETTINGVALUE, FLENGTH, FINITIAL, FSTEP, FADDCHAR, FISSPLITSIGN, FADDSTYLE, FCUTSTYLE, FISSORTITEM, FSPLITSIGN, FISVISABLE) VALUES ('0APYC/8CB6A6', '0APYAVFC5DGP', 0, '1', ' ', ' ', 'ZZD', ' ', 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 ('0APYC/8CB6A7', '0APYAVFC5DGP', 1, '2', '1', 'biztime', '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 ('0APYC/8CB6A8', '0APYAVFC5DGP', 2, '16', '1', ' ', ' ', ' ', 8, 1, 1, ' ', '1', '1', '1', '0', '-', '1');
