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
   [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 an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Sales Initial Setup]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [O365 Sales Initial Setup].[Default Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [O365 Sales Initial Setup].[Default Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [O365 Sales Initial Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [O365 Sales Initial Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in O365 Sales Initial Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
2Payment Reg. Template Name Primary Key SearchPayment Reg. Template NameNormalCode10Payment Reg_ Template Namenvarchar(20)
Key to join to the Gen. Journal Template table.

Show/hide example query

SELECT
	       [O365 Sales Initial Setup].[Payment Reg_ Template Name]
	       ,[Gen. Journal Template].[Name]
	FROM
	       [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Sales Initial Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Journal Template]
	              ON
	                     [O365 Sales Initial Setup].[Payment Reg_ Template Name] = [Gen. Journal Template].[Name]
3Payment Reg. Batch Name SearchPayment Reg. Batch NameNormalCode10Payment Reg_ Batch Namenvarchar(20)
4Is initialized SearchIs initializedNormalBoolean4Is initializedtinyint
5Default Customer Template SearchDefault Customer TemplateNormalCode10Default Customer Templatenvarchar(20)
6Default Item Template SearchDefault Item TemplateNormalCode10Default Item Templatenvarchar(20)
7Default Payment Terms Code SearchDefault Payment Terms CodeNormalCode10Default Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
	       [O365 Sales Initial Setup].[Default Payment Terms Code]
	       ,[Payment Terms].[Code]
	FROM
	       [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Sales Initial Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
	              ON
	                     [O365 Sales Initial Setup].[Default Payment Terms Code] = [Payment Terms].[Code]
8Default Payment Method Code SearchDefault Payment Method CodeNormalCode10Default Payment Method Codenvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
	       [O365 Sales Initial Setup].[Default Payment Method Code]
	       ,[Payment Method].[Code]
	FROM
	       [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Sales Initial Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
	              ON
	                     [O365 Sales Initial Setup].[Default Payment Method Code] = [Payment Method].[Code]
9Sales Invoice No. Series SearchSales Invoice No. SeriesNormalCode20Sales Invoice No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [O365 Sales Initial Setup].[Sales Invoice No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Sales Initial Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [O365 Sales Initial Setup].[Sales Invoice No_ Series] = [No. Series].[Code]
10Posted Sales Inv. No. Series SearchPosted Sales Inv. No. SeriesNormalCode20Posted Sales Inv_ No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [O365 Sales Initial Setup].[Posted Sales Inv_ No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Sales Initial Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [O365 Sales Initial Setup].[Posted Sales Inv_ No_ Series] = [No. Series].[Code]
11Tax Type SearchTax TypeNormalOption4Tax Typeint
Available options are:
  • “VAT”
  • “Sales Tax”
12Default VAT Bus. Posting Group SearchDefault VAT Bus. Posting GroupNormalCode20Default VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
	       [O365 Sales Initial Setup].[Default VAT Bus_ Posting Group]
	       ,[VAT Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Sales Initial Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
	              ON
	                     [O365 Sales Initial Setup].[Default VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
13Normal VAT Prod. Posting Gr. SearchNormal Tax Prod. Posting Gr.NormalCode20Normal VAT Prod_ Posting Gr_nvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
	       [O365 Sales Initial Setup].[Normal VAT Prod_ Posting Gr_]
	       ,[VAT Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Sales Initial Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
	              ON
	                     [O365 Sales Initial Setup].[Normal VAT Prod_ Posting Gr_] = [VAT Product Posting Group].[Code]
14Reduced VAT Prod. Posting Gr. SearchReduced Tax Prod. Posting Gr.NormalCode20Reduced VAT Prod_ Posting Gr_nvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
	       [O365 Sales Initial Setup].[Reduced VAT Prod_ Posting Gr_]
	       ,[VAT Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Sales Initial Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
	              ON
	                     [O365 Sales Initial Setup].[Reduced VAT Prod_ Posting Gr_] = [VAT Product Posting Group].[Code]
15Zero VAT Prod. Posting Gr. SearchZero Tax Prod. Posting Gr.NormalCode20Zero VAT Prod_ Posting Gr_nvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
	       [O365 Sales Initial Setup].[Zero VAT Prod_ Posting Gr_]
	       ,[VAT Product Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Sales Initial Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
	              ON
	                     [O365 Sales Initial Setup].[Zero VAT Prod_ Posting Gr_] = [VAT Product Posting Group].[Code]
16C2Graph Endpoint SearchC2Graph EndpointNormalText250C2Graph Endpointnvarchar(500)
17Sales Quote No. Series SearchSales Quote No. SeriesNormalCode20Sales Quote No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
	       [O365 Sales Initial Setup].[Sales Quote No_ Series]
	       ,[No. Series].[Code]
	FROM
	       [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Sales Initial Setup]
	LEFT JOIN
	       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
	              ON
	                     [O365 Sales Initial Setup].[Sales Quote No_ Series] = [No. Series].[Code]
18Engage Endpoint SearchEngage EndpointNormalText250Engage Endpointnvarchar(500)
19Coupons Integration Enabled SearchCoupons Integration EnabledNormalBoolean4Coupons Integration Enabledtinyint
20Graph Enablement Reminder SearchGraph Enablement ReminderNormalBoolean4Graph Enablement Remindertinyint
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
	       [O365 Sales Initial Setup].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$O365 Sales Initial Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [O365 Sales Initial Setup]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [O365 Sales Initial Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Leave a Reply

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