EN
Español
English
Português
    AFLS_INVENTORY_LOCATION_INFO

    Table where the detailed information of each of the locations configured to store the different products in the inventory is recorded.

    Data model

    Fields

    Field Type Description
    aslc_id INT Location category identifier.
    asli_addl_address NVARCHAR (MAX) Recording Additional Location Address Information
    asli_address NVARCHAR (MAX) Location Address Record
    asli_contact_mail NVARCHAR (MAX) Location contact mail log
    asli_contact_name NVARCHAR (MAX) Location Contact Name Registration
    asli_contact_phone NVARCHAR (MAX) Location contact phone log
    asli_description NVARCHAR (512) Detailed description of the location
    asli_is_active INT Dialing to identify whether this location is enabled or disabled.
    asli_isdefault BIT A location is set by default. By business logic, only one default location is allowed at a time.
    asli_latitude DECIMAL Location latitude logging
    asli_longitude DECIMAL Location Length Log
    asli_parent INT Marking to identify whether this location is the parent or principal seat of another location
    aslt_id INT Location type identifier.
    aslt_path* NVARCHAR (512) Physical path generated for the corresponding location
    grou_id* INT Unique identifier of the table
    grou_name* NVARCHAR (512) Location Name

    Primary Key

    PK_AFLS_INVENTORY_LOCATION_INFO
    grou_id

    References

    Column Referenced Table Referenced column Name
    aslc_id dbo.AFLS_INVENTORY_LOCATION_CATEGORIES aslc_id FK02_AFLS_INVENTORY_LOCATION_INFO
    asli_parent dbo.AFLS_INVENTORY_LOCATION_INFO grou_id FK01_AFLS_INVENTORY_LOCATION_INFO
    aslt_id dbo.AFLS_INVENTORY_LOCATION_TYPES aslt_id FK03_AFLS_INVENTORY_LOCATION_INFO