Home > Technical > Table Definitions > REVALUATION

REVALUATION

This tables stores details about stock revaluations. A revaluation occurs when new stock is invoiced at a different cost to the last invoice cost. The existing stock is revalued at the difference between the old and new last invoice cost. It is also used when doing a return for an invoice for FIFO.

Column Type Description

CTRCODE

INT(4)

Unique number assigned by the system.

DTMADJUSTED

DATETIME(8)

 

LINTINVOICENUM

INT(4)

The number of the invoice which forced the revaluation.

link.gif (858 bytes) INVOICEHEADER.lintInvoiceNumber

CUROLDINVOICECOST

DECIMAL9(19,4)

The old unit invoice cost for the item.

CURNEWINVOICECOST

DECIMAL9(19,4)

The new unit invoice cost for the item.

DBLSTOCKONHAND

DECIMAL9(19,4)

The number of units that needed to be revalued.

LINTITEMNUMBER

INT(4)

The IPN of the item being revalued.

link.gif (858 bytes) ITEM.lintItemNumber

STRSOURCE

VARCHAR(5)

Indicates the source of the revaluation, for example IM-R.

 

Primary Key: CTRCODE

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