Spaces:
Sleeping
Sleeping
| 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' |