T3結(jié)轉(zhuǎn)固定資產(chǎn)報(bào)錯(cuò)：列名或所提供值的數(shù)目與表定義不匹配
發(fā)布時(shí)間：2025-1-20
人工客服
特價(jià)活動(dòng):>>>> 用友U8、T6、T+、T3軟件產(chǎn)品4折優(yōu)惠，暢捷通T+cloud、好會(huì)計(jì)、易代賬、好業(yè)財(cái)、好生意云產(chǎn)品6-8折優(yōu)惠。
T3結(jié)轉(zhuǎn)固定資產(chǎn)報(bào)錯(cuò)：列名或所提供值的數(shù)目與表定義不匹配
通用腳本：
對(duì)上下兩個(gè)年度執(zhí)行
update accinformation set cvalue='8.216' where csysid='AA' and cid='99'
drop
table
rpt_flddef,rpt_fltdef,rpt_glbdef,rpt_grpdef,rpt_reldef,rpt_folder,rpt_itmdef
select * into rpt_flddef from UFDATA_999_2011..rpt_flddef
select * into rpt_fltdef from UFDATA_999_2011..rpt_fltdef
select * into rpt_glbdef from UFDATA_999_2011..rpt_glbdef5
select * into rpt_grpdef from UFDATA_999_2011..rpt_grpdef
select * into rpt_reldef from UFDATA_999_2011..rpt_reldef
select * into rpt_folder from UFDATA_999_2011..rpt_folder
select * into rpt_itmdef from UFDATA_999_2011..rpt_itmdef
alter table RPT_FldDEF drop column CurGroupCol,CurSubTotalCol
