科目余额表代码
/**公司名称代码开始**/
Select t.* Into #AcctBal2569457n
From (
Select 0 FBalanceTotal,a.FAccountID,a.FNumber ,
convert(varchar(800),a.FName) FName,a.FLevel,a.FDC,a.FDetail,
a.FParentID,a.FRootID,Isnull(b.FDetailID,0) FDetailID,
ISNULL(FBeginBalanceFor,0) FBeginBalanceFor, ISNULL(FBeginBalance,0) FBeginBalanceLocal,
ISNULL(FEndBalanceFor,0) FEndBalanceFor, ISNULL(FEndBalance,0) FEndBalanceLocal,
ISNULL(FDebitFor,0) FDebit, ISNULL(FDebit,0) FDebitLocal, ISNULL(FCreditFor,0) FCredit,
ISNULL(FCredit,0) FCreditLocal, ISNULL(FYtdDebitFor,0) FYtdDebit, ISNULL(FYtdDebit,0) FYtdDebitLocal,
ISNULL(FYtdCreditFor,0) FYtdCredit, ISNULL(FYtdCredit,0) FYtdCreditLocal,
ISNULL(CASE WHEN FBeginBalanceFor > 0 THEN FBeginBalanceFor END,0) FBeginDebit,
ISNULL(CASE WHEN FBeginBalance > 0 THEN FBeginBalance END,0) FBeginDebitLocal,
ISNULL(CASE WHEN FBeginBalanceFor < 0 THEN -FBeginBalanceFor END,0) FBeginCredit,
ISNULL(CASE WHEN FBeginBalance < 0 THEN -FBeginBalance END,0) FBeginCreditLocal,
ISNULL(CASE WHEN FEndBalanceFor> 0 THEN FEndBalanceFor END,0) FEndDebit,
ISNULL(CASE WHEN FEndBalance> 0 THEN FEndBalance END,0) FEndDebitLocal,
ISNULL(CASE WHEN FEndBalanceFor < 0 THEN -FEndBalanceFor END,0) FEndCredit,
ISNULL(CASE WHEN FEndBalance < 0 THEN -FEndBalance END,0) FEndCreditLocal,
convert(varchar(800),'公司名称') 账套
From AIS20090905160608..t_Account a
LEFT OUTER JOIN (
Select * From AIS20090905160608..t_Balance
WHERE FCurrencyID=1 And FYear*100+FPeriod =@MyYear*100+@MyMon ) b On a.FAccountID = b.FAccountID
WHERE 1=1 AND (a.FGroupID<600 or a.FGroupID>=700) and ( a.FNumber like '2202%' or a.FNumber like '2241%' or a.FNumber like '2221%') ) t
Insert Into #AcctBal2569457n
( FBalanceTotal,FAccountID,FNumber ,FName,FLevel,
FDC,FDetail,FParentID,FRootID,FDetailID, FBeginBalanceFor,
FBeginBalanceLocal,FEndBalanceFor,FEndBalanceLocal, FDebit,
FDebitLocal, FCredit, FCreditLocal, FYtdDebit,FYtdDebitLocal,
FYtdCredit, FYtdCreditLocal, FBeginDebit, FBeginDebitLocal,
FBeginCredit, FBeginCreditLocal, FEndDebit,FEndDebitLocal,
FEndCredit, FEndCreditLocal,账套
)
Select distinct 0 FBalanceTotal,a.FAccountID,a.FNumber ,a.FName,
a.FLevel,a.FDC,a.FDetail,a.FParentID,a.FRootID,FDetailID=0,
0 FBeginBalanceFor,0 FBeginBalanceLocal,0 FEndBalanceFor,
0 FEndBalanceLocal,0 FDebit,0 FDebitLocal,0 FCredit,0 FCreditLocal,
0 FYtdDebit,0 FYtdDebitLocal,0 FYtdCredit, 0 FYtdCreditLocal,
0 FBeginDebit,0 FBeginDebitLocal,0 FBeginCredit,0 FBeginCreditLocal,
0 FEndDebit,0 FEndDebitLocal,0 FEndCredit,0 FEndCreditLocal,'公司名称'
From ( select distinct FNumber from (Select a.FNumber,a.FAccountID,a.FRootID,
Sum(e.FDC*e.FAmountFor) FDebit,Sum(e.FDC*e.FAmount) FDebitLocal ,
Sum((1-e.FDC)*e.FAmountFor) FCredit ,Sum((1-e.FDC)*e.FAmount) FCreditLocal
From AIS20090905160608..t_Voucher v,AIS20090905160608..t_VoucherEntry e,AIS20090905160608..t_Account a
Where v.FVoucherID=e.FVoucherID And e.FAccountID=a.FAccountID And v.FPosted=0
and ( a.FNumber like '2202%' or a.FNumber like '2241%' or a.FNumber like '2221%')
And ( FYear*100+FPeriod between @MyYear*100+@MyMon and @MyYear*100+@MyMon) And e.FCurrencyID=1
And (a.FGroupID<600 or a.FGroupID>=700) Group By a.FNumber,a.FAccountID,a.FRootID ) xyz ) v1,t_account a
where ( a.FNumber=v1.FNumber or v1.FNumber like a.FNumber+'.%')
and a.FNumber not in ( select FNumber from #AcctBal2569457n) And a.FLevel<=4 And (a.FGroupID<600 or a.FGroupID>=700)
UPDATE #AcctBal2569457n
Set FDebit=t.FDebit+e.FDebit , FDebitLocal=t.FDebitLocal+e.FDebitLocal ,
FCredit=t.FCredit+e.FCredit, FCreditLocal=t.FCreditLocal+e.FCreditLocal ,
FYtdDebit=t.FYtdDebit+e.FDebit , FYtdDebitLocal=t.FYtdDebitLocal+e.FDebitLocal ,
FYtdCredit=t.FYtdCredit+e.FCredit , FYtdCreditLocal=t.FYtdCreditLocal+e.FCreditLocal ,
FEndBalanceFor=(t.FEndBalanceFor+ e.FDebit - e.FCredit ) , FEndBalanceLocal=(t.FEndBalanceLocal+e.FDebitLocal - e.FCreditLocal)
From #AcctBal2569457n t
Inner join (
Select b.FNumber, b.FAccountID, b.FRootID,SUM(FDebit) FDebit,SUM(FDebitLocal) FDebitLocal,
SUM(FCredit) FCredit,SUM(FCreditLocal) FCreditLocal
from AIS20090905160608..t_Account b
inner join (
Select a.FNumber,a.FAccountID,a.FRootID,
Sum(e.FDC*e.FAmountFor) FDebit,Sum(e.FDC*e.FAmount) FDebitLocal ,
Sum((1-e.FDC)*e.FAmountFor) FCredit ,Sum((1-e.FDC)*e.FAmount) FCreditLocal
From AIS20090905160608..t_Voucher v,AIS20090905160608..t_VoucherEntry e,AIS20090905160608..t_Account a
Where v.FVoucherID=e.FVoucherID And e.FAccountID=a.FAccountID And v.FPosted=0
And ( FYear*100+FPeriod between @MyYear*100+@MyMon and @MyYear*100+@MyMon) And e.FCurrencyID=1
And (a.FGroupID<600 or a.FGroupID>=700)
Group By a.FNumber,a.FAccountID,a.FRootID
) t on (t.FNumber like b.FNumber+'.%' or t.FNumber = b.FNumber)
group by b.FNumber, b.FAccountID, b.FRootID
) e on t.FRootID=e.FRootID and t.FNumber =e.FNumber And t.FDetailID=0
Insert Into #AcctBal2569457n
( FBalanceTotal,FAccountID,FNumber ,FName,FLevel,FDC,FDetail,FParentID,FRootID,FDetailID,
FBeginBalanceFor,FBeginBalanceLocal,FEndBalanceFor,FEndBalanceLocal, FDebit, FDebitLocal,
FCredit, FCreditLocal, FYtdDebit,FYtdDebitLocal, FYtdCredit, FYtdCreditLocal, FBeginDebit,
FBeginDebitLocal, FBeginCredit, FBeginCreditLocal, FEndDebit,FEndDebitLocal, FEndCredit,
FEndCreditLocal,账套)
Select 0 FBalanceTotal,v1.FAccountID,a.FNumber ,a.FName,a.FLevel,a.FDC,a.FDetail,a.FParentID,a.FRootID,
v1.FDetailID,0 FBeginBalanceFor,0 FBeginBalanceLocal,0 FEndBalanceFor,0 FEndBalanceLocal,0 FDebit,
0 FDebitLocal,0 FCredit,0 FCreditLocal,0 FYtdDebit,0 FYtdDebitLocal,0 FYtdCredit, 0 FYtdCreditLocal,
0 FBeginDebit,0 FBeginDebitLocal,0 FBeginCredit,0 FBeginCreditLocal,0 FEndDebit,0 FEndDebitLocal,0 FEndCredit,
0 FEndCreditLocal,'公司名称'
From (
Select Distinct e.FAccountID,e.FDetailID
From AIS20090905160608..t_Voucher v,AIS20090905160608..t_VoucherEntry e,AIS20090905160608..t_Account a
Where v.FVoucherID=e.FVoucherID And e.FAccountID=a.FAccountID And v.FPosted=0
and ( a.FNumber like '2202%' or a.FNumber like '2241%' or a.FNumber like '2221%')
And e.FDetailID>0 And ( FYear*100+FPeriod between @MyYear*100+@MyMon and @MyYear*100+@MyMon)
And e.FCurrencyID=1 And (a.FGroupID<600 or a.FGroupID>=700) ) v1,AIS20090905160608..t_Account a
Where v1.FAccountID=a.FAccountID
And convert(varchar,v1.FAccountid) +','+ convert(varchar, v1.FDetailID) Not In
(Select convert(varchar,FAccountid) +','+ convert(varchar, FDetailID)
From AIS20090905160608..t_Balance Where FDetailID>0 And FCurrencyID=1 And ( FYear*100+FPeriod =@MyYear*100+@MyMon) )
UPDATE #AcctBal2569457n
Set FDebit=FDebit+t1.FDebit1, FDebitLocal=FDebitLocal+t1.FDebitLocal1, FCredit=FCredit+t1.FCredit1,
FCreditLocal=FCreditLocal+t1.FCreditLocal1, FYtdDebit=FYtdDebit+t1.FDebit1, FYtdDebitLocal=FYtdDebitLocal+t1.FDebitLocal1,
FYtdCredit=FYtdCredit+t1.FCredit1, FYtdCreditLocal=FYtdCreditLocal+t1.FCreditLocal1,
FEndBalanceFor=(FEndBalanceFor+t1.FDebit1 -t1.FCredit1) , FEndBalanceLocal=(FEndBalanceLocal+t1.FDebitLocal1 -t1.FCreditLocal1)
From (
Select d1,sum(FDebit1) FDebit1,sum(FCredit1) FCredit1,sum(FDebitLocal1) FDebitLocal1,sum(FCreditLocal1) FCreditLocal1
From (Select convert(varchar,a.FAccountid) +','+ convert(varchar, e.FDetailID) d1,
e.FDC*e.FAmountFor FDebit1,e.FDC*e.FAmount FDebitLocal1,(1-e.FDC)*e.FAmountFor FCredit1,(1-e.FDC)*e.FAmount FCreditLocal1
From AIS20090905160608..t_Voucher v,AIS20090905160608..t_VoucherEntry e, AIS20090905160608..t_Account a
Where v.FVoucherID=e.FVoucherID And e.FAccountID=a.FAccountID And v.FPosted=0
And e.FDetailID>0 And ( FYear*100+FPeriod between @MyYear*100+@MyMon and @MyYear*100+@MyMon) And e.FCurrencyID=1
And (a.FGroupID<600 or a.FGroupID>=700) ) t2 group by d1 ) t1
Where convert(varchar,FAccountid) +','+ convert(varchar, FDetailID)=d1
UPDATE #AcctBal2569457n
Set FEndDebit=ISNULL(CASE WHEN FEndBalanceFor> 0 THEN FEndBalanceFor END,0) ,
FEndDebitLocal=ISNULL(CASE WHEN FEndBalanceLocal> 0 THEN FEndBalanceLocal END,0) ,
FEndCredit=ISNULL(CASE WHEN FEndBalanceFor < 0 THEN -FEndBalanceFor END,0),
FEndCreditLocal=ISNULL(CASE WHEN FEndBalanceLocal < 0 THEN -FEndBalanceLocal END,0)
delete b from #AcctBal2569457n b
where b.FBeginCredit=0 and b.FBeginDebit=0 and FBeginCreditLocal=0
and b.FBeginDebitLocal=0 and b.FDebit=0 and b.FCredit=0 and b.FDebitLocal=0
and b.FCreditLocal=0 and b.FYtdDebit=0 and b.FYtdCredit=0 and b.FYtdDebitLocal=0
and b.FYtdCreditLocal=0 and b.FEndBalanceFor=0 and b.FEndBalanceLocal=0
UPDATE #AcctBal2569457n SET FName=Space(Flevel*2-2) + FName where len(isnull(FNumber,'')) >0 and FDetailID=0
Alter Table #AcctBal2569457n Add FItemNumber nvarchar(200) null
---exec sp_executesql N'Select FValue From t_SystemProfile Where FCategory = @P1 And FKey = @P2', N'@P1 varchar(30),@P2 varchar(30)', 'GL', 'LdgViewItemNumber'
Select t1.FDetailID,convert(nvarchar(800), '') FName,convert(nvarchar(800), '') FNumber Into #MultiItem2569457n
From AIS20090905160608..t_ItemDetail as t1
Inner join ( Select DistInct FDetailID From #AcctBal2569457n Where FDetailID >0) as t2 On t1.FDetailID=t2.FDetailID Where t1.FDetailID>0
---Select distinct c.FITEMCLASSID,c.Fnumber from t_Itemclass c, t_Itemdetailv v Where c.FItemClassID=v.FItemClassID and c.FType=1 and c.FItemclassID>0 order by c.Fnumber
/*应收账款**/
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
---From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f1 ) t Where FDetailID=t.F1
/**部门**/
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
---From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f2 ) t Where FDetailID=t.F1
/**职员类别**/
Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
From (Select FDetailID F1, FName FN,FNumber FNum From AIS20090905160608..t_Itemdetail a, AIS20090905160608..t_item b where b.FitemID>0 And b.FitemID=a.f3 ) t Where FDetailID=t.F1
/**物料类别**/
Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
From (Select FDetailID F1, FName FN,FNumber FNum From AIS20090905160608..t_Itemdetail a, AIS20090905160608..t_item b where b.FitemID>0 And b.FitemID=a.f4 ) t Where FDetailID=t.F1
/**应付账款**/
Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
From (Select FDetailID F1, FName FN,FNumber FNum From AIS20090905160608..t_Itemdetail a, AIS20090905160608..t_item b where b.FitemID>0 And b.FitemID=a.f8 ) t Where FDetailID=t.F1
/**
Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f10 ) t Where FDetailID=t.F1
**/
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
---From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f14 ) t Where FDetailID=t.F1
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800) From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f2003 ) t Where FDetailID=t.F1
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800) From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f2014 ) t Where FDetailID=t.F1
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
---From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f2024 ) t Where FDetailID=t.F1
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
---From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f3001 ) t Where FDetailID=t.F1
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
---From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f3002 ) t Where FDetailID=t.F1
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
---From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f3003 ) t Where FDetailID=t.F1
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
---From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f3004 ) t Where FDetailID=t.F1
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
---From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f3005 ) t Where FDetailID=t.F1
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
---From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f3006 ) t Where FDetailID=t.F1
Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
From (Select FDetailID F1, FName FN,FNumber FNum From AIS20090905160608..t_Itemdetail a, AIS20090905160608..t_item b where b.FitemID>0 And b.FitemID=a.f3007 ) t Where FDetailID=t.F1
---Update #MultiItem2569457n Set FName =Left(FName +'/'+ IsNull(t.FN,''),800),FNumber =Left(FNumber +'/'+ IsNull(t.FNum,''),800)
---From (Select FDetailID F1, FName FN,FNumber FNum From t_Itemdetail a, t_item b where b.FitemID>0 And b.FitemID=a.f3008 ) t Where FDetailID=t.F1
Update #MultiItem2569457n Set FName =STUFF(FName, 1, 1, ''),FNumber=STUFF(FNumber, 1, 1, '')
UPDATE #AcctBal2569457n Set FName=Space(Flevel*2-2 +4) + t1.n1 ,FItemNumber = left(t1.FNumber,200)
From (Select FDetailID d1 ,FName n1,FNumber From (Select * From #MultiItem2569457n ) t2 ) t1 Where FDetailID>0 AND FDetailID=t1.d1
UPDATE #AcctBal2569457n
Set FBeginDebit=case when fdc=1 then FBeginDebit-FBeginCredit else 0 end,
FBeginDebitLocal=case when fdc=1 then FBeginDebitLocal-FBeginCreditLocal else 0 end,
FBeginCredit=case when fdc=1 then 0 else FBeginCredit -FBeginDebit end,
FBeginCreditLocal=case when fdc=1 then 0 else FBeginCreditLocal -FBeginDebitLocal end,
FEndDebit=case when fdc=1 then FEndDebit-FEndCredit else 0 end,
FEndDebitLocal=case when fdc=1 then FEndDebitLocal-FEndCreditLocal else 0 end,
FEndCredit=case when fdc=1 then 0 else FEndCredit -FEndDebit end,
FEndCreditLocal=case when fdc=1 then 0 else FEndCreditLocal -FEndDebitLocal end where FBalanceTotal<>-1
UPDATE #AcctBal2569457n Set FBeginDebit=-FBeginCredit,FBeginCredit=0 where FBeginCredit<0 and FBalanceTotal<>-1
UPDATE #AcctBal2569457n Set FBeginDebitLocal=-FBegincreditLocal ,FBeginCreditLocal=0 where fBegincreditlocal<0 and FBalanceTotal<>-1
UPDATE #AcctBal2569457n Set FBeginCredit=-FBeginDebit,FBeginDebit=0 where FBeginDebit<0 and FBalanceTotal<>-1
UPDATE #AcctBal2569457n Set FBeginCreditLocal=-FBegindeBitLocal,FBeginDebitLocal=0 where FBegindebitlocal<0 and FBalanceTotal<>-1
UPDATE #AcctBal2569457n Set FEndDebit=-FEndCredit,FendCredit=0 where fendcredit<0 and FBalanceTotal<>-1
UPDATE #AcctBal2569457n Set FEndDebitlocal=-FEndCreditLocal ,FEndCreditLocal=0 where FEndCreditlocal<0 and FBalanceTotal<>-1
UPDATE #AcctBal2569457n Set FEndCredit=-FEndDebit,FEndDebit=0 where FEndDebit<0 and FBalanceTotal<>-1
UPDATE #AcctBal2569457n Set FEndCreditlocal=-FEndDebitlocal,FEndDebitLocal=0 where FEndDebitlocal<0 and FBalanceTotal<>-1
insert into #AcctBal2569457n
(FBalanceTotal,FAccountID,FNumber ,FName,FLevel,FDC,FDetail,FParentID,FRootID,FDetailID,FBeginBalanceFor,
FBeginBalanceLocal,FEndBalanceFor,FEndBalanceLocal,FDebit, FDebitLocal,FCredit, FCreditLocal,FYtdDebit,
FYtdDebitLocal,FYtdCredit,FYtdCreditLocal,FBeginDebit,FBeginDebitLocal,FBeginCredit,FBeginCreditLocal,
FEndDebit,FEndDebitLocal, FEndCredit,FEndCreditLocal,账套)
Select -1 FBalanceTotal,0 FAccountID,'ZZ' FNumber ,'总计' FName,1 FLevel,1 FDC,1 FDetail,0 FParentID,0 FRootID,0 FDetailID, 0 FBeginBalanceFor,
0 FBeginBalanceLocal, 0 FEndBalanceFor, 0 FEndBalanceLocal, ISNULL(sum(FDebit),0) FDebit, ISNULL(sum(FDebitLocal),0) FDebitLocal,
ISNULL(sum(FCredit),0) FCredit, ISNULL(sum(FCreditLocal),0) FCreditLocal, ISNULL(sum(FYtdDebit),0) FYtdDebit,
ISNULL(sum(FYtdDebitLocal),0) FYtdDebitLocal, ISNULL(sum(FYtdCredit),0) FYtdCredit, ISNULL(sum(FYtdCreditLocal),0) FYtdCreditLocal,
ISNULL(Sum(FBeginDebit),0) FBeginDebit, ISNULL(Sum(FBeginDebitLocal),0) FBeginDebitLocal, ISNULL(Sum(FBeginCredit),0) FBeginCredit,
ISNULL(Sum(FBeginCreditLocal),0) FBeginCreditLocal, ISNULL(Sum(FEndDebit),0) FEndDebit, ISNULL(Sum(FEndDebitLocal),0) FEndDebitLocal,
ISNULL(Sum(FEndCredit),0) FEndCredit, ISNULL(Sum(FEndCreditLocal),0) FEndCreditLocal,'公司名称'
From #AcctBal2569457n b
INNER JOIN AIS20090905160608..t_Account a ON a.FAccountID=b.FAccountID
Where a.FDetail =1 and b.FDetailID =0 AND b.FBalanceTotal=0
insert Into #tAllBal
Select b.* ,FDetailIDOrder =( CASE b.FDetailID WHEN 0 THEN 0 ELSE 1 END) From #AcctBal2569457n b WHERE 1=1 AND b.FLevel<= 4
Order By b.FNumber,FDetailIDOrder,b.FName
Drop table #AcctBal2569457n
drop table #MultiItem2569457n
/**公司名称代码结束**/