COHUB Group Company Summary – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables System Tables CCOHUB Group Company Summary

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

Table Type: System

Table Name: COHUB Group Company Summary
Database Table Name:

Table Number: 1156

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 Group Company Summary 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 Group Company Summary]
LEFT JOIN
   [Company] AS [Company]
      ON
         [COHUB Group Company Summary].[Company Name] = [Company].[Name]
LEFT JOIN
   [User] AS [User]
      ON
         [COHUB Group Company Summary].[Assigned To] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [COHUB Group Company Summary].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [COHUB Group Company Summary].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in COHUB Group Company Summary table

Field No.	Field Name	Field Caption	Class	Type	Length
1	Group Code	Group Code	Normal	Code	20
2	Enviroment No.	Enviroment No.	Normal	Code	20
4	Indent	Indent	Normal	Integer	4
5	Company Display Name	Company Display Name	Normal	Text	50
6	Company Name	Company Name	Normal	Text	50
	Key to join to the Company table. Show/hide example query SELECT [COHUB Group Company Summary].[] ,[Company].[Name] FROM [] AS [COHUB Group Company Summary] LEFT JOIN [Company] AS [Company] ON [COHUB Group Company Summary].[] = [Company].[Name]
7	Cash Accounts Balance	Cash Accounts Balance	FlowField	Text	30
8	Overdue Purch. Invoice Amount	Overdue Purch. Invoice Amount	FlowField	Text	30
9	Overdue Sales Invoice Amount	Overdue Sales Invoice Amount	FlowField	Text	30
10	Last Refreshed	Last Refreshed	FlowField	DateTime	8
11	GroupSortOrder	GroupSortOrder	Normal	Integer	4
12	Assigned To	Assigned To	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [COHUB Group Company Summary].[] ,[User].[User Security ID] FROM [] AS [COHUB Group Company Summary] LEFT JOIN [User] AS [User] ON [COHUB Group Company Summary].[] = [User].[User Security ID]
13	Contact Name	Contact Name	FlowField	Text	50
14	Overdue Sales Documents	Overdue Sales Documents	FlowField	Text	30
15	Purchase Documents Due Today	Purchase Documents Due Today	FlowField	Text	30
16	POs Pending Approval	POs Pending Approval	FlowField	Text	30
17	SOs Pending Approval	SOs Pending Approval	FlowField	Text	30
18	Approved Sales Orders	Approved Sales Orders	FlowField	Text	30
19	Approved Purchase Orders	Approved Purchase Orders	FlowField	Text	30
20	Vendors – Payment on Hold	Vendors – Payment on Hold	FlowField	Text	30
21	Purchase Return Orders	Purchase Return Orders	FlowField	Text	30
22	Sales Return Orders – All	Sales Return Orders – All	FlowField	Text	30
23	Enviroments – Blocked	Enviroments – Blocked	FlowField	Text	30
24	Overdue Purchase Documents	Overdue Purchase Documents	FlowField	Text	30
25	Purchase Discounts Next Week	Purchase Discounts Next Week	FlowField	Text	30
26	Purch. Invoices Due Next Week	Purch. Invoices Due Next Week	FlowField	Text	30
27	New Incoming Documents	New Incoming Documents	FlowField	Text	30
28	Approved Incoming Documents	Approved Incoming Documents	FlowField	Text	30
29	OCR Pending	OCR Pending	FlowField	Text	30
30	OCR Completed	OCR Completed	FlowField	Text	30
31	Requests to Approve	Requests to Approve	FlowField	Text	30
32	Requests Sent for Approval	Requests Sent for Approval	FlowField	Text	30
33	Non-Applied Payments	Non-Applied Payments	FlowField	Text	30
34	Last Depreciated Posted Date	Last Depreciated Posted Date	FlowField	Text	30
35	Ongoing Sales Invoices	Ongoing Sales Invoices	FlowField	Text	30
36	Ongoing Purchase Invoices	Ongoing Purchase Invoices	FlowField	Text	30
37	Sales This Month	Sales This Month	FlowField	Text	30
38	Top 10 Company Sales YTD	Top 10 Company Sales YTD	FlowField	Text	30
39	Average Collection Days	Average Collection Days	FlowField	Text	30
40	Ongoing Sales Quotes	Ongoing Sales Quotes	FlowField	Text	30
41	Sales Inv. – Pending Doc.Exch.	Sales Inv. – Pending Doc.Exch.	FlowField	Text	30
42	Sales CrM. – Pending Doc.Exch.	Sales CrM. – Pending Doc.Exch.	FlowField	Text	30
43	My Incoming Documents	My Incoming Documents	FlowField	Text	30
44	Sales Invoices Due Next Week	Sales Invoices Due Next Week	FlowField	Text	30
45	Ongoing Sales Orders	Ongoing Sales Orders	FlowField	Text	30
46	Inc. Doc. Awaiting Verfication	Inc. Doc. Awaiting Verfication	FlowField	Text	30
47	Purchase Orders	Purchase Orders	FlowField	Text	30
48	Overdue Sales Documents Style	Overdue Sales Documents Style	FlowField	Text	30
49	Purch. Docs Due Today Style	Purch. Docs Due Today Style	FlowField	Text	30
50	POs Pending Approval Style	POs Pending Approval Style	FlowField	Text	30
51	SOs Pending Approval Style	SOs Pending Approval Style	FlowField	Text	30
52	Approved Sales Orders Style	Approved Sales Orders Style	FlowField	Text	30
53	Approved Purchase Orders Style	Approved Purchase Orders Style	FlowField	Text	30
54	Vendors-Payment on Hold Style	Vendors-Payment on Hold Style	FlowField	Text	30
55	Purchase Return Orders Style	Purchase Return Orders Style	FlowField	Text	30
56	Sales Return Orders-All Style	Sales Return Orders-All Style	FlowField	Text	30
57	Enviroments – Blocked Style	Enviroments – Blocked Style	FlowField	Text	30
58	Overdue Purch. Docs Style	Overdue Purch. Docs Style	FlowField	Text	30
59	Purch. Disc Next Week Style	Purch. Disc Next Week Style	FlowField	Text	30
60	Purch. Inv Due Next Week Style	Purch. Inv Due Next Week Style	FlowField	Text	30
61	New Incoming Documents Style	New Incoming Documents Style	FlowField	Text	30
62	Approved Incoming Docs Style	Approved Incoming Docs Style	FlowField	Text	30
63	OCR Pending Style	OCR Pending Style	FlowField	Text	30
64	OCR Completed Style	OCR Completed Style	FlowField	Text	30
65	Requests to Approve Style	Requests to Approve Style	FlowField	Text	30
66	Req Sent for Approval Style	Req Sent for Approval Style	FlowField	Text	30
67	Non-Applied Payments Style	Non-Applied Payments Style	FlowField	Text	30
68	Cash Accounts Balance Style	Cash Accounts Balance Style	FlowField	Text	30
69	Last Dep Posted Date Style	Last Dep Posted Date Style	FlowField	Text	30
70	Ongoing Sales Invoices Style	Ongoing Sales Invoices Style	FlowField	Text	30
71	Ongoing Purch. Invoices Style	Ongoing Purch. Invoices Style	FlowField	Text	30
72	Sales This Month Style	Sales This Month Style	FlowField	Text	30
73	Top 10 Cust Sales YTD Style	Top 10 Cust Sales YTD Style	FlowField	Text	30
74	Overdue Purch. Inv Amt Style	Overdue Purch. Inv Amt Style	FlowField	Text	30
75	Overdue Sales Inv Amt Style	Overdue Sales Inv Amt Style	FlowField	Text	30
76	Average Collection Days Style	Average Collection Days Style	FlowField	Text	30
77	Ongoing Sales Quotes Style	Ongoing Sales Quotes Style	FlowField	Text	30
78	Sales Inv-Pend DocExch Style	Sales Inv-Pend DocExch Style	FlowField	Text	30
79	Sales CrM-Pend DocExch Style	Sales CrM-Pend DocExch Style	FlowField	Text	30
80	My Incoming Documents Style	My Incoming Documents Style	FlowField	Text	30
81	Sales Inv Due Next Week Style	Sales Inv Due Next Week Style	FlowField	Text	30
82	Ongoing Sales Orders Style	Ongoing Sales Orders Style	FlowField	Text	30
83	Inc Doc Awaiting Verf Style	Inc Doc Awaiting Verf Style	FlowField	Text	30
84	Purchase Orders Style	Purchase Orders Style	FlowField	Text	30
85	Last Login Date Style	Last Login Date Style	FlowField	Text	30
86	Contact Name Style	Contact Name Style	FlowField	Text	50
87	My User Task Style	My User Task Style	FlowField	Text	30
90	Currency Symbol	Currency Symbol	FlowField	Text	10
92	Cash Accounts Balance Decimal	Cash Accounts Balance Decimal	FlowField	Decimal	12
93	Overdue Purch. Inv Amt Decimal	Overdue Purch. Inv Amt Decimal	FlowField	Decimal	12
94	Overdue Sales Inv. Amt. Dec.	Overdue Sales Inv. Amt. Dec.	FlowField	Decimal	12
100	Environment Name	Environment Name	FlowField	Text	100
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 Group Company Summary].[] ,[User].[User Security ID] FROM [] AS [COHUB Group Company Summary] LEFT JOIN [User] AS [User] ON [COHUB Group Company Summary].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16