EN
Español
English
Português
    AFLS_INVENTORY_PRODUCTS_ASSIGNMENT

    Table where records are made to assign the product to a certain specialist in the warehouse and its current quantity in the inventory

    Data model

    Fields

    Field Type Description
    aipa_id* INT Unique identifier of the table
    aipa_quantity INT Recording the current quantity of product assigned to a lawyer or a specialist
    aipa_serial_num NVARCHAR (256) When the product type is of a single type, its serial number must be recorded in this column
    aipa_specialist_id INT Identifier of the specialist who has been assigned a certain product.
    date_id* INT Identify the date on which the registration is made. This record corresponds to the year-month-day format.
    group_id INT Identifier of the warehouse in which the product is located.
    last_enabled* BIT Marking to identify whether the mapping record is in an active or inactive state. If for the same record, the field (date_id) has changed, the same record is not updated, but a new one is made, this for reporting issues.
    prod_id INT Product identifier.

    Primary Key

    PK_AFLS_INVENTORY_PRODUCTS_ASSIGNMENT
    aipa_id

    References

    Column Referenced Table Referenced column Name
    aipa_specialist_id dbo.AFLS_USERS_SPECIALISTS user_id FK03_AFLS_INVENTORY_PRODUCTS_ASSIGNMENT
    date_id* Bod. ADW_DIM_DATE id FK04_AFLS_INVENTORY_PRODUCTS_ASSIGNMENT
    group_id dbo.AFLS_INVENTORY_LOCATION_INFO grou_id FK01_AFLS_INVENTORY_PRODUCTS_ASSIGNMENT
    prod_id dbo.AFLS_INVENTORY_PRODUCTS prod_id FK02_AFLS_INVENTORY_PRODUCTS_ASSIGNMENT