Table CACCE
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| CACCE | CCE | Analytical dimension table | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| CCE0 | DIE+CCE | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACS | Access code | ACS | [ACS]ACS0=[CCE]ACS | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| AUZ | Restriction code | ADI | [ADI]CODE=322;AUZ | Block | ||||
| AXI | Dimension type | M | 15 | 601 | ||||
| BUD | Budgeted | M | 4 | 1 | ||||
| BUDTRK | Budget tracking | M | 4 | 1 | ||||
| CAT | Category | ADI | [ADI]CODE=301;CAT | Block | ||||
| CCE | Dimension | CCE | [CCE]CCE0=DIE;CCE | Delete | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation author | A | 5 | |||||
| DES | Title | DES | ||||||
| DESSHO | Short title | SHO | ||||||
| DESTRA | Title | AX3 | ||||||
| DIE | Dim type code | DIE | [DIE]DIE0=[CCE]DIE | Block | ||||
| ENAFLG | Active | M | 4 | 1 | ||||
| EXPNUM | Export number | L | 8 | |||||
| FCY | Company / site | CFY | ||||||
| FIYEND | Reset to zero | M | 4 | 1 | ||||
| FRW | Carry-forward | M | 4 | 1 | ||||
| IPT | Chargeable | M | 4 | 1 | ||||
| NBRUOM | Number of units | C | 4 | |||||
| QTY | Quantity | 20 | QTY | |||||
| QTYCNADSP | Calculated structure quantity | DCB | 9.2 | |||||
| QTYDSP | Analytical distribution | QTY | ||||||
| SCT1 | Sector 1 | A | 10 | IAS | ||||
| SCT2 | Sector 2 | A | 10 | IAS | ||||
| SHOTRA | Short title | AX1 | ||||||
| UOM | Non-financial unit | 20 | UOM | [TUN]TUN0=[CCE]UOM | Block | |||
| UOMNBR | Number of units | C | 4 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change author | A | 5 | |||||
| VLYEND | Valid to | D | ||||||
| VLYSTR | Valid from | D |