Field crosswalk registry. The combined schema is not achieved by forcing Salesforce and ServiceNow to agree; it is achieved by recording, field by field, how each one maps onto the canonical interaction line. Every mapping declares its transform and its confidence, and an unmapped source field is recorded as unmapped rather than quietly dropped. This table is what makes a third system — a phone platform, a satellite ground segment, a parish register — a configuration exercise instead of a rewrite.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | T000 |
| SOR_CLV key | systema originis clavis | Source system key | EGD_SRCSYS | CHAR 10 | SYSRC |
| FNS_OBI_TBL key | fons obiectum tabula | Source object or table name | EGD_SRCTYP | CHAR 40 | — |
| FNS_CMP_NOM key | fons campus nomen | Source field or attribute name | EGD_SRCFLD | CHAR 60 | — |
| MTA_TBL_EPH | meta tabula ephemeris commercii | Target table in the interaction journal | EGD_SRCTYP | CHAR 40 | — |
| MTA_CMP_EPH | meta campus ephemeris commercii | Target field in the interaction journal | EGD_SRCFLD | CHAR 60 | — |
| NOM_MTA_CMP | nomen meta campus | Canonical Latin name of the target field | EGD_SRCFLD | CHAR 64 | — |
| DSG_GEN | designatio genus | Mapping type: direct, transformed, derived, constant, crosswalked or unmapped | EGD_MAPTYP | CHAR 10 | — |
| TFM | transformatio | Transform rule applied, stated plainly enough to be argued with | TEXT80 | CHAR 255 | — |
| FID_DSG | fiducia designatio | Confidence in the mapping: asserted, reviewed or verified against live data | EGD_CONFID | CHAR 1 | — |
| DSG_FNS_VAL | designatio fons valor | Mapping loses information; the source value is preserved in the raw mirror | XFELD | CHAR 1 | — |
| PSN_DSG | persona designatio | Party accountable for the correctness of this mapping | EGD_PARTY | CHAR 32 | — |
| VLA_DIE_DSG | validus ab dies designatio | Valid from date of the mapping | DATUM | DATS 8 | — |
| DSG | designatio | Notes recording why the mapping is what it is | TEXT80 | CHAR 255 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
SRCSYS | SYSRC | SRCSYS |