Table COMPANY

Table Abbreviation Description Module Activity code
COMPANY CPY Company Supervisor  

Key Description Duplicates Activity code
CPY0 CPY No  
CPY1 LEG+CPY Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ACCCOD Accounting code   A 10        
ACCCUR Accounting currency   CUR     [TCU]TCU0=[CPY]ACCCUR Block  
AGTPCP Collection agent   M 4 1      
AUUID Single identifier   AUUID          
BIDNUM Bank ID number   BID          
BPAADD Default address   ADR          
CCE Analytical dimension   A 10        
CNTNAM Contact   A 10        
CPY Company   CPY     [CPY]CPY0=[CPY]CPY Delete  
CPYLEGFLG Legal company   M 4 1      
CPYLOG Legal form   A 10        
CPYNAM Company name   NAM          
CPYSHO Short description   SHO          
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   AUS     [AUS]CODUSR=[CPY]CREUSR Other  
CRN Company tax ID number   CRN          
CRY Country   CRY     [TCY]TCY0=[CPY]CRY Block  
DIVCOD Division code   A 10       KUS
EECNUM Tax number   EEC          
EORINUM EORI number   A 35       EORI
GRUCOD Consolidation   A 10        
KACT Cy's pr. activity   A 10       KPO
LEG Legislation   ADI     [ADI]CODE=909;LEG Block  
MAIFCY Main site   FCY     [FCY]FCY0=[CPY]MAIFCY Block  
NAF SIC code   NAF          
NID Identification no.   NID          
NUMADD Additional number   C 3        
RGCAMT Registered capital   DCB 11.4       EUR
RGCCUR Capital currency   CUR     [TCU]TCU0=[CPY]RGCCUR Block EUR
RTZFLG Retention   M 4 1      
SCT1 Sector 1   ADI     [ADI]CODE=360;SCT1 Block  
SCT2 Sector 2   ADI     [ADI]CODE=361;SCT2 Block  
STAFED Federal state   ADI     [ADI]CODE=80;STAFED Block  
STRPER First fiscal year   D          
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   AUS     [AUS]CODUSR=[CPY]UPDUSR Other  
VACCPY Tax rule   ADI     [ADI]CODE=1;VACCPY Block