|
1
|
SELECT A.REQ_PAY_CODE,A.REQ_REASON AS NOI_DUNG, A.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG,
|
|
2
|
CONVERT(VARCHAR,DAY(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,MONTH(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.TRANSFER_DT),2) AS NGAY_NHAN_PHIEU,
|
|
3
|
A.MAKER_ID_KT AS GDV,
|
|
4
|
CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET,
|
|
5
|
A.CHECKER_ID_KT AS KSV,
|
|
6
|
CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
|
|
7
|
FROM TR_REQ_PAYMENT A
|
|
8
|
WHERE 1=1
|
|
9
|
AND ((A.TRANSFER_DT >='2022-7-1' AND A.TRANSFER_DT <='2022-12-31')
|
|
10
|
OR (A.CREATE_DT_KT >='2022-7-1' AND A.CREATE_DT_KT <='2022-12-31')
|
|
11
|
OR (A.APPROVE_DT_KT >='2022-7-1' AND A.APPROVE_DT_KT <='2022-12-31'))
|
|
12
|
AND A.AUTH_STATUS ='A'
|
|
13
|
|
|
14
|
UNION
|
|
15
|
|
|
16
|
SELECT A.REQ_PAY_CODE,A.REQ_REASON AS NOI_DUNG, A.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG,
|
|
17
|
CONVERT(VARCHAR,DAY(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,MONTH(A.TRANSFER_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.TRANSFER_DT),2) AS NGAY_NHAN_PHIEU,
|
|
18
|
A.MAKER_ID_KT AS GDV,
|
|
19
|
CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET,
|
|
20
|
A.CHECKER_ID_KT AS KSV,
|
|
21
|
CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
|
|
22
|
|
|
23
|
FROM TR_REQ_ADVANCE_PAYMENT A
|
|
24
|
WHERE 1=1
|
|
25
|
AND ((A.TRANSFER_DT >='2022-7-1' AND A.TRANSFER_DT <='2022-12-31')
|
|
26
|
OR (A.CREATE_DT_KT >='2022-7-1' AND A.CREATE_DT_KT <='2022-12-31')
|
|
27
|
OR (A.APPROVE_DT_KT >='2022-7-1' AND A.APPROVE_DT_KT <='2022-12-31'))
|
|
28
|
AND A.AUTH_STATUS ='A'
|
|
29
|
|
|
30
|
---202297
|
|
31
|
---202298
|