CREATE VIEW [dbo].[pal_vSMSCreditHistory]
AS
SELECT	S.recId,S.customerCode,S.transactionDate,S.reference,S.qty
		,T.transactionType,U.userDisplay
FROM	pal_SMSCreditLog S
		JOIN pal_SMSCreditTransactionType T
			ON T.recId = S.transactionType
		JOIN pal_User U
			ON U.recId = S.userId
