FCT_FIN_MASTER_ATTRIBUTIONS

Database

INSNZP01_R12

Schema

R12PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 TYPE CHARACTER VARYING(8) 8
2 CUBE CHARACTER VARYING(50) 50
3 LIVEVERSIONS CHARACTER VARYING(25) 25
4 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
5 PERIOD_NAME CHARACTER VARYING(8) 8
6 CURRENCY_CODE CHARACTER VARYING(20) 20
7 CATEGORY_CODE CHARACTER VARYING(3) 3
8 CHANNEL_CODE CHARACTER VARYING(5) 5
9 CLASS_CODE CHARACTER VARYING(2) 2
10 ENTITY_CODE CHARACTER VARYING(6) 6
11 INTERCOMPANY_CODE CHARACTER VARYING(6) 6
12 PRODUCT_CODE CHARACTER VARYING(6) 6
13 PROJECT_CODE CHARACTER VARYING(3) 3
14 SPARE_CODE CHARACTER VARYING(4) 4
15 STATE_CODE CHARACTER VARYING(1) 1
16 ACCOUNT_CODE CHARACTER VARYING(6) 6
17 COST_CENTRE_CODE CHARACTER VARYING(4) 4
18 SOURCE_COST_CENTRE_CODE CHARACTER VARYING(4) 4
19 TARGET_COST_CENTRE_CODE CHARACTER VARYING(4) 4
20 PPATTRIBUTION_MEASURES CHARACTER VARYING(15) 15
21 TM1_ACTUALS_VALUE DOUBLE PRECISION 8