| Legacy Enquiry Number | Optional | Must be unique. Leave blank to allocate the next CRM enquiry number. |
| Customer Code | Optional | Must match an existing customer or be used consistently with a new prospect name. |
| Customer Name | Required | Existing company is reused; otherwise, a new active prospect is created. |
| Contact Name | Optional | Existing matching contact is reused; otherwise, a new contact may be created. |
| Project Name | Required | Saved as the enquiry project name. |
| Tender Number / Customer Reference | Optional | Saved as the external tender or customer reference. |
| Status | Required | Must exactly match an active CRM status from the Reference sheet. |
| Probability % | Optional | Must be allowed for the selected status. The status default is used when blank. |
| Currency | Required | Must match an active currency code or name. |
| Amount | Required | Must be greater than zero. |
| Cost | Optional | Must be zero or positive. Blank is treated as zero. |
| Quantity | Required | Must be greater than zero. |
| Unit | Required | Must match an existing unit name or symbol. |
| Scope of Work | Optional | One or more configured scopes may be entered. |
| Sales Owner | Optional | Must resolve to an existing user. Blank uses the importing user. |
| Estimator | Optional | Must resolve to an existing user when supplied. |
| Country | Required | Must match a supported country. |
| City | Optional | Must be valid for the selected country. |
| Industry | Optional | Must match an existing CRM industry. |
| Expected Award Date | Optional | Saved as the expected award date. |
| Expected Delivery Date | Optional | Must be later than the award date when both are supplied. |
| Quotation Sent Date | Optional | Cannot be a future date in the company timezone. |
| Closed/Won Date | Optional | Used only for Won records. Blank uses the import time. |
| PO Number | Optional | Saved only for Won enquiries. |
| Loss Reason | Optional | Normally required for Lost records unless the missing-reason option is enabled. |
| Description | Optional | Maximum 500 characters. Project Name may be used for the line description when blank. |