home *** CD-ROM | disk | FTP | other *** search
- VERSION 2.00
- Begin Report NLACCENQ.REP
- Caption = "NLACCENQ.REP"
- Width = 11175
- Height = 16395
- Reportheader = 945
- Header = 1140
- Transaction = 2955
- SubTotal = 3150
- Footer = 0
- Pagefooter = 15690
- Replicate = 360
- Style = 1
- Query = "NLTRAN NTCODE=>^@0 & NTCODE<=^@1 ORDER BY NLTRAN.NTCODE"
- Macro = "1LU:Select from NLNAME where NLNAME.NNACCOUNT=NLTRAN.NTCODE"
- 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 = "2PP:@REPVARS.REPTOT(0) = REPTOT(0)+NLTRAN.NTVALUE"
- Macro = "3PP:@REPVARS.REPTOT(0) = 0"
- BreakOn = "NLTRAN.NTCODE"
- Special = "TXNRANGE(NTENTRYNO,NOQUESTIONS)"
- End
- Begin Control LABEL
- Type = "Label"
- Style = 4
- Caption = "Nominal 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 = 270
- 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 = 420
- 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 = 270
- Top = 810
- Width = 1140
- 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 = 5700
- Top = 810
- Width = 1410
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "Comment"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 9030
- Top = 810
- Width = 1275
- End
- Begin Control NNACCNAME
- Type = "Text"
- Style = 0
- Fieldname = "NNACCNAME"
- Filename = "NLNAME"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 270
- Left = 2295
- Top = 270
- Width = 3510
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "Nominal ID:"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 270
- Left = 270
- Top = 270
- Width = 945
- 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 = 3060
- Top = 810
- Width = 870
- 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 = 7320
- Top = 810
- Width = 1410
- End
- Begin Control LABEL
- Type = "Label"
- Style = 1
- Caption = "Input By"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 4275
- Top = 810
- Width = 1005
- End
- Begin Control NNACCOUNT
- Type = "Text"
- Style = 0
- Fieldname = "NNACCOUNT"
- Filename = "NLNAME"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 270
- Left = 1350
- Top = 270
- Width = 810
- End
- Begin Control LABEL
- Type = "Label"
- Style = 4
- Caption = "Entry"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Header Block"
- Height = 285
- Left = 1710
- Top = 810
- Width = 600
- End
- Begin Control NTTXNDATE
- Type = "Text"
- Style = 0
- Fieldname = "NTTXNDATE"
- Filename = "NLTRAN"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 270
- Top = 60
- Width = 1410
- End
- Begin Control NTCOMMENT
- Type = "Text"
- Style = 0
- Fieldname = "NTCOMMENT"
- Filename = "NLTRAN"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 9000
- Top = 60
- Width = 1275
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "MID(" Journal Sales Purchase Res/Prov Cash BookB/Fwd ",NLTRAN.NTTXNTYPE*9,9)"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 2835
- Top = 75
- Width = 1080
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "CORD(NLTRAN.NTVALUE,10,2,-1)"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 285
- Left = 7455
- Top = 75
- Width = 1275
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "CORD(NLTRAN.NTVALUE,10,2,1)"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 285
- Left = 5835
- Top = 75
- Width = 1275
- End
- Begin Control NTINPUTBY
- Type = "Text"
- Style = 0
- Fieldname = "NTINPUTBY"
- Filename = "NLTRAN"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 4320
- Top = 60
- Width = 735
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "mid(NLTRAN.NTENTRYNO+" ",5,5)"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 1755
- Top = 75
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 9
- Caption = "mid(NLTRAN.NTENTRYNO+" ",5,5)"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Transaction Block"
- Height = 270
- Left = 1755
- Top = 75
- Width = 945
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "CORD(@REPVARS.REPTOT(0),10,2,-1)"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Subtotal Block"
- Height = 285
- Left = 7320
- Top = 360
- Width = 1410
- End
- Begin Control LABEL
- Type = "Label"
- Style = 2
- Caption = "Account Total:"
- Font = "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
- Location = "Subtotal Block"
- Height = 270
- Left = 3915
- Top = 360
- Width = 1485
- End
- Begin Control LABEL
- Type = "Label"
- Style = 10
- Caption = "CORD(@REPVARS.REPTOT(0),10,2,1)"
- Font = "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
- Location = "Subtotal Block"
- Height = 285
- Left = 5700
- Top = 360
- Width = 1410
- End
-