Consolidation Properties Flashcards

master consolidation properties

1
Q

Consolidation properties on account

A

AERT - I

C_ACCOUNT
ACCTYPE
ELIMACC
RATETYPE
TYPELIM

O_ACCOUNT
IS_INPUT
special_SYS

R_ACCOUNT (avg, clo, 3)
RATETYPE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Category

A

FxOR - 11

FX_DIFFERENCE_ONLY
FX_SOURCE_CATEGORY

OPENING_CATEGORY/ CATEGORY_FOR_OPE
OPENING_PERIOD
OPENING_YEAR

OWN_CATEGORY
OWN_PERIOD
OWN_YEAR

RATE_CATEGORY
RATE_PERIOD
RATE_YEAR

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

DataSource

A

CDIO - 6
COPY_OPENING

DATASRC_TYPE
DATASRC_STAGE

IS_CONSOL
IS_CONVERTED

OPENING_DATASRC

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Entity

A
CEFxIO - 7
CONTROL_LEVEL
CTRL_CURRENCY_NOT_LC
CURRENCY
ELIM
FX_TYPE
INTCO
OWNER
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Group

A

CDEFGPS - 10

CONSO_TYPE
CURRENCY_TYPE
DATASRC_LEVEL
ENTITY
FIRST_CONS_DATE
GROUP_CURRENCY
PARENT_GROUP
STAGE_ONLY
STORE_ENTITY
STORE_GROUP_CURRENCY
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Intercompany

A

E - 1

Entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

ReportCurency

A

CR - 2
Currency Type
Reporting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

S Flow Subtable

A

DF-2
Dimlist
Flowtype

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Time

A

PYM-3
Period
Year
Monthnum

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

AERT-I

A
AERT - I  - 
C_ACCOUNT
ACCTYPE
ELIMACC
RATETYPE
TYPELIM

O_ACCOUNT
IS_INPUT
special_SYS

R_ACCOUNT (avg, clo, 3)
RATETYPE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

CFxOR

A

FxOR - 11 — CPY (Category, Period, Year)

FX_DIFFERENCE_ONLY
FX_SOURCE_CATEGORY
Opening_Category/CATEGORY_FOR_OPE
OPENING_PERIOD
OPENING_YEAR
OWN_CATEGORY
OWN_PERIOD
OWN_YEAR
RATE_CATEGORY
RATE_PERIOD
RATE_YEAR
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

CDIO

A

CDIO-6

COPY_OPENING
DATASRC_TYPE
DATASRC_STAGE
IS_CONSOL
IS_CONVERTED
OPENING_DATASRC
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

CDEFGPS

A

CDEFGPS -10

CONSO_TYPE
CURRENCY_TYPE
DATASRC_LEVEL
ENTITY
FIRST_CONS_DATE
GROUP_CURRENCY
PARENT_GROUP
STAGE_ONLY
STORE_ENTITY
STORE_GROUP_CURRENCY
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

InterCompany

A

E1 Entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

CR2

A

Currency Type
Reporting

currency dimension

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

DF2

A

DIM_LIST
FLOW_TYPE

subtable, flow dimension

17
Q

PYM3

A

PERIOD
YEAR
MONTHNUM

time dimension

18
Q
AERT - I
CFxOR - 11
CDIO - 6
CEFxIO -7
CDEFGPS - 10
E - 1
CR - 2
DF -2
PYM 3
A
ACCOUNT
CATEGORY 11
D 1
ENTITY 1
G -GROUP or SCOPE
I - intercompany
R - currency
S - FLOW or SUBTABLE
TIME