Standard 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
   [timestamp]
   ,[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_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Standard Customer Sales Code].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] 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]

Show/hide columns in Standard Customer Sales Code table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Customer No_ Primary Key Searchnvarchar(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_]
3Code Primary Key Searchnvarchar(20)
4Description Searchnvarchar(200)
5Valid From Date Searchdatetime
6Valid To date Searchdatetime
7Payment Method Code Searchnvarchar(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] AS [Payment Method]
              ON
                     [Standard Customer Sales Code].[Payment Method Code] = [Payment Method].[Code]
8Payment Terms Code Searchnvarchar(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]
9Direct Debit Mandate ID Searchnvarchar(70)
10Blocked Searchtinyint
11Currency Code Searchnvarchar(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]
12Insert Rec_ Lines On Quotes Searchint
13Insert Rec_ Lines On Orders Searchint
14Insert Rec_ Lines On Invoices Searchint
15Insert Rec_ Lines On Cr_ Memos Searchint
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Standard Customer Sales Code table

Leave a Reply

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