DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN - NH BẢN VIỆT - GD3

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