select 
    Col1 as "Record Type",
    Col2 as "Account Number",
    Col3 as "Master Account Indicator",
    Col4 as "Master Account Number",
    Col5 as "Statement Consolidate Indicator",
    Col6 as "Product",
    Col7 as "Next Payment Duedate",
    Col8 as "Next Payment Dueamount",
    Col9 as "Contract Rate",
    Col10 as "Loan Balance",
    Col11 as "Current Payoff Amount",
    Col12 as "Last Payment Date",
    Col13 as "Bankruptcy Indicator",
    Col14 as "Repo Fore Closure Indicator",
    Col15 as "Last Payment Amount",
    Col16 as "Active Date",
    Col17 as "First Payment Date",
    Col18 as "Next Duedate",
    Col19 as "Bill Method Code",
    Col20 as "Sale Premium Percent",
    Col21 as "Down Payment Amount",
    Col22 as "Contract Financed Amount",
    Col23 as "Financed Charge",
    Col24 as "Total Payments",
    Col25 as "Contract Term",
    Col26 as "Payment Amount",
    Col27 as "Current Payment Amount",
    Col28 as "Late Charge Amount",
    Col29 as "Other Due Amount",
    Col30 as "Contract Date",
    Col31 as "Payment Mode",
    Col32 as "Maturity Date",
    Col33 as "Current Maturity Date",
    Col34 as "Due Delinquent Amount",
    Col35 as "Due Total Amount",
    Col36 as "Due Nsf Amount",
    Col37 as "Days Past Due",
    Col38 as "Future Payoff Amount",
    Col39 as "Future Payoff Date",
    Col40 as "Exemption Indicator",
    Col41 as "Exemption Reasoncode",
    Col42 as "Exemption Start Date",
    Col43 as "Exemption End Date",
    Col44 as "Super Poolid",
    Col45 as "Poolid",
    Col46 as "Pool Status",
    Col47 as "Pool Sale Date",
    Col48 as "Repurchased Indicator",
    Col49 as "Repurchase Date",
    Col50 as "Trade Equity Amount",
    Col51 as "Equity In Amount",
    Col52 as "Equity Out Amount",
    Col53 as "Account Currency",
    Col54 as "Outstanding Total Amount",
    Col55 as "Account Status",
    Col56 as "Stop Correspondence Indicator",
    Col57 as "Skip Credit Bureaure Porting",
    Col58 as "Allow Repossession On Scra",
    Col59 as "Cpt Indicator",
    Col60 as "Cpt Frequency Code",
    Col61 as "Cpt Grace Days",
    Col62 as "Cpt Start Basis Code",
    Col63 as "Cpt Start Date",
    Col64 as "Cpt Tolerance Amount",
    Col65 as "Customer Score",
    Col66 as "Behaviour Score",
    Col67 as "Customer Grade",
    Col68 as "Account Rate",
    Col69 as "Account Amount Financed",
    Col70 as "Account Term",
    Col71 as "Application Number",
    Col72 as "Xref",
    Col73 as "Last Activity Date",
    Col74 as "Due Day",
    Col75 as "Last Bill Amount",
    Col76 as "Chargeoff Date",
    Col77 as "Paidoff Date",
    Col78 as "Effective Date",
    Col79 as "Militaryduty Indicator",
    Col80 as "Writtenoff Balance",
    Col81 as "Billing Cycle",
    Col82 as "Company Code",
    Col83 as "Company Name",
    Col84 as "Branch Code",
    Col85 as "Branch Name",
    Col86 as "Paid Term"
from OFSLL_Pipe 
where Col1='REC1'