CNTRY

From ICISWiki

Jump to: navigation, search

Back to TABLE CHANGES v5.6


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
Personal tools