IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '3H3OT0=PMHSQ')
INSERT INTO T_BAS_IMPORTTEMPLATE_L ( FID, FLOCALEID, FPKID, FCOMMENT, FNAME) VALUES ( 1751379853355042816, 'zh_CN', '3H3OT0=PMHSQ', '系统预置模板', '销售价目表引入模板');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATE_L WHERE FPKID = '3H3OT0=PMHSR')
INSERT INTO T_BAS_IMPORTTEMPLATE_L ( FID, FLOCALEID, FPKID, FCOMMENT, FNAME) VALUES ( 1751379853355042816, 'zh_TW', '3H3OT0=PMHSR', '係統預置模板', '銷售價目表引入模板');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATE WHERE FID = 1751379853355042816)
INSERT INTO T_BAS_IMPORTTEMPLATE ( FENABLESETNULL, FID, FENABLEIMPORT, FEXCHANGENAMEANDMARK, FMASTERID, FSTATUS, FTEMPLATETYPE, FNUMBER, FCREATETIME, FHIDEFIELDROW, FAPPLYSCOPE, FENABLE, FMODIFIERID, FSPLITSUBENTRIES, FPLUGIN, FFORUPDATEMULTILANGFIELDS, FMODIFYTIME, FCREATORID, FBIZOBJECT) VALUES ( '1', 1751379853355042816, ' ', '0', 1751379853355042816, 'C', 'IMPT', 'sm_salepricelist_IMPT_S',{ts'2018-08-08  00:00:00'}, '0', '0', '1',1, '0', ' ', '0',{ts'2018-08-08  00:00:00'},1, 'sm_salepricelist');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858000730112)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858000730112, '0', '0', ' ', ' ', '0', ' ', '0', ' ', 0, 'sm_salepricelist', 1, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858042742784)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858042742784, '0', '0', ' ', ' ', '0', ' ', '0', ' ', 1751466858000730112, 'billhead', 2, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858051061760)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858051061760, '0', '0', ' ', ' ', '0', ' ', '1', ' ', 1751466858042742784, 'id', 3, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858067908608)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858067908608, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858042742784, 'number', 4, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858067838976)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858067838976, '1', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858042742784, 'name', 5, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858067908609)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858067908609, '1', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858042742784, 'applymaterial', 6, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858076227584)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858076227584, '1', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858042742784, 'applycustomer', 7, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858076297216)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858076297216, '1', '1', ' ', ' ', '1', 'dateformat1', '1', ' ', 1751466858042742784, 'effectdate', 8, 'YYYY-MM-dd', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858084616192)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858084616192, '1', '1', ' ', ' ', '1', 'dateformat1', '1', ' ', 1751466858042742784, 'expirydate', 9, 'YYYY-MM-dd', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858093074432)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858093074432, '1', '0', 'name', ' ', '1', ' ', '1', ' ', 1751466858042742784, 'org', 10, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858093004800)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858093004800, '0', '0', 'name', ' ', '1', ' ', '1', ' ', 1751466858042742784, 'group', 11, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858101463040)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858101463040, '1', '0', 'name', ' ', '1', ' ', '1', ' ', 1751466858042742784, 'pricelisttype', 12, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858101393408)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858101393408, '0', '0', ' ', ' ', '0', ' ', '1', ' ', 1751466858042742784, 'status', 13, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858109851648)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858109851648, '0', '0', ' ', ' ', '0', ' ', '1', ' ', 1751466858042742784, 'enable', 14, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858118170624)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858118170624, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858042742784, 'description', 15, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858118240256)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858118240256, '0', '0', 'name', ' ', '0', ' ', '1', ' ', 1751466858042742784, 'creator', 16, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858126559232)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858126559232, '0', '1', ' ', ' ', '0', 'dateformat6', '1', ' ', 1751466858042742784, 'createtime', 17, 'YYYY-MM-dd HH:mm:ss', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858135017472)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858135017472, '0', '0', 'name', ' ', '0', ' ', '1', ' ', 1751466858042742784, 'modifier', 18, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858134947840)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858134947840, '0', '1', ' ', ' ', '0', 'dateformat6', '1', ' ', 1751466858042742784, 'modifytime', 19, 'YYYY-MM-dd HH:mm:ss', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858143406080)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858143406080, '0', '0', 'name', ' ', '0', ' ', '1', ' ', 1751466858042742784, 'auditor', 20, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858151725056)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858151725056, '0', '1', ' ', ' ', '0', 'dateformat6', '1', ' ', 1751466858042742784, 'audittime', 21, 'YYYY-MM-dd HH:mm:ss', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858151794688)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858151794688, '0', '0', 'name', ' ', '0', ' ', '1', ' ', 1751466858042742784, 'disabler', 22, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858160113664)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858160113664, '0', '1', ' ', ' ', '0', 'dateformat6', '1', ' ', 1751466858042742784, 'disabledate', 23, 'YYYY-MM-dd HH:mm:ss', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858160183296)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858160183296, '1', '0', 'name', ' ', '1', ' ', '1', ' ', 1751466858042742784, 'currency', 24, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858168502272)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858168502272, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858042742784, 'istax', 25, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858176960512)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858176960512, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858042742784, 'isstair', 26, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858520823808)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858520823808, '0', '0', ' ', ' ', '0', ' ', '0', ' ', 1751466858000730112, 'customerentryentity', 27, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858529282048)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858529282048, '0', '0', ' ', ' ', '0', ' ', '1', ' ', 1751466858520823808, 'customerentryentity.id', 28, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858529212416)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858529212416, '0', '0', 'name', ' ', '1', ' ', '1', ' ', 1751466858520823808, 'customer', 29, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858537670656)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858537670656, '0', '0', 'name', ' ', '1', ' ', '1', ' ', 1751466858520823808, 'customergroup', 30, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858596321280)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858596321280, '0', '0', ' ', ' ', '0', ' ', '0', ' ', 1751466858000730112, 'priceentryentity', 31, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858613168128)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858613168128, '0', '0', ' ', ' ', '0', ' ', '1', ' ', 1751466858596321280, 'priceentryentity.id', 32, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858613098496)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858613098496, '1', '1', ' ', ' ', '1', 'dateformat1', '1', ' ', 1751466858596321280, 'priceeffectdate', 33, 'YYYY-MM-dd', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858621556736)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858621556736, '1', '1', ' ', ' ', '1', 'dateformat1', '1', ' ', 1751466858596321280, 'priceexpirydate', 34, 'YYYY-MM-dd', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858621487104)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858621487104, '0', '0', 'name', ' ', '1', ' ', '1', ' ', 1751466858596321280, 'materialgroup', 35, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858638264320)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858638264320, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858596321280, 'auxpty', 37, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858638333952)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858638333952, '0', '0', 'name', ' ', '1', ' ', '1', ' ', 1751466858596321280, 'unit', 38, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858646652928)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858646652928, '0', '0', 'name', ' ', '0', ' ', '1', ' ', 1751466858596321280, 'baseunit', 39, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858655111168)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858655111168, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858596321280, 'price', 40, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858663430144)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858663430144, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858596321280, 'priceandtax', 41, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858663499776)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858663499776, '0', '0', 'name', ' ', '1', ' ', '1', ' ', 1751466858596321280, 'taxrateid', 42, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858671818752)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858671818752, '0', '0', ' ', ' ', '0', ' ', '1', ' ', 1751466858596321280, 'taxrate', 43, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858680276992)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858680276992, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858596321280, 'isstairprice', 44, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858688665600)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858688665600, '0', '0', ' ', ' ', '0', ' ', '1', ' ', 1751466858596321280, 'qtyfrom', 46, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858696984576)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858696984576, '0', '0', ' ', ' ', '0', ' ', '1', ' ', 1751466858596321280, 'qtyto', 47, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858697054208)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858697054208, '0', '0', ' ', ' ', '0', ' ', '1', ' ', 1751466858596321280, 'baseqtyfrom', 48, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858705373184)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858705373184, '0', '0', ' ', ' ', '0', ' ', '1', ' ', 1751466858596321280, 'baseqtyto', 49, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858705442816)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858705442816, '0', '0', ' ', ' ', '0', ' ', '1', ' ', 1751466858596321280, 'unitpriceqty', 50, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858688595968)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858688595968, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858596321280, 'lotnumber', 45, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858629945344)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, 'number', 1751466858629945344, '0', '0', 'name', ' ', '1', ' ', '1', ' ', 1751466858596321280, 'material', 36, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858713761792)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858713761792, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858596321280, 'pricefloor', 51, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858722220032)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858722220032, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858596321280, 'priceceiling', 52, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858722150400)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858722150400, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858596321280, 'remark', 53, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858948642816)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858948642816, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858931935232, 'stairqtystart', 57, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858957101056)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858957101056, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858931935232, 'stairqtyend', 58, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858931935232)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858931935232, '0', '0', ' ', ' ', '0', ' ', '0', ' ', 1751466858596321280, 'salstairprice', 54, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858940254208)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858940254208, '0', '0', ' ', ' ', '0', ' ', '1', ' ', 1751466858931935232, 'salstairprice.id', 55, ' ', ' ');
IF NOT EXISTS (SELECT 1 FROM T_BAS_IMPORTTEMPLATEENTRY WHERE FENTRYID = 1751466858948712448)
INSERT INTO T_BAS_IMPORTTEMPLATEENTRY ( FID, FCOLWIDTH, FIMPORTPROP, FENTRYID, FMUSTINPUT, FISDATE, FEXPORTPROP, FDESCRIPTION, FISIMPORT, FEXPORTFORMAT, FISFIELD, FSOURCENAME, FPARENTENTRYID, FFIELDKEY, FSEQ, FEXPORTFORMATNAME, FSOURCEENTITY) VALUES ( 1751379853355042816, 0, ' ', 1751466858948712448, '0', '0', ' ', ' ', '1', ' ', '1', ' ', 1751466858931935232, 'stairprice', 56, ' ', ' ');
