Table where information is recorded to relate work orders to their identifier both externally and within Field Service
Data model
Fields
| Field | Type | Description |
|---|---|---|
| atpi_attempts_notificated* | INT | Number of notification attempts |
| atpi_date_notificated | DATETIME | Date of last notification |
| atpi_error_message | NVARCHAR (MAX) | Error message in an unsuccessful notification |
| atpi_external_id* | VARCHAR (50) | Identifier corresponding to the work order coming from the external component |
| atpi_final_substate | INT | Homologated sub-status from the synchronized external component |
| atpi_id* | INT | Unique identifier of the table |
| atpi_is_executed | BIT | Dialing to identify if the synchronization with external service has been successful |
| atpi_is_notificated | BIT | Marking to identify if the corresponding work order is notified |
| atpi_item_id* | VARCHAR (50) | Identifier corresponding to the related work order |
| atpi_product_id* | VARCHAR (50) | Name of the external component from which the information is synchronized within Field Service |
Primary Key
| PK_AFLS_THIRD_PARTY_INTEGRATIONS |
|---|
| atpi_id |