Home > Technical > Table Definitions > 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. |
STRSTORECODE |
VARCHAR(10) |
The location the item is being stocked. |
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) |