|
|
ACCHGORDX FILE
Activity Change Order Detail
This file contains budget change order detailed information from AC21.1
(Activity Group Budget Change Order) and AC21.2 (Activity Budget Change
Order).
REFERENCED BY
AC421
UPDATED BY
AC120 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC20.6 AC21.1 AC21.2 AC21.3 AC22.1 AC300
AC310 AC580
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CHX-ACTIVITY-GRP Alpha 15 AC21.1 AC21.2
Activity Group Required key. This is the activity AC21.3
group for the change order.
CHX-ACTIVITY Alpha 15 AC21.1 AC21.2
Activity Required key. This is the activity for AC21.3
the change order.
CHX-BUDGET-NBR Numeric 3 AC21.1 AC21.2
Budget Number Required key. This is the budget number AC21.3
uniquely defined in budget setup.
CHX-CHG-ORDER-NBR Alpha 5 AC21.1 AC21.2
Change Order Number Required key. This is the AC21.3
identification number for the change
order.
CHX-ACCT-CATEGORY Alpha 5 AC21.1 AC21.2
Account Category Required key. This is the account AC21.3
category for the change order.
CHX-FISCAL-YEAR Numeric 4 AC21.1 AC21.2
Fiscal Year Required key. This is the fiscal year AC21.3
for the budget.
CHX-PERIOD Numeric 2 AC21.1 AC21.2
Fiscal Period Required key. This is the fiscal period AC21.3
for the budget.
CHX-BASE-ND Numeric 1 AC21.1 AC21.2
Base Number of Required. This is the number of decimal AC21.3
Decimals positions defined for the budget
currency.
CHX-AMOUNT Currency 15.2 AC21.1 AC21.2
Change Order Amount Required. This is the calculated AC21.3
amount, including the change order, for
the account category for the period.
CHX-ENTERED-AMT Signed 15.2 AC21.1 AC21.2
Entered Amt This is the new amount, including the AC21.3
change order, as entered for the account
category for the period.
CHX-PRIOR-AMOUNT Signed 15.2 AC21.1 AC21.2
Prior Amount This is the period amount for the AC21.3
account category prior to the budget
change order.
CHX-UNIT Signed 15.2 AC21.1 AC21.2
Unit This is the calculated units budget, AC21.3
including the change order, for the
account category for the period.
CHX-ENTERED-UNIT Signed 15.2 AC21.1 AC21.2
Entered Unit This is the new units budget, including AC21.3
the change order, as entered for the
account category for the period.
CHX-PRIOR-UNIT Signed 15.2 AC21.1 AC21.2
Prior Unit This is the period units budget for the AC21.3
account category prior to the budget
change order.
CHX-BLANK Derived
Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
CHX-FACTOR Alpha 15 AC21.1 AC21.2
Factor This is the calculated factor, AC21.3
including the change order, for the
budget.
CHX-PRIOR-FACTOR Alpha 15 AC21.1 AC21.2
Prior Factor This is the prior factor for the AC21.3
budget.
CHX-FACTOR-RATE Signed 12.6 AC21.1 AC21.2
Rate This is the calculated factor rate, AC21.3
including the change order, for the
budget.
CHX-ENTERED-F-RATE Signed 12.6 AC21.1 AC21.2
Entered F Rate This is the factor rate, including the AC21.3
change order, as entered for the budget.
CHX-PRIOR-F-RATE Signed 12.6 AC21.1 AC21.2
Prior F Rate This is the prior factor rate for the AC21.3
budget.
CHX-SPREAD-CODE Alpha 3 AC21.1 AC21.2
Spread Code 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
the characteristic spending pattern of
each account category.
CHX-CHANGE-AMOUNT Derived
Change Amount This is the change amount (the change
order information) for the account
category for the period.
CHX-CHANGE-UNITS Derived
Change Units This is the change number of units (the
change order information) for the
account category for the period.
ACCHGORDX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CHXSET1 ACTIVITY-GRP AC120 AC20.1
ACTIVITY AC20.2 AC20.3
BUDGET-NBR AC20.4 AC20.5
CHG-ORDER-NBR AC20.6 AC21.1
ACCT-CATEGORY AC21.2 AC21.3
FISCAL-YEAR AC22.1 AC300
PERIOD AC310 AC421
AC580
CHXSET2 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
ACCT-CATEGORY
CHG-ORDER-NBR
FISCAL-YEAR
PERIOD
CHXSET3 ACTIVITY-GRP KeyChange AC21.3
ACTIVITY
BUDGET-NBR
CHG-ORDER-NBR
FISCAL-YEAR
PERIOD
ACCT-CATEGORY
ACCHGORDX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
CHX-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acbudhdr ACBUDHDR Required
CHX-ACTIVITY-GRP -> BDH-ACTIVITY-GRP
CHX-ACTIVITY -> BDH-ACTIVITY
CHX-BUDGET-NBR -> BDH-BUDGET-NBR
Acchgorder ACCHGORDER Required
CHX-ACTIVITY-GRP -> CHO-ACTIVITY-GRP
CHX-ACTIVITY -> CHO-ACTIVITY
CHX-BUDGET-NBR -> CHO-BUDGET-NBR
CHX-CHG-ORDER-NBR -> CHO-CHG-ORDER-NBR
|