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