G_L Entry – VAT Entry Link

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

Table Type: Company

Table Name: G_L Entry – VAT Entry Link
Database Table Name: CRONUS UK Ltd_$G_L Entry – VAT Entry Link$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 0

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 G_L Entry – VAT Entry Link can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$G_L Entry - VAT Entry Link$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

FROM
   [CRONUS UK Ltd_$G_L Entry - VAT Entry Link$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in G_L Entry – VAT Entry Link table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2G_L Entry No_ Primary Key Searchint
3VAT Entry No_ Primary Key Searchint
4$systemId Searchuniqueidentifier
5$systemCreatedAt Searchdatetime
6$systemCreatedBy Searchuniqueidentifier
7$systemModifiedAt Searchdatetime
8$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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