INSERT INTO dbo.PL_MASTER
(
    PLAN_ID,
    PLAN_CODE,
    PLAN_NAME,
    BRANCH_ID,
    DEPT_ID,
    EFFECT_DT,
    PLAN_TYPE,
    TOTAL_AMT,
    APPROVE_VALUE,
    VERSON,
    YEAR,
    STATUS,
    NOTES,
    RECORD_STATUS,
    MAKER_ID,
    CREATE_DT,
    AUTH_STATUS,
    CHECKER_ID,
    APPROVE_DT,
    PLAN_TYPE_ID,
    COST_ID
)
VALUES
(   'PLMI0000018107',        -- PLAN_ID - varchar(15)
    '06904030120',        -- PLAN_CODE - varchar(15)
    N'KẾ HOẠCH NGÂN SÁCH 2020',       -- PLAN_NAME - nvarchar(200)
    'DV0001',        -- BRANCH_ID - varchar(15)
    'DEP000000000809',        -- DEPT_ID - varchar(15)
    GETDATE(), -- EFFECT_DT - datetime
    '',        -- PLAN_TYPE - varchar(1)
    NULL,      -- TOTAL_AMT - decimal(18, 2)
    NULL,      -- APPROVE_VALUE - decimal(18, 2)
    0,         -- VERSON - int
    '2020',        -- YEAR - varchar(4)
    '1',        -- STATUS - varchar(1)
    N'',       -- NOTES - nvarchar(1000)
    '1',        -- RECORD_STATUS - varchar(1)
    'admin',        -- MAKER_ID - varchar(15)
    GETDATE(), -- CREATE_DT - datetime
    'A',        -- AUTH_STATUS - varchar(50)
    'admin',        -- CHECKER_ID - varchar(15)
    GETDATE(), -- APPROVE_DT - datetime
    'PLTYPE000000019',        -- PLAN_TYPE_ID - varchar(15)
    'DM0000000000049'         -- COST_ID - varchar(15)
    )


	UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID='PLMI0000018107' WHERE TRADE_ID='PLT000000070428'

	INSERT INTO dbo.PL_MASTER
(
    PLAN_ID,
    PLAN_CODE,
    PLAN_NAME,
    BRANCH_ID,
    DEPT_ID,
    EFFECT_DT,
    PLAN_TYPE,
    TOTAL_AMT,
    APPROVE_VALUE,
    VERSON,
    YEAR,
    STATUS,
    NOTES,
    RECORD_STATUS,
    MAKER_ID,
    CREATE_DT,
    AUTH_STATUS,
    CHECKER_ID,
    APPROVE_DT,
    PLAN_TYPE_ID,
    COST_ID
)
VALUES
(   'PLMII000018107',        -- PLAN_ID - varchar(15)
    '06904030120',        -- PLAN_CODE - varchar(15)
    N'KẾ HOẠCH NGÂN SÁCH 2020',       -- PLAN_NAME - nvarchar(200)
    'DV0001',        -- BRANCH_ID - varchar(15)
    'DEP000000000809',        -- DEPT_ID - varchar(15)
    GETDATE(), -- EFFECT_DT - datetime
    '',        -- PLAN_TYPE - varchar(1)
    NULL,      -- TOTAL_AMT - decimal(18, 2)
    NULL,      -- APPROVE_VALUE - decimal(18, 2)
    0,         -- VERSON - int
    '2020',        -- YEAR - varchar(4)
    '1',        -- STATUS - varchar(1)
    N'',       -- NOTES - nvarchar(1000)
    '1',        -- RECORD_STATUS - varchar(1)
    'admin',        -- MAKER_ID - varchar(15)
    GETDATE(), -- CREATE_DT - datetime
    'A',        -- AUTH_STATUS - varchar(50)
    'admin',        -- CHECKER_ID - varchar(15)
    GETDATE(), -- APPROVE_DT - datetime
    'PLTYPE000000011',        -- PLAN_TYPE_ID - varchar(15)
    'DM0000000000049'         -- COST_ID - varchar(15)
    )
		UPDATE dbo.PL_TRADEDETAIL SET PLAN_ID='PLMII000018107' WHERE TRADE_ID='PLT000000070127'