ALTER TABLE [dbo].[TR_REQ_PAY_AUTO_RECURRING_HISTORY] DROP
COLUMN [billCodeAlias],
COLUMN [year],
COLUMN [customerAddress],
COLUMN [accountName],
COLUMN [accountNoRec],
COLUMN [billDate]
GO


ALTER TABLE [dbo].[TR_REQ_PAY_AUTO_RECURRING_HISTORY] ADD
[accountType] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[createdTime] [datetime] NULL,
[resultDesc] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[transDesc] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO


ALTER TABLE [dbo].[TR_REQ_PAY_AUTO_PAYMENTS] ADD
[TYPE_AUTO] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TYPE_SERVICE_AUTO] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO


ALTER TABLE [dbo].[TR_REQ_PAYMENT_AUTO_MANUFACTURER] ADD
[TRANSACCOUNT_NAME] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TRANS_GLNAME] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[customerNo] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SERVICE_TYPE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
GO