Home > Technical > Table Definitions > STOCKADJ

STOCKADJ

This tables audits stock adjustments performed in the system. These can be the result of spillages recorded at the POS. It also records transfers that are also recorded in TRANSFERHEADER and TRANSFERDETAIL.

Column Type Description

CTRCODE

INT(4)

Unique code assigned by the system.

STRADJUSTMENTTYPE

VARCHAR(20)

The reason for the adjustment.

STOCKADJREASON.strCode

STRSTORECODEFROM

VARCHAR(10)

The location from which the goods are being transferred.

TRADUNIT.strTradeCode

LINTDAMAGEITEM

INT(4)

If the item was a damaged item, then its IPN will be stored here.

ITEM.lintItemNumber

LINTITEMNUMBERFROM

INT(4)

The item number of the goods being transferred.

ITEM.lintItemNumber

DBLQUANTITYFROM

DECIMAL9(19,4)

The quantity of goods transferred.

STRSTORECODETO

VARCHAR(10)

The location to which the goods are being transferred. Not required if damaged/spillage item.

TRADUNIT.strTradeCode

LINTITEMNUMBERTO

INT(4)

The item number of the goods being transferred to. Not required if damaged/spillage item.

ITEM.lintItemNumber

DBLQUANTITYTO

DECIMAL9(19,4)

The quantity of items received. This may be different to dblQuantityFrom if the units of measure of the ‘from’ and ‘to’ items were different.

CURADJUSTMENTVALUE

DECIMAL9(19,4)

The value of the adjustment based on the quantity and average cost of the item transferred .

DTMWHEN

DATETIME(8)

When the adjustment was made.

STRWHO

VARCHAR(20)

The user who made the adjustment.

DTMTRANSDATE

DATETIME(8)

The date the transaction actually took place.

STRMAINREFERENCE

VARCHAR(20)

The reference of the main transaction.

TRANSFERHEADER.strReference

STRITEMREFERENCE

VARCHAR(20)

The reference of the item within the main transaction.

TRANSFERDETAIL.strReference

 

Primary Key: CTRCODE

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