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   CAC     [CAC]CAC0=[CPY]ACCCOD BSRA  
ACCCUR Accounting currency   CUR     [TCU]TCU0=[CPY]ACCCUR Block  
ACM Account core model   GCM     [GCM]GCM0=[CPY]ACM Block  
AGREEMENT Agreement   A 100       KSP
AGTPCP Collection agent   C 4       KAG
AMTFIN Financed amount   MD1         KSP
ARACPYNAM Arabic name   A 250       FAEDC
AUSFINSRV Financial department   A 10       KAT
AUUID Single identifier   AUUID          
BDFECOCOD Economic reason   PBDECO     [PBDECO]PBDECO0=BDFECOCOD;LEG Block  
BDO Waste DB no.   BDO         KPL
BIDNUM Bank acct. number   BID          
BPAADD Default address   ADR          
CCE Analytical dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CNTNAM Contact   AIN     [AIN]AIN0=[CPY]CNTNAM Block  
COMMTYPE Communication type 9 M 20 2427     EFAT
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  
DACDIE Enter dimensions ascending   M 4 1     ANA
DCLDIRBALPAY Direct decl. site bal   M 4 1      
DIE Dimension type code   DIE     [DIE]DIE0=[CPY]DIE Block ANA
DIVCOD Division code   A 20       KUS
EECNUM Tax number   EEC          
ENDDAT End date 9 D         EFAT
EORINUM EORI number   A 35       EORI
FDRX3 X3 folder   A 10       PAI
FINPER End date   D         KSP
GERCODELMA5 ELMA5 sender ID 8 A 11       KDE
GERDEFVAL Default value 8 M 4 1     KDEAT
GEREECNUM Tax number 8 A 20       KDEAT
GERPTP Participant code   A 20       KDE
GERTAXCEN Tax center 8 BPR     [BPR]BPR0=[CPY]GERTAXCEN Block KDEAT
GERTAXIDT Tax identifier 8 A 20       KDEAT
GOSIREFNUM GOSI reference no.   A 30       FAEDC
GRUCOD Consolidation   A 10       CSL
IMPCPY Location   C 4       FPAY
INIPER Start date   D         KSP
KACT Cy's pr. activity   A 20       KPO
LEG Legislation   ADI     [ADI]CODE=909;LEG Block  
MAIFCY Main site   FCY     [FCY]FCY0=[CPY]MAIFCY Block  
MOLID MOL establishment ID   A 30       FAEDC
NAF SIC code   NAF          
NID Identification no.   NID          
NUMADD Additional number   C 3       KDE
OBYDIE Mandatory dimension type   M 4 1     ANA
ORICERFLG Self-certification of origin   M 4 1     REX
PLISTC Structure code   PRS     [PRS]PRS0=1;PLISTC Block  
PORAMTITMINV Simp inv itm   DCB 9.2       KPO
PORAMTSERINV Simp inv ser   DCB 9.2       KPO
PORCPYACT Company activity   CAEC     [CAEC]CAEC0=[CPY]PORCPYACT BSRA KPO
PORCPYACTDET Detailed activity   CAEC     [CAEC]CAEC0=[CPY]PORCPYACTDET BSRA KPO
PORCPYACTTYP Activity type   M 15 3646     KPO
PORCTFACN Certified expert   A 9       KPO
PORDCLPER Periodicity   M 30 2226     KPO
PORFINDPR Financial department   A 9       KPO
PORHQR Head office   M 15 3618     KPO
PORLRC Legal representative   A 9       KPO
PORRESFISCDA Invoicing company   CPY     [CPY]CPY0=[CPY]PORRESFISCDA Block KPO
PORSIMINVISS Simplified invoice   M 25 1     KPO
REXNUM REX number   A 30       REX
RGCAMT Registered capital   DCB 11.4       EUR
RGCCUR Capital currency   CUR     [TCU]TCU0=[CPY]RGCCUR Block EUR
RTZFLG Retained   M 4 1     WTHMG
SCINUM SEPA Creditor ID   A 35       SDD
SCT1 Sector 1   ADI     [ADI]CODE=10360;SCT1 Block IAS
SCT2 Sector 2   ADI     [ADI]CODE=10361;SCT2 Block IAS
SERVICEID Service ID   A 100       EINV
SFINUM Disc. invoicing element   SFI     [SFI]SFI0=[CPY]SFINUM Block LTA
SOLFIN Solution funding   A 100       KSP
SPABPCTSD Customer threshold   DCB 13.2       KSP
SPABPSTSD Supplier threshold   DCB 13.2       KSP
SPAYEATSD Yearly 347 threshold   DCB 13.2       KSP
SSTCPY Sage Sales Tax company   A 25       LTA
SSTTAXACT Activation   M 4 1     LTA
STAFED Federal state   ADI     [ADI]CODE=80;STAFED Block KDE
STRDAT Start date 9 D         EFAT
STRPER First fiscal year   D          
TAXAGCNAM Tax agency name   A 100       FAEDC
TAXAGCNUM Tax agency number   A 20       FAEDC
TAXAGNNAM Tax agent name   A 100       FAEDC
TAXAGNNUM Tax agent number   A 20       FAEDC
TRECPY TR customer ref   A 10       FTRH
TRECPY2 CD customer ref   A 10       FCQH
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   AUS     [AUS]CODUSR=[CPY]UPDUSR Other  
VACCPY Tax rule   A 10       KAG