--生产领料申请批号单据配置预置数据

DELETE FROM t_msmod_lotbillcfgmfentry WHERE FENTRYID = 1893540440813123584;
INSERT INTO t_msmod_lotbillcfgmfentry(FID,FMAINFSRCBILLCOLNO,FENTRYID,FSEQ,FMAINFCOL,FMAINFSRCBILLCOL,FMAINFCOLNO) VALUES (1893540440402081792,'物料明细.批号',1893540440813123584,1,'number','billentry.lotnumber','批号'); 
DELETE FROM t_msmod_lotbillcfgmfentry WHERE FENTRYID = 1893540440813123585;
INSERT INTO t_msmod_lotbillcfgmfentry(FID,FMAINFSRCBILLCOLNO,FENTRYID,FSEQ,FMAINFCOL,FMAINFSRCBILLCOL,FMAINFCOLNO) VALUES (1893540440402081792,'创建人',1893540440813123585,2,'creator','creator','创建人'); 
DELETE FROM t_msmod_lotbillcfgmfentry WHERE FENTRYID = 1893540440813123586;
INSERT INTO t_msmod_lotbillcfgmfentry(FID,FMAINFSRCBILLCOLNO,FENTRYID,FSEQ,FMAINFCOL,FMAINFSRCBILLCOL,FMAINFCOLNO) VALUES (1893540440402081792,'审核日期',1893540440813123586,3,'instockdate','auditdate','首次入库日期'); 
DELETE FROM t_msmod_lotbillcfgmfentry WHERE FENTRYID = 1893540440813123587;
INSERT INTO t_msmod_lotbillcfgmfentry(FID,FMAINFSRCBILLCOLNO,FENTRYID,FSEQ,FMAINFCOL,FMAINFSRCBILLCOL,FMAINFCOLNO) VALUES (1893540440402081792,'申请组织',1893540440813123587,4,'createorg','org','创建组织'); 
DELETE FROM t_msmod_lotbillcfgmfentry WHERE FENTRYID = 1893540440813123588;
INSERT INTO t_msmod_lotbillcfgmfentry(FID,FMAINFSRCBILLCOLNO,FENTRYID,FSEQ,FMAINFCOL,FMAINFSRCBILLCOL,FMAINFCOLNO) VALUES (1893540440402081792,'物料明细.物料编码',1893540440813123588,5,'material','billentry.material','物料编码'); 
DELETE FROM t_msmod_lotcfgretentry WHERE FENTRYID = 1893540440813124610;


INSERT INTO t_msmod_lotcfgretentry(FLOTMFRETURNSRCBILLCOL,FRETURNBILL,FID,FSELECTCONDITION,FLOTMFRETURNCOLNO,FLOTMFRETURNCOL,FLOTMFRETURNSRCBILLCOLNO,FENTRYID,FSEQ) VALUES ('billentry.lotnumber','1',1893540440402081792,'0','批号','number','物料明细.批号',1893540440813124610,1); 
DELETE FROM t_msmod_lotcfgretentry WHERE FENTRYID = 1893540440813124611;
INSERT INTO t_msmod_lotcfgretentry(FLOTMFRETURNSRCBILLCOL,FRETURNBILL,FID,FSELECTCONDITION,FLOTMFRETURNCOLNO,FLOTMFRETURNCOL,FLOTMFRETURNSRCBILLCOLNO,FENTRYID,FSEQ) VALUES ('billentry.material','0',1893540440402081792,'1','物料编码','material','物料明细.物料编码',1893540440813124611,2); 


DELETE FROM t_msmod_lotbillconf WHERE FID = 1893540440402081792;
INSERT INTO t_msmod_lotbillconf(FID,FSRCBILLOBJ,FLOTID,FGENLOT,FMASTERID,FSTATUS,FMASTERFILETYPEID,FNUMBER,FBILLFILTER,FLOTIDFIELD,FCREATETIME,FMODIFIERID,FENABLE,FSRCBILLENTRY,FISPRESET,FMODIFYTIME,FLOTNUMBERFIELD,FSRCBILLENTRYNAME,FCREATORID,FMOVEDIRECTION) VALUES (1893540440402081792,'im_mdc_mftomreqapplybill','物料明细.批号主档','0',1893540440402081792,'A',1401417099242528768,'IM_MDC_MFTOMREQAPPLYBILL_S01','{"filterRow":[],"forList":false}','billentry.lot',{ts'2018-08-08  00:00:00'},1,'1','billentry','1',{ts'2018-08-08  00:00:00'},'billentry.lotnumber','物料明细',1,'B'); 


DELETE FROM t_msmod_lotbillconf_l WHERE FID = 1893540440402081792 and FLOCALEID = 'zh_CN';
INSERT INTO t_msmod_lotbillconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1893540440402081792,'3YKRWT6LS9W9','zh_CN',' ','生产委外领料申请单'); 
DELETE FROM t_msmod_lotbillconf_l WHERE FID = 1893540440402081792 and FLOCALEID = 'zh_TW';
INSERT INTO t_msmod_lotbillconf_l(FID,FPKID,FLOCALEID,FDESCRIPTION,FNAME) VALUES (1893540440402081792,'3YKRWT6LS9W=','zh_TW',' ','生產委外領料申請單'); 

