Stores work order assignment traces to vendors
Data model
Fields
| Field | Type | Description |
|---|---|---|
| creationdate* | DATETIME | Log Log Date |
| id* | INT | Unique identifier of the table |
| provideractiondate | DATETIME | Date the provider takes log action |
| providerid | INT | Supplier identifier. |
| slaid | INT | Service Level Agreement Identifier |
| state* | INT | Indicates the status of the relationship between order and vendor. |
| workid* | INT | Work order identifier. |
Primary Key
| PK_AFLS_WORKORDER_PROVIDER_LOG |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| providerid | dbo.AFLS_PROVIDERS | providerid | FK02_AFLS_WORKORDER_PROVIDER_LOG |
| state* | dbo.AFLS_WORKORDER_PROVIDER_STATUS | id | FK03_AFLS_WORKORDER_PROVIDER_LOG |
| workid* | dbo.AFLS_WORKORDERS | work_id | FK01_AFLS_WORKORDER_PROVIDER_LOG |