Texas Capital WarehouseNOW Sample eGuide

Creating the Release Request Import File Tips for Creating a Valid Import File • Complete all required fields or the system will return an error message during the import. A list of fields and values is provided in Appendix C . • The Release Request Spreadsheet must contain a single worksheet. Delete any extra worksheets prior to import. • Clear any unused fields. Hidden ‘0’s or extra spaces in “blank” fields can cause unexpected errors. • Verify your number fields carefully. Leading zeros are often removed by the spreadsheet due to formatting rules. To avoid this, format the cell number category as “text.”

Input your customer code into the customer_code field. Input the collateral_key entered for the funding request.

customer_code collateral_key

Enter the Pool ID for all collateral that ships together in a single shipment as a Pool to a specific Investor. Note: If you submit a Release Request against a note that has not been received by Texas Capital Bank, your entire Pool might be delayed. Best practice is to ensure all notes have been received for a given Pool prior to submitting a release request.

Pool_id

Release_reason_code

2

mm/dd/yyyy

Request_date Recipient_type Investor_code

0

3 character investor code. Recipient_track_location_code 6 character investor location code. Inv_commit_expire_date mm/dd/yyyy

32

Client Support warehouselending@texascapitalbank.com 1.866.503.6365