Objects/Tables/Table 950 Time Sheet Header
Table 950 Time Sheet Header in 19
Jonas Paprotka, Base Application 19.5.36567.56815, checked
- App
- Base Application
Fields, 27Keys, 4Procedures, 5Events, 2
Versions171819202122232425262728latest
Source29
Fields, 27
| Id | Name | Type | Obsolete |
|---|
| 1 | No. | Code[20] | - |
| 3 | Starting Date | Date | - |
| 4 | Ending Date | Date | - |
| 5 | Resource No. | Code[20] | - |
| 6 | Resource Name | Text[100] | - |
| 7 | Owner User ID | Code[50] | - |
| 8 | Approver User ID | Code[50] | - |
| 10 | Description | Text[100] | - |
| 11 | Unit of Measure | Code[10] | - |
| 12 | Open Exists | Boolean | - |
| 13 | Submitted Exists | Boolean | - |
| 14 | Rejected Exists | Boolean | - |
| 15 | Approved Exists | Boolean | - |
| 16 | Posted Exists | Boolean | - |
| 20 | Quantity | Decimal | - |
| 21 | Posted Quantity | Decimal | - |
| 26 | Comment | Boolean | - |
| 30 | Status Filter | Enum Time Sheet Status | - |
| 31 | Job No. Filter | Code[20] | - |
| 32 | Job Task No. Filter | Code[20] | - |
| 33 | Date Filter | Date | - |
| 34 | Posted Filter | Boolean | - |
| 35 | Type Filter | Enum Time Sheet Line Type | - |
| 40 | Quantity Open | Decimal | - |
| 41 | Quantity Submitted | Decimal | - |
| 42 | Quantity Approved | Decimal | - |
| 43 | Quantity Rejected | Decimal | - |
Keys, 4
| Name | Fields | Obsolete |
|---|
| Key1, clustered | No. | - |
| Key2 | Resource No., Starting Date | - |
| Key3 | Owner User ID | - |
| Key4 | Approver User ID | - |
Procedures, 5
| Name | Parameters | Returns | Access | Obsolete |
|---|
| CalcQtyWithStatus | (Enum Time Sheet Status) | Decimal | public | - |
| Check | () | | public | - |
| GetLastLineNo | () | Integer | public | - |
| FindLastTimeSheetNo | (Integer) | Code[20] | public | - |
| FindCurrentTimeSheetNo | (Integer) | Code[20] | public | - |
Events, 2
| Kind | Name | Parameters | Obsolete |
|---|
| Integration event | OnBeforeCheckTimeSheetLine | (Record Time Sheet Line, var Boolean) | - |
| Integration event | OnValidateResourceNoOnBeforeTestFields | (Record Resource, var Boolean) | - |