QUANTITY, ISCREDIT, TRANSACTIONCURRENCYCODE, CURRENCYNAME, CURRENCYSYMBOL, PAYMENTREFERENCE, POSTINGTYPE, TEXT,
GENERALJOURNALENTRY, REASONREF, LEDGERDIMENSION,
ACCOUNTINGDATE, JOURNALNUMBER, POSTINGLAYER, LEDGER, FISCALCALENDARPERIOD, ACKNOWLEDGEMENTDATE,
DOCUMENTDATE, LEDGERPOSTINGJOURNAL, DOCUMENTNUMBER, JOURNALCATEGORY,
REASON, REASONCOMMENT,
CONSOLIDATEDCOMPANY, ISBRIDGINGPOSTING,
JOURNALDESCRIPTION, JOURNALTYPE, JOURNALNAME, SUBLEDGERVOUCHER, TRACENUM, REVERSED, REVERSEENTRY,
MODIFIEDDATETIME, MODIFIEDBY, JOURNALENTRYDATE, HISTORICALEXCHANGERATEDATE, VOUCHER_CN, REVERSED_CN, ID, CREATEDBY FROM (SELECT GJAE.RECID, GJAE.PARTITION as PARTITION, GJAE.TRANSACTIONCURRENCYAMOUNT, GJAE.ACCOUNTINGCURRENCYAMOUNT, GJAE.REPORTINGCURRENCYAMOUNT,
GJAE.QUANTITY, GJAE.ISCREDIT, GJAE.TRANSACTIONCURRENCYCODE, C.TXT AS CURRENCYNAME, C.SYMBOL AS CURRENCYSYMBOL, GJAE.PAYMENTREFERENCE, GJAE.POSTINGTYPE, GJAE.TEXT,
GJAE.GENERALJOURNALENTRY, GJAE.REASONREF, GJAE.LEDGERDIMENSION,
GJE.ACCOUNTINGDATE, GJE.JOURNALNUMBER, GJE.POSTINGLAYER, GJE.LEDGER, GJE.FISCALCALENDARPERIOD, GJE.ACKNOWLEDGEMENTDATE,
GJE.DOCUMENTDATE, GJE.LEDGERPOSTINGJOURNAL, GJE.DOCUMENTNUMBER, GJE.JOURNALCATEGORY,
RTR.REASON, RTR.REASONCOMMENT,
LE.CONSOLIDATEDCOMPANY, LE.ISBRIDGINGPOSTING,
LJT.NAME as JOURNALDESCRIPTION, LJT.JOURNALTYPE, LJT.JOURNALNAME,
TRT.TRACENUM, TRT.REVERSED, TL.CREATEDBY, LJT.MODIFIEDDATETIME, LJT.MODIFIEDBY, LJT.POSTEDDATETIME as JOURNALENTRYDATE, GJAE.HISTORICALEXCHANGERATEDATE, GJEW.VOUCHER_CN, GJEW.REVERSED_CN, LVTCN.ID, GJE.SUBLEDGERVOUCHER, LJTR.REVERSEENTRY FROM GENERALJOURNALACCOUNTENTRY GJAE