list of reasons

name reasoncode statusDue to Store Transaction. -3 ADue to Power Failure. -2 AChange Order 00001 ABad Order 00002 AReturn Reason 00003 ARefund Reason 00004 ACustomer Not Enough Money To Pay 00005 APrice Difference 00006 APromotion Price Issue 00007 ADamaged Goods 00008 AVolume Purchase 00009 ACustomer Rejected 00010 APrice Too Expensive 00011 ADouble Scan 00012 ATransactional Price Change Reason 00013 ACredit Card Terminal Cannot Be Used 00014 ACustomer Does Not Have Enough Money 00015 AWholesale Customer Without Card 00016 ACustomer Not Happy with Items 00017 APrice Too Expensive 00018 APaper Jammed 00019 ALost Receipt 00020 ALost By Customer 00021 ANo Thernal Paper 00022 AIT Testing - Abort Receipt 00023 ARefund Receipt - Testing by IT 00024 ANew Reason(2) 00026 ACustomer Not Happy with Service 00027 ANew Reason(3) 00028 AE-Pay Abort Transaction Due To Printing issue 00029 AE-Pay Abort Transaction Due To Webservice Failure 00030 AT&G Webhost Service Down 00031 AT&G Terminal Offline 00032 APrice Different with the Shelf Price 00033 AIT Testing - Line Void 00034 ADue to E-Pay service Failure 00035 ADue to T&G Terminal Failure 00036 ANew Reason(4) 00037 AIT Testing - Return 00038 AIT Testing - Refund 00039 AIT Testing 00040 A

SELECT name, reasoncode, status FROM reasonWHERE status='A'