O365 Sales Initial Setup

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

Table Type: Company

Table Name: O365 Sales Initial Setup
Database Table Name: CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 2110

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 O365 Sales Initial Setup can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Primary Key]
   ,[Payment Reg_ Template Name]
   ,[Payment Reg_ Batch Name]
   ,[Is initialized]
   ,[Default Customer Template]
   ,[Default Item Template]
   ,[Default Payment Terms Code]
   ,[Default Payment Method Code]
   ,[Sales Invoice No_ Series]
   ,[Posted Sales Inv_ No_ Series]
   ,[Tax Type]
   ,[Default VAT Bus_ Posting Group]
   ,[Normal VAT Prod_ Posting Gr_]
   ,[Reduced VAT Prod_ Posting Gr_]
   ,[Zero VAT Prod_ Posting Gr_]
   ,[C2Graph Endpoint]
   ,[Sales Quote No_ Series]
   ,[Engage Endpoint]
   ,[Coupons Integration Enabled]
   ,[Graph Enablement Reminder]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in O365 Sales Initial Setup table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Primary Key Primary Key Searchnvarchar(20)
3Payment Reg_ Template Name Searchnvarchar(20)
4Payment Reg_ Batch Name Searchnvarchar(20)
5Is initialized Searchtinyint
6Default Customer Template Searchnvarchar(20)
7Default Item Template Searchnvarchar(20)
8Default Payment Terms Code Searchnvarchar(20)
9Default Payment Method Code Searchnvarchar(20)
10Sales Invoice No_ Series Searchnvarchar(40)
11Posted Sales Inv_ No_ Series Searchnvarchar(40)
12Tax Type Searchint
13Default VAT Bus_ Posting Group Searchnvarchar(40)
14Normal VAT Prod_ Posting Gr_ Searchnvarchar(40)
15Reduced VAT Prod_ Posting Gr_ Searchnvarchar(40)
16Zero VAT Prod_ Posting Gr_ Searchnvarchar(40)
17C2Graph Endpoint Searchnvarchar(500)
18Sales Quote No_ Series Searchnvarchar(40)
19Engage Endpoint Searchnvarchar(500)
20Coupons Integration Enabled Searchtinyint
21Graph Enablement Reminder Searchtinyint
22$systemId Searchuniqueidentifier
23$systemCreatedAt Searchdatetime
24$systemCreatedBy Searchuniqueidentifier
25$systemModifiedAt Searchdatetime
26$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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