Home > Technical > Table Definitions > TKTDET

TKTDET

Column

Type

Description

LINTBATCHCODE

INT

 

STRTYPE

VARCHAR(5)

 

CTRCODE

INT

 

LINTITEMNUMBER

INT

 

INTTICKETNUM

INT

 

DBLAPN

FLOAT

 

STRPRODUCTBRANDNAME

VARCHAR(30)

 

STRPRODUCTDESCRIPTION

VARCHAR(30)

 

STRPRODUCTVARIETY

VARCHAR(30)

 

STRPRODUCTSIZE

VARCHAR(10)

 

CURSELL

DECIMAL(19,4)

 

CURNORMALSELL

DECIMAL(19,4)

 

CURSELL2

DECIMAL(19,4)

 

CURNORMALSELL2

DECIMAL(19,4)

 

CURSELL3

DECIMAL(19,4)

 

CURNORMALSELL3

DECIMAL(19,4)

 

CURSELL4

DECIMAL(19,4)

 

CURNORMALSELL4

DECIMAL(19,4)

 

CURSELL5

DECIMAL(19,4)

 

CURNORMALSELL5

DECIMAL(19,4)

 

DTMSELLEND

DATETIME

 

STRSUPPLIERCODE

VARCHAR(10)

 

INTMINORDER

DECIMAL(9,3)

 

DBLRATEOFSALE

DECIMAL(19,4)

 

STRPROFITFLAG

VARCHAR(2)

 

STRORDERCODE

VARCHAR(20)

 

INTCARTONSIZE

DECIMAL(9,3)

 

STRDEPTCODE

VARCHAR(10)

 

STRCATCODE

VARCHAR(10)

 

STRGROUPCODE

VARCHAR(10)

 

STRPOS12DESCRIPTION

VARCHAR(12)

 

STRPOS20DESCRIPTION

VARCHAR(20)

 

STRUNITOFMEASURE

VARCHAR(10)

 

LINTTICKETCLIP1

INT

 

LINTTICKETCLIP2

INT

 

LINTTICKETCLIP3

INT

 

LINTTICKETCLIP4

INT

 

LINTTICKETCLIP5

INT

 

STRCLASSCODE

VARCHAR(10)

 

STRCOMPETITION

VARCHAR(10)

 

MEMCOMMENTS

VARCHAR(2000)

 

MEMCOMMENTS2

VARCHAR(2000)

 

DTMTICKETDATE

DATETIME

 

INTPOINTS

INT

 

LINTCUSTOMERNUM

INT

 

STRTITLE

VARCHAR(5)

 

STRFIRSTNAME

VARCHAR(50)

 

STRINITIALS

VARCHAR(5)

 

STRLASTNAME

VARCHAR(50)

 

STRPREFERNAME

VARCHAR(50)

 

DTMBIRTHDAY

DATETIME

 

STRADDR1

VARCHAR(50)

 

STRADDR2

VARCHAR(50)

 

STRCITY

VARCHAR(50)

 

STRSTATE

VARCHAR(20)

 

STRPOSTCODE

VARCHAR(15)

 

STRADDR1POST

VARCHAR(50)

 

STRADDR2POST

VARCHAR(50)

 

STRCITYPOST

VARCHAR(50)

 

STRSTATEPOST

VARCHAR(20)

 

STRPOSTCODEPOST

VARCHAR(15)

 

STRPHONE

VARCHAR(20)

 

STRFAX

VARCHAR(20)

 

STRMOBILE

VARCHAR(20)

 

STREMAIL

VARCHAR(60)

 

STRWORKPHONE

VARCHAR(20)

 

STRPASSWORD

VARCHAR(10)

 

STREMPLOYMENT

VARCHAR(50)

 

STRCATEGORY1

VARCHAR(10)

 

STRCATEGORY2

VARCHAR(10)

 

STRCATEGORY3

VARCHAR(10)

 

STRCATEGORY4

VARCHAR(10)

 

STRCATEGORY5

VARCHAR(10)

 

STRTAXEXEMPT

VARCHAR(20)

 

STRDRIVERSLICENCE

VARCHAR(20)

 

DBLCARDNUM

DECIMAL(19,4)

 

LINTPOINTS

INT

 

DTMVALIDFROM

DATETIME

 

DTMVALIDTO

DATETIME

 

STRCARDNUM

VARCHAR(16)

 

STRSAVELABEL

VARCHAR(10)

 

STRSAVEVALUE

VARCHAR(20)

 

STRBONUSLABEL

VARCHAR(10)

 

LINTBONUSITEMNUMBER

INT

 

STRBONUSORDERCODE

VARCHAR(20)

 

STRBONUSDESCRIPTION

VARCHAR(20)

 

STRPROMOCOMMENT

VARCHAR(255)

 

LINTWARRANTYITEM

INT

 

CURWARRANTYSELL

DECIMAL(19,4)

 

STRWARRANTYORDERCODE

VARCHAR(20)

 

STRMANUFACTURER

VARCHAR(10)

 

STRSUBGROUPCODE

VARCHAR(10)

 

DBLMINSTOCKQTY

DECIMAL(19,4)

 

DBLMAXSTOCKQTY

DECIMAL(19,4)

 

STRAPN

VARCHAR(20)

 

STRSEASONCODE

VARCHAR(10)

 

STRYEARCODE

VARCHAR(4)

 

STRPERWEIGHTCODE

VARCHAR(10)

 

DBLPERWEIGHTQTY

DECIMAL(19,4)

 

MEMWARRANTYDESCRIPTIONS

TEXT

 

MEMWARRANTYSELLS

TEXT

 

YSNFOODSTAMP

VARCHAR(1)

 

YSNWIC

VARCHAR(1)

 

STRPRODUCTFIT

VARCHAR(20)

 

STRSPECIFICATION

VARCHAR(100)

 

STRMANUFACTURERCOUNTRY

VARCHAR(100)

 

STRFORMOFPRODUCT

VARCHAR(100)

 

STRENGLISHDESCRIPTION

VARCHAR(100)

 

STRREGISTEREDTRADEMARK

VARCHAR(100)

 

STRPRODUCTREFERENCE1

VARCHAR(100)

 

STRPRODUCTREFERENCE2

VARCHAR(100)

 

STRPRODUCTREFERENCE3

VARCHAR(100)

 

STRPRODUCTREFERENCE4

VARCHAR(100)

 

STRPRODUCTREFERENCE5

VARCHAR(100)

 

STRLONGDESCRIPTION

VARCHAR(200)

 

 

Primary Key: LINTBATCHCODE + STRTYPE + CTRCODE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)