Table 6220 "Sustainability Cue"

Sustainability · Microsoft.Sustainability.RoleCenters · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Sustainability Cue
DataClassification	CustomerContent

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	Primary Key	Code[10]	—
2	Emission CO2	Decimal	—	FlowField: sum(“Sustainability Ledger Entry”.“Emission CO2” where(“Posting Date” = field(“Date Filter”), “Emission Scope” = field(“Scope Filter”)))
3	Emission CH4	Decimal	—	FlowField: sum(“Sustainability Ledger Entry”.“Emission CH4” where(“Posting Date” = field(“Date Filter”), “Emission Scope” = field(“Scope Filter”)))
4	Emission N2O	Decimal	—	FlowField: sum(“Sustainability Ledger Entry”.“Emission N2O” where(“Posting Date” = field(“Date Filter”), “Emission Scope” = field(“Scope Filter”)))
6	Ongoing Purchase Orders	Integer	Specifies purchases orders that are not posted or only partially posted. via Page 6236 “Sustainability Activities”	FlowField: count(“Purchase Header” where(“Document Type” = const(Order), “Sustainability Lines Exist” = const(true))); not editable
7	Ongoing Purchase Invoices	Integer	Specifies purchases invoices that are not posted or only partially posted. via Page 6236 “Sustainability Activities”	FlowField: count(“Purchase Header” where(“Document Type” = const(Invoice), “Sustainability Lines Exist” = const(true))); not editable
8	Purch. Invoices Due Next Week	Integer	Specifies the number of payments to vendors that are due next week. via Page 6236 “Sustainability Activities”	FlowField: count(“Vendor Ledger Entry” where(“Document Type” = filter(Invoice \| “Credit Memo”), “Due Date” = field(“Due Next Week Filter”), Open = const(true))); not editable
9	My Incoming Documents	Integer	Specifies incoming documents that are assigned to you. via Page 6236 “Sustainability Activities”	FlowField: count(“Incoming Document” where(Processed = const(false)))
15	Inc. Doc. Awaiting Verfication	Integer	Specifies incoming documents in OCR processing that require you to log on to the OCR service website to manually verify the OCR values before the documents can be received. via Page 6236 “Sustainability Activities”	FlowField: count(“Incoming Document” where(“OCR Status” = const(“Awaiting Verification”)))
20	Date Filter	Date	—	FlowFilter
21	Due Next Week Filter	Date	—	FlowFilter
22	Scope Filter	Enum “Emission Scope”	—	FlowFilter; enum Enum 6212 “Emission Scope”
23	Water/Waste Int. Type Filter	Enum “Water/Waste Intensity Type”	Water/Waste Intensity Type Filter caption	FlowFilter; enum Enum 6217 “Water/Waste Intensity Type”
24	Water Type Filter	Enum “Water Type”	—	FlowFilter; enum Enum 6218 “Water Type”
25	User ID Filter	Code[50]	—	FlowFilter
29	Discharged Into Water	Decimal	—	FlowField: sum(“Sustainability Ledger Entry”.“Discharged Into Water” where(“Posting Date” = field(“Date Filter”), “Water/Waste Intensity Type” = field(“Water/Waste Int. Type Filter”), “Water Type” = field(“Water Type Filter”)))
30	Water Intensity	Decimal	—	FlowField: sum(“Sustainability Ledger Entry”.“Water Intensity” where(“Posting Date” = field(“Date Filter”), “Water/Waste Intensity Type” = field(“Water/Waste Int. Type Filter”), “Water Type” = field(“Water Type Filter”)))
31	Waste Intensity	Decimal	—	FlowField: sum(“Sustainability Ledger Entry”.“Waste Intensity” where(“Posting Date” = field(“Date Filter”), “Water/Waste Intensity Type” = field(“Water/Waste Int. Type Filter”)))
32	Ongoing Sales Orders	Integer	Specifies Sales orders that are not posted or only partially posted. via Page 6236 “Sustainability Activities”	FlowField: count(“Sales Header” where(“Document Type” = const(Order), “Sustainability Lines Exist” = const(true))); not editable
33	Ongoing Sales Invoices	Integer	Specifies Sales invoices that are not posted or only partially posted. via Page 6236 “Sustainability Activities”	FlowField: count(“Sales Header” where(“Document Type” = const(Invoice), “Sustainability Lines Exist” = const(true))); not editable
34	Sales Invoices Due Next Week	Integer	Specifies the number of payments to customer that are due next week. via Page 6236 “Sustainability Activities”	FlowField: count(“Cust. Ledger Entry” where(“Document Type” = filter(Invoice \| “Credit Memo”), “Due Date” = field(“Due Next Week Filter”), Open = const(true))); not editable
35	Released Prod. Orders	Integer	Specifies the value of the Released Production Orders This Month field. via Page 6236 “Sustainability Activities”	FlowField: count(“Production Order” where(Status = const(Released), “Creation Date” = field(“Date Filter”), “Sustainability Lines Exist” = const(true))); not editable
36	Assembly Orders	Integer	Specifies the value of the Assembly Orders This Month field. via Page 6236 “Sustainability Activities”	FlowField: count(“Assembly Header” where(“Document Type” = const(order), “Posting Date” = field(“Date Filter”), “Sust. Account No.” = filter(‘<>’‘’‘’))); not editable
37	Ongoing Transfer Orders	Integer	Specifies Transfer Orders that are not posted or only partially posted. via Page 6236 “Sustainability Activities”	FlowField: count(“Transfer Header” where(“Sustainability Lines Exist” = const(true))); not editable
38	Requests to Approve	Integer	Specifies requests for certain documents, cards, or journal lines that you must approve for other users before they can proceed. via Page 6236 “Sustainability Activities”	FlowField: count(“Approval Entry” where(“Approver ID” = field(“User ID Filter”), Status = filter(Open)))
39	Requests Sent for Approval	Integer	Specifies requests for certain documents, cards, or journal lines that your approver must approve before you can proceed. via Page 6236 “Sustainability Activities”	FlowField: count(“Approval Entry” where(“Sender ID” = field(“User ID Filter”), Status = filter(Open)))
40	Pending User Tasks	Integer	—
41	Tasks This Month	Integer	—
42	Overdue User Tasks	Integer	—
43	CO2e Emission	Decimal	—	FlowField: sum(“Sustainability Ledger Entry”.“CO2e Emission” where(“Posting Date” = field(“Date Filter”)))
44	DateTime Filter	DateTime	—	FlowFilter

Keys

Key1: Primary Key (clustered)

Procedures

GetMyPendingUserTasksThisMonthCount(): Integer (internal)
ShowMyPendingUserTasksThisMonthCount(): Integer (internal)
GetMyOverDueUserTasksCount(): Integer (internal)
ShowMyPendingUserTasksOverDueCount(): Integer (internal)

Relations

Inc. Doc. Awaiting Verfication: CalcFormula Table 130 “Incoming Document”
My Incoming Documents: CalcFormula Table 130 “Incoming Document”
Sales Invoices Due Next Week: CalcFormula Table 21 “Cust. Ledger Entry”
Purch. Invoices Due Next Week: CalcFormula Table 25 “Vendor Ledger Entry”
Ongoing Sales Invoices: CalcFormula Table 36 “Sales Header”
Ongoing Sales Orders: CalcFormula Table 36 “Sales Header”
Ongoing Purchase Invoices: CalcFormula Table 38 “Purchase Header”
Ongoing Purchase Orders: CalcFormula Table 38 “Purchase Header”
Requests Sent for Approval: CalcFormula Table 454 “Approval Entry”
Requests to Approve: CalcFormula Table 454 “Approval Entry”
Released Prod. Orders: CalcFormula Table 5405 “Production Order”
Ongoing Transfer Orders: CalcFormula Table 5740 “Transfer Header”
CO2e Emission: CalcFormula Table 6216 “Sustainability Ledger Entry”
Discharged Into Water: CalcFormula Table 6216 “Sustainability Ledger Entry”
Emission CH4: CalcFormula Table 6216 “Sustainability Ledger Entry”
Emission CO2: CalcFormula Table 6216 “Sustainability Ledger Entry”
Emission N2O: CalcFormula Table 6216 “Sustainability Ledger Entry”
Waste Intensity: CalcFormula Table 6216 “Sustainability Ledger Entry”
Water Intensity: CalcFormula Table 6216 “Sustainability Ledger Entry”
Assembly Orders: CalcFormula Table 900 “Assembly Header”

Pages and codeunits on this table

Page 6236 “Sustainability Activities” (source table)

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Codeunit 1174 “User Task Management” (4 calls: GetMyOverDueUserTasksCount → SetFiltersToShowMyUserTasks, GetMyPendingUserTasksThisMonthCount → SetFiltersToShowMyUserTasks, ShowMyPendingUserTasksOverDueCount → SetFiltersToShowMyUserTasks, …)

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. 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: "Sustainability Cue"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.