Table 87 "Date Compr. Register"
Base Application · Microsoft.Foundation.Period
Across versions
- BC23present
- BC241 fields changed
- BC25-28unchanged
- BC2915 fields changed
- BC30unchanged
Neighbourhood 7 connected objects and pages
Base Application · Microsoft.Foundation.Period · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 107 “Date Compr. Registers” (1 Learn page).
Properties
| Property | Value |
|---|---|
| Caption | Date Compr. Register |
| 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 | No. Δ BC29 | Integer | Specifies the number of the involved entry or record, according to the specified number series. | |
| 2 | Creation Date Δ BC29 | Date | Specifies the date that the date compression took place. | |
| 3 | Table Caption Δ BC24 Δ BC29 | Text[250] | Specifies the name of the table that was compressed. | FlowField: lookup(AllObjWithCaption.“Object Caption” where(“Object Type” = const(Table), “Object ID” = field(“Table ID”))); not editable |
| 4 | Period Length Δ BC29 | Option | Specifies the time interval of entries combined into one for the period defined in the Starting Date and Ending Date fields in the batch job. | OptionCaption: Day,Week,Month,Quarter,Year,Period |
| 5 | Ending Date Δ BC29 | Date | Specifies the last date in the period for which entries were compressed. | |
| 6 | No. of New Records Δ BC29 | Integer | Specifies the number of new entries that were created by the date compression. | |
| 7 | No. Records Deleted Δ BC29 | Integer | Specifies the number of entries that were deleted during the date compression. | |
| 8 | User ID Δ BC29 | Code[50] | Specifies the ID of the user who posted the entry, to be used, for example, in the change log. | TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation |
| 9 | Filter Δ BC29 | Text[250] | Specifies the filters that were placed on the date compression. | |
| 10 | Starting Date Δ BC29 | Date | Specifies the first date in the period for which entries were compressed. | |
| 11 | Table ID Δ BC29 | Integer | Specifies the number of the table that was compressed. | TableRelation AllObjWithCaption.“Object ID” where(“Object Type” = const(Table)) |
| 12 | Register No. Δ BC29 | Integer | Specifies the number of the register that was created by the date compression and that contains the compressed entries. | TableRelation Table 240 “Resource Register”, Table 45 “G/L Register”, Table 46 “Item Register” (if (“Table ID” = const(17)) “G/L Register” else if (“Table ID” = const(21)) “G/L Register” else if (“Table ID” = const(25)) “G/L Register” else if (“Table ID” = const(254)) “G/L Register” else if (“Table ID” = const(32)) “Item Register” else if (“Table ID” = const(203)) “Resource Register” else if (…) |
| 13 | Source Code Δ BC29 | Code[10] | Specifies the source code that specifies where the entry was created. | TableRelation Table 230 “Source Code” (Source Code) |
| 14 | Retain Field Contents Δ BC29 | Text[80] | Specifies a list of the fields whose contents the user chose to retain in the date compression. | |
| 15 | Retain Totals Δ BC29 | Text[80] | Specifies a list of the quantity fields that the user chose to retain when they ran the date compression batch job. |
Keys
- Key1: No. (clustered)
- Key2: Table ID
- Key3: Table ID, Ending Date
Procedures
GetLastEntryNo(): IntegerInitRegister(TableID: Integer; RegNo: Integer; StartingDate: Date; EndingDate: Date; PeriodLength: Integer; EntryFilter: Text[250]; RelatedRegNo: Integer; SourceCode: Code[10])CheckMaxDateCompressed(MaxPostingDate: Date; Type: Option Unapply,Reversal)
Plus 1 local procedures.
Relations
- lookup page Page 107 “Date Compr. Registers”
- Source Code: TableRelation Table 230 “Source Code”
- Register No.: TableRelation Table 240 “Resource Register” (conditional)
- Register No.: TableRelation Table 45 “G/L Register” (conditional)
- Register No.: TableRelation Table 46 “Item Register” (conditional)
Pages and codeunits on this table
- Page 107 “Date Compr. Registers” (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 703 “Find Record Management” (1 call:
GetLastEntryNo → GetLastEntryIntFieldValue)
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: "Date Compr. Register"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.