18
2024
05

用友手工导出数据千户税友软件

凭证

select 

 year(dbill_date),iperiod,csign,ino_id,inid,year(dbill_date)*10000+month(dbill_date)*100+day(dbill_date),cdigest,

ccode,md,mc,'',md_f,mc_f,ccheck,cbill,cbook ,ccashier ,idoc

 from gl_accvouch where dbill_date>='2023-01-01' and dbill_date<='2023-12-31' and inid<>0

and iperiod <=12

order by dbill_date,ino_id,inid


科目表:

select '2023',ccode,ccode_name,

case   cclass_engl when 'ZC' then 1  

when 'FZ' THEN 2

WHEN 'GT' THEN 3

WHEN 'QY' THEN 4

WHEN 'CB' THEN 5

WHEN 'SY' THEN 7

ELSE 9 END ,9, case when len(ccode) = 4  then '' else left (ccode,len(ccode) - 2) end


 from code where iyear = 2023



order  by ccode


余额表:

select 2023,iperiod,ccode,md,mc from gl_accsum where iyear = 2023 and iperiod = 1


« 上一篇 下一篇 »

发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。