-- 税务日历引入模板初始化插入
-- 李旭灿
-- 2019.6.12
delete from t_bas_importtemplate where FID='646995538767628288';
insert into t_bas_importtemplate (FID, FCREATETIME, FMODIFYTIME, FMODIFIERID, FNUMBER, FNAME, FBIZOBJECT, FSTATUS, FCREATORID, FENABLE, FCOMMENT, FMASTERID, FTEMPLATETYPE) values ('646995538767628288', {ts'2019-03-14 11:51:24'}, {ts'2019-03-14 11:51:24'}, '331947755784139801', 'tpo_tax_calendar_IMPT_S', ' ', 'tpo_tax_calendar', 'A', '331947755784139801', '1', ' ', '646995538767628288', 'IMPT');


delete from t_bas_importtemplate_l where FID='646995538767628288';
insert into t_bas_importtemplate_l (FPKID, FID, FLOCALEID, FNAME, FCOMMENT) values ('0/FOADU0NRH3', '646995538767628288', 'zh_CN', '税务日历', ' ');

insert into t_bas_importtemplate_l (FPKID, FID, FLOCALEID, FNAME, FCOMMENT) values ('0/FOADU0NRH4', '646995538767628288', 'zh_TW', '稅務日曆', ' ');

delete from t_bas_importtemplateentry where FID='646995538767628288';

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP) values ('646995538767628288', '646995495004260352', '0', '1', 'tpo_tax_calendar', '税务日历', '0', ' ', '0', '0', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495323027456', '646995495004260352', '2', 'billhead', '单据头', '0', ' ', '0', '0', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495323027457', '646995495323027456', '3', 'creatorid', '创建人', '0', ' ', '0', '1', 'number');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495323027458', '646995495323027456', '4', 'createtime', '创建日期', '0', ' ', '0', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495323027459', '646995495323027456', '5', 'year', '年份:', '1', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495323027460', '646995495323027456', '6', 'description', '描述:', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495323027461', '646995495004260352', '7', 'entryentity', '单据体', '0', ' ', '1', '0', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416064', '646995495323027461', '8', 'provinces', '省', '0', ' ', '1', '1', 'name');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416065', '646995495323027461', '9', 'city', '市', '0', ' ', '1', '1', 'name');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416066', '646995495323027461', '10', 'taxtype', '税种', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416067', '646995495323027461', '11', 'methods', '征收方式', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416068', '646995495323027461', '12', 'january', '1月', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416069', '646995495323027461', '13', 'february', '2月', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416070', '646995495323027461', '14', 'march', '3月', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416071', '646995495323027461', '15', 'april', '4月', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416072', '646995495323027461', '16', 'may', '5月', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416073', '646995495323027461', '17', 'june', '6月', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416074', '646995495323027461', '18', 'july', '7月', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416075', '646995495323027461', '19', 'august', '8月', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416076', '646995495323027461', '20', 'september', '9月', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416077', '646995495323027461', '21', 'october', '10月', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416078', '646995495323027461', '22', 'november', '11月', '0', ' ', '1', '1', ' ');

insert into t_bas_importtemplateentry (FID, FENTRYID, FPARENTENTRYID, FSEQ, FFIELDKEY, FFIELDNAME, FMUSTINPUT, FDESCRIPTION, FISIMPORT, FISFIELD, FIMPORTPROP)
values ('646995538767628288', '646995495331416079', '646995495323027461', '23', 'december', '12月', '0', ' ', '1', '1', ' ');