--------------------------------------------
--             资产卡片初始化卡片API 2.0             --
--------------------------------------------

-- 通用查询
DELETE FROM t_open_apiservice WHERE FID = 1637008845597571072;
INSERT INTO t_open_apiservice(FAPISERVICETYPE,FADDEDINFO,FAPIDEFTYPE,FORG_AUTHOR_FILTER,FOPERATION,FORDER_BY_HIDE,FMASTERID,FMUSTPARAM,FSTDMODIFYTIME,FCREATETIME,FPRESCRIPT,ISFAILCONTINUE,FREQTYPE,FISVID,FALLOWGUEST,FBIZOBJECT,FDISABLERID,FOUTPUTPARAM,FCU_LIMIT_TAC,FFILTERPARAM,FISOUTPARAWITHOUTSTATUS,FREPTYPE,FPRESCRIPT_TAG,FISDYOBJRESULT,FCOSMICVER,FMODIFIERID,FPLUGIN,FWSMETHODNAME,FURLFORMAT,FCUSTOMMETHOD,FISFAILCONTINUE,FINPUTPARAM,FISKSQL,FSELECTPARAM,FCONTENTTYPE,FMETHODNAME,FENABLE,FID,FVERSION,FNAMESPACE,FADDEDINFO_TAG,FURL,FDISABLEDATE,FSAVEOPERATION,FSTATUS,FCUSTOMSORT,FNUMBER,FMESSAGETYPE,FMODIFYTIME,FCLASSNAME,FAPPID,FHTTPMETHOD,FCREATORID) VALUES ('0',' ',' ','1','query',' ',1637008845597571072,' ',{ts'2023-08-21  00:00:00'},{ts'2023-03-09  00:00:00'},' ','1',NULL,'kingdee','0','fa_asset_initcard',NULL,' ',0,' ','0',NULL,NULL,'0','5.0.015',1,' ',' ','/v2/fa/fa_asset_initcard/getList',' ','0',' ','0','name,createorg,modifytime','0',' ','1',1637008845597571072,'2',' ',' ',NULL,NULL,' ','C',0,'getList',NULL,{ts'2023-03-09  00:00:00'},' ','83bfebc800001aac','0',1);
DELETE FROM t_open_apiservice_L WHERE FPKID = '341R1FK4NR7W';
INSERT INTO t_open_apiservice_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (1637008845597571072,' ','341R1FK4NR7W','zh_CN','资产卡片初始化通用查询');
DELETE FROM t_open_apiservice_L WHERE FPKID = '341R1FK4NR7X';
INSERT INTO t_open_apiservice_L(FID,FDISCRIPTION,FPKID,FLOCALEID,FNAME) VALUES (1637008845597571072,' ','341R1FK4NR7X','zh_TW','資產卡片初始化通用查詢');
DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1637008845605959680;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERDES,FHEADERVALUE) VALUES (1637008845597571072,'Content-Type',1637008845605959680,1,'内容格式','application/json');
DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1637008845605959681;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERDES,FHEADERVALUE) VALUES (1637008845597571072,'accesstoken',1637008845605959681,2,'请求令牌','获取的accesstoken值');
DELETE FROM t_open_apiheaderentry WHERE FENTRYID = 1637008845605959682;
INSERT INTO t_open_apiheaderentry(FID,FHEADERNAME,FENTRYID,FSEQ,FHEADERDES,FHEADERVALUE) VALUES (1637008845597571072,'Idempotency-Key',1637008845605959682,3,'非必传参数，防止接口被重复调用','唯一的requestId');
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1637002824749676544;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_MUL_VALUE,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FDEFAULTVALUE,FPARAMNAME) VALUES (1637008845597571072,'"Ia9mU"',1637002824749676544,'TextProp','0','org.number','0','0','1','1','String',0,'核算组织.编码',1,' ','org_number');
DELETE FROM t_open_apibodyentry WHERE FENTRYID = 1637603316710245376;
INSERT INTO t_open_apibodyentry(FID,FEXAMPLE,FENTRYID,FBODY_DATA_MODEL,FIS_UNIQUE_KEY,FOBJPROPNAME,FIS_MUL_VALUE,FIS_BODY_CUSTOM,FBODY_LEVEL,FMUST,FPARAMTYPE,FPARENTENTRYID,FBODYPARAMDES,FSEQ,FDEFAULTVALUE,FPARAMNAME) VALUES (1637008845597571072,'"uxH37"',1637603316710245376,'TextProp','0','number','0','0','1','0','String',0,'资产编码',2,'"*"','number');
DELETE FROM t_open_apiqueryfilter WHERE FENTRYID = 1637008845605835778;
INSERT INTO t_open_apiqueryfilter(FID,FFILTERLINK,FFILTERCOMPARE,FFILTER_TYPE,FFILTERVALUE,FFILTERCOLUMN,FFILTERLEFTBRACKET,FENTRYID,FFILTER_CONSTANT,FSEQ,FFILTERRIGHTBRACKET,FFILTERLABEL) VALUES (1637008845597571072,' ','EQUAL','String','org.number','org.number',' ',1637008845605835778,' ',1,' ','核算组织.编码');
DELETE FROM t_open_apiqueryfilter WHERE FENTRYID = 1637603507534300160;
INSERT INTO t_open_apiqueryfilter(FID,FFILTERLINK,FFILTERCOMPARE,FFILTER_TYPE,FFILTERVALUE,FFILTERCOLUMN,FFILTERLEFTBRACKET,FENTRYID,FFILTER_CONSTANT,FSEQ,FFILTERRIGHTBRACKET,FFILTERLABEL) VALUES (1637008845597571072,' ','EQUAL','String','number','number',' ',1637603507534300160,' ',2,' ','资产编码');
DELETE FROM t_open_apiqueryfilter WHERE FENTRYID = 1756656010057035776;
INSERT INTO t_open_apiqueryfilter(FID,FFILTERLINK,FFILTERCOMPARE,FFILTER_TYPE,FFILTERVALUE,FFILTERCOLUMN,FFILTERLEFTBRACKET,FENTRYID,FFILTER_CONSTANT,FSEQ,FFILTERRIGHTBRACKET,FFILTERLABEL) VALUES (1637008845597571072,'0','EQUAL','Boolean',' ','initialcard',' ',1756656010057035776,'1',3,' ','初始化卡片');
DELETE FROM t_open_apiqueryfilter WHERE FENTRYID = 1756656010057035777;
INSERT INTO t_open_apiqueryfilter(FID,FFILTERLINK,FFILTERCOMPARE,FFILTER_TYPE,FFILTERVALUE,FFILTERCOLUMN,FFILTERLEFTBRACKET,FENTRYID,FFILTER_CONSTANT,FSEQ,FFILTERRIGHTBRACKET,FFILTERLABEL) VALUES (1637008845597571072,'0','EQUAL','Boolean',' ','isbak',' ',1756656010057035777,'0',4,' ','备份卡片');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637008827159410688;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'String',1637008827159410688,'0','"ttP2c"','billno','1','0',0,1,'TextProp','1','卡片编号','billno');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637142992785714176;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'String',1637142992785714176,'0','"49m7v"','org_name','1','0',0,2,'MuliLangTextProp','1','核算组织.名称','org.name');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637142992836292608;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'String',1637142992836292608,'0','"K7xBG"','assetunit_name','1','0',0,3,'MuliLangTextProp','1','资产组织.名称','assetunit.name');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637143172603915264;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'String',1637143172603915264,'0','"gNc7n"','number','1','0',0,4,'TextProp','1','资产编码','number');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637143172629327872;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'String',1637143172629327872,'0','"mcL7T"','assetname','1','0',0,5,'MuliLangTextProp','1','资产名称','assetname');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637143172629081088;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'Decimal',1637143172629081088,'0','"541.35"','assetamount','1','0',0,6,'QtyProp','1','资产数量','assetamount');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637143387142811648;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'Date',1637143387142811648,'0','"2023-03-09"','realaccountdate','1','0',0,7,'DateProp','1','启用日期','realaccountdate');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637143387176119296;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'String',1637143387176119296,'0','"MiRSq"','assetcat_name','1','0',0,8,'MuliLangTextProp','1','资产类别.名称','assetcat.name');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637143700264382464;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'String',1637143700264382464,'0','"ADD"','bizstatus','1','0',0,9,'ComboProp','1','业务状态','bizstatus');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637143700297936896;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'String',1637143700297936896,'0','"C"','billstatus','1','0',0,10,'BillStatusProp','1','单据状态 [A:暂存, B:已提交, C:已审核]','billstatus');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637144290251713536;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'Boolean',1637144290251713536,'0','false','mergedcard','1','0',0,11,'BooleanProp','1','资产卡片','mergedcard');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637144554333728768;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'DateTime',1637144554333728768,'0','"2023-03-09 19:53:42"','createtime','1','0',0,12,'CreateDateProp','1','创建时间','createtime');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637144554350259200;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'String',1637144554350259200,'0','"S4SVV"','creator_name','1','0',0,13,'MuliLangTextProp','1','创建人.姓名','creator.name');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1637145542176206848;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'Entries',1637145542176206848,'0','[{},{}]','finentry','1','0',0,14,'EntryProp','1','财务分录','finentry');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1757326749018330112;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'String',1757326749018330112,'0','"qhJEN"','originalfincard_depreuse_name','1','0',1637145542176206848,15,'MuliLangTextProp','2','折旧用途.名称','finentry.originalfincard.depreuse.name');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1757326748976388096;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'Decimal',1757326748976388096,'0','"117.77"','originalfincard_originalval','1','0',1637145542176206848,16,'AmountProp','2','原始财务卡片基础资料.资产原值','finentry.originalfincard.originalval');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1757326749001552896;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'Decimal',1757326749001552896,'0','"21.43"','originalfincard_accumdepre','1','0',1637145542176206848,17,'AmountProp','2','原始财务卡片基础资料.累计折旧','finentry.originalfincard.accumdepre');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1757327969887950848;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'Decimal',1757327969887950848,'0','"642.03"','originalfincard_addupyeardepre','1','0',1637145542176206848,18,'AmountProp','2','原始财务卡片基础资料.本年累计折旧','finentry.originalfincard.addupyeardepre');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1757326749009942528;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'Decimal',1757326749009942528,'0','"781.96"','originalfincard_networth','1','0',1637145542176206848,19,'AmountProp','2','原始财务卡片基础资料.净值','finentry.originalfincard.networth');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1757326749009941504;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'Date',1757326749009941504,'0','"2023-08-22"','originalfincard_finaccountdate','1','0',1637145542176206848,20,'DateProp','2','原始财务卡片基础资料.财务入账日期','finentry.originalfincard.finaccountdate');
DELETE FROM t_open_apirespentry WHERE FENTRYID = 1757326749009942529;
INSERT INTO t_open_apirespentry(FID,FRESPPARAMTYPE,FENTRYID,FIS_RESP_CUSTOM,FRESPEXAMPLE,FRESPPARAMNAME,FRESPPARAMMUST,FIS_RESP_MUL_VALUE,FPARENTENTRYID,FSEQ,FRESP_DATA_MODEL,FRESP_LEVEL,FRESPDES,FRESPOBJPROPNAME) VALUES (1637008845597571072,'String',1757326749009942529,'0','"A"','originalfincard_billstatus','1','0',1637145542176206848,21,'BillStatusProp','2','原始财务卡片基础资料.单据状态 [A:暂存, B:已提交, C:已审核]','finentry.originalfincard.billstatus');

