Key Map GL
In ScopeTechnical: KEY_MAP_GL | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- KEY_MAP_GL
Field Definitions(16)
Rules & Considerations(39)
Sample Load Data(4)
| _scenario | PROCESSED_DATER | REFERENCE_TRACE_IDRPK | REFERENCE_TRACE_TYPER | DEPT | ITEM | CLASS | DEAL_NO | LOCATION | LOC_TYPE | PGM_NAME | SUBCLASS | GL_REF_NO | TRAN_CODE | IFTD_ROWID | COST_RETAIL_FLAG | PROCESSING_VDATE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 2026-01-01 | STD-KEY_MAP-001 | Key Map GL-001 | 1001 | Key Map GL-001 | 1101 | 2 | 1 | Key Map GL-001 | Key Map GL Primary | 1111 | Key Map GL-001 | 0001 | Key Map GL-001 | Key Map GL-001 | 2026-01-01 |
default
- PROCESSED_DATER
- 2026-01-01
- REFERENCE_TRACE_IDRPK
- STD-KEY_MAP-001
- REFERENCE_TRACE_TYPER
- Key Map GL-001
- DEPT
- 1001
- ITEM
- Key Map GL-001
- CLASS
- 1101
- DEAL_NO
- 2
- LOCATION
- 1
- LOC_TYPE
- Key Map GL-001
- PGM_NAME
- Key Map GL Primary
- SUBCLASS
- 1111
- GL_REF_NO
- Key Map GL-001
- TRAN_CODE
- 0001
- IFTD_ROWID
- Key Map GL-001
- COST_RETAIL_FLAG
- Key Map GL-001
- PROCESSING_VDATE
- 2026-01-01
