Table DECAT
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| DECAT | DLA | WI declaration | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| DLA1 | DAT+REFNUM+CTRNUM | No | |
| DLA0 | REFNUM+DAT+CTRNUM | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCCRN | Site tax ID no. | CRT | ||||||
| ACCPLA | Accident location | M | 15 | 563 | ||||
| ACCTIM | Accident circumstances | M | 15 | 564 | ||||
| ACCTYP | Accident type | M | 15 | 389 | ||||
| ADD1 | Address | ADL | ||||||
| ADD2 | Address | ADL | ||||||
| ADD3 | Address | ADL | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BPRADD | Business partner address | A | 120 | |||||
| BPRNAM | BP name | A | 40 | |||||
| BPRNSS | Third-party insurance | A | 80 | |||||
| BPRWAC | Accident caused by a third party | M | 4 | 1 | ||||
| CIV | Title | M | 15 | 231 | ||||
| CODPOS | Postal code | POS | ||||||
| CODRSK | Risk code | A | 5 | |||||
| CPY | Company | CPY | [CPY]CPY0=[DLA]CPY | Block | ||||
| CPYADDLIG | Address | 3 | ADL | |||||
| CPYCRY | Country | CRY | [TCY]TCY0=[DLA]CPYCRY | Block | ||||
| CPYCTY | City | CTY | ||||||
| CPYPOSCOD | Postal code | POS | ||||||
| CPYTEL | Telephone | TEL | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CRY | Country | CRY | [TCY]TCY0=[DLA]CRY | Block | ||||
| CTRNUM | Contract | CTR | ||||||
| CTTCNT | Reporting party | M | 15 | 307 | ||||
| CTTDAT | Date of the report | D | ||||||
| CTTHOU | Time of the report | HM | ||||||
| CTTINS | Registered | M | 4 | 1 | ||||
| CTTTYP | Report | M | 15 | 305 | ||||
| CTY | City | CTY | ||||||
| DAT | WI date | D | ||||||
| DATANC | Seniority date | D | ||||||
| DATBRN | Birth date | D | ||||||
| DATREF | Date | D | ||||||
| DECES | Death | M | 4 | 1 | ||||
| DTAWAC | WI consequences | M | 15 | 308 | ||||
| ETRDAT | Receipt date | DTR | ||||||
| FCY | Site | FCY | [FCY]FCY0=[DLA]FCY | Block | ||||
| FCYADDLIG | Address | 3 | ADL | |||||
| FCYCRN | Site tax ID no. | CRT | ||||||
| FCYCRY | Country | CRY | [TCY]TCY0=[DLA]FCYCRY | Block | ||||
| FCYCTY | City | CTY | ||||||
| FCYPOSCOD | Postal code | POS | ||||||
| FCYRPB | Supervisor | A | 40 | |||||
| FCYRPBFNC | Function | M | 15 | 233 | ||||
| FCYRPBFNC2 | Other | A | 30 | |||||
| FCYTEL | Telephone | TEL | ||||||
| FLGVIC | Other victims | M | 4 | 1 | ||||
| HEAADDLIG | Address | 2 | ADL | |||||
| HEAPOSCOD | Postal code | POS | ||||||
| HEASVCNAM | Department name | A | 80 | |||||
| HOU | WI time | HM | ||||||
| HOUEND | End time | 2 | HM | |||||
| HOUSTR | Start time | 2 | HM | |||||
| JOB | Job | A | 30 | |||||
| NAM | Name | A | 40 | |||||
| NTTTYP | Nationality | M | 15 | 390 | ||||
| NUMSSC | Social Security | SSE | ||||||
| OLDNAM | Birth name | A | 40 | |||||
| PLCREF | Location | A | 30 | |||||
| QLF | Qualification | A | 30 | |||||
| REFNUM | Employee ID | MAT | [ID]ID0=[DLA]REFNUM | Delete | ||||
| RGTDAT | Date | D | ||||||
| RGTNUM | Ledger number | A | 10 | |||||
| RPTFLG | Police report | M | 4 | 1 | ||||
| RPTNAM | Name | A | 40 | |||||
| SEX | Individual's gender | M | 15 | 314 | ||||
| SRN | Employee's first name | A | 40 | |||||
| TXT0 | Accident location | A | 120 | |||||
| TXT1 | Circumstances | 6 | A | 120 | ||||
| TXT2 | Location of the injuries | A | 120 | |||||
| TXT3 | Nature of injuries | A | 120 | |||||
| TXT4 | Location | A | 120 | |||||
| TXT5 | Accident nature | 2 | A | 120 | ||||
| TXT6 | Source object | 2 | A | 120 | ||||
| TXT7 | Reservations | 2 | A | 120 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 | |||||
| WITNES | Notified person | M | 4 | 1 | ||||
| WTSADD | Address | 2 | A | 120 | ||||
| WTSNAM | Witness name | A | 80 | |||||
| WTSPOSCOD | Postal code | POS |