Table 3902 "Retention Policy Setup Line"
System Application · System.DataAdministration
Across versions
- BC23-30present
Neighbourhood 6 connected objects and pages
System Application · System.DataAdministration · BC23-30 · source at ea08af5e · facts from BC29
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 | Table ID | Integer | — | not editable; DataClassification SystemMetadata |
| 2 | Table Name | Text[30] | — | FlowField: lookup(AllObjWithCaption.“Object Name” where(“Object Type” = const(Table), “Object ID” = field(“Table Id”))); not editable |
| 3 | Table Caption | Text[249] | — | FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = const(Table), “Object ID” = field(“Table Id”))); not editable |
| 4 | Line No. | Integer | — | not editable; DataClassification SystemMetadata |
| 5 | Enabled | Boolean | Specifies whether the retention policy is enabled for this subset. via Page 3902 “Retention Policy Setup Lines” | DataClassification SystemMetadata |
| 6 | Retention Period | Code[20] | Specifies an identifier for the retention period. via Page 3902 “Retention Policy Setup Lines” | TableRelation Table 3900 “Retention Period” (“Retention Period”.Code); DataClassification SystemMetadata |
| 7 | Date Field No. | Integer | Specifies the number of the date or datetime field on the table used to determine the age of a record. via Page 3902 “Retention Policy Setup Lines” | TableRelation Field.“No.” where(TableNo = field(“Table ID”), “Type” = filter(Date | DateTime)); DataClassification SystemMetadata |
| 8 | Date Field Name | Text[30] | Specifies the name of the date or datetime field on the table used to determine the age of a record. via Page 3902 “Retention Policy Setup Lines” | FlowField: lookup(Field.FieldName where(TableNo = field(“Table ID”), “No.” = field(“Date Field No.”))); not editable |
| 9 | Date Field Caption | Text[80] | Specifies the caption of the date or datetime field on the table used to determine the age of a record. The caption is the translated name of the field. via Page 3902 “Retention Policy Setup Lines” | FlowField: lookup(Field.“Field Caption” where(TableNo = field(“Table ID”), “No.” = field(“Date Field No.”))); not editable |
| 10 | Table Filter | Blob | — | DataClassification CustomerContent |
| 11 | Table Filter Text | Text[2048] | Specifies the filter in text format that defines a subset of records. via Page 3902 “Retention Policy Setup Lines” | DataClassification CustomerContent |
| 12 | Locked | Boolean | Specifies whether the retention policy is editable for this subset. via Page 3902 “Retention Policy Setup Lines” | not editable; DataClassification SystemMetadata |
Keys
- PrimaryKey: Table ID, Line No. (clustered)
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 3912 “Reten. Policy Telemetry Impl.” OnDeleteRetentionPolicySetupLine
- OnAfterInsertEvent: Codeunit 3912 “Reten. Policy Telemetry Impl.” OnInsertRetentionPolicySetupLine
- OnAfterModifyEvent: Codeunit 3912 “Reten. Policy Telemetry Impl.” OnModifyRetentionPolicySetupLine
- OnBeforeDeleteEvent: Codeunit 3902 “Retention Policy Setup” CheckRecordLockedOnRetentionPolicySetupLineOnAfterDelete
- OnBeforeModifyEvent: Codeunit 3902 “Retention Policy Setup” CheckRecordLockedOnRetentionPolicySetupLineOnAfterModify
- OnBeforeRenameEvent: Codeunit 3902 “Retention Policy Setup” ErrorOnBeforeRenameRetentionPolicySetupLine
Procedures
SetTableFilter(): Use this procedure to open a Filter Page Builder page and store the resulting filter in view format on the current record.GetTableFilterView(): Text: Use this procedure to get the filter in view format stored in the current record.GetTableFilterText(): Text[2048]: Use this procedure to get the filter in text format stored in the current record.IsLocked(): Boolean: Use this procedure to verify whether the retention policy setup line is locked.
Relations
- Retention Period: TableRelation Table 3900 “Retention Period”
Pages and codeunits on this table
- Page 3902 “Retention Policy Setup Lines” (source table)
Extended by
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 3902 “Retention Policy Setup” (3 calls:
GetTableFilterText → GetTableFilterText,GetTableFilterView → GetTableFilterView,SetTableFilter → SetTableFilterView)
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: "Retention Policy Setup Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.