Skip to content
Thoroughbred Software InternationalThoroughbred Software InternationalThoroughbred DocumentationDocs

Customer Database

Customer File (UTCUST)

Cust Cust Sales Credit Credit Open AR YTD

Code Name Address City State ZIP Phone Rep. Terms Limit Cmnt Balance Sales

0001
Warren 1500 Boulevard Warren CT 10078 (203) 003 6 1000 T 1618.55 Baseball Rd. 774-2415 Club
0002
Lakewood 40 North Main South NY 10112 (516) 001 C 1000 T 822.50 2388.50 Little Street Hampton 934-0221 League
0003
Southside 100 Locust Rochelle NJ 07011 (201) 004 3 1000 T 412.78 1153.65 Raiders Ave. Park 345-3240
0004
Blue 91 Bayway Brooklyn NY 10114 (718) 002 6 1000 T 1105.52 1980.50 Diamond Ave. 230-2424 Baseball
0005 Team
503 Glenview New York NY 10012 (212) 001 9 1000 T 664.05 2831.65 Sports Dr. 423-4555
0006
Westfield 100 East Broad Westfield NJ 07090 (732) 004 3 1000 T 525.97 2785.80 Recreation St. 232-1500
0007
Dayton 725 Austin Springfield NJ 07082 (732) 001 C 1000 T 503.70 1259.25 Little Devils St. 433-4300 Baseball
0008
Hartford 100 Route 66 Hartford CT 10081 (203) 003 6 1000 T 1088.25 2353.90 Recreation 340-3434 Office
0009
Paramus 750 Walsh Lane Paramus NJ 07231 (201) 003 6 1000 T 291.30 1717.00 Little 236-4001 League
0010
Fords Little 1967 North Clark Fords NJ 07034 (732) 002 3 1000 T 347.55 505.85 League St. 345-9292 All-Stars
0011
Princeton 440 Nassau St. Princeton NJ 08718 (609) 004 9 1000 T 687.50 2545.20 Amateur 359-9090 League
0012
Hackensack 191 Lincoln Hackensac NJ 07071 (201) 001 C 1000 T 825.21 1729.10 Hackers Drive 452-3544
Rep Code Rep (UTREP) Phone YTD
Code Rep Name Ext Commission
001 James Johnson 4513 546.05
002 Helen Tyler 4511 428.62
003 Mike Walsh 4518 235.60
004 Brian Andrew 4503 298.71
Open AR Invoice File (UTOPENAR) Customer
Number Due Date Net Amount Total Payments Code
B00102 02/05/98 664.05 398.43 0006
B00105 01/18/98 167.85 .00 0012
B00111 04/03/98 470.05 282.03 0004
B00115 02/14/98 165.85 .00 0002
B00117 02/19/98 448.20 268.92 0007
B00118 02/21/98 656.65 393.99 0012
B00123 04/29/98 493.50 .00 0004
B00128 03/08/98 811.05 486.63 0007
B00129 04/09/98 620.95 372.57 0003
B00135 06/19/98 300.20 .00 0011
B00136 03/24/98 314.55 .00 0002
B00137 03/24/98 394.70 .00 0012
B00138 05/28/98 199.70 .00 0004
B00139 05/29/98 668.25 .00 0008
B00140 06/04/98 291.30 .00 0009
B00141 05/06/98 347.55 .00 0010
B00142 07/06/98 387.75 .00 0011
B00143 06/10/98 224.30 .00 0004
B00144 07/12/98 664.05 .00 0005
B00145 05/15/98 260.35 .00 0006
B00146 06/17/98 420.00 .00 0008
B00147 04/18/98 342.10 .00 0002
B00148 05/19/98 164.40 .00 0003
Sales History (UTSALHSH)
Invoice Invoice Rep Customer Rep Net
Number Date Code Code Commission Sale Amount
B00100 01/05/98 004 0001 19.29 385.70
B00101 01/05/98 002 0005 56.02 700.25
B00102 01/06/98 001 0006 53.12 664.05
B00103 01/12/98 002 0011 56.74 709.25
B00104 01/15/98 003 0002 27.67 553.40
B00105 01/18/98 002 0012 13.43 167.85
B00106 01/19/98 001 0004 17.51 218.85
B00107 01/21/98 001 0008 09.03 112.90
B00108 01/24/98 002 0009 40.04 500.50
B00109 01/29/98 001 0010 12.66 158.30
B00110 02/01/98 004 0011 15.38 307.65
Invoice Number Invoice Date Rep Code Customer Code Rep Commission Net Sale Amount
B00111 02/02/98 001 0004 37.60 470.05
B00112 02/05/98 002 0005 13.27 165.85
B00113 02/06/98 004 0006 32.91 658.10
B00114 02/08/98 004 0008 19.11 382.15
B00115 02/14/98 003 0002 08.29 165.85
B00116 02/15/98 004 0003 18.42 268.30
B00117 02/19/98 003 0007 22.41 448.20
B00118 02/21/98 001 0012 52.53 656.65
B00119 02/23/98 004 0002 50.63 1012.60
B00120 02/25/98 003 0011 42.02 840.35
B00121 02/27/98 004 0012 25.50 509.90
B00122 02/27/98 002 0005 22.79 284.85
B00123 02/28/98 004 0004 24.68 493.50
B00124 03/02/98 002 0004 29.93 374.10
B00125 03/04/98 002 0009 74.02 925.20
B00126 03/05/98 001 0008 61.65 770.60
B00127 03/05/98 002 0006 52.03 650.40
B00128 03/08/98 001 0007 64.88 811.05
B00129 03/10/98 003 0003 31.05 620.95
B00130 03/14/98 004 0001 26.15 523.05
B00131 03/14/98 001 0005 32.33 404.10
B00132 03/15/98 001 0001 56.78 709.80
B00133 03/16/98 004 0005 30.63 612.55
B00134 03/18/98 003 0006 27.65 552.90
B00135 03/21/98 004 0011 15.01 300.20
B00136 03/24/98 003 0002 15.73 314.55
B00137 03/24/98 002 0012 31.58 394.70
B00138 03/29/98 003 0004 09.99 199.70
B00139 03/30/98 003 0008 33.41 668.25
B00140 04/05/98 001 0009 23.30 291.30
B00141 04/06/98 003 0010 17.38 347.55
B00142 04/07/98 001 0011 31.02 387.75
B00143 04/11/98 002 0004 17.94 224.30
B00144 04/13/98 001 0005 53.12 664.05
B00145 04/15/98 002 0006 20.83 260.35
B00146 04/18/98 004 0008 21.00 420.00
B00147 04/18/98 001 0002 27.37 342.10
B00148 04/18/98 001 0003 13.15 164.40

From the Query-IV Reference, version 8.9.1. Open this page in the PDF