创建固定资产视图

create view V_T100深圳固定资产 as 
select distinct  faah001||'-'||faah003 as 卡片财产编号,
 faah001 as 卡片编号,faah003 as 财产编号,faah022 as 财产金额,faah018 as 财产数量,faah021 as 财产单价,
 faah012 as 财产名称, faah013 as 财产规格,faah025 as 现保管人员,t2.ooag011 as 保管人全名,faah029 as 现负责人员,t3.ooag011 as 负责人全名,faah027 as 财产位置,
faah014 as 取得日期,
 (case when faah005='1' then '1.有形资产' when faah005='2' then '2:无形资产' 
 when faah005='3' then '3:土地' when faah005='4' then '4:递耗资产' when faah005='5' then '5:费用' else '' end) as 财产类型,
  (case when faah015='0' then '0.取得' when faah015='1' then '1:资本化' when faah015='2' then '2:折旧中' 
 when faah015='3' then '3:外送/收回' when faah015='4' then '4:折毕' when faah015='5' then '5:出售' 
  when faah015='6' then '6:销帐/盘亏' when faah015='7' then '7:折毕再提' when faah015='8' then '8:停用'  
  when faah015='9' then '9:重估/调整/盘盈' when faah015='10' then '10:被资本化'
 else '11:拨出' end) as 财产状态,
 faaj034 as 处置成本,faaj019 as 预留残值
 from faah_t left join faaj_t on faah003=faaj001 and faaj037=faah001 and faajent=faahent
             left join ooag_t t2 on faah025=t2.ooag001 
             left join ooag_t t3 on faah029=t3.ooag001
  where faah032='SZ'  and faahstus='Y' AND faahent=100
 order by faah014