home *** CD-ROM | disk | FTP | other *** search
/ Frostbyte's 1980s DOS Shareware Collection / floppyshareware.zip / floppyshareware / DOOG / QATEMPLA.ZIP / PERSACCT.DTF (.txt) < prev    next >
Symantec Q&A Database File  |  1990-03-13  |  66KB  |  453 lines
  1. SYMANTEC TOUCHBASE DATABASE
  2. rrison x8980
  3.                                                       CHECK NUMBER :AB      > 
  4.                                                                               
  5.                                                       DATE :AC              > 
  6.                                                                               
  7.    Pay To The                                                                 
  8.    Order Of :AD                                      >Amount   <AE          > 
  9.    <AF                                                                      > 
  10.                                                                               
  11.    Memo:AG                                  >                                 
  12.       <AH      ><AI      ><AJ      >
  13.          DATE DEPOSIT :AK             >     DEPOSIT      :AL       >
  14.          Deposit Memo:AM                                           >
  15.                                            
  16.          PREV. BALANCE:AN         >        
  17. BALANCE FWD  :AO         >
  18.                                            
  19. Check #:AP    >         Paid?<AQ>
  20. Amount :AR        >
  21. Posted (Y/N):AS   >
  22. Deposit:AT        >
  23. <AU                                                                           >
  24. <AV                                                                           >
  25. <AW                                                                           >
  26. <AX                                                                           >
  27. <AY                                                                           >
  28. <AZ                                                                           >
  29. <Aa                                                                           >
  30. <Ab                                                                           >
  31. rrison x8980
  32. Q&A Accounts Manager           (Press any key to exit help)
  33.                        
  34. Select your option (1-8) and press [ENTER].
  35. To print checks, set the Batch Print field to Y in the appropriate record. Then select the Check Printing spec from FILE/PRINT. Afterwards, use MASS UPDATE to reset each Y value to N.
  36. 1990/01/191John Smith          9-83000011408 Elm Street, #4Cupertino, CA 95114408-555-12221990/01/19Sam O'Conner145.00ONE HUNDRED FORTY FIVE AND 00/100 DOLLARS*******************************Window CleaningN000011990/01/195000.00Initial Deposit000011990/01/191500.00Initial Deposit000011990/01/19Macys163.401ONE HUNDRED FORTY FIVE451FIVE40
  37. 1990/01/192John Smith          9-83000021408 Elm Street, #4Cupertino, CA 95114408-555-12221990/01/19Pacific Bells55.32FIFTY FIVE AND 32/100 DOLLARS*******************************************5" BellN000011990/01/19250.00Cash1320FIFTY FIVE551FIVE50
  38.             
  39. -#10+#20-#30
  40. Balance
  41. #50+#40
  42. !Checkbook Balance!@date
  43. !- # -
  44. 5114408-555-12221990/01/18000031990/01/181000.003
  45. /=/=/=
  46. 1,AS,F(D3)51015202530,F(N0)2025,F(N0)30
  47. #25-#15
  48. Balance
  49. #50+#40
  50. 1990/01/193John Smith          9-831408 Elm Street, #4Cupertino, CA 95114408-555-12221990/01/19Y000011990/01/19150.00000021990/01/19Shevron22.38Gas1) Withdrawal    
  51.              
  52. 1990/01/194John Smith          9-83000031408 Elm Street, #4Cupertino, CA 95114408-555-12221990/01/19John's Car Service232.00TWO HUNDRED THIRTY TWO AND 00/100 DOLLARS*******************************Car RepairY000021990/01/19500.00000011990/01/19250.00000031990/01/19APB335.003TWO HUNDRED THIRTY TWO321TWO30
  53. 1990/01/1934John Smith          9-831408 Elm S
  54. 1990/01/195John Smith          9-83000041408 Elm Street, #4Cupertino, CA 95114408-555-12221990/01/19Bruce Auman426.44FOUR HUNDRED TWENTY SIX AND 44/100 DOLLARS******************************Y000021990/01/19343.002440FOUR HUNDRED TWENTY SIX261SIX20ND THREE HUNDRED TWENTY THREE AND 00/100 DOLLARS********@
  55. 1990/01/226John Smith          9-83000051408 Elm Street, #4Cupertino, CA 95114408-555-12221990/01/22Elmer Fudd432.55FOUR HUNDRED THIRTY TWO AND 55/100 DOLLARS******************************Y000031990/01/224342.553550FOUR HUNDRED THIRTY TWO321TWO30
  56. /=/=/=
  57. 1,AS,F(D3)20251015530
  58.  Deposit into Checking$
  59. !Credit Card Balance!@date
  60. !- # -
  61.                                       
  62. #15-#25
  63. Balance
  64. #50+#40
  65. FD = FOOD        UT = UTILITY   MD = MEDICAL   ET = ENTRNMT 
  66.                                                           
  67. CL = CLOTHING    LN = LOAN      RT = Rent      TR = TRAVEL
  68.                                                           
  69. CA = CASH        EO = EAT OUT   IN = INSURANCE MS = MISC
  70.                                                         
  71. CR = CREDIT CARD HI = HOMESTUFF GF = GIFT      TX = TAX-EXM
  72. AU = Auto Repair GS = Gas Pay                  
  73.            
  74. /=/=8 Elm Street, #4Cupertino, CA 95114408-555-1
  75. 1,AS,F(D3)10152025
  76. THREE
  77. SEVEN
  78. EIGHT
  79. ELEVEN
  80. TWELVE
  81. THIRTEEN
  82. FOURTEEN
  83. FIFTEEN
  84. SIXTEEN
  85. SEVENTEEN
  86. EIGHTEEN
  87. NINETEEN
  88. TWENTY
  89. THIRTY
  90. FORTY
  91. FIFTY
  92. SIXTY
  93. SEVENTY
  94. EIGHTY
  95. NINETY
  96. Auto Repair/Maintenance
  97. Cash withdrawl
  98. Clothing
  99. Credit Card Payment
  100. Eat Out
  101. Entertainment
  102. Groceries
  103. Gas Payment
  104. Home Improvement
  105. Insurance
  106. Loan Payment
  107. Mortgage
  108. Medical
  109. Travel/Vacation
  110. Tax-Exempt
  111. Miscellaneous
  112. !Savings Balance!@date
  113. !- # -
  114.                                    A
  115. 10,I20,I30,I40,I50,I60,I70,I,I50,I60,I70,I      
  116. T-DateChk#Check!AmountDep#Check!DepositDep#Savings!DepositPmnt#Credit!Card!PaymentWtdl#Check!WithdrawalWtdl#Savings!WithdrawalChg #Credit!Card!Charge
  117.          C
  118. !All Account Totals!@date
  119. !Invalid Option
  120. !99999
  121. !Edit or Menu? (E/M) -
  122. ! HUNDRED
  123. ! THOUSAND 
  124. ! AND 00/100 DOLLARS
  125. ! AND 
  126. !/100 DOLLARS
  127. !99999
  128. !X#600
  129. !X#600
  130. !Edit or Menu? (E/M) -
  131. !99999
  132. !X#650
  133. !X#650
  134. !Edit or Menu? (E/M) -
  135. !99999
  136. !X#700
  137. !X#700
  138. !Edit or Menu? (E/M) -
  139. !99999
  140. !X#750
  141. !X#750
  142. !Edit or Menu? (E/M) -
  143. !99999
  144. !X#800
  145. !X#800
  146. !Edit or Menu? (E/M) -
  147. !99999
  148. !X#850
  149. !X#850
  150. !Edit or Menu? (E/M) -
  151.  #715="E" then {#715="";goto #700} else {#715D
  152. /=/=/=0
  153.       B
  154. Checkbook!Balance
  155. @total(#20)-@total(#10)-@total(#50)
  156. 100,MAX
  157. Savings!Balance
  158. @total(#30)-@total(#60)
  159. 110,MAX
  160. Credit Card!Balance
  161. @total(#40)-@total(#70)
  162. 120,MAX
  163.              
  164.         H
  165. /=/=,I57,F(D3)1015170
  166.                          
  167. !Checkbook Detail!@date
  168. !- # -
  169. 1,AS,I57,F(D3)10,H(15:Paid to:)15175055,F(D3)60658085,F(D3)9095                                            
  170. 2022,F(D3)2530100120,F(D3)130,H(20)150155
  171.                
  172. Memo:
  173. !Credit Card Detail!@date
  174. !- # -
  175.                   
  176. 1012,F(D3)15204042,F(D3)4550
  177.                        
  178. @date@numberJohn Smith          9-831408 Elm Street, #4Cupertino, CA 95114408-555-1222@dateY                  
  179. !Savings Detail!@date
  180. !- # -
  181. Checkbook Balance
  182. Credit Card Balance
  183. Savings Balance
  184. All Accounts
  185. Checkbook Detail
  186. Credit Card Detail
  187. Savings Detail
  188. 3,705,508,158,6010,713,12
  189. Check Printing
  190. <#998:goto#400<#10: goto #400>#400:if #400="1" then goto #1; if #400="2" then goto #600; if #400="3" then goto #750; if #400="4" then goto #800; if #400="5" then goto #650; if #400="6" then goto #850; if #400="7" then goto #700; cnext<#410:if #400="8" then {@help(#400); goto #400}; if #400 <>"" then @msg("Invalid Option");#400=""; goto #400<#999: goto #1<#1:if #1 = "" then {#2=@date;#33 = @xlookupr(@filename,"99999","X#1","X#1")+1;#1=@text(5-@len(#33),"0")+@str(#33);  goto #2}#2>#3:cnext>#4:#104="";#105="";#106="";#103="";if @instr(#4,".")=0 then{#104=#4;#110=@num(#104);#104=#110;#4=#4+".00"}else{#104=@left(#4,@instr(#4,".")-1);#110=@num(#104);#104=#110;#105=@mid(#4,@instr(#4,".")+1,2)+"0"};#108="";#120="";#107=0;goto#103<#103:if #110<>0then{#107=#107+1;#106=@right(#104,3);#104=@left(#110,@len(#110)-3);#110=#104;if @mid(#106,2,1) ="" then #106="00"+#106;if @mid(#106,3,1)="" then #106="0" +#106;#120=""; lookup(@left(#106,1),1,#120);goto #124} else goto #126>#5:lookup(#5,1,#5)<#500 = "Edit or Menu? (E/M) -";#505="M"; goto #505>#505:#500=""; if #505="E" then {#505="";goto #1} else {#505=""; #400="";goto #400}<#124:if #120 <>"" then #120=#120+" HUNDRED";#106=@del(#106,1,1);#108="";lookup(#106,1,#108);if #108="" then {#109=@left(#106,1);#109=#109*10;lookup(#109,1,#108);if#108<>""then#120=#120+" "+#108;#108="";lookup(@right(#106,1),1,#108)};cnext<#125:#120=#120+" "+#108; if #107=2 then #103=#120+" THOUSAND "+#103 else #103=#120+" "+#103;goto #103<#126:if #105="" then {#103=#103+" AND 00/100 DOLLARS"+@text(60,"*"); goto #5} else {#103=#103+" AND "+@left(#105,2)+"/100 DOLLARS"+@text(60,"*");goto #5}<#600:if #600 = "" then {#605=@date;#33 = @xlookupr(@filename,"99999","X#600","X#600")+1;#600=@text(5-@len(#33),"0")+@str(#33);  goto #605}#605<#620 = "Edit or Menu? (E/M) -";#625="M"; goto #625>#625:#620=""; if #625="E" then {#625="";goto #600} else {#625=""; #400="";goto #400}<#650:if #650 = "" then {#655=@date;#33 = @xlookupr(@filename,"99999","X#650","X#650")+1;#650=@text(5-@len(#33),"0")+@str(#33);  goto #655}#655<#660 = "Edit or Menu? (E/M) -";#675="M"; goto #675>#675:#660=""; if #675="E" then {#675="";goto #650} else {#675=""; #400="";goto #400}<#700:if #700 = "" then {#705=@date;#33 = @xlookupr(@filename,"99999","X#700","X#700")+1;#700=@text(5-@len(#33),"0")+@str(#33);  goto #705}#705<#710 = "Edit or Menu? (E/M) -";#715="M"; goto #715>#715:#710=""; if #715="E" then {#715="";goto #700} else {#715=""; #400="";goto #400}<#750:if #750 = "" then {#755=@date;#33 = @xlookupr(@filename,"99999","X#750","X#750")+1;#750=@text(5-@len(#33),"0")+@str(#33);  goto #755}#755<#760 = "Edit or Menu? (E/M) -";#765="M"; goto #765>#765:#760=""; if #765="E" then {#765="";goto #750} else {#765=""; #400="";goto #400}<#800:if #800 = "" then {#805=@date;#33 = @xlookupr(@filename,"99999","X#800","X#800")+1;#800=@text(5-@len(#33),"0")+@str(#33);  goto #805}#805<#810 = "Edit or Menu? (E/M) -";#815="M"; goto #815>#815:#810=""; if #815="E" then {#815="";goto #800} else {#815=""; #400="";goto #400}<#850:if #850 = "" then {#855=@date;#33 = @xlookupr(@filename,"99999","X#850","X#850")+1;#850=@text(5-@len(#33),"0")+@str(#33);  goto #855}#855<#860 = "Edit or Menu? (E/M) -";#865="M"; goto #865>#865:#860=""; if #865="E" then {#865="";goto #850} else {#865=""; #400="";goto #400}#33#104#105#120#106#107#108#109#110to #400}#33#104#105#120#106#107#108#109#110okupr(
  191. Jan 31, 1990
  192. 11:26 am
  193.           Q&A WRITE -- B. Emerald                                                                                                                                    
  194.                         
  195.  Q & A Personal Accountant 
  196.                                                           
  197.  Transaction Date 
  198.                        
  199. <AA                >
  200.                        
  201.        Transaction# <AB      > 
  202.       
  203.       
  204.   Checkbook    1) Write Check   
  205.   Credit Card   6) Charge       
  206.       
  207.                2) Deposit       
  208.                 7) Payment      
  209.       
  210.                3) Withdrawal    
  211.       
  212.                 8) Help         
  213.       
  214.   Savings      4) Withdrawal    
  215.                                 
  216.       
  217.                5) Deposit       
  218.        Option -<a><b>           
  219.       
  220.             Remember| Only one transaction of each type is allowed
  221.                       per record.  Hit [F10] to move to the next
  222.                       record, [SHIFT][F10] to save and exit and
  223.                       [ESC] to exit without saving.
  224.                              
  225.  Write Checks 
  226.   <AC                         >                             Check#<AD      >  
  227.   <AE                         >                                               
  228.   <AF                         >                                               
  229.   <AG                         >         Date:AH                  >            
  230.                                                                               
  231.    Pay To The                                                                 
  232.    Order Of<AI                                       >   Amount<AJ          > 
  233.    <AK                                                                      > 
  234.                                                                               
  235.    Memo:AL                                >  
  236.      Batch Print?<c>
  237.     <AM                   ><d>
  238.    <AN      ><AO      ><AP      >
  239. A                          
  240.  Deposit into Checking 
  241.                                                  Deposit#<AQ      >           
  242.      Date:AR                   >                                              
  243.                                                                               
  244.      Amount<AS           >                                                    
  245.                                                                               
  246.      Memo:AT                                           >                      
  247.     <AU                   ><e>
  248. A                           
  249.  Deposit into Savings 
  250.                                                  Deposit#<AV      >           
  251.      Date:AW                   >                                              
  252.                                                                               
  253.      Amount<AX           >                                                    
  254.                                                                               
  255.      Memo:AY                                           >                      
  256.     <AZ                   ><f>
  257. A                           
  258.  Credit Card Payment 
  259.                                                  Payment#<Aa      >           
  260.      Date:Ab                   >                                              
  261.                                                                               
  262.      Amount<Ac           >                                                    
  263.                                                                               
  264.      Memo:Ad                                           >                      
  265.     <Ae                   ><g>
  266. A                         
  267.  Withdrawal from Checking 
  268.                                               Withdrawal#<Af      >           
  269.      Date:Ag                   >                                              
  270.                                                                               
  271.      Amount<Ah           >                                                    
  272.                                                                               
  273.      Memo:Ai                                           >                      
  274.     <Aj                   ><h>
  275. A                         
  276.  Withdrawal from Savings 
  277.                                               Withdrawal#<Ak      >           
  278.      Date:Al                   >                                              
  279.                                                                               
  280.      Amount<Am           >                                                    
  281.                                                                               
  282.      Memo:An                                           >                      
  283.     <Ao                   ><i>
  284. A                            
  285.  Credit Card Charge 
  286.                                                   Charge#<Ap      >           
  287.      Date:Aq                   >                                              
  288.                                                                               
  289.      Paid to:Ar                                       >                       
  290.                                                                               
  291.      Amount<As           >                                                    
  292.                                                                               
  293.      Memo:At                                           >                      
  294.     <Au                   ><j>
  295. Tnum:Av       >
  296. <Aw                                                                           >
  297. <Ax                                                                           >
  298. <Ay                                                                           >
  299. <Az                                                                           >
  300. <BA                                                                           >
  301. <BB                                                                           >
  302. <BC                                                                           >
  303. <BD                                                                           >
  304. 1990/01/317John Smith          9-831408 Elm Street, #4Cupertino, CA 95114408-555-12221990/01/31Y
  305.  Q & A Personal Accountant 
  306.  Transaction Date 
  307.                   
  308.       
  309. Transaction#
  310.         
  311.   Checkbook    1) Write Check   
  312.   Credit Card   6) Charge       
  313.                2) Deposit       
  314.                 7) Payment      
  315.                3) Withdrawal    
  316.                 8) Help         
  317.   Savings      4) Withdrawal    
  318.                                 
  319.                5) Deposit       
  320.       
  321. Option -
  322. 6Remember| Only one transaction of each type is allowed
  323. *per record.  Hit [F10] to move to the next
  324. )record, [SHIFT][F10] to save and exit and
  325. [ESC] to exit without saving.
  326.  Write Checks 
  327.                            
  328. Check#
  329.         
  330.                            
  331.                            
  332.                            
  333. Date:
  334.                     
  335.                                                                               
  336.    Pay To The                                                                 
  337. Order Of
  338. )                                         
  339. Amount
  340.             
  341. H                                                                        
  342.                                                                               
  343. Memo:
  344. "                                  
  345. Batch Print?
  346.                      
  347.         
  348.         
  349.         
  350.  Deposit into Checking 
  351.                                                 
  352. Deposit#
  353.         
  354. Date:
  355.                      
  356.                                                                               
  357. Amount
  358.              
  359.                                                                               
  360. Memo:
  361. -                                             
  362.                      
  363.  Deposit into Savings 
  364.                                                 
  365. Deposit#
  366.         
  367. Date:
  368.                      
  369.                                                                               
  370. Amount
  371.              
  372.                                                                               
  373. Memo:
  374. -                                             
  375.                      
  376.  Credit Card Payment 
  377.                                                 
  378. Payment#
  379.         
  380. Date:
  381.                      
  382.                                                                               
  383. Amount
  384.              
  385.                                                                               
  386. Memo:
  387. -                                             
  388.                      
  389. N WICHTERMAN1989/06/19
  390.  Withdrawal from Checking 
  391.                                              
  392. Withdrawal#
  393.         
  394. Date:
  395.                      
  396.                                                                               
  397. Amount
  398.              
  399.                                                                               
  400. Memo:
  401. -                                             
  402.                      
  403.                                       /
  404.  Withdrawal from Savings 
  405.                                              
  406. Withdrawal#
  407.         
  408. Date:
  409.                      
  410.                                                                               
  411. Amount
  412.              
  413.                                                                               
  414. Memo:
  415. -                                             
  416.                      
  417.                                 >      2
  418.  Credit Card Charge 
  419.                                                  
  420. Charge#
  421.         
  422. Date:
  423.                      
  424.                                                                               
  425. Paid to:
  426. )                                         
  427.                                                                               
  428. Amount
  429.              
  430.                                                                               
  431. Memo:
  432. -                                             
  433.                      
  434.         3
  435. Tnum:
  436.              
  437. M                                                                             
  438. M                                                                             
  439. M                                                                             
  440. M                                                                             
  441. M                                                                             
  442. M                                                                             
  443. M                                                                             
  444. M                                                                             
  445.       > 
  446.                                                   acti@
  447.         
  448.   Checkbook    1) Write Check   
  449.   Credit Card   6) Charge       
  450.                2) Deposit       
  451.                 7) Payment      
  452.                3) Withdrawal    
  453.