Table ABIHIERA
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
ABIHIERA | AHH | Hierarchies | Supervisor | ABI |
Key | Description | Duplicates | Activity code |
---|---|---|---|
AHH0 | COD | No | |
AHH1 | ABM+COD | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ABM | Datamart | ABM | [ABM]ABM0=[AHH]ABM | Block | ||||
ACV | Activity code | ACV | [ACV]CODACT=[AHH]ACV | Block | ||||
AUUID | Single identifier | AUUID | ||||||
COD | Code | AHH | [AHH]AHH0=[AHH]COD | Delete | ||||
CODABF | Fact table | 15 | ABF | [ABF]ABF0=[AHH]CODABF | Block | |||
CODDIM1 | Dimension | 15 | ABI | [ABI]ABI0=[AHH]CODDIM1 | Block | |||
CODDIM2 | Dimension | 15 | ABI | [ABI]ABI0=[AHH]CODDIM2 | Block | |||
CODDIM3 | Dimension | 15 | ABI | [ABI]ABI0=[AHH]CODDIM3 | Block | |||
CODDIM4 | Dimension | 15 | ABI | [ABI]ABI0=[AHH]CODDIM4 | Block | |||
CODDIM5 | Dimension | 15 | ABI | [ABI]ABI0=[AHH]CODDIM5 | Block | |||
CODDIM6 | Dimension | 15 | ABI | [ABI]ABI0=[AHH]CODDIM6 | Block | |||
CODDIM7 | Dimension | 15 | ABI | [ABI]ABI0=[AHH]CODDIM7 | Block | |||
CODDIM8 | Dimension | 15 | ABI | [ABI]ABI0=[AHH]CODDIM8 | Block | |||
CODDIM9 | Dimension | 15 | ABI | [ABI]ABI0=[AHH]CODDIM9 | Block | |||
CODFLD | Field code | 15 | AVA | |||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | AUS | [AUS]CODUSR=[AHH]CREUSR | Other | ||||
DES | Description | ATX | ||||||
FLDDIM1 | Field code | 15 | AVA | |||||
FLDDIM2 | Field code | 15 | AVA | |||||
FLDDIM3 | Field code | 15 | AVA | |||||
FLDDIM4 | Field code | 15 | AVA | |||||
FLDDIM5 | Field code | 15 | AVA | |||||
FLDDIM6 | Field code | 15 | AVA | |||||
FLDDIM7 | Field code | 15 | AVA | |||||
FLDDIM8 | Field code | 15 | AVA | |||||
FLDDIM9 | Field code | 15 | AVA | |||||
INTEVAL | Evaluated title | A | 60 | |||||
MODULE | Module | M | 15 | 14 | ||||
NBAHH | Number | C | 4 | |||||
NIVEAU | Level | C | 4 | |||||
TYPOPT | Option | 15 | A | 15 | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | AUS | [AUS]CODUSR=[AHH]UPDUSR | Other |