Project

General

Profile

Feature #1436

VẬN HÀNH SAU GOLIVE NGÀY 12-01-2023

Added by Luc Tran Van over 2 years ago. Updated over 2 years ago.

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
01/12/2023
Due date:
% Done:

0%

Estimated time:
Update số tiền hợp đồng mua sắm.txt (1.96 KB) Update số tiền hợp đồng mua sắm.txt Luc Tran Van, 01/12/2023 10:01 AM
advance_serach_120123.txt (54.7 KB) advance_serach_120123.txt Luc Tran Van, 01/12/2023 10:12 AM
adv_search_2.txt (103 KB) adv_search_2.txt Luc Tran Van, 01/12/2023 10:17 AM
CM_HANGHOA_Ins.txt (5.09 KB) CM_HANGHOA_Ins.txt Luc Tran Van, 01/12/2023 10:30 AM
CM_HANGHOA_Upd.txt (4.53 KB) CM_HANGHOA_Upd.txt Luc Tran Van, 01/12/2023 10:30 AM
advance_serach_120123.txt (55 KB) advance_serach_120123.txt Luc Tran Van, 01/12/2023 10:46 AM
adv_search_2.txt (103 KB) adv_search_2.txt Luc Tran Van, 01/12/2023 10:48 AM
CM_HANGHOA_Search.txt (6.4 KB) CM_HANGHOA_Search.txt Luc Tran Van, 01/12/2023 11:28 AM
notifi_id.txt (106 KB) notifi_id.txt Luc Tran Van, 01/12/2023 11:45 AM
Cập nhật store sendapp XDCB.txt (1.32 KB) Cập nhật store sendapp XDCB.txt Luc Tran Van, 01/12/2023 11:46 AM
Cập nhật store ins XDCB.txt (20.4 KB) Cập nhật store ins XDCB.txt Luc Tran Van, 01/12/2023 11:46 AM
Cập nhật store upd XDCB.txt (19.6 KB) Cập nhật store upd XDCB.txt Luc Tran Van, 01/12/2023 11:46 AM
UAT_TOOLKH_BVB.zip (1.24 MB) UAT_TOOLKH_BVB.zip Luc Tran Van, 01/12/2023 03:20 PM
DATA_TTCT_0060.xlsx (20.1 KB) DATA_TTCT_0060.xlsx Luc Tran Van, 01/12/2023 03:50 PM
DATA_TTCT_0059.xlsx (25.3 KB) DATA_TTCT_0059.xlsx Luc Tran Van, 01/12/2023 03:50 PM
DATA PHONG #11.xlsx (767 KB) DATA PHONG #11.xlsx Luc Tran Van, 01/12/2023 04:12 PM
DATA_TTCT_0060.xlsx (36.9 KB) DATA_TTCT_0060.xlsx Luc Tran Van, 01/12/2023 04:18 PM
DATA PHONG #16.xlsx (14.4 KB) DATA PHONG #16.xlsx Luc Tran Van, 01/12/2023 05:07 PM
DATA PHONG_LIVE #16.xlsx (14.6 KB) DATA PHONG_LIVE #16.xlsx Luc Tran Van, 01/12/2023 05:14 PM
DATA 00032022TTr-0692105.xlsx (9.73 KB) DATA 00032022TTr-0692105.xlsx Luc Tran Van, 01/13/2023 10:06 AM
ADVANCE_UPD_130123.txt (54.2 KB) ADVANCE_UPD_130123.txt Luc Tran Van, 01/13/2023 03:48 PM

History

#11 Updated by Luc Tran Van over 2 years ago

SELECT am.ASSET_CODE, am.AMORTIZED_MONTH, am.AMORTIZED_AMT,am.ASS_STATUS FROM ASS_MASTER am

#16 Updated by Luc Tran Van over 2 years ago

SELECT * FROM dbo.ASS_AMORT

#19 Updated by Luc Tran Van over 2 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0003/2022/TTr-0692105')
SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT GOODS_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT FR_GOOD_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
SELECT * FROM CM_GOODSTYPE
SELECT * FROM PL_TRADEDETAIL_HIST WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =@REQ_ID

#21 Updated by Luc Tran Van over 2 years ago

0003/2023/TTr-06906022

#22 Updated by Luc Tran Van over 2 years ago

0003/2023/TTr-06906022

#23 Updated by Luc Tran Van over 2 years ago

DECLARE @REQ_ID VARCHAR
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0003/2023/TTr-06906022')
SELECT * FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID
SELECT * FROM PL_PROCESS WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT TRADE_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
SELECT * FROM PL_TRADEDETAIL WHERE TRADE_ID IN (SELECT FR_TRADE_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT GOODS_ID FROM PL_REQUEST_DOC_DT WHERE REQ_ID =@REQ_ID)
SELECT * FROM CM_GOODS WHERE GD_ID IN (SELECT FR_GOOD_ID FROM PL_REQUEST_TRANSFER WHERE REQ_DOC_ID =@REQ_ID)
SELECT * FROM CM_GOODSTYPE
SELECT * FROM PL_TRADEDETAIL_HIST WHERE REQ_ID =@REQ_ID
SELECT * FROM PL_REQUEST_COSTCENTER WHERE REQ_ID =@REQ_ID

Also available in: Atom PDF