COHUB Company KPI – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables CCOHUB Company KPI

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

Table Type: System

Table Name: COHUB Company KPI
Database Table Name:

Table Number: 1151

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 COHUB Company KPI can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

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

SELECT
   *
FROM
   [] AS [COHUB Company KPI]
LEFT JOIN
   [Company] AS [Company]
      ON
         [COHUB Company KPI].[Company Name] = [Company].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [COHUB Company KPI].[Assigned To] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [COHUB Company KPI].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [COHUB Company KPI].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in COHUB Company KPI table

Field No.	Field Name	Field Caption	Class	Type	Length
1	Enviroment No.	Enviroment No.	Normal	Code	20
2	Company Name	Company Name	Normal	Text	50
	Key to join to the Company table. Show/hide example query SELECT [COHUB Company KPI].[] ,[Company].[Name] FROM [] AS [COHUB Company KPI] LEFT JOIN [Company] AS [Company] ON [COHUB Company KPI].[] = [Company].[Name]
4	Company Display Name	Company Display Name	Normal	Text	50
5	Assigned To	Assigned To	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [COHUB Company KPI].[] ,[User].[User Security ID] FROM [] AS [COHUB Company KPI] LEFT JOIN [User] AS [User] ON [COHUB Company KPI].[] = [User].[User Security ID]
100	Overdue Sales Documents	Overdue Sales Documents	Normal	Text	30
101	Purchase Documents Due Today	Purchase Documents Due Today	Normal	Text	30
102	POs Pending Approval	POs Pending Approval	Normal	Text	30
103	SOs Pending Approval	SOs Pending Approval	Normal	Text	30
104	Approved Sales Orders	Approved Sales Orders	Normal	Text	30
105	Approved Purchase Orders	Approved Purchase Orders	Normal	Text	30
106	Vendors – Payment on Hold	Vendors – Payment on Hold	Normal	Text	30
107	Purchase Return Orders	Purchase Return Orders	Normal	Text	30
108	Sales Return Orders – All	Sales Return Orders – All	Normal	Text	30
109	Enviroments – Blocked	Enviroments – Blocked	Normal	Text	30
110	Overdue Purchase Documents	Overdue Purchase Documents	Normal	Text	30
111	Purchase Discounts Next Week	Purchase Discounts Next Week	Normal	Text	30
112	Purch. Invoices Due Next Week	Purch. Invoices Due Next Week	Normal	Text	30
113	New Incoming Documents	New Incoming Documents	Normal	Text	30
114	Approved Incoming Documents	Approved Incoming Documents	Normal	Text	30
115	OCR Pending	OCR Pending	Normal	Text	30
116	OCR Completed	OCR Completed	Normal	Text	30
117	Requests to Approve	Requests to Approve	Normal	Text	30
118	Requests Sent for Approval	Requests Sent for Approval	Normal	Text	30
119	Non-Applied Payments	Non-Applied Payments	Normal	Text	30
120	Cash Accounts Balance	Cash Accounts Balance	Normal	Text	30
121	Last Depreciated Posted Date	Last Depreciated Posted Date	Normal	Text	30
130	Environment Name	Environment Name	FlowField	Text	100
200	Ongoing Sales Invoices	Ongoing Sales Invoices	Normal	Text	30
201	Ongoing Purchase Invoices	Ongoing Purchase Invoices	Normal	Text	30
202	Sales This Month	Sales This Month	Normal	Text	30
203	Top 10 Company Sales YTD	Top 10 Company Sales YTD	Normal	Text	30
204	Overdue Purch. Invoice Amount	Overdue Purch. Invoice Amount	Normal	Text	30
205	Overdue Sales Invoice Amount	Overdue Sales Invoice Amount	Normal	Text	30
206	Average Collection Days	Average Collection Days	Normal	Text	30
207	Ongoing Sales Quotes	Ongoing Sales Quotes	Normal	Text	30
208	Sales Inv. – Pending Doc.Exch.	Sales Invoices – Pending Document Exchange	Normal	Text	30
209	Sales CrM. – Pending Doc.Exch.	Sales Credit Memos – Pending Document Exchange	Normal	Text	30
210	My Incoming Documents	My Incoming Documents	Normal	Text	30
211	Sales Invoices Due Next Week	Sales Invoices Due Next Week	Normal	Text	30
212	Ongoing Sales Orders	Ongoing Sales Orders	Normal	Text	30
213	Inc. Doc. Awaiting Verfication	Inc. Doc. Awaiting Verification	Normal	Text	30
214	Purchase Orders	Purchase Orders	Normal	Text	30
215	Last Login Date	Last Login Date	Normal	Text	30
216	Contact Name	Contact Name	Normal	Text	50
300	Overdue Sales Documents Style	Overdue Sales Documents Style	Normal	Text	30
301	Purch. Docs Due Today Style	Purch. Docs Due Today Style	Normal	Text	30
302	POs Pending Approval Style	POs Pending Approval Style	Normal	Text	30
303	SOs Pending Approval Style	SOs Pending Approval Style	Normal	Text	30
304	Approved Sales Orders Style	Approved Sales Orders Style	Normal	Text	30
305	Approved Purchase Orders Style	Approved Purchase Orders Style	Normal	Text	30
306	Vendors-Payment on Hold Style	Vendors-Payment on Hold Style	Normal	Text	30
307	Purchase Return Orders Style	Purchase Return Orders Style	Normal	Text	30
308	Sales Return Orders-All Style	Sales Return Orders-All Style	Normal	Text	30
309	Enviroments – Blocked Style	Enviroments – Blocked Style	Normal	Text	30
310	Overdue Purch. Docs Style	Overdue Purch. Docs Style	Normal	Text	30
311	Purch. Disc Next Week Style	Purch. Disc Next Week Style	Normal	Text	30
312	Purch. Inv Due Next Week Style	Purch. Inv Due Next Week Style	Normal	Text	30
313	New Incoming Documents Style	New Incoming Documents Style	Normal	Text	30
314	Approved Incoming Docs Style	Approved Incoming Docs Style	Normal	Text	30
315	OCR Pending Style	OCR Pending Style	Normal	Text	30
316	OCR Completed Style	OCR Completed Style	Normal	Text	30
317	Requests to Approve Style	Requests to Approve Style	Normal	Text	30
318	Req Sent for Approval Style	Req Sent for Approval Style	Normal	Text	30
319	Non-Applied Payments Style	Non-Applied Payments Style	Normal	Text	30
320	Cash Accounts Balance Style	Cash Accounts Balance Style	Normal	Text	30
321	Last Dep Posted Date Style	Last Dep Posted Date Style	Normal	Text	30
400	Ongoing Sales Invoices Style	Ongoing Sales Invoices Style	Normal	Text	30
401	Ongoing Purch. Invoices Style	Ongoing Purch. Invoices Style	Normal	Text	30
402	Sales This Month Style	Sales This Month Style	Normal	Text	30
403	Top 10 Cust Sales YTD Style	Top 10 Cust Sales YTD Style	Normal	Text	30
404	Overdue Purch. Inv Amt Style	Overdue Purch. Inv Amt Style	Normal	Text	30
405	Overdue Sales Inv Amt Style	Overdue Sales Inv Amt Style	Normal	Text	30
406	Average Collection Days Style	Average Collection Days Style	Normal	Text	30
407	Ongoing Sales Quotes Style	Ongoing Sales Quotes Style	Normal	Text	30
408	Sales Inv-Pend DocExch Style	Sales Invoices – Pending Document Exchange	Normal	Text	30
409	Sales CrM-Pend DocExch Style	Sales Credit Memos – Pending Document Exchange	Normal	Text	30
410	My Incoming Documents Style	My Incoming Documents Style	Normal	Text	30
411	Sales Inv Due Next Week Style	Sales Inv Due Next Week Style	Normal	Text	30
412	Ongoing Sales Orders Style	Ongoing Sales Orders Style	Normal	Text	30
413	Inc Doc Awaiting Verf Style	Inc Doc Awaiting Verf Style	Normal	Text	30
414	Purchase Orders Style	Purchase Orders Style	Normal	Text	30
415	Last Login Date Style	Last Login Date Style	Normal	Text	30
416	Contact Name Style	Contact Name Style	Normal	Text	50
500	Last Refreshed	Last Refreshed	Normal	DateTime	8
501	My User Task Style	My User Task Style	Normal	Text	30
502	Group Code	Group Code	FlowField	Code	20
510	Currency Symbol	Currency Symbol	Normal	Text	10
511	Cash Accounts Balance Decimal	Cash Accounts Balance Decimal	Normal	Decimal	12
512	Overdue Purch. Inv. Amt. Dec.	Overdue Purch. Inv. Amt. Dec.	Normal	Decimal	12
513	Overdue Sales Inv. Amt. Dec.	Overdue Sales Inv. Amt. Dec.	Normal	Decimal	12
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [COHUB Company KPI].[] ,[User].[User Security ID] FROM [] AS [COHUB Company KPI] LEFT JOIN [User] AS [User] ON [COHUB Company KPI].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16