Home > Technical > Table Definitions > TRADSTATQUERY
Column |
Type |
Description |
STRCODE |
VARCHAR(10) |
|
STRDESCRIPTION |
VARCHAR(50) |
|
STRWHO |
VARCHAR(20) |
|
INTTABSET |
INT |
|
LINTITEMNUMBER |
INT |
|
STRBRANDNAME |
VARCHAR(30) |
|
STRFAMILYCODE |
VARCHAR(10) |
|
INTGROUPBY |
INT |
|
STRDEPTCODE |
VARCHAR(10) |
|
STRCATCODE |
VARCHAR(10) |
|
STRGROUPCODE |
VARCHAR(10) |
|
STRTRADECODE |
VARCHAR(10) |
|
STRFROMPERIOD |
VARCHAR(5) |
|
STRSUPPLIERCODE |
VARCHAR(10) |
|
INTSORTCOLUMN |
INT |
|
YSNASCENDING |
VARCHAR(1) |
|
INTCOMPAREMETHOD |
INT |
|
STRCOMPARETRADECODE |
VARCHAR(10) |
|
STRCOMPAREFROMPERIOD |
VARCHAR(5) |
|
YSNPRINTGRAPH |
VARCHAR(1) |
|
YSNPRINTREPORT |
VARCHAR(1) |
|
STRSUBGROUPCODE |
VARCHAR(10) |
|
STRITEMCATEGORY |
VARCHAR(50) |
|
STRCLASSCODE |
VARCHAR(10) |
|
STRSEASONCODE |
VARCHAR(10) |
|
STRYEARCODE |
VARCHAR(4) |
|
STRVIEWCOLUMNS |
VARCHAR(2000) |
|
STRGRAPHCOLUMNS |
VARCHAR(2000) |
|
INTTRIPID |
INT |
|
LINTPROMOCODE |
INT |
|
STRTRADETYPE |
VARCHAR(10) |
|
STRMANUFACTURER |
VARCHAR(10) |
|
INTSHIFTCODE |
INT |
|
INTSALESMETHOD |
INT |
|
STRAGENTCODE |
VARCHAR(10) |
|
Primary Key: STRCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |