A table that contains all the location categories of inventory products. E.g. (Building, Store, Warehouse, Vehicle, etc)
Data model
Fields
| Field | Type | Description |
|---|---|---|
| aslc_description | NVARCHAR (MAX) | Location Category Description |
| aslc_id* | INT | Unique identifier of the table |
| aslc_name* | NVARCHAR (100) | Location Category Name |
| aslt_id* | INT | Location type identifier (Terrestrial, air, etc.). |
Primary Key
| PK_AFLS_INVENTORY_LOCATION_CATEGORIES |
|---|
| aslc_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| aslt_id* | dbo.AFLS_INVENTORY_LOCATION_TYPES | aslt_id | FK01_AFLS_INVENTORY_LOCATION_CATEGORIES |