Home > Technical > Table Definitions > STOCKTAKEDTL

STOCKTAKEDTL

Column

Type

Description

LINTSTOCKTAKENUM

INT

 

CTRCODE

INT

 

STRDEPTCODE

VARCHAR(10)

 

STRCATCODE

VARCHAR(10)

 

STRGROUPCODE

VARCHAR(10)

 

LINTITEMNUMBER

INT

 

STRUNITOFMEASURE

VARCHAR(10)

 

CURUNITCOST

DECIMAL(19,6)

 

DBLSTOCKONHAND

DECIMAL(19,6)

 

DBLSTOCKCOUNT

DECIMAL(19,6)

 

DBLLINKEDQTY

DECIMAL(19,4)

 

STRMAINUNITOFMEASURE

VARCHAR(10)

 

DBLORIGCOUNT

DECIMAL(19,6)

 

YSNORIGENTERED

VARCHAR(1)

 

YSNPDE

VARCHAR(1)

 

YSNSHOWSTOCK

VARCHAR(1)

 

STRDESCRIPTION

VARCHAR(100)

 

LINTSTOCKITEM

INT

 

YSNRECIPEITEM

VARCHAR(1)

 

YSNSTOCK

VARCHAR(1)

 

YSNWORKSHEETREP

VARCHAR(1)

 

YSNTRANSFERFROM

VARCHAR(1)

 

YSNTRANSFERTO

VARCHAR(1)

 

STRORDERCODE

VARCHAR(20)

 

STRCOMMENT

VARCHAR(200)

 

STRBAY

VARCHAR(10)

 

CURSELLPRICE

DECIMAL(19,4)

 

STRSUBGROUPCODE

VARCHAR(10)

 

CURREBATE

DECIMAL(19,6)

 

DBLCONSOLIDATEDCOUNT

DECIMAL(19,6)

 

INTSTKAREA

INT

Used to support stock templates in stocktakes. CTRCODE  of the stock area for the item.

INTLOCATION INT

Used to support stock templates in stocktakes. Stock location shelf number

 

Primary Key: LINTSTOCKTAKENUM + CTRCODE + LINTITEMNUMBER

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