Difference between revisions of "Teller Reports"
>Johno |
>Paulae |
||
Line 7: | Line 7: | ||
updated=2020/09/01| | updated=2020/09/01| | ||
results={{Results_Teller Related Accounts Shares and Loans|}} | results={{Results_Teller Related Accounts Shares and Loans|}} | ||
+ | }} | ||
+ | |||
+ | {{SampleContext| | ||
+ | name=Teller Transactions by Branch| | ||
+ | h2=This report selects all monetary transaction from the SH-HISTORY and LN-HISTORY databases.| | ||
+ | h1=The report is sorted by the BRANCH-GL-LOC field and TELLER-INTL and gives totals for each. The transactions are counted in one hour increments.| | ||
+ | link=Teller%20Transactions%20by%20Branch%20and%20Teller.ctx| | ||
+ | created=2020/08/31| | ||
+ | updated=2020/09/01| | ||
+ | results={{Results_Teller Transaction Counts|}} | ||
}} | }} | ||
[[Spectrum Context Library | Back to Context Library]] | [[Spectrum Context Library | Back to Context Library]] |
Revision as of 16:45, 10 September 2020
All Related Teller Accounts
- All Shares and Loans for the related accounts are displayed.
- Uses TELLER-FILE to display all related accounts.
Sample Report Output
Date: 08/31/2020 Related Teller Accounts Page: 1 Time: 9:13 AM Related ACCT Account Name SFX ACC/COLL Balance R11 R12 ----------------------------------------------------------------------------------------------- Related Accounts for Teller: kt KEVIN 207 JAMES N PADDOCK SHARES 00 RSA 180,529.36 0 0 01 SSA 716.79 0 0 10 HYA 5,888.85 0 0 15 SDA 46,364.66 0 0 81 NDC 0.00 80 0 Total: 233,499.66 LOANS 98 31 0.00 0 0 Total: 0.00 239 DAVID R WALLING SHARES 00 RSA 9,569.90 0 0 01 SSA 195.37 0 0 10 HYA 14,014.45 0 0 15 SDA 3,315.41 0 0 Total: 27,095.13 LOANS 60 9 0.00 80 0 61 9 0.00 0 0 98 31 1,580.95 0 0 Total: 1,580.95 273 KATHY MASON SHARES 00 RSA 9,395.47- 0 0 10 HYA 104,474.46 0 0 30 SMC 102,358.01 0 0 70 IRA 0.00 0 0 Total: 197,437.00 LOANS 87 22 140.15 0 0 Total: 140.15 644 GUY MORRIS SHARES 00 RSA 69,852.40 0 0 10 HYA 7,171.34 0 0 15 SDA 12,717.22 0 0 20 SMC 0.00 0 0 21 SMC 0.00 0 0 22 SMC 0.00 0 0 23 SMC 0.00 0 0 24 SMC 0.00 0 0 25 SMC 0.00 0 0 50 OYC 10,467.91 0 0 Total: 100,208.87 LOANS 98 31 4,060.01 0 0 Total: 4,060.01
Download All Related Teller Accounts
Created: 2020/08/31
Last Updated: 2020/09/01
Teller Transactions by Branch
- The report is sorted by the BRANCH-GL-LOC field and TELLER-INTL and gives totals for each. The transactions are counted in one hour increments.
- This report selects all monetary transaction from the SH-HISTORY and LN-HISTORY databases.
Sample Report Output
Date: 09/10/2020 Page: 1 Time: 8:48 AM Monthly Teller Transactions by Teller by Hour Totals for: June 2020 Teller Total 08:00 09:00 10:00 11:00 12:00 13:00 14:00 15:00 16:00 17:00 18:00 24:00 Transactions for Branch: 1 EVERYBODY'S CU - MAIN OFFICE 03D4 1 0 0 0 0 0 0 0 0 0 0 0 0 30I2 4 0 0 0 0 0 0 0 0 0 1 1 0 31I1 4 1 0 1 0 0 0 0 0 0 0 0 0 31I3 4 1 0 0 0 0 0 0 0 0 1 0 0 31I4 3 0 0 0 0 0 0 0 0 0 1 0 0 59I1 3 0 0 0 0 0 0 0 0 1 0 1 0 60I1 1 0 0 0 0 0 0 0 0 0 0 0 0 61I2 4 1 0 0 0 0 0 0 0 1 0 0 0 61I4 3 0 0 0 0 0 0 0 0 0 0 1 0 62I3 4 1 0 0 0 0 0 0 0 0 0 0 0 90I1 3 1 0 0 0 0 0 0 0 1 0 0 0 91I1 1 1 0 0 0 0 0 0 0 0 0 0 0 91I2 4 1 0 0 0 0 0 0 0 0 0 0 0 92I3 4 2 0 0 0 0 0 0 0 0 0 0 0 92I4 3 0 0 0 0 0 0 0 0 0 2 0 0 BOA 260 260 0 0 0 0 0 0 0 0 0 0 0 BOP 745 601 108 1 23 0 0 0 0 6 0 0 0 C24 28 28 0 0 0 0 0 0 0 0 0 0 0 ZZZ 10 4 1 1 0 0 0 0 0 1 3 0 0 __________________________________________________________________________________________________ Branch: 1 Total 1,089 902 109 3 23 0 0 0 0 10 8 3 0
Download Teller Transactions by Branch
Created: 2020/08/31
Last Updated: 2020/09/01