/*折旧用途引入模板*/

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

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

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

INSERT INTO T_BAS_IMPORTTEMPLATE_L(FPKID, FID, FLOCALEID, FNAME, FCOMMENT) VALUES ('13PYY8XVK2B9', '999177076902959104', 'zh_CN', '折旧用途引入模板', '预置折旧用途引入模板');
INSERT INTO T_BAS_IMPORTTEMPLATE_L(FPKID, FID, FLOCALEID, FNAME, FCOMMENT) VALUES ('13PYY8XVK2B=', '999177076902959104', 'zh_TW', '折舊用途引入模板', '預置折舊用途引入模板');

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

INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177076902959104', '999176631929247744', '0',                   '1', 'fa_depreuse',  ' ', '0', ' ', '0', '0', ' ', ',,');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177076902959104', '999176632080137216', '999176631929247744',  '2', 'billhead',  ' ', '0', ' ', '0', '0', ' ', ',,');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177076902959104', '999176632130574336', '999176632080137216',  '3', 'id',  ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177076902959104', '999176632180800512', '999176632080137216',  '4', 'number',  ' ', '1', ' ', '1', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177076902959104', '999176632206071808', '999176632080137216',  '5', 'name',  ' ', '1', ' ', '1', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177076902959104', '999176632247909376', '999176632080137216',  '6', 'createtime',  ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177076902959104', '999176632281569280', '999176632080137216',  '7', 'status',  ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177076902959104', '999176632306629632', '999176632080137216',  '8', 'enable',  ' ', '0', ' ', '0', '1', ' ', ' ');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177076902959104', '999176632331900928', '999176632080137216',  '9', 'creator',  ' ', '0', ' ', '0', '1', 'number', 'name');
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY(FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP, FEXPORTPROP) VALUES ('999177076902959104', '999176632356961280', '999176632080137216', '10', 'default',  ' ', '0', ' ', '0', '1', ' ', ' ');
