Table TABCOUNTRY
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TABCOUNTRY | TCY | Country table | Supervisor |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TCY0 | CRY | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ADRCODFMT | Address format | A | 30 | |||||
| ADRNAM | Header address | 3 | A | 20 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BANLNG | Length of bank | C | 4 | |||||
| BIDCLS | Fenêtre données bancaires | FEN | [AWI]AWI0=[TCY]BIDCLS | Block | ||||
| BIDCRY | Print format | A | 30 | |||||
| BIDCTL | Bank control | M | 4 | 1 | ||||
| BIDFMT | Fmt N° cpte bancaire | A | 30 | |||||
| CINSEE | Federal ID code | A | 5 | |||||
| CONTINENT | Continent | ADI | [ADI]CODE=918;CONTINENT | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[TCY]CREUSR | Other | ||||
| CRNFMT | Company tax ID no. form | A | 30 | |||||
| CRNFMTFLG | Company tax ID no. form | M | 4 | 1 | ||||
| CRNOBL | Company tax ID mandatory | M | 4 | 1 | ||||
| CRTFMT | Site tax ID number format | A | 30 | |||||
| CRTFMTFLG | Site tax ID number format | M | 4 | 1 | ||||
| CRTOBL | Site tax ID no. mandator | M | 4 | 1 | ||||
| CRY | Country | CRY | [TCY]TCY0=[TCY]CRY | Delete | ||||
| CRYDES | Name | AXX | ||||||
| CRYVATNUM | Tax number | A | 3 | |||||
| CTLPRG | Control script | ADC | ||||||
| CTYCODFMT | City format | A | 30 | |||||
| CTYNUMFMT | City code format | A | 30 | |||||
| CTYUPP | Upper-case letters | M | 4 | 1 | ||||
| CUR | Currency | CUR | [TCU]TCU0=[TCY]CUR | Block | ||||
| EECCOD | Intrastat country code | A | 3 | |||||
| EECDAT | EU entry date | D | ||||||
| EECDATOUT | EU withdrawal date | D | ||||||
| EECFLG | EU member | M | 4 | 1 | ||||
| EECFMT | VAT format | A | 30 | |||||
| EECFMTFLG | VAT format | M | 4 | 1 | ||||
| EORIFLG | EORI identification | M | 4 | 1 | EORI | |||
| ETAT | Subdivision entry | M | 15 | 7831 | ||||
| ETATCTL | Subdivision control | M | 4 | 1 | ||||
| ETATFLG | Subdivision 1 | M | 4 | 1 | ||||
| ETATFLG2 | Subdivision 2 | M | 4 | 1 | ||||
| ETATFMT | Subdivision format | A | 30 | |||||
| ETATFMT2 | Subdivision format | A | 30 | |||||
| ETATNAM | Subdivision title | AX3 | ||||||
| ETATNAM2 | Subdivision title | AX3 | ||||||
| FLGDUE | Involved in DUE | M | 4 | 1 | ||||
| FLGSEPA | SEPA area | M | 10 | 1 | ||||
| FLIBAN | IBAN management | M | 4 | 1 | ||||
| GSPFLG | Generalized system of preferences | C | 4 | REX | ||||
| ISO | ISO-3166-1 alpha-2 | A | 2 | |||||
| ISOA3 | ISO-3166-1 alpha-3 | A | 3 | |||||
| ISONUM | ISO-3166-1 numeric | A | 3 | |||||
| LAN | Language | LAN | [TLA]TLA0=[TCY]LAN | Block | ||||
| MINZIP | Controlled length | C | 2 | |||||
| NAFFMT | SIC code format | A | 30 | |||||
| NAFFMTFLG | SIC code format | M | 4 | 1 | ||||
| NIDFMT | Unique number | A | 30 | |||||
| NIDFMTFLG | Ident format | M | 4 | 1 | ||||
| PABFMT | Domicile format | A | 30 | |||||
| POSCODCRY | Print format | A | 30 | |||||
| POSCODCTL | Postal code control | M | 4 | 1 | ||||
| POSCODFMT | Postal code format | A | 30 | |||||
| POSOBL | Mandatory postal code | M | 4 | 1 | ||||
| SOCNUMFLG1 | SS no. format | C | 4 | PYS | ||||
| SOCNUMFLG2 | SS no. 2 format | C | 4 | PYS | ||||
| SOCNUMFMT | SS no. format | A | 10 | PYS | ||||
| SOCNUMFMT2 | SS no. 2 format | A | 10 | PYS | ||||
| SUBDIVFMT | State format | A | 30 | |||||
| TELFMT | Phone number format | A | 30 | |||||
| TELREG | Control | A | 10 | |||||
| TELTCY | Control | A | 10 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[TCY]UPDUSR | Other |