DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

07/14/2020

11:28 AM Feature #34: Đào tạo 14 -07 -2020

SELECT PL.REQ_ID,PL.PROCESS_ID,CD.DVDM_NAME,CASE WHEN TempC.ID IS NULL THEN TempU.TLNANME ELSE TU.TLNANME END AS TLN... Luc Tran Van

09:53 AM Feature #34: Đào tạo 14 -07 -2020

DELETE FROM TL_SYSROLEDETAIL WHERE ROLE_ID ='TC'
INSERT INTO TL_SYSROLEDETAIL SELECT 'TC',MENU_ID,ISINSERT,ISUPDATE... Luc Tran Van

09:34 AM Feature #34: Đào tạo 14 -07 -2020

SET IDENTITY_INSERT [dbo].[PL_ROLE_DATA_CONFIG] ON
INSERT INTO [dbo].[PL_ROLE_DATA_CONFIG] ([ID], [ROLE_TYPE], [BRAN... Luc Tran Van

09:33 AM Feature #34: Đào tạo 14 -07 -2020

INSERT INTO [dbo].[PL_ROLE_DATA_CONFIG] ([ID], [ROLE_TYPE], [BRANCH_ID], [DEP_ID]) VALUES (1, 'PL_MASTER', 'DV0001', ... Luc Tran Van

08:58 AM Feature #34 (Closed): Đào tạo 14 -07 -2020

Luc Tran Van

07/13/2020

02:44 PM Feature #33: IMPORT DATA

ALTER PROCEDURE [dbo].[TR_REQ_DOC_Ins_To_PO] @p_TR_REQ_ID VARCHAR(15)
AS
BEGIN TRANSACTION;
DECLARE @l_SUP_ID... Luc Tran Van

02:05 PM Feature #33: IMPORT DATA

INSERT INTO TL_SYSROLE_LIMIT VALUES ('LM000090','KT',50000000,'','admin','U','',getdate(),null,null,'DCNS',null,null) Luc Tran Van

11:36 AM Feature #33: IMPORT DATA

UPDATE PL_TRADEDETAIL SET AMT_EXE =0,AMT_ETM=0,AMT_TF=0,AMT_RECEIVE_TF=0
DELETE FROM TR_REQUEST_DOC
DELETE FROM TR_... Truong Nguyen Vu

11:34 AM Feature #33: IMPORT DATA

UPDATE PL_TRADEDETAIL SET AMT_EXE =0,AMT_ETM=0,AMT_TF=0,AMT_RECEIVE_TF=0
DELETE FROM TR_REQUEST_DOC
DELETE FROM TR_... Truong Nguyen Vu

11:31 AM Feature #33: IMPORT DATA

DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID IN (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT)
DELETE FROM PL_REQUES... Luc Tran Van

07/12/2020

10:08 PM Feature #33 (Closed): IMPORT DATA

Luc Tran Van