--收入确认单单据策略名称修改
UPDATE T_BAS_BILLTYPE_L SET FNAME='费用销售收入',FDESCRIPTION='费用销售收入' WHERE FPKID='09YMFCYL1N0J';
UPDATE T_BAS_BILLTYPE_L SET FNAME='費用銷售收入',FDESCRIPTION='費用銷售收入' WHERE FPKID='09YMFCYL1N0K';
UPDATE T_BAS_BILLTYPE_L SET FNAME='服务销售收入',FDESCRIPTION='服务销售收入' WHERE FPKID='09YMUCV0OYD1';
UPDATE T_BAS_BILLTYPE_L SET FNAME='服務銷售收入',FDESCRIPTION='服務銷售收入' WHERE FPKID='09YMUCV0OYD2';
UPDATE T_BAS_BILLTYPE_L SET FNAME='销售费用收入',FDESCRIPTION='销售费用收入' WHERE FPKID='0ABWBB3=WPXH';
UPDATE T_BAS_BILLTYPE_L SET FNAME='銷售費用收入',FDESCRIPTION='銷售費用收入' WHERE FPKID='0ABWBB3=WPXI';
UPDATE T_BAS_BILLTYPE_L SET FNAME='标准销售收入',FDESCRIPTION='标准销售收入' WHERE FPKID='09YLPETVSVUW';
UPDATE T_BAS_BILLTYPE_L SET FNAME='標準銷售收入',FDESCRIPTION='標準銷售收入' WHERE FPKID='09YLPETVSVUX';
--收入确认单单据类型修改（物料、费用项目设为必录）
--标准销售收入
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980427379237215232;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732351444413344768,'0','0',980427379237215232,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_expenseitem',1,' ',' ','0',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980427379237215233;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732351444413344768,'1','0',980427379237215233,'0','1','1','0',0,'1',' ','1','1','1',0,'1','0','e_material',2,' ',' ','1',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 981070296238808066;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732351444413344768,'0','0',981070296238808066,'0','1','1','0',0,'1',' ','0','1','0',0,'0','0','asstacttype',3,' ',' ','0',0); 
--服务销售收入
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980428127584933888;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732357475654724608,'0','0',980428127584933888,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_expenseitem',1,' ',' ','0',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980428127584933889;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732357475654724608,'1','0',980428127584933889,'0','1','1','0',0,'1',' ','1','1','1',0,'1','0','e_material',2,' ',' ','1',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 981070550145193986;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732357475654724608,'0','0',981070550145193986,'0','1','1','0',0,'1',' ','0','1','0',0,'0','0','asstacttype',3,' ',' ','0',0); 
--销售费用收入
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980429499021679616;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (743888441053316096,'1','0',980429499021679616,'0','1','1','0',0,'1',' ','1','1','1',0,'1','0','e_expenseitem',1,' ',' ','1',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980429499021679617;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (743888441053316096,'0','0',980429499021679617,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_material',2,' ',' ','0',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980429499021679618;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (743888441053316096,'0','0',980429499021679618,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_spectype',4,' ',' ','0',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980429499021679619;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (743888441053316096,'0','0',980429499021679619,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_assistantattr',5,' ',' ','0',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980429499021679620;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (743888441053316096,'0','0',980429499021679620,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_materialversion',6,' ',' ','0',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 981071084004596738;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (743888441053316096,'0','0',981071084004596738,'0','1','1','0',0,'1',' ','0','1','0',0,'0','0','asstacttype',3,' ',' ','0',0); 
--其他收入
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980431204509572096;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732363231766538240,'1','0',980431204509572096,'0','1','1','0',0,'1',' ','1','1','1',0,'1','0','e_expenseitem',1,' ',' ','1',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980431204509572097;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732363231766538240,'0','0',980431204509572097,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_material',2,' ',' ','0',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980431204509572098;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732363231766538240,'0','0',980431204509572098,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_spectype',3,' ',' ','0',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980431204509572099;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732363231766538240,'0','0',980431204509572099,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_assistantattr',4,' ',' ','0',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980431204509572100;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732363231766538240,'0','0',980431204509572100,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_materialversion',5,' ',' ','0',0); 
--费用销售收入
UPDATE T_BAS_BILLTYPE SET FENABLE=0 WHERE FNUMBER='ar_revcfmbill_fee_BT_S';
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980431696316880896;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732355417509751808,'1','0',980431696316880896,'0','1','1','0',0,'1',' ','1','1','1',0,'1','0','e_expenseitem',1,' ',' ','1',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980431696316880897;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732355417509751808,'0','0',980431696316880897,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_material',2,' ',' ','0',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980431696316880898;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732355417509751808,'0','0',980431696316880898,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_spectype',3,' ',' ','0',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980431696316880899;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732355417509751808,'0','0',980431696316880899,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_assistantattr',4,' ',' ','0',0); 
DELETE FROM T_BAS_BILLTYPEFLDCTL WHERE FENTRYID = 980431696316880900;
INSERT INTO T_BAS_BILLTYPEFLDCTL(FID,FVVIEW,FISDELETED,FENTRYID,FSYSMUSTINPUT,FMUSTINPUT,FSUBMITENABLED,FEDITENABLED,FDEFAULTVALUETYPE,FAUDITENABLED,FDEFAULTFUNCNAME,FVSUBMIT,FVINIT,FVNEW,FFIELDELEMENTTYPE,FVEDIT,FENABLED,FFIELDKEY,FSEQ,FDEFAULTVALUE,FDEFAULTFUNCPARAM,FVAUDIT,FDEFAULTFUNCID) VALUES (732355417509751808,'0','0',980431696316880900,'0','0','1','0',0,'1',' ','0','1','0',0,'0','0','e_materialversion',5,' ',' ','0',0); 

