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