New standard Patronage Transaction Audit Detail Spreadsheet (AGS-9797)

Benefit:

• Minimize time and effort to analyze patronage transactions.

Navigation - Usage: 

PAT > Report Manager > Transaction Audit Reports > 1) Print Standard Reports > Transaction Audit Detail Spreadsheet.

1. Select Standard Report 2, Transaction Audit Detail Spreadsheet
2. 
3. The following columns of data appear in the spreadsheet:
   1. PATRON NAME ID
   2. PATRON NAME
   3. SOCIAL SECURITY #
   4. CELL PHONE
   5. User Defined #3
   6. TRANSACT DATE
   7. PROCESS DATE
   8. LOCATION
   9. TRANSACT NUMBER
   10. TRANSACTION TYPE
   11. TRANSACTION DESCRIPTION
   12. DISTRIBUTION TYPE
   13. DISTRIBUTION DESCRIPTION
   14. STOCK/EQUITY TYPE
   15. STOCK/EQUITY DESCRIPTION
   16. ACTIVE CERT./EQUITY
   17. CERT./EQUITY NUMBER
   18. ORIG. CERT./EQUITY
   19. INVC/ VOUCH
   20. SHARES
   21. PERCENT
   22. ALLOCATED FUNDS
   23. DIST. AMOUNT
   24. STOCK CREDITS
   25. CREDITS BALANCE
   26. STOCK ISSUED
   27. STOCK BALANCE
   28. AMOUNT PAYABLE
   29. PATRON EQUITY
   30. EQUITY BALANCE
   31. GENERAL RESERVE
   32. EQUITY REMAINING
   33. ALTERNATIVE MINIMUM TAX
   34. TRANSACTION AMOUNT
   35. LOCATION DESCRIPTION
   36. LOCATION REM #1
   37. LOCATION REM #2
   38. NAME ID TYPE
   39. MEMBER
   40. PRODUCER
   41. NEWSLETTER
   42. DIRECTOR
   43. Customer Type
   44. CREDIT RATING
   45. NAME ID TYPE DESCR.
   46. MEMBER DESCR.
   47. PRODUCER DESCR.
   48. NEWSLETTER DESCR.
   49. DIRECTOR DESCR.
   50. Customer Type DESCR.
   51. CREDIT RATING DESCR.
   52. BIRTH DATE
   53. EQUITY SOURCE CODE
   54. EQUITY DESCRIPTION
   55. STN ID
   56. USR ID
   57. AUDIT DATE
   58. AUDIT TIME
   59. AUDIT TYPE

Related Content: