EN
Español
English
Português
    AFLS_THIRD_PARTY_NOTIFICATION_LOGS

    Table that stores the error log of work order integration with an external

    Data model

    Fields

    Field Type Description
    atpi_id* INT Integration ID
    error_id* SMALLINT Error message ID
    last_error* BIT Indicates if it is the last error generated
    log_date* DATETIME Record creation date
    log_error_attempts* INT Work Order Notification Attempt Number
    log_id* INT Unique identifier of the table
    sub_state_id* INT Sub status of the work order where the error occurred

    Primary Key

    PK_AFLS_THIRD_PARTY_NOTIFICATION_LOGS
    log_id

    References

    Column Referenced Table Referenced column Name
    atpi_id* dbo.AFLS_THIRD_PARTY_INTEGRATIONS atpi_id FK01_AFLS_THIRD_PARTY_NOTIFICATION_LOGS
    error_id* dbo.AFLS_ERROR_MESSAGES error_id FK02_AFLS_THIRD_PARTY_NOTIFICATION_LOGS