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
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 ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Code  | nvarchar(40) |
| 3 | Name | nvarchar(100) |
| 4 | Commission _ | decimal(38,38) |
| 5 | Image | uniqueidentifier |
| 6 | Privacy Blocked | tinyint |
| 7 | Coupled to CRM | tinyint |
| 8 | Global Dimension 1 Code | nvarchar(40) |
| 9 | Global Dimension 2 Code | nvarchar(40) |
| 10 | E-Mail | nvarchar(160) |
| 11 | Phone No_ | nvarchar(60) |
| 12 | Job Title | nvarchar(60) |
| 13 | Search E-Mail | nvarchar(160) |
| 14 | E-Mail 2 | nvarchar(160) |
| 15 | $systemId | uniqueidentifier |
| 16 | $systemCreatedAt | datetime |
| 17 | $systemCreatedBy | uniqueidentifier |
| 18 | $systemModifiedAt | datetime |
| 19 | $systemModifiedBy | uniqueidentifier |
Show/hide tables related to Salesperson_Purchaser table
CampaignCampaign EntryContactCustomerCustomer Templ_Cust_ Ledger EntryCV Ledger Entry BufferFiled Service Contract HeaderInteraction Log EntryInteraction Merge DataInvt_ Shipment HeaderOpportunityOpportunity EntryReturn Receipt HeaderSales Cr_ Memo Entity BufferSales Cr_Memo HeaderSales HeaderSales Header ArchiveSales Invoice Entity AggregateSales Invoice HeaderSales Order Entity BufferSales Quote Entity BufferSales Shipment HeaderSegment HeaderSegment LineService Contract HeaderService Cr_Memo HeaderService HeaderService Invoice HeaderService Shipment HeaderTeam SalespersonTo-do