BUDGET GENERAL OVERVIEW PROFILE
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 date’s 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 System’s tables
Upload - Taking data from Budget System’s tables and entering it in the ERP (main) system’s tables
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.