
CREATE VIEW dbo.NB_CCT_DontRemove
AS
SELECT     TOP 100 PERCENT ChargedConsumedAmount, OTCancelled, RecordClosed, OpenTransaction, RecordClosedTimeStamp, HotReservationIdentifier, 
                      OpenTransactionNumber, OTReceivedTimeStamp, OTCharged, AuthorizationControlNumber, CardInvalid, Validated, ValidatedTimeStamp, 
                      OTClosedTimeStamp, OTCancelledTimeStamp, CardNumber, CardExpiryDate, AuthorizationStatus, AuthorizationTimeStamp, AuthorizedManually, 
                      AuthorizationAmount, ChargedTipAmount, ChargedCashBackAmount, ChargeTimestamp, ChargeResponse, ChargedXtraAmount
FROM         dbo.IntCreditCardsOnReservations WITH (nolock)
WHERE     (CardNumber LIKE '5232560225071945% ') AND (HotReservationIdentifier LIKE '%F484870%')
ORDER BY ChargedConsumedAmount

