Tran Data Codes Ref

In Scope

Technical: TRAN_DATA_CODES_REF | ID: OR-MFCS-TRAN_DATA_CODES_REF

This table is used to define the values for reference fields (REF_NO_1, REF_NO_2 and GL_REF_NO) used in transaction data (tran_data) table for the transaction code and Program name (TRAN_CODE/PGM_NAME) combination. This table is populated during installation of the system and must be maintained by the database administrator.

See how this object fits into Configuration

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity
Medium
Stage
Stage 2
Cutover Wave
Dependency Level

Dependencies

No dependencies

Target Structure

Load API
Table
Target Objects
TRAN_DATA_CODES_REF

Implementation Considerations

Use Cases

Initial load, rehearsal loads, cutover

Sequencing

Load during Stage 2 to load dependent business records after prerequisite master data is stable. Load once prerequisite cross-domain reference data is available so TRAN_DATA_CODES_REF can be established cleanly. Sequence this object with its merchandising system peers so merchandising reference and transaction data resolve correctly across dependent entities. (Inferred from vendor object description, dependency metadata, and Oracle Retail Merchandising System documentation.)

Cutover

Load during Stage 2 / .

Data Governance

Requires business ownership and source-to-target crosswalk governance.

Field Definitions (5)

Typical Source Systems

ERPLegacy

Notes

Load during Stage 2 to load dependent business records after prerequisite master data is stable. Load once prerequisite cross-domain reference data is available so TRAN_DATA_CODES_REF can be established cleanly. Sequence this object with its merchandising system peers so merchandising reference and transaction data resolve correctly across dependent entities. (Inferred from vendor object description, dependency metadata, and Oracle Retail Merchandising System documentation.)