home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / FACTAUD.REP < prev    next >
Text File  |  1995-08-30  |  15KB  |  450 lines
  1. VERSION 2.00
  2. Begin Report FACTAUD.REP
  3.       Caption      =   "FACTAUD.REP"
  4.       Width        =   11460
  5.       Height       =   16185
  6.       Reportheader =   0
  7.       Header       =   2385
  8.       Transaction  =   9585
  9.       SubTotal     =   1620
  10.       Footer       =   0
  11.       Pagefooter   =   15960
  12.       Replicate    =   435
  13.       Style        =   13
  14.       Query        =   "FACTAD ALL ORDER BY STR(FCFACTER,8,0)+FCDOCNO"
  15.       Macro        =   "2CD:When FACTAD.FCTYPE="I" then REPTOT(2)=REPTOT(2)+FACTAD.FCTOTVAT"
  16.       Macro        =   "2CD:When FACTAD.FCTYPE="I" then REPTOT(3)=REPTOT(3)+FACTAD.FCTOTVALUE"
  17.       Macro        =   "2CD:When FACTAD.FCTYPE="C" then REPTOT(2)=REPTOT(2)-FACTAD.FCTOTVAT"
  18.       Macro        =   "2CD:When FACTAD.FCTYPE="C" then REPTOT(3)=REPTOT(3)-FACTAD.FCTOTVALUE"
  19.       Macro        =   "2OF:RUNTIME.ALPHAFIELD = STR(FACTAD.FCFACTER,6,0)"
  20.       Macro        =   "3PP:@REPVARS.REPTOT(1) = 0"
  21.       Macro        =   "3PP:@REPVARS.REPTOT(2) = 0"
  22.       Macro        =   "3PP:@REPVARS.REPTOT(3) = 0"
  23.       BreakOn      =   "FACTAD.FCFACTER"
  24. End
  25. Begin Control LABEL
  26.       Type         =   "Label"
  27.       Style        =   12
  28.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  29.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  30.       Location     =   "Header Block"
  31.       Height       =   270
  32.       Left         =   -15
  33.       Top          =   405
  34.       Width        =   11070
  35. End
  36. Begin Control LABEL
  37.       Type         =   "Label"
  38.       Style        =   4
  39.       Caption      =   "Factoring Audit Report"
  40.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  41.       Location     =   "Header Block"
  42.       Height       =   420
  43.       Left         =   135
  44.       Top          =   675
  45.       Width        =   11025
  46. End
  47. Begin Control LABEL
  48.       Type         =   "Label"
  49.       Style        =   9
  50.       Caption      =   "DTOC(DATE())"
  51.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  52.       Location     =   "Header Block"
  53.       Height       =   285
  54.       Left         =   135
  55.       Top          =   705
  56.       Width        =   3285
  57. End
  58. Begin Control LABEL
  59.       Type         =   "Label"
  60.       Style        =   10
  61.       Caption      =   ""Page: "+PAGENUM()"
  62.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  63.       Location     =   "Header Block"
  64.       Height       =   285
  65.       Left         =   9585
  66.       Top          =   720
  67.       Width        =   1395
  68. End
  69. Begin Control LABEL
  70.       Type         =   "Label"
  71.       Style        =   1
  72.       Caption      =   "Customer ID"
  73.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  74.       Location     =   "Header Block"
  75.       Height       =   285
  76.       Left         =   1110
  77.       Top          =   2010
  78.       Width        =   1080
  79. End
  80. Begin Control LABEL
  81.       Type         =   "Label"
  82.       Style        =   1
  83.       Caption      =   "Customer Name"
  84.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  85.       Location     =   "Header Block"
  86.       Height       =   285
  87.       Left         =   2400
  88.       Top          =   2010
  89.       Width        =   1650
  90. End
  91. Begin Control LABEL
  92.       Type         =   "Label"
  93.       Style        =   1
  94.       Caption      =   "Extraction Ref No. :"
  95.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  96.       Location     =   "Header Block"
  97.       Height       =   285
  98.       Left         =   30
  99.       Top          =   1605
  100.       Width        =   1620
  101. End
  102. Begin Control LABEL
  103.       Type         =   "Label"
  104.       Style        =   1
  105.       Caption      =   "Extraction Date :"
  106.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  107.       Location     =   "Header Block"
  108.       Height       =   285
  109.       Left         =   2730
  110.       Top          =   1605
  111.       Width        =   1350
  112. End
  113. Begin Control FCFACTDT
  114.       Type         =   "Text"
  115.       Style        =   0
  116.       Fieldname    =   "FCFACTDT"
  117.       Filename     =   "FACTAD"
  118.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  119.       Location     =   "Header Block"
  120.       Height       =   270
  121.       Left         =   4110
  122.       Top          =   1605
  123.       Width        =   1140
  124. End
  125. Begin Control FCFACTER
  126.       Type         =   "Text"
  127.       Style        =   0
  128.       Fieldname    =   "FCFACTER"
  129.       Filename     =   "FACTAD"
  130.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  131.       Location     =   "Header Block"
  132.       Height       =   270
  133.       Left         =   1620
  134.       Top          =   1605
  135.       Width        =   600
  136. End
  137. Begin Control LABEL
  138.       Type         =   "Label"
  139.       Style        =   1
  140.       Caption      =   "Extraction Time :"
  141.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  142.       Location     =   "Header Block"
  143.       Height       =   285
  144.       Left         =   5430
  145.       Top          =   1605
  146.       Width        =   1485
  147. End
  148. Begin Control LABEL
  149.       Type         =   "Label"
  150.       Style        =   9
  151.       Caption      =   "LEFT(FACTAD.FCFACTTM,2)+":"+MID(FACTAD.FCFACTTM,3,2)+":"+MID(FACTAD.FCFACTTM,5,2)"
  152.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  153.       Location     =   "Header Block"
  154.       Height       =   270
  155.       Left         =   6885
  156.       Top          =   1620
  157.       Width        =   1080
  158. End
  159. Begin Control LABEL
  160.       Type         =   "Label"
  161.       Style        =   4
  162.       Caption      =   "Type"
  163.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  164.       Location     =   "Header Block"
  165.       Height       =   285
  166.       Left         =   6585
  167.       Top          =   2010
  168.       Width        =   570
  169. End
  170. Begin Control LABEL
  171.       Type         =   "Label"
  172.       Style        =   4
  173.       Caption      =   "Total Value\r( inc. VAT )"
  174.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  175.       Location     =   "Header Block"
  176.       Height       =   420
  177.       Left         =   7215
  178.       Top          =   2010
  179.       Width        =   1050
  180. End
  181. Begin Control LABEL
  182.       Type         =   "Label"
  183.       Style        =   2
  184.       Caption      =   "VAT"
  185.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  186.       Location     =   "Header Block"
  187.       Height       =   285
  188.       Left         =   8745
  189.       Top          =   2010
  190.       Width        =   510
  191. End
  192. Begin Control LABEL
  193.       Type         =   "Label"
  194.       Style        =   1
  195.       Caption      =   "Doc. No."
  196.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  197.       Location     =   "Header Block"
  198.       Height       =   285
  199.       Left         =   105
  200.       Top          =   2010
  201.       Width        =   975
  202. End
  203. Begin Control LABEL
  204.       Type         =   "Label"
  205.       Style        =   1
  206.       Caption      =   "Status"
  207.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  208.       Location     =   "Header Block"
  209.       Height       =   285
  210.       Left         =   10530
  211.       Top          =   2010
  212.       Width        =   780
  213. End
  214. Begin Control LABEL
  215.       Type         =   "Label"
  216.       Style        =   2
  217.       Caption      =   "Factoring Ref."
  218.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  219.       Location     =   "Header Block"
  220.       Height       =   285
  221.       Left         =   5100
  222.       Top          =   2010
  223.       Width        =   1380
  224. End
  225. Begin Control LABEL
  226.       Type         =   "Label"
  227.       Style        =   4
  228.       Caption      =   "Batch No."
  229.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  230.       Location     =   "Header Block"
  231.       Height       =   285
  232.       Left         =   9585
  233.       Top          =   2010
  234.       Width        =   780
  235. End
  236. Begin Control LABEL
  237.       Type         =   "Label"
  238.       Style        =   1
  239.       Caption      =   "User Name :"
  240.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  241.       Location     =   "Header Block"
  242.       Height       =   285
  243.       Left         =   8130
  244.       Top          =   1605
  245.       Width        =   1215
  246. End
  247. Begin Control LABEL
  248.       Type         =   "Label"
  249.       Style        =   9
  250.       Caption      =   "REPSTR(8)"
  251.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  252.       Location     =   "Header Block"
  253.       Height       =   270
  254.       Left         =   9315
  255.       Top          =   1620
  256.       Width        =   2025
  257. End
  258. Begin Control FCACCID
  259.       Type         =   "Text"
  260.       Style        =   0
  261.       Fieldname    =   "FCACCID"
  262.       Filename     =   "FACTAD"
  263.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  264.       Location     =   "Transaction Block"
  265.       Height       =   270
  266.       Left         =   1110
  267.       Top          =   165
  268.       Width        =   960
  269. End
  270. Begin Control FCNAME
  271.       Type         =   "Text"
  272.       Style        =   0
  273.       Fieldname    =   "FCNAME"
  274.       Filename     =   "FACTAD"
  275.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  276.       Location     =   "Transaction Block"
  277.       Height       =   270
  278.       Left         =   2085
  279.       Top          =   165
  280.       Width        =   3435
  281. End
  282. Begin Control LABEL
  283.       Type         =   "Label"
  284.       Style        =   9
  285.       Caption      =   "IF(FACTAD.FCTYPE="I","Inv ","Cred")"
  286.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  287.       Location     =   "Transaction Block"
  288.       Height       =   270
  289.       Left         =   6645
  290.       Top          =   165
  291.       Width        =   540
  292. End
  293. Begin Control FCDOCNO
  294.       Type         =   "Text"
  295.       Style        =   0
  296.       Fieldname    =   "FCDOCNO"
  297.       Filename     =   "FACTAD"
  298.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  299.       Location     =   "Transaction Block"
  300.       Height       =   270
  301.       Left         =   30
  302.       Top          =   165
  303.       Width        =   1050
  304. End
  305. Begin Control LABEL
  306.       Type         =   "Label"
  307.       Style        =   9
  308.       Caption      =   "IF(TRIM(REPSTR(9))="N",IF(FACTAD.FCFACTEF="Y","Factored","Unfactored"),IF(FACTAD.FCFACTST="N","Failed",IF(FACTAD.FCFACTST="E","Excluded",IF(FACTAD.FCFACTST="S","Sent",""))))"
  309.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  310.       Location     =   "Transaction Block"
  311.       Height       =   270
  312.       Left         =   10395
  313.       Top          =   165
  314.       Width        =   945
  315. End
  316. Begin Control FCFACTR
  317.       Type         =   "Text"
  318.       Style        =   0
  319.       Fieldname    =   "FCFACTR"
  320.       Filename     =   "FACTAD"
  321.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  322.       Location     =   "Transaction Block"
  323.       Height       =   270
  324.       Left         =   5565
  325.       Top          =   165
  326.       Width        =   960
  327. End
  328. Begin Control LABEL
  329.       Type         =   "Label"
  330.       Style        =   9
  331.       Caption      =   "IF(TRIM(REPSTR(9))="N","",IF(FACTAD.FCFACTST="X","Extracted ",""))"
  332.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  333.       Location     =   "Transaction Block"
  334.       Height       =   270
  335.       Left         =   10395
  336.       Top          =   165
  337.       Width        =   945
  338. End
  339. Begin Control LABEL
  340.       Type         =   "Label"
  341.       Style        =   10
  342.       Caption      =   "IF(FACTAD.FCTYPE="I",STR(FACTAD.FCTOTVALUE,10,2),STR(FACTAD.FCTOTVALUE*-1,10,2))"
  343.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  344.       Location     =   "Transaction Block"
  345.       Height       =   270
  346.       Left         =   7260
  347.       Top          =   165
  348.       Width        =   945
  349. End
  350. Begin Control LABEL
  351.       Type         =   "Label"
  352.       Style        =   10
  353.       Caption      =   "IF(FACTAD.FCTYPE="I",STR(FACTAD.FCTOTVAT,10,2),STR(FACTAD.FCTOTVAT*-1,10,2))"
  354.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  355.       Location     =   "Transaction Block"
  356.       Height       =   270
  357.       Left         =   8475
  358.       Top          =   165
  359.       Width        =   945
  360. End
  361. Begin Control FCBATCHNO
  362.       Type         =   "Text"
  363.       Style        =   0
  364.       Fieldname    =   "FCBATCHNO"
  365.       Filename     =   "FACTAD"
  366.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  367.       Location     =   "Transaction Block"
  368.       Height       =   270
  369.       Left         =   9750
  370.       Top          =   165
  371.       Width        =   555
  372. End
  373. Begin Control LABEL
  374.       Type         =   "Label"
  375.       Style        =   2
  376.       Caption      =   "___________"
  377.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  378.       Location     =   "Subtotal Block"
  379.       Height       =   270
  380.       Left         =   7530
  381.       Top          =   450
  382.       Width        =   675
  383. End
  384. Begin Control LABEL
  385.       Type         =   "Label"
  386.       Style        =   10
  387.       Caption      =   "STR(REPTOT(3),10,2)"
  388.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  389.       Location     =   "Subtotal Block"
  390.       Height       =   270
  391.       Left         =   7260
  392.       Top          =   855
  393.       Width        =   945
  394. End
  395. Begin Control LABEL
  396.       Type         =   "Label"
  397.       Style        =   2
  398.       Caption      =   "___________"
  399.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  400.       Location     =   "Subtotal Block"
  401.       Height       =   270
  402.       Left         =   7530
  403.       Top          =   1125
  404.       Width        =   675
  405. End
  406. Begin Control LABEL
  407.       Type         =   "Label"
  408.       Style        =   2
  409.       Caption      =   "___________"
  410.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  411.       Location     =   "Subtotal Block"
  412.       Height       =   270
  413.       Left         =   8745
  414.       Top          =   450
  415.       Width        =   675
  416. End
  417. Begin Control LABEL
  418.       Type         =   "Label"
  419.       Style        =   10
  420.       Caption      =   "STR(REPTOT(2),10,2)"
  421.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  422.       Location     =   "Subtotal Block"
  423.       Height       =   270
  424.       Left         =   8475
  425.       Top          =   855
  426.       Width        =   945
  427. End
  428. Begin Control LABEL
  429.       Type         =   "Label"
  430.       Style        =   2
  431.       Caption      =   "___________"
  432.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  433.       Location     =   "Subtotal Block"
  434.       Height       =   270
  435.       Left         =   8745
  436.       Top          =   1125
  437.       Width        =   675
  438. End
  439. Begin Control LABEL
  440.       Type         =   "Label"
  441.       Style        =   9
  442.       Caption      =   ""Totals for Extraction "+TRIM(RUNTIME.ALPHAFIELD)"
  443.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  444.       Location     =   "Subtotal Block"
  445.       Height       =   270
  446.       Left         =   4695
  447.       Top          =   855
  448.       Width        =   2430
  449. End
  450.