DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624192;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.qty',1236236345836473344,'billentry',1236236346943624192,'1',1,'qty','物料明细.数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624193;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.qtyunit2nd',1236236345836473344,'billentry',1236236346943624193,'1',2,'qtyunit2nd','物料明细.辅助数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624195;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.amount',1236236345836473344,'billentry',1236236346943624195,'1',4,'amount','物料明细.金额'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624194;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.baseqty',1236236345836473344,'billentry',1236236346943624194,'1',3,'baseqty','物料明细.基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624196;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.returnbaseqty',1236236345836473344,'billentry',1236236346943624196,'1',5,'returnbaseqty','物料明细.累计退库基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624197;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.remainreturnbaseqty',1236236345836473344,'billentry',1236236346943624197,'1',6,'remainreturnbaseqty','物料明细.剩余退库基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624198;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.returnqty',1236236345836473344,'billentry',1236236346943624198,'1',7,'returnqty','物料明细.累计退库数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624199;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.remainreturnqty',1236236345836473344,'billentry',1236236346943624199,'1',8,'remainreturnqty','物料明细.剩余退库数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624200;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.vmisettleqty',1236236345836473344,'billentry',1236236346943624200,'1',9,'vmisettleqty','物料明细.VMI已结算数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624201;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.vmiremainsettlebaseqty',1236236345836473344,'billentry',1236236346943624201,'1',10,'vmiremainsettlebaseqty','物料明细.VMI剩余结算数量(基本单位)'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624202;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.vmiremainsettleqty',1236236345836473344,'billentry',1236236346943624202,'1',11,'vmiremainsettleqty','物料明细.VMI剩余结算数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624203;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.vmisettlebaseqty',1236236345836473344,'billentry',1236236346943624203,'1',12,'vmisettlebaseqty','物料明细.VMI已结算数量(基本单位)'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624204;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.purchasedqty',1236236345836473344,'billentry',1236236346943624204,'1',13,'purchasedqty','物料明细.已转固数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624205;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.remainpurqty',1236236345836473344,'billentry',1236236346943624205,'1',14,'remainpurqty','物料明细.未转固数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624206;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.purchasedamount',1236236345836473344,'billentry',1236236346943624206,'1',15,'purchasedamount','物料明细.已转固金额'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624207;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.remainpuramount',1236236345836473344,'billentry',1236236346943624207,'1',16,'remainpuramount','物料明细.未转固金额'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1236236346943624208;
INSERT INTO t_im_fieldsettingentry(FFULLFIELD,FID,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES ('billentry.cansendqty',1236236345836473344,'billentry',1236236346943624208,'1',17,'cansendqty','物料明细.可发数量'); 

DELETE FROM t_im_billfieldsetting WHERE FID = 1236236345836473344;
INSERT INTO t_im_billfieldsetting(FID,FCREATETIME,FBILL,FMODIFIERID,FENABLE,FMODIFYTIME,FSTATUS,FCREATORID) VALUES (1236236345836473344,{ts'2021-09-02  00:00:00'},'im_mdc_omreturnbill',17526091,'1',{ts'2021-09-02  00:00:00'},'C',17526091); 

