invoice.txt
| 1 |
ALTER PROC [dbo].[rpt_TR_REQ_PAY_INVOICE_ByID_KT] |
|---|---|
| 2 |
@p_REQ_PAY_ID VARCHAR(15) = NULL |
| 3 |
AS |
| 4 |
BEGIN |
| 5 |
SELECT ROW_NUMBER() OVER (ORDER BY A.REQ_PAYDT_ID) AS STT, |
| 6 |
BR.BRANCH_CODE BRANCH_CODE, |
| 7 |
BR.BRANCH_NAME BRANCH_NAME, |
| 8 |
US.TLFullName TLFNAME, |
| 9 |
A.VAT VAT, |
| 10 |
A.TRANS_NO TRANS_NO, |
| 11 |
CONVERT(VARCHAR(20),A.TRANS_DT) TRANS_DT, |
| 12 |
A.INVOICE_SIGN INVOICE_SIGN, |
| 13 |
A.INVOICE_NO_SIGN INVOICE_NO_SIGN, |
| 14 |
A.INVOICE_NO INVOICE_NO, |
| 15 |
CONVERT(VARCHAR(20),FORMAT(CONVERT(DATE,A.INVOICE_DT,103), 'dd/MM/yyyy')) INVOICE_DT, |
| 16 |
A.SELLER SELLER, |
| 17 |
A.TAX_NO TAX_NO, |
| 18 |
A.GOODS_NAME GOODS_NAME, |
| 19 |
A.PRICE PRICE, |
| 20 |
A.TAX TAX, |
| 21 |
CASE WHEN A.TYPE_VAT = '0' THEN '353200001' ELSE '353200002' END AS ACC, |
| 22 |
A.TOTAL_AMT_KT AS TOTAL_AMT |
| 23 |
FROM TR_REQ_PAY_INVOICE A |
| 24 |
LEFT JOIN TR_REQ_PAYMENT B ON A.REQ_PAY_ID = B.REQ_PAY_ID |
| 25 |
LEFT JOIN CM_BRANCH BR ON B.BRANCH_ID = BR.BRANCH_ID |
| 26 |
LEFT JOIN TL_USER US ON B.MAKER_ID = US.TLNANME |
| 27 |
WHERE 1=1 |
| 28 |
AND (@p_REQ_PAY_ID = A.REQ_PAY_ID) |
| 29 |
AND ((A.MAKER_ID_KT IS NOT NULL AND A.MAKER_ID_KT <>'' AND A.TYPE_FUNC='KT') OR ((A.MAKER_ID_KT IS NULL OR A.MAKER_ID_KT ='') AND A.TYPE_FUNC='HC')) AND A.TAX >0 |
| 30 |
END |