SELECT
      br.TRM_BUSINESS_UNIT_ID     AS trm_id,       -- 这个填进 TBU_ID 列
      br.REGION_ID                AS brand_region_id,
      si.CLIENTSTANDARDSETTLEMENTID AS si_id,
      si.SETTLEMENTCODE           AS si_code,
      si.CLIENTSELLSCCY           AS ccy,
      si.USE_VIRTUAL_ACCOUNT,
      si.PAYMENT_METHOD
  FROM DFX.BRAND_REGION br
  JOIN DATAELA.CLIENTSTANDARDSETTLEMENT si
      ON si.BRAND_REGION_ID = br.REGION_ID
  WHERE si.CLIENTSELLSCCY = 'GBP'
    AND si.BANK_ACCOUNT_ID = 80596
  ORDER BY br.TRM_BUSINESS_UNIT_ID, si.CLIENTSTANDARDSETTLEMENTID


#xe
 
 
Back to Top