EXPORT NGÂN SÁCH CHI PHÍ.txt
| 1 |
DECLARE @listTRADE_TRANSFER TABLE |
|---|---|
| 2 |
( |
| 3 |
GOODS_ID VARCHAR(20), |
| 4 |
TRADE_ID VARCHAR(20), |
| 5 |
PLAN_ID VARCHAR(20), |
| 6 |
AMT_APP DECIMAL(18,2), |
| 7 |
AMT_EXE DECIMAL (18,2), |
| 8 |
AMT_ETM DECIMAL (18,2), |
| 9 |
AMT_TF DECIMAL (18,2), |
| 10 |
AMT_RECEIVE_TF DECIMAL (18,2) |
| 11 |
) |
| 12 |
INSERT INTO @listTRADE_TRANSFER SELECT DISTINCT TO_GOOD_ID, TO_TRADE_ID,TO_PLAN_ID,TO_AMT_APP,TO_AMT_EXE, TO_AMT_ETM, TO_AMT_TF, TO_AMT_RECEIVE_TF FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID ='PLRD00000207183' |
| 13 |
SELECT * FROM @listTRADE_TRANSFER |
| 14 |
EXEC rpt_PL_REQUEST_DOC_DT_ById 'PLRD00000207183' |