|
Table Owner |
Table Name |
Table Comment |
Table Column Name |
Table Column Datatype |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|---|---|---|---|---|---|---|---|
|
dbo |
aloc_hierarchy_tmp |
|
guid |
sql_variant |
Guid |
Yes |
No |
|
|
|
|
loc_code |
|
Location Code |
|
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
ou_id |
|
Organization Unit Id |
|
|
|
|
|
|
loc_desc |
sql_variant |
Location Description |
|
|
|
|
|
|
loc_status |
|
Location Status |
|
|
|
|
|
|
loc_type |
|
Location Type |
|
|
|
|
|
|
loc_hierarchy |
|
Location Hierarchy |
|
|
|
|
|
|
parentloc_code |
|
Parent Location Code |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
aloc_inter_tmp |
|
timestamp |
int |
Time Stamp |
|
|
|
|
|
|
guid |
sql_variant |
Guid |
|
|
|
|
|
|
loc_code |
|
Location Code |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|
|
|
aloc_location_mst |
This table will store all asset location details will be stored. |
loc_code |
sql_variant |
Location Code |
Yes |
|
|
|
|
|
timestamp |
int |
Time Stamp |
No |
|
|
|
|
|
ou_id |
|
Organization Unit Id |
|
|
|
|
|
|
loc_desc |
sql_variant |
Location Description |
|
|
|
|
|
|
loc_abbr |
|
Location asset address |
|
|
|
|
|
|
parentloc_code |
|
Parent Location Code |
|
|
|
|
|
|
loc_type |
|
Location Type |
|
|
|
|
|
|
loc_status |
|
Location Status.Values A-Active,I-Inactive. |
|
|
|
|
|
|
createdby |
|
Created By |
|
|
|
|
|
|
createddate |
datetime |
Created Date |
|
|
|
|
|
|
modifiedby |
sql_variant |
Modified By |
|
|
|
|
|
|
modifieddate |
datetime |
Modified Date |
|
|