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) |