Home > Technical > Table Definitions > TRADSTATQUERY

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)