|
|
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
AC21.1 AC21.2 AC21.3 AC21.4 AC22.1 AC300
AC310 AC20.1 AC20.2 AC20.3 AC20.4 AC20.5
AC20.6 AC20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CHX-ACTIVITY-GRP Alpha 15 AC21.1 AC21.2
Element: Activity GroupRequired key. This is the activity AC21.3 AC21.4
group for the change order.
CHX-ACTIVITY Alpha 15 AC21.1 AC21.2
Element: Activity Required key. This is the activity for AC21.3 AC21.4
the change order.
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
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
currency.
CHX-AMOUNT Currency 15.2 AC21.1 AC21.2
Element: Change Order ARequired. This is the calculated AC21.3 AC21.4
amount, including the change order, for
the account category for the period.
CHX-ENTERED-AMT Signed 15.2 AC21.1 AC21.2
Element: Adj Amt This is the new amount, including the AC21.3 AC21.4
change order, as entered for the account
category for the period.
CHX-PRIOR-AMOUNT Signed 15.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
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: 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: 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: Factor This is the prior factor for the AC21.3 AC21.4
budget.
CHX-FACTOR-RATE Signed 12.6 AC21.1 AC21.2
Element: Account Rate This is the calculated factor rate, AC21.3 AC21.4
including the change order, for the
budget.
CHX-ENTERED-F-RATE Signed 12.6 AC21.1 AC21.2
Element: Account Rate This is the factor rate, including the AC21.3 AC21.4
change order, as entered for the budget.
CHX-PRIOR-F-RATE Signed 12.6 AC21.1 AC21.2
Element: Account Rate This is the prior factor rate for the AC21.3 AC21.4
budget.
CHX-SPREAD-CODE Alpha 3 AC21.2
Element: Authority Code
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 AC20.1 AC20.2
ACTIVITY AC20.3 AC20.4
BUDGET-NBR AC20.5 AC20.6
CHG-ORDER-NBR AC20.7 AC21.1
ACCT-CATEGORY AC21.2 AC21.3
FISCAL-YEAR AC21.4 AC22.1
PERIOD AC300 AC310
AC421
CHXSET2 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
ACCT-CATEGORY
CHG-ORDER-NBR
FISCAL-YEAR
PERIOD
CHXSET3 ACTIVITY-GRP KeyChange AC21.4
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
|
