Step 3a/b - Submission of Results - XML (Combined CPR and Line Listing) File
Low Sort Scheme
The table below indicates all the fields and the order in which you MUST supply them for the following mailing schemes:
- Low Sort Letters
- Low Sort Large Letters
- Low Sort Mixed Weight Large Letters
IMPORTANT NOTES:
- Numeric values must be a whole number.
- Percentage values must be rounded to two decimal points.
- Entity References - some characters have a special meaning in XML. e.g. if you place a character like "<" inside an XML element,
it will generate an error because the parser interprets it as the start of a new element.
There are 5 predefined entity references in XML:
Entity Reference Character Description < < less than > > greater than & & ampersand ' ' apostrophe " " quotation mark
Field | Size | Type | XML Element Name | Description / Example |
---|---|---|---|---|
Database Version | 50 | Alphanumeric |
<database_version> . </database_version> |
Indicating the name of the latest release of selection file e.g. "RMSF2013R1" |
Field | Size | Type | XML Element Name | Description / Example |
---|---|---|---|---|
Account Number | 10 | Integer |
<account_number> . </account_number> |
Your Royal Mail account number. This is 9 digits and can start with a zero e.g. "012345678" |
Account Name | 50 | Alphanumeric |
<account_name> . </account_name> |
The name of the Royal Mail account associated with the account number above. e.g. "Joe Bloggs Publishing" |
Cell Reference | 5 | Alphanumeric |
<cell_reference> . </cell_reference> |
This is used to identify multiple postings on the same account. It is alphanumeric, e.g. "A" |
Posting Date | 10 | Date |
<posting_date> . </posting_date> |
The date you plan for mailing to be collected from the poster premises to enter Royal Mail’s pipeline. e.g. "14-05-2013" (DD-MM-YYYY) |
Poster Name | 50 | Alphanumeric |
<poster_name> . </poster_name> |
The name of the company where the mail is being collected from. e.g. "Joe Bloggs Publishing" |
Poster Address | 100 | Alphanumeric |
<poster_address> . </poster_address> |
address of the company where the mail is being collected from. "1 Main Street" |
Poster Postcode | 8 | Alphanumeric |
<poster_postcode> . </poster_postcode> |
The postcode of the company where the mail is being collected from. "EC1 1AA" |
Field | Size | Type | XML Element Name | Description / Example |
---|---|---|---|---|
Class | 10 | Alphanumeric |
<mail_class> . </mail_class> |
The delivery speed. e.g. "2" |
CDD for Deferred | 10 | Date |
<cdd> . </cdd> |
The date you would like an Economy Deferred mailing to commence delivery. e.g. "14-05-2013" (DD-MM-YYYY) |
Product | 30 | Alphanumeric |
<product> . </product> |
The product you wish to use. e.g. "Business Mail" |
Sort Option | 30 | Alphanumeric |
<sort_option> . </sort_option> |
The level of sortation you wish to. e.g. "Low Sort" |
Minimum Selection Size | 10 | Integer |
<minimum_selection_size> . </minimum_selection_size> |
For posting Low Sort, enter the minimum selection size as "1". |
Formats | 15 | Alphanumeric |
<formats> . </formats> |
The format of the mail you are posting. e.g. "Large Letters" |
Weight of Item | 5 | Integer |
<item_weight> . </item_weight> |
Actual (single weight mailing) or average (mixed weight mailing) item weight, range 1-2000. e.g. "100" |
Container | 10 | Alphanumeric |
<container> . </container> |
The primary container the mail will be contained in from the option. e.g "Bag" |
Max Items Per Container | 5 | Integer |
<max_items> . </max_items> |
The max number of items in the container that you’re using. e.g. 1-10000. This number will be the max weight of the container you are using (bag 11kg, tray 10kg) divided by the weight of the item. |
Mixed Weight Mailing | 3 | Alphanumeric |
<mixed_weight> . </mixed_weight> |
Is this a mixed weight mailing?. e.g. "Yes" or "No" |
Unique Job Reference | 10 | Alphanumeric |
<job_reference> . </job_reference> |
Unique job reference number. e.g. "JREF123456" |
Field | Size | Type | XML Element Name | Description / Example |
---|---|---|---|---|
Address Records Processed | 10 | Integer |
<address_records_processed> . </address_records_processed> |
The number of records being used for the mailing. |
Postcode Matched | 10 | Integer |
<postcode_matched> . </postcode_matched> |
The amount of addresses within those records that have matched postcodes. |
Post Town Matched | 10 | Integer |
<postcode_matched> . </postcode_matched> |
The amount of addresses within those records that have matched post towns. |
Address Not Matched | 10 | Integer |
<address_notmatched> . </address_notmatched> |
The number of addresses where data is incomplete. |
Number Suitable For Mailing | 10 | Integer |
<suitable_mailing> . </suitable_mailing> |
The number of addresses from the database that qualify for bulk mail discounts. |
Field | Size | Type | XML Element Name | Description / Example |
---|---|---|---|---|
Full Postcode - Eligible Items | 10 | Integer |
<full_postcode_eligible_items> . </full_postcode_eligible_items> |
The number of items fully & accurately post coded and addresses against PAF. |
Full Postcode - Eligible Percentages | 5 | Floating points (2 decimals) |
<full_postcode_eligible_percents> . </full_postcode_eligible_percents> |
The percentage of items fully & accurately postcode and addressed against PAF. |
Postcode Level - Eligible Items | 10 | Integer |
<outward_postcode_eligible_items> . </outward_postcode_eligible_items> |
The number of items of mail with some form of postcode on the item. |
Postcode Level - Eligible Percentages | 5 | Floating points (2 decimals) |
<outward_postcode_eligible_percents> . </outward_postcode_eligible_percents> |
The percentage of items of mail with some form of postcode on the item. |
Outward Postcode Only - Eligible Items | 10 | Integer |
<postcode_level_eligible_items> . </postcode_level_eligible_items> |
The number of items of mail with only the outward part of the postcode complete. |
Outward Postcode Only - Eligible Percentages | 5 | Floating points (2 decimals) |
<postcode_level_eligible_percents> . </postcode_level_eligible_percents> |
The percentage of mail with only the outward part of the postcode complete. |
No Postcode - Eligible Items | 10 | Integer |
<no_postcode_eligible_items> . </no_postcode_eligible_items> |
The number of items of mail with no postcode at all on the items. |
No Postcode - Eligible Percentages | 5 | Floating points (2 decimals) |
<no_postcode_eligible_percents> . </no_postcode_eligible_percents> |
The percentage of items of mail with no postcode at all on the items. |
Field | Size | Type | XML Element Name | Description / Example |
---|---|---|---|---|
DPS Matched - Eligible Items | 10 | Integer |
<dps_matched_eligible_items> . </dps_matched_eligible_items> |
The number of items with DPS accuracy Please leave it as blank (no longer used). |
DPS Matched - Eligible Percentages | 5 | Floating points (2 decimals) |
<dps_matched_eligible_percents> . </dps_matched_eligible_percents> |
The percentage of items with DPS accuracy Please leave it as blank (no longer used). |
Default DPS - Eligible Items | 10 | Integer |
<default_dps_eligible_items> . </default_dps_eligible_items> |
The number of items with default DPS accuracy Please leave it as blank (no longer used). |
Default DPS - Eligible Percentages | 5 | Floating points (2 decimals) |
<default_dps_eligible_percents> . </default_dps_eligible_percents> |
The percentage of items with default DPS accuracy Please leave it as blank (no longer used). |
No DPS - Eligible Items | 10 | Integer |
<no_dps_eligible_items> . </no_dps_eligible_items> |
The number of items with no DPS Please leave it as blank (no longer used). |
No DPS - Eligible Percentages | 5 | Floating points (2 decimals) |
<no_dps_eligible_percents> . </no_dps_eligible_percents> |
The percentage of items with no DPS Please leave it as blank (no longer used). |
Field | Size | Type | XML Element Name | Description / Example |
---|---|---|---|---|
Eligible Direct Selections | 4 | Integer |
<eligible_direct_number> . </eligible_direct_number> |
The number of eligible direct selections. |
Eligible Direct Selections - Items | 10 | Integer |
<eligible_direct_items> . </eligible_direct_items> |
The number of eligible direct items. |
Eligible Direct Selections- % Match | 5 | Floating points (2 decimals) |
<eligible_direct_percent_match> . </eligible_direct_percent_match> |
The number of eligible direct items expressed in percentages. |
Eligible Direct Selections - Containers | 10 | Integer |
<eligible_direct_containers> . </eligible_direct_containers> |
The number of containers for the eligible direct items. |
Eligible Residue Selections - Number | 4 | Integer |
<eligible_residue_number> . </eligible_residue_number> |
The number of eligible residue selections Please leave it as blank (no longer used). |
Eligible Residue Selections - Items | 10 | Integer |
<eligible_residue_items> . </eligible_residue_items> |
The number of eligible residue items Please leave it as blank (no longer used). |
Eligible Residue Selections - % Match | 5 | Floating points (2 decimals) |
<eligible_residue_percent_match> . </eligible_residue_percent_match> |
The number of eligible residue items expressed in percentages Please leave it as blank (no longer used). |
Eligible Residue Selections - Containers | 10 | Integer |
<eligible_residue_containers> . </eligible_residue_containers> |
The number of containers for the eligible residue items Please leave it as blank (no longer used). |
Total Selections - Number | 4 | Integer |
<eligible_total_number> . </eligible_total_number> |
The total number of eligible selections. |
Total Selections - Items | 10 | Integer |
<eligible_total_items> . </eligible_total_items> |
The total number of eligible items. |
Total Selections - % Match | 5 | Floating points (2 decimals) |
<eligible_total_percent_match> . </eligible_total_percent_match> |
The total number of eligible items expressed in percentages. |
Total Selections - Containers | 10 | Integer |
<eligible_total_containers> . </eligible_total_containers> |
The total number of containers for the eligible items. |
View an example Standard XML file (Combined Computer Planning Report and Line Listing) (9KB).
Field | Size | Type | XML Element Name | Description / Example |
---|---|---|---|---|
Standard Selection Code | 5 | Integer |
<selection_code> . </selection_code> |
3 or 5 digits SSCs. |
Selection Name | 50 | Alphanumeric |
<selection_name> . </selection_name> |
Selection descriptions. |
Total Items | 10 | Integer |
<total_items> . </total_items> |
Total number of items for each selection. |
Total Containers | 10 | Integer |
<total_containers> . </total_containers> |
Total number of container for each selection. |
Cumulative Items | 10 | Integer |
<cum_items> . </cum_items> |
Cumulative total number of items. |
Cumulative Containers | 10 | Integer |
<cum_containers> . </cum_containers> |
Cumulative total number of containers. |
View an example Enhanced XML file (Combined Computer Planning Report and Line Listing) (9KB).
Field | Size | Type | XML Element Name | Description / Example |
---|---|---|---|---|
Standard Selection Code | 5 | Integer |
<selection_code> . </selection_code> |
3 or 5 digits SSCs . |
Selection Name | 50 | Alphanumeric |
<selection_name> . </selection_name> |
Selection descriptions. |
Total Items | 10 | Integer |
<total_items> . </total_items> |
Total number of items for each selection. |
Total Containers | 10 | Integer |
<total_containers> . </total_containers> |
Total number of container for each selection. |
Cumulative Items | 10 | Integer |
<cum_items> . </cum_items> |
Cumulative total number of items. |
Cumulative Containers | 10 | Integer |
<cum_containers> . </cum_containers> |
Cumulative total number of containers. |
Items 1-100g | 10 | Integer |
<items100> . </items100> |
Total number of items between 1-100g for each selection. |
Actual Weight 1-100g | 10 | Integer |
<actual_weight100> . </actual_weight100> |
Total actual weight between 1-100g for each selection. |
Assumed Weight 1-100g | 10 | Integer |
<assumed_weight100> . </assumed_weight100> |
Total assumed weight between 1-100g for each selection. |
Items 101-250g | 10 | Integer |
<items250> . </items250> |
Total number of items between 101-205g for each selection. |
Actual Weight 101-250g | 10 | Integer |
<actual_weight250> . </actual_weight250> |
Total actual weight between 101-250g for each selection. |
Assumed Weight 101-250g | 10 | Integer |
<assumed_weight250> . </assumed_weight250> |
Total assumed weight between 101-250g for each selection. |
Items 251-750g / 251-2000g | 10 | Integer |
<items750_2000> . </items750_2000> |
Total number of items between 251-750g or 251-2000g for each selection. |
Actual/Assumed Weight 251-750g / 251-2000g | 10 | Integer |
<actual_assumed_weight750_2000> . </actual_assumed_weight750_2000> |
Total actual/assumed weight between 251-750g / 251-2000g for each selection. |
Total Actual Weight | 10 | Integer |
<total_actual_weight> . </total_actual_weight> |
The total actual weight for each selection. |
Total Assumed Weight | 10 | Integer |
<total_assumed_weight> . </total_assumed_weight> |
The total assumed weight for each selection. |