Facts

BF_ADJUSTMENT

Properties

Property Value
Target Table BF_ADJUSTMENT
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Financial Transaction
Default Replication Group FT
Source System Driver Table CI_ADJ
Stage Table STG_BF_ADJUSTMENT
ODI Package BF_PKG_ADJUSTMENT
ETL View BF_ADJUSTMENT_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
FT_TYPE_FLGFinancial Transaction Type FT_TYPE_FLG
GL_DIV
ADJ_STATUS_DESCR
CAN_RSN_CDCancel Reason CAN_RSN_CD
CAN_RSN_DESCR
DST_IDDistribution Code DST_ID
GL_ACCOUNT GL_ACCOUNT
ADJ_CCY
ADJ_AMTCurrent Amount ADJ_AMT
DIV_ADJ_CCY
DIV_ADJ_AMT
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
EXCH_RATE Exchange Rate H_RATE
GL_SEQ_NBRSequence GL_SEQ_NBR
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
CORP_CCY
CORP_ADJ_AMT
TRANS_TYPE
ORIG_ADJ_AMTOriginal Adjustment Amount ORIG_ADJ_AMT
ORIG_ADJ_CCY_CDOriginal Adjustment Currency Code ORIG_ADJ_CCY_CD
BALANCED_DT
BALANCED_ENTITY
SRC_SA_ID Natural Key
SRC_ADJ_ID Natural Key
SRC_FT_ID Natural Key
SRC_BILL_ID Natural Key
SRC_XFER_ADJ_ID Natural Key
SRC_BEHALF_SA_ID Natural Key
SRC_BSEG_ID Natural Key
ACCT_FK Foreign Key
CUST_FK Foreign Key
SA_TYPE_FK Foreign Key
DIV_FK Foreign Key
ACCT_DT_FK Foreign Key
ACCT_MON_FK Foreign Key
CAL_FK Foreign Key
ARS_DT_FK Foreign Key
FREEZE_DT_FK Foreign Key
ARS_MON_FK Foreign Key
FREEZE_MON_FK Foreign Key
FISCAL_MONTH_FK Foreign Key
ADJ_TYPE_FK Foreign Key
UDD_ADJ1_FK Foreign Key
UDD_ADJ2_FK Foreign Key
UDD_ADJ3_FK Foreign Key
UDD_ADJ4_FK Foreign Key
UDD_ADJ5_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
FACT_CNT Fact count 1
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
ILM_DTM Information Lifecycle Management Date/Time

BF_BILL

Properties

Property Value
Target Table BF_BILL
Table Type Fact
Fact Type Regular
Character Flag
Subject Area BILL
Default Replication Group BL
Source System Driver Table
Stage Table STG_BF_BILL
ODI Package BF_PKG_BILL
ETL View BF_BILL_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
FT_TYPE_FLGFinancial Transaction Type FT_TYPE_FLG
GL_DIV
BSEG_STATUS_DESCR
CAN_RSN_CDCancel Reason CAN_RSN_CD
CAN_RSN_DESCR
INT_QTY
BILLED_QTY
BLENDED_RATE
CALC_CCY
CALC_AMTCalculated Amount CALC_AMT
DIV_CALC_CCY
DIV_CALC_AMT
RESIDUAL_AMT
DIV_RESIDUAL_AMT
DST_AMT1
DIV_DST_AMT1
DST_ID1Distribution Code 1 DST_ID1
DST_GL1
DST_AMT2
DIV_DST_AMT2
DST_ID2Distribution Code 2 DST_ID2
DST_GL2
DST_AMT3
DIV_DST_AMT3
DST_ID3Distribution Code 3 DST_ID3
DST_GL3
DST_AMT4
DIV_DST_AMT4
DST_ID4Distribution Code 4 DST_ID4
DST_GL4
DST_AMT5
DIV_DST_AMT5
DST_ID5Distribution Code 5 DST_ID5
DST_GL5
EXCHRATEExchange Rate EXCHRATE
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
TAX_AMT
DIV_TAX_AMT
REVENUE_AMT
DIV_REVENUE_AMT
AVL_SQI_CD1
AVL_BILL_SQ1
AVL_SQI_CD01_DESCR
AVL_SQI_CD2
AVL_BILL_SQ2
AVL_SQI_CD02_DESCR
AVL_SQI_CD3
AVL_BILL_SQ3
AVL_SQI_CD03_DESCR
AVL_SQI_CD4
AVL_BILL_SQ4
AVL_SQI_CD04_DESCR
AVL_SQI_CD5
AVL_BILL_SQ5
AVL_SQI_CD05_DESCR
AVL_SQI_CD6
AVL_BILL_SQ6
AVL_SQI_CD06_DESCR
AVL_SQI_CD7
AVL_BILL_SQ7
AVL_SQI_CD07_DESCR
AVL_SQI_CD8
AVL_BILL_SQ8
AVL_SQI_CD08_DESCR
AVL_SQI_CD9
AVL_BILL_SQ9
AVL_SQI_CD09_DESCR
AVL_SQI_CD10
AVL_BILL_SQ10
AVL_SQI_CD10_DESCR
AVL_SQI_CD11
AVL_BILL_SQ11
AVL_SQI_CD11_DESCR
AVL_SQI_CD12
AVL_BILL_SQ12
AVL_SQI_CD12_DESCR
AVL_SQI_CD13
AVL_BILL_SQ13
AVL_SQI_CD13_DESCR
AVL_SQI_CD14
AVL_BILL_SQ14
AVL_SQI_CD14_DESCR
AVL_SQI_CD15
AVL_BILL_SQ15
AVL_SQI_CD15_DESCR
AVL_SQI_CD16
AVL_BILL_SQ16
AVL_SQI_CD16_DESCR
AVL_SQI_CD17
AVL_BILL_SQ17
AVL_SQI_CD17_DESCR
AVL_SQI_CD18
AVL_BILL_SQ18
AVL_SQI_CD18_DESCR
AVL_SQI_CD19
AVL_BILL_SQ19
AVL_SQI_CD19_DESCR
AVL_SQI_CD20
AVL_BILL_SQ20
AVL_SQI_CD20_DESCR
AVL_SQI_CD21
AVL_BILL_SQ21
AVL_SQI_CD21_DESCR
AVL_SQI_CD22
AVL_BILL_SQ22
AVL_SQI_CD22_DESCR
AVL_SQI_CD23
AVL_BILL_SQ23
AVL_SQI_CD23_DESCR
AVL_SQI_CD24
AVL_BILL_SQ24
AVL_SQI_CD24_DESCR
AVL_SQI_CD25
AVL_BILL_SQ25
AVL_SQI_CD25_DESCR
CORP_CCY
CORP_CALC_AMT
CORP_TAX_AMT
CORP_REVENUE_AMT
BALANCED_DT
BALANCED_ENTITY
REVIEW_YN
AGG_SQ
WIN_START_DTWindow Start Date WIN_START_DT
SRC_FT_ID Natural Key
SRC_BSEG_ID Natural Key
SRC_BILL_ID Natural Key
SRC_SA_ID Natural Key
SRC_CANCEL_BSEG_ID Natural Key
SRC_REBILL_BSEG_ID Natural Key
USAGE_ACCT_FK Foreign Key
PRODUCT_FK Foreign Key
INV_ACCT_FK Foreign Key
CUST_FK Foreign Key
SA_TYPE_FK Foreign Key
DIV_FK Foreign Key
BILL_DT_FK Foreign Key
ACCT_DT_FK Foreign Key
BILL_MON_FK Foreign Key
ACCT_MON_FK Foreign Key
ARS_MON_FK Foreign Key
FREEZE_MON_FK Foreign Key
ARS_DT_FK Foreign Key
FREEZE_DT_FK Foreign Key
CAL_FK Foreign Key
BSEG_START_DT_FK Foreign Key
BSEG_END_DT_FK Foreign Key
BSEG_START_MON_FK Foreign Key
BSEG_END_MON_FK Foreign Key
FISCAL_MONTH_FK Foreign Key
UDD_BILL1_FK Foreign Key
UDD_BILL2_FK Foreign Key
UDD_BILL3_FK Foreign Key
UDD_BILL4_FK Foreign Key
UDD_BILL5_FK Foreign Key
BILL_CYC_SCH_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
FACT_CNT Fact count 1
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
ILM_DTM Information Lifecycle Management Date/Time

BF_EXCEPTION

Properties

Property Value
Target Table BF_EXCEPTION
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Payment
Default Replication Group PY
Source System Driver Table CI_PAY_EVT_EXCP, CI_BSEG_EXCP, BILL_EXCP, CI_PAY_EXCP
Stage Table STG_BF_EXCEPTION
ODI Package BF_PKG_EXCEPTION
ETL View BF_EXCEPTION_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
ENTITY_TYPEEntity Type ENTITY_TYPE
ENTITY_IDEntity ID ENTITY_ID
EXCP_FLG
EXCP_FLG_DESCR
REVIEW_COMPLETED
COMMENTSComments COMMENTS
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
MSG_FK Foreign Key
REVIEW_USER_FK Foreign Key
REVIEW_DT_FK Foreign Key
REVIEW_MON_FK Foreign Key
CRE_DT_FK Foreign Key
CRE_MON_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
UDD_EXCP1_FK Foreign Key
UDD_EXCP2_FK Foreign Key
UDD_EXCP3_FK Foreign Key
UDD_EXCP4_FK Foreign Key
UDD_EXCP5_FK Foreign Key
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
FACT_CNT Fact count 1
ILM_DTM Information Lifecycle Management Date/Time

BF_EXCEPTION

Properties

Property Value
Target Table BF_EXCEPTION
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Payment
Default Replication Group PY
Source System Driver Table CI_PAY_EVT_EXCP, CI_BSEG_EXCP, BILL_EXCP, CI_PAY_EXCP
Stage Table STG_BF_EXCEPTION
ODI Package BF_PKG_EXCEPTION
ETL View BF_EXCEPTION_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
ENTITY_TYPEEntity Type ENTITY_TYPE
ENTITY_IDEntity ID ENTITY_ID
EXCP_FLG
EXCP_FLG_DESCR
REVIEW_COMPLETED
COMMENTSComments COMMENTS
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
MSG_FK Foreign Key
REVIEW_USER_FK Foreign Key
REVIEW_DT_FK Foreign Key
REVIEW_MON_FK Foreign Key
CRE_DT_FK Foreign Key
CRE_MON_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
UDD_EXCP1_FK Foreign Key
UDD_EXCP2_FK Foreign Key
UDD_EXCP3_FK Foreign Key
UDD_EXCP4_FK Foreign Key
UDD_EXCP5_FK Foreign Key
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
FACT_CNT Fact count 1
ILM_DTM Information Lifecycle Management Date/Time

BF_FEED

Properties

Property Value
Target Table BF_FEED
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Transaction Feed Management
Default Replication Group TXN
Source System Driver Table CI_TXN_HEADER
Stage Table STG_BF_FEED
ODI Package BF_PKG_FEED
ETL View BF_FEED_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
TOT_NO_FEEDS
NO_UPLD_FILES
NO_VALID_FILES
NO_INVALID_FILES
NO_CNCL_FILES
NO_ERROR_FILES
TOT_NO_RECS
TOT_VOLUME
TOT_AMTPayoff Amount TOT_AMT
NO_MANL_FILES
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
TXN_SOURCE_FK Foreign Key
DIV_FK Foreign Key
TXN_MON_FK Foreign Key
TXN_DT_FK Foreign Key
UDD_FEED1_FK Foreign Key
UDD_FEED2_FK Foreign Key
UDD_FEED3_FK Foreign Key
UDD_FEED4_FK Foreign Key
UDD_FEED5_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
FACT_CNT Fact count 1
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
ILM_DTM Information Lifecycle Management Date/Time

BF_GL

Properties

Property Value
Target Table BF_GL
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Financial Transaction General Ledger
Default Replication Group FTGL
Source System Driver Table CI_FT
Stage Table STG_BF_GL
ODI Package BF_PKG_GL
ETL View BF_GL_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
FT_TYPE_FLGFinancial Transaction Type FT_TYPE_FLG
GL_DIV
GL_ACCOUNT GL_ACCOUNT
GL_CCY
GL_AMT
GL_CONTRA_AMT
DIV_CCY
DIV_GL_AMT
DIV_GL_CONTRA_AMT
EXCHRATEExchange Rate EXCHRATE
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
CORP_CCY
CORP_GL_AMT
SRC_FT_ID Natural Key
SRC_SA_ID Natural Key
ACCT_FK Foreign Key
CUST_FK Foreign Key
SA_TYPE_FK Foreign Key
DIV_FK Foreign Key
DST_FK Foreign Key
CAL_FK Foreign Key
ACCT_DT_FK Foreign Key
ACCT_MON_FK Foreign Key
FREEZE_DT_FK Foreign Key
FREEZE_MON_FK Foreign Key
FISCAL_MONTH_FK Foreign Key
UDD_GL1_FK Foreign Key
UDD_GL2_FK Foreign Key
UDD_GL3_FK Foreign Key
UDD_GL4_FK Foreign Key
UDD_GL5_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
FACT_CNT Fact count 1
ILM_DTM Information Lifecycle Management Date/Time

BF_PAYMENT

Properties

Property Value
Target Table BF_PAYMENT
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Payment
Default Replication Group PY
Source System Driver Table CI_PAY
Stage Table STG_BF_PAYMENT
ODI Package BF_PKG_PAYMENT
ETL View BF_PAYMENT_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
FT_TYPE_FLGFinancial Transaction Type FT_TYPE_FLG
GL_DIV
MATCH_TYPE_CDMatch Type MATCH_TYPE_CD
PAY_STATUS_DESCR
CAN_RSN_CDCancel Reason CAN_RSN_CD
CAN_RSN_DESCR
DST_IDDistribution Code DST_ID
GL_ACCOUNT GL_ACCOUNT
PAY_CCY
PAY_AMTPayment Amount PAY_AMT
DIV_PAY_CCY
DIV_PAY_AMT
EXCHRATEExchange Rate EXCHRATE
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
GL_SEQ_NBRSequence GL_SEQ_NBR
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
CORP_CCY
CORP_PAY_AMT
SRC_FT_ID Natural Key
SRC_PAY_ID Natural Key
SRC_PAY_SEG_ID Natural Key
ACCT_FK Foreign Key
CUST_FK Foreign Key
SA_TYPE_FK Foreign Key
DIV_FK Foreign Key
PAY_DT_FK Foreign Key
ACCT_DT_FK Foreign Key
ARS_DT_FK Foreign Key
FREEZE_DT_FK Foreign Key
CAL_FK Foreign Key
PAY_MON_FK Foreign Key
ARS_MON_FK Foreign Key
FREEZE_MON_FK Foreign Key
ACCT_MON_FK Foreign Key
FISCAL_MONTH_FK Foreign Key
UDD_PAYMENT1_FK Foreign Key
UDD_PAYMENT2_FK Foreign Key
UDD_PAYMENT3_FK Foreign Key
UDD_PAYMENT4_FK Foreign Key
UDD_PAYMENT5_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
FACT_CNT Fact count 1
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
ILM_DTM Information Lifecycle Management Date/Time

BF_PAY_TNDR

Properties

Property Value
Target Table BF_PAY_TNDR
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Payment Tender
Default Replication Group PT
Source System Driver Table CI_PAY_EVENT
Stage Table STG_BF_PAY_TNDR
ODI Package BF_PKG_PAY_TNDR
ETL View BF_PAY_TNDR_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
CAN_RSN_CDCancel Reason CAN_RSN_CD
CAN_RSN_DESCR
TNDR_STATUS_FLGTender Status TNDR_STATUS_FLG
TNDR_STATUS_DESCRTender Status TNDR_STATUS_DESCR
TENDER_AMTTender Amount TENDER_AMT
CURRENCY_CDCurrency Code CURRENCY_CD
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
CORP_CCY
CORP_TENDER_AMT
ORIG_TNDR_AMTOriginal Tender Amount ORIG_TNDR_AMT
ORIG_TNDR_CCY_CDOriginal Tender Currency ORIG_TNDR_CCY_CD
SRC_PAY_TENDER_ID Natural Key
SRC_TNDR_CTL_ID Natural Key
ACCT_FK Foreign Key
EVENT_DT_FK Foreign Key
EVENT_MON_FK Foreign Key
EVENT_PAY_DT_FK Foreign Key
EVENT_PAY_MON_FK Foreign Key
DIV_FK Foreign Key
TENDER_TYPE_FK Foreign Key
CTL_USER_FK Foreign Key
CTL_DT_FK Foreign Key
CTL_MON_FK Foreign Key
TNDR_SOURCE_FK Foreign Key
CUST_FK Foreign Key
UDD_PAY_TNDR1_FK Foreign Key
UDD_PAY_TNDR2_FK Foreign Key
UDD_PAY_TNDR3_FK Foreign Key
UDD_PAY_TNDR4_FK Foreign Key
UDD_PAY_TNDR5_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
FACT_CNT Fact count 1
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
ILM_DTM Information Lifecycle Management Date/Time

BF_PRICE

Properties

Property Value
Target Table BF_PRICE
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Pricing and Billable Charge
Default Replication Group PR
Source System Driver Table CI_BSEG
Stage Table STG_BF_PRICE
ODI Package BF_PKG_PRICE
ETL View BF_PRICE_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
PRICE
BILL_SQ_CD
BILL_SQBillable Service Quantity BILL_SQ
CALC_CCY
CALC_AMTCalculated Amount CALC_AMT
DIV_CALC_CCY
DIV_CALC_AMT
EXCHRATEExchange Rate EXCHRATE
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
CALC_LINE_TYPE
PRICE_CURRENCY
DIV_PRICE
STD_PRICE
DIV_STD_PRICE
BLENDED_RATE
DIV_BLENDED_RATE
FEED_SRC_FLAG
MEMO_SWMemo Only,No GL MEMO_SW
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
PASS_THRU_SW
CORP_CCY
CORP_CALC_AMT
BASED_ON_SQ_VAL
CALC_AMT_IN_PRICE_CCY
CALC_AMT_TXN_CCY
CRE_DTCreation Date CRE_DT
EXCHRATE_CALC_TO_DIV
EXCHRATE_TXN_TO_PRICE
INITIAL_PRODUCT
PRICE_CCY
RATE_PRICE_CCY
TXN_CCY
TXN_DT
PROD_UNIT_COST
STD_AMOUNT
COST
COMP_KEY Surrogate Key
SRC_BILLABLE_CHG_ID Natural Key
SRC_BSEG_ID Natural Key
SRC_BILL_ID Natural Key
SRC_SA_ID Natural Key
SRC_PRICECOMP_ID Natural Key
USAGE_ACCT_FK Foreign Key
INV_ACCT_FK Foreign Key
SA_TYPE_FK Foreign Key
DIV_FK Foreign Key
BILL_DT_FK Foreign Key
BILL_MON_FK Foreign Key
ACCT_DT_FK Foreign Key
CAL_FK Foreign Key
BCHG_START_DT_FK Foreign Key
BCHG_END_DT_FK Foreign Key
PRODUCT_FK Foreign Key
PRICELIST_ID_FK Foreign Key
PRICE_ASGN_ID_FK Foreign Key
RATE_FK Foreign Key
ACCT_MON_FK Foreign Key
BCHG_START_MON_FK Foreign Key
BCHG_END_MON_FK Foreign Key
USAGE_CUST_FK Foreign Key
INV_CUST_FK Foreign Key
FREEZE_DT_FK Foreign Key
FREEZE_MON_FK Foreign Key
BUNDLE_FK Foreign Key
PRICE_COMP_ID_FK Foreign Key
PRICE_LINE_FK Foreign Key
UDD_PRICE1_FK Foreign Key
UDD_PRICE2_FK Foreign Key
UDD_PRICE3_FK Foreign Key
UDD_PRICE4_FK Foreign Key
UDD_PRICE5_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
TXN_LINE_FK Foreign Key
FACT_CNT Fact count 1
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
ILM_DTM Information Lifecycle Management Date/Time

BF_REFUND

Properties

Property Value
Target Table BF_REFUND
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Financial Transaction
Default Replication Group FT
Source System Driver Table C1_REF_WO_REQ
Stage Table STG_BF_REFUND
ODI Package BF_PKG_REFUND
ETL View BF_REFUND_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
REFUND_REASON
REQUEST_TYPERequest Type REQUEST_TYPE
REQ_STATUS
REQ_COMMENTS
REF_CCY
REF_AMTReferral Amount REF_AMT
DIV_CCY
DIV_REF_AMT
CORP_CCY
CORP_REF_AMT
ENTITY_TYPEEntity Type ENTITY_TYPE
ENTITY_IDEntity ID ENTITY_ID
PYMNT_DTPayment Date PYMNT_DT
PYMNT_METHOD
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
SRC_SA_ID Natural Key
SRC_ADJ_ID Natural Key
SRC_REF_REQ_ID Natural Key
SRC_REF_REQ_DTL_ID Natural Key
CRE_DT_FK Foreign Key
CRE_MON_FK Foreign Key
ADJ_DT_FK Foreign Key
CUST_FK Foreign Key
ACCT_FK Foreign Key
DIV_FK Foreign Key
SA_TYPE_FK Foreign Key
ADJ_TYPE_FK Foreign Key
UDD_REFUND1_FK Foreign Key
UDD_REFUND2_FK Foreign Key
UDD_REFUND3_FK Foreign Key
UDD_REFUND4_FK Foreign Key
UDD_REFUND5_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
FACT_CNT Fact count 1
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
ILM_DTM Information Lifecycle Management Date/Time

BF_SA

Properties

Property Value
Target Table BF_SA
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Service Agreement
Default Replication Group SA
Source System Driver Table CI_SA
Stage Table STG_BF_SA
ODI Package BF_PKG_SA
ETL View BF_SA_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
CURRENCY_CDCurrency Code CURRENCY_CD
SA_DURATION
SA_STATUS_DESCR
SA_REASON_DESCR
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
PROPOSAL_YN
SRC_SA_ID Natural Key
ACCT_FK Foreign Key
CUST_FK Foreign Key
DIV_FK Foreign Key
START_DT_FK Foreign Key
END_DT_FK Foreign Key
START_MON_FK Foreign Key
END_MON_FK Foreign Key
SA_FK Foreign Key
SA_TYPE_FK Foreign Key
UDD_SA1_FK Foreign Key
UDD_SA2_FK Foreign Key
UDD_SA3_FK Foreign Key
UDD_SA4_FK Foreign Key
UDD_SA5_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
FACT_CNT Fact count 1
JOB_NBR Job Number This field is populated with the ODI Job number
ILM_DTM Information Lifecycle Management Date/Time

BF_TD

Properties

Property Value
Target Table BF_TD
Table Type Fact
Fact Type Regular
Character Flag
Subject Area To-Do
Default Replication Group TD
Source System Driver Table CI_TD_ENTRY
Stage Table STG_BF_TD
ODI Package BF_PKG_TD
ETL View BF_TD_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
CREATE_DTTM
ASSIGN_DTTM
COMP_DTTM
OPEN_IND
ASSIGN_IND
COMPL_IND
HOURS
OPEN_HOURS
ASSIGN_HOURS
REL_TD_CNT
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
SRC_TD_ENTRY_ID Natural Key
SRC_TD_MSG Natural Key
SRC_BATCH_CD Natural Key
CUST_FK Foreign Key
ACCT_FK Foreign Key
SA_TYPE_FK Foreign Key
DIV_FK Foreign Key
TD_MESSAGE_FK Foreign Key
TD_ROLE_FK Foreign Key
TD_USER_FK Foreign Key
TD_TYPE_FK Foreign Key
TD_PRIORITY_FK Foreign Key
UDD_TD1_FK Foreign Key
UDD_TD2_FK Foreign Key
UDD_TD3_FK Foreign Key
UDD_TD4_FK Foreign Key
UDD_TD5_FK Foreign Key
CREATE_DT_FK Foreign Key
ASSIGN_DT_FK Foreign Key
COMP_DT_FK Foreign Key
CREATE_MON_FK Foreign Key
ASSIGN_MON_FK Foreign Key
COMP_MON_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
FACT_CNT Fact count 1
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
ILM_DTM Information Lifecycle Management Date/Time

BF_TXN

Properties

Property Value
Target Table BF_TXN
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Transaction Feed Management
Default Replication Group TXN
Source System Driver Table CI_TXN_DETAIL
Stage Table STG_BF_TXN
ODI Package BF_PKG_TXN
ETL View BF_TXN_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
NO_TXN_UPLOADED
NO_TXN_PROCESSED
NO_TXN_CANCELLED
NO_TXN_IGNORED
NO_TXN_COMPLETED
NO_TXN_INVALID
NO_TXN_ERRORED
NO_TXN_ROLLBACKED
NO_TXN_MANUAL
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
TXN_MON_FK Foreign Key
TXN_DT_FK Foreign Key
TXN_SOURCE_FK Foreign Key
TXN_REC_TYPE_FK Foreign Key
DIV_FK Foreign Key
UDD_TXN1_FK Foreign Key
UDD_TXN2_FK Foreign Key
UDD_TXN3_FK Foreign Key
UDD_TXN4_FK Foreign Key
UDD_TXN5_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
FACT_CNT Fact count 1
ILM_DTM Information Lifecycle Management Date/Time

BF_TXN_ERROR

Properties

Property Value
Target Table BF_TXN_ERROR
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Transaction Feed Management
Default Replication Group TXN
Source System Driver Table CI_ROLLBACK_TXN_DETAIL
Stage Table STG_BF_TXN_ERROR
ODI Package BF_PKG_TXN_ERROR
ETL View BF_TXN_ERROR_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
NO_ERRORS
TXN_FLAG
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
MSG_KEY_FK Foreign Key
TXN_DT_FK Foreign Key
TXN_MON_FK Foreign Key
TXN_SOURCE_FK Foreign Key
TXN_REC_TYPE_FK Foreign Key
DIV_FK Foreign Key
UDD_TXN_ERROR1_FK Foreign Key
UDD_TXN_ERROR2_FK Foreign Key
UDD_TXN_ERROR3_FK Foreign Key
UDD_TXN_ERROR4_FK Foreign Key
UDD_TXN_ERROR5_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
FACT_CNT Fact count 1
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
ILM_DTM Information Lifecycle Management Date/Time

BF_WRITEOFF

Properties

Property Value
Target Table BF_WRITEOFF
Table Type Fact
Fact Type Regular
Character Flag
Subject Area Financial Transaction
Default Replication Group FT
Source System Driver Table C1_REF_WO_REQ
Stage Table STG_BF_WRITEOFF
ODI Package BF_PKG_WRITEOFF
ETL View BF_WRITEOFF_VW
Scheduling Frequency Daily Once

Fields

Target Field Field Description Source Field Transformation or Calculation Logic
WO_TYPE
WRITEOFF_REASON
REQUEST_TYPERequest Type REQUEST_TYPE
REQ_STATUS
REQ_COMMENTS
WO_CCY
WO_AMTWrite Off Amount WO_AMT
DIV_CCY
DIV_WO_AMT
CORP_CCY
CORP_WO_AMT
ENTITY_TYPEEntity Type ENTITY_TYPE
ENTITY_IDEntity ID ENTITY_ID
UDDGEN1 User Defined Degenerate Dimension 1
UDDGEN2 User Defined Degenerate Dimension 2
UDDGEN3 User Defined Degenerate Dimension 3
UDDGEN4 User Defined Degenerate Dimension 4
UDDGEN5 User Defined Degenerate Dimension 5
UDDGEN6 User Defined Degenerate Dimension 6
UDDGEN7 User Defined Degenerate Dimension 7
UDDGEN8 User Defined Degenerate Dimension 8
UDDGEN9 User Defined Degenerate Dimension 9
UDDGEN10 User Defined Degenerate Dimension 10
UDDGEN11 User Defined Degenerate Dimension 11
UDDGEN12 User Defined Degenerate Dimension 12
UDDGEN13 User Defined Degenerate Dimension 13
UDDGEN14 User Defined Degenerate Dimension 14
UDDGEN15 User Defined Degenerate Dimension 15
UDDGEN16 User Defined Degenerate Dimension 16
UDDGEN17 User Defined Degenerate Dimension 17
UDDGEN18 User Defined Degenerate Dimension 18
UDDGEN19 User Defined Degenerate Dimension 19
UDDGEN20 User Defined Degenerate Dimension 20
UDDGEN21 User Defined Degenerate Dimension 21
UDDGEN22 User Defined Degenerate Dimension 22
UDDGEN23 User Defined Degenerate Dimension 23
UDDGEN24 User Defined Degenerate Dimension 24
UDDGEN25 User Defined Degenerate Dimension 25
UDDGEN26 User Defined Degenerate Dimension 26
UDDGEN27 User Defined Degenerate Dimension 27
UDDGEN28 User Defined Degenerate Dimension 28
UDDGEN29 User Defined Degenerate Dimension 29
UDDGEN30 User Defined Degenerate Dimension 30
UDDGENL1 User Defined Long Degenerate Dimension L1
UDDGENL2 User Defined Long Degenerate Dimension L2
UDDGENL3 User Defined Long Degenerate Dimension L3
UDDGENL4 User Defined Long Degenerate Dimension L4
UDDGENL5 User Defined Long Degenerate Dimension L5
UDDGENL6 User Defined Long Degenerate Dimension L6
UDDGENL7 User Defined Long Degenerate Dimension L7
UDDGENL8 User Defined Long Degenerate Dimension L8
UDDGENL9 User Defined Long Degenerate Dimension L9
UDDGENL10 User Defined Long Degenerate Dimension L10
UDDGENL11 User Defined Long Degenerate Dimension L11
UDDGENL12 User Defined Long Degenerate Dimension L12
UDDGENL13 User Defined Long Degenerate Dimension L13
UDDGENL14 User Defined Long Degenerate Dimension L14
UDDGENL15 User Defined Long Degenerate Dimension L15
UDDGENL16 User Defined Long Degenerate Dimension L16
UDDGENL17 User Defined Long Degenerate Dimension L17
UDDGENL18 User Defined Long Degenerate Dimension L18
UDDGENL19 User Defined Long Degenerate Dimension L19
UDDGENL20 User Defined Long Degenerate Dimension L20
UDM1 User Defined Measure 1
UDM2 User Defined Measure 2
UDM3 User Defined Measure 3
UDM4 User Defined Measure 4
UDM5 User Defined Measure 5
UDM6 User Defined Measure 6
UDM7 User Defined Measure 7
UDM8 User Defined Measure 8
UDM9 User Defined Measure 9
UDM10 User Defined Measure 10
UDM11 User Defined Measure 11
UDM12 User Defined Measure 12
UDM13 User Defined Measure 13
UDM14 User Defined Measure 14
UDM15 User Defined Measure 15
UDM16 User Defined Measure 16
UDM17 User Defined Measure 17
UDM18 User Defined Measure 18
UDM19 User Defined Measure 19
UDM20 User Defined Measure 20
UDM21 User Defined Measure 21
UDM22 User Defined Measure 22
UDM23 User Defined Measure 23
UDM24 User Defined Measure 24
UDM25 User Defined Measure 25
UDM26 User Defined Measure 26
UDM27 User Defined Measure 27
UDM28 User Defined Measure 28
UDM29 User Defined Measure 29
UDM30 User Defined Measure 30
UDM31 User Defined Measure 31
UDM32 User Defined Measure 32
UDM33 User Defined Measure 33
UDM34 User Defined Measure 34
UDM35 User Defined Measure 35
UDM36 User Defined Measure 36
UDM37 User Defined Measure 37
UDM38 User Defined Measure 38
UDM39 User Defined Measure 39
UDM40 User Defined Measure 40
UDM41 User Defined Measure 41
UDM42 User Defined Measure 42
UDM43 User Defined Measure 43
UDM44 User Defined Measure 44
UDM45 User Defined Measure 45
UDM46 User Defined Measure 46
UDM47 User Defined Measure 47
UDM48 User Defined Measure 48
UDM49 User Defined Measure 49
UDM50 User Defined Measure 50
UPDATE_DTTMUpdate DateTime UPDATE_DTTM
SRC_SA_ID Natural Key
SRC_ADJ_ID Natural Key
SRC_WO_REQ_ID Natural Key
SRC_WO_REQ_DTL_ID Natural Key
CRE_DT_FK Foreign Key
CRE_MON_FK Foreign Key
ADJ_DT_FK Foreign Key
ACCT_FK Foreign Key
CUST_FK Foreign Key
DIV_FK Foreign Key
SA_TYPE_FK Foreign Key
ADJ_TYPE_FK Foreign Key
UDD_WRITEOFF1_FK Foreign Key
UDD_WRITEOFF2_FK Foreign Key
UDD_WRITEOFF3_FK Foreign Key
UDD_WRITEOFF4_FK Foreign Key
UDD_WRITEOFF5_FK Foreign Key
COMMON1_FK Foreign Key
COMMON2_FK Foreign Key
COMMON3_FK Foreign Key
COMMON4_FK Foreign Key
COMMON5_FK Foreign Key
FACT_CNT Fact count 1
DATA_SOURCE_IND Data Source Indicator This field is populated with the DSI value.This column is populated as part of source product instance configuration.The DSI value is extractedfrom the environment ID of the source system (CI_INSTALLATION.ENV_ID)
JOB_NBR Job Number This field is populated with the ODI Job number
ILM_DTM Information Lifecycle Management Date/Time