home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / NLSTATE.REP < prev    next >
Text File  |  1997-02-26  |  9KB  |  281 lines
  1. VERSION 2.00
  2. Begin Report NLSTATE.REP
  3.       Caption      =   "NLSTATE.REP"
  4.       Width        =   11175
  5.       Height       =   16395
  6.       Reportheader =   795
  7.       Header       =   1080
  8.       Transaction  =   3165
  9.       SubTotal     =   3150
  10.       Footer       =   0
  11.       Pagefooter   =   15690
  12.       Replicate    =   435
  13.       Style        =   1
  14.       Query        =   "NLTRAN "
  15.       Macro        =   "1LU:Select from NLNAME where NNACCOUNT=NLTRAN.NTCODE"
  16.       Macro        =   "1LU:Select from NLBANK where NBBANK=NLTRAN.NTCODE"
  17.       Macro        =   "1PP:@REPVARS.REPTOT(0) = NLBANK.NBBFWD"
  18.       Macro        =   "2CD:When NLTRAN.NTVALUE>0 then REPTOT(1)=REPTOT(1)+NLTRAN.NTVALUE"
  19.       Macro        =   "2CD:When NLTRAN.NTVALUE<0 then REPTOT(2)=REPTOT(2)-NLTRAN.NTVALUE"
  20.       Macro        =   "2OF:@REPVARS.REPTOT(0) = REPTOT(0)+NLTRAN.NTVALUE"
  21.       Macro        =   "3PP:@REPVARS.REPTOT(1) = 0"
  22.       Macro        =   "3PP:@REPVARS.REPTOT(2) = 0"
  23. End
  24. Begin Control LABEL
  25.       Type         =   "Label"
  26.       Style        =   4
  27.       Caption      =   "Bank Statement"
  28.       Font         =   "-315|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  29.       Location     =   "Reportheader Block"
  30.       Height       =   420
  31.       Left         =   135
  32.       Top          =   540
  33.       Width        =   10890
  34. End
  35. Begin Control LABEL
  36.       Type         =   "Label"
  37.       Style        =   9
  38.       Caption      =   "DTOC(DATE())"
  39.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  40.       Location     =   "Reportheader Block"
  41.       Height       =   285
  42.       Left         =   135
  43.       Top          =   720
  44.       Width        =   1800
  45. End
  46. Begin Control LABEL
  47.       Type         =   "Label"
  48.       Style        =   10
  49.       Caption      =   ""Page "+PAGENUM()"
  50.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  51.       Location     =   "Reportheader Block"
  52.       Height       =   285
  53.       Left         =   9210
  54.       Top          =   705
  55.       Width        =   1800
  56. End
  57. Begin Control LABEL
  58.       Type         =   "Label"
  59.       Style        =   12
  60.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  61.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  62.       Location     =   "Reportheader Block"
  63.       Height       =   420
  64.       Left         =   135
  65.       Top          =   135
  66.       Width        =   10890
  67. End
  68. Begin Control LABEL
  69.       Type         =   "Label"
  70.       Style        =   1
  71.       Caption      =   "Date"
  72.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  73.       Location     =   "Header Block"
  74.       Height       =   285
  75.       Left         =   135
  76.       Top          =   960
  77.       Width        =   1140
  78. End
  79. Begin Control LABEL
  80.       Type         =   "Label"
  81.       Style        =   1
  82.       Caption      =   "Reference"
  83.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  84.       Location     =   "Header Block"
  85.       Height       =   285
  86.       Left         =   1575
  87.       Top          =   960
  88.       Width        =   1140
  89. End
  90. Begin Control LABEL
  91.       Type         =   "Label"
  92.       Style        =   2
  93.       Caption      =   "Payments"
  94.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  95.       Location     =   "Header Block"
  96.       Height       =   285
  97.       Left         =   5835
  98.       Top          =   960
  99.       Width        =   1410
  100. End
  101. Begin Control LABEL
  102.       Type         =   "Label"
  103.       Style        =   2
  104.       Caption      =   "Balance"
  105.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  106.       Location     =   "Header Block"
  107.       Height       =   285
  108.       Left         =   9030
  109.       Top          =   960
  110.       Width        =   1275
  111. End
  112. Begin Control LABEL
  113.       Type         =   "Label"
  114.       Style        =   2
  115.       Caption      =   "Receipts"
  116.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  117.       Location     =   "Header Block"
  118.       Height       =   285
  119.       Left         =   7455
  120.       Top          =   960
  121.       Width        =   1410
  122. End
  123. Begin Control NNACCOUNT
  124.       Type         =   "Text"
  125.       Style        =   0
  126.       Fieldname    =   "NNACCOUNT"
  127.       Filename     =   "NLNAME"
  128.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  129.       Location     =   "Header Block"
  130.       Height       =   270
  131.       Left         =   1485
  132.       Top          =   420
  133.       Width        =   810
  134. End
  135. Begin Control LABEL
  136.       Type         =   "Label"
  137.       Style        =   1
  138.       Caption      =   "Bank Account:"
  139.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  140.       Location     =   "Header Block"
  141.       Height       =   270
  142.       Left         =   135
  143.       Top          =   420
  144.       Width        =   1350
  145. End
  146. Begin Control LABEL
  147.       Type         =   "Label"
  148.       Style        =   1
  149.       Caption      =   "Details"
  150.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  151.       Location     =   "Header Block"
  152.       Height       =   285
  153.       Left         =   3465
  154.       Top          =   960
  155.       Width        =   1140
  156. End
  157. Begin Control NNACCNAME
  158.       Type         =   "Text"
  159.       Style        =   0
  160.       Fieldname    =   "NNACCNAME"
  161.       Filename     =   "NLNAME"
  162.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  163.       Location     =   "Header Block"
  164.       Height       =   270
  165.       Left         =   2430
  166.       Top          =   420
  167.       Width        =   3510
  168. End
  169. Begin Control LABEL
  170.       Type         =   "Label"
  171.       Style        =   1
  172.       Caption      =   "Bfwd Balance:"
  173.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  174.       Location     =   "Header Block"
  175.       Height       =   270
  176.       Left         =   7560
  177.       Top          =   420
  178.       Width        =   1350
  179. End
  180. Begin Control LABEL
  181.       Type         =   "Label"
  182.       Style        =   10
  183.       Caption      =   "STR(NLBANK.NBBFWD,12,2)"
  184.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  185.       Location     =   "Header Block"
  186.       Height       =   285
  187.       Left         =   8940
  188.       Top          =   420
  189.       Width        =   1410
  190. End
  191. Begin Control NTTXNDATE
  192.       Type         =   "Text"
  193.       Style        =   0
  194.       Fieldname    =   "NTTXNDATE"
  195.       Filename     =   "NLTRAN"
  196.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  197.       Location     =   "Transaction Block"
  198.       Height       =   270
  199.       Left         =   135
  200.       Top          =   135
  201.       Width        =   1275
  202. End
  203. Begin Control NTCOMMENT
  204.       Type         =   "Text"
  205.       Style        =   0
  206.       Fieldname    =   "NTCOMMENT"
  207.       Filename     =   "NLTRAN"
  208.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  209.       Location     =   "Transaction Block"
  210.       Height       =   270
  211.       Left         =   1575
  212.       Top          =   135
  213.       Width        =   1275
  214. End
  215. Begin Control LABEL
  216.       Type         =   "Label"
  217.       Style        =   10
  218.       Caption      =   "CORD(NLTRAN.NTVALUE,10,2,-1)"
  219.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  220.       Location     =   "Transaction Block"
  221.       Height       =   285
  222.       Left         =   5835
  223.       Top          =   150
  224.       Width        =   1410
  225. End
  226. Begin Control LABEL
  227.       Type         =   "Label"
  228.       Style        =   10
  229.       Caption      =   "CORD(NLTRAN.NTVALUE,10,2,1)"
  230.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  231.       Location     =   "Transaction Block"
  232.       Height       =   285
  233.       Left         =   7455
  234.       Top          =   150
  235.       Width        =   1410
  236. End
  237. Begin Control LABEL
  238.       Type         =   "Label"
  239.       Style        =   10
  240.       Caption      =   "STR(REPTOT(0),12,2)"
  241.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  242.       Location     =   "Transaction Block"
  243.       Height       =   285
  244.       Left         =   8940
  245.       Top          =   150
  246.       Width        =   1815
  247. End
  248. Begin Control LABEL
  249.       Type         =   "Label"
  250.       Style        =   9
  251.       Caption      =   "MID("               Journal         Sales Receipt   Purchase PaymentJournal         Cash Book                                                       Payroll",NLTRAN.NTTXNTYPE*16,16)"
  252.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  253.       Location     =   "Transaction Block"
  254.       Height       =   270
  255.       Left         =   3375
  256.       Top          =   150
  257.       Width        =   2025
  258. End
  259. Begin Control LABEL
  260.       Type         =   "Label"
  261.       Style        =   10
  262.       Caption      =   "STR(REPTOT(1),10,2)"
  263.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  264.       Location     =   "Subtotal Block"
  265.       Height       =   285
  266.       Left         =   7455
  267.       Top          =   495
  268.       Width        =   1410
  269. End
  270. Begin Control LABEL
  271.       Type         =   "Label"
  272.       Style        =   10
  273.       Caption      =   "STR(REPTOT(2),10,2)"
  274.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  275.       Location     =   "Subtotal Block"
  276.       Height       =   285
  277.       Left         =   5835
  278.       Top          =   495
  279.       Width        =   1410
  280. End
  281.