Table TMPCPTDTA
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TMPCPTDTA | TCD | Accounting interface -data | Fixed Assets |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TCD0 | TRTNUM+PCENUM+SEQNUM+DSP+CCE | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AASBUS | Activity | 2 | ADI | [ADI]CODE=410;AASBUS | Other | |||
| AASTYP | Type | M | 15 | 3151 | ||||
| ACCCOD | Accounting code | 2 | CAC | [CAC]CAC0=TYP;ACCCOD;[V]GSUPCLE | Other | |||
| AGRKEY | Aggregation level | A | 80 | |||||
| ALPHA | Alphanumeric | 4 | A | 20 | ||||
| AMT | Amounts | 20 | DCB | 11.2 | ||||
| AUUID | Single identifier | AUUID | ||||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Other | ANA | |||
| CCED | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Other | ANA | |||
| CPTKEY | Key | 10 | A | 20 | ||||
| CPTREF | Accounting ledger | M | 30 | 2644 | ||||
| CPTSTA | Result | L | 8 | |||||
| CPY | Company | CPY | [CPY]CPY0=[TCD]CPY | Other | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[TCD]CREUSR | Other | ||||
| CUR | Currency | 2 | CUR | [TCU]TCU0=[TCD]CUR | Other | |||
| DAT | Date | 2 | D | |||||
| DIE | Dimension type | DIE | [DIE]DIE0=[TCD]DIE | Other | ANA | |||
| DSP | Distribution | DSP | [DSP]DSP0=DSP;1 | Other | ||||
| DSPD | New allocation | DSP | [DSP]DSP0=DSPD;1 | Other | ||||
| ETRNAT | Recpt nature | M | 15 | 3157 | ||||
| EVTPRINC | Main event | M | 4 | 1 | ||||
| FCY | Site | FCY | [FCY]FCY0=[TCD]FCY | Other | ||||
| GAC | Account | 4 | GAC | [GAC]GAC0="";GAC | Other | |||
| GACACN | CoA nature | 2 | M | 15 | 2628 | |||
| GRASTA | Status | M | 1 | 3225 | GRT | |||
| GRATYP | Subsidy type | M | 25 | 3181 | GRT | |||
| IASACC | IFRS allocation | 2 | GAC | [GAC]GAC0="";IASACC | Other | IAS | ||
| IASACN | IFRS nature | 2 | M | 15 | 2628 | IAS | ||
| IASCGU | UGT | 2 | ADI | [ADI]CODE=413;IASCGU | Other | IAS | ||
| LEASTA | Status | M | 15 | 3227 | LEA | |||
| LEATYP | Contract type | M | 15 | 3224 | LEA | |||
| LEG | Legislation | ADI | [ADI]CODE=909;LEG | RTZ | ||||
| LIN | Line number | C | 3 | |||||
| OWNTYP | Holding type | M | 15 | 3171 | ||||
| PCENUM | Document no. | L | 8 | |||||
| REF | Reference | VC9 | ||||||
| SEQNUM | Sequence number | L | 8 | |||||
| SNS | Sign | C | 2 | |||||
| TRTNUM | Processing number | L | 8 | |||||
| TYP | Accounting code type | M | 15 | 602 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[TCD]UPDUSR | Other |