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