create or replace view vw_ba_brssxx as
select LSH000,
       SSM000,
       SSMC00,
       SSLB00,
       ssxh00 XH0000,   --排序号
       SSRQ00,
       SSSJ00,
       SSZL00,
       SSYSMC,
       IYSMC0,
       IIYSMC,
       MZFS00,
       QKYHDJ,
       MZYSMC
  from BA_BRSSXX p
;