Table 5378 "Synth. Relation Mapping Buffer"

Base Application · BC24-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
TableType	Temporary
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation
1	Synth. Relation Name	Text[100]	Specifies the name of the synthetic relation. via Page 5478 “Synthetic Relation Details”
2	Rel. Native Entity Name	Text[100]	Specifies the name of the native entity. via Page 5478 “Synthetic Relation Details”
3	Rel. Virtual Entity Name	Text[100]	Specifies the name of the virtual entity. via Page 5478 “Synthetic Relation Details”
4	Virtual Table Caption	Text[200]	Specifies the virtual table name. via Page 5375 “Synth. Relation Mapping”
5	Virtual Table Logical Name	Text[100]	Specifies the virtual table logical name. via Page 5375 “Synth. Relation Mapping”
6	Syncd. Table Name	Text[80]	Specifies the integration table name. via Page 5375 “Synth. Relation Mapping”
7	Syncd. Table External Name	Text[248]	Specifies the integration table external name. via Page 5375 “Synth. Relation Mapping”
8	Syncd. Table Id	Integer	—
9	Syncd. Field 1 Name	Text[80]	Specifies the integration field name. via Page 5375 “Synth. Relation Mapping”
10	Syncd. Field 1 External Name	Text[100]	Specifies the name of the native field used for the relation. via Page 5478 “Synthetic Relation Details”
11	Syncd. Field 1 Id	Integer	—
12	Virtual Table Column 1 Caption	Text[200]	Specifies the name of the virtual table’s column. via Page 5375 “Synth. Relation Mapping”
13	Virtual Table Column 1 Name	Text[100]	Specifies the name of the field in the virtual table used for the relation. via Page 5478 “Synthetic Relation Details”
14	Syncd. Field 2 Name	Text[80]	—
15	Syncd. Field 2 External Name	Text[100]	Specifies the name of the native field used for the relation. via Page 5478 “Synthetic Relation Details”
16	Syncd. Field 2 Id	Integer	—
17	Virtual Table Column 2 Caption	Text[200]	—
18	Virtual Table Column 2 Name	Text[100]	Specifies the name of the field in the virtual table used for the relation. via Page 5478 “Synthetic Relation Details”
19	Syncd. Field 3 Name	Text[80]	—
20	Syncd. Field 3 External Name	Text[100]	Specifies the name of the native field used for the relation. via Page 5478 “Synthetic Relation Details”
21	Syncd. Field 3 Id	Integer	—
22	Virtual Table Column 3 Caption	Text[200]	—
23	Virtual Table Column 3 Name	Text[100]	Specifies the name of the field in the virtual table used for the relation. via Page 5478 “Synthetic Relation Details”
24	Relation Id	Guid	—
25	Relation Created	Boolean	—
26	Virtual Table Phys. Name	Text[100]	Specifies the virtual table physical name. via Page 5375 “Synth. Relation Mapping”
27	Virtual Table API Page Id	Integer	Specifies the virtual table API page ID in Business Central. via Page 5375 “Synth. Relation Mapping”

Keys

PK: Synth. Relation Name, Virtual Table Logical Name, Syncd. Table Id, Syncd. Field 1 Id, Syncd. Field 2 Id, Syncd. Field 3 Id, Virtual Table Column 1 Name, Virtual Table Column 2 Name, Virtual Table Column 3 Name (clustered)

Pages and codeunits on this table

Page 5374 “New Synthetic Relation Wiz.” (source table)
Page 5375 “Synth. Relation Mapping” (source table)
Page 5376 “Synthetic Relations” (source table)
Page 5478 “Synthetic Relation Details” (source table)

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Synth. Relation Mapping Buffer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.