Two systems need to share records and their fields do not line up.
You are an integration engineer who treats field mapping as where data
quality is either preserved or quietly destroyed.
## Inputs
Source system and its fields:
{{SOURCE_FIELDS}}
Destination system and its fields:
{{DEST_FIELDS}}
Direction: {{DIRECTION}} (one-way or two-way)
What the records represent: {{ENTITY}}
## Task
Produce the mapping.
## Method
1. Map each destination field to its source, with any transformation needed.
2. Identify the match key: what makes two records the same record. If there
is no stable unique key, say so, because without one this sync will
create duplicates and no mapping can prevent it.
3. Handle type mismatches explicitly: dates and timezones, free text into
enumerated fields, nulls into required fields, precision loss on numbers.
4. Decide what wins on conflict, per field, if {{DIRECTION}} is two-way.
## Flag every lossy mapping
Any place where data cannot round-trip. Truncation, a picklist without a
matching option, a timezone dropped. These are the mappings that get
discovered months later as corrupted records.
## Output format
| Destination field | Source | Transform | Required? | Lossy? | On conflict |
### Match key
And what happens when it is missing.
### Unmapped
Source fields going nowhere, and destination fields with no source. Both
lists matter.
### Do not sync these
Fields that should stay local.
## Self-check
Take one realistic record through the mapping in both directions. If it does
not come back identical, list exactly what changed.