Project

General

Profile

Support #425

Gỡ DVCM Kế Toán khỏi PYCMS (PUR/2020/000227, PUR/2020/000211, PUR/2020/00009812)

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

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
10/12/2020
Due date:
% Done:

0%

Estimated time:
DATA PUR 2020 000227.xlsx (24.4 KB) DATA PUR 2020 000227.xlsx Luc Tran Van, 10/12/2020 04:50 PM
DATA PUR 2020 000211.xlsx (24.4 KB) DATA PUR 2020 000211.xlsx Luc Tran Van, 10/12/2020 04:55 PM
DATA PUR 2020 00009812.xlsx (25.5 KB) DATA PUR 2020 00009812.xlsx Luc Tran Van, 10/12/2020 04:57 PM

History

#1 Updated by Luc Tran Van over 4 years ago

Hi Lực!

Gựi Lực các phiếu cần bỏ Phòng Kế toán ra giúp ra nha!

Thanks!

1/ PUR/2020/000227
2/ PUR/2020/000211
3/ PUR/2020/00009812

Vo Duy Cuong (Mr.)
Senior Officer
Purchasing Dept

VIET CAPITAL BANK
Headquarter: Tòa nhà HM Town số 412 Nguyễn Thị Minh Khai, Phường 5, Quận 3, TP.Hồ Chí Minh, Vietnam
T: (+84 8) 62 679 679 | ext: 379 | F: (+84 8) 62 638 668
M: (+84) 907644568 | E: | W: www.vietcapitalbank.com.vn

#2 Updated by Luc Tran Van over 4 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/000227'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000251227'
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID ='TRRD00000251227'

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000251227' AND PROCESS_ID ='DVCM' AND ROLE_USER ='KSV'
DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_ID ='TRRD00000251227' AND REQ_COST_ID ='TRCC00000000961'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE REQ_ID = 'TRRD00000251227' AND PROCESS_ID ='GDK_PYC' AND ROLE_USER ='GDK'

#4 Updated by Luc Tran Van over 4 years ago

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRD00000251211' AND PROCESS_ID ='DVCM' AND ROLE_USER ='KSV'
DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_ID ='TRRD00000251211' AND REQ_COST_ID ='TRCC00000000962'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE REQ_ID = 'TRRD00000251211' AND PROCESS_ID ='GDK_PYC' AND ROLE_USER ='GDK'

#5 Updated by Luc Tran Van over 4 years ago

SELECT * FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2020/00009812'
SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRDI001055584'
SELECT * FROM TR_REQUEST_COSTCENTER WHERE REQ_ID ='TRRDI001055584'

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID ='TRRDI001055584' AND PROCESS_ID ='DVCM' AND ROLE_USER ='KSV'
DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_ID ='TRRDI001055584' AND REQ_COST_ID ='TRCC00000000870'
UPDATE PL_REQUEST_PROCESS SET STATUS ='C' WHERE REQ_ID = 'TRRDI001055584' AND PROCESS_ID ='GDK_PYC' AND ROLE_USER ='GDK'

#6 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed
  • Assignee set to Luc Tran Van

Also available in: Atom PDF