Field Transfer Mappings window
Target.TRANSFERFIELDS(Source) copies fields by field number. The Field Transfer
Mappings window shows how the fields of two tables pair up, and flags types that do not match and
fields that cannot take part.
Opening Field Transfer Mappings
- Right-click the target table in the Object index or its heading in the Object view, and choose Show TransferFields Mapping From…. In Universal Search, the same command is among the table's actions (Tab).
- In Select source table, pick the source table.
The table you right-clicked is the target; the table you pick is the source. For Show TransferFields Mapping From…, your license must include Explore Table Relations.
From code: on the Prism tab of the Object view, right-click a
TRANSFERFIELDS call and choose
Show inter-table field mappings.
The window opens at once, with the record's table as the target and the table of the argument as the source.
The mapping
| # | Name | Description |
|---|---|---|
| 1 | Swap tables | Swaps source and target: x.TRANSFERFIELDS(y) becomes y.TRANSFERFIELDS(x). |
| 2 | Search | Keeps the rows whose field number, source name or target name contains the text. |
| 3 | Mapping filter | See Mapping filter. |
| 4 | Field selector | Which side the mapping filter looks at: Any, Both, Source or Target. |
| 5 | Target table | The table the fields are copied to, on the left. |
| 6 | Source table | The table the fields are copied from, on the right. Read from right to left, as the assignment runs. |
| 7 | Fields | One row per field number; see Mapping columns. |
| 8 | Mapping icon | How the field transfers; hover for the reason. See Mapping icons. |
Mapping columns
| Column | Shows |
|---|---|
| No. | The field number. |
| Target Name, Target Type | The target table's field with that number, if any. |
| Mapping icon | How the field transfers. |
| Source Type, Source Name | The source table's field with that number, if any. |
Select a header to sort; drag a header to reorder the columns or its edge to resize them. Right-click a row and choose Go to Target Field or Go to Source Field, each followed by the field's name, to open the field in the workspace window.
Mapping icons
| # | Icon | Meaning | Tooltips |
|---|---|---|---|
| 1 | Green check | Mapped, and the value can be assigned. | Types match; Source dimension fits target dimension |
| 2 | Yellow cross | Mapped, but the types do not match. | Types mismatch; Text overflow — source dimension exceeds target |
| 3 | Grey cross | Mapped, but disqualified: a FlowField, or a field with ObsoleteState Removed. | Source field has a flow field class, Target field has a flow field class; Source field is obsolete removed, Target field is obsolete removed |
| 4 | Empty circle | Unmapped: the field number exists in one table only. | Source field is not defined; Target field is not defined |
Mapping filter
The mapping filter lists only the choices that have at least one row.
| # | Filter | Lists |
|---|---|---|
| 1 | All | Every field number in either table. |
| 2 | Mapped | Field numbers in both tables that transfer. |
| 3 | › Type Match | Of those, the ones whose types match. |
| 4 | › Type Mismatch | Of those, the ones whose types do not match. |
| 5 | Mapped (Disqualified) | Field numbers in both tables that do not transfer. |
| 6 | › Flow Field Class | Of those, the ones that are FlowFields. |
| 7 | Unmapped | Field numbers in one table only. |
The list offers only the filters that match some field of the two tables. One more appears under
Mapped (Disqualified) when a field has ObsoleteState Removed in either table:
› Obsolete Removed.
For Flow Field Class, Obsolete Removed and Unmapped, the field selector chooses whether the source field, the target field, both or either must qualify. It offers only the choices that apply and is disabled when Any is the only one.
Check a TRANSFERFIELDS between two tables
Use this before you add a field to a table that is copied with TRANSFERFIELDS, such as a document line and its posted line.
- Right-click the target table, such as table 113 Sales Invoice Line, and choose Show TransferFields Mapping From….
- Pick the source table, such as table 37 Sales Line.
- Choose › Type Mismatch in the mapping filter and hover each icon to read the mismatch.
- Choose Unmapped to see the fields that exist on one side only, and give a new field the same number on both sides if it should transfer.
Behavior
- By number: fields pair up by field number only; names do not matter.