凭证
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