Salesperson_Purchaser

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

Table Type: Company

Table Name: Salesperson_Purchaser
Database Table Name: CRONUS UK Ltd_$Salesperson_Purchaser$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 Salesperson_Purchaser can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Name]
   ,[Commission _]
   ,[Image]
   ,[Privacy Blocked]
   ,[Coupled to CRM]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[E-Mail]
   ,[Phone No_]
   ,[Job Title]
   ,[Search E-Mail]
   ,[E-Mail 2]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Salesperson_Purchaser table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Name Searchnvarchar(100)
4Commission _ Searchdecimal(38,38)
5Image Searchuniqueidentifier
6Privacy Blocked Searchtinyint
7Coupled to CRM Searchtinyint
8Global Dimension 1 Code Searchnvarchar(40)
9Global Dimension 2 Code Searchnvarchar(40)
10E-Mail Searchnvarchar(160)
11Phone No_ Searchnvarchar(60)
12Job Title Searchnvarchar(60)
13Search E-Mail Searchnvarchar(160)
14E-Mail 2 Searchnvarchar(160)
15$systemId Searchuniqueidentifier
16$systemCreatedAt Searchdatetime
17$systemCreatedBy Searchuniqueidentifier
18$systemModifiedAt Searchdatetime
19$systemModifiedBy Searchuniqueidentifier

Show/hide tables related to Salesperson_Purchaser table

Leave a Reply

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