home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
SLACCENQ.REP
< prev
next >
Wrap
Text File
|
1995-11-09
|
21KB
|
635 lines
VERSION 2.00
Begin Report SLACCENQ.REP
Caption = "SLACCENQ.REP"
Width = 11175
Height = 16395
Reportheader = 975
Header = 2460
Transaction = 1605
SubTotal = 3150
Footer = 0
Pagefooter = 15690
Replicate = 360
Style = 1
Query = "SLTRAN STACCOUNT=>^@0 & STACCOUNT<=^@1 ORDER BY STACCOUNT"
Macro = "1LU:Select from SLNAME where SLNAME.SNACCOUNT=SLTRAN.STACCOUNT"
Macro = "1OF:@REPVARS.REPTOT(0) = 0"
Macro = "1OF:@REPVARS.REPTOT(1) = 0"
Macro = "1OF:@REPVARS.REPTOT(2) = 0"
Macro = "1OF:@REPVARS.REPTOT(3) = 0"
Macro = "1OF:@REPVARS.REPTOT(4) = 0"
Macro = "2OF:@REPVARS.REPTOT(0) = @REPVARS.REPTOT(0)+SLTRAN.STOUTSTAND"
Macro = "2OF:@REPVARS.REPTOT(1) = PERIOD(DATE(),SLTRAN.STTXNDATE)"
Macro = "2CD:When SLTRAN.STTYPE="R" & SLTRAN.STALLOC=" " then REPTOT(1)=-1"
Macro = "2CD:When REPTOT(1)=-1 then REPTOT(6)=REPTOT(6)+SLTRAN.STOUTSTAND"
Macro = "2CD:When REPTOT(1)=0 then REPTOT(2)=REPTOT(2)+SLTRAN.STOUTSTAND"
Macro = "2CD:When REPTOT(1)=1 then REPTOT(3)=REPTOT(3)+SLTRAN.STOUTSTAND"
Macro = "2CD:When REPTOT(1)=2 then REPTOT(4)=REPTOT(4)+SLTRAN.STOUTSTAND"
Macro = "2CD:When REPTOT(1)=3 then REPTOT(5)=REPTOT(5)+SLTRAN.STOUTSTAND"
Macro = "3PP:@REPVARS.REPTOT(0) = 0"
Macro = "3PP:@REPVARS.REPTOT(1) = 0"
Macro = "3PP:@REPVARS.REPTOT(2) = 0"
Macro = "3PP:@REPVARS.REPTOT(3) = 0"
Macro = "3PP:@REPVARS.REPTOT(4) = 0"
Macro = "3PP:@REPVARS.REPTOT(5) = 0"
Macro = "3PP:@REPVARS.REPTOT(6) = 0"
BreakOn = "SLTRAN.STACCOUNT"
End
Begin Control LABEL
Type = "Label"
Style = 4
Caption = "Customer Account Enquiry"
Font = "-315|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Reportheader Block"
Height = 420
Left = 135
Top = 540
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 = 720
Width = 1800
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 = 9075
Top = 705
Width = 1800
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 = 1
Caption = "Date"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 135
Top = 2130
Width = 1140
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Reference"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 2790
Top = 2130
Width = 1275
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Debit"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 5565
Top = 2130
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Balance"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 8760
Top = 2130
Width = 1275
End
Begin Control SNNAME
Type = "Text"
Style = 0
Fieldname = "SNNAME"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 270
Top = 240
Width = 3375
End
Begin Control SNADD1
Type = "Text"
Style = 0
Fieldname = "SNADD1"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 270
Top = 510
Width = 3375
End
Begin Control SNADD2
Type = "Text"
Style = 0
Fieldname = "SNADD2"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 270
Top = 780
Width = 3375
End
Begin Control SNADD3
Type = "Text"
Style = 0
Fieldname = "SNADD3"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 270
Top = 1050
Width = 3375
End
Begin Control SNADD4
Type = "Text"
Style = 0
Fieldname = "SNADD4"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 270
Top = 1320
Width = 3375
End
Begin Control SNPOSTCODE
Type = "Text"
Style = 0
Fieldname = "SNPOSTCODE"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 270
Top = 1590
Width = 3375
End
Begin Control SNACCOUNT
Type = "Text"
Style = 0
Fieldname = "SNACCOUNT"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4995
Top = 240
Width = 1350
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Customer ID:"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 3780
Top = 240
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Turnover:"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7965
Top = 780
Width = 1080
End
Begin Control SNTURNOVER
Type = "Text"
Style = 0
Fieldname = "SNTURNOVER"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 9180
Top = 780
Width = 1350
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Credit Limit:"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7965
Top = 1050
Width = 1215
End
Begin Control SNCREDIT
Type = "Text"
Style = 0
Fieldname = "SNCREDIT"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 9180
Top = 1050
Width = 1350
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Credit"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 7050
Top = 2130
Width = 1410
End
Begin Control SNTEL
Type = "Text"
Style = 0
Fieldname = "SNTEL"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4995
Top = 780
Width = 1890
End
Begin Control SNFAX
Type = "Text"
Style = 0
Fieldname = "SNFAX"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4995
Top = 1050
Width = 1890
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Tel:"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 3780
Top = 780
Width = 675
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Fax:"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 3780
Top = 1050
Width = 675
End
Begin Control SNCONTACT
Type = "Text"
Style = 0
Fieldname = "SNCONTACT"
Filename = "SLNAME"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4995
Top = 1590
Width = 2565
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Contact:"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 3780
Top = 1590
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Status"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4275
Top = 2130
Width = 1140
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Type"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 1440
Top = 2130
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(SLNAME.SNFACTT="Y","Factored Customer",IF(TRIM(SLNAME.SNFACTR)<>"","Non Factored Customer",""))"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7965
Top = 240
Width = 2565
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "if(TRIM(SLNAME.SNFACTR)<>"","Factor Reference ","")"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7965
Top = 510
Width = 1485
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "SLNAME.SNFACTR"
Font = "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 9450
Top = 510
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "if(TRIM(SLNAME.SNFACTR)<>"","Factored","")"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 10245
Top = 2130
Width = 735
End
Begin Control STTXNDATE
Type = "Text"
Style = 0
Fieldname = "STTXNDATE"
Filename = "SLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 135
Top = 60
Width = 1140
End
Begin Control STREF
Type = "Text"
Style = 0
Fieldname = "STREF"
Filename = "SLTRAN"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 2790
Top = 60
Width = 1275
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "CORD(SLTRAN.STVALUE,10,2,1)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 5565
Top = 75
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "CORD(SLTRAN.STVALUE,10,2,-1)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 7050
Top = 75
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(SLTRAN.STVALUE>0 & SLTRAN.STVALUE<>SLTRAN.STOUTSTAND,CORD(SLTRAN.STOUTSTAND,10,2,1),"")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 8670
Top = 75
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "if(SLTRAN.STDISP="D","Disputed",MID(" Paid Allocated",INSTR("PA",SLTRAN.STALLOC)*9+1,9))"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 4185
Top = 75
Width = 1350
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "MID(" InvCrnRecAdjDscRfd",INSTR("ICRADF",SLTRAN.STTYPE)*3+1,3)"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 1485
Top = 75
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(TRIM(SLNAME.SNFACTR)<>"",IF(SLTRAN.STFACTEF='Y',"Yes","No"),"")"
Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 285
Left = 10290
Top = 75
Width = 600
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 = "Subtotal Block"
Height = 285
Left = 8805
Top = 765
Width = 1410
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Balance"
Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Subtotal Block"
Height = 270
Left = 8640
Top = 495
Width = 1485
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 = "Subtotal Block"
Height = 285
Left = 840
Top = 765
Width = 1410
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 = "Subtotal Block"
Height = 285
Left = 5565
Top = 765
Width = 1410
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 = "Subtotal Block"
Height = 285
Left = 3810
Top = 765
Width = 1410
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 = "Subtotal Block"
Height = 285
Left = 2325
Top = 765
Width = 1410
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 = "Subtotal Block"
Height = 270
Left = 5535
Top = 495
Width = 1485
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 = "Subtotal Block"
Height = 270
Left = 3780
Top = 495
Width = 1485
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 = "Subtotal Block"
Height = 270
Left = 2295
Top = 495
Width = 1485
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 = "Subtotal Block"
Height = 270
Left = 810
Top = 495
Width = 1485
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 = "Subtotal Block"
Height = 270
Left = 7425
Top = 495
Width = 1215
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 = "Subtotal Block"
Height = 285
Left = 7185
Top = 765
Width = 1410
End