/*增减方式引入模板*/

/*主表*/
DELETE FROM T_BAS_IMPORTTEMPLATE WHERE FID = '999177781806077952';

INSERT INTO T_BAS_IMPORTTEMPLATE(FID, FCREATETIME, FMODIFYTIME, FMODIFIERID, FNUMBER, FNAME, FBIZOBJECT, FSTATUS, FCREATORID, FENABLE, FCOMMENT, FMASTERID, FTEMPLATETYPE, FENABLEIMPORT) VALUES ('999177781806077952', {ts'2020-10-10 14:22:34'}, {ts'2020-10-10 14:22:34'}, '13466739', 'fa_changemode_IMPT_S', ' ', 'fa_changemode', 'C', '13466739', '1', ' ', '999177781806077952', 'IMPT', ' ');

/*多语言表*/
DELETE FROM T_BAS_IMPORTTEMPLATE_L WHERE FID = '999177781806077952';

INSERT INTO T_BAS_IMPORTTEMPLATE_L(FPKID, FID, FLOCALEID, FNAME, FCOMMENT) VALUES ('13PZ1D8NJDS2', '999177781806077952', 'zh_CN', '增减方式引入模板', '预置增减方式引入模板');
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FPKID, FID, FLOCALEID, FNAME, FCOMMENT) VALUES ('13PZ1D8NJDS3', '999177781806077952', 'zh_TW', '增減方式引入模板', '預置增減方式引入模板');

/*分录表*/
DELETE FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FID = '999177781806077952';

INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177646866929664', '0',                   '1', 'fa_changemode' , ' ', '0', ' ', '0', '0', ' ', ',,');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177646950710272', '999177646866929664',  '2', 'billhead' , ' ', '0', ' ', '0', '0', ' ', ',,');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177646967592960', '999177646950710272',  '3', 'id' , ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177646992653312', '999177646950710272',  '4', 'number' , ' ', '1', ' ', '1', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647009536000', '999177646950710272',  '5', 'name' , ' ', '1', ' ', '1', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647026207744', '999177646950710272',  '6', 'type' , ' ', '1', ' ', '1', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647051479040', '999177646950710272',  '7', 'longnumber' , ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647068150784', '999177646950710272',  '8', 'fullname' , ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647085033472', '999177646950710272',  '9', 'isleaf' , ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647101705216', '999177646950710272', '10', 'parent' , ' ', '1', ' ', '1', '1', 'number', 'name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647118587904', '999177646950710272', '11', 'sourceflag' , ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647135259648', '999177646950710272', '12', 'issystem' , ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647152142336', '999177646950710272', '13', 'enable' , ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647168814080', '999177646950710272', '14', 'createtime' , ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647185696768', '999177646950710272', '15', 'status' , ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647210757120', '999177646950710272', '16', 'creator' , ' ', '0', ' ', '0', '1', 'number', 'name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647227639808', '999177646950710272', '17', 'level' , ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647244311552', '999177646950710272', '18', 'createorg' , ' ', '1', ' ', '1', '1', 'number', 'name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647261194240', '999177646950710272', '19', 'org' , ' ', '1', ' ', '1', '1', 'number', 'name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177781806077952', '999177647277865984', '999177646950710272', '20', 'useorg' , ' ', '0', ' ', '1', '1', 'number', 'name');
