home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
PLAGED.REP
< prev
next >
Wrap
Text File
|
1995-11-14
|
14KB
|
424 lines
VERSION 2.00
Begin Report PLAGED.REP
Caption = "PLAGED.REP"
Width = 11295
Height = 15510
Reportheader = 930
Header = 585
Transaction = 11775
SubTotal = 0
Footer = 765
Pagefooter = 15000
Replicate = 390
Style = 16
Query = "PLTRAN PTCODE => ^@0 & PTCODE <= ^@1 ORDER BY PLTRAN.PTCODE"
Macro = "1OF:@REPVARS.REPSTR(0) = "0""
Macro = "1OF:@REPVARS.REPSTR(1) = "0""
Macro = "2LU:Select from PLNAME where PLNAME.PNCODE=PLTRAN.PTCODE"
Macro = "2OF:@REPVARS.REPTOT(0) = @REPVARS.REPTOT(0)+PLTRAN.PTOUTSTAND"
Macro = "2OF:@REPVARS.REPTOT(1) = PERIOD(DATE(),PLTRAN.PTTXNDATE)"
Macro = "2CD:When PLTRAN.PTTXNTYPE="P" & PLTRAN.PTALLOC=" " then REPTOT(1)=-1"
Macro = "2CD:When REPTOT(1)=-1 then REPSTR(0)=STR(REPSTR(0)+PLTRAN.PTOUTSTAND,10,2)"
Macro = "2CD:When REPTOT(1)=0 then REPTOT(2)=REPTOT(2)+PLTRAN.PTOUTSTAND"
Macro = "2CD:When REPTOT(1)=1 then REPTOT(3)=REPTOT(3)+PLTRAN.PTOUTSTAND"
Macro = "2CD:When REPTOT(1)=2 then REPTOT(4)=REPTOT(4)+PLTRAN.PTOUTSTAND"
Macro = "2CD:When REPTOT(1)=3 then REPTOT(5)=REPTOT(5)+PLTRAN.PTOUTSTAND"
Macro = "3OF:@REPVARS.REPTOT(6) = REPTOT(6)+REPTOT(2)"
Macro = "3OF:@REPVARS.REPTOT(7) = REPTOT(7)+REPTOT(3)"
Macro = "3OF:@REPVARS.REPTOT(8) = REPTOT(8)+REPTOT(4)"
Macro = "3OF:@REPVARS.REPTOT(9) = REPTOT(9)+REPTOT(5)"
Macro = "3OF:@REPVARS.REPSTR(1) = STR(REPSTR(1)+REPSTR(0),10,2)"
Macro = "3OF:@REPVARS.REPTOT(0) = 0"
Macro = "3OF:@REPVARS.REPTOT(1) = 0"
Macro = "3OF:@REPVARS.REPTOT(2) = 0"
Macro = "3OF:@REPVARS.REPTOT(3) = 0"
Macro = "3OF:@REPVARS.REPTOT(4) = 0"
Macro = "3OF:@REPVARS.REPTOT(5) = 0"
Macro = "3OF:@REPVARS.REPSTR(0) = "0""
Macro = "4OF:@REPVARS.REPTOT(5) = REPTOT(9)+REPTOT(8)+REPTOT(7)+REPTOT(6)+REPSTR(1)"
Macro = "4PP:@REPVARS.REPTOT(5) = 0"
Macro = "4PP:@REPVARS.REPTOT(6) = 0"
Macro = "4PP:@REPVARS.REPTOT(7) = 0"
Macro = "4PP:@REPVARS.REPTOT(8) = 0"
Macro = "4PP:@REPVARS.REPTOT(9) = 0"
Macro = "4PP:@REPVARS.REPSTR(1) = "0""
BreakOn = "PLTRAN.PTCODE"
End
Begin Control LABEL
Type = "Label"
Style = 12
Caption = "TRIM(SYSTEM.COMPNAME)"
Font = "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 285
Left = 135
Top = 135
Width = 10890
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Aged Creditors List"
Font = "-315|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 420
Left = 135
Top = 405
Width = 10890
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "DTOC(DATE())"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 285
Left = 135
Top = 585
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = ""Page "+PAGENUM()"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 285
Left = 9285
Top = 585
Width = 1800
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Supplier ID"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 135
Top = 150
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Current"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4230
Top = 150
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "1 Month"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 3375
Top = 150
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "2 Months"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 2235
Top = 150
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "C/R Limit"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7530
Top = 150
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Total"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 6465
Top = 150
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Unallocated"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5190
Top = 150
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "3 Months +"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 1275
Top = 150
Width = 945
End
Begin Control PNDEBIT
Type = "Text"
Style = 0
Fieldname = "PNDEBIT"
Filename = "PLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 7485
Top = 105
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(0),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 6300
Top = 105
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(5),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 1290
Top = 105
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(2),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 4260
Top = 105
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(3),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 3255
Top = 105
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(4),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 2280
Top = 105
Width = 945
End
Begin Control PNCODE
Type = "Text"
Style = 0
Fieldname = "PNCODE"
Filename = "PLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 195
Top = 105
Width = 1080
End
Begin Control PNNAME
Type = "Text"
Style = 0
Fieldname = "PNNAME"
Filename = "PLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 8505
Top = 105
Width = 2700
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPSTR(0),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 5280
Top = 105
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(9),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 285
Left = 1290
Top = 480
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(8),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 285
Left = 2280
Top = 480
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(7),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 285
Left = 3255
Top = 480
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(6),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 285
Left = 4260
Top = 480
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(@REPVARS.REPTOT(5),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 285
Left = 6300
Top = 480
Width = 1005
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "3 Months +"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 1275
Top = 210
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "2 Months"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 2235
Top = 210
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "1 Month"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 3375
Top = 210
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Current"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 4230
Top = 210
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Total"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 6465
Top = 210
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Total"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 135
Top = 480
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "STR(REPSTR(1),10,2)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 285
Left = 5280
Top = 480
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Unallocated"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Footer Block"
Height = 270
Left = 5190
Top = 210
Width = 1080
End