视图名称视图标签问题类型科目表u8c_subjscheme_syn需更新SQL和TS会计期间方案u8c_accperiodscheme_需更新SQL和TS会计期间年u8c_accperiod_year_sy需更新SQL和TS会计期间u8c_accperiod_syn更新SQL会计期间半年u8c_periodhalfyear_syn更新SQL现金流量项目u8c_cashflowitem_syn更新SQL费用项目u8c_ficloud_feeitem更新SQL辅助核算项u8c_accassitem_syn更新SQL账簿u8c_glorgbook_syn更新SQL项目类型U8C_projectclass_sync_更新SQL企业银行账户u8c_bankaccbas_syn更新SQL企业现金账户u8c_orgFinCashAcct_sy更新SQL自定义档案维护u8c_customerDoc_syn更新SQL员工银行账户U8C_StaffBankAcc_cwy更新SQL科目辅助核算u8c_accass_syn需更新SQL和TS会计主体更新SQL部门u8c_dept_syn需更新SQL和TS兼职u8c_ptjob_syn更新SQLSKUu8c_sku_new_syn_upc更新SQL部门（组织部门）u8c_dept_org_syn需更新SQL和TS客户分配关系u8c_custorg_syn_upc更新SQL供应商分配关系u8c_suporg_syn_upc更新SQL客户u8c_customer_syn_upc需更新SQL和TS供应商u8c_supplier_syn_upc需更新SQL和TS人员银行账户u8c_staffbankacct_syn更新SQL物料u8c_material_new_syn_更新SQL库存组织u8c_stockorg_syn需更新SQL和TS会计科目u8c_accsubj_syn更新ts现有SQLSELECTbd_glorgbook.glorgbookcodeAScode,bd_glorgbook.glorgbooknameASname,bd_glorg.pk_entityorgASaccentity,REPLACE(bd_subjscheme.subjcoderule,'/','-')ASsubjectcoderule,bd_subjscheme.memoASdescription,bd_glorgbook.pk_glorgbookASobjid,1ASenable,'U8C_'+CAST(bd_subjscheme.group_indexASCHAR(1))ASSELECTbd_accperiodscheme.accperiodschemecodeAScode,bd_accperiodscheme.accperiodschemenameASname,bd_accperiodscheme.memoASdescription,bd_accperiodscheme.pk_accperiodschemeASobjid,1ASperiodClass,bd_accperiod.periodnumASperiodcount,2ASperiodhcount,bd_accperiod.quarternumASperiodqcount,bd_accperiod.tsASpubts,SELECTbd_accperiodscheme.accperiodschemecodeASschemeCode,bd_accperiodscheme.accperiodschemecodeASaccperiodscheme,bd_accperiod.begindateASbegindate,bd_accperiod.periodyearAScode,bd_accperiod.enddateASenddate,bd_accperiod.periodyearASname,bd_accperiod.periodnumASnum,SELECTbd_accperiod.periodyear+'-'+bd_accperiodmonth.monthASname,bd_accperiod.periodyear+'-'+bd_accperiodmonth.monthAScode,bd_accperiodscheme.accperiodschemecodeASschemeCode,bd_accperiod.periodyearASperiodyearCode,bd_accperiodmonth.begindateASbegindate,bd_accperiodmonth.enddateASenddate,bd_accperiod.tsASpubts,SELECTh.codeAScode,h.codeASname,h.accperiodschemeASschemeCode,h.periodyearASperiodyearCode,h.beginperiodASbeginperiodCode,b.endperiodASendperiodCode,h.objidASobjidFROM(SELECTcode,name,'u8c'ASSOURCE,cashflowtype,mainattachedtable,directionattribute,objid,parent_id,pk_orgFROMSELECTbd_costsubj.pk_corpASaccentity,concat(bd_costsubj.costcode,concat('_',bd_corp.unitcode))AScode,bd_costsubj.costnameASname,bd_costsubj.pk_parentASparent,bd_costsubj.pk_costsubjASobjid,bd_costsubj.sealflagASstopstatus,1ASlevelsFROMSELECTbd_bdinfo.bdcodeAScode,CASEbd_bdinfo.bdcodeWHEN'1'THEN'personnel'WHEN'2'THEN'dept'WHEN'14'THEN'feeitem'WHEN'71'THEN'customer'WHEN'72'THEN'supplier'WHEN'96'THEN'finorgbankacct'WHEN'jobass'THEN'project'SELECTbd_glorg.pk_entityorgASaccentity,s.typeASbookType,s.pk_startaccperiodASgl_startperiodid,s.isconvertASconvertable,s.glorgbooknameASname,s.glorgbookcodeAScode,s.pk_currrateschemeAScurrencySchema,s.pk_glorgbookASobjid,t.pk_subjschemeASaccsubjectchart,t.pk_main_currtypeAScurrency,t.pk_accperiodschemeASaccperiodscheme,'01'ASratetype_code,CASEWHENs.type=0THEN1ELSE2ENDASaccountingclassifi,CASEWHENs.isstartuse='Y'THEN'1'ELSE''SELECTpr.PK_JOBTYPEASid,pr.JOBTYPECODEASCODE,pr.JOBTYPENAMEASNAME,NULLASparentid,pr.PK_CORPASpk_org,CASEWHENpr.JOBPHASEFLAG='N'THEN1ELSE0SELECTs.pk_bankaccbasASid,s.ts,s.tsASpubts,concat(s.accountcode,concat('_',bd_corp.unitcode))AScode,s.pk_bankdocASbanknumber,s.pk_bankdocASbankname,s.account,SELECTs.pk_bankaccbasASid,s.accountcodeASaccount,s.accountcode+'_'+bd_corp.unitcodeAScode,s.accountnameASname,s.creatorAScreator,s.createtimeAScreationtime,s.modifierASmodifier,s.modifytimeASmodifiedtime,1ASenable,0ASisdefault,SELECTd.pk_defdocASid,d.pk_defdocASobjid,d.doccodeAScode,d.docnameASname,d.shortnameASshortname,d.pk_defdoc1ASparentid,d.pk_defdoclistAScustdocdefid,d.docsystypeASispreset,d.pk_corpASorgid,d.memoASdescription,CASEWHEN(d.sealflag='N'SELECTbd_psnaccbank.pk_psnaccbankASid,bd_bankaccbas.accountcodeAScode,bd_psnbasdoc.psnnameASname,bd_bankaccbas.accountnameASaccname,bd_bankaccbas.creatorAScreator,bd_bankaccbas.createtimeAScreationtime,bd_bankaccbas.modifierASmodifier,bd_bankaccbas.modifytimeASmodifiedtime,SELECTbd_subjass.pk_subjassASid,bd_subjass.pk_subjassASobjid,bd_subjass.pk_accsubjASaccsubject,bd_subjass.pk_bdinfoASdimensionext,bd_accsubj.pk_subjschemeASaccsubjectchart,CASEWHENbd_subjass.isnonleafused='Y'THEN1ELSE0ENDASallownonleaf,CASESELECTd.pk_deptdocASid,d.pk_deptdocASobjid,d.deptcode+'_'+p.unitcodeASCODE,d.deptnameASname,d.deptshortnameASshortname,d.pk_fathedeptASparentid,psn.pk_psnbasdocASprincipal,d.phoneAStelephone,d.addrASaddress,d.pk_corpASparentorgid,CASESELECTpt.pk_psndoc_subASid,pt.pk_psndoc_subASobjid,psn.pk_psnbasdocASstaff_id,pt.pk_corpASorg_id,pt.pk_deptdocASdept_id,pt.pk_om_dutyASjob_id,pt.pk_postdocASpost_id,pt.pk_psnclASpsncl_id,SELECTscm_invsku_b.sku_codeAScode,scm_invsku_b.sku_nameASname,bd_invbasdoc.invcodeASproduct_code,bd_invbasdoc.invnameASproduct_name,scm_invsku.retailpriceASprice,scm_invsku_b.pk_invsku_bASobjid,scm_invsku_b.pk_invsku_bASpk_goodsref,scm_invsku_b.sku_barcodeASbarcode,SELECTd.pk_deptdocASid,d.pk_deptdocASobjid,concat(concat(d.deptcode,'_'),p.unitcode)ASCODE,d.deptnameASname,d.deptshortnameASshortname,CASEWHENd.pk_calbodyISNULLORd.pk_calbody=''THENd.pk_fathedeptSELECTpk_cumandoc,pk_cubasdoc,pk_corp,dr,tsFROMbd_cumandocSELECTpk_cumandoc,pk_cubasdoc,pk_corp,dr,tsFROMbd_cumandocWHERESELECTbd_cubasdoc.pk_cubasdoc,bd_cubasdoc.pk_corp,bd_cumandoc.pk_corppk_corp1,pk_areaclASclassifyid,custcodecode,custnamename,custshortname,bd_cubasdoc.taxpayerid,bd_cubasdoc.registerfund,mnecode,SELECTDISTINCTbd_cubasdoc.pk_cubasdoc,bd_cubasdoc.pk_corp,bd_cubasdoc.pk_corp1,pk_areaclASclassifyid,custcodecode,custnamename,custshortname,SELECTbd_bankaccbas.pk_bankaccbasASid,bd_psnaccbank.pk_psnbasdocASstaff_id,bd_bankaccbas.creatorAScreator,bd_bankaccbas.createtimeAScreationtime,bd_bankaccbas.modifierASmodifier,bd_bankaccbas.modifytimeASmodifiedtime,SELECTbd_invbasdoc.pk_invbasdoc,bd_invbasdoc.pk_corp,pk_invcl,invcodeAScode,invnameASname,CASEWHENbd_invbasdoc.sealflag='Y'THEN'true'ELSE'false'ENDASstopstatus,invspec,需更新SQL需更新TSU8C刘云祥判断selectbd_glorgbook.glorgbookcodeascode,bd_glorgbook.glorgbooknameasname,bd_glorgbook.pk_glorgasaccentity,REPLACE(bd_subjscheme.subjcoderule,'/','-')assubjectcoderule,bd_subjscheme.memoasdescription,bd_glorgbook.pk_glorgbookasobjid,1asenable,'U8C_'+cast(bd_subjscheme.group_indexasCHAR(1))asaccelementbd_glorgbook.tsSELECTbd_accperiodscheme.accperiodschemecodeAScode,bd_accperiodscheme.accperiodschemenameASname,bd_accperiodscheme.memoASdescription,bd_accperiodscheme.pk_accperiodschemeASobjid,1ASperiodClass,bd_accperiod.periodnumASperiodcount,2ASperiodhcount,bd_accperiod.quarternumASperiodqcount,bd_accperiod.tsASpubts,bd_accperiod.tsSELECTbd_accperiodscheme.accperiodschemecodeASschemeCode,bd_accperiod.begindateASbegindate,bd_accperiod.periodyearAScode,bd_accperiod.enddateASenddate,bd_accperiod.periodyearASname,bd_accperiod.periodnumASnum,bd_accperiod.pk_accperiodASobjidFROMbd_accperiod.tsSELECTh.codeAScode,h.codeASname,h.accperiodschemeASschemeCode,h.periodyearASperiodyearCode,h.beginperiodASbeginperiodCode,b.endperiodASendperiodCode,h.objidASobjidFROM(会计期间【现有SQL】是正确的，不需要修改；【需更新SQL】是错误的；SELECTh.codeAScode,h.codeASname,h.accperiodschemeASschemeCode,h.periodyearASperiodyearCode,h.beginperiodASbeginperiodCode,b.endperiodASendperiodCode,h.objidASobjidFROM(SELECTtop100percentcode,name,'u8c'ASSOURCE,cashflowtype,mainattachedtable,directionattribute,objid,parent_id,pk_orgFROMSELECTbd_costsubj.pk_corpASaccentity,bd_costsubj.costcode+'_'+bd_corp.unitcodeAScode,bd_costsubj.costnameASname,bd_costsubj.pk_parentASparent,bd_costsubj.pk_costsubjASobjid,CASEbd_costsubj.sealflagWHEN'Y'THEN2ELSE1ENDASenabled,1ASlevelsSELECTbd_bdinfo.bdcodeAScode,CASEbd_bdinfo.bdcodeWHEN'1'THEN'personnel'WHEN'2'THEN'dept'WHEN'14'THEN'feeitem'WHEN'71'THEN'customer'WHEN'72'THEN'supplier'WHEN'96'THEN'finorgbankacct'SQL需要更新按照当前【需更新SQL】更新即可；SELECTbd_glorg.pk_entityorgASaccentity,s.typeASbookType,s.pk_startaccperiodASgl_startperiodid,s.isconvertASconvertable,s.glorgbooknameASname,s.glorgbookcodeAScode,s.pk_currrateschemeAScurrencySchema,s.pk_glorgbookASobjid,s.pk_glorgbookASaccsubjectchart,t.pk_main_currtypeAScurrency,t.pk_accperiodschemeASaccperiodscheme,'01'ASratetype_code,CASEWHENs.type=0THEN1ELSE2ENDASaccountingclassifi,CASEWHENs.isstartuse='Y'THEN'1'ELSE''SQL需要更新按照当前【需更新SQL】更新即可；SELECTpk_jobtypeobjid,pk_corporgId,jobtypecodecode,jobtypenamename,tssynchts,1ASenableFROMbd_jobtypeSELECTs.pk_bankaccbasASid,s.ts,s.tsASpubts,concat(s.accountcode,concat('_',(CASEWHENbd_corp.unitcodeISNULLORbd_corp.unitcode=''THENs.pk_corpELSEbd_corp.unitcodeSELECTbd_bankaccbas.pk_bankaccbasASid,bd_bankaccbas.accountcodeASaccount,bd_bankaccbas.accountcode+'_'+bd_corp.unitcodeAScode,bd_bankaccbas.accountnameASname,bd_bankaccbas.creatorAScreator,bd_bankaccbas.createtimeAScreationtime,bd_bankaccbas.modifierASmodifier,bd_bankaccbas.modifytimeASmodifiedtime,1ASenable,SELECTd.pk_defdocASid,d.pk_defdocASobjid,concat(d.doccode,concat('_',concat(l.doclistcode,concat('_',RIGHT(d.pk_defdoc,2)))))AScode,d.docnameASname,d.shortnameASshortname,d.pk_defdoc1ASparentid,SELECTbd_bankaccbas.pk_bankaccbasASid,bd_psnaccbank.pk_psnbasdocASstaff_id,bd_bankaccbas.creatorAScreator,bd_bankaccbas.createtimeAScreationtime,bd_bankaccbas.modifierASmodifier,bd_bankaccbas.modifytimeASmodifiedtime,bd_bankaccbas.pk_corpASbu_id,bd_bankaccbas.pk_banktypeASbank,SELECTbd_subjass.pk_subjassASid,bd_subjass.pk_subjassASobjid,bd_subjass.pk_accsubjASaccsubject,bd_subjass.pk_bdinfoASdimensionext,bd_accsubj.pk_glorgbookASaccsubjectchart,CASEWHENbd_subjass.isnonleafused='Y'THEN1ELSE0ENDASallownonleaf,CASEbd_subjass.tsSQL需要更新按照当前【需更新SQL】更新即可；SELECTbd_corp.pk_corpASid,bd_corp.pk_corpASobjid,bd_corp.unitcodeASCODE,bd_corp.unitnameASNAME,bd_corp.unitnameASshortname,CASEWHENbd_corp.isseal='Y'THEN2ELSE1SELECTd.pk_deptdocASid,d.pk_deptdocASobjid,concat(concat(d.deptcode,'_'),p.unitcode)ASCODE,d.deptnameASname,d.deptshortnameASshortname,CASEWHEN(d.pk_calbodyISNULLORd.pk_calbody='')THENtrim(d.pk_fathedept)ELSEtrim(d.pk_calbody)d.tsSELECTpsn.psncodeAScode,bas.psnnameASname,bas.mobile,bas.email,psn.pk_psndocASobjid,psn.pk_psnbasdocASstaff_id,psn.pk_corpASorg_id,psn.pk_deptdocASdept_id,SELECTscm_invsku_b.sku_codeAScode,scm_invsku_b.sku_nameASname,bd_invbasdoc.pk_invbasdocASproduct_code,bd_invbasdoc.invnameASproduct_name,scm_invsku.retailpriceASprice,scm_invsku_b.pk_invsku_bASobjid,scm_invsku_b.pk_invsku_bASpk_goodsref,scm_invsku_b.sku_barcodeASbarcode,SELECTd.pk_deptdocASid,d.pk_deptdocASobjid,concat(concat(d.deptcode,'_'),p.unitcode)ASCODE,d.deptnameASname,d.deptshortnameASshortname,CASEWHEN(d.pk_calbodyISNULLORd.pk_calbody='')THENtrim(d.pk_fathedept)d.tsSELECTpk_cumandoc,pk_cubasdoc,pk_corp,dr,tsFROMbd_cumandocSELECTpk_cumandoc,pk_cubasdoc,pk_corp,dr,tsFROMbd_cumandocWHERESELECTbd_cubasdoc.pk_cubasdoc,bd_cubasdoc.pk_corp,bd_cumandoc.pk_corppk_corp1,pk_areaclASclassifyid,custcodecode,custnamename,custshortname,bd_cubasdoc.taxpayerid,bd_cubasdoc.registerfund,mnecode,bd_cumandoc.tsSELECTbd_cubasdoc.pk_cubasdoc,bd_cubasdoc.pk_corpASpk_corp,bd_cumandoc.pk_corpASpk_corp1,pk_areaclASclassifyid,custcodecode,custnamename,custshortname,bd_cumandoc.tsSELECTbd_bankaccbas.pk_bankaccbasASid,bd_psnaccbank.pk_psnbasdocASstaff_id,bd_bankaccbas.creatorAScreator,bd_bankaccbas.createtimeAScreationtime,bd_bankaccbas.modifierASmodifier,bd_bankaccbas.modifytimeASmodifiedtime,SQL需要更新按照当前【需更新SQL】更新即可；SELECTbd_invbasdoc.pk_invbasdoc,bd_invbasdoc.pk_corp,pk_invcl,invcodeAScode,invnameASname,CASEWHENbd_invbasdoc.sealflag='Y'THEN'true'ELSE'false'ENDASstopstatus,invspec,bd_calbody.tss.ts备注（日期都是23年）最新SQL是8月19日更新SQL是7月13日更新日期3月16日8月25日更新8月19日更新8月5日更新7月13日更新3月16日更新核心3后台没找到这个视图，但是常见问题列表里有这个sql3月16更新4月5日更新3月16更新4月14更新4月14更新4月14更新4月14更新4月14更新4月15更新，但是后台管理是9月13修改的，以哪个为准？5月29从客户环境上获取
