Feature #36
Đào tạo 22 -07
Start date:
07/22/2020
Due date:
% Done:
0%
Estimated time:
History
#1 Updated by Luc Tran Van almost 5 years ago
- Tracker changed from Bug to Feature
#2 Updated by Luc Tran Van almost 5 years ago
- File STORE LIVE.txt STORE LIVE.txt added
#3 Updated by Luc Tran Van almost 5 years ago
#4 Updated by Luc Tran Van almost 5 years ago
- File 2207 FILE 2.txt 2207 FILE 2.txt added
#5 Updated by Luc Tran Van almost 5 years ago
- File 2207 FILE 5.txt 2207 FILE 5.txt added
#6 Updated by Luc Tran Van almost 5 years ago
- File 2207 FILE 8.txt 2207 FILE 8.txt added
#7 Updated by Luc Tran Van almost 5 years ago
IF
BEGIN
DECLARE @AMT_AD_PAY DECIMAL =0
DECLARE @AMT_AD_PAY_BACK DECIMAL =0
DECLARE @AMT_AD_PAY_REMAIN DECIMAL =0
SET @AMT_AD_PAY = (SELECT SUM) FROM TR_REQ_ADVANCE_PAYMENT WHERE REF_ID=@p_MAKER_ID AND AUTH_STATUS_KT='A' AND REQ_TYPE ='I')
SET @AMT_AD_PAY_BACK = (SELECT SUM +SUM - SUM (D.AMT_ADD)
FROM TR_REQ_PAYMENT_DT D
LEFT JOIN TR_REQ_ADVANCE_PAYMENT X ON D.PAY_ADV_ID = X.REQ_PAY_ID AND D.AUTH_STATUS_KT ='A'
WHERE X.REF_ID =@p_REF_ID)
SET @AMT_AD_PAY_REMAIN =ISNULL -ISNULL
SET @p_REQ_TEMP_AMT =ISNULL
END
#8 Updated by Luc Tran Van almost 5 years ago
- File 2207 FILE 9.txt 2207 FILE 9.txt added
#9 Updated by Luc Tran Van almost 5 years ago
- File 2207 FILE 10.txt 2207 FILE 10.txt added
#10 Updated by Luc Tran Van almost 5 years ago
- File 2207 FILE 12.txt 2207 FILE 12.txt added
#11 Updated by Luc Tran Van almost 5 years ago
- File 2207 FILE 14.txt 2207 FILE 14.txt added
#12 Updated by Luc Tran Van almost 5 years ago
- File 2207 FILE 15.txt 2207 FILE 15.txt added
#13 Updated by Luc Tran Van almost 5 years ago
- File 2207 FILE 18.txt 2207 FILE 18.txt added
#14 Updated by Luc Tran Van over 4 years ago
- Status changed from New to Closed