home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / SLACCLST.REP < prev    next >
Text File  |  1996-10-08  |  17KB  |  520 lines
  1. VERSION 2.00
  2. Begin Report SLACCLST.REP
  3.       Caption      =   "SLACCLST.REP"
  4.       Width        =   11175
  5.       Height       =   15825
  6.       Reportheader =   795
  7.       Header       =   0
  8.       Transaction  =   14895
  9.       SubTotal     =   0
  10.       Footer       =   0
  11.       Pagefooter   =   15690
  12.       Replicate    =   2580
  13.       Style        =   1
  14.       Query        =   "SLNAME SNACCOUNT=>^@0 & SNACCOUNT<=^@1 ORDER BY SNACCOUNT"
  15. End
  16. Begin Control LABEL
  17.       Type         =   "Label"
  18.       Style        =   4
  19.       Caption      =   "Customer Details Listing"
  20.       Font         =   "-315|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  21.       Location     =   "Reportheader Block"
  22.       Height       =   420
  23.       Left         =   135
  24.       Top          =   540
  25.       Width        =   10890
  26. End
  27. Begin Control LABEL
  28.       Type         =   "Label"
  29.       Style        =   9
  30.       Caption      =   "DTOC(DATE())"
  31.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  32.       Location     =   "Reportheader Block"
  33.       Height       =   285
  34.       Left         =   135
  35.       Top          =   720
  36.       Width        =   1800
  37. End
  38. Begin Control LABEL
  39.       Type         =   "Label"
  40.       Style        =   10
  41.       Caption      =   ""Page "+PAGENUM()"
  42.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  43.       Location     =   "Reportheader Block"
  44.       Height       =   285
  45.       Left         =   9210
  46.       Top          =   705
  47.       Width        =   1800
  48. End
  49. Begin Control LABEL
  50.       Type         =   "Label"
  51.       Style        =   12
  52.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  53.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  54.       Location     =   "Reportheader Block"
  55.       Height       =   420
  56.       Left         =   135
  57.       Top          =   135
  58.       Width        =   10890
  59. End
  60. Begin Control SNNAME
  61.       Type         =   "Text"
  62.       Style        =   0
  63.       Fieldname    =   "SNNAME"
  64.       Filename     =   "SLNAME"
  65.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  66.       Location     =   "Transaction Block"
  67.       Height       =   270
  68.       Left         =   1350
  69.       Top          =   420
  70.       Width        =   2970
  71. End
  72. Begin Control SNADD1
  73.       Type         =   "Text"
  74.       Style        =   0
  75.       Fieldname    =   "SNADD1"
  76.       Filename     =   "SLNAME"
  77.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  78.       Location     =   "Transaction Block"
  79.       Height       =   270
  80.       Left         =   1350
  81.       Top          =   690
  82.       Width        =   2970
  83. End
  84. Begin Control SNADD2
  85.       Type         =   "Text"
  86.       Style        =   0
  87.       Fieldname    =   "SNADD2"
  88.       Filename     =   "SLNAME"
  89.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  90.       Location     =   "Transaction Block"
  91.       Height       =   270
  92.       Left         =   1350
  93.       Top          =   960
  94.       Width        =   2970
  95. End
  96. Begin Control SNADD3
  97.       Type         =   "Text"
  98.       Style        =   0
  99.       Fieldname    =   "SNADD3"
  100.       Filename     =   "SLNAME"
  101.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  102.       Location     =   "Transaction Block"
  103.       Height       =   270
  104.       Left         =   1350
  105.       Top          =   1230
  106.       Width        =   2970
  107. End
  108. Begin Control SNADD4
  109.       Type         =   "Text"
  110.       Style        =   0
  111.       Fieldname    =   "SNADD4"
  112.       Filename     =   "SLNAME"
  113.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  114.       Location     =   "Transaction Block"
  115.       Height       =   270
  116.       Left         =   1350
  117.       Top          =   1500
  118.       Width        =   2970
  119. End
  120. Begin Control SNPOSTCODE
  121.       Type         =   "Text"
  122.       Style        =   0
  123.       Fieldname    =   "SNPOSTCODE"
  124.       Filename     =   "SLNAME"
  125.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  126.       Location     =   "Transaction Block"
  127.       Height       =   270
  128.       Left         =   1350
  129.       Top          =   1770
  130.       Width        =   2970
  131. End
  132. Begin Control SNACCOUNT
  133.       Type         =   "Text"
  134.       Style        =   0
  135.       Fieldname    =   "SNACCOUNT"
  136.       Filename     =   "SLNAME"
  137.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  138.       Location     =   "Transaction Block"
  139.       Height       =   270
  140.       Left         =   135
  141.       Top          =   420
  142.       Width        =   945
  143. End
  144. Begin Control LABEL
  145.       Type         =   "Label"
  146.       Style        =   1
  147.       Caption      =   "T/Over:"
  148.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  149.       Location     =   "Transaction Block"
  150.       Height       =   270
  151.       Left         =   8100
  152.       Top          =   420
  153.       Width        =   810
  154. End
  155. Begin Control SNTURNOVER
  156.       Type         =   "Text"
  157.       Style        =   0
  158.       Fieldname    =   "SNTURNOVER"
  159.       Filename     =   "SLNAME"
  160.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  161.       Location     =   "Transaction Block"
  162.       Height       =   270
  163.       Left         =   9315
  164.       Top          =   420
  165.       Width        =   1080
  166. End
  167. Begin Control LABEL
  168.       Type         =   "Label"
  169.       Style        =   1
  170.       Caption      =   "C/R Limit:"
  171.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  172.       Location     =   "Transaction Block"
  173.       Height       =   270
  174.       Left         =   8100
  175.       Top          =   690
  176.       Width        =   810
  177. End
  178. Begin Control SNCREDIT
  179.       Type         =   "Text"
  180.       Style        =   0
  181.       Fieldname    =   "SNCREDIT"
  182.       Filename     =   "SLNAME"
  183.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  184.       Location     =   "Transaction Block"
  185.       Height       =   270
  186.       Left         =   9315
  187.       Top          =   690
  188.       Width        =   1080
  189. End
  190. Begin Control SNTEL
  191.       Type         =   "Text"
  192.       Style        =   0
  193.       Fieldname    =   "SNTEL"
  194.       Filename     =   "SLNAME"
  195.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  196.       Location     =   "Transaction Block"
  197.       Height       =   270
  198.       Left         =   5400
  199.       Top          =   420
  200.       Width        =   1890
  201. End
  202. Begin Control SNFAX
  203.       Type         =   "Text"
  204.       Style        =   0
  205.       Fieldname    =   "SNFAX"
  206.       Filename     =   "SLNAME"
  207.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  208.       Location     =   "Transaction Block"
  209.       Height       =   270
  210.       Left         =   5400
  211.       Top          =   690
  212.       Width        =   1890
  213. End
  214. Begin Control LABEL
  215.       Type         =   "Label"
  216.       Style        =   1
  217.       Caption      =   "Tel:"
  218.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  219.       Location     =   "Transaction Block"
  220.       Height       =   270
  221.       Left         =   4455
  222.       Top          =   420
  223.       Width        =   675
  224. End
  225. Begin Control LABEL
  226.       Type         =   "Label"
  227.       Style        =   1
  228.       Caption      =   "Fax:"
  229.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  230.       Location     =   "Transaction Block"
  231.       Height       =   270
  232.       Left         =   4455
  233.       Top          =   690
  234.       Width        =   675
  235. End
  236. Begin Control SNCONTACT
  237.       Type         =   "Text"
  238.       Style        =   0
  239.       Fieldname    =   "SNCONTACT"
  240.       Filename     =   "SLNAME"
  241.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  242.       Location     =   "Transaction Block"
  243.       Height       =   270
  244.       Left         =   5400
  245.       Top          =   960
  246.       Width        =   2565
  247. End
  248. Begin Control LABEL
  249.       Type         =   "Label"
  250.       Style        =   1
  251.       Caption      =   "Contact:"
  252.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  253.       Location     =   "Transaction Block"
  254.       Height       =   270
  255.       Left         =   4455
  256.       Top          =   960
  257.       Width        =   810
  258. End
  259. Begin Control LABEL
  260.       Type         =   "Label"
  261.       Style        =   1
  262.       Caption      =   "Disc Code:"
  263.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  264.       Location     =   "Transaction Block"
  265.       Height       =   270
  266.       Left         =   8100
  267.       Top          =   1500
  268.       Width        =   945
  269. End
  270. Begin Control LABEL
  271.       Type         =   "Label"
  272.       Style        =   1
  273.       Caption      =   "Area Code:"
  274.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  275.       Location     =   "Transaction Block"
  276.       Height       =   270
  277.       Left         =   8100
  278.       Top          =   1770
  279.       Width        =   945
  280. End
  281. Begin Control LABEL
  282.       Type         =   "Label"
  283.       Style        =   1
  284.       Caption      =   "Country:"
  285.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  286.       Location     =   "Transaction Block"
  287.       Height       =   270
  288.       Left         =   4455
  289.       Top          =   1230
  290.       Width        =   810
  291. End
  292. Begin Control LABEL
  293.       Type         =   "Label"
  294.       Style        =   1
  295.       Caption      =   "VAT Reg:"
  296.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  297.       Location     =   "Transaction Block"
  298.       Height       =   270
  299.       Left         =   4455
  300.       Top          =   1500
  301.       Width        =   810
  302. End
  303. Begin Control LABEL
  304.       Type         =   "Label"
  305.       Style        =   1
  306.       Caption      =   "VAT Code:"
  307.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  308.       Location     =   "Transaction Block"
  309.       Height       =   270
  310.       Left         =   4455
  311.       Top          =   1770
  312.       Width        =   945
  313. End
  314. Begin Control SNCOUNTRY
  315.       Type         =   "Text"
  316.       Style        =   0
  317.       Fieldname    =   "SNCOUNTRY"
  318.       Filename     =   "SLNAME"
  319.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  320.       Location     =   "Transaction Block"
  321.       Height       =   270
  322.       Left         =   5400
  323.       Top          =   1230
  324.       Width        =   2565
  325. End
  326. Begin Control SNVATREGNO
  327.       Type         =   "Text"
  328.       Style        =   0
  329.       Fieldname    =   "SNVATREGNO"
  330.       Filename     =   "SLNAME"
  331.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  332.       Location     =   "Transaction Block"
  333.       Height       =   270
  334.       Left         =   5400
  335.       Top          =   1500
  336.       Width        =   2565
  337. End
  338. Begin Control SNDFLTVAT
  339.       Type         =   "Text"
  340.       Style        =   0
  341.       Fieldname    =   "SNDFLTVAT"
  342.       Filename     =   "SLNAME"
  343.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  344.       Location     =   "Transaction Block"
  345.       Height       =   270
  346.       Left         =   5400
  347.       Top          =   1770
  348.       Width        =   405
  349. End
  350. Begin Control LABEL
  351.       Type         =   "Label"
  352.       Style        =   1
  353.       Caption      =   "VAT Code:"
  354.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  355.       Location     =   "Transaction Block"
  356.       Height       =   270
  357.       Left         =   4455
  358.       Top          =   1770
  359.       Width        =   945
  360. End
  361. Begin Control LABEL
  362.       Type         =   "Label"
  363.       Style        =   9
  364.       Caption      =   "IF(SLNAME.SNDUEDTOPT=0,"Payment Days:","Day of Month:")"
  365.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  366.       Location     =   "Transaction Block"
  367.       Height       =   270
  368.       Left         =   8100
  369.       Top          =   1230
  370.       Width        =   1890
  371. End
  372. Begin Control LABEL
  373.       Type         =   "Label"
  374.       Style        =   1
  375.       Caption      =   "Disc Days 1:"
  376.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  377.       Location     =   "Transaction Block"
  378.       Height       =   270
  379.       Left         =   8100
  380.       Top          =   2040
  381.       Width        =   1080
  382. End
  383. Begin Control SNPAYDAYS
  384.       Type         =   "Text"
  385.       Style        =   0
  386.       Fieldname    =   "SNPAYDAYS"
  387.       Filename     =   "SLNAME"
  388.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  389.       Location     =   "Transaction Block"
  390.       Height       =   270
  391.       Left         =   9990
  392.       Top          =   1230
  393.       Width        =   405
  394. End
  395. Begin Control SNDISC1
  396.       Type         =   "Text"
  397.       Style        =   0
  398.       Fieldname    =   "SNDISC1"
  399.       Filename     =   "SLNAME"
  400.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  401.       Location     =   "Transaction Block"
  402.       Height       =   270
  403.       Left         =   9855
  404.       Top          =   2040
  405.       Width        =   540
  406. End
  407. Begin Control LABEL
  408.       Type         =   "Label"
  409.       Style        =   1
  410.       Caption      =   "Disc Days 2:"
  411.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  412.       Location     =   "Transaction Block"
  413.       Height       =   270
  414.       Left         =   8100
  415.       Top          =   2310
  416.       Width        =   1080
  417. End
  418. Begin Control SNDAYS2
  419.       Type         =   "Text"
  420.       Style        =   0
  421.       Fieldname    =   "SNDAYS2"
  422.       Filename     =   "SLNAME"
  423.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  424.       Location     =   "Transaction Block"
  425.       Height       =   270
  426.       Left         =   9180
  427.       Top          =   2310
  428.       Width        =   270
  429. End
  430. Begin Control SNDISC2
  431.       Type         =   "Text"
  432.       Style        =   0
  433.       Fieldname    =   "SNDISC2"
  434.       Filename     =   "SLNAME"
  435.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  436.       Location     =   "Transaction Block"
  437.       Height       =   270
  438.       Left         =   9855
  439.       Top          =   2310
  440.       Width        =   540
  441. End
  442. Begin Control SNDAYS1
  443.       Type         =   "Text"
  444.       Style        =   0
  445.       Fieldname    =   "SNDAYS1"
  446.       Filename     =   "SLNAME"
  447.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  448.       Location     =   "Transaction Block"
  449.       Height       =   270
  450.       Left         =   9180
  451.       Top          =   2040
  452.       Width        =   270
  453. End
  454. Begin Control LABEL
  455.       Type         =   "Label"
  456.       Style        =   10
  457.       Caption      =   "SLNAME.SNANAL1"
  458.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  459.       Location     =   "Transaction Block"
  460.       Height       =   270
  461.       Left         =   10125
  462.       Top          =   1500
  463.       Width        =   270
  464. End
  465. Begin Control LABEL
  466.       Type         =   "Label"
  467.       Style        =   10
  468.       Caption      =   "SLNAME.SNANAL2"
  469.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  470.       Location     =   "Transaction Block"
  471.       Height       =   270
  472.       Left         =   10125
  473.       Top          =   1770
  474.       Width        =   270
  475. End
  476. Begin Control LABEL
  477.       Type         =   "Label"
  478.       Style        =   9
  479.       Caption      =   "IF(SLNAME.SNFACTT="Y","Factored Customer",IF(TRIM(SLNAME.SNFACTR)<>"","Non Factored Customer",""))"
  480.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  481.       Location     =   "Transaction Block"
  482.       Height       =   270
  483.       Left         =   4455
  484.       Top          =   2040
  485.       Width        =   2430
  486. End
  487. Begin Control LABEL
  488.       Type         =   "Label"
  489.       Style        =   9
  490.       Caption      =   "if(TRIM(SLNAME.SNFACTR)<>"","Factor Reference:","")"
  491.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  492.       Location     =   "Transaction Block"
  493.       Height       =   270
  494.       Left         =   4455
  495.       Top          =   2310
  496.       Width        =   1485
  497. End
  498. Begin Control LABEL
  499.       Type         =   "Label"
  500.       Style        =   10
  501.       Caption      =   "SLNAME.SNFACTR"
  502.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  503.       Location     =   "Transaction Block"
  504.       Height       =   270
  505.       Left         =   5940
  506.       Top          =   2310
  507.       Width        =   945
  508. End
  509. Begin Control LABEL
  510.       Type         =   "Label"
  511.       Style        =   9
  512.       Caption      =   "IF(SLNAME.SNDUEDTOPT=0,"No. of Days After Invoice Date",IF(SLNAME.SNDUEDTOPT=1,"Month Following",IF(SLNAME.SNDUEDTOPT<10,STR(SLNAME.SNDUEDTOPT,1,0)+" Months Following",STR(SLNAME.SNDUEDTOPT,2,0)+" Months Following")))"
  513.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  514.       Location     =   "Transaction Block"
  515.       Height       =   270
  516.       Left         =   8100
  517.       Top          =   960
  518.       Width        =   2835
  519. End
  520.