| Individual Field Constraints | ||||||||
|---|---|---|---|---|---|---|---|---|
| Field name | Type Allowed | Min Allowed | Max Allowed | Sign Allowed | Nulls Allowed | Duplicates Allowed | Values Allowed | Regular Expressions |
| CompanyName | string | 3 | 150 | 0 | ||||
| CompanyNumber | string | 8 | 8 | 0 | no | |||
| RegAddress.CareOf | string | 1 | 65 | |||||
| RegAddress.POBox | string | 1 | 10 | |||||
| RegAddress.AddressLine1 | string | 1 | 101 | |||||
| RegAddress.AddressLine2 | string | 1 | 59 | |||||
| RegAddress.PostTown | string | 1 | 50 | |||||
| RegAddress.County | string | 1 | 42 | |||||
| RegAddress.Country | string | 2 | 32 | |||||
| RegAddress.PostCode | string | 1 | 15 | |||||
| CompanyCategory | string | 15 | 89 | 0 | ||||
| CompanyStatus | string | 6 | 48 | 0 | "ADMINISTRATION ORDER" "ADMINISTRATIVE RECEIVER" "Active" "Active - Proposal to Strike off" "In Administration" "In Administration/Administrative Receiver" "In Administration/Receiver Manager" "Liquidation" "Live but Receiver Manager on at least one charge" "RECEIVER MANAGER / ADMINISTRATIVE RECEIVER" "RECEIVERSHIP" "VOLUNTARY ARRANGEMENT / RECEIVER MANAGER" "Voluntary Arrangement" |
|||
| CountryOfOrigin | string | 1 | 32 | 0 | ||||
| DissolutionDate | real | |||||||
| IncorporationDate | string | 10 | 10 | 0 | ||||
| Accounts.AccountRefDay | real | 1.0 | 31.0 | positive | ||||
| Accounts.AccountRefMonth | real | 1.0 | 12.0 | positive | ||||
| Accounts.NextDueDate | string | 10 | 10 | |||||
| Accounts.LastMadeUpDate | string | 10 | 10 | |||||
| Accounts.AccountCategory | string | 4 | 27 | 0 | "ACCOUNTS TYPE NOT AVAILABLE" "AUDIT EXEMPTION SUBSIDIARY" "AUDITED ABRIDGED" "DORMANT" "FILING EXEMPTION SUBSIDIARY" "FULL" "GROUP" "INITIAL" "MEDIUM" "MICRO ENTITY" "NO ACCOUNTS FILED" "PARTIAL EXEMPTION" "SMALL" "TOTAL EXEMPTION FULL" "TOTAL EXEMPTION SMALL" "UNAUDITED ABRIDGED" |
|||
| Returns.NextDueDate | string | 10 | 10 | |||||
| Returns.LastMadeUpDate | string | 10 | 10 | |||||
| Mortgages.NumMortCharges | int | 0 | 6121 | non-negative | 0 | |||
| Mortgages.NumMortOutstanding | int | 0 | 6121 | non-negative | 0 | |||
| Mortgages.NumMortPartSatisfied | int | 0 | 10 | non-negative | 0 | |||
| Mortgages.NumMortSatisfied | int | 0 | 5720 | non-negative | 0 | |||
| SICCode.SicText_1 | string | 11 | 166 | 0 | ||||
| SICCode.SicText_2 | string | 11 | 166 | |||||
| SICCode.SicText_3 | string | 13 | 166 | |||||
| SICCode.SicText_4 | string | 15 | 166 | |||||
| LimitedPartnerships.NumGenPartners | int | 0 | 24 | non-negative | 0 | |||
| LimitedPartnerships.NumLimPartners | int | 0 | 622 | non-negative | 0 | |||
| URI | string | 47 | 47 | 0 | no | |||
| PreviousName_1.CONDATE | string | 10 | 10 | |||||
| PreviousName_1.CompanyName | string | 3 | 121 | |||||
| PreviousName_2.CONDATE | string | 10 | 10 | |||||
| PreviousName_2.CompanyName | string | 5 | 91 | |||||
| PreviousName_3.CONDATE | string | 10 | 10 | |||||
| PreviousName_3.CompanyName | string | 6 | 88 | |||||
| PreviousName_4.CONDATE | string | 10 | 10 | |||||
| PreviousName_4.CompanyName | string | 8 | 72 | no | ||||
| PreviousName_5.CONDATE | string | 10 | 10 | |||||
| PreviousName_5.CompanyName | string | 7 | 121 | no | ||||
| PreviousName_6.CONDATE | string | 10 | 10 | no | ||||
| PreviousName_6.CompanyName | string | 8 | 53 | no | ||||
| PreviousName_7.CONDATE | string | 10 | 10 | no | ||||
| PreviousName_7.CompanyName | string | 10 | 39 | no | ||||
| PreviousName_8.CONDATE | string | 10 | 10 | no | ||||
| PreviousName_8.CompanyName | string | 13 | 50 | no | ||||
| PreviousName_9.CONDATE | string | 10 | 10 | no | ||||
| PreviousName_9.CompanyName | string | 11 | 107 | no | ||||
| PreviousName_10.CONDATE | string | 10 | 10 | no | ||||
| PreviousName_10.CompanyName | string | 13 | 64 | no | ||||
| ConfStmtNextDueDate | string | 10 | 10 | |||||
| ConfStmtLastMadeUpDate | string | 10 | 10 | |||||