Index | Column Heading | Required | Unique | Type | Value Constraints | Title/Description |
---|---|---|---|---|---|---|
1 |
ID
|
Yes | No | String |
Minimum Length: 38 Maximum Length: 38 Pattern: \{[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}\} |
Unique transaction code |
2 |
Price
|
Yes | No | Non-Negative Integer | Price Paid | |
3 |
Date of Transfer
|
Yes | No |
DateTime
%Y-%m-%d %H:%M
|
Data of transfer | |
4 |
Postcode
|
Yes | No | String |
Pattern: [A-Z]{1,2}[0-9][0-9A-Z]? ?[0-9][A-Z]{2} |
Postcode for the property |
5 |
Property Type
|
Yes | No | String |
Pattern: (D|S|T|F) |
Type of property (D, S, T, F) |
6 |
Old/New
|
Yes | No | String |
Pattern: (Y|N) |
Old or new property |
7 |
Duration
|
Yes | No | String |
Pattern: (F|L) |
Duration of transfer |
8 |
PAON
|
Yes | No | String | ||
9 |
SAON
|
Yes | No | String | ||
10 |
Street
|
Yes | No | String | ||
11 |
Locality
|
Yes | No | String | ||
12 |
Town/City
|
Yes | No | String | ||
13 |
Local Authority
|
Yes | No | String | ||
14 |
County
|
Yes | No | String | ||
15 |
Record Status
|
Yes | No | String |
Pattern: (A|C|D) |