How to edit ENQUIRY FILE

Hi all
I want to move Debit amount(-) from column DEPOSIT/WITHDRAWAL to paste in column value.date
Note see Out put in attached files

Full view
ENQUIRY SEE

ENQUIRY........... STMT.ENT.BOOK.BRW.REP

---

1 PAGE.SIZE ........ 6,18
2 FILE.NAME......... STMT.ENTRY
4. 1 FIXED.SORT..... DATE.TIME
6. 1 SELECTION.FLDS. ACCT.ID
7. 1. 1 GB SEL.LABEL Account
9. 1 REQUIRED.SEL... Y
6. 2 SELECTION.FLDS. BOOKING.DATE
7. 2. 1 GB SEL.LABEL Booking date
8. 2 SEL.FLD.OPER... EQ LT LE GT GE RG
6. 3 SELECTION.FLDS. PROCESSING.DATE
7. 3. 1 GB SEL.LABEL Processing Date
8. 3 SEL.FLD.OPER... EQ LT LE GT GE RG
6. 4 SELECTION.FLDS. VALUE.DATE
7. 4. 1 GB SEL.LABEL Value Date
8. 4 SEL.FLD.OPER... EQ LT LE GT GE RG
6. 5 SELECTION.FLDS. SHOW.NARRATIVE
7. 5. 1 GB SEL.LABEL Description
6. 6 SELECTION.FLDS. SHOW.REVERSAL
7. 6. 1 GB SEL.LABEL Reversal Marker
8. 6 SEL.FLD.OPER... EQ
6. 7 SELECTION.FLDS. INCL.SUB.ACCT
7. 7. 1 GB SEL.LABEL Include Sub Acct
8. 7 SEL.FLD.OPER... EQ
6. 8 SELECTION.FLDS. APPL.DRILLDOWN
7. 8. 1 GB SEL.LABEL Appl Drilldown
8. 8 SEL.FLD.OPER... EQ
12. 1 BUILD.ROUTINE.. E.MB.STMT.BOOK.BUILD
14. 1 FIELD.NAME..... NULLVAR
15. 1. 1 OPERATION... ""
21. 1 DISPLAY.BREAK.. ONCE
14. 2 FIELD.NAME..... HDR.LINE1.1
15. 2. 1 OPERATION... "Account Statement"
23. 2 FIELD.DISP.TYPE CLASS-ENQ.H.TITLE
24. 2 SECTION........ HEADER
14. 3 FIELD.NAME..... HDR.LINE2.1
15. 3. 1 OPERATION... "Account :"
23. 3 FIELD.DISP.TYPE CLASS-ENQ.ID.LABEL
24. 3 SECTION........ HEADER
14. 4 FIELD.NAME..... HDR.LINE2.2
15. 4. 1 OPERATION... "Customer :"
23. 4 FIELD.DISP.TYPE CLASS-ENQ.ID.LABEL
24. 4 SECTION........ HEADER
14. 5 FIELD.NAME..... HDR.LINE.3
15. 5. 1 OPERATION... "Currency :"
23. 5 FIELD.DISP.TYPE CLASS-ENQ.ID.LABEL
24. 5 SECTION........ HEADER
14. 6 FIELD.NAME..... @ID
15. 6. 1 OPERATION... @ID
17. 6 LENGTH.MASK.... 90L
35. 6 SINGLE.MULTI... S
14. 7 FIELD.NAME..... ACC
15. 7. 1 OPERATION... S ACCT.ID
17. 7 LENGTH.MASK.... 19L
35. 7 SINGLE.MULTI... S
14. 8 FIELD.NAME..... E.HDR.DATA
15. 8. 1 OPERATION... S ACCT.ID
16. 8 COLUMN......... 16,1
18. 8. 1 CONVERSION.. @ TU.EC.CRPT.STMT.HDR.S
21. 8 DISPLAY.BREAK.. PAGE
24. 8 SECTION........ HEADER
14. 9 FIELD.NAME..... ORIG.ACCT
15. 9. 1 OPERATION... F ACC
18. 9. 1 CONVERSION.. LINK ACCOUNT,ORIGINAL.ACCT
19. 9. 1 COMMENTS.... The original account number
14.10 FIELD.NAME..... AUTO.PAY.ACCT
15.10. 1 OPERATION... F ACC
18.10. 1 CONVERSION.. LINK ACCOUNT,AUTO.PAY.ACCT
19.10. 1 COMMENTS.... Linked auto pay acct
14.11 FIELD.NAME..... B.ACC
15.11. 1 OPERATION... BREAK CHANGE ACC
14.12 FIELD.NAME..... D.ACC
15.12. 1 OPERATION... F ACC
17.12 LENGTH.MASK.... 16L
21.12 DISPLAY.BREAK.. PAGE
23.12 FIELD.DISP.TYPE CLASS-ENQ.H.DATA
24.12 SECTION........ HEADER
14.13 FIELD.NAME..... CUS
15.13. 1 OPERATION... F ACC
17.13 LENGTH.MASK.... 10L
18.13. 1 CONVERSION.. L ACCOUNT,CUSTOMER
20.13 TYPE........... LANGUAGE
21.13 DISPLAY.BREAK.. PAGE
23.13 FIELD.DISP.TYPE CLASS-ENQ.H.DATA
24.13 SECTION........ HEADER
14.14 FIELD.NAME..... CUSNM
15.14. 1 OPERATION... F CUS
18.14. 1 CONVERSION.. L CUSTOMER,SHORT.NAME
20.14 TYPE........... LANGUAGE
21.14 DISPLAY.BREAK.. PAGE
14.15 FIELD.NAME..... ACCSNM
15.15. 1 OPERATION... F ACC
18.15. 1 CONVERSION.. L ACCOUNT,SHORT.TITLE
20.15 TYPE........... LANGUAGE
21.15 DISPLAY.BREAK.. PAGE
14.16 FIELD.NAME..... SPACE
15.16. 1 OPERATION... " "
24.16 SECTION........ HEADER
14.17 FIELD.NAME..... PRTNM
15.17. 1 OPERATION... IF CUS NE NULLVAR CUSNM ACCSNM
17.17 LENGTH.MASK.... 35L
23.17 FIELD.DISP.TYPE CLASS-ENQ.H.DATA
24.17 SECTION........ HEADER
14.18 FIELD.NAME..... CCY
15.18. 1 OPERATION... CURRENCY
14.19 FIELD.NAME..... FIX.CCY
15.19. 1 OPERATION... FIELD CCY
18.19. 1 CONVERSION.. UTIL FIXCCY,CCY
19.19. 1 COMMENTS.... The fixed currency
14.20 FIELD.NAME..... D.CCY
15.20. 1 OPERATION... F CCY
14.21 FIELD.NAME..... NULL
15.21. 1 OPERATION... ""
14.22 FIELD.NAME..... COMP.CCY
15.22. 1 OPERATION... COMPANY.CODE
17.22 LENGTH.MASK.... 11L
18.22. 1 CONVERSION.. L COMPANY,LOCAL.CURRENCY
35.22 SINGLE.MULTI... S
14.23 FIELD.NAME..... AMOUNT.LCY
15.23. 1 OPERATION... AMOUNT.LCY
17.23 LENGTH.MASK.... 19R
35.23 SINGLE.MULTI... S
14.24 FIELD.NAME..... AMOUNT.FCY
15.24. 1 OPERATION... AMOUNT.FCY
17.24 LENGTH.MASK.... 19R
35.24 SINGLE.MULTI... S
14.25 FIELD.NAME..... CCY1
15.25. 1 OPERATION... IF CCY NE NULL CCY COMP.CCY
14.26 FIELD.NAME..... DIS.CCY
15.26. 1 OPERATION... F CCY1
17.26 LENGTH.MASK.... 3L
21.26 DISPLAY.BREAK.. PAGE
23.26 FIELD.DISP.TYPE CLASS-ENQ.H.DATA
24.26 SECTION........ HEADER
14.27 FIELD.NAME..... AMT.1
15.27. 1 OPERATION... IF CCY EQ NULL AMOUNT.LCY AMOUNT.FCY
14.28 FIELD.NAME..... CHECK1
15.28. 1 OPERATION... F CCY1
18.28. 1 CONVERSION.. E 1,3
14.29 FIELD.NAME..... CHECK2
15.29. 1 OPERATION... F COMP.CCY
18.29. 1 CONVERSION.. E 1,3
14.30 FIELD.NAME..... AMOUNT
15.30. 1 OPERATION... IF CHECK2 EQ CHECK1 AMOUNT.LCY AMOUNT.FCY
14.31 FIELD.NAME..... LANG
15.31. 1 OPERATION... !LANGUAGE
21.31 DISPLAY.BREAK.. ONCE
14.32 FIELD.NAME..... TCODE
15.32. 1 OPERATION... TRANSACTION.CODE
17.32 LENGTH.MASK.... 5L
14.33 FIELD.NAME..... CVDT
15.33. 1 OPERATION... VALUE.DATE
35.33 SINGLE.MULTI... S
14.34 FIELD.NAME..... DESC
15.34. 1 OPERATION... F @ID
18.34. 1 CONVERSION.. @ E.GET.NARRATIVE
14.35 FIELD.NAME..... VALID.DESC
15.35. 1 OPERATION... IF DESC EQ @ID NULL DESC
14.36 FIELD.NAME..... NOREC
15.36. 1 OPERATION... "*** NO ENTRIES"
21.36 DISPLAY.BREAK.. ONCE
14.37 FIELD.NAME..... NOREC1
15.37. 1 OPERATION... "FOR PERIOD ***"
21.37 DISPLAY.BREAK.. ONCE
14.38 FIELD.NAME..... NULL
15.38. 1 OPERATION... ""
21.38 DISPLAY.BREAK.. ONCE
14.39 FIELD.NAME..... DELIM
15.39. 1 OPERATION... ":"
21.39 DISPLAY.BREAK.. ONCE
14.40 FIELD.NAME..... THEIR.REF
15.40. 1 OPERATION... THEIR.REFERENCE
14.41 FIELD.NAME..... B.AMT.BF
15.41. 1 OPERATION... ACCOUNT.NUMBER
17.41 LENGTH.MASK.... 19L
18.41. 1 CONVERSION.. @ E.CALC.OPEN.BALANCE
21.41 DISPLAY.BREAK.. ONCE
35.41 SINGLE.MULTI... S
14.42 FIELD.NAME..... BFWD
15.42. 1 OPERATION... "Balance at Period Start"
16.42 COLUMN......... 14,+0
21.42 DISPLAY.BREAK.. ONCE
23.42 FIELD.DISP.TYPE CLASS-TITLE
14.43 FIELD.NAME..... POST
15.43. 1 OPERATION... BOOKING.DATE
16.43 COLUMN......... 10
17.43 LENGTH.MASK.... 9L
18.43. 1 CONVERSION.. J
18.43. 2 CONVERSION.. O D2
18.43. 3 CONVERSION.. S --,
20.43 TYPE........... DATE
22.43. 1 GB FIELD.LBL Booking Date
14.44 FIELD.NAME..... REFNO
15.44. 1 OPERATION... TRANS.REFERENCE
16.44 COLUMN......... 34
17.44 LENGTH.MASK.... 25L
22.44. 1 GB FIELD.LBL Reference
14.45 FIELD.NAME..... TRANS.NARRATIVE
15.45. 1 OPERATION... TRANSACTION.CODE
17.45 LENGTH.MASK.... 50L
18.45. 1 CONVERSION.. L TRANSACTION,NARRATIVE
35.45 SINGLE.MULTI... S
14.46 FIELD.NAME..... PDESC
15.46. 1 OPERATION... IF TCODE NE NULL TRANS.NARRATIVE NOREC
17.46 LENGTH.MASK.... 50L
22.46. 1 GB FIELD.LBL Description
14.47 FIELD.NAME..... NARRATIVE
15.47. 1 OPERATION... NARRATIVE
16.47 COLUMN......... 14,+1
17.47 LENGTH.MASK.... 34L
19.47. 1 COMMENTS.... Stmt Entry Narrative
35.47 SINGLE.MULTI... M
14.48 FIELD.NAME..... CHN
15.48. 1 OPERATION... CHEQUE.NUMBER
17.48 LENGTH.MASK.... 35L
35.48 SINGLE.MULTI... M
14.49 FIELD.NAME..... I.BLNK
15.49. 1 OPERATION... " "
14.50 FIELD.NAME..... JOIN
15.50. 1 OPERATION... CALC PDESC : I.BLNK
14.51 FIELD.NAME..... JOIN1
15.51. 1 OPERATION... CALC JOIN : CHN
14.52 FIELD.NAME..... EXTRA.NARR
15.52. 1 OPERATION... F JOIN1
16.52 COLUMN......... 14
22.52. 1 GB FIELD.LBL Description
14.53 FIELD.NAME..... VALDESC
15.53. 1 OPERATION... IF TCODE NE NULL CVDT NOREC1
16.53 COLUMN......... 48
17.53 LENGTH.MASK.... 25L
20.53 TYPE........... DATE
22.53. 1 GB FIELD.LBL Value Date
14.54 FIELD.NAME..... AMT
15.54. 1 OPERATION... F AMOUNT
16.54 COLUMN......... 60
20.54 TYPE........... CCY CCY
35.54 SINGLE.MULTI... S
14.55 FIELD.NAME..... ZERO
15.55. 1 OPERATION... "0"
14.56 FIELD.NAME..... ABS.DR.AMT
15.56. 1 OPERATION... F AMT
18.56. 1 CONVERSION.. UTIL ABS
20.56 TYPE........... CCY CCY
14.57 FIELD.NAME..... DR.AMOUNT
15.57. 1 OPERATION... IF AMT LT ZERO ABS.DR.AMT NULL
14.58 FIELD.NAME..... DR.AMT
15.58. 1 OPERATION... IF TCODE NE NULL DR.AMOUNT NULL
22.58. 1 GB FIELD.LBL Debit
14.59 FIELD.NAME..... CR.AMOUNT
15.59. 1 OPERATION... IF AMT GT ZERO AMT NULL
22.59. 1 GB FIELD.LBL Credit
14.60 FIELD.NAME..... CR.AMT
15.60. 1 OPERATION... IF CR.AMOUNT EQ "0" NULL CR.AMOUNT
14.61 FIELD.NAME..... OPENING.BALANCE
15.61. 1 OPERATION... F B.AMT.BF
16.61 COLUMN......... 70,+0
20.61 TYPE........... CCY CCY
21.61 DISPLAY.BREAK.. ONCE
14.62 FIELD.NAME..... ENTRY.BALANCE
15.62. 1 OPERATION... C AMT + ENTRY.BALANCE
14.63 FIELD.NAME..... RUNNING.BALANCE
15.63. 1 OPERATION... C B.AMT.BF + ENTRY.BALANCE
20.63 TYPE........... CCY CCY
14.64 FIELD.NAME..... HYPHN
15.64. 1 OPERATION... "

---

"
21.64 DISPLAY.BREAK.. ONCE
14.65 FIELD.NAME..... AA
15.65. 1 OPERATION... "AA"
21.65 DISPLAY.BREAK.. ONCE
14.66 FIELD.NAME..... BALANCE
15.66. 1 OPERATION... IF TCODE NE NULL RUNNING.BALANCE HYPHN
16.66 COLUMN......... 70
22.66. 1 GB FIELD.LBL Closing Balance
14.67 FIELD.NAME..... SYSTEM.ID
15.67. 1 OPERATION... SYSTEM.ID
14.68 FIELD.NAME..... TRANS.REF
15.68. 1 OPERATION... TRANS.REFERENCE
14.69 FIELD.NAME..... STMT.ID
15.69. 1 OPERATION... @ID
19.69. 1 COMMENTS.... Stmt entry id
35.69 SINGLE.MULTI... S
14.70 FIELD.NAME..... BASE.APPL
15.70. 1 OPERATION... F SYSTEM.ID
18.70. 1 CONVERSION.. @ E.READ.EB.SYSTEM.ID
19.70. 1 COMMENTS.... Next level for drilldown
14.71 FIELD.NAME..... NO
15.71. 1 OPERATION... "NO"
21.71 DISPLAY.BREAK.. ONCE
14.72 FIELD.NAME..... APPL.DRILLDOWN
15.72. 1 OPERATION... SELECTION APPL.DRILLDOWN
17.72 LENGTH.MASK.... 3L
20.72 TYPE........... L
14.73 FIELD.NAME..... NEW.SYSTEM.ID
15.73. 1 OPERATION... CALC SYSTEM.ID : DELIM
14.74 FIELD.NAME..... NEW.BASE.APPL
15.74. 1 OPERATION... C NEW.SYSTEM.ID : NEXT.ID
17.74 LENGTH.MASK.... 100L
18.74. 1 CONVERSION.. @ E.CONV.APPLN
14.75 FIELD.NAME..... PS
15.75. 1 OPERATION... "PS"
21.75 DISPLAY.BREAK.. ONCE
14.76 FIELD.NAME..... PS.ID.CHK
15.76. 1 OPERATION... F REFNO
18.76. 1 CONVERSION.. F .,2,1
14.77 FIELD.NAME..... PS.ID.FIN1
15.77. 1 OPERATION... C BASE.APPL : FUN.SEE
14.78 FIELD.NAME..... PS.ID.FIN
15.78. 1 OPERATION... C PS.ID.FIN1 : PS.ID.CHK
14.79 FIELD.NAME..... NET.REF
15.79. 1 OPERATION... F REFNO
18.79. 1 CONVERSION.. F -,1,1
14.80 FIELD.NAME..... NET.ENTRY
15.80. 1 OPERATION... "NET..."
14.81 FIELD.NAME..... STMT.ENT.DET
15.81. 1 OPERATION... "ENQ STMT.ENT.DETAIL"
14.82 FIELD.NAME..... NET.SEL.ID
15.82. 1 OPERATION... "STMT.ENTRY.ID EQ "
14.83 FIELD.NAME..... NET.SEL.FORM
15.83. 1 OPERATION... IF NET.REF LK NET.ENTRY STMT.ID NULL
14.84 FIELD.NAME..... FIN.NET.ID.FORM
15.84. 1 OPERATION... C NET.SEL.ID : NET.SEL.FORM
14.85 FIELD.NAME..... FUN.SEE
15.85. 1 OPERATION... " S "
14.86 FIELD.NAME..... Y.TRAN.ID
15.86. 1 OPERATION... C BASE.APPL : FUN.SEE
14.87 FIELD.NAME..... AA.ID.FORM
15.87. 1 OPERATION... "AA.ARRANGEMENT.ACTIVITY"
14.88 FIELD.NAME..... AA.ID.FIN1
15.88. 1 OPERATION... C AA.ID.FORM : FUN.SEE
14.89 FIELD.NAME..... AA.ID.FIN
15.89. 1 OPERATION... C AA.ID.FIN1 : REFNO
14.90 FIELD.NAME..... Y.TRAN.ID.FIN
15.90. 1 OPERATION... C Y.TRAN.ID : REFNO
14.91 FIELD.NAME..... Y.STMT.ID
15.91. 1 OPERATION... C STMT.ENTRY : FUN.SEE
14.92 FIELD.NAME..... Y.STMT.ID.FIN
15.92. 1 OPERATION... C Y.STMT.ID : STMT.ID
14.93 FIELD.NAME..... Y.PS.ID
15.93. 1 OPERATION... IF SYSTEM.ID EQ PS PS.ID.FIN Y.TRAN.ID.FIN
14.94 FIELD.NAME..... Y.AA.ID
15.94. 1 OPERATION... IF BASE.APPL EQ AA.ID.FORM AA.ID.FIN Y.PS.ID
14.95 FIELD.NAME..... NET.DET.ID
15.95. 1 OPERATION... IF REFNO LK NET.ENTRY STMT.ENT.DET Y.DRILL
14.96 FIELD.NAME..... ENT.TOT
15.96. 1 OPERATION... T AMT
14.97 FIELD.NAME..... NO
15.97. 1 OPERATION... "N"
21.97 DISPLAY.BREAK.. ONCE
14.98 FIELD.NAME..... APPL.NAME
15.98. 1 OPERATION... IF BASE.APPL EQ NULL Y.STMT.ID.FIN NET.DET.ID
14.99 FIELD.NAME..... Y.DRILL
15.99. 1 OPERATION... IF BASE.APPL EQ NULL Y.STMT.ID.FIN Y.AA.ID
14100 FIELD.NAME..... NEXT.APPL
15100. 1 OPERATION... IF APPL.DRILLDOWN EQ NO Y.STMT.ID.FIN NET.DET.ID
14101 FIELD.NAME..... DRILL.DOWN
15101. 1 OPERATION... IF APPL.DRILLDOWN EQ NO Y.STMT.ID.FIN NET.DET.ID
14102 FIELD.NAME..... STMT.ENTRY
15102. 1 OPERATION... "STMT.ENTRY"
21102 DISPLAY.BREAK.. ONCE
14103 FIELD.NAME..... ZERO
15103. 1 OPERATION... "0"
21103 DISPLAY.BREAK.. ONCE
14104 FIELD.NAME..... ZER1
15104. 1 OPERATION... IF TOTAL EQ ZERO TOTAL B.AMT.BF
21104 DISPLAY.BREAK.. ONCE
14105 FIELD.NAME..... END.TOT
15105. 1 OPERATION... CALC ENT.TOT + B.AMT.BF
14106 FIELD.NAME..... D.BAL
15106. 1 OPERATION... "Balance at Period End"
16106 COLUMN......... 14,+1
21106 DISPLAY.BREAK.. B.ACC
23106 FIELD.DISP.TYPE CLASS-TITLE
14107 FIELD.NAME..... TOTAL
15107. 1 OPERATION... F RUNNING.BALANCE
16107 COLUMN......... 70,+1
20107 TYPE........... CCY CCY
21107 DISPLAY.BREAK.. B.ACC
22107. 1 GB FIELD.LBL Closing Balance
14108 FIELD.NAME..... NULL
15108. 1 OPERATION... ""
14109 FIELD.NAME..... ZERORECORDS
15109. 1 OPERATION... "Either Selection incorrect or No entries
15109. 2 OPERATION... for the period"
16109 COLUMN......... 1
21109 DISPLAY.BREAK.. NONE
23109 FIELD.DISP.TYPE CLASS-ENQ.NORECS
24109 SECTION........ HEADER
40 PAGE.FIELDS....... 82 2ý3ý4ý5ý6ý7ý9ý10ý16ý17ý18ý19ý20ý21ý22ý23ý24ý25ý27ý28ý29ý30ý32ý33ý34ý35ý40ý43ý44ý45ý46ý47ý48ý49ý50ý51ý52ý53ý54ý55ý5
42 MULTI.FIELDS...... 2 47ý48
43 BREAK.FIELDS...... 1 11
44 PROCESS.BREAKS.... 26 1ý8ý12ý13ý14ý15ý26ý31ý36ý37ý38ý39ý41ý42ý61ý64ý65ý71ý75ý97ý102ý103ý104ý106ý107ý109
45 TOTAL.FIELDS...... 1 96
46 NEXT.LVL.FLDS..... 2 97 80
56. 1 ATTRIBUTES..... NO.TOOLBAR
56. 2 ATTRIBUTES..... PAGE
56. 3 ATTRIBUTES..... NO.SELECTION
56. 4 ATTRIBUTES..... ALLDATA
56. 5 ATTRIBUTES..... ZERORECORDDISPLAY
58. 1 GB SHORT.DESC.. Account Statement
60 COMPANY.SELECT.... ALL
77 CURR.NO........... 8
78. 1 INPUTTER....... 86232_ITD
79. 1 DATE.TIME...... 28 SEP 18 09:58
80 AUTHORISER........ 86232_ITD
81 CO.CODE........... LA-001-0001
82 DEPT.CODE......... 13 lnformation Technology Department

---

Thank a lot

Are you using Enquiry Designer (ENQUIRY,INPUT). You just need to adjust the column number

HI,
CAN ANYONE PLEASE TELL ME HOW WE CAN DO FORMULA BAR IN ENQUIRY .
BELOW I ATTACHED FILE, LIKE THAT I WANT OUTPUT USING ENQUIRY,PLEASE CAN ANY ONE HELP ME


THANKS

Hello,

How to display all record from enquiry as this picture?

Hello,

How to display all record from enquiry like your picture?

Do you mean without pages? You can add attribute ALL DATA

Hello,
I refer to all data you show on html page. did you use *.xls file to display?

if yes please help share me the procedure to do it.
thanks.