Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.
SELECT BPCBPRID, BPCBPRDES, BPUCNTPT, BPCNTRTPT, BPUCNTDF, BPCNTRTDF, BPUCNTRTSD, BPCNTRTSD, BPUCNTRTED, BPCNTRTED, BPURNWTYP, BPRNWTYPE, BPURNWED, BPRNWEDTE, BPURNWTRM, BPRNWTRM, BPURNWUOM, BPRNWUOM, BPUCNTCC, BPCMDCDE, BPUCQTY, BPCNTRTQTY, BPUTUOM, BPUOM, BPUDISOR, BPQCONTROL, BPUMINQTY, BPMINQTY, BPUMAXQTY, BPMAXQTY, BPUPUOM, BPUOM3, BPUCNTRTPL, BPPRLEVL, BPUCPG, BPCNTRPRG, BPUPRICOVR, BPPRICEOVR, BPUPOCOM, BPOVRCOMM, BPUMINPRC, BPMINPRICE, BPUMAXPRC, BPMAXPRICE, BPUMP, BPMEMPRICE, BPUMPL, BPPRICELVL, BPUPRCADJ, BPASN, BPCLSID, BPCUPDLVL, BPUCNTAB01, BPCNTRAB01, BPUCNTAB02, BPCNTRAB02, BPUCNTAB03, BPCNTRAB03, BPUCNTAB04, BPCNTRAB04, BPUCNTAB05, BPCNTRAB05, BPUCNTAB06, BPCNTRAB06, BPUCNTAB07, BPCNTRAB07, BPUCNTAB08, BPCNTRAB08, BPUCNTAB09, BPCNTRAB09, BPUCNTAB10, BPCNTRAB10, BPUCNTAB11, BPCNTRAB11, BPUCNTAB12, BPCNTRAB12, BPUCNTCD01, BPCNTRT01, BPUCNTCD02, BPCNTRT02, BPUCNTCD03, BPUCNTCD04, BPCNTRT03, BPCNTRT04, BPUCNTCD05, BPCNTRT05, BPUCNTCD06, BPCNTRT06, BPUCNTCD07, BPCNTRT07, BPUCNTCD08, BPCNTRT08, BPUCNTCD09, BPCNTRT09, BPUCNTCD10, BPCNTRT10, BPUCNTCD11, BPCNTRT11, BPUCNTCD12, BPCNTRT12, BPUCNTCD13, BPCNTRT13, BPUCNTCD14, BPCNTRT14, BPUCNTCD15, BPCNTRT15, BPUCNTDT1, BPCNTRTDT1, BPUCNTDT2, BPCNTRTDT2, BPUCNTDT3, BPCNTRTDT3, BPUCNTDT4, BPCNTRTDT4, BPUCNTDT5, BPCNTRTDT5, BPUCNTDT6, BPCNTRTDT6, BPUCNTP1, BPCNTRPT01, BPUCNTP2, BPCNTRPT02, BPUCNTP3, BPCNTRPT03, BPUCNTP4, BPCNTRPT04, BPUCNTP5, BPCNTRPT05, BPUCNTP6, BPCNTRPT06, BPURCD, BPURDT, BPURAT, BPURAB, BPURRF, BPTORG, BPUSER, BPPID, BPJOBN, BPUUPMJ, BPCNTPTCB, BPCNTCOCB, BPCNTDFCB, BPCNTMNPCB, BPCNTMPCB, BPCNTMPLCB, BPCNTMQCB, BPCNTMXPCB, BPCNTOPCB, BPCNTPACB, BPCNTPGCB, BPCNTPUCB, BPCNTTUCB, BPCNTXQCB, BPCNTPLCB, BPCNTPCCB, BPCNTCQCB, BPPOPPOOL, BPGEQTYP, BPGEQPCT, BPPOPASN, BPPOPPTC, BPUPOOL, BPUEQTYP, BPUEQPCT, BPUPOPASN, BPUPOPPTC, BPPOOLCB, BPGEQTYPCB, BPGEQPCTCB, BPPOPASNCB, BPPOPPTCCB FROM F43C100
