Objects/Tables/Table 950 Time Sheet Header
Table 950 Time Sheet Header in 18
Jonas Paprotka, Base Application 18.5.29545.46345, checked
- App
- Base Application
Fields, 20Keys, 4Procedures, 4Events, 2
Versions171819202122232425262728latest
Source29
Fields, 20
| Id | Name | Type | Obsolete |
|---|
| 1 | No. | Code[20] | - |
| 3 | Starting Date | Date | - |
| 4 | Ending Date | Date | - |
| 5 | Resource No. | Code[20] | - |
| 7 | Owner User ID | Code[50] | - |
| 8 | Approver User ID | Code[50] | - |
| 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 | - |
Keys, 4
| Name | Fields | Obsolete |
|---|
| Key1, clustered | No. | - |
| Key2 | Resource No., Starting Date | - |
| Key3 | Owner User ID | - |
| Key4 | Approver User ID | - |
Procedures, 4
| Name | Parameters | Returns | Access | Obsolete |
|---|
| CalcQtyWithStatus | (Enum Time Sheet Status) | Decimal | public | - |
| Check | () | | public | - |
| GetLastLineNo | () | Integer | public | - |
| FindLastTimeSheetNo | (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) | - |