|
|
ACSPREADX FILE
Activity Spread Code Detail
This file contains detailed information on spread codes from AC23.1 (Spread
Codes). It includes spread code, period, and percentage of budget.
REFERENCED BY
AC121 AC123 AC127 AC20.2 AC20.3 AC20.4
AC20.5 AC21.1 AC21.2 AC21.3 AC21.4 AC22.1
AC223 AC27.1
UPDATED BY
AC23.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SPX-SPREAD-CODE Alpha 3 AC23.1
Element: Spread Code Required key. A spread code is a
formula for budgeting spending activity
that can be set up in AC23.1 (Spread
Codes) for each account category. You
can use a spread code to schedule
spending over the life of the activity
or activity group. Spread codes can be
used to represent characteristic
spending patterns.
SPX-PERIOD Numeric 2 AC23.1
Element: Period Required key. This is the period for
the spread code.
SPX-PERC-OF-TIME Signed 8.5 AC23.1
Element: Perc Of Time This field defines the percentage of
budget for this period for the spread
code.
This field indicates the percent of the
total budget of the activity to be
allocated to the time interval. The
Percent of Budget field is repeated for
each time interval on the form.
The sum of the entries in the Percent
of Budget fields must be 100 percent. If
the entries total less than 100 percent,
the Activity Management system makes an
additional entry, automatically bringing
the total to 100 percent. If the entries
total more than 100 percent, add and
change are not allowed and an error
message displays.
ACSPREADX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SPXSET1 SPREAD-CODE AC121 AC123
PERIOD AC127 AC20.2
AC20.3 AC20.4
AC20.5 AC21.1
AC21.2 AC21.3
AC21.4 AC22.1
AC223 AC23.1
AC27.1
ACSPREADX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acspread ACSPREAD Required
SPX-SPREAD-CODE -> SPR-SPREAD-CODE
|
