Navigation:  Budget >

Budget General Overview Profile

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic


General Summary

Provide a tool to create, save and compare budgets from various baselines. Integrate the budget requirements into the main stream of the business and assess the results.



Baseline –  A snapshot of information for a particular period. Many snapshots are kept for the same entities over the entire life of the budget. An example would be : 2002-2003 09 03

Baseline Id – The identifying name given to the snapshot.

Original Baseline – The baseline that was considered the most accurate when the budgeting cycle started given certain assumptions and rules. There can be more than one because the assumptions and rules may have changed requiring a new original baseline.

Budget Concept- within a grouping and sub grouping and program that relates to the organization in which one can identify and save the envisaged costs or revenue and against which one can compare the eventual reality. A budget may consist of only one budget type.

Budget Id – The identifier given to the budget

Budget Type – Valid types of  budgets namely : Contract, capital, project, division, cost centre and own funded.

Budget Grouping – The main group to which the budget belongs e.g. production or engineering

Budget Sub Grouping – A secondary optional budget grouping.

Budget Program - A further budget grouping – generally for various programs identified by the company

Organisation Relation Id – An entity within the organization to which this budget relates e.g. contract number

Entity – An object for which a budget is required as it will may costs and it may accumulate revenue.

Budget Entity Type –Accounts, Nodes or Orders.

Link between Entity Types and Budget Types – Orders may exist in Contract budgets only Nodes may exist in project, own funded and capital budgets Accounts may exist in all except project budgets Cost centre and Division budgets contain only accounts

Budget Entity Id -The actual account or node. In the case of orders, it is the order number. The entire entity for orders is the budget entity id, budget entity order type, budget entity line number and budget entity completion date.

Locked -Availability of the budget to the budget managers – when assessments are made, the budget will be locked to ensure that the snapshots remain unchanged.

Budget Resource Type – Material or Labour

Budget Amount Type –These are either : planned commitments, released commitments, actual costs, budgeted costs, budgeted sales, actual sales, budgeted purchases ,actual purchases, budget additional cost sales, actual additional cost sales, budget additional cost purchases, actual additional cost purchases, budget credit sales, actual credit sales, budget credit purchases, actual credit purchases, actual advance payments, actual advance payment credits and actual prepayments.

Budget Source – This is the source (table) from which the data is derived – namely : Account Budget, Budget System, Node Labour Budget – Bcws, Node Labour Budget – Lcws, Node Labour Budget Scenario, Node Material Budget – Bcws, Node Material Budget – Lcws, Node Material Budget Scenario, Order Line Customer, Order Line Purchases, Order Operations, Order And Part Operations, Order Requirements, Part Operations, Requisitions, Timesheets, Budget Resource Account Allocation, Budget Schedule Account Allocation, Budget Manpower Account Allocation, Budget Capital Account Allocation, Budget Labour Account Allocation and Budget Account To Account Allocation

Extraction Date – This is the date that the download extraction was performed or the date when the budget was updated. It is always the date of the latest extraction per parameters (usually the key) that was made.

Pay Ship Period – This is the financial period in which the payment or shipment was made or planned to be made but is derived by adding the payment terms to the completion dates financial period

Completion Date - The date held on the system from which to calculate the payment or shipment date – the completion date of the order

Budget Owner Type – Client or Supplier.

Budget Line Type – Payment, shipment or both a payment and a shipment.

Type of Payment/Deliv  -Final, Advance,  Progress, retention, escalation, prepayment or advance payment types of payment or shipment

Budget status- The statuses that the entities may be in are : planned, approved, company approved, board approved, released, rejected, suspended, closed, depending on the level of approval of the budgets linked to those entities.

Budget Source-        A source table from which data was extracted – e.g. node labour scenario table

Post Id – The identifier of a post from the Human Resource system


Budget Appointment Type –  Different types of employee appointments

Download - Taking data from the ERP (main)system and entering it in the Budget Systems tables

Upload - Taking data from Budget Systems tables and entering it in the ERP (main) systems  tables



Profiles :                


The following profiles exist in the Budget System see Profile doc.

For detail rules for the Budget header : see Profile header doc.


Entity Rules :


The same budget entity may not occur more than once per baseline, unless it is an account entity belonging to a capital budget. (The same account may exist on more than 1 capital budget for the same baseline)


An account entity may belong to many contract and own funded budgets and a single division budget for the same baseline


An account entity may belong to many capital budgets for the same baseline as well as to a single division budget


An account entity may belong either to capital budgets for a baseline OR to non capital budgets per baseline.


A node entity may occur only once per baseline


A node may not exist as a node entity and also exist in the structure of a milestone node on a non stock customer order line as an order entity for the same baseline.


An entity may occur only once per budget id per baseline.