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
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 ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Code  | nvarchar(40) | ||||
| 3 | Name | nvarchar(200) | ||||
| 4 | Currency Code | nvarchar(20) | ||||
Key to join to the Currency table.Show/hide example querySELECT
[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] | ||||||
| 5 | Inbox Type | int | ||||
| 6 | Inbox Details | nvarchar(500) | ||||
| 7 | Receivables Account | nvarchar(40) | ||||
| 8 | Payables Account | nvarchar(40) | ||||
| 9 | Blocked | tinyint | ||||
| 10 | Customer No_ | nvarchar(40) | ||||
Key to join to the Customer table.Show/hide example querySELECT
[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_] | ||||||
| 11 | Vendor No_ | nvarchar(40) | ||||
Key to join to the Vendor table.Show/hide example querySELECT
[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_] | ||||||
| 12 | Outbound Sales Item No_ Type | int | ||||
| 13 | Outbound Purch_ Item No_ Type | int | ||||
| 14 | Cost Distribution in LCY | tinyint | ||||
| 15 | Auto_ Accept Transactions | tinyint | ||||
| 16 | $systemId | uniqueidentifier | ||||
| 17 | $systemCreatedAt | datetime | ||||
| 18 | $systemCreatedBy | uniqueidentifier | ||||
| 19 | $systemModifiedAt | datetime | ||||
| 20 | $systemModifiedBy | uniqueidentifier | ||||
Show/hide tables related from IC Partner table
Show/hide tables related to IC Partner table
Adjust Exchange Rate BufferCompany InformationCustomerCustomer Templ_Cust_ Ledger EntryGen_ Journal LineG_L EntryHandled IC Inbox Jnl_ LineHandled IC Inbox Purch_ HeaderHandled IC Inbox Purch_ LineHandled IC Inbox Sales HeaderHandled IC Inbox Sales LineHandled IC Inbox Trans_Handled IC Outbox Jnl_ LineHandled IC Outbox Purch_ HdrHandled IC Outbox Purch_ LineHandled IC Outbox Sales HeaderHandled IC Outbox Sales LineHandled IC Outbox Trans_IC Comment LineIC Document DimensionIC Inbox Jnl_ LineIC Inbox Purchase HeaderIC Inbox Purchase LineIC Inbox Sales HeaderIC Inbox Sales LineIC Inbox TransactionIC Inbox_Outbox Jnl_ Line Dim_IC Outbox Jnl_ LineIC Outbox Purchase HeaderIC Outbox Purchase LineIC Outbox Sales HeaderIC Outbox Sales LineIC Outbox TransactionIC SetupPosted Gen_ Journal LinePurchase LinePurchase Line ArchivePurch_ Cr_ Memo LinePurch_ Inv_ LineSales Cr_Memo LineSales Invoice LineSales LineSales Line ArchiveStandard General Journal LineVendorVendor Ledger Entry