Home > Technical > Table Definitions > STORERNG

STORERNG

This table contains a record for each item at each store. It is basically a snapshot of the item, including costs and sells. The details are actually a summary of the associate RANGE, ITEM, COST and SELL records.

Column Type Description
STRSTORECODE VARCHAR(10) The trading unit this snapshot is for.
TRADUNIT.strTradeCode 
LINTITEMNUMBER INT The IPN of the item this snapshot is for.
ITEM.lintItemNumber
STRSUPPLIERCODE VARCHAR(10) Supplier this item can be purchased from.
SUPPLIER.strSupplierCode
STRORDERCODE VARCHAR(20) Supplier’s order code for this item.
STRMANUFACTURER VARCHAR(10) Original manufacturer for this item.
SUPPLIER.strSupplierCode
LINTRANGECODE INT Determined when we get the cost for the item. This points to the RANGE record to which the cost belongs.
RANGE.lintRangeCode
STRCOMPETITION VARCHAR(10) Not currently used.
INTCARTONSIZE DECIMAL(9,3) The number of units in a carton.
INTLASTCARTONSIZE DECIMAL(9,3) The number of units in the previous carton.
INTMINORDER DECIMAL(9,3) The minimum number of units which can be purchased at a time. Normally the same as intCartonSize.
STRCOSTTYPE VARCHAR(10) The type of cost. Normal/Deal/Our
STRCOSTTRADEUNIT VARCHAR(10) The trading unit for which this cost was original recorded. For example, the best cost for a specific store was actually the cost nominated for the state. This code would then be the state trading unit code.
TRADUNIT.strTradeCode
CURCOST DECIMAL(19,4) The current carton cost (inc GST/VAT).
CURLANDEDCOST DECIMAL(19,4) The current landed carton cost. This is ex GST/VAT.
DTMBUYSTART DATETIME The date the cost starts.
DTMBUYEND DATETIME The date the cost ends. If a normal cost is in effect, this date will be empty to signify that it never ends.
CURNORMALCOST DECIMAL(19,4) The normal carton cost. This is inc GST/VAT.
CURLANDEDNORMALCOST DECIMAL(19,4) The normal carton landed cost. This is ex GST.
CURCASEDEAL DECIMAL(19,4) Not currently used.
CURDEALAMT DECIMAL(19,4) Not currently used.
CURDEFERCASEDEAL DECIMAL(19,4) Not currently used.
CURDEFERDEALAMT DECIMAL(19,4) Not currently used.
CURLASTCOST DECIMAL(19,4) The last carton cost.
YSNNORMALCOSTCHANGE VARCHAR(1) Not currently used.
DBLREBATEPER DECIMAL(19,4) Not currently used.
STRSELLTYPE VARCHAR(10) The type of sell. Normal/Promo.
STRSELLTRADEUNIT VARCHAR(10) The trading unit for which this sell was original recorded. For example, the best sell for a specific store was actually the sell nominated for the state. This code would then be the state trading unit code.
TRADUNIT.strTradeCode
CURSELL DECIMAL(19,4) The current unit sell.
DTMSELLSTART DATETIME The date the sell starts.
DTMSELLEND DATETIME The date the sell ends. If a normal sell is in effect, this date will be empty to signify that it never ends.
LINTPROMOCODE INT The promotion code currently in effect, if any.
PROMOHDR.lintPromoCode
STRPROMOTYPE VARCHAR(10) The type of promotion in effect, if any.
CURNORMALSELL DECIMAL(19,4) The normal sell price.
STRINCDECSELL VARCHAR(1) If the sell price has changed, indicates the type of change. I=Increase, D=Decrease.
DBLNORMALMARGIN DECIMAL(19,4) The normal margin calculated on the normal cost and normal sell.
DBLCURRENTMARGIN DECIMAL(19,4) The current margin calculated on the current cost and sell.
CUROVERRIDESELL DECIMAL(19,4) The sell price to be used instead of curSell.
STROVERRIDEREASON VARCHAR(15) The reason for the override.
DTMOVERRIDESTART DATETIME The date the override sell started.
DTMOVERRIDEEND DATETIME The date the override sell will end.
STROVERRIDEWHO VARCHAR(20) The user who set the override
YSNSTOCKED VARCHAR(1) ‘T’ if the item is stocked at the store. ‘F’ if the item is no longer stocked. If this is 'F' the item will not appear on a stocktake.
DBLRATEOFSALE DECIMAL(19,4) The rate of sale for the item. This will be set by the Suggest Stock Levels EOD process.
DTMLASTTICKET DATETIME The date a ticket was last printed for this item at the store.
INTTICKETREQUIRED SMALLINT The number of tickets required.
STRTICKETTYPE VARCHAR(2) Indicates the profitability of the item. This can then be printed on tickets to help layout stock.
ITEM.strTicketType
INTWEEKSCOUNT SMALLINT No longer used.
YSNNEW VARCHAR(1) No longer used.
YSNDELETED VARCHAR(1) No longer used.
YSNCHANGED VARCHAR(1) No longer used.
YSNCHANGECARTONCOST VARCHAR(1) No longer used.
YSNCHANGECARTONSIZE VARCHAR(1) No longer used.
YSNCHANGEMINORDER VARCHAR(1) No longer used.
YSNCHANGEORDER VARCHAR(1) No longer used.
YSNCHANGESELL VARCHAR(1) No longer used.
YSNCHANGESUPPLIER VARCHAR(1) No longer used.
YSNCHANGEITEM VARCHAR(1) No longer used.
DBLLASTSTOCKTAKEQTY DECIMAL(19,4) No longer used.
DTMLASTSTOCKTAKE DATETIME No longer used.
DBLCURRENTSTOCKTAKEQTY DECIMAL(19,4) No longer used.
DTMCURRENTSTOCKTAKE DATETIME No longer used.
CURLASTINVOICECOST DECIMAL(19,4) The unit cost of this item as per the last invoice  (ex GST/VAT).
CURAVGCOST DECIMAL(19,6) The average unit cost of this item (ex GST/VAT).
YSNCHANGELASTSTOCKTAKE VARCHAR(1) No longer used.
YSNCHANGECURRENTSTOCKTAKE VARCHAR(1) No longer used.
YSNCHANGELASTINVOICECOST VARCHAR(1) No longer used.
YSNCHANGEAVGCOST VARCHAR(1) No longer used.
CURCURRENTSELL2 DECIMAL(19,4) The second unit sell price.
DBLCURRENTMARGIN2 DECIMAL(19,4) The second current margin (see dblCurrentMargin above).
CURNORMALSELL2 DECIMAL(19,4) The second normal sell price.
DBLNORMALMARGIN2 DECIMAL(19,4) The second normal margin (see dblNormalMargin above).
CURCURRENTSELL3 DECIMAL(19,4) The third unit sell price.
DBLCURRENTMARGIN3 DECIMAL(19,4) The third current margin (see dblCurrentMargin above).
CURNORMALSELL3 DECIMAL(19,4) The third normal sell price.
DBLNORMALMARGIN3 DECIMAL(19,4) The third normal margin (see dblNormalMargin above).
CURCURRENTSELL4 DECIMAL(19,4) The fourth unit sell price.
DBLCURRENTMARGIN4 DECIMAL(19,4) The fourth current margin (see dblCurrentMargin above).
CURNORMALSELL4 DECIMAL(19,4) The fourth normal sell price.
DBLNORMALMARGIN4 DECIMAL(19,4) The fourth normal margin (see dblNormalMargin above).
CURCURRENTSELL5 DECIMAL(19,4) The fifth unit sell price.
DBLCURRENTMARGIN5 DECIMAL(19,4) The fifth current margin (see dblCurrentMargin above).
CURNORMALSELL5 DECIMAL(19,4) The fifth normal sell price.
DBLNORMALMARGIN5 DECIMAL(19,4) The fifth normal margin (see dblNormalMargin above).
CUROVERRIDESELL2 DECIMAL(19,4) The second override sell price (see curOverrideSell above).
CUROVERRIDESELL3 DECIMAL(19,4) The third override sell price (see curOverrideSell above).
CUROVERRIDESELL4 DECIMAL(19,4) The fourth override sell price (see curOverrideSell above).
CUROVERRIDESELL5 DECIMAL(19,4) The fifth override sell price (see curOverrideSell above).
DBLSTOCKONHAND DECIMAL(19,6) The current stock on hand.
DBLMINSTOCKQTY DECIMAL(19,4) The minimum stock on hand quantity that should be kept.
DBLMAXSTOCKQTY DECIMAL(19,4) The maximum stock on hand quantity that should be kept.
YSNCHANGESTOCKED VARCHAR(1) No longer used.
YSNCHANGEDELETED VARCHAR(1) No longer used.
CUREXTAXCOST DECIMAL(19,4) The current ex-tax cost. This is ex deals, fees and taxes.
CURSERVICEFEE DECIMAL(19,4) The service fee based on the current ex-tax cost.
CURULLAGEFEE DECIMAL(19,4) The ullage based on the current  ex-tax cost.
CURSALESTAX DECIMAL(19,4) The sales tax based on (current ex-tax cost+service fee+ullage).
CURFREIGHT DECIMAL(19,4) The freight charge on the current landed cost.
CURLIQUORTAX DECIMAL(19,4) No longer used.
STRSERVICEMETHOD VARCHAR(10) The method used to calculate current service fee.1=% of Cost2=$/Carton
STRULLAGEMETHOD VARCHAR(10) The method used to calculate current ullage.1=% of Cost2=$/Carton
STRFREIGHTMETHOD VARCHAR(10) The method used to calculate current freight.2=$/Carton3=$/kg
STRPROPOSEORDERCODE VARCHAR(10) No longer used.
STRPROPOSESUPPLIERCODE VARCHAR(10) No longer used.
CURNETTNORMALCOST DECIMAL(19,4) The normal ex tax cost.
CURNORMALSALESTAX DECIMAL(19,4) The sales tax based on (normal ex-tax cost+service fee+ullage).
CURNORMALULLAGEFEE DECIMAL(19,4) The ullage based on the normal ex-tax cost.
CURNORMALSERVICEFEE DECIMAL(19,4) The service fee based on the normal ex-tax cost.
CURNORMALLIQUORTAX DECIMAL(19,4) No longer used.
CURNORMALFREIGHT DECIMAL(19,4) The freight charge on the normal landed cost.
STRNORMALFREIGHTMETHOD VARCHAR(10) The method used to calculate current freight.2=$/Carton3=$/kg
STRNORMALSERVICEMETHOD VARCHAR(10) The method used to calculate current service fee.1=% of Cost2=$/Carton
STRNORMALULLAGEMETHOD VARCHAR(10) The method used to calculate current ullage.1=% of Cost2=$/Carton
DBLORDEREDQTY DECIMAL(19,6) The number of units currently on order.
STRCREATEPERIOD VARCHAR(7) The weekly period the record was created.Link
STATSPER.strYearWeek
CURAVGINVCOST DECIMAL(19,4) No longer used.
STRXREFCODE VARCHAR(20) No longer used.
STRSTRIPORDERCODE VARCHAR(20) The strOrderCode field with non-alpha characters stripped out, that is - / *, and so on. This allows a search to be done without regard to such characters.
DBLALLOCATEDQTY DECIMAL(19,6) The amount of stock which has been allocated to uncommitted sales. This quantity is also included in the dblStockOnHand because its still stock that needs to be counted.
DBLDISPLAYQTY DECIMAL(19,4) The number of units stock which are required to show on the shelf. This is used as part of suggested ordering.
DBLREORDERQTY DECIMAL(19,4) When stock drops to this level, it will be reordered within a suggested order, provided at least one item has been ordered because its stock has dropped to dblMinStockQty. This works along the lines of 'if I have to order an item I may as well order other items which have dropped to this level'.
CURWETAMT DECIMAL(19,4) The amount of WET tax to be paid on the cost.
CURNORMALWETAMT DECIMAL(19,4) The amount of WET to be paid on the normal cost.
STRSELLTAXCODE VARCHAR(10) The tax code representing the tax include in the sell price.
TAX.strTaxCode
CURFINALCOST DECIMAL(19,4) The final cost of the item. Includes all trading terms.
CURNORMALFINALCOST DECIMAL(19,4) The normal final cost of the item
YSNREORDERREQUIRED VARCHAR(1) Defaults to 'F'. A trigger on the table will set this to 'T' if the stockonhand falls below the minimum or reorder quantities.
DTMLASTSOLD DATETIME The date the item was last sold.
DTMLASTRECEIVED DATETIME The date the item was last received (either via a goods receipt or a transfer).
INTCHANGEFLAG INT An incrementing number that changes each time the item is changed. This can be used by EOD processes to determine which items have changed since the last time the EOD process was run.
INTNEWFLAG INT Similar to INTCHANGEFLAG but indicates that the item is new.
INTCHANGESELL INT Similar to INTCHANGEFLAG but indicates that the sell has changed.
INTCHANGECOST INT Similar to INTCHANGEFLAG but indicates that the cost has changed.
STRCOSTCURRENCYCODE VARCHAR(5) The code of the currency that the cost is in.

CURRENCYCODE.strCurrencyCode

STRSELLCURRENCYCODE VARCHAR(5) The code of the currency that the sell is in.

CURRENCYCODE.strCurrencyCode

STRNORMCOSTCURRENCYCODE VARCHAR(5) The code of the currency that the normal cost is in.

CURRENCYCODE.strCurrencyCode

STRNORMSELLCURRENCYCODE VARCHAR(5) The code of the currency that the normal sell is in.

CURRENCYCODE.strCurrencyCode

DBLRETURNEDQTY DECIMAL(19,6) The quantity of stock marked for return to supplier. This quantity is also included in the dblStockOnHand because its still stock that needs to be counted.
DBLINTRANSITQTY DECIMAL(19,6) The quantity of stock marked as in transit. This quantity is also included in the dblStockOnHand because its still stock that needs to be counted.
CURAVGREBATES DECIMAL(19,6) Average of any expected rebates. This is ex tax.
DTMLASTORDERED DATETIME Date the item was last ordered. This can be from a purchase order or a transfer request.
DBLSOLDSINCEORDER DECIMAL(19,4) The quantity sold since the last order was created.
YSNVISUALVERIFY VARCHAR(1) If this is 'T', POS will prompt the user to ensure the price is correct.
DBLREQUESTEDQTY DECIMAL(19,6) The number of units that have been requested from this location. Used with warehouses to determine the total quantity that has been requested from stores.
DTMMINMAXCHG DATETIME The date the min/max quantities were recalculated. Used for audit purposes only.
DBLMINSTOCKCOVER DECIMAL(19,4) The minimum stock cover value that was used to calculate the dblMinStockQty. Used for audit purposes only.
DBLMAXSTOCKCOVER DECIMAL(19,4) The maximum stock cover value that was used to calculate the dblMaxStockQty. Used for audit purposes only.
DBLREORDERSTOCKCOVER DECIMAL(19,4) The reorder stock cover value that was used to calculate the dblReorderQty. Used for audit purposes only.
DBLLEADCOVER DECIMAL(19,4) The lead cover value that was used to when calculating supplier lead time. Used for audit purposes only.
DBLSEASONALFACTOR DECIMAL(19,4) The seasonal factor value that was used to calculate the min/max stock levels. Used for audit purposes only.
DTMNOPOSRETURNAFTER DATETIME The date after which the POS cannot return this item. Determined from ITEMSPECIALDATES.
DTMNOSUPPLIERRETURNAFTER DATETIME The date after which the item cannot be returned to a supplier. Determined from ITEMSPECIALDATES.
DTMNOTRANSFERAFTER DATETIME The date after which the item cannot be transferred. Determined from ITEMSPECIALDATES.
DTMNOPOSSELLAFTER DATETIME The date after which the POS cannot sell this item. Determined from ITEMSPECIALDATES.
DTMNOINVENTORYBEFORE DATETIME The date before which inventory cannot be adjusted for this item. Determined from ITEMSPECIALDATES.
STRFREQCODE VARCHAR(10) The frequency code used to determine when an item can be ordered.
ORDERFREQUENCY.strFrequencyCode
DTMNOPOSSELLBEFORE DATETIME The date before which the POS cannot sell this item. Determined from ITEMSPECIALDATES.

YSNPURCHASE

VARCHAR(1)

'T' if we are allowed to purchase the item for this location. If 'F', the item cannot be manually ordered or included in suggested orders.

STRWAREHOUSELOCATION

VARCHAR(10)

The code of the warehouse location from which this item will be supplied.

TRADUNIT.strTradeCode

STRWAREHOUSEFREQCODE

VARCHAR(10)

The code of the order frequency that shows when we can get the item from the warehouse.

ORDERFREQUENCY.strFrequencyCode

 
Primary Key: LINTITEMNUMBER + STRSTORECODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)