Query "Get Time Sheet Archive Lines"
ID 985
Namespace: Microsoft.Projects.TimeSheet
Properties
| Name | Value |
|---|---|
| QueryType | Normal |
| ReadState | ReadUncommitted |
| DataAccessIntent | ReadOnly |
| OrderBy | descending(Starting_Date) |
Query columns
| Column name | Data item | Data type | Description |
|---|---|---|---|
| Time_Sheet_No_ | Time_Sheet_Header_Archive | Code[20] | |
| Resource_No_ | Time_Sheet_Header_Archive | Code[20] | |
| Starting_Date | Time_Sheet_Header_Archive | Date | |
| Ending_Date | Time_Sheet_Header_Archive | Date | |
| Line_No_ | Time_Sheet_Line_Archive | Integer | |
| Type | Time_Sheet_Line_Archive | Enum Microsoft.Projects.TimeSheet."Time Sheet Line Type" | |
| Status | Time_Sheet_Line_Archive | Enum Microsoft.Projects.TimeSheet."Time Sheet Status" | |
| Description | Time_Sheet_Line_Archive | Text[100] | |
| Job_No_ | Time_Sheet_Line_Archive | Code[20] | |
| Job_Task_No_ | Time_Sheet_Line_Archive | Code[20] | |
| Cause_of_Absence_Code | Time_Sheet_Line_Archive | Code[10] | |
| Chargeable | Time_Sheet_Line_Archive | Boolean | |
| Work_Type_Code | Time_Sheet_Line_Archive | Code[10] | |
| Service_Order_No_ | Time_Sheet_Line_Archive | Code[20] | |
| Assembly_Order_No_ | Time_Sheet_Line_Archive | Code[20] |