home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / STPRDENQ.REP < prev    next >
Text File  |  1997-10-28  |  24KB  |  703 lines
  1. VERSION 2.00
  2. Begin Report STPRDENQ.REP
  3.       Caption      =   "STPRDENQ.REP"
  4.       Width        =   11460
  5.       Height       =   16185
  6.       Reportheader =   1200
  7.       Header       =   3795
  8.       Transaction  =   6975
  9.       SubTotal     =   270
  10.       Footer       =   0
  11.       Pagefooter   =   15960
  12.       Replicate    =   405
  13.       Style        =   1
  14.       Query        =   "STTRND CDPRODID>=^@0 & CDPRODID<=^@1 ORDER BY CDPRODID+CDTYPE"
  15.       Macro        =   "1LU:Select from STNAME where CNPRODID=STTRND.CDPRODID"
  16.       Macro        =   "2LU:Select from STTRNH where CHTRANNO=STTRND.CDTRANNO"
  17.       BreakOn      =   "STTRND.CDPRODID"
  18. End
  19. Begin Control LABEL
  20.       Type         =   "Label"
  21.       Style        =   12
  22.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  23.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  24.       Location     =   "Reportheader Block"
  25.       Height       =   270
  26.       Left         =   -15
  27.       Top          =   405
  28.       Width        =   11070
  29. End
  30. Begin Control LABEL
  31.       Type         =   "Label"
  32.       Style        =   4
  33.       Caption      =   "Product Enquiry"
  34.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  35.       Location     =   "Reportheader Block"
  36.       Height       =   420
  37.       Left         =   135
  38.       Top          =   675
  39.       Width        =   11025
  40. End
  41. Begin Control LABEL
  42.       Type         =   "Label"
  43.       Style        =   9
  44.       Caption      =   "DTOC(DATE())"
  45.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  46.       Location     =   "Reportheader Block"
  47.       Height       =   285
  48.       Left         =   135
  49.       Top          =   705
  50.       Width        =   1800
  51. End
  52. Begin Control LABEL
  53.       Type         =   "Label"
  54.       Style        =   10
  55.       Caption      =   ""Page: "+PAGENUM()"
  56.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  57.       Location     =   "Reportheader Block"
  58.       Height       =   285
  59.       Left         =   9585
  60.       Top          =   720
  61.       Width        =   1395
  62. End
  63. Begin Control LABEL
  64.       Type         =   "Label"
  65.       Style        =   1
  66.       Caption      =   "Product ID"
  67.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  68.       Location     =   "Header Block"
  69.       Height       =   285
  70.       Left         =   165
  71.       Top          =   270
  72.       Width        =   945
  73. End
  74. Begin Control LABEL
  75.       Type         =   "Label"
  76.       Style        =   1
  77.       Caption      =   "Description"
  78.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  79.       Location     =   "Header Block"
  80.       Height       =   285
  81.       Left         =   2400
  82.       Top          =   270
  83.       Width        =   1110
  84. End
  85. Begin Control LABEL
  86.       Type         =   "Label"
  87.       Style        =   1
  88.       Caption      =   "Reference"
  89.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  90.       Location     =   "Header Block"
  91.       Height       =   285
  92.       Left         =   2415
  93.       Top          =   3360
  94.       Width        =   990
  95. End
  96. Begin Control LABEL
  97.       Type         =   "Label"
  98.       Style        =   2
  99.       Caption      =   "Qty"
  100.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  101.       Location     =   "Header Block"
  102.       Height       =   285
  103.       Left         =   3795
  104.       Top          =   3375
  105.       Width        =   510
  106. End
  107. Begin Control LABEL
  108.       Type         =   "Label"
  109.       Style        =   1
  110.       Caption      =   "Type"
  111.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  112.       Location     =   "Header Block"
  113.       Height       =   285
  114.       Left         =   120
  115.       Top          =   3375
  116.       Width        =   600
  117. End
  118. Begin Control LABEL
  119.       Type         =   "Label"
  120.       Style        =   1
  121.       Caption      =   "Date"
  122.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  123.       Location     =   "Header Block"
  124.       Height       =   285
  125.       Left         =   1200
  126.       Top          =   3375
  127.       Width        =   585
  128. End
  129. Begin Control LABEL
  130.       Type         =   "Label"
  131.       Style        =   2
  132.       Caption      =   "Qty Bal"
  133.       Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  134.       Location     =   "Header Block"
  135.       Height       =   285
  136.       Left         =   4740
  137.       Top          =   3375
  138.       Width        =   645
  139. End
  140. Begin Control CNPRODID
  141.       Type         =   "Text"
  142.       Style        =   0
  143.       Fieldname    =   "CNPRODID"
  144.       Filename     =   "STNAME"
  145.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  146.       Location     =   "Header Block"
  147.       Height       =   270
  148.       Left         =   135
  149.       Top          =   555
  150.       Width        =   1770
  151. End
  152. Begin Control CNDESC
  153.       Type         =   "Text"
  154.       Style        =   0
  155.       Fieldname    =   "CNDESC"
  156.       Filename     =   "STNAME"
  157.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  158.       Location     =   "Header Block"
  159.       Height       =   270
  160.       Left         =   2430
  161.       Top          =   555
  162.       Width        =   3390
  163. End
  164. Begin Control LABEL
  165.       Type         =   "Label"
  166.       Style        =   9
  167.       Caption      =   "IF(STNAME.CNPRODTYPE="0","Description Only",IF(STNAME.CNPRODTYPE="1","Product Only","Full Stock Product"))"
  168.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  169.       Location     =   "Header Block"
  170.       Height       =   270
  171.       Left         =   2415
  172.       Top          =   825
  173.       Width        =   1485
  174. End
  175. Begin Control LABEL
  176.       Type         =   "Label"
  177.       Style        =   9
  178.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Group ID:","")"
  179.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  180.       Location     =   "Header Block"
  181.       Height       =   270
  182.       Left         =   120
  183.       Top          =   1620
  184.       Width        =   810
  185. End
  186. Begin Control LABEL
  187.       Type         =   "Label"
  188.       Style        =   9
  189.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Unit Desc.:","")"
  190.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  191.       Location     =   "Header Block"
  192.       Height       =   270
  193.       Left         =   120
  194.       Top          =   1890
  195.       Width        =   810
  196. End
  197. Begin Control LABEL
  198.       Type         =   "Label"
  199.       Style        =   9
  200.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","VAT Code:","")"
  201.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  202.       Location     =   "Header Block"
  203.       Height       =   270
  204.       Left         =   120
  205.       Top          =   2160
  206.       Width        =   810
  207. End
  208. Begin Control LABEL
  209.       Type         =   "Label"
  210.       Style        =   9
  211.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Disc. 1:","")"
  212.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  213.       Location     =   "Header Block"
  214.       Height       =   270
  215.       Left         =   2415
  216.       Top          =   1620
  217.       Width        =   540
  218. End
  219. Begin Control LABEL
  220.       Type         =   "Label"
  221.       Style        =   9
  222.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Disc. 2:","")"
  223.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  224.       Location     =   "Header Block"
  225.       Height       =   270
  226.       Left         =   2415
  227.       Top          =   1890
  228.       Width        =   540
  229. End
  230. Begin Control LABEL
  231.       Type         =   "Label"
  232.       Style        =   9
  233.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Disc. 3:","")"
  234.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  235.       Location     =   "Header Block"
  236.       Height       =   270
  237.       Left         =   2415
  238.       Top          =   2160
  239.       Width        =   540
  240. End
  241. Begin Control LABEL
  242.       Type         =   "Label"
  243.       Style        =   10
  244.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNANALHEAD,"")"
  245.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  246.       Location     =   "Header Block"
  247.       Height       =   270
  248.       Left         =   1470
  249.       Top          =   1620
  250.       Width        =   810
  251. End
  252. Begin Control LABEL
  253.       Type         =   "Label"
  254.       Style        =   10
  255.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNUNITDESC,"")"
  256.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  257.       Location     =   "Header Block"
  258.       Height       =   270
  259.       Left         =   1470
  260.       Top          =   1890
  261.       Width        =   810
  262. End
  263. Begin Control LABEL
  264.       Type         =   "Label"
  265.       Style        =   10
  266.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNVATCODE,"")"
  267.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  268.       Location     =   "Header Block"
  269.       Height       =   270
  270.       Left         =   1470
  271.       Top          =   2160
  272.       Width        =   810
  273. End
  274. Begin Control LABEL
  275.       Type         =   "Label"
  276.       Style        =   10
  277.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE1,"")"
  278.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  279.       Location     =   "Header Block"
  280.       Height       =   270
  281.       Left         =   4035
  282.       Top          =   1620
  283.       Width        =   270
  284. End
  285. Begin Control LABEL
  286.       Type         =   "Label"
  287.       Style        =   10
  288.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE2,"")"
  289.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  290.       Location     =   "Header Block"
  291.       Height       =   270
  292.       Left         =   4035
  293.       Top          =   1890
  294.       Width        =   270
  295. End
  296. Begin Control LABEL
  297.       Type         =   "Label"
  298.       Style        =   10
  299.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE3,"")"
  300.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  301.       Location     =   "Header Block"
  302.       Height       =   270
  303.       Left         =   4035
  304.       Top          =   2160
  305.       Width        =   270
  306. End
  307. Begin Control LABEL
  308.       Type         =   "Label"
  309.       Style        =   10
  310.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC1<>0,STR(STNAME.CNDISC1,5,2)+"%","")"
  311.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  312.       Location     =   "Header Block"
  313.       Height       =   270
  314.       Left         =   4575
  315.       Top          =   1620
  316.       Width        =   810
  317. End
  318. Begin Control LABEL
  319.       Type         =   "Label"
  320.       Style        =   10
  321.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC2<>0,STR(STNAME.CNDISC2,5,2)+"%","")"
  322.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  323.       Location     =   "Header Block"
  324.       Height       =   270
  325.       Left         =   4575
  326.       Top          =   1890
  327.       Width        =   810
  328. End
  329. Begin Control LABEL
  330.       Type         =   "Label"
  331.       Style        =   10
  332.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC3<>0,STR(STNAME.CNDISC3,5,2)+"%","")"
  333.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  334.       Location     =   "Header Block"
  335.       Height       =   270
  336.       Left         =   4575
  337.       Top          =   2160
  338.       Width        =   810
  339. End
  340. Begin Control LABEL
  341.       Type         =   "Label"
  342.       Style        =   9
  343.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Min. Stock:","")"
  344.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  345.       Location     =   "Header Block"
  346.       Height       =   270
  347.       Left         =   5655
  348.       Top          =   1620
  349.       Width        =   945
  350. End
  351. Begin Control LABEL
  352.       Type         =   "Label"
  353.       Style        =   9
  354.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Selling Price:","")"
  355.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  356.       Location     =   "Header Block"
  357.       Height       =   270
  358.       Left         =   2415
  359.       Top          =   2430
  360.       Width        =   1080
  361. End
  362. Begin Control LABEL
  363.       Type         =   "Label"
  364.       Style        =   10
  365.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STR(STNAME.CNSELPRICE,10,2),"")"
  366.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  367.       Location     =   "Header Block"
  368.       Height       =   270
  369.       Left         =   4575
  370.       Top          =   2430
  371.       Width        =   810
  372. End
  373. Begin Control LABEL
  374.       Type         =   "Label"
  375.       Style        =   10
  376.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNMINSTOCK,10,2),"")"
  377.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  378.       Location     =   "Header Block"
  379.       Height       =   270
  380.       Left         =   7005
  381.       Top          =   1620
  382.       Width        =   810
  383. End
  384. Begin Control LABEL
  385.       Type         =   "Label"
  386.       Style        =   9
  387.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Re-Ord Level:","")"
  388.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  389.       Location     =   "Header Block"
  390.       Height       =   270
  391.       Left         =   5655
  392.       Top          =   1350
  393.       Width        =   945
  394. End
  395. Begin Control LABEL
  396.       Type         =   "Label"
  397.       Style        =   10
  398.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNREOLEVEL,10,2),"")"
  399.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  400.       Location     =   "Header Block"
  401.       Height       =   270
  402.       Left         =   7005
  403.       Top          =   1350
  404.       Width        =   810
  405. End
  406. Begin Control LABEL
  407.       Type         =   "Label"
  408.       Style        =   9
  409.       Caption      =   "IF(STNAME.CNPRODTYPE="2","In Stock:","")"
  410.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  411.       Location     =   "Header Block"
  412.       Height       =   270
  413.       Left         =   5655
  414.       Top          =   1890
  415.       Width        =   945
  416. End
  417. Begin Control LABEL
  418.       Type         =   "Label"
  419.       Style        =   10
  420.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYINST,10,2),"")"
  421.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  422.       Location     =   "Header Block"
  423.       Height       =   270
  424.       Left         =   7005
  425.       Top          =   1890
  426.       Width        =   810
  427. End
  428. Begin Control LABEL
  429.       Type         =   "Label"
  430.       Style        =   9
  431.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Cost Price:","")"
  432.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  433.       Location     =   "Header Block"
  434.       Height       =   270
  435.       Left         =   5655
  436.       Top          =   2430
  437.       Width        =   945
  438. End
  439. Begin Control LABEL
  440.       Type         =   "Label"
  441.       Style        =   10
  442.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNCOSPRICE,10,2),"")"
  443.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  444.       Location     =   "Header Block"
  445.       Height       =   270
  446.       Left         =   7005
  447.       Top          =   2430
  448.       Width        =   810
  449. End
  450. Begin Control LABEL
  451.       Type         =   "Label"
  452.       Style        =   9
  453.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Supplier ID:","")"
  454.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  455.       Location     =   "Header Block"
  456.       Height       =   270
  457.       Left         =   5655
  458.       Top          =   1080
  459.       Width        =   945
  460. End
  461. Begin Control LABEL
  462.       Type         =   "Label"
  463.       Style        =   10
  464.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STNAME.CNSUPPID,"")"
  465.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  466.       Location     =   "Header Block"
  467.       Height       =   270
  468.       Left         =   7005
  469.       Top          =   1080
  470.       Width        =   810
  471. End
  472. Begin Control LABEL
  473.       Type         =   "Label"
  474.       Style        =   9
  475.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","Last Issued:","")"
  476.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  477.       Location     =   "Header Block"
  478.       Height       =   270
  479.       Left         =   5640
  480.       Top          =   810
  481.       Width        =   945
  482. End
  483. Begin Control LABEL
  484.       Type         =   "Label"
  485.       Style        =   10
  486.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNLASTISS<>NULLDATE,DTOC(STNAME.CNLASTISS),"")"
  487.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  488.       Location     =   "Header Block"
  489.       Height       =   270
  490.       Left         =   7005
  491.       Top          =   810
  492.       Width        =   810
  493. End
  494. Begin Control LABEL
  495.       Type         =   "Label"
  496.       Style        =   9
  497.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Location:","")"
  498.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  499.       Location     =   "Header Block"
  500.       Height       =   270
  501.       Left         =   8085
  502.       Top          =   810
  503.       Width        =   945
  504. End
  505. Begin Control LABEL
  506.       Type         =   "Label"
  507.       Style        =   10
  508.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STNAME.CNLOC),"")"
  509.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  510.       Location     =   "Header Block"
  511.       Height       =   270
  512.       Left         =   9570
  513.       Top          =   810
  514.       Width        =   810
  515. End
  516. Begin Control LABEL
  517.       Type         =   "Label"
  518.       Style        =   9
  519.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Part No.:","")"
  520.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  521.       Location     =   "Header Block"
  522.       Height       =   270
  523.       Left         =   8085
  524.       Top          =   1080
  525.       Width        =   945
  526. End
  527. Begin Control LABEL
  528.       Type         =   "Label"
  529.       Style        =   10
  530.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STNAME.CNSPARTNO),"")"
  531.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  532.       Location     =   "Header Block"
  533.       Height       =   270
  534.       Left         =   9165
  535.       Top          =   1080
  536.       Width        =   1215
  537. End
  538. Begin Control LABEL
  539.       Type         =   "Label"
  540.       Style        =   9
  541.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Re-Ord Qty:","")"
  542.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  543.       Location     =   "Header Block"
  544.       Height       =   270
  545.       Left         =   8085
  546.       Top          =   1350
  547.       Width        =   945
  548. End
  549. Begin Control LABEL
  550.       Type         =   "Label"
  551.       Style        =   10
  552.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNREOQTY,10,2),"")"
  553.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  554.       Location     =   "Header Block"
  555.       Height       =   270
  556.       Left         =   9570
  557.       Top          =   1350
  558.       Width        =   810
  559. End
  560. Begin Control LABEL
  561.       Type         =   "Label"
  562.       Style        =   9
  563.       Caption      =   "IF(STNAME.CNPRODTYPE="2","Average Cost:","")"
  564.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  565.       Location     =   "Header Block"
  566.       Height       =   270
  567.       Left         =   8085
  568.       Top          =   2430
  569.       Width        =   945
  570. End
  571. Begin Control LABEL
  572.       Type         =   "Label"
  573.       Style        =   10
  574.       Caption      =   "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNAVGCOS,10,2),"")"
  575.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  576.       Location     =   "Header Block"
  577.       Height       =   270
  578.       Left         =   9570
  579.       Top          =   2430
  580.       Width        =   810
  581. End
  582. Begin Control LABEL
  583.       Type         =   "Label"
  584.       Style        =   9
  585.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0","VAT Inclusive:","")"
  586.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  587.       Location     =   "Header Block"
  588.       Height       =   270
  589.       Left         =   135
  590.       Top          =   2445
  591.       Width        =   1215
  592. End
  593. Begin Control LABEL
  594.       Type         =   "Label"
  595.       Style        =   10
  596.       Caption      =   "IF(STNAME.CNPRODTYPE<>"0",STR(STNAME.CNVATPRICE,10,2),"")"
  597.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  598.       Location     =   "Header Block"
  599.       Height       =   270
  600.       Left         =   1485
  601.       Top          =   2445
  602.       Width        =   810
  603. End
  604. Begin Control LABEL
  605.       Type         =   "Label"
  606.       Style        =   9
  607.       Caption      =   "IF(STTRND.CDTYPE="3","Cost =",IF((STTRND.CDTYPE="4"|STTRND.CDTYPE="5")&STTRND.CDPRODTYPE="2","Profit =",IF(STTRND.CDTYPE="0"|STTRND.CDTYPE="9","Completed ",IF(STTRND.CDTYPE="1"|STTRND.CDTYPE="B"|STTRND.CDTYPE="E"|STTRND.CDTYPE="F","Due "+IF(STTRNH.CHDUEDEL<>NULLDATE,DTOC(STTRNH.CHDUEDEL),""),""))))"
  608.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  609.       Location     =   "Transaction Block"
  610.       Height       =   270
  611.       Left         =   5655
  612.       Top          =   120
  613.       Width        =   1620
  614. End
  615. Begin Control LABEL
  616.       Type         =   "Label"
  617.       Style        =   9
  618.       Caption      =   "IF(STTRND.CDTYPE="3",LTRIM(STR(STTRND.CDPRICE,10,2)),IF((STTRND.CDTYPE="4"|STTRND.CDTYPE="5")&STTRND.CDPRODTYPE="2",LTRIM(STR(STTRND.CDPROFIT,10,2)),IF(STTRND.CDTYPE="0"|STTRND.CDTYPE="1","From  "+STTRND.CDACCID,IF(STTRND.CDTYPE="9"|STTRND.CDTYPE="B"|STTRND.CDTYPE="E"|STTRND.CDTYPE="F","To  "+STTRND.CDACCID,""))))"
  619.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  620.       Location     =   "Transaction Block"
  621.       Height       =   270
  622.       Left         =   8160
  623.       Top          =   135
  624.       Width        =   1290
  625. End
  626. Begin Control CDDOCNO
  627.       Type         =   "Text"
  628.       Style        =   0
  629.       Fieldname    =   "CDDOCNO"
  630.       Filename     =   "STTRND"
  631.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  632.       Location     =   "Transaction Block"
  633.       Height       =   270
  634.       Left         =   2415
  635.       Top          =   120
  636.       Width        =   1140
  637. End
  638. Begin Control LABEL
  639.       Type         =   "Label"
  640.       Style        =   9
  641.       Caption      =   "MID("       ReceiptIssue  Adjust Return CmPO   POrd   CmSO   SOrd   Prof   Quot   ",(INSTR("3485019BEF",STTRND.CDTYPE)*7)+1,7)"
  642.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  643.       Location     =   "Transaction Block"
  644.       Height       =   270
  645.       Left         =   120
  646.       Top          =   120
  647.       Width        =   675
  648. End
  649. Begin Control CDTXNDATE
  650.       Type         =   "Text"
  651.       Style        =   0
  652.       Fieldname    =   "CDTXNDATE"
  653.       Filename     =   "STTRND"
  654.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  655.       Location     =   "Transaction Block"
  656.       Height       =   270
  657.       Left         =   1215
  658.       Top          =   120
  659.       Width        =   870
  660. End
  661. Begin Control LABEL
  662.       Type         =   "Label"
  663.       Style        =   10
  664.       Caption      =   "IF((STTRND.CDTYPE="1"|STTRND.CDTYPE="B")&STTRND.CDQTYBAL<>0,STR(STTRND.CDQTYBAL,10,2),"")"
  665.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  666.       Location     =   "Transaction Block"
  667.       Height       =   270
  668.       Left         =   4545
  669.       Top          =   135
  670.       Width        =   870
  671. End
  672. Begin Control LABEL
  673.       Type         =   "Label"
  674.       Style        =   10
  675.       Caption      =   "IF(STTRND.CDQUANTITY<>0,STR(STTRND.CDQUANTITY,10,2),"")"
  676.       Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  677.       Location     =   "Transaction Block"
  678.       Height       =   270
  679.       Left         =   3495
  680.       Top          =   135
  681.       Width        =   810
  682. End
  683. Begin Control LABEL
  684.       Type         =   "Label"
  685.       Style        =   10
  686.       Caption      =   "" ""
  687.       Location     =   "Transaction Block"
  688.       Height       =   270
  689.       Left         =   9720
  690.       Top          =   135
  691.       Width        =   675
  692. End
  693. Begin Control LABEL
  694.       Type         =   "Label"
  695.       Style        =   10
  696.       Caption      =   "" ""
  697.       Location     =   "Transaction Block"
  698.       Height       =   270
  699.       Left         =   7425
  700.       Top          =   135
  701.       Width        =   405
  702. End
  703.