DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031040;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.qty',1270142720081597440,'billentry',1270142720115031040,'1',1,'qty','物料明细.数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031041;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.baseqty',1270142720081597440,'billentry',1270142720115031041,'1',2,'baseqty','物料明细.基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031042;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.qtyunit2nd',1270142720081597440,'billentry',1270142720115031042,'1',3,'qtyunit2nd','物料明细.辅助数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031043;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.discountamount',1270142720081597440,'billentry',1270142720115031043,'1',4,'discountamount','物料明细.折扣额'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031044;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.taxamount',1270142720081597440,'billentry',1270142720115031044,'1',5,'taxamount','物料明细.税额'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031045;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.curtaxamount',1270142720081597440,'billentry',1270142720115031045,'1',6,'curtaxamount','物料明细.税额本位币'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031046;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.amount',1270142720081597440,'billentry',1270142720115031046,'1',7,'amount','物料明细.金额'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031047;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.curamount',1270142720081597440,'billentry',1270142720115031047,'1',8,'curamount','物料明细.金额本位币'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031048;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.amountandtax',1270142720081597440,'billentry',1270142720115031048,'1',9,'amountandtax','物料明细.价税合计'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031049;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.curamountandtax',1270142720081597440,'billentry',1270142720115031049,'1',10,'curamountandtax','物料明细.价税合计本位币'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031050;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.remainreturnqty',1270142720081597440,'billentry',1270142720115031050,'1',11,'remainreturnqty','物料明细.剩余退库数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031051;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.remainreturnbaseqty',1270142720081597440,'billentry',1270142720115031051,'1',12,'remainreturnbaseqty','物料明细.剩余退库基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031052;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.remainjoinpriceqty',1270142720081597440,'billentry',1270142720115031052,'1',13,'remainjoinpriceqty','物料明细.剩余应付数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031053;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.remainjoinpricebaseqty',1270142720081597440,'billentry',1270142720115031053,'1',14,'remainjoinpricebaseqty','物料明细.剩余应付基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031054;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.verifyqty',1270142720081597440,'billentry',1270142720115031054,'1',15,'verifyqty','物料明细.已核销数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031055;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.verifybaseqty',1270142720081597440,'billentry',1270142720115031055,'1',16,'verifybaseqty','物料明细.已核销基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031056;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.unverifyqty',1270142720081597440,'billentry',1270142720115031056,'1',17,'unverifyqty','物料明细.未核销数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031057;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.unverifybaseqty',1270142720081597440,'billentry',1270142720115031057,'1',18,'unverifybaseqty','物料明细.未核销基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031058;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.joinpriceqty',1270142720081597440,'billentry',1270142720115031058,'1',19,'joinpriceqty','物料明细.累计应付数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270142720115031059;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.joinpricebaseqty',1270142720081597440,'billentry',1270142720115031059,'1',20,'joinpricebaseqty','物料明细.累计应付基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270143102660721664;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.returnqty',1270142720081597440,'billentry',1270143102660721664,'1',21,'returnqty','物料明细.累计退库数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1270143102660721665;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.returnbaseqty',1270142720081597440,'billentry',1270143102660721665,'1',22,'returnbaseqty','物料明细.累计退库基本数量'); 

DELETE FROM t_im_billfieldsetting WHERE FID = 1270142720081597440;
INSERT INTO t_im_billfieldsetting(FID,FCREATETIME,FBILL,FMODIFIERID,FENABLE,FMODIFYTIME,FSTATUS,FCREATORID) VALUES (1270142720081597440,{ts'2021-10-19  00:00:00'},'im_mdc_omcmplinbill',1159363507540525056,'1',{ts'2021-10-19  00:00:00'},'C',1159363507540525056); 

