|
|
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
AC10.1 AC10.5 AC421 BR422
UPDATED BY
AC120 AC21.1 AC21.2 AC21.3 AC21.4 AC22.1
AC300 AC310 BR10.1 BR22.1 PW110 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CHX-ACTIVITY-GRP Alpha 15 AC120 AC21.1
Element: Activity GroupRequired key. This is the activity AC21.2 AC21.3
group for the change order. AC21.4 BR22.1
CHX-ACTIVITY Alpha 15 AC21.1 AC21.2
Element: Activity Required key. This is the activity for AC21.3 AC21.4
the change order. BR22.1
CHX-BUDGET-NBR Numeric 3 AC21.1 AC21.2
Element: Budget Number Required key. This is the budget number AC21.3 AC21.4
uniquely defined in budget setup.
CHX-CHG-ORDER-NBR Alpha 5 AC21.1 AC21.2
Element: Change Order NRequired key. This is the AC21.3 AC21.4
identification number for the change BR22.1
order.
CHX-ACCT-CATEGORY Alpha 5 AC21.1 AC21.2
Element: Account CategoRequired key. This is the account AC21.3 AC21.4
category for the change order.
CHX-FISCAL-YEAR Numeric 4 AC21.1 AC21.2
Element: Fiscal Year Required key. This is the fiscal year AC21.3 AC21.4
for the budget.
CHX-PERIOD Numeric 2 AC21.1 AC21.2
Element: Fiscal Period Required key. This is the fiscal period AC21.3 AC21.4
for the budget.
CHX-BASE-ND Numeric 1 AC21.1 AC21.2
Base Number of Required. This is the number of decimal AC21.3 AC21.4
Decimals positions defined for the budget BR22.1
currency.
CHX-AMOUNT Signed 18.2 AC21.1 AC21.2
Element: Change Order ARequired. This is the calculated AC21.3 AC21.4
amount, including the change order, for BR22.1
the account category for the period.
CHX-ENTERED-AMT Signed 18.2 AC21.1 AC21.2
Element: Intl Amt This is the new amount, including the AC21.3 AC21.4
change order, as entered for the account BR22.1
category for the period.
CHX-PRIOR-AMOUNT Signed 18.2 AC21.1 AC21.2
Element: Prior Amount This is the period amount for the AC21.3 AC21.4
account category prior to the budget BR22.1
change order.
CHX-UNIT Signed 15.2 AC21.1 AC21.2
Element: Unit This is the calculated units budget, AC21.3 AC21.4
including the change order, for the
account category for the period.
CHX-ENTERED-UNIT Signed 15.2 AC21.1 AC21.2
Element: Entered Unit This is the new units budget, including AC21.3 AC21.4
the change order, as entered for the
account category for the period.
CHX-PRIOR-UNIT Signed 15.2 AC21.1 AC21.2
Element: Prior Unit This is the period units budget for the AC21.3 AC21.4
account category prior to the budget
change order.
CHX-BLANK Derived
Element: 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
Element: Factor This is the calculated factor, AC21.3 AC21.4
including the change order, for the
budget.
CHX-PRIOR-FACTOR Alpha 15 AC21.1 AC21.2
Element: Prior Factor This is the prior factor for the AC21.3 AC21.4
budget.
CHX-FACTOR-RATE Signed 14.7 AC21.1 AC21.2
Element: Factor Rate This is the calculated factor rate, AC21.3 AC21.4
including the change order, for the
budget.
CHX-ENTERED-F-RATE Signed 14.7 AC21.1 AC21.2
Element: Acct Rate This is the factor rate, including the AC21.3 AC21.4
change order, as entered for the budget.
CHX-PRIOR-F-RATE Signed 14.7 AC21.1 AC21.2
Element: Acct Rate This is the prior factor rate for the AC21.3 AC21.4
budget.
CHX-SPREAD-CODE Alpha 3 AC21.2
Element: 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
Element: Change Amount This is the change amount (the change
order information) for the account
category for the period.
CHX-CHANGE-UNITS Derived
Element: 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 AC10.1 AC10.5
ACTIVITY AC120 AC20.1
BUDGET-NBR AC20.2 AC20.3
CHG-ORDER-NBR AC20.4 AC20.5
ACCT-CATEGORY AC20.7 AC21.1
FISCAL-YEAR AC21.2 AC21.3
PERIOD AC21.4 AC22.1
AC300 AC310
AC421 BR10.1
BR10.2 BR22.1
PW110
CHXSET3 ACTIVITY-GRP KeyChange AC21.4 BR22.1
ACTIVITY BR422
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
|
