home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / SLACCENQ.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  18.6 KB  |  580 lines
  1. VERSION 2.00
  2. Begin Report SLACCENQ.REP
  3.       Caption      =   "SLACCENQ.REP"
  4.       Width        =   11175
  5.       Height       =   16395
  6.       Reportheader =   975
  7.       Header       =   2460
  8.       Transaction  =   1605
  9.       SubTotal     =   3150
  10.       Footer       =   0
  11.       Pagefooter   =   15690
  12.       Replicate    =   360
  13.       Style        =   1
  14.       Query        =   "SLTRAN STACCOUNT=>^@0 & STACCOUNT<=^@1 ORDER BY STACCOUNT"
  15.       Macro        =   "1LU:Select from SLNAME where SLNAME.SNACCOUNT=SLTRAN.STACCOUNT"
  16.       Macro        =   "1OF:@REPVARS.REPTOT(0) = 0"
  17.       Macro        =   "1OF:@REPVARS.REPTOT(1) = 0"
  18.       Macro        =   "1OF:@REPVARS.REPTOT(2) = 0"
  19.       Macro        =   "1OF:@REPVARS.REPTOT(3) = 0"
  20.       Macro        =   "1OF:@REPVARS.REPTOT(4) = 0"
  21.       Macro        =   "2OF:@REPVARS.REPTOT(0) = @REPVARS.REPTOT(0)+SLTRAN.STOUTSTAND"
  22.       Macro        =   "2OF:@REPVARS.REPTOT(1) = PERIOD(DATE(),SLTRAN.STTXNDATE)"
  23.       Macro        =   "2CD:When SLTRAN.STTYPE="R" & SLTRAN.STALLOC=" " then REPTOT(1)=-1"
  24.       Macro        =   "2CD:When REPTOT(1)=-1 then REPTOT(6)=REPTOT(6)+SLTRAN.STOUTSTAND"
  25.       Macro        =   "2CD:When REPTOT(1)=0 then REPTOT(2)=REPTOT(2)+SLTRAN.STOUTSTAND"
  26.       Macro        =   "2CD:When REPTOT(1)=1 then REPTOT(3)=REPTOT(3)+SLTRAN.STOUTSTAND"
  27.       Macro        =   "2CD:When REPTOT(1)=2 then REPTOT(4)=REPTOT(4)+SLTRAN.STOUTSTAND"
  28.       Macro        =   "2CD:When REPTOT(1)=3 then REPTOT(5)=REPTOT(5)+SLTRAN.STOUTSTAND"
  29.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  30.       Macro        =   "3PP:@REPVARS.REPTOT(1) = 0"
  31.       Macro        =   "3PP:@REPVARS.REPTOT(2) = 0"
  32.       Macro        =   "3PP:@REPVARS.REPTOT(3) = 0"
  33.       Macro        =   "3PP:@REPVARS.REPTOT(4) = 0"
  34.       Macro        =   "3PP:@REPVARS.REPTOT(5) = 0"
  35.       Macro        =   "3PP:@REPVARS.REPTOT(6) = 0"
  36.       BreakOn      =   "SLTRAN.STACCOUNT"
  37. End
  38. Begin Control LABEL
  39.       Type         =   "Label"
  40.       Style        =   4
  41.       Caption      =   "Customer  Account Enquiry"
  42.       Font         =   "-315|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  43.       Location     =   "Reportheader Block"
  44.       Height       =   420
  45.       Left         =   135
  46.       Top          =   540
  47.       Width        =   10890
  48. End
  49. Begin Control LABEL
  50.       Type         =   "Label"
  51.       Style        =   9
  52.       Caption      =   "DTOC(DATE())"
  53.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  54.       Location     =   "Reportheader Block"
  55.       Height       =   285
  56.       Left         =   135
  57.       Top          =   720
  58.       Width        =   1800
  59. End
  60. Begin Control LABEL
  61.       Type         =   "Label"
  62.       Style        =   10
  63.       Caption      =   ""Page "+PAGENUM()"
  64.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  65.       Location     =   "Reportheader Block"
  66.       Height       =   285
  67.       Left         =   9210
  68.       Top          =   705
  69.       Width        =   1800
  70. End
  71. Begin Control LABEL
  72.       Type         =   "Label"
  73.       Style        =   12
  74.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  75.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  76.       Location     =   "Reportheader Block"
  77.       Height       =   285
  78.       Left         =   135
  79.       Top          =   135
  80.       Width        =   10890
  81. End
  82. Begin Control LABEL
  83.       Type         =   "Label"
  84.       Style        =   1
  85.       Caption      =   "Date"
  86.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  87.       Location     =   "Header Block"
  88.       Height       =   285
  89.       Left         =   135
  90.       Top          =   2130
  91.       Width        =   1140
  92. End
  93. Begin Control LABEL
  94.       Type         =   "Label"
  95.       Style        =   1
  96.       Caption      =   "Reference"
  97.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  98.       Location     =   "Header Block"
  99.       Height       =   285
  100.       Left         =   3060
  101.       Top          =   2130
  102.       Width        =   1275
  103. End
  104. Begin Control LABEL
  105.       Type         =   "Label"
  106.       Style        =   2
  107.       Caption      =   "Debit"
  108.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  109.       Location     =   "Header Block"
  110.       Height       =   285
  111.       Left         =   5835
  112.       Top          =   2130
  113.       Width        =   1410
  114. End
  115. Begin Control LABEL
  116.       Type         =   "Label"
  117.       Style        =   2
  118.       Caption      =   "Balance"
  119.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  120.       Location     =   "Header Block"
  121.       Height       =   285
  122.       Left         =   8895
  123.       Top          =   2130
  124.       Width        =   1275
  125. End
  126. Begin Control SNNAME
  127.       Type         =   "Text"
  128.       Style        =   0
  129.       Fieldname    =   "SNNAME"
  130.       Filename     =   "SLNAME"
  131.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  132.       Location     =   "Header Block"
  133.       Height       =   270
  134.       Left         =   270
  135.       Top          =   240
  136.       Width        =   2700
  137. End
  138. Begin Control SNADD1
  139.       Type         =   "Text"
  140.       Style        =   0
  141.       Fieldname    =   "SNADD1"
  142.       Filename     =   "SLNAME"
  143.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  144.       Location     =   "Header Block"
  145.       Height       =   270
  146.       Left         =   270
  147.       Top          =   510
  148.       Width        =   2700
  149. End
  150. Begin Control SNADD2
  151.       Type         =   "Text"
  152.       Style        =   0
  153.       Fieldname    =   "SNADD2"
  154.       Filename     =   "SLNAME"
  155.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  156.       Location     =   "Header Block"
  157.       Height       =   270
  158.       Left         =   270
  159.       Top          =   780
  160.       Width        =   2700
  161. End
  162. Begin Control SNADD3
  163.       Type         =   "Text"
  164.       Style        =   0
  165.       Fieldname    =   "SNADD3"
  166.       Filename     =   "SLNAME"
  167.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  168.       Location     =   "Header Block"
  169.       Height       =   270
  170.       Left         =   270
  171.       Top          =   1050
  172.       Width        =   2700
  173. End
  174. Begin Control SNADD4
  175.       Type         =   "Text"
  176.       Style        =   0
  177.       Fieldname    =   "SNADD4"
  178.       Filename     =   "SLNAME"
  179.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  180.       Location     =   "Header Block"
  181.       Height       =   270
  182.       Left         =   270
  183.       Top          =   1320
  184.       Width        =   2700
  185. End
  186. Begin Control SNPOSTCODE
  187.       Type         =   "Text"
  188.       Style        =   0
  189.       Fieldname    =   "SNPOSTCODE"
  190.       Filename     =   "SLNAME"
  191.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  192.       Location     =   "Header Block"
  193.       Height       =   270
  194.       Left         =   270
  195.       Top          =   1590
  196.       Width        =   2700
  197. End
  198. Begin Control SNACCOUNT
  199.       Type         =   "Text"
  200.       Style        =   0
  201.       Fieldname    =   "SNACCOUNT"
  202.       Filename     =   "SLNAME"
  203.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  204.       Location     =   "Header Block"
  205.       Height       =   270
  206.       Left         =   4995
  207.       Top          =   240
  208.       Width        =   1350
  209. End
  210. Begin Control LABEL
  211.       Type         =   "Label"
  212.       Style        =   1
  213.       Caption      =   "Customer ID:"
  214.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  215.       Location     =   "Header Block"
  216.       Height       =   270
  217.       Left         =   3780
  218.       Top          =   240
  219.       Width        =   1080
  220. End
  221. Begin Control LABEL
  222.       Type         =   "Label"
  223.       Style        =   1
  224.       Caption      =   "T/Over"
  225.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  226.       Location     =   "Header Block"
  227.       Height       =   270
  228.       Left         =   7965
  229.       Top          =   780
  230.       Width        =   1080
  231. End
  232. Begin Control SNTURNOVER
  233.       Type         =   "Text"
  234.       Style        =   0
  235.       Fieldname    =   "SNTURNOVER"
  236.       Filename     =   "SLNAME"
  237.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  238.       Location     =   "Header Block"
  239.       Height       =   270
  240.       Left         =   9180
  241.       Top          =   780
  242.       Width        =   1350
  243. End
  244. Begin Control LABEL
  245.       Type         =   "Label"
  246.       Style        =   1
  247.       Caption      =   "Credit Limit"
  248.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  249.       Location     =   "Header Block"
  250.       Height       =   270
  251.       Left         =   7965
  252.       Top          =   1050
  253.       Width        =   1215
  254. End
  255. Begin Control SNCREDIT
  256.       Type         =   "Text"
  257.       Style        =   0
  258.       Fieldname    =   "SNCREDIT"
  259.       Filename     =   "SLNAME"
  260.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  261.       Location     =   "Header Block"
  262.       Height       =   270
  263.       Left         =   9180
  264.       Top          =   1050
  265.       Width        =   1350
  266. End
  267. Begin Control LABEL
  268.       Type         =   "Label"
  269.       Style        =   2
  270.       Caption      =   "Credit"
  271.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  272.       Location     =   "Header Block"
  273.       Height       =   285
  274.       Left         =   7320
  275.       Top          =   2130
  276.       Width        =   1410
  277. End
  278. Begin Control SNTEL
  279.       Type         =   "Text"
  280.       Style        =   0
  281.       Fieldname    =   "SNTEL"
  282.       Filename     =   "SLNAME"
  283.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  284.       Location     =   "Header Block"
  285.       Height       =   270
  286.       Left         =   4995
  287.       Top          =   780
  288.       Width        =   1890
  289. End
  290. Begin Control SNFAX
  291.       Type         =   "Text"
  292.       Style        =   0
  293.       Fieldname    =   "SNFAX"
  294.       Filename     =   "SLNAME"
  295.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  296.       Location     =   "Header Block"
  297.       Height       =   270
  298.       Left         =   4995
  299.       Top          =   1050
  300.       Width        =   1890
  301. End
  302. Begin Control LABEL
  303.       Type         =   "Label"
  304.       Style        =   1
  305.       Caption      =   "Tel:"
  306.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  307.       Location     =   "Header Block"
  308.       Height       =   270
  309.       Left         =   3780
  310.       Top          =   780
  311.       Width        =   675
  312. End
  313. Begin Control LABEL
  314.       Type         =   "Label"
  315.       Style        =   1
  316.       Caption      =   "Fax:"
  317.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  318.       Location     =   "Header Block"
  319.       Height       =   270
  320.       Left         =   3780
  321.       Top          =   1050
  322.       Width        =   675
  323. End
  324. Begin Control SNCONTACT
  325.       Type         =   "Text"
  326.       Style        =   0
  327.       Fieldname    =   "SNCONTACT"
  328.       Filename     =   "SLNAME"
  329.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  330.       Location     =   "Header Block"
  331.       Height       =   270
  332.       Left         =   4995
  333.       Top          =   1590
  334.       Width        =   2565
  335. End
  336. Begin Control LABEL
  337.       Type         =   "Label"
  338.       Style        =   1
  339.       Caption      =   "Contact:"
  340.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  341.       Location     =   "Header Block"
  342.       Height       =   270
  343.       Left         =   3780
  344.       Top          =   1590
  345.       Width        =   810
  346. End
  347. Begin Control LABEL
  348.       Type         =   "Label"
  349.       Style        =   1
  350.       Caption      =   "Status"
  351.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  352.       Location     =   "Header Block"
  353.       Height       =   285
  354.       Left         =   4410
  355.       Top          =   2130
  356.       Width        =   1140
  357. End
  358. Begin Control LABEL
  359.       Type         =   "Label"
  360.       Style        =   1
  361.       Caption      =   "Type"
  362.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  363.       Location     =   "Header Block"
  364.       Height       =   285
  365.       Left         =   1710
  366.       Top          =   2130
  367.       Width        =   870
  368. End
  369. Begin Control STTXNDATE
  370.       Type         =   "Text"
  371.       Style        =   0
  372.       Fieldname    =   "STTXNDATE"
  373.       Filename     =   "SLTRAN"
  374.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  375.       Location     =   "Transaction Block"
  376.       Height       =   270
  377.       Left         =   135
  378.       Top          =   60
  379.       Width        =   1410
  380. End
  381. Begin Control STREF
  382.       Type         =   "Text"
  383.       Style        =   0
  384.       Fieldname    =   "STREF"
  385.       Filename     =   "SLTRAN"
  386.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  387.       Location     =   "Transaction Block"
  388.       Height       =   270
  389.       Left         =   3060
  390.       Top          =   60
  391.       Width        =   1275
  392. End
  393. Begin Control LABEL
  394.       Type         =   "Label"
  395.       Style        =   10
  396.       Caption      =   "CORD(SLTRAN.STVALUE,10,2,1)"
  397.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  398.       Location     =   "Transaction Block"
  399.       Height       =   285
  400.       Left         =   5835
  401.       Top          =   75
  402.       Width        =   1410
  403. End
  404. Begin Control LABEL
  405.       Type         =   "Label"
  406.       Style        =   10
  407.       Caption      =   "CORD(SLTRAN.STVALUE,10,2,-1)"
  408.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  409.       Location     =   "Transaction Block"
  410.       Height       =   285
  411.       Left         =   7320
  412.       Top          =   75
  413.       Width        =   1410
  414. End
  415. Begin Control LABEL
  416.       Type         =   "Label"
  417.       Style        =   10
  418.       Caption      =   "IF(SLTRAN.STVALUE>0 & SLTRAN.STVALUE<>SLTRAN.STOUTSTAND,CORD(SLTRAN.STOUTSTAND,10,2,1),"")"
  419.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  420.       Location     =   "Transaction Block"
  421.       Height       =   285
  422.       Left         =   8805
  423.       Top          =   75
  424.       Width        =   1410
  425. End
  426. Begin Control LABEL
  427.       Type         =   "Label"
  428.       Style        =   9
  429.       Caption      =   "if(SLTRAN.STDISP="D","Disputed",MID("         Paid     Allocated",INSTR("PA",SLTRAN.STALLOC)*9+1,9))"
  430.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  431.       Location     =   "Transaction Block"
  432.       Height       =   270
  433.       Left         =   4455
  434.       Top          =   75
  435.       Width        =   1350
  436. End
  437. Begin Control LABEL
  438.       Type         =   "Label"
  439.       Style        =   9
  440.       Caption      =   "MID("   InvCrnRecAdjDscRfd",INSTR("ICRADF",SLTRAN.STTYPE)*3+1,3)"
  441.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  442.       Location     =   "Transaction Block"
  443.       Height       =   270
  444.       Left         =   1755
  445.       Top          =   75
  446.       Width        =   1080
  447. End
  448. Begin Control LABEL
  449.       Type         =   "Label"
  450.       Style        =   10
  451.       Caption      =   "STR(@REPVARS.REPTOT(0),10,2)"
  452.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  453.       Location     =   "Subtotal Block"
  454.       Height       =   285
  455.       Left         =   8805
  456.       Top          =   765
  457.       Width        =   1410
  458. End
  459. Begin Control LABEL
  460.       Type         =   "Label"
  461.       Style        =   2
  462.       Caption      =   "Balance"
  463.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  464.       Location     =   "Subtotal Block"
  465.       Height       =   270
  466.       Left         =   8640
  467.       Top          =   495
  468.       Width        =   1485
  469. End
  470. Begin Control LABEL
  471.       Type         =   "Label"
  472.       Style        =   10
  473.       Caption      =   "STR(@REPVARS.REPTOT(5),10,2)"
  474.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  475.       Location     =   "Subtotal Block"
  476.       Height       =   285
  477.       Left         =   840
  478.       Top          =   765
  479.       Width        =   1410
  480. End
  481. Begin Control LABEL
  482.       Type         =   "Label"
  483.       Style        =   10
  484.       Caption      =   "STR(@REPVARS.REPTOT(2),10,2)"
  485.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  486.       Location     =   "Subtotal Block"
  487.       Height       =   285
  488.       Left         =   5565
  489.       Top          =   765
  490.       Width        =   1410
  491. End
  492. Begin Control LABEL
  493.       Type         =   "Label"
  494.       Style        =   10
  495.       Caption      =   "STR(@REPVARS.REPTOT(3),10,2)"
  496.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  497.       Location     =   "Subtotal Block"
  498.       Height       =   285
  499.       Left         =   3810
  500.       Top          =   765
  501.       Width        =   1410
  502. End
  503. Begin Control LABEL
  504.       Type         =   "Label"
  505.       Style        =   10
  506.       Caption      =   "STR(@REPVARS.REPTOT(4),10,2)"
  507.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  508.       Location     =   "Subtotal Block"
  509.       Height       =   285
  510.       Left         =   2325
  511.       Top          =   765
  512.       Width        =   1410
  513. End
  514. Begin Control LABEL
  515.       Type         =   "Label"
  516.       Style        =   2
  517.       Caption      =   "Current"
  518.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  519.       Location     =   "Subtotal Block"
  520.       Height       =   270
  521.       Left         =   5535
  522.       Top          =   495
  523.       Width        =   1485
  524. End
  525. Begin Control LABEL
  526.       Type         =   "Label"
  527.       Style        =   2
  528.       Caption      =   "1 Month"
  529.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  530.       Location     =   "Subtotal Block"
  531.       Height       =   270
  532.       Left         =   3780
  533.       Top          =   495
  534.       Width        =   1485
  535. End
  536. Begin Control LABEL
  537.       Type         =   "Label"
  538.       Style        =   2
  539.       Caption      =   "2 Months"
  540.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  541.       Location     =   "Subtotal Block"
  542.       Height       =   270
  543.       Left         =   2295
  544.       Top          =   495
  545.       Width        =   1485
  546. End
  547. Begin Control LABEL
  548.       Type         =   "Label"
  549.       Style        =   2
  550.       Caption      =   "3 Months +"
  551.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  552.       Location     =   "Subtotal Block"
  553.       Height       =   270
  554.       Left         =   810
  555.       Top          =   495
  556.       Width        =   1485
  557. End
  558. Begin Control LABEL
  559.       Type         =   "Label"
  560.       Style        =   2
  561.       Caption      =   "Unallocated"
  562.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  563.       Location     =   "Subtotal Block"
  564.       Height       =   270
  565.       Left         =   7425
  566.       Top          =   495
  567.       Width        =   1215
  568. End
  569. Begin Control LABEL
  570.       Type         =   "Label"
  571.       Style        =   10
  572.       Caption      =   "STR(@REPVARS.REPTOT(6),10,2)"
  573.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  574.       Location     =   "Subtotal Block"
  575.       Height       =   285
  576.       Left         =   7185
  577.       Top          =   765
  578.       Width        =   1410
  579. End
  580.