leading-project/dw/dim/dim_meter_info_d.sql

11 lines
278 B
MySQL
Raw Permalink Normal View History

2024-07-21 22:06:45 +08:00
SELECT
MeterID -- 仪表id
, RoomID -- 房间id
, CommID -- 项目id
, MeterSign
, MeterName -- 表名称
, InitAmount -- 初始金额
, MeterType -- 仪表类型
, StanID -- 标准id
FROM ods_erp_tb_hspr_customermeter_d
where IsDelete = 0