Data dictionary

Data dictionary names provide a shortcut or a simplified way to access information to calculate a budget. Lawson provides a data dictionary, which contains a set of pre-defined data dictionary names you use to access activity information for these calculations. For example, if you select YTDACA, then the system retrieves year-to-date activity amounts. You cannot change or add to the pre-defined dictionary.

Note: You can run Data Dictionary Listing (RW205) to create a data dictionary listing.

See Data dictionary listing.

You can also view a list of data dictionary names and how their parameters are used from Compute Statement (RW50.1).

Examples of data dictionary names


Data dictionary name	Description
LTDACT	Life To Date Activity Total
PRDACU	Period Activity Units
YTDACB	Year To Date Activity Budget

Parameters

Most data dictionary names accept parameters. These parameters identify more specifically what data is retrieved. For example, with the data dictionary name YTDACA, you specify the year and period in which you are interested. Parameters attached to a data dictionary name are unique from and operate in addition to any compute parameters you define and use with a compute statement.

See Compute parameters.

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

There is no current year and period in Project Accounting. If you use a data dictionary name with a parameter that identifies current year, then the current year is presumed as the year defined on Allocation Calculation (AC130).


Name	Description	Parameters
YTDACA	Year To Date Activity Amount	This item accepts optional year and period parameters. For example, YTDACA(,9) represents year-to-date activity for the current year through period nine. YTDACA(1,9) represents return year-to-date activity for the previous year through period nine.