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

INSERT dbo.PL_REQUEST_PROCESS

(

    REQ_ID,

    PROCESS_ID,

    STATUS,

    ROLE_USER,

    BRANCH_ID,

    CHECKER_ID,

    APPROVE_DT,

    PARENT_PROCESS_ID,

    IS_LEAF,

    COST_ID,

    DVDM_ID,

    NOTES,

    IS_HAS_CHILD,

    DEP_ID

)

VALUES

(   'PLRD00000200031',        -- REQ_ID - varchar(15)

    'GDK_TT',        -- PROCESS_ID - varchar(10)

    'C',        -- STATUS - varchar(5)

    'GDK',        -- ROLE_USER - varchar(50)

    '',        -- BRANCH_ID - varchar(15)

    '',        -- CHECKER_ID - varchar(15)

    NULL, -- APPROVE_DT - datetime

    'KT',        -- PARENT_PROCESS_ID - varchar(10)

    '',        -- IS_LEAF - varchar(1)

    '',        -- COST_ID - varchar(15)

    'DM0000000000015',        -- DVDM_ID - varchar(15)

    N'',       -- NOTES - nvarchar(500)

    NULL,      -- IS_HAS_CHILD - bit

    ''         -- DEP_ID - varchar(20)

    )

	UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='GDK_TT' WHERE REQ_ID='PLRD00000200031'

	UPDATE dbo.PL_REQUEST_PROCESS SET STATUS='U' WHERE ID=805

	UPDATE dbo.PL_TRADEDETAIL SET QUANTITY_ETM = QUANTITY_ETM - 3600, AMT_ETM=AMT_ETM-27324000  WHERE TRADE_ID='PLT000000074374'

	UPDATE dbo.PL_TRADEDETAIL SET QUANTITY_ETM = QUANTITY_ETM - 92,AMT_ETM=AMT_ETM-22638000 WHERE TRADE_ID='PLT000000074377'