Key Map GL
In ScopeTechnical: KEY_MAP_GL | ID: OR-CST-KEY_MAP_GL-KEY_MAP_GL
Stores the reference key details of the GL records that are written to stg_fif_gl_data. So this new table will be used to map the records in the TRAN_DATA_HISTORY with the...
See how this object fits into Cost
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- KEY_MAP_GL
Field Definitions(5)
Rules & Considerations(18)
Sample Load Data(4)
| _scenario | REFERENCE_TRACE_IDRPK | REFERENCE_TRACE_TYPER | DEPT | ITEM | CLASS | DEAL_NO | LOCATION | LOC_TYPE | PGM_NAME | SUBCLASS | GL_REF_NO | TRAN_CODE | IFTD_ROWID | PROCESSED_DATE | COST_RETAIL_FLAG | PROCESSING_VDATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | 1 | SAMPLE | 1 | 1 | 1 | S | SAMPLE | 1 | SAMPLE | 1 | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 |
| default | ALT-KEY_MAP-002 | Key Map GL-002-ALT | 1003 | Key Map GL-002-ALT | 1103 | 4 | 3 | K | Key Map GL Secondary | 1113 | Key Map GL-002-ALT | 3 | Key Map GL-002-ALT | 2026-01-03 | Key Map GL-002-ALT | 2026-01-03 |
| default | EDGE-KEY_MAP-003 | Key Map GL-003-EDGE | 1005 | Key Map GL-003-EDGE | 1105 | 6 | 5 | K | Key Map GL Core | 1115 | Key Map GL-003-EDGE | 5 | Key Map GL-003-EDG | 2026-01-05 | Key Map GL-003-EDGE | 2026-01-05 |
Example values from field definitions
- REFERENCE_TRACE_IDRPK
- SAMPLE
- REFERENCE_TRACE_TYPER
- SAMPLE
- DEPT
- 1
- ITEM
- SAMPLE
- CLASS
- 1
- DEAL_NO
- 1
- LOCATION
- 1
- LOC_TYPE
- S
- PGM_NAME
- SAMPLE
- SUBCLASS
- 1
- GL_REF_NO
- SAMPLE
- TRAN_CODE
- 1
- IFTD_ROWID
- SAMPLE
- PROCESSED_DATE
- 2026-01-01
- COST_RETAIL_FLAG
- SAMPLE
- PROCESSING_VDATE
- 2026-01-01
default
- REFERENCE_TRACE_IDRPK
- ALT-KEY_MAP-002
- REFERENCE_TRACE_TYPER
- Key Map GL-002-ALT
- DEPT
- 1003
- ITEM
- Key Map GL-002-ALT
- CLASS
- 1103
- DEAL_NO
- 4
- LOCATION
- 3
- LOC_TYPE
- K
- PGM_NAME
- Key Map GL Secondary
- SUBCLASS
- 1113
- GL_REF_NO
- Key Map GL-002-ALT
- TRAN_CODE
- 3
- IFTD_ROWID
- Key Map GL-002-ALT
- PROCESSED_DATE
- 2026-01-03
- COST_RETAIL_FLAG
- Key Map GL-002-ALT
- PROCESSING_VDATE
- 2026-01-03
default
- REFERENCE_TRACE_IDRPK
- EDGE-KEY_MAP-003
- REFERENCE_TRACE_TYPER
- Key Map GL-003-EDGE
- DEPT
- 1005
- ITEM
- Key Map GL-003-EDGE
- CLASS
- 1105
- DEAL_NO
- 6
- LOCATION
- 5
- LOC_TYPE
- K
- PGM_NAME
- Key Map GL Core
- SUBCLASS
- 1115
- GL_REF_NO
- Key Map GL-003-EDGE
- TRAN_CODE
- 5
- IFTD_ROWID
- Key Map GL-003-EDG
- PROCESSED_DATE
- 2026-01-05
- COST_RETAIL_FLAG
- Key Map GL-003-EDGE
- PROCESSING_VDATE
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 24
- Governed Rule Count
- 18