Project

General

Profile

Feature #1400

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

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

Status:
New
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
11/15/2022
Due date:
% Done:

0%

Estimated time:

Description

DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID='PLRD00000205424' AND PROCESS_ID='73221'
UPDATE PL_REQUEST_PROCESS SET STATUS='C' WHERE REQ_ID='PLRD00000205424' AND PROCESS_ID='TC'
DELETE PL_PROCESS WHERE ID='394073'
DELETE PL_PROCESS WHERE ID='394884'
DELETE PL_PROCESS WHERE ID='379936'
DELETE PL_PROCESS WHERE ID='394839'

1.0 PL REQUEST DOC APPR.txt (51.4 KB) 1.0 PL REQUEST DOC APPR.txt Luc Tran Van, 11/15/2022 10:02 PM
TO_TRINH_CHU_TRUONG.docx (61 KB) TO_TRINH_CHU_TRUONG.docx Luc Tran Van, 11/16/2022 01:22 AM
2.0 rpt_PL_REQUEST_DOC_DT_ByID.txt (29 KB) 2.0 rpt_PL_REQUEST_DOC_DT_ByID.txt Luc Tran Van, 11/16/2022 01:23 AM
2.1. PL REQUEST DOC BY ID REPORT.txt (21.4 KB) 2.1. PL REQUEST DOC BY ID REPORT.txt Luc Tran Van, 11/16/2022 01:23 AM
GETDATA 16-11.xlsx (10.1 KB) GETDATA 16-11.xlsx Luc Tran Van, 11/16/2022 08:53 AM
GET LIST TRADE.txt (1.68 KB) GET LIST TRADE.txt Luc Tran Van, 11/16/2022 09:24 AM
#7.xlsx (8.47 KB) #7.xlsx Luc Tran Van, 11/16/2022 09:26 AM
2.2. IN TO TRINH CHU TRUONG FIX LAN 1.txt (29 KB) 2.2. IN TO TRINH CHU TRUONG FIX LAN 1.txt Luc Tran Van, 11/16/2022 09:35 AM
2.4. PL REQUEST DOC BY ID REPORT.txt (21.5 KB) 2.4. PL REQUEST DOC BY ID REPORT.txt Luc Tran Van, 11/16/2022 09:53 AM
#11.xlsx (12.2 KB) #11.xlsx Luc Tran Van, 11/16/2022 09:56 AM
CM_EMPLOYEE_Sync.txt (30 KB) CM_EMPLOYEE_Sync.txt Luc Tran Van, 11/16/2022 10:46 AM
2.5. PL COST CENTER Ins.txt (6.48 KB) 2.5. PL COST CENTER Ins.txt Luc Tran Van, 11/16/2022 05:06 PM
invoice_161122.txt (3.47 KB) invoice_161122.txt Luc Tran Van, 11/16/2022 05:41 PM
invoice2.txt (3.48 KB) invoice2.txt Luc Tran Van, 11/16/2022 05:52 PM
PL_COSTCENTER.xlsx (9.99 KB) PL_COSTCENTER.xlsx Luc Tran Van, 11/16/2022 05:59 PM
#23.xlsx (9.83 KB) #23.xlsx Luc Tran Van, 11/16/2022 06:04 PM
#23v2.xlsx (8.86 KB) #23v2.xlsx Luc Tran Van, 11/16/2022 06:10 PM
invoice3.txt (83 Bytes) invoice3.txt Luc Tran Van, 11/16/2022 06:13 PM
invoice4.txt (197 Bytes) invoice4.txt Luc Tran Van, 11/16/2022 06:21 PM
invoice5.txt (3.48 KB) invoice5.txt Luc Tran Van, 11/17/2022 08:51 AM
TR_REQ_GET_ENTRY.txt (1.23 KB) TR_REQ_GET_ENTRY.txt Luc Tran Van, 11/17/2022 09:06 AM
TR_REQ_TRANSFER_EXTERNAL_Upd_Status.txt (4.68 KB) TR_REQ_TRANSFER_EXTERNAL_Upd_Status.txt Luc Tran Van, 11/17/2022 09:06 AM
DATA_BAO_1.xlsx (10.5 KB) DATA_BAO_1.xlsx Luc Tran Van, 11/17/2022 09:28 AM
DATA_BAO_2.xlsx (9.67 KB) DATA_BAO_2.xlsx Luc Tran Van, 11/17/2022 09:49 AM
CMACCOUNT1.txt (316 Bytes) CMACCOUNT1.txt Luc Tran Van, 11/17/2022 10:32 AM
DATA_TRANSFER_EXTERNAL.xlsx (10.1 KB) DATA_TRANSFER_EXTERNAL.xlsx Luc Tran Van, 11/17/2022 11:09 AM

History

#2 Updated by Luc Tran Van over 2 years ago

  • Project changed from DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT to DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

#5 Updated by Luc Tran Van over 2 years ago

SELECT * FROM CM_GOODS WHERE GD_ID='GOO000000255591'
SELECT * FROM PL_TRADEDETAIL WHERE GOODS_ID='GOO000000255591'

#8 Updated by Luc Tran Van over 2 years ago

#11 Updated by Luc Tran Van over 2 years ago

EXEC rpt_PL_REQUEST_DOC_DT_ById 'PLRD00000205773'
EXEC PL_REQUEST_DOC_ById_Report 'PLRD00000205773'

#12 Updated by Luc Tran Van over 2 years ago

#14 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2022/002732')

#16 Updated by Luc Tran Van over 2 years ago

select * from PL_COSTCENTER WHERE COST_ID IN (SELECT COST_ID FROM PL_COSTCENTER_DT WHERE DEP_ID='DEP000000000051') or COST_ID='PLCC00000001075' or COST_CODE ='0692103'

select * FROM PL_COSTCENTER_DT WHERE DEP_ID='DEP000000000051'

#17 Updated by Luc Tran Van over 2 years ago

DELETE PL_COSTCENTER WHERE COST_ID IN (SELECT COST_ID FROM PL_COSTCENTER_DT WHERE DEP_ID='DEP000000000051') or COST_ID='PLCC00000001075' or COST_CODE ='0692103'

DELETE PL_COSTCENTER_DT WHERE DEP_ID='DEP000000000051'

#19 Updated by Luc Tran Van over 2 years ago

UPDATE TR_PO_MASTER SET IS_CLOSED ='N' WHERE PO_CODE='PO006/22/0006'

#23 Updated by Luc Tran Van over 2 years ago

SELECT * FROM PL_COSTCENTER WHERE COST_CODE='0692103'
SELECT * FROM PL_COSTCENTER_DT WHERE COST_ID IN (SELECT COST_ID FROM PL_COSTCENTER WHERE COST_CODE='0692103')

#24 Updated by Luc Tran Van over 2 years ago

#25 Updated by Luc Tran Van over 2 years ago

DELETE FROM PL_COSTCENTER_DT WHERE COST_ID IN (SELECT COST_ID FROM PL_COSTCENTER WHERE COST_CODE='0692103')
DELETE FROM PL_COSTCENTER WHERE COST_CODE='0692103'

#26 Updated by Luc Tran Van over 2 years ago

#30 Updated by Luc Tran Van over 2 years ago

UPDATE ASS_MASTER SET AMORT_STATUS ='VNM' WHERE ASSET_ID ='ASS000000276300'

#32 Updated by Luc Tran Van over 2 years ago

SELECT * FROM TR_PO_MASTER WHERE PO_ID = 'TRPM00000255362'
SELECT * FROM TR_PO_DETAIL WHERE PO_ID = 'TRPM00000255362'
SELECT * FROM TR_PO_PAYMENT WHERE PO_ID = 'TRPM00000255362'

#34 Updated by Luc Tran Van over 2 years ago

UPDATE TR_PO_DETAIL SET
TOTAL_AMT = QUANTITY * PRICE,
VAT = 0,
PRICE_VAT = 0,
TOTAL_AMT_FN = QUANTITY * PRICE
WHERE PO_ID = 'TRPM00000255362'

UPDATE TR_PO_MASTER SET TOTAL_AMT = 8298720 WHERE PO_ID = 'TRPM00000255362'
UPDATE TR_PO_PAYMENT SET [PERCENT] = 100 WHERE PO_ID = 'TRPM00000255362'

Also available in: Atom PDF