Table 135 "Acc. Sched. KPI Web Srv. Setup"
Base Application · Microsoft.Finance.FinancialReports
Across versions
- BC23present
- BC24declaration changed
- BC25unchanged
- BC261 fields changed
- BC27-28unchanged
- BC297 fields changed
- BC30unchanged
Neighbourhood 12 connected objects and pages
Base Application · Microsoft.Finance.FinancialReports · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 195 “Acc. Sched. KPI Web Srv. Setup” (6 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Acc. Sched. KPI Web Srv. Setup |
| 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 | Primary Key Δ BC26 | Code[10] | — | |
| 2 | Forecasted Values Start Δ BC29 | Option | Specifies at what point in time forecasted values are shown on the financial-report KPI graphic. The forecasted values are retrieved from the selected general ledger budget. | OptionCaption: After Latest Closed Period,After Current Date |
| 3 | G/L Budget Name Δ BC29 | Code[10] | Specifies the name of the general ledger budget that provides budgeted values to the financial-report KPI web service. | TableRelation Table 95 “G/L Budget Name” (G/L Budget Name) |
| 4 | Period Δ BC29 | Option | Specifies the period that the financial-report KPI web service is based on. | OptionCaption: Fiscal Year - Last Locked Period,Current Fiscal Year,Current Calendar Year,Current Calendar Quarter,Current Month,Today,Current Period,Last Locked Period,Current Fiscal Year + 3 Previous Years |
| 5 | View By Δ BC29 | Option | Specifies which time interval the financial-report KPI is shown in. | OptionCaption: Day,Week,Month,Quarter,Year,Period |
| 6 | Web Service Name Δ BC29 | Text[240] | Specifies the name of the financial-report KPI web service. This name will be shown under the displayed financial-report KPI. | |
| 7 | Published Δ BC29 | Boolean | Specifies if the financial-report KPI web service has been published. Published web services are listed in the Web Services window. | FlowField: exist(“Web Service” where(“Object Type” = const(Page), “Object ID” = const(197), Published = const(true))); not editable |
| 8 | Data Last Updated Δ BC29 | DateTime | Specifies the last time data was refreshed through the web service. | not editable; DataClassification SystemMetadata |
| 9 | Last G/L Entry Included | Integer | — | not editable; DataClassification SystemMetadata |
| 10 | Data Time To Live (hours) | Integer | Specifies how long data is stored in Business Central before being refreshed from the service. The longer the duration is the smaller the performance impact. via Page 195 “Acc. Sched. KPI Web Srv. Setup” |
Keys
- Key1: Primary Key (clustered)
Trigger event subscribers
- OnAfterModifyEvent: Codeunit 198 “Acc. Sched. KPI Event Handler” OnModifyAccSchedKpiSetup
Procedures
GetPeriodLength(var NoOfLines: Integer; var StartDate: Date; var EndDate: Date): Calculates period length and date range based on the configured period type. Determines start date, end date, and number of time segments for KPI data collection.CalcNextStartDate(OrgStartDate: Date; OffSet: Integer): Date: Calculates the next start date based on the original start date and offset value. Handles different view-by periods including accounting periods, years, quarters, months, weeks, and days.GetLastClosedAccDate(): Date: Retrieves the last closed accounting date based on general ledger setup. Returns the date before the allow posting from date or work date if not set.GetLastBudgetChangedDate(): Date: Retrieves the last modification date from G/L budget entries for the configured budget. Returns the most recent change date or zero date if no budget entries exist.PublishWebService()DeleteWebService()
Plus 4 local procedures.
Triggers
OnDelete, OnInsert, OnModify
Relations
- G/L Budget Name: TableRelation Table 95 “G/L Budget Name”
Pages and codeunits on this table
- Page 195 “Acc. Sched. KPI Web Srv. Setup” (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 457 “Environment Information” (2 calls:
DeleteWebService → IsSaaS,PublishWebService → IsSaaS) - Codeunit 9750 “Web Service Management” (2 calls:
PublishWebService → CreateTenantWebService,PublishWebService → CreateWebService) - Codeunit 198 “Acc. Sched. KPI Event Handler” (1 call:
DeleteWebService → ResetAccSchedKPIWevSrvSetup)
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: "Acc. Sched. KPI Web Srv. Setup"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.