Objects/Tables/Table 9 Country/Region
Table 9 Country/Region in 20
Jonas Paprotka, Base Application 20.5.45456.61928, checked
- App
- Base Application
Fields, 12Keys, 4Procedures, 5Events, 1
Versions171819202122232425262728latest
Source29
Fields, 12
| Id | Name | Type | Obsolete |
|---|
| 1 | Code | Code[10] | - |
| 2 | Name | Text[50] | - |
| 4 | ISO Code | Code[2] | - |
| 5 | ISO Numeric Code | Code[3] | - |
| 6 | EU Country/Region Code | Code[10] | - |
| 7 | Intrastat Code | Code[10] | - |
| 8 | Address Format | Enum Country/Region Address Format | - |
| 9 | Contact Address Format | Option | - |
| 10 | VAT Scheme | Code[10] | - |
| 11 | Last Modified Date Time | DateTime | - |
| 12 | County Name | Text[30] | - |
| 8000 | Id | Guid | Pending 15.0 |
| This functionality will be replaced by the systemID field |
Keys, 4
| Name | Fields | Obsolete |
|---|
| Key1, clustered | Code | - |
| Key2 | EU Country/Region Code | - |
| Key3 | Intrastat Code | - |
| Key4 | Name | - |
Procedures, 5
| Name | Parameters | Returns | Access | Obsolete |
|---|
| IsEUCountry | (Code[10]) | Boolean | public | - |
| GetNameInCurrentLanguage | () | Text[50] | public | - |
| CreateAddressFormat | (Code[10], Integer, Integer) | Integer | public | - |
| CreateAddressFormatLine | (Code[10], Integer, Integer, Integer) | | public | - |
| InitAddressFormat | () | | public | - |
Events, 1
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnBeforeInitAddressFormat | (var Record Country/Region, var Boolean) | - |