CREATE TABLE [dbo].[CM_ACCOUNT_PAY_LOG](
	[ID] [int] NULL,
	[REF_ID] [varchar](15) NULL,
	[ACC_TYPE] [varchar](50) NULL,
	[ACC_NUM] [varchar](150) NULL,
	[ACC_NAME] [nvarchar](250) NULL,
	[FUNTION] [varchar](50) NULL,
	[TK_GL] [varchar](100) NULL,
	[TK_GL_NAME] [varchar](1000) NULL,
	[CREATE_DT] [datetime] NULL,
	[MAKER_ID] [varchar](15) NULL,
	[EDITOR_ID] [varchar](15) NULL,
	[EDITOR_DT] [datetime] NULL,
	[AUTH_STATUS] [varchar](1) NULL,
	[CHECKER_ID] [varchar](15) NULL,
	[APPROVE_DT] [datetime] NULL
	)

	GO

CREATE PROC [dbo].[CM_ACCOUNT_Edit]
@p_REF_ID VARCHAR(15) = NULL
AS
BEGIN TRANSACTION

	-- LUU LOG
	INSERT INTO CM_ACCOUNT_PAY_LOG
	SELECT * FROM CM_ACCOUNT_PAY WHERE REF_ID = @p_REF_ID

	UPDATE CM_ACCOUNT_PAY SET AUTH_STATUS = 'U', CHECKER_ID = NULL, APPROVE_DT = NULL WHERE REF_ID = @p_REF_ID

COMMIT TRANSACTION

SELECT '0' as Result, @p_REF_ID  REF_ID, N'Cập nhật thành công. Bây giờ bạn có thể chỉnh sửa tài khoản tạm ứng này' ErrorDesc
RETURN '0'

ABORT:
BEGIN
		ROLLBACK TRANSACTION
		SELECT '-1' as Result, '' REF_ID, 'ERROR ABORT!' ErrorDesc
		RETURN '-1'
END