---
id: object/table/6220
type: object
title: Table 6220 "Sustainability Cue"
summary: Table 6220 "Sustainability Cue" in Sustainability (Microsoft.Sustainability.RoleCenters). 31 fields, 4 public procedures. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
  - table
  - sustainability
versions:
  introduced: "29"
  last_changed: null
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 53cc76f0598737e59974f26e339bc1ec9fa7897d2402e32dba58acabe01d5783
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Sustainability/app/src/RoleCenters/SustainabilityCue.Table.al
    title: src/Apps/W1/Sustainability/app/src/RoleCenters/SustainabilityCue.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 6220
name: Sustainability Cue
namespace: Microsoft.Sustainability.RoleCenters
app: Sustainability
extends: null
first_version: "29"
last_version: "30"
present_in:
  - "29"
  - "30"
changed_in: []
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 31
  procedures: 4
  events: 0
  subscribers: 0
relations:
  out: 20
  referenced_by: 0
  pages: 1
  extended_by: 0
  event_subscribers: 0
  calls: 1
  called_by: 0
  implements: 0
---

# Table 6220 "Sustainability Cue"

> Table 6220 "Sustainability Cue" in Sustainability (Microsoft.Sustainability.RoleCenters). 31 fields, 4 public procedures. Introduced in BC29, still in BC30.

Sustainability · Microsoft.Sustainability.RoleCenters · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Sustainability/app/src/RoleCenters/SustainabilityCue.Table.al) · 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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"](../enum/6212.md) |
| 23 | Water/Waste Int. Type Filter | Enum "Water/Waste Intensity Type" | Water/Waste Intensity Type Filter <small>caption</small> | FlowFilter; enum [Enum 6217 "Water/Waste Intensity Type"](../enum/6217.md) |
| 24 | Water Type Filter | Enum "Water Type" | — | FlowFilter; enum [Enum 6218 "Water Type"](../enum/6218.md) |
| 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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. <small>via [Page 6236 "Sustainability Activities"](../page/6236.md)</small> | 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"](../table/130.md)
- My Incoming Documents: CalcFormula [Table 130 "Incoming Document"](../table/130.md)
- Sales Invoices Due Next Week: CalcFormula [Table 21 "Cust. Ledger Entry"](../table/21.md)
- Purch. Invoices Due Next Week: CalcFormula [Table 25 "Vendor Ledger Entry"](../table/25.md)
- Ongoing Sales Invoices: CalcFormula [Table 36 "Sales Header"](../table/36.md)
- Ongoing Sales Orders: CalcFormula [Table 36 "Sales Header"](../table/36.md)
- Ongoing Purchase Invoices: CalcFormula [Table 38 "Purchase Header"](../table/38.md)
- Ongoing Purchase Orders: CalcFormula [Table 38 "Purchase Header"](../table/38.md)
- Requests Sent for Approval: CalcFormula [Table 454 "Approval Entry"](../table/454.md)
- Requests to Approve: CalcFormula [Table 454 "Approval Entry"](../table/454.md)
- Released Prod. Orders: CalcFormula [Table 5405 "Production Order"](../table/5405.md)
- Ongoing Transfer Orders: CalcFormula [Table 5740 "Transfer Header"](../table/5740.md)
- CO2e Emission: CalcFormula [Table 6216 "Sustainability Ledger Entry"](../table/6216.md)
- Discharged Into Water: CalcFormula [Table 6216 "Sustainability Ledger Entry"](../table/6216.md)
- Emission CH4: CalcFormula [Table 6216 "Sustainability Ledger Entry"](../table/6216.md)
- Emission CO2: CalcFormula [Table 6216 "Sustainability Ledger Entry"](../table/6216.md)
- Emission N2O: CalcFormula [Table 6216 "Sustainability Ledger Entry"](../table/6216.md)
- Waste Intensity: CalcFormula [Table 6216 "Sustainability Ledger Entry"](../table/6216.md)
- Water Intensity: CalcFormula [Table 6216 "Sustainability Ledger Entry"](../table/6216.md)
- Assembly Orders: CalcFormula [Table 900 "Assembly Header"](../table/900.md)

## Pages and codeunits on this table

- [Page 6236 "Sustainability Activities"](../page/6236.md) (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"](../codeunit/1174.md) (4 calls: `GetMyOverDueUserTasksCount → SetFiltersToShowMyUserTasks`, `GetMyPendingUserTasksThisMonthCount → SetFiltersToShowMyUserTasks`, `ShowMyPendingUserTasksOverDueCount → SetFiltersToShowMyUserTasks`, …)

## Across versions

- Present in: BC29-30
- Changed (declaration) in: none

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## 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.