|
Source
Column |
Source
Table Name |
Target
Column Name |
Target Table
Name |
Target
Schema |
TrueSource |
1 |
ACCOUNTING_DATE |
STG_FIF_GL_DATA |
ACCOUNTING_DATE |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
2 |
ACCT_SEGMENT1 |
STG_FIF_GL_DATA |
SEGMENT1 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
3 |
ACCT_SEGMENT10 |
STG_FIF_GL_DATA |
SEGMENT10 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
4 |
ACCT_SEGMENT11 |
STG_FIF_GL_DATA |
SEGMENT11 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
5 |
ACCT_SEGMENT12 |
STG_FIF_GL_DATA |
SEGMENT12 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
6 |
ACCT_SEGMENT13 |
STG_FIF_GL_DATA |
SEGMENT13 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
7 |
ACCT_SEGMENT14 |
STG_FIF_GL_DATA |
SEGMENT14 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
8 |
ACCT_SEGMENT15 |
STG_FIF_GL_DATA |
SEGMENT15 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
9 |
ACCT_SEGMENT16 |
STG_FIF_GL_DATA |
SEGMENT16 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
10 |
ACCT_SEGMENT17 |
STG_FIF_GL_DATA |
SEGMENT17 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
11 |
ACCT_SEGMENT18 |
STG_FIF_GL_DATA |
SEGMENT18 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
12 |
ACCT_SEGMENT19 |
STG_FIF_GL_DATA |
SEGMENT19 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
13 |
ACCT_SEGMENT2 |
STG_FIF_GL_DATA |
SEGMENT2 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
14 |
ACCT_SEGMENT20 |
STG_FIF_GL_DATA |
SEGMENT20 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
15 |
ACCT_SEGMENT3 |
STG_FIF_GL_DATA |
SEGMENT3 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
16 |
ACCT_SEGMENT4 |
STG_FIF_GL_DATA |
SEGMENT4 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
17 |
ACCT_SEGMENT5 |
STG_FIF_GL_DATA |
SEGMENT5 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
18 |
ACCT_SEGMENT6 |
STG_FIF_GL_DATA |
SEGMENT6 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
19 |
ACCT_SEGMENT7 |
STG_FIF_GL_DATA |
SEGMENT7 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
20 |
ACCT_SEGMENT8 |
STG_FIF_GL_DATA |
SEGMENT8 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
21 |
ACCT_SEGMENT9 |
STG_FIF_GL_DATA |
SEGMENT9 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
22 |
ACTUAL_FLAG |
STG_FIF_GL_DATA |
ACTUAL_FLAG |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
23 |
ATTRIBUTE1 |
STG_FIF_GL_DATA |
ATTRIBUTE1 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
24 |
ATTRIBUTE2 |
STG_FIF_GL_DATA |
ATTRIBUTE2 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
25 |
ATTRIBUTE3 |
STG_FIF_GL_DATA |
ATTRIBUTE3 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
26 |
ATTRIBUTE4 |
STG_FIF_GL_DATA |
ATTRIBUTE4 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
27 |
ATTRIBUTE5 |
STG_FIF_GL_DATA |
ATTRIBUTE5 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
28 |
ATTRIBUTE6 |
STG_FIF_GL_DATA |
ATTRIBUTE6 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
29 |
CODE_COMBINATION_ID |
STG_FIF_GL_DATA |
CODE_COMBINATION_ID |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
30 |
CREATED_BY |
STG_FIF_GL_DATA |
CREATED_BY |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
31 |
CURRENCY_CONVERSION_DATE |
STG_FIF_GL_DATA |
CURRENCY_CONVERSION_DATE |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
32 |
DATE_CREATED |
STG_FIF_GL_DATA |
DATE_CREATED |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
33 |
ENTERED_CR_AMOUNT |
STG_FIF_GL_DATA |
ENTERED_CR |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
34 |
ENTERED_DR_AMOUNT |
STG_FIF_GL_DATA |
ENTERED_DR |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
35 |
EXT_SYSTEM_ID |
RFI_XREF_DVM |
CURRENCY_CODE |
GL_INTERFACE |
EBIZ_GL |
MiddlelayerRefTable-ODI * |
36 |
EXT_SYSTEM_ID |
RFI_XREF_DVM |
LEDGER_ID |
GL_INTERFACE |
EBIZ_GL |
MiddlelayerRefTable-ODI * |
37 |
EXT_SYSTEM_ID |
RFI_XREF_DVM |
SET_OF_BOOKS_ID |
GL_INTERFACE |
EBIZ_GL |
MiddlelayerRefTable-ODI * |
38 |
PERIOD_NAME |
STG_FIF_GL_DATA |
PERIOD_NAME |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
39 |
PGM_NAME |
STG_FIF_GL_DATA |
REFERENCE10 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
40 |
REFERENCE1 |
STG_FIF_GL_DATA |
REFERENCE21 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
41 |
REFERENCE2 |
STG_FIF_GL_DATA |
REFERENCE22 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
42 |
REFERENCE3 |
STG_FIF_GL_DATA |
REFERENCE23 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
43 |
REFERENCE4 |
STG_FIF_GL_DATA |
REFERENCE24 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
44 |
REFERENCE5 |
STG_FIF_GL_DATA |
REFERENCE25 |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
45 |
USER_JE_CATEGORY_NAME |
STG_FIF_GL_DATA |
USER_JE_CATEGORY_NAME |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
46 |
USER_JE_SOURCE_NAME |
STG_FIF_GL_DATA |
USER_JE_SOURCE_NAME |
GL_INTERFACE |
EBIZ_GL |
SourceBusinessTable |
|
|
|
|
|
|
|
|
************
LEGEND*************** |
|
|
|
|
|
* Indicates Source is Middlelayer. |
|
|
|
|
|
++ Indicates Expression i.e., two or more source
columns are used. |
|
|
|
|
|