VAT Reg_ No_ Srv Config

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

Table Type: Company

Table Name: VAT Reg_ No_ Srv Config
Database Table Name: CRONUS UK Ltd_$VAT Reg_ No_ Srv Config$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 248

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 VAT Reg_ No_ Srv Config can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$VAT Reg_ No_ Srv Config$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Entry No_]
   ,[Enabled]
   ,[Service Endpoint]
   ,[Default Template Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$VAT Reg_ No_ Srv Config$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in VAT Reg_ No_ Srv Config table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3Enabled Searchtinyint
4Service Endpoint Searchnvarchar(500)
5Default Template Code Searchnvarchar(40)
6$systemId Searchuniqueidentifier
7$systemCreatedAt Searchdatetime
8$systemCreatedBy Searchuniqueidentifier
9$systemModifiedAt Searchdatetime
10$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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