|
1
|
--วันที่ 15/3/2022
|
|
2
|
--เพิ่ม Table เซ็ตค่า อัตราการลดทอนวงเงินสินเชื่อ ตามยี่ห้อรุ่นรถ
|
|
3
|
--เพิ่ม field ที่ table เบิกใช้วงเงินรายใบ
|
|
4
|
|
|
5
|
CREATE TABLE [dbo].[FPMSFP60](
|
|
6
|
[cmpcde] [varchar](2) NOT NULL,
|
|
7
|
[offcde] [varchar](3) NOT NULL,
|
|
8
|
[seq] [int] IDENTITY(1,1) NOT NULL,
|
|
9
|
[brand] [varchar](4) NOT NULL,
|
|
10
|
[model] [varchar](4) NOT NULL,
|
|
11
|
[rate] [decimal](12, 4) NULL,
|
|
12
|
[rewfreq] [int] NULL,
|
|
13
|
[recsts] [varchar](1) NULL,
|
|
14
|
[crtdte] [datetime] NULL,
|
|
15
|
[crtby] [varchar](20) NULL,
|
|
16
|
[crtwrkstn] [varchar](20) NULL,
|
|
17
|
[upddte] [datetime] NULL,
|
|
18
|
[updby] [varchar](20) NULL,
|
|
19
|
[updwrkstn] [varchar](20) NULL,
|
|
20
|
[vrfdte] [datetime] NULL,
|
|
21
|
[vrfby] [varchar](20) NULL,
|
|
22
|
[vrfwrkstn] [varchar](20) NULL,
|
|
23
|
CONSTRAINT [PK_FPMSFP60] PRIMARY KEY CLUSTERED
|
|
24
|
([cmpcde] ASC,
|
|
25
|
[offcde] ASC,
|
|
26
|
[seq] ASC,
|
|
27
|
[brand] ASC,
|
|
28
|
[model] ASC
|
|
29
|
)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]
|
|
30
|
) ON [PRIMARY]
|
|
31
|
|
|
32
|
------------------------------
|
|
33
|
ALTER TABLE FPWKDL01CC
|
|
34
|
add dueday int,
|
|
35
|
cru_rate decimal(12, 4),
|
|
36
|
cru_rewfreq int
|
|
37
|
;
|
