Home > Technical > Table Definitions > AREADEPT
If the user in a certain management area is only allowed to see/use certain department, those departments are listed here. If no records exist for a management area, the user can see any department. The records link back to the master record in MANAGEMENTAREA.
|
Column |
Type |
Description |
|
STRAREACODE |
VARCHAR(10) |
The management area code to which this record belongs. |
|
STRDEPTCODE |
VARCHAR(10) |
The department the user is allowed to see. When a user does a search for items, only items in the department will be visible. |
|
YSNMODIFY |
VARCHAR(1) |
If 'T' the user can modify items that belong in this department. If 'F', they can view but not edit the item. |
|
INTUPDATE |
INT |
Not currently used. |
|
INTINSERTEDBY |
INT |
Not currently used. |
|
DTMLOCALINSERTED |
DATETIME |
Not currently used. |
|
DTMUTCINSERTED |
DATETIME |
Not currently used. |
|
INTUPDATEDBY |
INT |
Not currently used. |
|
DTMLOCALUPDATED |
DATETIME |
Not currently used. |
|
DMUTCUPDATED |
DATETIME |
Not currently used. |
Primary Key: STRAREACODE + STRDEPTCODE
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |
