|
1
|
SELECT A.REQ_PAY_CODE, A.MAKER_ID AS NGUOI_TAO, B.BRANCH_CODE AS MA_DV_TAO, B.BRANCH_NAME AS TEN_DV_TAO,A.REQ_AMT AS SO_TIEN,
|
|
2
|
CASE WHEN A.REQ_TYPE ='I' THEN N'Thanh toán hoàn tạm ứng' WHEN A.REQ_TYPE ='P' THEN N'Thanh toán nhà cung cấp'
|
|
3
|
ELSE N'Thanh toán khác' END AS N'LOẠI_THANH_TOÁN',
|
|
4
|
A.MAKER_ID_KT AS GDV, A.CHECKER_ID_KT AS KSV, A.CONFIRM_NOTE AS N'Ý KIẾN KT', 'TT' AS LOẠI_PHIẾU FROM TR_REQ_PAYMENT A
|
|
5
|
LEFT JOIN CM_BRANCH B ON A.BRANCH_CREATE = B.BRANCH_ID
|
|
6
|
WHERE A.AUTH_STATUS_KT ='A' AND CONVERT(DATE, A.APPROVE_DT_KT, 103) >= '2021-07-01'
|
|
7
|
AND CONVERT(DATE, A.APPROVE_DT_KT, 103) <= '2021-10-01' AND A.CONFIRM_NOTE IS NOT NULL AND A.CONFIRM_NOTE <> ''
|
|
8
|
UNION
|
|
9
|
SELECT A.REQ_PAY_CODE, A.MAKER_ID AS NGUOI_TAO, B.BRANCH_CODE AS MA_DV_TAO, B.BRANCH_NAME AS TEN_DV_TAO,A.REQ_AMT AS SO_TIEN,
|
|
10
|
CASE WHEN A.REQ_TYPE ='I' THEN N'Thanh toán hoàn tạm ứng' WHEN A.REQ_TYPE ='P' THEN N'Thanh toán nhà cung cấp'
|
|
11
|
ELSE N'Thanh toán khác' END AS N'LOẠI_THANH_TOÁN',
|
|
12
|
A.MAKER_ID_KT AS GDV, A.CHECKER_ID_KT AS KSV, A.CONFIRM_NOTES AS N'Ý KIẾN KT', 'TU' AS LOẠI_PHIẾU FROM TR_REQ_ADVANCE_PAYMENT A
|
|
13
|
LEFT JOIN CM_BRANCH B ON A.BRANCH_CREATE = B.BRANCH_ID
|
|
14
|
WHERE A.AUTH_STATUS_KT ='A' AND CONVERT(DATE, A.APPROVE_DT_KT, 103) >= '2021-07-01'
|
|
15
|
AND CONVERT(DATE, A.APPROVE_DT_KT, 103) <= '2021-10-01' AND A.CONFIRM_NOTES IS NOT NULL AND A.CONFIRM_NOTES <> ''
|
|
16
|
|
|
17
|
UPDATE TR_REQ_ADVANCE_PAYMENT SET AUTH_STATUS ='A', AUTH_STATUS_KT ='A', CREATE_DT_KT ='2016-11-25', APPROVE_DT ='2016-11-25', CREATE_DT ='2016-11-25',
|
|
18
|
APPROVE_DT_KT ='2016-11-25', MAKER_ID_KT ='admin', CHECKER_ID_KT ='admin', CHECKER_ID ='admin' WHERE REQ_PAY_CODE ='NCC.2021.000801'
|
|
19
|
|
|
20
|
---2021101
|