Table 951 "Time Sheet Line"
Base Application · Microsoft.Projects.TimeSheet
Across versions
- BC23present
- BC243 fields changed, 2 procedures added
- BC252 events added, 1 fields changed
- BC26-27unchanged
- BC2815 fields changed
- BC29-30unchanged
Neighbourhood 30 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 946 “Time Sheet Line List” (1 Learn page), Page 949 “Time Sheet Lines” (1).
Properties
| Property | Value |
|---|---|
| Caption | Time Sheet Line |
| DataClassification | CustomerContent |
| Permissions | TableData Employee = r |
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 | Time Sheet No. Δ BC28 | Code[20] | Specifies the number of the related document. | TableRelation Table 950 “Time Sheet Header” (Time Sheet Header) |
| 2 | Line No. | Integer | — | |
| 3 | Time Sheet Starting Date Δ BC28 | Date | Specifies the starting date for a time sheet. | not editable |
| 5 | Type Δ BC28 | Enum “Time Sheet Line Type” | Specifies the type of time sheet line. | enum Enum 952 “Time Sheet Line Type” |
| 6 | Job No. Δ BC24 Δ BC28 | Code[20] | Specifies the number for the project that is associated with the time sheet line. | TableRelation Table 167 “Job” (Job where(Status = filter(Open))) |
| 7 | Job Task No. Δ BC24 Δ BC28 | Code[20] | Specifies the number of the related project task. | TableRelation Table 1001 “Job Task” (“Job Task”.“Job Task No.” where(“Job No.” = field(“Job No.”), “Job Task Type” = filter(Posting))) |
| 9 | Cause of Absence Code Δ BC28 | Code[10] | Specifies a list of standard absence codes, from which you may select one. | TableRelation Table 5206 “Cause of Absence” (Cause of Absence) |
| 10 | Description Δ BC28 | Text[100] | Specifies a description of the time sheet line. | |
| 11 | Work Type Code Δ BC28 | Code[10] | Specifies which work type the resource applies to. Prices are updated based on this entry. | TableRelation Table 200 “Work Type” (Work Type) |
| 12 | Approver ID | Code[50] | — | TableRelation Table 91 “User Setup” (User Setup); not editable; DataClassification EndUserIdentifiableInformation |
| 13 | Service Order No. Δ BC25 Δ BC28 | Code[20] | Specifies the service order number that is associated with the time sheet line. | |
| 14 | Service Order Line No. | Integer | — | |
| 15 | Total Quantity Δ BC28 | Decimal | Specifies the total number of hours that have been entered on a time sheet. | FlowField: sum(“Time Sheet Detail”.Quantity where(“Time Sheet No.” = field(“Time Sheet No.”), “Time Sheet Line No.” = field(“Line No.”))); not editable |
| 17 | Chargeable Δ BC28 | Boolean | Specifies if the usage that you are posting is chargeable. | |
| 18 | Assembly Order No. Δ BC28 | Code[20] | Specifies the assembly order number that is associated with the time sheet line. | TableRelation Table 900 “Assembly Header” (if (Posted = const(false)) “Assembly Header”.“No.” where(“Document Type” = const(Order))); not editable |
| 19 | Assembly Order Line No. | Integer | — | not editable |
| 20 | Status Δ BC28 | Enum “Time Sheet Status” | Specifies information about the status of a time sheet line. | enum Enum 950 “Time Sheet Status”; not editable |
| 21 | Approved By | Code[50] | — | TableRelation Table 91 “User Setup” (User Setup); not editable; DataClassification EndUserIdentifiableInformation |
| 22 | Approval Date | Date | — | not editable |
| 23 | Posted Δ BC28 | Boolean | Specifies whether a time sheet line has been posted completely. | not editable |
| 26 | Comment Δ BC28 | Boolean | Specifies that a comment about this document has been entered. | FlowField: exist(“Time Sheet Comment Line” where(“No.” = field(“Time Sheet No.”), “Time Sheet Line No.” = field(“Line No.”))); not editable |
| 480 | Dimension Set ID | Integer | — | not editable; DataClassification SystemMetadata |
| 8002 | Job Id Δ BC24 | Guid | Project Id caption | TableRelation Job.SystemId; DataClassification SystemMetadata |
Keys
- Key1: Time Sheet No., Line No. (clustered)
- Key2: Type
- Key3: Time Sheet No., Status, Posted
- Key4: Type, Job No.
Events published
OnAfterUpdateApproverID(var TimeSheetLine: Record "Time Sheet Line")(integration)OnBeforeTestStatus(var IsHandled: Boolean; var TimeSheetLine: Record "Time Sheet Line")(integration)OnBeforeGetJobApproverID(var ApproverID: Code[50]; var IsHandled: Boolean)(integration)OnBeforeSetApproverIDFromResource(Resource: Record Resource; var IsHandled: Boolean)(integration)OnBeforeShowLineDetails(var TimeSheetLine: Record "Time Sheet Line"; var IsHandled: Boolean; ManagerRole: Boolean)(integration)- subscribers: Codeunit 6451 “Serv. Time Sheet Mgt.” OnBeforeShowLineDetails
OnAfterGetAllowEdit(FldNo: Integer; ManagerRole: Boolean; var AllowEdit: Boolean)(integration)OnBeforeCheckWorkType(var TimeSheetLine: Record "Time Sheet Line"; var IsHandled: Boolean)(integration)OnValidateTypeOnAfterClearFields(var TimeSheetLine: Record "Time Sheet Line")+ BC25 (integration)- subscribers: Codeunit 6451 “Serv. Time Sheet Mgt.” OnValidateTypeOnAfterClearFields
OnAfterSetExclusionTypeFilter(var TimeSheetLine: Record "Time Sheet Line")+ BC25 (integration)- subscribers: Codeunit 6451 “Serv. Time Sheet Mgt.” TimeSheetLineOnAfterSetExclusionTypeFilter
Procedures
TestStatus()UpdateApproverID()ShowLineDetails(ManagerRole: Boolean)GetAllowEdit(FldNo: Integer; ManagerRole: Boolean): BooleanCheckIfTimeSheetLineLinkExist(Job: Record Job)+ BC24UpdateJobId()SetExclusionTypeFilter()+ BC25
Plus 7 local procedures.
Triggers
OnDelete, OnInsert, OnModify
Relations
- Job Task No.: TableRelation Table 1001 “Job Task”
- Job No.: TableRelation Table 167 “Job”
- Work Type Code: TableRelation Table 200 “Work Type”
- Cause of Absence Code: TableRelation Table 5206 “Cause of Absence”
- Assembly Order No.: TableRelation Table 900 “Assembly Header”
- Approved By: TableRelation Table 91 “User Setup”
- Approver ID: TableRelation Table 91 “User Setup”
- Time Sheet No.: TableRelation Table 950 “Time Sheet Header”
- Total Quantity: CalcFormula Table 952 “Time Sheet Detail”
- Comment: CalcFormula Table 953 “Time Sheet Comment Line”
Referenced by
10 fields in 6 objects relate to this table (TableRelation or CalcFormula).
- Table 950 “Time Sheet Header”: Approved Exists, Lines Exist, Open Exists, Rejected Exists, Submitted Exists
- Table 207 “Res. Journal Line”: Time Sheet Line No.
- Table 210 “Job Journal Line”: Time Sheet Line No.
- Table 5902 “Service Line”: Time Sheet Line No.
- Table 5991 “Service Shipment Line”: Time Sheet Line No.
- Table 6012 “Service Line Archive”: Time Sheet Line No.
Pages and codeunits on this table
- Page 946 “Time Sheet Line List” (source table)
- Page 948 “TimeSheet Line Details FactBox” (source table)
- Page 949 “Time Sheet Lines” (source table)
- Page 952 “Manager Time Sheet” (source table)
- Page 954 “Manager Time Sheet by Job” (source table)
- Page 965 “Time Sheet Line Res. Detail” (source table)
- Page 966 “Time Sheet Line Job Detail” (source table)
- Page 967 “Time Sheet Line Service Detail” (source table)
- Page 968 “Time Sheet Line Assemb. Detail” (source table)
- Page 969 “Time Sheet Line Absence Detail” (source table)
- Page 971 “Activity Details FactBox” (source table)
- Page 974 “Time Sheet Lines Subform” (source table)
Extended by
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: "Time Sheet Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.