Home > Technical > Table Definitions > DEPT
Items can be placed into a four-level hierarchical grouping - Department, Category, Group and Subgroup. This table contains the valid department.
|
Column |
Type |
Description |
|
VARCHAR(10) |
A unique code assigned by the user. |
|
|
STRDEPTDESCRIPTION |
VARCHAR(50) |
Department name |
|
YSNWEIGHATPOS |
VARCHAR(1) |
‘T’ if items in this department can be weighed at the POS Register, ‘F’ otherwise. |
|
YSNNEW |
VARCHAR(1) |
No longer used. |
|
YSNCHANGED |
VARCHAR(1) |
No longer used. |
|
DBLCOSTRATIO |
DECIMAL(19,4) |
No longer used. |
|
INTCOGSMETHOD |
INT |
No longer used. |
Primary Key: STRDEPTCODE
| Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |