EN
Español
English
Português
    AFLS_INVENTORY_MOVEMENTS

    Table that contains the record of each and every one of the movements that a certain product in the inventory may have

    Data model

    Fields

    Field Type Description
    grou_id INT Identifier of the location where the product is located.
    mov_buy_date DATETIME Product purchase date record
    mov_code_reference NVARCHAR (256) Unique reference code corresponding to the registered movement
    mov_descripcion NVARCHAR (512) Product Movement Description
    mov_id* INT Unique identifier of the table
    mov_inout* INT Marking to identify whether the movement is in or out.
    mov_quantity* INT Quantity of the product to which the movement is recorded
    mov_register_date* DATETIME Product Movement Posting Date
    mov_third_id NVARCHAR (256) Third-party identifier if applicable
    mov_unit_value DECIMAL Unit value of the product to which the movement is registered
    prod_id* INT Identifier of the product associated with the movement.
    spec_id INT Identifier of the specialist associated with the product.
    type_id* INT Identifier of the type of movement applied to the product.
    user_id* INT Specialist user identifier associated with the process to which the movement is recorded.
    work_id INT Identifier of the work order associated with the product.

    Primary Key

    PK_AFLS_INVENTORY_MOVEMENTS
    mov_id

    References

    Column Referenced Table Referenced column Name
    grou_id dbo.AFLS_INVENTORY_LOCATION_INFO grou_id FK02_AFLS_INVENTORY_MOVEMENTS
    prod_id* dbo.AFLS_INVENTORY_PRODUCTS prod_id FK01_AFLS_INVENTORY_MOVEMENTS
    spec_id dbo.AFLS_USERS_SPECIALISTS user_id FK06_AFLS_INVENTORY_MOVEMENTS
    type_id* dbo.AFLS_INVENTORY_MOVEMENT_TYPES type_id FK04_AFLS_INVENTORY_MOVEMENTS
    user_id* dbo.AFW_USERS user_id FK03_AFLS_INVENTORY_MOVEMENTS
    work_id dbo.AFLS_WORKORDERS work_id FK05_AFLS_INVENTORY_MOVEMENTS