Home > Technical > Table Definitions > STOCKDETAIL

STOCKDETAIL

Only used if using FIFO COGS method. There will be one record for each unit of stock.

Column Type Description

LINTITEMNUMBER

INT(4)

The item which is stocked.

ITEM.lintItemNumber

STRSTORECODE

VARCHAR(10)

The location the item is being stocked.

TRADUNIT.strTradeCode

CTRCODE

BIGINT(8)

A unique code assigned by the system.

DTMWHEN

DATETIME(8)

The date the record was created.

CURCOST

DECIMAL9(19,4)

The cost of the item. This will be used a the COGS.

CURREBATE

DECIMAL9(19,4)

The expected rebate for this stock unit.

STRSOURCE

VARCHAR(5)

Indicates the program from which the record was created, for example IM=Invoice Matching, ST=Stocktake, and so on.

LINTREFERENCE

INT(4)

The unique number which identifies the source of the record. For example, if st#strSourcerSource indicates that this record came from Invoice Matching, this number would be the invoice number.

 

Primary Key: STRSTORECODE + LINTITEMNUMBER + CTRCODE

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