Use the column checkboxes to build your query. Header columns sets/unsets all columns
SELECT AbsEntry, PeriodCat, FinancYear, Year, PeriodName, SubType, PeriodNum, F_RefDate, T_RefDate, F_DueDate, T_DueDate, F_TaxDate, T_TaxDate, LogInstanc, UpdateDate, UserSign, LinkAct_1, LinkAct_2, LinkAct_3, LinkAct_4, LinkAct_5, LinkAct_6, ComissAct, LinkAct_8, LinkAct_9, LinkAct_10, LinkAct_11, LinkAct_12, LinkAct_13, LinkAct_14, LinkAct_15, LinkAct_16, LinkAct_17, LinkAct_18, DfltIncom, ExmptIncom, DfltExpn, ForgnIncm, ECIncome, ForgnExpn, DfltRateDi, DecresGlAc, LinkAct_27, DftStockOB, LinkAct_19, LinkAct_20, LinkAct_21, LinkAct_22, LinkAct_23, LinkAct_24, LinkAct_25, LinkAct_26, IncresGlAc, RturnngAct, COGM_Act, AlocCstAct, VariancAct, PricDifAct, CDownPymnt, VDownPymnt, CBoERcvble, CBoEOnClct, CBoEPresnt, CBoEDiscnt, CUnpaidBoE, VBoEPayble, VAsstBoEPy, COpenDebts, VOpenDebts, PurchseAct, PaReturnAc, PaOffsetAc, LinkAct_28, ExDiffAct, BalanceAct, BnkChgAct, LinkAct_29, LinkAct_30, IncmAcct, ExpnAcct, VatRevAct, ExpClrAct, ExpOfstAct, CostRevAct, RepomoAct, WipVarAcct, SaleVatOff, PurcVatOff, DpmSalAct, DpmPurAct, ExpVarAct, CostOffAct, ECExepnses, StockAct, DflInPrcss, DfltInCstm, DfltProfit, DfltLoss, VAssets, StockRvAct, StkRvOfAct, WipAcct, DfltCard, ShpdGdsAct, GlRvOffAct, OverpayAP, UndrpayAP, OverpayAR, UndrpayAR, ARCMAct, ARCMExpAct, ARCMFrnAct, ARCMEUAct, APCMAct, APCMFrnAct, APCMEUAct, NegStckAct, StkInTnAct, GLGainXdif, GLLossXdif, AmountDiff, SlfInvIncm, SlfInvExpn, OnHoldAct, PlaAct, ICClrAct, OCClrAct, PurBalAct, WhICenAct, WhOCenAct, SalDpmInt, PurDpmInt, ExrateOnDt, UserSign2, EURecvAct, EUPayAct, WipOffset, StockOffst, DunIntrst, DunFee, SnapShotId, TDSInterst, TDSCharges FROM OACP
