The National City Warehouse Report allows users to update Colonial Bank regarding loans on its warehouse line.
For a loan to appear in this report: Funding > Funded Date must be between the Funded Date Range selected and Funding > Delivery Method for Funds must be completed.
Include Cancelled Loans check box is available if cancelled loans are to be included in the report findings.
Users have the ability to filter the report results by Institution. For the Institution field, begin typing in the name of the field response and the field options will appear as a rolodex.
Users have the ability to filter the report results by Warehouse Bank. The Warehouse Bank field is a drop-down list with all available Warehouse Banks to select from or the ability to select All Warehouse Banks.
Include Archived Loans check box is available to be marked if archived loans are to be included in the report findings.
Users have the ability to filter the report results by Funding Type. The Funding Type field is a drop-down list with the option to select either Wire or Check/Certified Check.
A Funded Date Range can be selected and will be the date range that determines the loan files that will fall into the report based on the funded date of the loan.
Enter in the Records/Page amount which can range between ten and two hundred.
Click Submit after all applicable information has been entered.
National City Warehouse results will display.
A Printer Friendly Version link will display and if clicked, users will have the ability to print the report results.
The Beginning Date and End Date previously entered on the Report Filter will display in the upper left corner of the screen.
A Return to Report Filter link will display and if clicked, the user will return to the report filter to make changes and re-run the report.
The Report results will display with the following parameters: Customer Account Key, Collateral Key, Borrower 1 Last Name, Borrower 1 First Name, Borrower 2 Last name, Borrower 2 First Name, Address, City, State, Zip, County, SS Number, SS Number 2, Product Code, Original Term, Original UPB, Current UPB, UDF Dollar 1, UDF Dollar 2, Original Rate, Origination Date, Collateral Value Flag, Effective Date, Track Location Code, Home Track Location Code, Investor Code, Investor Commitment Price, Investor Commitment Number, File Date, BB Original Advance Amount, UDF Interest 1, UDF Date 2, UDF Char 2, Property Type Code, Arm index, Lien Position, Original LTV, Original CLTV, Balloon Flag, Fico Score, Credit Grade Code, Mortgage Insurance Packet, Original Appraised Value, Current Appraised Value, Servicing Status Code, Construction Cost, Maturity, MERS Min, Purpose Code, UDF Char 7, Customer Code, Loan ID, Funding ID, Funding batch, Funding Amount, Funding Method Code, Request ID, Funding Action Code, Advance Amount, Closing Agent Code, Payee Instruction 1, and Payee Instruction 2.
To Export the report in CSV format, click the button in the upper right corner of the screen, Export CSV. To review the report, click the Download Report link. To save the report to a local computer, right-click the Download Report link and click Save Target As.
To Export the report in Tab format, click the button in the upper right corner of the screen, Export Tab. To review the report, click the Download Report link. To save the report to a local computer, right-click the Download Report link and click Save Target As.