EN
Español
English
Português
    AFLS_WORKORDER_PROVIDER_LOG

    Table for recording traces of assignment of work orders to suppliers

    Data model

    Fields

    Field Type Description
    creationdate* DATETIME Log Log Date
    id* INT Primary Table Key
    provideractiondate DATETIME Date the provider takes log action
    providerid INT Column containing the identification of the related vendor.
    slaid INT Service Level Agreement Identification
    state* INT Column that contains the identification of the status of the relationship between order and vendor.
    workid* INT Column that contains the related work order ID.

    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