Home > Technical > Table Definitions > STOCKAUDITSUMMARY

STOCKAUDITSUMMARY

This table is a summary of activity. The detailed information is written in STOCKAUDIT. When a stocktake is done, existing records are changed to show they are historical and a new record is created to record the current activity.
See Stock Audit for further details.

Column Type Description
LINTITEMNUMBER INT The item whose stock was adjusted.
ITEM.lintItemNumber
STRSTORECODE VARCHAR(10) The location at which the stock was adjusted for the item.
TRADUNIT.strTradeCode
INTSTATUS INT

0 indicates this is a past record.
1 indicates this is the current record.
99 is a marker record for a held stock take used in reports (by GP). It has no other purpose.

CTRCODE BIGINT A unique, incrementing number assigned by the system.
DTMWHEN DATETIME The date the record was created.
LINTREFERENCE INT The code of the stocktake that created this record.
STOCKTAKEDTL.lintStocktakeNum
DBLQTYOPEN DECIMAL(19,6) The opening stock on hand.
DBLQTYCLOSE DECIMAL(19,6) The closing stock on hand.
DBLQTYRECEIVE DECIMAL(19,6) The number of units received.
DBLQTYTRANSFERIN DECIMAL(19,6) The number of units transferred in.
DBLQTYTRANSFEROUT DECIMAL(19,6) The number of units transferred out.
DBLQTYSOLD DECIMAL(19,6) The number of units sold.
DBLQTYRETURNED DECIMAL(19,6) The number of units returned.
DBLQTYADJUST DECIMAL(19,6) The number of units adjusted either through a stocktake or a stock adjustment.
CURAVGOPEN DECIMAL(19,6) The value of opening stock based on average cost.
CURAVGCLOSE DECIMAL(19,6) The value of closing stock based on average cost. Note, that curAvgClose *should* be curAvgOpen +curAvgReceive +curAvgTransferIn +curAvgTransferOut +curAvgSold +curAvgReturn +curAvgAdjust. However, in circumstances where stock has been allowed to go negative before accepting new stock, its possible that it will not be the same.
CURAVGRECEIVE DECIMAL(19,6) The value of received stock based on average cost.
CURAVGTRANSFERIN DECIMAL(19,6) The value of stock transferred in based on average cost.
CURAVGTRANSFEROUT DECIMAL(19,6) The value of stock transferred out based on average cost.
CURAVGSOLD DECIMAL(19,6) The value of stock sold based on average cost.
CURAVGRETURNED DECIMAL(19,6) The value of stock returned based on average cost.
CURAVGADJUST DECIMAL(19,6) The value of stock adjusted either through a stocktake or a stock adjustment, based on average cost.
CURREBATESOPEN DECIMAL(19,6) The value of expected rebates for the opening stock.
CURREBATESCLOSE DECIMAL(19,6) The value of expected rebates for the closing stock.
CURREBATESRECEIVE DECIMAL(19,6) The value of expected rebates for received stock.
CURREBATESTRANSFERIN DECIMAL(19,6) The value of expected rebates for stock transferred in.
CURREBATESTRANSFEROUT DECIMAL(19,6) The value of expected rebates for stock transferred out.
CURREBATESSOLD DECIMAL(19,6) The value of rebates for stock sold.
CURREBATESRETURNED DECIMAL(19,6) The value of rebates for stock returned.
CURREBATESADJUST DECIMAL(19,6) The value of rebates for stock that was adjusted through either a stocktake or stock adjustment.
CURLASTINVOPEN DECIMAL(19,6) The value of opening stock based on last invoice cost.
CURLASTINVCLOSE DECIMAL(19,6) The value of closing stock based on last invoice cost.
CURLASTINVRECEIVE DECIMAL(19,6) The value of received stock based on last invoice cost.
CURLASTINVTRANSFERIN DECIMAL(19,6) The value of stock transferred in based on last invoice cost.
CURLASTINVTRANSFEROUT DECIMAL(19,6) The value of stock transferred out based on last invoice cost.
CURLASTINVSOLD DECIMAL(19,6) The value of stock sold based on last invoice cost.
CURLASTINVRETURNED DECIMAL(19,6) The value of stock returned based on last invoice cost.
CURLASTINVADJUST DECIMAL(19,6) The value of stock adjusted either through a stocktake or a stock adjustment, based on last invoice cost.
DBLORDEREDQTY DECIMAL(19,6) The total units on order. For the current record (INTSTATUS = 0), this is equivalent to STORERNG.dblOrderedQty.
DBLALLOCATEDQTY DECIMAL(19,6) The total units allocated for pending transactions. For the current record (INTSTATUS = 0), this is equivalent to STORERNG.dblAllocatedQty.
DBLINTRANSITQTY DECIMAL(19,6) The total units currently in transit. For the current record (INTSTATUS = 0), this is equivalent to STORERNG.dblInTransitQty.
DBLRETURNEDQTY DECIMAL(19,6) The total units requested to return to supplier. For the current record (INTSTATUS = 0), this is equivalent to STORERNG.dblReturnedQty.
DBLREQUESTEDQTY DECIMAL(19,6) The total units that have been requested FROM this location for other locations. For the current record (INTSTATUS = 0), this is equivalent to STORERNG.dblRequestedQty.
CURAVGCOST DECIMAL(19,6) The current average cost. For the current record (INTSTATUS = 0), this is equivalent to STORERNG.curAvgCost.
CURLASTINVOICECOST DECIMAL(19,6) The current last invoice cost. For the current record (INTSTATUS = 0), this is equivalent to curLastInvoiceCost.
CURAVGREBATES DECIMAL(19,6) The current average expected rebates. For the current record (INTSTATUS = 0), this is equivalent to STORERNG.curAvgRebates.
CURSALES DECIMAL(19,6) The value of sales for this item. Based on STOCKAUDIT.curSales.
CURTAXAMT1 DECIMAL(19,6) The value of tax for this item. Based on STOCKAUDIT.curTaxAmt1.
CURTAXAMT2 DECIMAL(19,6) The value of tax for this item. Based on STOCKAUDIT.curTaxAmt2.
CURTAXAMT3 DECIMAL(19,6) The value of tax for this item. Based on STOCKAUDIT.curTaxAmt3.

LINTFINALREFERENCE

INT

The code of the stocktake which marked this record as completed (Changed intStatus to 0).

DBLQTYSTOCKTAKEADJ

DECIMAL(19,6)

 

CURLASTINVSTOCKTAKEADJ

DECIMAL(19,6)

 

CURAVGSTOCKTAKEADJ

DECIMAL(19,6)

 

CURREBATESTOCKTAKEADJ

DECIMAL(19,6)

 

 

Primary Key: CTRCODE

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