Table 11006 "Data Export Table Relation" (CH)

CH country layer · Microsoft.Finance.AuditFileExport · captioned “Data Export Table Relationship” · BC29-30 · source at ea08af5e · facts from BC29

An object of the CH localization, not part of W1.

Properties

Property	Value
Caption	Data Export Table Relationship
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	Notes
1	Data Export Code	Code[10]	—	TableRelation Data Export; NotBlank
2	Data Exp. Rec. Type Code	Code[10]	—	TableRelation Data Export Record Type; NotBlank
3	From Table No.	Integer	—	TableRelation AllObj.“Object ID” where(“Object Type” = const(Table)); NotBlank
4	From Table Name	Text[80]	—	FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = const(Table), “Object ID” = field(“From Table No.”))); not editable
5	From Field No.	Integer	—	TableRelation Field.“No.” where(TableNo = field(“From Table No.”), Type = filter(Option \| Text \| Code \| Integer \| Decimal \| Date \| Boolean), Class = const(Normal), ObsoleteState = filter(<> Removed)); NotBlank
6	From Field Name	Text[80]	—	FlowField: lookup(Field.“Field Caption” where(TableNo = field(“From Table No.”), “No.” = field(“From Field No.”))); not editable
7	To Table No.	Integer	—	TableRelation AllObj.“Object ID” where(“Object Type” = const(Table)); NotBlank
8	To Table Name	Text[80]	—	FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = const(Table), “Object ID” = field(“To Table No.”))); not editable
9	To Field No.	Integer	—	TableRelation Field.“No.” where(TableNo = field(“To Table No.”), Type = filter(Option \| Text \| Code \| Integer \| Decimal \| Date \| Boolean), ObsoleteState = filter(<> Removed)); NotBlank
10	To Field Name	Text[80]	—	FlowField: lookup(Field.“Field Caption” where(TableNo = field(“To Table No.”), “No.” = field(“To Field No.”))); not editable

Keys

Key1: Data Export Code, Data Exp. Rec. Type Code, From Table No., From Field No., To Table No., To Field No. (clustered)

Triggers

OnInsert

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: "Data Export Table Relation"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A CH country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.