Table for result records for order timer update.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| chresult_agreetype | INT | Record to identify the type of agreement compliance |
| chresult_calendarid* | INT | Calendar ID associated with chronometer |
| chresult_complies | INT | Logging to identify stopwatch compliance |
| chresult_currentprogress | DECIMAL | Column for current progress record of the associated stopwatch |
| chresult_currenttime | INT | Column for current time recording of the associated stopwatch |
| chresult_enddate | DATETIME | Column for Execution End Date Record |
| chresult_enddatetime | INT | Column for Time-End Time, Stopwatch |
| chresult_estimateddate | DATETIME | Column for Stopwatch Expiration Date Record |
| chresult_estimatedtime | INT | Column for associated Sla timelog |
| chresult_id* | INT | Primary Table Key |
| chresult_item_id* | INT | Column for Associated Document ID Record |
| chresult_itemtime_id* | INT | Column for Associated Stopwatch ID Record |
| chresult_lastshot | DATETIME | Column for Last Record Date Record |
| chresult_providerid | INT | Registration to identify the partner provider |
| chresult_startdate | DATETIME | Column for Execution Start Date Record |
| chresult_status* | INT | Column for recording the status of the associated stopwatch. (Inactive = 0, Active = 1, OnHold = 2, Finalized = 3) |
Primary Key
| PK_AFLS_CHRONOS_RESULTS |
|---|
| chresult_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| chresult_itemtime_id* | Bod. AFW_ITEM_TIMES | id | FK01_AFLS_CHRONOS_RESULTS |