INSERT INTO dbo.PL_TRADEDETAIL
(
    TRADE_ID,
    PLAN_ID,
    GOODS_ID,
    GOODS_CODE,
    GOODS_NAME,
    GOODS_TYPE,
    UNIT_ID,
    M1,
    M2,
    M3,
    M4,
    M5,
    M6,
    M7,
    M8,
    M9,
    M10,
    M11,
    M12,
    QUANTITY,
    QUANTITY_EXE,
    PRICE,
    START_DT_AMORT,
    MONTH_AMORT,
    END_DT_AMORT,
    RATE_AMORT,
    NOTES,
    RECORD_STATUS,
    MAKER_ID,
    CREATE_DT,
    AUTH_STATUS,
    CHECKER_ID,
    APPROVE_DT,
    QUANTITY_ETM,
    AMT_APP,
    AMT_EXE,
    AMT_ETM,
    AMT_TF,
    AMT_RECEIVE_TF
)
VALUES
(   'IMPORT000000001',        -- TRADE_ID - varchar(15)
    'PLM000000018459',        -- PLAN_ID - varchar(15)
    'GOO000001061829',        -- GOODS_ID - varchar(15)
    N'AS.I.V.OE.0006',       -- GOODS_CODE - nvarchar(200)
    N'Bảo dưỡng tài sản đang phân bổ Tổng',       -- GOODS_NAME - nvarchar(200)
    '',        -- GOODS_TYPE - varchar(15)
    '',        -- UNIT_ID - varchar(15)
    NULL,      -- M1 - decimal(18, 0)
    NULL,      -- M2 - decimal(18, 0)
    NULL,      -- M3 - decimal(18, 0)
    NULL,      -- M4 - decimal(18, 0)
    NULL,      -- M5 - decimal(18, 0)
    NULL,      -- M6 - decimal(18, 0)
    NULL,      -- M7 - decimal(18, 0)
    NULL,      -- M8 - decimal(18, 0)
    NULL,      -- M9 - decimal(18, 0)
    NULL,      -- M10 - decimal(18, 0)
    NULL,      -- M11 - decimal(18, 0)
    NULL,      -- M12 - decimal(18, 0)
    NULL,      -- QUANTITY - decimal(18, 0)
    NULL,      -- QUANTITY_EXE - decimal(18, 0)
    NULL,      -- PRICE - decimal(18, 0)
    GETDATE(), -- START_DT_AMORT - datetime
    0,         -- MONTH_AMORT - int
    GETDATE(), -- END_DT_AMORT - datetime
    NULL,      -- RATE_AMORT - decimal(18, 3)
    N'',       -- NOTES - nvarchar(1000)
    '',        -- RECORD_STATUS - varchar(1)
    '',        -- MAKER_ID - varchar(12)
    GETDATE(), -- CREATE_DT - datetime
    '',        -- AUTH_STATUS - varchar(50)
    '',        -- CHECKER_ID - varchar(12)
    GETDATE(), -- APPROVE_DT - datetime
    NULL,      -- QUANTITY_ETM - decimal(18, 0)
    6102420765,      -- AMT_APP - decimal(18, 2)
    NULL,      -- AMT_EXE - decimal(18, 2)
    NULL,      -- AMT_ETM - decimal(18, 2)
    NULL,      -- AMT_TF - decimal(18, 2)
    NULL       -- AMT_RECEIVE_TF - decimal(18, 2)
    )

INSERT INTO dbo.PL_TRADEDETAIL
(
    TRADE_ID,
    PLAN_ID,
    GOODS_ID,
    GOODS_CODE,
    GOODS_NAME,
    GOODS_TYPE,
    UNIT_ID,
    M1,
    M2,
    M3,
    M4,
    M5,
    M6,
    M7,
    M8,
    M9,
    M10,
    M11,
    M12,
    QUANTITY,
    QUANTITY_EXE,
    PRICE,
    START_DT_AMORT,
    MONTH_AMORT,
    END_DT_AMORT,
    RATE_AMORT,
    NOTES,
    RECORD_STATUS,
    MAKER_ID,
    CREATE_DT,
    AUTH_STATUS,
    CHECKER_ID,
    APPROVE_DT,
    QUANTITY_ETM,
    AMT_APP,
    AMT_EXE,
    AMT_ETM,
    AMT_TF,
    AMT_RECEIVE_TF
)
VALUES
(   'IMPORT000000002',        -- TRADE_ID - varchar(15)
    'PLM000000018459',        -- PLAN_ID - varchar(15)
    'GOO000001061831',        -- GOODS_ID - varchar(15)
    N'AS.I.V.OE.0007',       -- GOODS_CODE - nvarchar(200)
    N'Bảo dưỡng tài sản trong năm 2020 - HO phân bổ Tổng',       -- GOODS_NAME - nvarchar(200)
    '',        -- GOODS_TYPE - varchar(15)
    '',        -- UNIT_ID - varchar(15)
    NULL,      -- M1 - decimal(18, 0)
    NULL,      -- M2 - decimal(18, 0)
    NULL,      -- M3 - decimal(18, 0)
    NULL,      -- M4 - decimal(18, 0)
    NULL,      -- M5 - decimal(18, 0)
    NULL,      -- M6 - decimal(18, 0)
    NULL,      -- M7 - decimal(18, 0)
    NULL,      -- M8 - decimal(18, 0)
    NULL,      -- M9 - decimal(18, 0)
    NULL,      -- M10 - decimal(18, 0)
    NULL,      -- M11 - decimal(18, 0)
    NULL,      -- M12 - decimal(18, 0)
    NULL,      -- QUANTITY - decimal(18, 0)
    NULL,      -- QUANTITY_EXE - decimal(18, 0)
    NULL,      -- PRICE - decimal(18, 0)
    GETDATE(), -- START_DT_AMORT - datetime
    0,         -- MONTH_AMORT - int
    GETDATE(), -- END_DT_AMORT - datetime
    NULL,      -- RATE_AMORT - decimal(18, 3)
    N'',       -- NOTES - nvarchar(1000)
    '',        -- RECORD_STATUS - varchar(1)
    '',        -- MAKER_ID - varchar(12)
    GETDATE(), -- CREATE_DT - datetime
    '',        -- AUTH_STATUS - varchar(50)
    '',        -- CHECKER_ID - varchar(12)
    GETDATE(), -- APPROVE_DT - datetime
    NULL,      -- QUANTITY_ETM - decimal(18, 0)
    36222732001,      -- AMT_APP - decimal(18, 2)
    NULL,      -- AMT_EXE - decimal(18, 2)
    NULL,      -- AMT_ETM - decimal(18, 2)
    NULL,      -- AMT_TF - decimal(18, 2)
    NULL       -- AMT_RECEIVE_TF - decimal(18, 2)
    )