TM1_ACTUALS

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 CUBE CHARACTER VARYING(50) 50
2 LIVEVERSIONS CHARACTER VARYING(25) 25
3 PERIODDETAIL CHARACTER VARYING(8) 8
4 CURRENCY CHARACTER VARYING(20) 20
5 CATEGORIES CHARACTER VARYING(3) 3
6 CHANNEL CHARACTER VARYING(5) 5
7 CLASS CHARACTER VARYING(2) 2
8 ENTITY CHARACTER VARYING(6) 6
9 INTERCOMPANY CHARACTER VARYING(6) 6
10 PRODUCT CHARACTER VARYING(6) 6
11 PROJECT CHARACTER VARYING(3) 3
12 SPARE CHARACTER VARYING(4) 4
13 STATE CHARACTER VARYING(1) 1
14 ACCOUNT CHARACTER VARYING(6) 6
15 DEPARTMENT CHARACTER VARYING(4) 4
16 SOURCE_DEPARTMENT CHARACTER VARYING(4) 4
17 TARGET_DEPARTMENT CHARACTER VARYING(4) 4
18 PPATTRIBUTION_MEASURES CHARACTER VARYING(15) 15
19 TM1_ACTUALS_VALUE DOUBLE PRECISION 8
20 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
21 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
22 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
23 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8