CNTRY
From ICISWiki
CNTRY Table Design v5.6
| Field Name | Description | Data Type | Field Size |
| CNTRYID | LOCID of the country location entry in the LOCATION table | (cur.val. is AutoNumber) Number | Long Integer |
| ISONUM | | Number | Long Integer |
| ISOTWO | | Text | 2 |
| ISOTHREE | | Text | 3 |
| FAOTHREE | | Text | 3 |
| FIPS | | Text | 2 |
| WB | | Text | 3 |
| ISOFULL | | Text | 50 |
| ISOABBR | | Text | 25 |
| CONT | | Text | 10 |
| SCNTRY | | Number | Long Integer |
| ECNTRY | | Number | Long Integer |
| CCHANGE | | Number | Long Integer |
Legend:
| (gray cell) | Already existing field/entry |
| (yellow cell) | New field/entry to be added |
| (gold cell) | Replace existing entry with this new code/size |

