DROP TABLE dbo.PL_TRADEDETAIL_HIST
CREATE TABLE [dbo].[PL_TRADEDETAIL_HIST](
	[TRADE_ID] [VARCHAR](15) NOT NULL,
	[PLAN_ID] [VARCHAR](15) NULL,
	[GOODS_ID] [VARCHAR](15) NULL,
	[GOODS_CODE] [NVARCHAR](200) NULL,
	[GOODS_NAME] [NVARCHAR](200) NULL,
	[GOODS_TYPE] [VARCHAR](15) NULL,
	[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,
	[AMT_ETM] [DECIMAL](18, 2) NULL,
	[AMT_EXE] [DECIMAL](18, 2) NULL,
	[AMT_APP] [DECIMAL](18, 2) NULL,
	[QUANTITY_ETM] [DECIMAL](18, 0) NULL,
	[QUANTITY] [DECIMAL](18, 0) NULL,
	[QUANTITY_EXE] [DECIMAL](18, 0) NULL,
	[PRICE] [DECIMAL](18, 0) NULL,
	[START_DT_AMORT] [DATETIME] NULL,
	[MONTH_AMORT] [INT] NULL,
	[END_DT_AMORT] [DATETIME] NULL,
	[RATE_AMORT] [DECIMAL](18, 3) NULL,
	[NOTES] [NVARCHAR](1000) NULL,
	[RECORD_STATUS] [VARCHAR](1) NULL,
	[MAKER_ID] [VARCHAR](12) NULL,
	[CREATE_DT] [DATETIME] NULL,
	[AUTH_STATUS] [VARCHAR](50) NULL,
	[CHECKER_ID] [VARCHAR](12) NULL,
	[APPROVE_DT] [DATETIME] NULL,
	[M9] [DECIMAL](18, 0) NULL,
	[M10] [DECIMAL](18, 0) NULL,
	[M11] [DECIMAL](18, 0) NULL,
	[M12] [DECIMAL](18, 0) NULL,
	[AMT_TF] [DECIMAL](18, 2) NULL,
	[AMT_RECEIVE_TF] [DECIMAL](18, 2) NULL,
	[REQ_ID] [VARCHAR](15) NOT NULL,
 CONSTRAINT [PK_PL_TRADEDETAIL_HIST] PRIMARY KEY NONCLUSTERED 
(
	[TRADE_ID] ASC,
	[REQ_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]