Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Benefits

Benefit:

  • Minimize time and effort to analyze patronage transactions.

Details:


Navigation

:  

Navigation - Usage: 

Stock/Equity Spreadsheet By Equity Type:  

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

.

  1. Select Standard Report 2, Transaction Audit Detail Spreadsheet
  2. 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:

Page Tree
rootPAT - Patronage (19.3.0)