Customer Details Request
To bulk-send a Customer Details Request (CDR), create a CSV file with the .csv file extension. The contents of every line in the file must use the following format:
<nmi>, <from_role>, <reason>, <notes>
Note: No header row is required for the CDR CSV file.
| Field | Format | Mandatory | Definition |
|---|---|---|---|
| nmi | Text (10 characters) | Yes | NMI, excluding the checksum. |
| from_role | Text (5 characters) | Yes | Valid Initiator for transaction according to market rules (LNSP, MC, MPB, MPC). |
| reason | One of the following:
|
Yes | Note: "Confirm Life Support" will only be valid if the business is not acting as an FRMP or LNSP in the market. |
| Notes | Text (240 characters) | Yes/No | Free text. Mandatory for some Reason Codes. |
Caution: "Confirm Life Support" is valid only if the business is not acting as a Financially Responsible Market Participant (FRMP) or Local Network Service Provider (LNSP) in the market. Otherwise, the file will fail validation.
MTS will apply the following validation rules to the entire file. If any of these conditions are met, the entire file will be rejected. In the case of multiple errors, only the first one encountered is reported.
| Order | Validation | Description | Message |
|---|---|---|---|
| 1 | Too many columns | A row has too many columns specified. | Too many columns (i.e. extra commas) |
| 2 | Too few columns | A row does not have enough columns specified. | Too few columns |
| 3 | Too many rows | The file has more than 1000 rows. | Too many rows (> 1000) |
MTS will apply the following validation rules to each record in the file. If any of these conditions are met, the row will be skipped and an error reported. If there are multiple errors identified with a row, only the first one encountered is reported.
| Order | Validation Name | Description | Message |
|---|---|---|---|
| 1 | NMI Does Not Exist | The NMI does not exist in the system. | NMI not known |
| 2 | Reason Unknown | The Reason Code does not match up to one of the valid Reason Codes. | Invalid Reason Code |
| 3 | Note Too Long | The Notes must be at most 240 characters. | The Notes must be at most 240 characters |
| 4 | Missing Special Note | A Reason Code that requires a mandatory note was supplied for the line, but a note was not supplied. | Note must be entered for selected Reason Code |
| 5 | Not FRMP Long Enough | There have not been X calendar days since the FRMP change. This value is dictated by the configuration variable CDR_Transfer_Period. | Not FRMP long enough |
| 6 | Limit Reached | The CDR has hit the limit of the number that can be created in a day. | Daily Limit Reached |
| 7 | Duplicate Request | An CDR has already been sent for that NMI/Retailer that day – including the other CDRs in the upload file. | CDR already sent for NMI today |
| 8 | Not Valid Initiator | The business is not currently operating in a valid role for the NMI. | From Role is not valid |
| 9 | Rejected CDN Too Close | There have not been X calendar days since the Rejected CDN. This value is dictated by the configuration variable CDR_CDN_Rejected_Period. | Rejected CDN Too Close |
| 10 | Confirm Life Support not useable | Reason = "Confirm Life Support" and business is acting as either FRMP or LNSP. | Invalid Reason Code |