--วันที่ 15/3/2022 
--เพิ่ม Table เซ็ตค่า อัตราการลดทอนวงเงินสินเชื่อ ตามยี่ห้อรุ่นรถ
--เพิ่ม field ที่ table เบิกใช้วงเงินรายใบ

CREATE TABLE [dbo].[FPMSFP60](
[cmpcde] [varchar](2) NOT NULL,
[offcde] [varchar](3) NOT NULL,
[seq] [int] IDENTITY(1,1) NOT NULL,
[brand] [varchar](4) NOT NULL,
[model] [varchar](4) NOT NULL,
[rate] [decimal](12, 4) NULL,
[rewfreq] [int] NULL,
[recsts] [varchar](1) NULL,
[crtdte] [datetime] NULL,
[crtby] [varchar](20) NULL,
[crtwrkstn] [varchar](20) NULL,
[upddte] [datetime] NULL,
[updby] [varchar](20) NULL,
[updwrkstn] [varchar](20) NULL,
[vrfdte] [datetime] NULL,
[vrfby] [varchar](20) NULL,
[vrfwrkstn] [varchar](20) NULL,
 CONSTRAINT [PK_FPMSFP60] PRIMARY KEY CLUSTERED 
([cmpcde] ASC,
[offcde] ASC,
[seq] ASC,
[brand] ASC,
[model] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

------------------------------
ALTER TABLE FPWKDL01CC
   add dueday	int,
   cru_rate	decimal(12, 4),
   cru_rewfreq	int
 ;