UPDATE dbo.PL_TRADEDETAIL SET AMT_RECEIVE_TF=0,AMT_ETM=90000000 WHERE TRADE_ID='PLT000000071125'

INSERT INTO dbo.TL_SYSROLE_LIMIT
(
    LIMIT_ID,
    ROLE_ID,
    LIMIT_VALUE,
    NOTES,
    MAKER_ID,
    AUTH_STATUS,
    CHECKER_ID,
    DATE_APPROVE,
    ISAPPROVE,
    BRANCH_ID,
    LIMIT_TYPE,
    LIMIT_PERCENT,
    DVDM_ID
)
VALUES
(   'LMPYC001',        -- LIMIT_ID - varchar(15)
    '',        -- ROLE_ID - varchar(15)
    20000000,      -- LIMIT_VALUE - decimal(18, 0)
    N'',       -- NOTES - nvarchar(200)
    '',        -- MAKER_ID - varchar(12)
    '',        -- AUTH_STATUS - varchar(1)
    '',        -- CHECKER_ID - varchar(12)
    GETDATE(), -- DATE_APPROVE - datetime
    '',        -- ISAPPROVE - varchar(1)
    '',        -- BRANCH_ID - varchar(15)
    'PYCMS_DVKD',        -- LIMIT_TYPE - varchar(15)
    NULL,      -- LIMIT_PERCENT - decimal(18, 0)
    ''         -- DVDM_ID - varchar(15)
    )


	INSERT INTO dbo.TL_SYSROLE_LIMIT
(
    LIMIT_ID,
    ROLE_ID,
    LIMIT_VALUE,
    NOTES,
    MAKER_ID,
    AUTH_STATUS,
    CHECKER_ID,
    DATE_APPROVE,
    ISAPPROVE,
    BRANCH_ID,
    LIMIT_TYPE,
    LIMIT_PERCENT,
    DVDM_ID
)
VALUES
(   'LMPYC002',        -- LIMIT_ID - varchar(15)
    '',        -- ROLE_ID - varchar(15)
    5000000,      -- LIMIT_VALUE - decimal(18, 0)
    N'',       -- NOTES - nvarchar(200)
    '',        -- MAKER_ID - varchar(12)
    '',        -- AUTH_STATUS - varchar(1)
    '',        -- CHECKER_ID - varchar(12)
    GETDATE(), -- DATE_APPROVE - datetime
    '',        -- ISAPPROVE - varchar(1)
    '',        -- BRANCH_ID - varchar(15)
    'PYCMS_DVCM',        -- LIMIT_TYPE - varchar(15)
    NULL,      -- LIMIT_PERCENT - decimal(18, 0)
    ''         -- DVDM_ID - varchar(15)
    )