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 |