Project

General

Profile

Feature #1434

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

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

Status:
New
Priority:
Normal
Assignee:
-
Start date:
01/05/2023
Due date:
% Done:

0%

Estimated time:
DATA_TTCT_01.xlsx (28 KB) DATA_TTCT_01.xlsx Luc Tran Van, 01/05/2023 09:39 AM
CM_ALLCODE đánh giá NCC.txt (307 Bytes) CM_ALLCODE đánh giá NCC.txt Luc Tran Van, 01/05/2023 09:59 AM
REQ_KPI-0da26418-9477-43b0-9eb7-018305d6930b.xlsx (24.3 KB) REQ_KPI-0da26418-9477-43b0-9eb7-018305d6930b.xlsx Luc Tran Van, 01/05/2023 10:05 AM
DATA_TTCT_02.xlsx (23.8 KB) DATA_TTCT_02.xlsx Luc Tran Van, 01/05/2023 10:31 AM
1.0 [FN_CHECK_LIMIT_TR_REQ].txt (2.15 KB) 1.0 [FN_CHECK_LIMIT_TR_REQ].txt Luc Tran Van, 01/05/2023 10:47 AM
PL_REQ_PROCESS_CHILD_App.txt (48.2 KB) PL_REQ_PROCESS_CHILD_App.txt Luc Tran Van, 01/05/2023 10:51 AM
Data #8.xlsx (9.69 KB) Data #8.xlsx Luc Tran Van, 01/05/2023 02:25 PM
PL_IMPORT_App.txt (14 KB) PL_IMPORT_App.txt Luc Tran Van, 01/05/2023 03:50 PM
PL_REQ_PROCESS_CHILD_App.txt (48.2 KB) PL_REQ_PROCESS_CHILD_App.txt Luc Tran Van, 01/05/2023 07:16 PM
a.txt (12.6 KB) a.txt Luc Tran Van, 01/06/2023 10:26 AM
advance_upd_060122.txt (53.9 KB) advance_upd_060122.txt Luc Tran Van, 01/06/2023 10:31 AM
ab.txt (12.6 KB) ab.txt Luc Tran Van, 01/06/2023 11:08 AM
paymentdt_contract_byid.txt (4.15 KB) paymentdt_contract_byid.txt Luc Tran Van, 01/06/2023 11:12 AM
TH_TANG_GIAM_TAI_SAN_BanViet.xlsx (11.3 KB) TH_TANG_GIAM_TAI_SAN_BanViet.xlsx Luc Tran Van, 01/06/2023 02:52 PM
rpt_TSCD_BC08_2_Excel_BanViet.txt (24.4 KB) rpt_TSCD_BC08_2_Excel_BanViet.txt Luc Tran Van, 01/06/2023 04:37 PM
TR_PO_MASTER_Upd.txt (22.2 KB) TR_PO_MASTER_Upd.txt Luc Tran Van, 01/06/2023 05:07 PM
Script.zip (19.9 KB) Script.zip Luc Tran Van, 01/09/2023 09:12 AM
PAY_T10.xlsx (144 KB) PAY_T10.xlsx Luc Tran Van, 01/09/2023 09:22 AM
TR_REQUEST_DOC_GET_DVDM_AND_BRANCH.txt (2.38 KB) TR_REQUEST_DOC_GET_DVDM_AND_BRANCH.txt Luc Tran Van, 01/09/2023 09:47 AM
TR_REQUEST_DOC_MOVE_DVCM.txt (5.08 KB) TR_REQUEST_DOC_MOVE_DVCM.txt Luc Tran Van, 01/09/2023 09:47 AM
TR_RE_PAY_Search.txt (63.6 KB) TR_RE_PAY_Search.txt Luc Tran Van, 01/09/2023 01:53 PM
entries_byid.txt (2.92 KB) entries_byid.txt Luc Tran Van, 01/09/2023 02:14 PM
entries_byid.txt (3.04 KB) entries_byid.txt Luc Tran Van, 01/09/2023 02:20 PM
BAOCAO.zip (587 KB) BAOCAO.zip Luc Tran Van, 01/09/2023 03:07 PM
TR_REQ_PROCESS_CHILD_App.txt (35.8 KB) TR_REQ_PROCESS_CHILD_App.txt Luc Tran Van, 01/09/2023 04:06 PM

History

#1 Updated by Luc Tran Van over 2 years ago

#6 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_PROCESS SET CHECKER_ID = NULL, APPROVE_DT = NULL, NOTES = N'Chờ Giám đốc khối phê duyệt' WHERE ID = 88403

#7 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_PROCESS SET STATUS = 'P', CHECKER_ID = 'sangnm1', APPROVE_DT = '2023-01-04T13:29:55.347', NOTES = N'Giám đốc khối đã phê duyệt' WHERE ID = 88403
UPDATE PL_REQUEST_PROCESS SET STATUS = 'C' WHERE ID = 88404
UPDATE PL_REQUEST_DOC SET PROCESS_ID = 'APPROVE' WHERE REQ_ID = 'PLRD00000206444'
INSERT INTO PL_PROCESS (REQ_ID, PROCESS_ID, CHECKER_ID, APPROVE_DT, PROCESS_DESC, NOTES)
VALUES ('PLRD00000206444', 'GDK_TT', 'sangnm1', '2023-01-04T13:29:55.347', N'Phê duyệt', N'Giám đốc khối đã phê duyệt xong');

#8 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_ID IN (SELECT REQ_DOC_ID FROM TR_REQUEST_DOC_DT WHERE HANGHOA_ID='HH0000000000035') AND
PROCESS_ID ='GDK_PYC'

#12 Updated by Luc Tran Van over 2 years ago

#14 Updated by Luc Tran Van over 2 years ago

#16 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_DOC SET IS_CHECKALL = 1 WHERE REQ_ID =

#19 Updated by Luc Tran Van over 2 years ago

exec rpt_TSCD_BC08_2_Excel_BanViet @p_BRANCH_LOGIN=N'DV0001',@p_LEVEL=N'ALL',@p_BRANCH_ID=N'DV0001',@p_Fromdate=N'01/01/2022 00:00:00',@p_Todate=N'01/01/2023 00:00:00',@p_FromPrice=0,@p_ToPrice=0,@p_User_ID=N'',@p_Supplier_id=N'',@p_Group_id=N''

#21 Updated by Luc Tran Van over 2 years ago

#22 Updated by Luc Tran Van over 2 years ago

INSERT INTO SYS_PREFIX
VALUES

INSERT INTO SYS_PREFIX
VALUES

#28 Updated by Luc Tran Van over 2 years ago

Also available in: Atom PDF