chengben/Scripts/数据校验/check_04_zulin.sql

--又有铁塔又有第三方--输出报表
select 
station_sid as 局站ID,
station_sname as 局站名称,
city_name as 地市名称,
area_name as 区县名称,
property_type as 产权类型,
station_level as 局站等级,
tower_code as 资源系统铁塔站址编码,
ht_sid as 合同编码,
ht_sname as 合同名称,
ht_yuezujin as 合同月租金,
ht_cbzx as 合同成本中心,
site_addr_id as 铁塔站址编码,
tower_cost as 铁塔租金,
tower_name as 铁塔名称,
tower_cbzx as 铁塔成本中心,
zulin_type as 租赁类型校验
from sqmdb_cost.err_station_has_tw_3rd
order by sort_id_city