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
   [Code]
   ,[Name]
   ,[Currency Code]
   ,[Inbox Type]
   ,[Inbox Details]
   ,[Receivables Account]
   ,[Payables Account]
   ,[Country_Region Code]
   ,[Blocked]
   ,[Customer No_]
   ,[Vendor No_]
   ,[Outbound Sales Item No_ Type]
   ,[Outbound Purch_ Item No_ Type]
   ,[Cost Distribution in LCY]
   ,[Auto_ Accept Transactions]
   ,[Data Exchange Type]
   ,[Connection Url Key]
   ,[Company Id Key]
   ,[Client Id Key]
   ,[Client Secret Key]
   ,[Authority Url Key]
   ,[Redirect Url key]
   ,[Token Key]
   ,[Token Expiration Time]
   ,[Token Endpoint Key]
   ,[$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_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [IC Partner].[Receivables Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
      ON
         [IC Partner].[Payables Account] = [G/L Account].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Data Exchange Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exchange Type]
      ON
         [IC Partner].[Data Exchange Type] = [Data Exchange Type].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [IC Partner].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [IC Partner].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in IC Partner table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
2Name SearchNameNormalText100Namenvarchar(200)
3Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
4Inbox Type SearchInbox TypeNormalOption4Inbox Typeint
Available options are:
  • “File Location”
  • “Database”
  • “Email”
  • “No IC Transfer”
5Inbox Details SearchInbox DetailsNormalText250Inbox Detailsnvarchar(500)
6Receivables Account SearchReceivables AccountNormalCode20Receivables Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [IC Partner].[Receivables Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [IC Partner].[Receivables Account] = [G/L Account].[No_]
7Payables Account SearchPayables AccountNormalCode20Payables Accountnvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [IC Partner].[Payables Account]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [IC Partner].[Payables Account] = [G/L Account].[No_]
8Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [IC Partner].[Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [IC Partner].[Country_Region Code] = [Country/Region].[Code]
10Blocked SearchBlockedNormalBoolean4Blockedtinyint
11Comment SearchCommentFlowFieldBoolean4
12Customer No. SearchCustomer No.NormalCode20Customer No_nvarchar(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_]
13Vendor No. SearchVendor No.NormalCode20Vendor No_nvarchar(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_]
14Outbound Sales Item No. Type SearchOutbound Sales Item No. TypeNormalOption4Outbound Sales Item No_ Typeint
Available options are:
  • “Internal No.”
  • “Common Item No.”
  • “Cross Reference”
15Outbound Purch. Item No. Type SearchOutbound Purch. Item No. TypeNormalOption4Outbound Purch_ Item No_ Typeint
Available options are:
  • “Internal No.”
  • “Common Item No.”
  • “Cross Reference”
  • “Vendor Item No.”
16Cost Distribution in LCY SearchCost Distribution in $NormalBoolean4Cost Distribution in LCYtinyint
17Auto. Accept Transactions SearchAuto. Accept TransactionsNormalBoolean4Auto_ Accept Transactionstinyint
18Data Exchange Type SearchData Exchange TypeNormalOption4Data Exchange Typeint
Key to join to the Data Exchange Type table.

Show/hide example query

SELECT
       [IC Partner].[Data Exchange Type]
       ,[Data Exchange Type].[Code]
FROM
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
LEFT JOIN
       [CRONUS UK Ltd_$Data Exchange Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Data Exchange Type]
              ON
                     [IC Partner].[Data Exchange Type] = [Data Exchange Type].[Code]
Available options are:
  • “Database”
  • “API”
100Connection Url Key SearchConnection URL KeyNormalGUID16Connection Url Keyuniqueidentifier
101Company Id Key SearchCompany ID KeyNormalGUID16Company Id Keyuniqueidentifier
102Client Id Key SearchClient ID KeyNormalGUID16Client Id Keyuniqueidentifier
103Client Secret Key SearchClient Secret KeyNormalGUID16Client Secret Keyuniqueidentifier
104Authority Url Key SearchAuthority URL KeyNormalGUID16Authority Url Keyuniqueidentifier
105Redirect Url key SearchRedirect URL KeyNormalGUID16Redirect Url keyuniqueidentifier
106Token Key SearchClient Secret KeyNormalGUID16Token Keyuniqueidentifier
107Token Expiration Time SearchToken Expiration TimeNormalDateTime8Token Expiration Timedatetime
108Token Endpoint Key SearchToken Endpoint KeyNormalGUID16Token Endpoint Keyuniqueidentifier
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
       [IC Partner].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
LEFT JOIN
       [User] AS [User]
              ON
                     [IC Partner].[$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
       [IC Partner].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
LEFT JOIN
       [User] AS [User]
              ON
                     [IC Partner].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from IC Partner table

Leave a Reply

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