Table 8622 "Config. Line"
Base Application · System.IO
Across versions
- BC23present
- BC242 fields changed
- BC25-30unchanged
Neighbourhood 11 connected objects and pages
Base Application · System.IO · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 8632 “Config. Worksheet” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Config. Line |
| 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 | Line No. | Integer | — | |
| 2 | Line Type | Option | Specifies the type of the configuration package line. The line can be one of the following types: via Page 8632 “Config. Worksheet” | OptionCaption: Area,Group,Table |
| 3 | Table ID | Integer | Specifies the ID of the table that you want to use for the line type. After you select a table ID from the list of objects in the lookup table, the name of the table is automatically filled in the Name field. via Page 8630 “Config. Tables” | TableRelation if (“Line Type” = const(Table)) AllObjWithCaption.“Object ID” where(“Object Type” = const(Table), “Object ID” = filter(.. 1260 | 1262 .. 99999999 | 2000000004 | 2000000005)) |
| 4 | Name | Text[250] | Specifies the name of the line type. via Page 8630 “Config. Tables” | |
| 5 | Company Filter | Text[30] | — | TableRelation Company; FlowFilter |
| 6 | Company Filter (Source Table) | Text[30] | — | TableRelation Company; FlowFilter |
| 8 | No. of Records | Integer | — | FlowField: sum(“Table Information”.“No. of Records” where(“Company Name” = field(“Company Filter”), “Table No.” = field(“Table ID”))); not editable |
| 9 | No. of Records (Source Table) | Integer | — | FlowField: sum(“Table Information”.“No. of Records” where(“Company Name” = field(“Company Filter (Source Table)”), “Table No.” = field(“Table ID”))); not editable |
| 10 | Licensed Table | Boolean | Specifies whether the table is covered by the license of the person creating the configuration package. via Page 8632 “Config. Worksheet” | FlowField: exist(“License Permission” where(“Object Type” = const(TableData), “Object Number” = field(“Table ID”), “Read Permission” = const(Yes), “Insert Permission” = const(Yes), “Modify Permission” = const(Yes), “Delete Permission” = const(Yes))); not editable |
| 11 | Promoted Table | Boolean | Specifies whether the table is promoted. Select the check box to promote the table in the configuration worksheet. You can use this designation as a signal that this table requires additional attention. via Page 8632 “Config. Worksheet” | |
| 12 | Dimensions as Columns | Boolean | Specifies whether the configuration includes dimensions as columns. When you select the Dimensions as Columns check box, the dimensions are included in the Excel worksheet that you create for configuration. In order to select this check box, you must include the Default Dimension and Dimension Value… via Page 8632 “Config. Worksheet” | |
| 13 | Copying Available | Boolean | Specifies whether copying is available in the configuration worksheet. via Page 8632 “Config. Worksheet” | not editable |
| 14 | Page ID | Integer | Specifies the number of the page that is used to show the journal or worksheet that uses the template. via Page 8632 “Config. Worksheet” | TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Page)) |
| 15 | Page Caption Δ BC24 | Text[250] | Specifies the displayed name of the journal or worksheet that uses the template. via Page 8632 “Config. Worksheet” | FlowField: lookup(AllObjWithCaption.“Object Name” where(“Object Type” = const(Page), “Object ID” = field(“Page ID”))); not editable |
| 18 | Starting Date | Date | — | |
| 19 | Ending Date | Date | — | |
| 20 | Responsible ID | Code[50] | Specifies the ID of the Business Central user who is responsible for the configuration worksheet. via Page 8630 “Config. Tables” | TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation |
| 21 | Status | Option | Specifies the status of the table in the configuration worksheet. You can use the status information, which you provide, to help you in planning and tracking your work. via Page 8630 “Config. Tables” | OptionCaption: ,In Progress,Completed,Ignored,Blocked |
| 25 | Vertical Sorting | Integer | — | |
| 26 | Data Origin | Text[50] | — | |
| 28 | Reference | Text[250] | Specifies a url address. Use this field to provide a url address to a location that Specifies information about the table. For example, you could provide the address of a page that Specifies information about setup considerations that the solution implementer should consider. via Page 8630 “Config. Tables” | |
| 30 | Licensed Page | Boolean | Specifies whether the page that is associated with the table is licensed. via Page 8632 “Config. Worksheet” | FlowField: exist(“License Permission” where(“Object Type” = const(Page), “Object Number” = field(“Page ID”), “Execute Permission” = const(Yes))); not editable |
| 31 | No. of Question Groups | Integer | Specifies the number of question groups that are contained on the configuration questionnaire. via Page 8632 “Config. Worksheet” | FlowField: count(“Config. Question Area” where(“Table ID” = field(“Table ID”))); not editable |
| 32 | Parent Line No. | Integer | — | |
| 36 | Package Code | Code[20] | Specifies the code of the package associated with the configuration. The code is filled in when you use the Assign Package function to select the package for the line type. via Page 8630 “Config. Tables” | TableRelation Table 8623 “Config. Package” (Config. Package) |
| 37 | Package Caption Δ BC24 | Text[50] | — | FlowField: lookup(“Config. Package”.“Package Name” where(Code = field(“Package Code”))); not editable |
| 38 | Package Exists | Boolean | Specifies whether the package that has been assigned to the worksheet line has been created. via Page 8632 “Config. Worksheet” | FlowField: exist(“Config. Package” where(Code = field(“Package Code”))); not editable |
Keys
- Key1: Line No. (clustered)
- Key2: Line Type, Status, Promoted Table
- Key3: Table ID
- Key4: Vertical Sorting
- Key5: Line Type, Parent Line No.
- Key6: Package Code
Events published
OnBeforeShowTableData(ConfigLine: Record "Config. Line"; var IsHandled: Boolean)(integration)OnGetRelatedTablesOnAfterFieldSetFilters(var ConfigLine: Record "Config. Line"; var Field: Record "Field")(integration)
Procedures
CheckBlocked()ShowTableData()ShowQuestions()GetProgress(): IntegerGetNoOfDirectChildrenTables(): IntegerGetDirectChildrenTablesStatusWeight(): DecimalGetNoTables(): IntegerGetLineStatusWeight(): DecimalSetHideValidationDialog(NewHideValidationDialog: Boolean)GetNoOfRecords(): IntegerGetNoOfRecordsSourceTable(): IntegerGetNoOfRecordsText(): TextDeleteDuplicateLines()
Plus 4 local procedures.
Triggers
OnDelete
Relations
- No. of Question Groups: CalcFormula Table 8611 “Config. Question Area”
- Package Caption: CalcFormula Table 8623 “Config. Package”
- Package Exists: CalcFormula Table 8623 “Config. Package”
- Package Code: TableRelation Table 8623 “Config. Package”
Referenced by
7 fields in 2 objects relate to this table (TableRelation or CalcFormula).
- Table 9061 “RapidStart Services Cue”: Blocked, Completed, Ignored, In Progress, Not Started, Promoted
- Table 8625 “Config. Related Table”: In Worksheet
Pages and codeunits on this table
- Page 8630 “Config. Tables” (source table)
- Page 8631 “Config. Areas” (source table)
- Page 8632 “Config. Worksheet” (source table)
- Page 8639 “Copy Company Data” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 8611 “Config. Package Management” (1 call:
GetRelatedTables → SetFieldFilter)
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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: "Config. Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.