Standard Customer Sales Code

Dynamics 365 BC Table ReferenceTablesCompany TablesSStandard Customer Sales Code

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

Table Type: Company

Table Name: Standard Customer Sales Code
Database Table Name: CRONUS UK Ltd_$Standard Customer Sales Code$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 172

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 Standard Customer Sales Code can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Standard Customer Sales Code$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Customer No_]
   ,[Code]
   ,[Description]
   ,[Valid From Date]
   ,[Valid To date]
   ,[Payment Method Code]
   ,[Payment Terms Code]
   ,[Direct Debit Mandate ID]
   ,[Blocked]
   ,[Currency Code]
   ,[Insert Rec_ Lines On Quotes]
   ,[Insert Rec_ Lines On Orders]
   ,[Insert Rec_ Lines On Invoices]
   ,[Insert Rec_ Lines On Cr_ Memos]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Standard Customer Sales Code$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

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

Show/hide columns in Standard Customer Sales Code table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Customer No. Primary Key SearchCustomer No.NormalCode20Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Standard Customer Sales Code].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Standard Customer Sales Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Customer Sales Code]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Standard Customer Sales Code].[Customer No_] = [Customer].[No_]
2Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
3Description SearchDescriptionNormalText100Descriptionnvarchar(200)
4Valid From Date SearchValid From DateNormalDate4Valid From Datedatetime
5Valid To date SearchValid To dateNormalDate4Valid To datedatetime
6Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Standard Customer Sales Code].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Standard Customer Sales Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Customer Sales Code]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Standard Customer Sales Code].[Payment Method Code] = [Payment Method].[Code]
7Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Standard Customer Sales Code].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Standard Customer Sales Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Customer Sales Code]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Standard Customer Sales Code].[Payment Terms Code] = [Payment Terms].[Code]
8Direct Debit Mandate ID SearchDirect Debit Mandate IDNormalCode35Direct Debit Mandate IDnvarchar(70)
9Blocked SearchBlockedNormalBoolean4Blockedtinyint
13Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Standard Customer Sales Code].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Standard Customer Sales Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Customer Sales Code]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Standard Customer Sales Code].[Currency Code] = [Currency].[Code]
15Insert Rec. Lines On Quotes SearchInsert Rec. Lines On QuotesNormalOption4Insert Rec_ Lines On Quotesint
Available options are:
  • “Manual”
  • “Automatic”
  • “Always Ask”
16Insert Rec. Lines On Orders SearchInsert Rec. Lines On OrdersNormalOption4Insert Rec_ Lines On Ordersint
Available options are:
  • “Manual”
  • “Automatic”
  • “Always Ask”
17Insert Rec. Lines On Invoices SearchInsert Rec. Lines On InvoicesNormalOption4Insert Rec_ Lines On Invoicesint
Available options are:
  • “Manual”
  • “Automatic”
  • “Always Ask”
18Insert Rec. Lines On Cr. Memos SearchInsert Rec. Lines On Cr. MemosNormalOption4Insert Rec_ Lines On Cr_ Memosint
Available options are:
  • “Manual”
  • “Automatic”
  • “Always Ask”
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
       [Standard Customer Sales Code].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Standard Customer Sales Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Customer Sales Code]
LEFT JOIN
       [User] AS [User]
              ON
                     [Standard Customer Sales Code].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Standard Customer Sales Code].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Standard Customer Sales Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Standard Customer Sales Code]
LEFT JOIN
       [User] AS [User]
              ON
                     [Standard Customer Sales Code].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Standard Customer Sales Code table

CurrencyPayment MethodPayment Terms
Dynamics 365 BC Table ReferenceTablesCompany TablesSStandard Customer Sales Code

Leave a Reply

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