Home > Technical > Table Definitions > 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. |
|
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. |
|
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) |
