| Data Dictionary -- Asset Location | ||||||||
| Srl. No. | Table Name | Comment |
| 1 | aloc_location_mst | Location Master |
| Table Name : | |
| Comment : | Location Master |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| loc_code | fin_assetlocation | varchar(20) | No | Location Code | Yes |
| timestamp | _int_0 | int(0) | Yes | Time Stamp | No |
| ou_id | fin_ctxt_ouinstance | int(4) | Yes | Organization Unit ID | No |
| loc_desc | fin_desc40 | varchar(40) | Yes | Location Description | No |
| loc_abbr | fin_shortdesc | varchar(75) | Yes | Location Abbr | No |
| parentloc_code | fin_assetlocation | varchar(20) | Yes | Parent Location Code | No |
| loc_type | fin_paramvalue | varchar(30) | Yes | Location Type | No |
| loc_status | fin_status | varchar(25) | Yes | Status | No |
| createdby | fin_ctxt_user | varchar(30) | Yes | Create By | No |
| createddate | _datetime_8 | datetime(8) | Yes | Created Date | No |
| modifiedby | fin_ctxt_user | varchar(30) | Yes | Modified By | No |
| modifieddate | _datetime_8 | datetime(8) | Yes | Modified Date | No |