Home > Technical > Table Definitions > BUDGET
This table contains *budget* sales, purchases and other miscellaneous numbers at a department/category/group level. Budget information is not available at the item level.
Column | Type | Description |
STRYEARWEEK | VARCHAR(7) | The period
in which the statistics were collected. STATSPER.strYearWeek |
STRSTORECODE | VARCHAR(10) | The trading
unit these statistics are for. TRADUNIT.strTradeCode |
STRDEPTCODE | VARCHAR(10) | The
department the statistics belong to. DEPT.strDeptCode |
STRCATCODE | VARCHAR(10) | The
department the statistics belong to. CATEGORY.strCatCode |
STRGROUPCODE | VARCHAR(10) | The
department the statistics belong to. GROUPS.strGroupCode |
STRMANUFACTURER | VARCHAR(10) | Budgets are not kept at the manufacturer level. This will be '*TOT*'. |
DBLQTYSOLD | DECIMAL(19,4) | Number of units sold. Updated by system. |
CURCOGS | DECIMAL(19,4) | Cost of Goods Sold. Updated by system. |
CURSALES | DECIMAL(19,4) | Sales revenue. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
CURPLANSALES | DECIMAL(19,4) | Planned sales revenue. |
LINTCUSTOMERS | INT | Number of customers who purchased items from this department. Updated by system. |
CURTOTALWAGES | DECIMAL(19,4) | Total wages. Can be entered using Statistics Entry. |
CUROTWAGES | DECIMAL(19,4) | Overtime wages. Can be entered using Statistics Entry. |
CURFTWAGES | DECIMAL(19,4) | Fulltime wages. Can be entered using Statistics Entry. |
CURPTWAGES | DECIMAL(19,4) | Parttime wages. Can be entered using Statistics Entry. |
DBLLABOURHRSTOTAL | DECIMAL(19,4) | Labour hours. Can be entered using Statistics Entry. |
DBLLABOURHRSOT | DECIMAL(19,4) | Overtime labour hours. Can be entered using Statistics Entry. |
DBLLABOURHRSFT | DECIMAL(19,4) | Fulltime labour hours. Can be entered using Statistics Entry. |
DBLLABOURHRSPT | DECIMAL(19,4) | Parttime labour hours. Can be entered using Statistics Entry. |
CURPLANWAGESTOTAL | DECIMAL(19,4) | Planned total wages. |
DBLPLANHRSTOTAL | DECIMAL(19,4) | Planned total labour hours. |
DBLPLANHRSOT | DECIMAL(19,4) | Planned overtime labour hours. |
DBLPLANHRSFT | DECIMAL(19,4) | Planned fulltime labour hours. |
DBLPLANHRSPT | DECIMAL(19,4) | Planned parttime labour hours. |
CURWORKCOMP | DECIMAL(19,4) | Workers’ compensation expenses. |
CURFREIGHT | DECIMAL(19,4) | Freight expenses. Can be entered using Statistics Entry. |
CURMARKDOWN | DECIMAL(19,4) | Markdown expenses. Can be entered using Statistics Entry. |
CURDAMAGE | DECIMAL(19,4) | Damages expenses. Updated by system. |
CURCASHSHORTOVER | DECIMAL(19,4) | Cash short/over expenses. Updated by system. |
CURCASHTENDER | DECIMAL(19,4) | Cash tendered at POS register. |
CUREFTTENDER | DECIMAL(19,4) | EFT tendered at POS register. |
CURCHEQUETENDER | DECIMAL(19,4) | Cheques tendered at POS register. |
CURBAGSWRAP | DECIMAL(19,4) | Bags & Wrap expenses. Can be entered using Statistics Entry. |
CURPURCHASES | DECIMAL(19,4) | Value of stock purchases. Updated by system. |
DBLQTYPURCHASED | DECIMAL(19,4) | Number of units purchased. Updated by system. |
INTTROLLEYCOUNT | SMALLINT | Number of trolleys. Can be entered using Statistics Entry. |
CUROFFINVOICEDEAL | DECIMAL(19,4) | Total value of off-invoice deals. |
CURCLAIMDEAL | DECIMAL(19,4) | Total value of claims. |
CURTERMS | DECIMAL(19,4) | Total value of terms. Updated by system (when rebates are claimed). |
DBLPLANQTYHR | DECIMAL(19,4) | Planned quantity sold/labour hour. |
CURPLANLABOURCOST | DECIMAL(19,4) | Planned labour cost. |
CURAVGSALE | DECIMAL(19,4) | Average sale price per unit. |
CURSTAFFDISCOUNT | DECIMAL(19,4) | Staff discount expenses. |
CURDISCOUNT | DECIMAL(19,4) | Discount expenses. |
CURSHRINKAGE | DECIMAL(19,4) | Shrinkage expenses. Updated by system. |
CURINSTOREDEALS | DECIMAL(19,4) | Value of instore deals. |
CURSERVICEFEE | DECIMAL(19,4) | Service fee expenses. |
CURWAREHOUSEREBATE | DECIMAL(19,4) | Value of warehouse rebates. |
CURREBATE | DECIMAL(19,4) | Value of other rebates. |
CURSTOCKTAKEADJ | DECIMAL(19,4) | Value of stocktake adjustment. |
CUROTHERADJ | DECIMAL(19,4) | Other adjustment expenses. |
CURGROSSPURCHASES | DECIMAL(19,4) | Gross value of purchases. Updated by system. |
CURROUNDING | DECIMAL(19,4) | Value of rounding. |
CURCOOPAMT | DECIMAL(19,4) | Value of promotional coops. |
CURREPORTSALES | DECIMAL(19,4) | Sales as reported by the store. |
CURREPORTCOGS | DECIMAL(19,4) | COGS as reported by the store. |
CURPHYSICALOPENSTOCK | DECIMAL(19,4) | Physical opening stock for the period. |
CURPHYSICALCLOSESTOCK | DECIMAL(19,4) | Physical closing stock for the period. Updated by system. |
CURSPECIALSALES | DECIMAL(19,4) | Sales revenue for items on promotion. |
CURSPECIALCOGS | DECIMAL(19,4) | COGS for items on promotion. |
CURGP | DECIMAL(19,4) | GP dollars. |
CURREPORTGP | DECIMAL(19,4) | GP dollars as reported by the store. |
CURREPORTPURCHASES | DECIMAL(19,4) | Estimated purchases as reported by the store. |
CURREPORTADJPURCHASES | DECIMAL(19,4) | Difference between actual and estimated purchases for the period. |
CURREPORTTOTPURCHASES | DECIMAL(19,4) | This weeks estimated plus last weeks adjustment. |
CURLEDGERCLOSESTOCK | DECIMAL(19,4) | Closing stock according to the ledger. |
CURPCCLOSESTOCK | DECIMAL(19,4) | Closing stock according to the computer. |
DBLSTOREPCMARGIN | DECIMAL(19,4) | The sales margin according to the store’s computer. |
CURLIQUORLICENCE | DECIMAL(19,4) | Liquor licence fees for the period. |
DBLREPORTQTYSOLD | DECIMAL(19,4) | Units sold as reported by the store. |
DBLREPORTQTYPURCHASED | DECIMAL(19,4) | Units purchased as reported by the store. |
CURNETPROFIT | DECIMAL(19,4) | The net profit (gross profit less expenses). |
CURREPORTNETPROFIT | DECIMAL(19,4) | The net profit as reported by the store. |
CURREPORTSPECIALSALES | DECIMAL(19,4) | The sales for items on promotion as reported by the store. |
CURREPORTSPECIALCOGS | DECIMAL(19,4) | The COGS for items on promotion as reported by the store. |
CURPACKAGING | DECIMAL(19,4) | Packaging expense. |
CURINGREDIENTS | DECIMAL(19,4) | Ingredients expense. |
CURCASUALWAGES | DECIMAL(19,4) | Casual labour wages. Can be entered using Statistics Entry. |
DBLLABOURHRSCASUAL | DECIMAL(19,4) | Casual labour hours. Can be entered using Statistics Entry. |
DBLPLANHRSCASUAL | DECIMAL(19,4) | Planned casual labour hours. |
DBLPLANGPPER | DECIMAL(19,4) | Planned GP percent |
CURCOMPETITIONADJ | DECIMAL(19,4) | Adjustment to prices because of competition. |
CURTRANSFER | DECIMAL(19,4) | The value of stock transferred. Updated by system. |
CURMANAGEMENTWAGES | DECIMAL(19,4) | The value of management wages. |
DBLLABOURHRSMANAGEMENT | DECIMAL(19,4) | The number of management hours worked. |
DBLPLANHRSMANAGEMENT | DECIMAL(19,4) | The planned number of management labour hours. |
CURONCOSTS | DECIMAL(19,4) | The costs associated with wages. |
CURPLANONCOSTS | DECIMAL(19,4) | The planned costs associated with wages. |
CURPROMOTIONS | DECIMAL(19,4) | Promotional expenses. |
CURCORPRECOVERY | DECIMAL(19,4) | Corporate recovery expenses. |
CURDELETEDLINES | DECIMAL(19,4) | Deleted lines expense. |
CURMANAGEMENTLOSS | DECIMAL(19,4) | Management loss expense. |
CURINDIRECT | DECIMAL(19,4) | Indirect expenses |
CURBRNCEXP | DECIMAL(19,4) | Branch NC Expenses |
CURBRDIRECTEXP | DECIMAL(19,4) | Branch direct expenses |
CURBRINDIRECTEXP | DECIMAL(19,4) | Branch indirect expenses |
CURBRCONTPROFIT | DECIMAL(19,4) | Branch contribution to profit |
CURHOEXP | DECIMAL(19,4) | Head office expenses |
CURPCSTOCKRETAIL | DECIMAL(19,4) | The retail value of stock. |
DBLPCSTOCKQTY | DECIMAL(19,4) | The quantity of stock. |
DBLLITRESSOLD | DECIMAL(19,4) | A unique number assigned by the system. |
DBLKILOSSOLD | DECIMAL(19,4) | The number of litres sold. |
DBLCARTONSSOLD | DECIMAL(19,4) | The number of kilos sold. |
DBLLITRESPURCHASED | DECIMAL(19,4) | The number of cartons sold. |
DBLKILOSPURCHASED | DECIMAL(19,4) | The number of litres purchased. |
DBLCARTONSPURCHASED | DECIMAL(19,4) | The number of kilos purchased. |
CURTAXAMT | DECIMAL(19,4) | The amount of tax charged on sales. |
CURSALES1 | DECIMAL(19,4) | The sales on the first day of the period. curSales is the total of sales within the period. Although not normalised, provides a useful means of showing trends within a week and easily accumulating sales for a day of week. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
CURSALES2 | DECIMAL(19,4) | The sales on the second day of the period. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
CURSALES3 | DECIMAL(19,4) | The sales on the third day of the period. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
CURSALES4 | DECIMAL(19,4) | The sales on the fourth day of the period. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
CURSALES5 | DECIMAL(19,4) | The sales on the fifth day of the period. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
CURSALES6 | DECIMAL(19,4) | The sales on the sixth day of the period. If using GST Tax System, then this amount is GST exclusive. Updated by system. |
CURSALES7 | DECIMAL(19,4) | The sales on the seventh day of the period. If using GST Tax System, then this amount is GST exclusive. |
DBLQTYSOLD1 | DECIMAL(19,4) | The quantity sold of the first day of the period. Updated by system. |
DBLQTYSOLD2 | DECIMAL(19,4) | The quantity sold of the second day of the period. Updated by system. |
DBLQTYSOLD3 | DECIMAL(19,4) | The quantity sold of the third day of the period. Updated by system. |
DBLQTYSOLD4 | DECIMAL(19,4) | The quantity sold of the fourth day of the period. Updated by system. |
DBLQTYSOLD5 | DECIMAL(19,4) | The quantity sold of the fifth day of the period. Updated by system. |
DBLQTYSOLD6 | DECIMAL(19,4) | The quantity sold of the sixth day of the period. Updated by system. |
DBLQTYSOLD7 |
DECIMAL(19,4) |
The quantity sold of the seventh day of the period. Updated by system. |
INTTRANSCOUNT |
INTEGER |
The number of transactions. |
CURTAXAMT1 |
DECIMAL(19,4) |
The expected value of tax 1 (CESS). |
CURTAXAMT3 |
DECIMAL(19,4) |
The expected value of tax 1 (Service Fee). |
INTTYPE |
INTEGER |
Indicates the type of data being stored in the BUDGET table. 1= Budget |
Primary Key: INTTYPE + STRSTORECODE + STRDEPTCODE + STRCATCODE + STRGROUPCODE + STRYEARWEEK + STRMANUFACTURER
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |