Project

General

Profile

Feature #1403

VẬN HÀNH SAU GOLIVE NGÀY 21-11-2022

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

Status:
New
Priority:
Normal
Assignee:
-
Start date:
11/21/2022
Due date:
% Done:

0%

Estimated time:
TR_CONTRACT_Ins.txt (12.9 KB) TR_CONTRACT_Ins.txt Luc Tran Van, 11/21/2022 09:06 AM
TR_CONTRACT_Upd.txt (22.1 KB) TR_CONTRACT_Upd.txt Luc Tran Van, 11/21/2022 09:06 AM
NF_MESSAGE_GetContent.txt (130 KB) NF_MESSAGE_GetContent.txt Luc Tran Van, 11/21/2022 09:26 AM
ASS_ADDNEW_KT_BVB_Appr.txt (38.4 KB) ASS_ADDNEW_KT_BVB_Appr.txt Luc Tran Van, 11/21/2022 10:06 AM
PL_REQUEST_DOC_ById.txt (6.19 KB) PL_REQUEST_DOC_ById.txt Luc Tran Van, 11/21/2022 10:19 AM
1.0 PL REQUEST DOC UPD.txt (23.5 KB) 1.0 PL REQUEST DOC UPD.txt Luc Tran Van, 11/21/2022 10:23 AM
INHACHTOAN_BanViet.docx (103 KB) INHACHTOAN_BanViet.docx Luc Tran Van, 11/21/2022 10:30 AM
ASS_USE_MULTI_BVB_MASTER_BBBG.txt (8.1 KB) ASS_USE_MULTI_BVB_MASTER_BBBG.txt Luc Tran Van, 11/21/2022 11:05 AM
ASS_BBBG_USE-d80f2b01-656e-49a9-a109-e9e00031acfa.pdf (164 KB) ASS_BBBG_USE-d80f2b01-656e-49a9-a109-e9e00031acfa.pdf Luc Tran Van, 11/21/2022 11:11 AM
2.0 TL USER Search.txt (17.7 KB) 2.0 TL USER Search.txt Luc Tran Van, 11/21/2022 11:25 AM
ASS_USE_MULTI_BVB_MASTER_BBBG_v2.txt (8.1 KB) ASS_USE_MULTI_BVB_MASTER_BBBG_v2.txt Luc Tran Van, 11/21/2022 11:26 AM
ASS_BBBG_USE-151f2030-46fe-4ecf-bd9a-c14708b67307.pdf (164 KB) ASS_BBBG_USE-151f2030-46fe-4ecf-bd9a-c14708b67307.pdf Luc Tran Van, 11/21/2022 11:33 AM
ASS_USE_MULTI_BVB_MASTER_DATA.txt (348 Bytes) ASS_USE_MULTI_BVB_MASTER_DATA.txt Luc Tran Van, 11/21/2022 01:48 PM
PHONG_DATA.txt (2.96 KB) PHONG_DATA.txt Luc Tran Van, 11/21/2022 01:51 PM
ASS_COLLECT_MULTI_MASTER_BBBG.txt (10.5 KB) ASS_COLLECT_MULTI_MASTER_BBBG.txt Luc Tran Van, 11/21/2022 02:07 PM
ASS_TRANSFER_MULTI_MASTER_BBBG.txt (11.8 KB) ASS_TRANSFER_MULTI_MASTER_BBBG.txt Luc Tran Van, 11/21/2022 02:07 PM
ASS_USE_MULTI_BVB_MASTER_BBBG_v3.txt (8.1 KB) ASS_USE_MULTI_BVB_MASTER_BBBG_v3.txt Luc Tran Van, 11/21/2022 02:07 PM
UPDATE PUR_2022_002615.txt (223 Bytes) UPDATE PUR_2022_002615.txt Luc Tran Van, 11/21/2022 02:07 PM
UPDATE PUR_2022_002615.txt (496 Bytes) UPDATE PUR_2022_002615.txt Luc Tran Van, 11/21/2022 02:21 PM
Ngôn ngữ.txt (272 Bytes) Ngôn ngữ.txt Luc Tran Van, 11/21/2022 02:47 PM
rpt_TR_REQ_GOODS_Inventory.txt (2.85 KB) rpt_TR_REQ_GOODS_Inventory.txt Luc Tran Van, 11/21/2022 05:28 PM
rpt_TR_REQ_DOC_Inventory.txt (22.5 KB) rpt_TR_REQ_DOC_Inventory.txt Luc Tran Van, 11/21/2022 05:28 PM

History

#2 Updated by Luc Tran Van over 2 years ago

INSERT INTO [TL_MESSAGE] ([PROCESS_ID],[TITLE],[FUNC])VALUES

#7 Updated by Luc Tran Van over 2 years ago

wwwroot/Reports/ASS_MASTER

#8 Updated by Luc Tran Van over 2 years ago

SELECT CREATE_DT,USE_EXPORT_DT FROM ASS_USE_MULTI_MASTER WHERE USER_MASTER_ID='SMA000000251931'

#20 Updated by Luc Tran Van over 2 years ago

-------UPDATE TR_PO_PAYMENT---------
UPDATE TR_PO_PAYMENT SET
AMOUNT = (149973904 * [PERCENT])/100,
TOTAL_AMT = (149973904 * [PERCENT])/100
WHERE PO_ID =

#22 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE='0011/2022/TTr-0450005')

#23 Updated by Luc Tran Van over 2 years ago

UPDATE PL_REQUEST_COSTCENTER SET NOTES =N'Đồng ý', AUTH_STATUS ='A' WHERE REQ_ID ='PLRD00000205661' AND COST_ID ='DM0000000000052'
INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000205045','DVCM','P','GDDV','DV0001','tuanva','2022-11-7 10:11:22.177','KT','N','','DM0000000000052',N'Đơn vị chuyên môn xác nhận','1','','')
INSERT INTO PL_PROCESS VALUES ('PLRD00000205045','DVCM','tuanva','2022-11-7 10:11:22.177',N'Đồng ý',N'Đơn vị chuyên môn phê duyệt')
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID='DVCM' WHERE REQ_ID ='PLRD00000205045' AND PROCESS_ID ='GDK_TT'

Also available in: Atom PDF