Table 1151 "COHUB Company KPI"

CompanyHub · Mirosoft.Integration.CompanyHub · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Access	Internal

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Enviroment No.	Code[20]	—	TableRelation Table 1152 “COHUB Enviroment” (“COHUB Enviroment”.“No.”); DataClassification CustomerContent
2	Company Name	Text[50]	—	DataClassification CustomerContent
130	Environment Name	Text[100]	—	FlowField: lookup(“COHUB Enviroment”.Name where(“No.” = field(“Enviroment No.”)))
4	Company Display Name	Text[50]	—	DataClassification CustomerContent
5	Assigned To	Guid	—	TableRelation User.“User Security ID”; DataClassification EndUserIdentifiableInformation
100	Overdue Sales Documents	Text[30]	—	DataClassification CustomerContent
101	Purchase Documents Due Today	Text[30]	—	DataClassification CustomerContent
102	POs Pending Approval	Text[30]	—	DataClassification CustomerContent
103	SOs Pending Approval	Text[30]	—	DataClassification CustomerContent
104	Approved Sales Orders	Text[30]	—	DataClassification CustomerContent
105	Approved Purchase Orders	Text[30]	—	DataClassification CustomerContent
106	Vendors - Payment on Hold	Text[30]	—	DataClassification CustomerContent
107	Purchase Return Orders	Text[30]	—	DataClassification CustomerContent
108	Sales Return Orders - All	Text[30]	—	DataClassification CustomerContent
109	Enviroments - Blocked	Text[30]	—	DataClassification CustomerContent
110	Overdue Purchase Documents	Text[30]	—	DataClassification CustomerContent
111	Purchase Discounts Next Week	Text[30]	—	not editable; DataClassification CustomerContent
112	Purch. Invoices Due Next Week	Text[30]	—	not editable; DataClassification CustomerContent
113	New Incoming Documents	Text[30]	—	DataClassification CustomerContent
114	Approved Incoming Documents	Text[30]	—	DataClassification CustomerContent
115	OCR Pending	Text[30]	—	DataClassification CustomerContent
116	OCR Completed	Text[30]	—	DataClassification CustomerContent
117	Requests to Approve	Text[30]	—	DataClassification CustomerContent
118	Requests Sent for Approval	Text[30]	—	DataClassification CustomerContent
119	Non-Applied Payments	Text[30]	—	DataClassification CustomerContent
120	Cash Accounts Balance	Text[30]	—	DataClassification CustomerContent
121	Last Depreciated Posted Date	Text[30]	—	DataClassification CustomerContent
200	Ongoing Sales Invoices	Text[30]	—	DataClassification CustomerContent
201	Ongoing Purchase Invoices	Text[30]	—	DataClassification CustomerContent
202	Sales This Month	Text[30]	—	DataClassification CustomerContent
203	Top 10 Company Sales YTD	Text[30]	—	DataClassification CustomerContent
204	Overdue Purch. Invoice Amount	Text[30]	—	DataClassification CustomerContent
205	Overdue Sales Invoice Amount	Text[30]	—	DataClassification CustomerContent
206	Average Collection Days	Text[30]	—	DataClassification CustomerContent
207	Ongoing Sales Quotes	Text[30]	—	DataClassification CustomerContent
208	Sales Inv. - Pending Doc.Exch.	Text[30]	Sales Invoices - Pending Document Exchange caption	not editable; DataClassification CustomerContent
209	Sales CrM. - Pending Doc.Exch.	Text[30]	Sales Credit Memos - Pending Document Exchange caption	not editable; DataClassification CustomerContent
210	My Incoming Documents	Text[30]	—	DataClassification CustomerContent
211	Sales Invoices Due Next Week	Text[30]	—	not editable; DataClassification CustomerContent
212	Ongoing Sales Orders	Text[30]	—	DataClassification CustomerContent
213	Inc. Doc. Awaiting Verfication	Text[30]	Inc. Doc. Awaiting Verification caption	not editable; DataClassification CustomerContent
214	Purchase Orders	Text[30]	—	DataClassification CustomerContent
215	Last Login Date	Text[30]	—	DataClassification CustomerContent
216	Contact Name	Text[50]	—	DataClassification CustomerContent
300	Overdue Sales Documents Style	Text[30]	—	DataClassification CustomerContent
301	Purch. Docs Due Today Style	Text[30]	—	DataClassification CustomerContent
302	POs Pending Approval Style	Text[30]	—	DataClassification CustomerContent
303	SOs Pending Approval Style	Text[30]	—	DataClassification CustomerContent
304	Approved Sales Orders Style	Text[30]	—	DataClassification CustomerContent
305	Approved Purchase Orders Style	Text[30]	—	DataClassification CustomerContent
306	Vendors-Payment on Hold Style	Text[30]	—	DataClassification CustomerContent
307	Purchase Return Orders Style	Text[30]	—	DataClassification CustomerContent
308	Sales Return Orders-All Style	Text[30]	—	DataClassification CustomerContent
309	Enviroments - Blocked Style	Text[30]	—	DataClassification CustomerContent
310	Overdue Purch. Docs Style	Text[30]	—	DataClassification CustomerContent
311	Purch. Disc Next Week Style	Text[30]	—	not editable; DataClassification CustomerContent
312	Purch. Inv Due Next Week Style	Text[30]	—	not editable; DataClassification CustomerContent
313	New Incoming Documents Style	Text[30]	—	DataClassification CustomerContent
314	Approved Incoming Docs Style	Text[30]	—	DataClassification CustomerContent
315	OCR Pending Style	Text[30]	—	DataClassification CustomerContent
316	OCR Completed Style	Text[30]	—	DataClassification CustomerContent
317	Requests to Approve Style	Text[30]	—	DataClassification CustomerContent
318	Req Sent for Approval Style	Text[30]	—	DataClassification CustomerContent
319	Non-Applied Payments Style	Text[30]	—	DataClassification CustomerContent
320	Cash Accounts Balance Style	Text[30]	—	DataClassification CustomerContent
321	Last Dep Posted Date Style	Text[30]	—	DataClassification CustomerContent
400	Ongoing Sales Invoices Style	Text[30]	—	DataClassification CustomerContent
401	Ongoing Purch. Invoices Style	Text[30]	—	DataClassification CustomerContent
402	Sales This Month Style	Text[30]	—	DataClassification CustomerContent
403	Top 10 Cust Sales YTD Style	Text[30]	—	DataClassification CustomerContent
404	Overdue Purch. Inv Amt Style	Text[30]	—	DataClassification CustomerContent
405	Overdue Sales Inv Amt Style	Text[30]	—	DataClassification CustomerContent
406	Average Collection Days Style	Text[30]	—	DataClassification CustomerContent
407	Ongoing Sales Quotes Style	Text[30]	—	DataClassification CustomerContent
408	Sales Inv-Pend DocExch Style	Text[30]	Sales Invoices - Pending Document Exchange caption	not editable; DataClassification CustomerContent
409	Sales CrM-Pend DocExch Style	Text[30]	Sales Credit Memos - Pending Document Exchange caption	not editable; DataClassification CustomerContent
410	My Incoming Documents Style	Text[30]	—	DataClassification CustomerContent
411	Sales Inv Due Next Week Style	Text[30]	—	not editable; DataClassification CustomerContent
412	Ongoing Sales Orders Style	Text[30]	—	DataClassification CustomerContent
413	Inc Doc Awaiting Verf Style	Text[30]	—	DataClassification CustomerContent
414	Purchase Orders Style	Text[30]	—	DataClassification CustomerContent
415	Last Login Date Style	Text[30]	—	DataClassification CustomerContent
416	Contact Name Style	Text[50]	—	DataClassification CustomerContent
500	Last Refreshed	DateTime	—	DataClassification CustomerContent
501	My User Task Style	Text[30]	—	DataClassification CustomerContent
502	Group Code	Code[20]	—	FlowField: lookup(“COHUB Enviroment”.“Group Code” where(“No.” = field(“Enviroment No.”)))
510	Currency Symbol	Text[10]	—	DataClassification CustomerContent
511	Cash Accounts Balance Decimal	Decimal	—	DataClassification CustomerContent
512	Overdue Purch. Inv. Amt. Dec.	Decimal	—	DataClassification CustomerContent
513	Overdue Sales Inv. Amt. Dec.	Decimal	—	DataClassification CustomerContent

Keys

Key1: Enviroment No., Company Name, Assigned To (clustered)

Procedures

1 local procedures, no public ones.

Relations

Environment Name: CalcFormula Table 1152 “COHUB Enviroment”
Group Code: CalcFormula Table 1152 “COHUB Enviroment”
Enviroment No.: TableRelation Table 1152 “COHUB Enviroment”

Referenced by

83 fields in 1 objects relate to this table (TableRelation or CalcFormula).

Table 1156 “COHUB Group Company Summary”: Approved Incoming Docs Style, Approved Incoming Documents, Approved Purchase Orders, Approved Purchase Orders Style, Approved Sales Orders, Approved Sales Orders Style, Average Collection Days, Average Collection Days Style, Cash Accounts Balance, Cash Accounts Balance Decimal, Cash Accounts Balance Style, Contact Name, Contact Name Style, Currency Symbol, Enviroments - Blocked, Enviroments - Blocked Style, Inc Doc Awaiting Verf Style, Inc. Doc. Awaiting Verfication, Last Dep Posted Date Style, Last Depreciated Posted Date, Last Login Date Style, Last Refreshed, My Incoming Documents, My Incoming Documents Style, My User Task Style, New Incoming Documents, New Incoming Documents Style, Non-Applied Payments, Non-Applied Payments Style, OCR Completed, OCR Completed Style, OCR Pending, OCR Pending Style, Ongoing Purch. Invoices Style, Ongoing Purchase Invoices, Ongoing Sales Invoices, Ongoing Sales Invoices Style, Ongoing Sales Orders, Ongoing Sales Orders Style, Ongoing Sales Quotes, Ongoing Sales Quotes Style, Overdue Purch. Docs Style, Overdue Purch. Inv Amt Decimal, Overdue Purch. Inv Amt Style, Overdue Purch. Invoice Amount, Overdue Purchase Documents, Overdue Sales Documents, Overdue Sales Documents Style, Overdue Sales Inv Amt Style, Overdue Sales Inv. Amt. Dec., Overdue Sales Invoice Amount, POs Pending Approval, POs Pending Approval Style, Purch. Disc Next Week Style, Purch. Docs Due Today Style, Purch. Inv Due Next Week Style, Purch. Invoices Due Next Week, Purchase Discounts Next Week, Purchase Documents Due Today, Purchase Orders, Purchase Orders Style, Purchase Return Orders, Purchase Return Orders Style, Req Sent for Approval Style, Requests Sent for Approval, Requests to Approve, Requests to Approve Style, Sales CrM-Pend DocExch Style, Sales CrM. - Pending Doc.Exch., Sales Inv Due Next Week Style, Sales Inv-Pend DocExch Style, Sales Inv. - Pending Doc.Exch., Sales Invoices Due Next Week, Sales Return Orders - All, Sales Return Orders-All Style, Sales This Month, Sales This Month Style, SOs Pending Approval, SOs Pending Approval Style, Top 10 Company Sales YTD, Top 10 Cust Sales YTD Style, Vendors - Payment on Hold, Vendors-Payment on Hold Style

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "COHUB Company KPI"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.