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 Bank detail window   FEN     [AWI]AWI0=[TCY]BIDCLS Block  
BIDCRY Print format   A 30        
BIDCTL Bank control   M 4 1      
BIDFMT Bank acct. no. fmt.   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 mandatory   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   M 4 1     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       FHRPA
SOCNUMFLG2 SS no. format 2   C 4       FHRPA
SOCNUMFMT SS no. format   A 10       FHRPA
SOCNUMFMT2 SS no. format 2   A 10       FHRPA
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