FCT_CFO_TRANSFER_PRICING_INSIGHT_20210701

Database

INSNZP01_R12

Schema

R12PADM

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PPATTRIBUTION_MEASURES_PRICING CHARACTER VARYING(21) 21
2 PPATTRIBUTION_MEASURES CHARACTER VARYING(15) 15
3 SOURCE_DEPARTMENT CHARACTER VARYING(4) 4
4 TARGET_DEPARTMENT CHARACTER VARYING(4) 4
5 ACCOUNT INTEGER 4
6 CURRENCY CHARACTER VARYING(20) 20
7 PERIODDETAIL CHARACTER VARYING(200) 200
8 CAL_YEAR_MONTH INTEGER 4
9 CAL_YEAR CHARACTER VARYING(4) 4
10 CAL_MONTH CHARACTER VARYING(2) 2
11 FIN_YEAR CHARACTER VARYING(4) 4
12 FIN_MONTH CHARACTER VARYING(2) 2
13 MTD_ACTUAL DOUBLE PRECISION 8
14 MTD_BUDGET DOUBLE PRECISION 8
15 MTD_FORECAST DOUBLE PRECISION 8
16 VAR_ACTUALVSBUD DOUBLE PRECISION 8
17 VAR_ACTUALVSFORECAST DOUBLE PRECISION 8
18 YTD_ACTUAL DOUBLE PRECISION 8
19 YTD_BUDGET DOUBLE PRECISION 8
20 YTD_FORECAST DOUBLE PRECISION 8
21 FY_ACTUAL DOUBLE PRECISION 8
22 FY_BUDGET DOUBLE PRECISION 8
23 FY_FORECAST DOUBLE PRECISION 8
24 PCP_MTD_ACTUAL DOUBLE PRECISION 8
25 PCP_MTD_BUDGET DOUBLE PRECISION 8
26 PCP_MTD_FORECAST DOUBLE PRECISION 8
27 S_LEVEL_01_CODE CHARACTER VARYING(150) 150
28 S_LEVEL_01_NAME CHARACTER VARYING(240) 240
29 S_LEVEL_02_CODE CHARACTER VARYING(150) 150
30 S_LEVEL_02_NAME CHARACTER VARYING(240) 240
31 S_LEVEL_03_CODE CHARACTER VARYING(150) 150
32 S_LEVEL_03_NAME CHARACTER VARYING(240) 240
33 S_LEVEL_04_CODE CHARACTER VARYING(150) 150
34 S_LEVEL_04_NAME CHARACTER VARYING(240) 240
35 S_LEVEL_05_CODE CHARACTER VARYING(150) 150
36 S_LEVEL_05_NAME CHARACTER VARYING(240) 240
37 S_LEVEL_06_CODE CHARACTER VARYING(150) 150
38 S_LEVEL_06_NAME CHARACTER VARYING(240) 240
39 S_LEVEL_07_CODE CHARACTER VARYING(150) 150
40 S_LEVEL_07_NAME CHARACTER VARYING(240) 240
41 S_LEVEL_08_CODE CHARACTER VARYING(150) 150
42 S_LEVEL_08_NAME CHARACTER VARYING(240) 240
43 S_LEVEL_09_CODE CHARACTER VARYING(150) 150
44 S_LEVEL_09_NAME CHARACTER VARYING(240) 240
45 S_LEVEL_10_CODE CHARACTER VARYING(150) 150
46 S_LEVEL_10_NAME CHARACTER VARYING(240) 240
47 T_LEVEL_01_CODE CHARACTER VARYING(150) 150
48 T_LEVEL_01_NAME CHARACTER VARYING(240) 240
49 T_LEVEL_02_CODE CHARACTER VARYING(150) 150
50 T_LEVEL_02_NAME CHARACTER VARYING(240) 240
51 T_LEVEL_03_CODE CHARACTER VARYING(150) 150
52 T_LEVEL_03_NAME CHARACTER VARYING(240) 240
53 T_LEVEL_04_CODE CHARACTER VARYING(150) 150
54 T_LEVEL_04_NAME CHARACTER VARYING(240) 240
55 T_LEVEL_05_CODE CHARACTER VARYING(150) 150
56 T_LEVEL_05_NAME CHARACTER VARYING(240) 240
57 T_LEVEL_06_CODE CHARACTER VARYING(150) 150
58 T_LEVEL_06_NAME CHARACTER VARYING(240) 240
59 T_LEVEL_07_CODE CHARACTER VARYING(150) 150
60 T_LEVEL_07_NAME CHARACTER VARYING(240) 240
61 T_LEVEL_08_CODE CHARACTER VARYING(150) 150
62 T_LEVEL_08_NAME CHARACTER VARYING(240) 240
63 T_LEVEL_09_CODE CHARACTER VARYING(150) 150
64 T_LEVEL_09_NAME CHARACTER VARYING(240) 240
65 T_LEVEL_10_CODE CHARACTER VARYING(150) 150
66 T_LEVEL_10_NAME CHARACTER VARYING(240) 240