Home > Technical > Table Definitions > BUDGET

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
2=Forecast
3=Target

 

Primary Key: INTTYPE + STRSTORECODE + STRDEPTCODE + STRCATCODE + STRGROUPCODE + STRYEARWEEK + STRMANUFACTURER

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