--单据头
DELETE FROM t_bas_importtemplate
WHERE fid=2003805312699604992;

INSERT INTO t_bas_importtemplate
(fid, fcreatetime, fmodifytime, fmodifierid, fnumber, fbizobject, fstatus, fcreatorid, fenable, fcomment, fmasterid, ftemplatetype, fenableimport, fname, fapplyscope, fenablesetnull, fhidefieldrow, fexchangenameandmark, fsplitsubentries, foverrideentry, fforupdatemultilangfields, fplugin)
VALUES(2003805312699604992, {ts'2024-07-27 17:20:01'}, {ts'2024-07-31 16:30:05'}, 1850843891356641280, 'im_warehousesetupmate_rel_IMPT_S', 'im_warehousesetupmate_rel', 'C', 13466739, '1', ' ', 2003805312699604992, 'IMPT', '1', '仓库-物料关系设置引入模板', '0', '1', '0', '0', '0', '0', '0', ' ');

--单据体-字段选择

DELETE FROM t_bas_importtemplateentry
WHERE fentryid=2003803980345384960;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=2003803980253520896;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=2003803980311830536;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=2003803980354184192;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=2003803980311830538;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=2003803980320629762;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=2003803980328607744;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=2003803980329018371;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=2003803980362162176;
DELETE FROM t_bas_importtemplateentry
WHERE fentryid=2003803980303852547;

INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformatname, fexportformat, fisdate)
VALUES(2003805312699604992, 2003803980345384960, 2003803980303852547, 6, 'warehousesetup', NULL, '0', ' ', '0', '1', 'number', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformatname, fexportformat, fisdate)
VALUES(2003805312699604992, 2003803980253520896, 0, 1, 'im_warehousesetupmate_rel', NULL, '0', ' ', '0', '0', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformatname, fexportformat, fisdate)
VALUES(2003805312699604992, 2003803980311830536, 2003803980303852547, 3, 'id', NULL, '0', ' ', '1', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformatname, fexportformat, fisdate)
VALUES(2003805312699604992, 2003803980354184192, 2003803980303852547, 9, 'seqfield', NULL, '0', ' ', '0', '1', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformatname, fexportformat, fisdate)
VALUES(2003805312699604992, 2003803980311830538, 2003803980303852547, 4, 'org', NULL, '1', ' ', '1', '1', 'number', 'number,name', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformatname, fexportformat, fisdate)
VALUES(2003805312699604992, 2003803980320629762, 2003803980303852547, 5, 'warehouse', NULL, '1', ' ', '1', '1', 'number', 'number,name', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformatname, fexportformat, fisdate)
VALUES(2003805312699604992, 2003803980328607744, 2003803980303852547, 7, 'materialnumber', NULL, '0', ' ', '1', '1', 'number', 'number,name', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformatname, fexportformat, fisdate)
VALUES(2003805312699604992, 2003803980329018371, 2003803980303852547, 8, 'materialgrpnumber', NULL, '0', ' ', '1', '1', 'number', 'number,name', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformatname, fexportformat, fisdate)
VALUES(2003805312699604992, 2003803980362162176, 2003803980303852547, 10, 'materialmasterid', NULL, '0', ' ', '0', '1', 'number', 'name', 0, ' ', ' ', ' ', ' ', '0');
INSERT INTO t_bas_importtemplateentry
(fid, fentryid, fparententryid, fseq, ffieldkey, ffieldname, fmustinput, fdescription, fisimport, fisfield, fimportprop, fexportprop, fcolwidth, fsourceentity, fsourcename, fexportformatname, fexportformat, fisdate)
VALUES(2003805312699604992, 2003803980303852547, 2003803980253520896, 2, 'billhead', NULL, '0', ' ', '0', '0', ' ', ' ', 0, ' ', ' ', ' ', ' ', '0');

--多语言
DELETE FROM t_bas_importtemplate_l
WHERE fpkid='4=KQMYQ1N00X';
DELETE FROM t_bas_importtemplate_l
WHERE fpkid='4=KQMYQ1N00Y';
INSERT INTO t_bas_importtemplate_l
(fpkid, fid, flocaleid, fname, fcomment)
VALUES('4=KQMYQ1N00X', 2003805312699604992, 'zh_CN', '仓库-物料关系设置引入模板', ' ');
INSERT INTO t_bas_importtemplate_l
(fpkid, fid, flocaleid, fname, fcomment)

