Data dictionary

Data dictionary names provide a shortcut to, or a simplified way to access information you will use to calculate a budget. Lawson provides a data dictionary, which contains a set of predefined names that you use to access information for these calculations. For example, if you select CPBUD, then the current period budget amounts are retrieved. Select CYDAMT to include current year-to-date actual amounts. You cannot change or add to the predefined dictionary.

Note: You can run Data Dictionary Listing (RW205) to create a data dictionary listing or see the Report Writer User Guide. You can also view a list of data dictionary names and how their parameters are used in Compute Statement (RW50.1).

Examples of data dictionary names


Data dictionary name	Description
CPBUD	Current Period Budget
CPBUN	Current Period Budget Units
CYDBUD	Current Year-to-Date Budget

Parameters

For General Ledger data dictionary names, you can specify the accounting units and accounts from which you will retrieve data using any of these parameters:


Company and accounting unit	Accounts	Subaccounts
a company and an accounting unit a company group and an accounting unit a list of accounting units	a range of accounts an account group	a range of subaccounts a subaccount group

Note: When you select data dictionary names, you can use Drill Around to see the optional parameters allowed.

Most data dictionary names accept parameters. These parameters identify more specifically what data to retrieve. Parameters attached to a data dictionary name are unique from and operate in addition to any compute parameters that you define and use with a compute statement.


Name	Description	Parameters
CPBUD	Current Period Budget	This variable accepts a budget parameter and an optional accounting unit parameter. CPBUD(23) - Current period budget for budget number 23 CPBUD(,111) - Current period budget for accounting unit (111). Budget number will be specified later.