DELETE FROM t_tctb_datasource WHERE FID = 1855042370970929152;
INSERT INTO t_tctb_datasource(FID,FBIZNAME,FTYPE,FISCHILD,FCONDITION,FORGTAKERELATION,FCREATEORGID,FSOURCEDATAID,FSUBENTITYNAME,FMASTERID,FORGID,FUSERORG,FSTATUS,FCTRLSTRATEGY,FENTITYNAME,FNUMBER,FGROUPID,FCREATETIME,FMODIFIERID,FENABLE,FTAXTYPE,FMODIFYTIME,FCREATORID,FISSYSTEM) VALUES (1855042370970929152,'佣金手续费台账','0','1',' ','0',100000,0,' ',1855042370970929152,100000,100000,'C','5','tccit_commissions_fees',' ',978216567512983552,{ts'2024-01-04  00:00:00'},13466739,'1',' ',{ts'2024-01-04  00:00:00'},13466739,'1'); 

DELETE FROM t_tctb_datasource_l WHERE FPKID = '3TVAPC33QV/W';
INSERT INTO t_tctb_datasource_l(FID,FPKID,FLOCALEID,FNAME) VALUES (1855042370970929152,'3TVAPC33QV/W','zh_CN','tccit_commissions_fees'); 

DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594688;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','业务编码','0','0',' ',1855042417460594688,'1','tccit_commissions_fees','0',0,'1','0',1,'billno','0','业务编码','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594689;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','单据状态','0','0',' ',1855042417460594689,'1','tccit_commissions_fees','0',0,'0','0',2,'billstatus','0','单据状态','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594690;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','创建人','0','0',' ',1855042417460594690,'1','tccit_commissions_fees','0',0,'0','0',3,'creator','0','创建人','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594691;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','修改人','0','0',' ',1855042417460594691,'1','tccit_commissions_fees','0',0,'0','0',4,'modifier','0','修改人','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594692;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','审核人','0','0',' ',1855042417460594692,'1','tccit_commissions_fees','0',0,'0','0',5,'auditor','0','审核人','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594693;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','审核日期','0','0',' ',1855042417460594693,'1','tccit_commissions_fees','0',0,'0','0',6,'auditdate','0','审核日期','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594694;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','修改时间','0','0',' ',1855042417460594694,'1','tccit_commissions_fees','0',0,'0','0',7,'modifytime','0','修改时间','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594695;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','创建时间','0','0',' ',1855042417460594695,'1','tccit_commissions_fees','0',0,'0','0',8,'createtime','0','创建时间','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594696;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'1','税务组织','0','0',' ',1855042417460594696,'1','tccit_commissions_fees','0',0,'0','0',9,'org','0','税务组织','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594697;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','业务名称','0','0',' ',1855042417460594697,'1','tccit_commissions_fees','0',0,'1','0',10,'name','0','业务名称','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594698;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','佣金手续费类型','0','0',' ',1855042417460594698,'1','tccit_commissions_fees','0',0,'0','0',11,'type','0','佣金手续费类型','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594699;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','税收规定扣除率','0','0',' ',1855042417460594699,'1','tccit_commissions_fees','0',0,'0','0',12,'rate','0','税收规定扣除率','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594700;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','业务日期','0','0',' ',1855042417460594700,'1','tccit_commissions_fees','0',0,'0','0',13,'businessdate','0','业务日期','0','1'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594701;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','账载金额','0','0',',bqhj,',1855042417460594701,'1','tccit_commissions_fees','0',0,'0','1',14,'zzje','0','账载金额','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594702;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','不允许扣除金额','0','0',' ',1855042417460594702,'1','tccit_commissions_fees','0',0,'0','0',15,'nonallowedamount','0','不允许扣除金额','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594703;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','合同金额','0','0',' ',1855042417460594703,'1','tccit_commissions_fees','0',0,'0','0',16,'contractamount','0','合同金额','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594705;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','税收金额','0','0',',bqhj,',1855042417460594705,'1','tccit_commissions_fees','0',0,'0','1',18,'ssje','0','税收金额','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594706;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','数据来源','0','0',' ',1855042417460594706,'1','tccit_commissions_fees','0',0,'0','0',19,'datasource','0','数据来源','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594707;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','备注','0','0',' ',1855042417460594707,'1','tccit_commissions_fees','0',0,'1','0',20,'remark','0','备注','0','0'); 
DELETE FROM t_tctb_datasource_entry WHERE FENTRYID = 1855042417460594704;
INSERT INTO t_tctb_datasource_entry(FID,FORGSTATE,FBIZSUBNAME,FELEMENTWHERE,FYEARSTATE,FACCESSLOGIC,FENTRYID,FSTATE,FSUBNAME,FMONTHSTATE,FACCESSMAP,FWHERESTATE,FISAMOUNT,FSEQ,FFIELDNAME,FINSPECTIONSHOWFIELD,FDESCRICE,FDRILLDOWN,FDATASTATE) VALUES (1855042370970929152,'0','扣除限额','0','0',' ',1855042417460594704,'1','tccit_commissions_fees','0',0,'0','0',17,'deductlimit','0','扣除限额','0','0'); 

DELETE FROM t_tctb_datasource_pkrules WHERE FPKID = 1855042417460469760;
INSERT INTO t_tctb_datasource_pkrules(FID,FBASEDATAID,FPKID) VALUES (1855042370970929152,1057920129968386048,1855042417460469760); 