Table 9057 "Job Cue"
Base Application · Microsoft.Projects.RoleCenters
Across versions
- BC23present
- BC248 fields changed, 2 fields added
- BC251 fields changed
- BC263 fields changed
- BC27unchanged
- BC2810 fields changed
- BC29-30unchanged
Neighbourhood 8 connected objects and pages
Base Application · Microsoft.Projects.RoleCenters · captioned “Project Cue” · BC23-30 · source at ea08af5e · facts from BC29
Properties
| Property | Value |
|---|---|
| Caption | Project 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 Δ BC26 | Code[10] | — | |
| 2 | Jobs w/o Resource Δ BC24 Δ BC28 | Integer | Specifies the number of projects without an assigned resource that are displayed in the Project Cue on the Role Center. The documents are filtered by today’s date. | FlowField: count(Job where(“Scheduled Res. Qty.” = filter(0))); not editable |
| 3 | Upcoming Invoices Δ BC24 Δ BC28 | Integer | Specifies the number of upcoming invoices that are displayed in the Project Cue on the Role Center. The documents are filtered by today’s date. | FlowField: count(Job where(Status = filter(Planning | Quote | Open), “Next Invoice Date” = field(“Date Filter”))); not editable |
| 4 | Invoices Due - Not Created Δ BC24 Δ BC28 | Integer | Specifies the number of invoices that are due but not yet created that are displayed in the Project Cue on the Role Center. The documents are filtered by today’s date. | FlowField: count(Job where(Status = const(Open), “Next Invoice Date” = field(“Date Filter2”))); not editable |
| 5 | WIP Not Posted Δ BC24 Δ BC28 | Integer | Specifies the amount of work in process that has not been posted that is displayed in the Service Cue on the Role Center. The documents are filtered by today’s date. | FlowField: count(Job where(“WIP Entries Exist” = const(true))); not editable |
| 6 | Completed - WIP Not Calculated Δ BC24 Δ BC28 | Integer | Specifies the total of work in process that is complete but not calculated that is displayed in the Project Cue on the Role Center. The documents are filtered by today’s date. | FlowField: count(Job where(Status = filter(Completed), “WIP Completion Calculated” = const(false), “WIP Completion Posted” = const(false))); not editable |
| 7 | Available Resources Δ BC24 Δ BC25 Δ BC28 | Integer | Specifies the number of available resources that are displayed in the Project Cue on the Role Center. The documents are filtered by today’s date. | FlowField: count(Resource where(“Qty. on Order (Job)” = filter(0), “Qty. Quoted (Job)” = filter(0), “Date Filter” = field(“Date Filter”))); not editable |
| 8 | Unassigned Resource Groups Δ BC24 Δ BC28 | Integer | Specifies the number of unassigned resource groups that are displayed in the Project Cue on the Role Center. The documents are filtered by today’s date. | FlowField: count(“Resource Group” where(“No. of Resources Assigned” = filter(0))); not editable |
| 9 | Jobs Over Budget Δ BC24 Δ BC28 | Integer | Specifies the number of projects where the usage cost exceeds the budgeted cost. | FlowField: count(Job where(“Over Budget” = filter(= true))); not editable |
| 20 | Date Filter | Date | — | FlowFilter; not editable |
| 21 | Date Filter2 | Date | — | FlowFilter; not editable |
| 22 | User ID Filter | Code[50] | — | FlowFilter |
| 24 | Coupled Data Synch Errors + BC24 Δ BC26 Δ BC28 | Integer | — | obsolete Removed 28.0; #if not CLEANSCHEMA28; FlowField: count(“CRM Integration Record” where(Skipped = const(true))) |
| 25 | FS Integration Errors + BC24 Δ BC26 Δ BC28 | Integer | Field Service Integration Errors caption | obsolete Removed 28.0; #if not CLEANSCHEMA28; FlowField: count(“Integration Synch. Job Errors”) |
Keys
- Key1: Primary Key (clustered)
Relations
- Unassigned Resource Groups: CalcFormula Table 152 “Resource Group”
- Available Resources: CalcFormula Table 156 “Resource”
- Completed - WIP Not Calculated: CalcFormula Table 167 “Job”
- Invoices Due - Not Created: CalcFormula Table 167 “Job”
- Jobs Over Budget: CalcFormula Table 167 “Job”
- Jobs w/o Resource: CalcFormula Table 167 “Job”
- Upcoming Invoices: CalcFormula Table 167 “Job”
- WIP Not Posted: CalcFormula Table 167 “Job”
- Coupled Data Synch Errors: CalcFormula Table 5331 “CRM Integration Record”
- FS Integration Errors: CalcFormula Table 5339 “Integration Synch. Job Errors”
Pages and codeunits on this table
- Page 9067 “Resource Manager Activities” (source table)
- Page 9068 “Project Manager Activities” (source table)
Extended by
Deprecations
- field Coupled Data Synch Errors: Removed 28.0 (#if not CLEANSCHEMA28), “Field Service is moved to Field Service Integration app.”
- field FS Integration Errors: Removed 28.0 (#if not CLEANSCHEMA28), “Field Service is moved to Field Service Integration app.”
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). 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: "Job Cue"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.