Table 950 "Time Sheet Header"
Base Application · Microsoft.Projects.TimeSheet
Across versions
- BC23present
- BC244 fields changed, 1 fields added
- BC25-27unchanged
- BC2818 fields changed
- BC29-30unchanged
Neighbourhood 20 connected objects and pages
Base Application · Microsoft.Projects.TimeSheet · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 951 “Time Sheet List” (1 Learn page), Page 973 “Time Sheet Card” (1).
Properties
| Property | Value |
|---|---|
| Caption | Time Sheet Header |
| 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 | No. Δ BC28 | Code[20] | Specifies the number of the involved entry or record, according to the specified number series. | |
| 3 | Starting Date Δ BC28 | Date | Specifies the starting date for a time sheet. | |
| 4 | Ending Date Δ BC28 | Date | Specifies the ending date for a time sheet. | |
| 5 | Resource No. Δ BC28 | Code[20] | Specifies the number of the resource for the time sheet. | TableRelation Table 156 “Resource” |
| 6 | Resource Name Δ BC24 Δ BC28 | Text[100] | Specifies the name of the resource for the time sheet. | FlowField: lookup(Resource.Name where(“No.” = field(“Resource No.”))); not editable |
| 7 | Owner User ID | Code[50] | — | TableRelation Table 91 “User Setup” (User Setup); DataClassification EndUserIdentifiableInformation |
| 8 | Approver User ID | Code[50] | — | TableRelation Table 91 “User Setup” (User Setup); DataClassification EndUserIdentifiableInformation |
| 10 | Description Δ BC28 | Text[100] | Specifies the description for a time sheet. | |
| 11 | Unit of Measure Δ BC24 | Code[10] | — | FlowField: lookup(Resource.“Base Unit of Measure” where(“No.” = field(“Resource No.”))); not editable |
| 12 | Open Exists Δ BC28 | Boolean | Specifies if there are time sheet lines with the status Open. | FlowField: exist(“Time Sheet Line” where(“Time Sheet No.” = field(“No.”), Status = const(Open))); not editable |
| 13 | Submitted Exists Δ BC28 | Boolean | Specifies if there are time sheet lines with the status Submitted. | FlowField: exist(“Time Sheet Line” where(“Time Sheet No.” = field(“No.”), Status = const(Submitted))); not editable |
| 14 | Rejected Exists Δ BC28 | Boolean | Specifies whether there are time sheet lines with the status Rejected. | FlowField: exist(“Time Sheet Line” where(“Time Sheet No.” = field(“No.”), Status = const(Rejected))); not editable |
| 15 | Approved Exists Δ BC28 | Boolean | Specifies whether there are time sheet lines with the status Approved. | FlowField: exist(“Time Sheet Line” where(“Time Sheet No.” = field(“No.”), Status = const(Approved))); not editable |
| 16 | Posted Exists Δ BC28 | Boolean | Specifies whether there are time sheet lines with the status Posted. | FlowField: exist(“Time Sheet Posting Entry” where(“Time Sheet No.” = field(“No.”))); not editable |
| 18 | Lines Exist + BC24 | Boolean | — | FlowField: exist(“Time Sheet Line” where(“Time Sheet No.” = field(“No.”))); not editable |
| 20 | Quantity Δ BC28 | Decimal | Specifies the total number of hours that are registered on the time sheet. | FlowField: sum(“Time Sheet Detail”.Quantity where(“Time Sheet No.” = field(“No.”), Status = field(“Status Filter”), “Job No.” = field(“Job No. Filter”), “Job Task No.” = field(“Job Task No. Filter”), Date = field(“Date Filter”), Posted = field(“Posted Filter”), Type = field(“Type Filter”))) |
| 21 | Posted Quantity Δ BC28 | Decimal | — | FlowField: sum(“Time Sheet Posting Entry”.Quantity where(“Time Sheet No.” = field(“No.”))) |
| 26 | Comment Δ BC28 | Boolean | Specifies that a comment about this document has been entered. | FlowField: exist(“Time Sheet Comment Line” where(“No.” = field(“No.”), “Time Sheet Line No.” = const(0))); not editable |
| 30 | Status Filter | Enum “Time Sheet Status” | — | FlowFilter; enum Enum 950 “Time Sheet Status” |
| 31 | Job No. Filter Δ BC24 | Code[20] | Project No. Filter caption | FlowFilter |
| 32 | Job Task No. Filter Δ BC24 | Code[20] | Project Task No. Filter caption | FlowFilter |
| 33 | Date Filter | Date | — | FlowFilter |
| 34 | Posted Filter | Boolean | — | FlowFilter |
| 35 | Type Filter | Enum “Time Sheet Line Type” | — | FlowFilter; enum Enum 952 “Time Sheet Line Type” |
| 40 | Quantity Open Δ BC28 | Decimal | Specifies the total number of hours with the status Open on the time sheet. | FlowField: sum(“Time Sheet Detail”.Quantity where(“Time Sheet No.” = field(“No.”), Status = const(Open))); not editable |
| 41 | Quantity Submitted Δ BC28 | Decimal | Specifies the total number of hours with the status Submitted on the time sheet. | FlowField: sum(“Time Sheet Detail”.Quantity where(“Time Sheet No.” = field(“No.”), Status = const(Submitted))); not editable |
| 42 | Quantity Approved Δ BC28 | Decimal | Specifies the total number of hours with the status Approved on the time sheet. | FlowField: sum(“Time Sheet Detail”.Quantity where(“Time Sheet No.” = field(“No.”), Status = const(Approved))); not editable |
| 43 | Quantity Rejected Δ BC28 | Decimal | Specifies the total number of hours with the status Rejected on the time sheet. | FlowField: sum(“Time Sheet Detail”.Quantity where(“Time Sheet No.” = field(“No.”), Status = const(Rejected))); not editable |
Keys
- Key1: No. (clustered)
- Key2: Resource No., Starting Date
- Key3: Owner User ID
- Key4: Approver User ID
Events published
OnBeforeCheckTimeSheetLine(TimeSheetLine: Record "Time Sheet Line"; var IsHandled: Boolean)(integration)OnValidateResourceNoOnBeforeTestFields(Resource: Record Resource; var IsHandled: Boolean)(integration)
Procedures
CalcQtyWithStatus(Status: Enum "Time Sheet Status"): DecimalCheck()GetLastLineNo(): IntegerFindLastTimeSheetNo(FilterFieldNo: Integer): Code[20]FindCurrentTimeSheetNo(FilterFieldNo: Integer): Code[20]FindTimeSheetList(FilterFieldNo: Integer): Code[20]
Plus 4 local procedures.
Triggers
OnDelete, OnInsert, OnModify, OnRename
Relations
- Resource Name: CalcFormula Table 156 “Resource”
- Resource No.: TableRelation Table 156 “Resource”
- Approver User ID: TableRelation Table 91 “User Setup”
- Owner User ID: TableRelation Table 91 “User Setup”
- Approved Exists: CalcFormula Table 951 “Time Sheet Line”
- Lines Exist: CalcFormula Table 951 “Time Sheet Line”
- Open Exists: CalcFormula Table 951 “Time Sheet Line”
- Rejected Exists: CalcFormula Table 951 “Time Sheet Line”
- Submitted Exists: CalcFormula Table 951 “Time Sheet Line”
- Quantity: CalcFormula Table 952 “Time Sheet Detail”
- Quantity Approved: CalcFormula Table 952 “Time Sheet Detail”
- Quantity Open: CalcFormula Table 952 “Time Sheet Detail”
- Quantity Rejected: CalcFormula Table 952 “Time Sheet Detail”
- Quantity Submitted: CalcFormula Table 952 “Time Sheet Detail”
- Comment: CalcFormula Table 953 “Time Sheet Comment Line”
- Posted Exists: CalcFormula Table 958 “Time Sheet Posting Entry”
- Posted Quantity: CalcFormula Table 958 “Time Sheet Posting Entry”
Referenced by
14 fields in 9 objects relate to this table (TableRelation or CalcFormula).
- Table 9042 “Team Member Cue”: Approved Time Sheets, New Time Sheets, Open Time Sheets, Rejected Time Sheets, Submitted Time Sheets, Time Sheets to Approve
- Table 207 “Res. Journal Line”: Time Sheet No.
- Table 210 “Job Journal Line”: Time Sheet No.
- Table 5902 “Service Line”: Time Sheet No.
- Table 5991 “Service Shipment Line”: Time Sheet No.
- Table 6012 “Service Line Archive”: Time Sheet No.
- Table 951 “Time Sheet Line”: Time Sheet No.
- Table 952 “Time Sheet Detail”: Time Sheet No.
- Table 958 “Time Sheet Posting Entry”: Time Sheet No.
Pages and codeunits on this table
- Page 951 “Time Sheet List” (source table)
- Page 953 “Manager Time Sheet List” (source table)
- Page 973 “Time Sheet Card” (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 950 “Time Sheet Management” (3 calls:
FindCurrentTimeSheetNo → FilterTimeSheets,FindLastTimeSheetNo → FilterTimeSheets,FindTimeSheetList → FilterTimeSheets)
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: "Time Sheet Header"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.