IC Partner – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IIC 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	20	Code	nvarchar(40)
2	Name	Name	Normal	Text	100	Name	nvarchar(200)
3	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(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]
4	Inbox Type	Inbox Type	Normal	Option	4	Inbox Type	int
	Available options are: “File Location” “Database” “Email” “No IC Transfer”
5	Inbox Details	Inbox Details	Normal	Text	250	Inbox Details	nvarchar(500)
6	Receivables Account	Receivables Account	Normal	Code	20	Receivables Account	nvarchar(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_]
7	Payables Account	Payables Account	Normal	Code	20	Payables Account	nvarchar(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_]
8	Country/Region Code	Country/Region Code	Normal	Code	10	Country_Region Code	nvarchar(20)
10	Blocked	Blocked	Normal	Boolean	4	Blocked	tinyint
11	Comment	Comment	FlowField	Boolean	4
12	Customer No.	Customer No.	Normal	Code	20	Customer 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_]
13	Vendor No.	Vendor No.	Normal	Code	20	Vendor 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_]
14	Outbound Sales Item No. Type	Outbound Sales Item No. Type	Normal	Option	4	Outbound Sales Item No_ Type	int
	Available options are: “Internal No.” “Common Item No.” “Cross Reference”
15	Outbound Purch. Item No. Type	Outbound Purch. Item No. Type	Normal	Option	4	Outbound Purch_ Item No_ Type	int
	Available options are: “Internal No.” “Common Item No.” “Cross Reference” “Vendor Item No.”
16	Cost Distribution in LCY	Cost Distribution in $	Normal	Boolean	4	Cost Distribution in LCY	tinyint
17	Auto. Accept Transactions	Auto. Accept Transactions	Normal	Boolean	4	Auto_ Accept Transactions	tinyint
18	Data Exchange Type	Data Exchange Type	Normal	Option	4	Data Exchange Type	int
	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”
100	Connection Url Key	Connection URL Key	Normal	GUID	16	Connection Url Key	uniqueidentifier
101	Company Id Key	Company ID Key	Normal	GUID	16	Company Id Key	uniqueidentifier
102	Client Id Key	Client ID Key	Normal	GUID	16	Client Id Key	uniqueidentifier
103	Client Secret Key	Client Secret Key	Normal	GUID	16	Client Secret Key	uniqueidentifier
104	Authority Url Key	Authority URL Key	Normal	GUID	16	Authority Url Key	uniqueidentifier
105	Redirect Url key	Redirect URL Key	Normal	GUID	16	Redirect Url key	uniqueidentifier
106	Token Key	Client Secret Key	Normal	GUID	16	Token Key	uniqueidentifier
107	Token Expiration Time	Token Expiration Time	Normal	DateTime	8	Token Expiration Time	datetime
108	Token Endpoint Key	Token Endpoint Key	Normal	GUID	16	Token Endpoint Key	uniqueidentifier
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from IC Partner table

Dynamics 365 BC Table Reference Tables Company Tables IIC Partner

Leave a Reply Cancel reply