Transaction Inspection

set @store='000000', @storeid=?, @dt='yyyy-mm-dd', @term='0000', @trx=?;

 

select ID,AccountID,CardID,date(transactiondatetime) as TransDate,StoreID,TerminalID,PosTransactionID,TransactionCode,Upc,Quantity,Price,Department,

DiscountOffered,DiscountQuantity,Comments,TotalSpent,PointsAmount,TaxableAmount,TaxAmount,TotalAmount

from transactions

where date(TransactionDateTime) = @dt

and storeid=@storeid

and TerminalID=@term

and PosTransactionID=@trx;

 

select id,AccountID,CardID,date(transactiondatetime) as TransDate,StoreID,TerminalID,POS_TransactionID,TransactionCode,Comments,TotalSpent,QualifiedAmount,PointsAmount

from pointstransactions

where date(TransactionDateTime) = @dt

and storeid=@storeid

and TerminalID=@term

and Pos_TransactionID=@trx;

 

select ID,storeNum,transDate,terminal,transaction,memberId,Created

from offers_inquiries

where storenum = @store

and date(transdate) = date(@dt)

and terminal = @term

and transaction = @trx;

select ID,storeNum,transDate,terminal,transaction,quantity,productCode,GTIN,deptNo,price,itemSeqNo,ptIssue,ptBonus,UpdateState,Created

from offers_cart

where storenum = @store

and date(transdate) = date(@dt)

and terminal = @term

and transaction = @trx;

select ID,storeNum,transDate,terminal,transaction,OfferID,SpecialID,offerGroup,qualOrDisc,productCode,amount,sequenceNum,isRedemption,used,ptIssue,ptBonus,Created

from offers_deal

where storenum = @store

and date(transdate) = date(@dt)

and terminal = @term

and transaction = @trx;