Acc_ Sched_ KPI Web Srv_ Setup

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/135

Table Type: Company

Table Name: Acc_ Sched_ KPI Web Srv_ Setup
Database Table Name: CRONUS UK Ltd_$Acc_ Sched_ KPI Web Srv_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 135

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Acc_ Sched_ KPI Web Srv_ Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Acc_ Sched_ KPI Web Srv_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Forecasted Values Start]
   ,[G_L Budget Name]
   ,[Period]
   ,[View By]
   ,[Web Service Name]
   ,[Data Last Updated]
   ,[Last G_L Entry Included]
   ,[Data Time To Live (hours)]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Acc_ Sched_ KPI Web Srv_ Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Acc_ Sched_ KPI Web Srv_ Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Forecasted Values Start Searchint
4G_L Budget Name Searchnvarchar(20)
5Period Searchint
6View By Searchint
7Web Service Name Searchnvarchar(480)
8Data Last Updated Searchdatetime
9Last G_L Entry Included Searchint
10Data Time To Live (hours) Searchint
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *