CMDLINE1="C.ACCNO,C.DESP,C.CURRCODE,B.FPERIOD,B.DATE,B.REFERENCE,B.FCAMT,B.DEBITAMT-B.CREDITAMT,B.ARAPTYPE,B.EXC_RATE "
CMDLINE2="GLPOST B ON (A.BATCHNO * 10000 + A.TRANNO=B.BATCHNO * 10000 + B.TRANNO)"
CMDLINE3="GLDATA C ON (A.ACCNO=C.ACCNO)"
SELECT &CMDLINE1 FROM INITFILE A INNER JOIN &CMDLINE2 INNER JOIN &CMDLINE3 INTO CURSOR EXCEL_INITFILE
EXCEL_TITLE_NAME_1=LGS("Transactions Listing")
EXCEL_SUB_TITLE_1=LGS("A/C No.")
EXCEL_SUB_TITLE_2=LGS("Description")
EXCEL_SUB_TITLE_3=LGS("Currency Code")
EXCEL_SUB_TITLE_4=LGS("Period")
EXCEL_SUB_TITLE_5=LGS("Date")
EXCEL_SUB_TITLE_6=LGS("Reference")
EXCEL_SUB_TITLE_7=lgs("Foreign")
EXCEL_SUB_TITLE_8=LGS("Local")
EXCEL_SUB_TITLE_9=LGS("Type")
EXCEL_SUB_TITLE_10=LGS("Rate")
EXCEL_COMMAND_AMOUNT(7,8)
EXCEL_COMMAND_LINE("J")