Untitled

-- case 1 Create By โดยปกติ MIT PC2 เป็นผู้ Create ส่ง mail    ทำไมใน Report ถึงไม่เป็น MTI_PC2  ตอบ = query ตาม XCUST_STATEMENT_HDR_TBL.CREATE_BY
    
-- case 2 ทำไมใน 1 Report เลขที่ statement เดีววกันถึงมีหลายบรรทัด  และ Email ถึงแยกบรรทัด
SELECT
    a.ID AS ID,
    a.REQUEST_ID AS REQUEST_ID,
    a.EMAIL AS EMAIL,
    a.STATUS AS STATUS,
    a.SEND_DATE AS SEND_DATE,
    b.STATEMENT_NUMBER AS STATEMENT_NUMBER,
    b.STATEMENT_DATE AS STATEMENT_DATE,
    b.PAYMENT_DUE_DATE AS PAYMENT_DUE_DATE,
    b.CUSTOMER_NAME AS CUSTOMER_NAME,
    b.CUSTOMER_NUMBER AS CUSTOMER_NUMBER,
    b.SITE_NUMBER AS SITE_NUMBER,
    b.CREATE_BY AS CREATE_BY,
    b.CUSTOMER_CLASS AS CUSTOMER_CLASS,
    b.BRANCH AS BRANCH,
    b.CREATE_DATE AS CREATE_DATE,
    b.STATEMENT_ID AS STATEMENT_ID,
    c.ATTRIBUTE7 AS D_CHANNEL
FROM XCUST_STATEMENT_EMAIL_LOG_TBL a
         LEFT JOIN XCUST_STATEMENT_HDR_TBL b ON b.REQUEST_ID = a.REQUEST_ID
         LEFT JOIN XCUST_CUSTOMER_MST_TBL c ON c.ACCOUNT_NUMBER = b.CUSTOMER_NUMBER
WHERE 1=1
  AND b.BU_ID = 300000002064001
  AND b.CUSTOMER_CLASS = 'AGENT'
  AND b.SITE_NUMBER = '74000592'
ORDER BY b.CREATE_DATE ASC, b.STATEMENT_NUMBER ASC;

-- case 3 ทำไม Branch  แสดงบ้างไม่แสดงบ้าง ตอบ = เพราะมันไม่มี

-- case 4 Agent  Inhouse และ broker  ยังไม่สามารถ test ได้ ไม่มีข้อมูลออก
SELECT
    a.REQUEST_ID AS REQUEST_ID,
    a.EMAIL AS EMAIL,
    a.STATUS AS STATUS,
    a.SEND_DATE AS SEND_DATE,
    b.CUSTOMER_SUB_CLASS,
    b.STATEMENT_NUMBER AS STATEMENT_NUMBER,
    b.STATEMENT_DATE AS STATEMENT_DATE,
    b.PAYMENT_DUE_DATE AS PAYMENT_DUE_DATE,
    b.CUSTOMER_NAME AS CUSTOMER_NAME,
    b.CUSTOMER_NUMBER AS CUSTOMER_NUMBER,
    b.SITE_NUMBER AS SITE_NUMBER,
    b.CREATE_BY AS CREATE_BY,
    b.CUSTOMER_CLASS AS CUSTOMER_CLASS,
    b.BRANCH AS BRANCH,
    b.CREATE_DATE AS CREATE_DATE,
    b.STATEMENT_ID AS STATEMENT_ID,
    c.ATTRIBUTE7 AS D_CHANNEL
FROM XCUST_STATEMENT_EMAIL_LOG_TBL a
         LEFT JOIN XCUST_STATEMENT_HDR_TBL b ON b.REQUEST_ID = a.REQUEST_ID
         LEFT JOIN XCUST_CUSTOMER_MST_TBL c ON c.ACCOUNT_NUMBER = b.CUSTOMER_NUMBER
WHERE 1=1
  AND b.BU_ID = 300000002064001
  AND b.CUSTOMER_CLASS = 'AGENT'
  AND b.CUSTOMER_SUB_CLASS = 'BROKER'
ORDER BY b.CREATE_DATE ASC, b.STATEMENT_NUMBER ASC;