-- 直接调拨单，调拨出，调拨入  红字字段
 
DELETE FROM t_im_billfieldsetting WHERE FID = 1073094147713540096;
INSERT INTO t_im_billfieldsetting(FID,FCREATETIME,FBILL,FENABLE,FMODIFIERID,FMODIFYTIME,FSTATUS,FCREATORID,FNAME) 
VALUES (1073094147713540096,{ts'2021-01-20  14:03:58'},'im_transdirbill','1',1,{ts'2021-02-25  14:37:02'},'C',1,' '); 


DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1073094147747092480;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094147713540096,'billentry.qty','billentry',1073094147747092480,'1',1,'qty','物料明细.数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1073094147747092481;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094147713540096,'billentry.baseqty','billentry',1073094147747092481,'1',2,'baseqty','物料明细.基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1073094147747092482;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094147713540096,'billentry.qtyunit2nd','billentry',1073094147747092482,'1',3,'qtyunit2nd','物料明细.辅助数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099201436136525824;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094147713540096,'billentry.amount','billentry',1099201436136525824,'1',4,'amount','物料明细.金额'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099201436136525826;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094147713540096,'billentry.remainreturnqty','billentry',1099201436136525826,'1',6,'remainreturnqty','物料明细.剩余退回数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099201436136525827;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094147713540096,'billentry.remainreturnbaseqty','billentry',1099201436136525827,'1',7,'remainreturnbaseqty','物料明细.剩余退回基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099201436136525828;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094147713540096,'billentry.returnbaseqty','billentry',1099201436136525828,'1',8,'returnbaseqty','物料明细.累计退回基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099201436136525829;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094147713540096,'billentry.returnqty','billentry',1099201436136525829,'1',9,'returnqty','物料明细.累计退回数量'); 





DELETE FROM t_im_billfieldsetting WHERE FID = 1073095372316090368;
INSERT INTO t_im_billfieldsetting(FID,FCREATETIME,FBILL,FENABLE,FMODIFIERID,FMODIFYTIME,FSTATUS,FCREATORID,FNAME) 
VALUES (1073095372316090368,{ts'2021-01-20  14:08:17'},'im_transinbill','1',1,{ts'2021-02-25  14:38:49'},'C',1,' '); 

DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1073095372316088320;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073095372316090368,'billentry.qty','billentry',1073095372316088320,'1',1,'qty','物料明细.数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1073095372316088321;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073095372316090368,'billentry.qtyunit2nd','billentry',1073095372316088321,'1',2,'qtyunit2nd','物料明细.辅助数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1073095372316088322;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073095372316090368,'billentry.baseqty','billentry',1073095372316088322,'1',3,'baseqty','物料明细.基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099202336947195904;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073095372316090368,'billentry.amount','billentry',1099202336947195904,'1',4,'amount','物料明细.金额'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099202336947195906;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073095372316090368,'billentry.remainreturnqty','billentry',1099202336947195906,'1',6,'remainreturnqty','物料明细.剩余退回数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099202336947195907;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073095372316090368,'billentry.remainreturnbaseqty','billentry',1099202336947195907,'1',7,'remainreturnbaseqty','物料明细.剩余退回基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099202336947195908;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073095372316090368,'billentry.returnqty','billentry',1099202336947195908,'1',8,'returnqty','物料明细.累计退回数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099202336947195909;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073095372316090368,'billentry.returnbaseqty','billentry',1099202336947195909,'1',9,'returnbaseqty','物料明细.累计退回基本数量'); 





DELETE FROM t_im_billfieldsetting WHERE FID = 1073094732005251072;
INSERT INTO t_im_billfieldsetting(FID,FCREATETIME,FBILL,FENABLE,FMODIFIERID,FMODIFYTIME,FSTATUS,FCREATORID,FNAME) 
VALUES (1073094732005251072,{ts'2021-01-20  14:06:50'},'im_transoutbill','1',1,{ts'2021-02-25  14:43:34'},'C',1,' '); 

DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1073094732013641728;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094732005251072,'billentry.qty','billentry',1073094732013641728,'1',1,'qty','物料明细.数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1073094732013641729;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094732005251072,'billentry.qtyunit2nd','billentry',1073094732013641729,'1',2,'qtyunit2nd','物料明细.辅助数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1073094732013641730;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094732005251072,'billentry.baseqty','billentry',1073094732013641730,'1',3,'baseqty','物料明细.基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099204727482372096;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094732005251072,'billentry.transinbaseqty','billentry',1099204727482372096,'1',4,'transinbaseqty','物料明细.累计调入基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099204727482372097;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094732005251072,'billentry.remaintransinbaseqty','billentry',1099204727482372097,'1',5,'remaintransinbaseqty','物料明细.剩余调入基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099204727482372098;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094732005251072,'billentry.transinqty','billentry',1099204727482372098,'1',6,'transinqty','物料明细.累计调入数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099204727482372099;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094732005251072,'billentry.remaintransinqty','billentry',1099204727482372099,'1',7,'remaintransinqty','物料明细.剩余调入数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099204727482372100;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094732005251072,'billentry.amount','billentry',1099204727482372100,'1',8,'amount','物料明细.金额');  
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099204727482372102;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094732005251072,'billentry.returnqty','billentry',1099204727482372102,'1',10,'returnqty','物料明细.累计退回数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099204727482372103;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094732005251072,'billentry.returnbaseqty','billentry',1099204727482372103,'1',11,'returnbaseqty','物料明细.累计退回基本数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099204727482372104;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094732005251072,'billentry.remainreturnqty','billentry',1099204727482372104,'1',12,'remainreturnqty','物料明细.剩余退回数量'); 
DELETE FROM t_im_fieldsettingentry WHERE FENTRYID = 1099204727482372105;
INSERT INTO t_im_fieldsettingentry(FID,FFULLFIELD,FENTRYENTITYID,FENTRYID,FISINVERSE,FSEQ,FFIELD,FFIELDNAME) VALUES (1073094732005251072,'billentry.remainreturnbaseqty','billentry',1099204727482372105,'1',13,'remainreturnbaseqty','物料明细.剩余退回基本数量'); 


