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. Open

   

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: