IC Partner

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

Table Type: Company

Table Name: IC Partner
Database Table Name: CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 413

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 IC Partner can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Name]
   ,[Currency Code]
   ,[Inbox Type]
   ,[Inbox Details]
   ,[Receivables Account]
   ,[Payables Account]
   ,[Blocked]
   ,[Customer No_]
   ,[Vendor No_]
   ,[Outbound Sales Item No_ Type]
   ,[Outbound Purch_ Item No_ Type]
   ,[Cost Distribution in LCY]
   ,[Auto_ Accept Transactions]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [IC Partner].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [IC Partner].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [IC Partner].[Vendor No_] = [Vendor].[No_]

Show/hide columns in IC Partner table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Name Searchnvarchar(200)
4Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [IC Partner].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [IC Partner].[Currency Code] = [Currency].[Code]
5Inbox Type Searchint
6Inbox Details Searchnvarchar(500)
7Receivables Account Searchnvarchar(40)
8Payables Account Searchnvarchar(40)
9Blocked Searchtinyint
10Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [IC Partner].[Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [IC Partner].[Customer No_] = [Customer].[No_]
11Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [IC Partner].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [IC Partner].[Vendor No_] = [Vendor].[No_]
12Outbound Sales Item No_ Type Searchint
13Outbound Purch_ Item No_ Type Searchint
14Cost Distribution in LCY Searchtinyint
15Auto_ Accept Transactions Searchtinyint
16$systemId Searchuniqueidentifier
17$systemCreatedAt Searchdatetime
18$systemCreatedBy Searchuniqueidentifier
19$systemModifiedAt Searchdatetime
20$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from IC Partner table

Show/hide tables related to IC Partner table

Leave a Reply

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