ACCHGORDX

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 AC310 AC421 BR422


UPDATED BY
AC120 AC21.1 AC21.2 AC21.3 AC21.4 AC21.5
AC22.1 AC300 AC311 BR10.1 BR22.1 AC20.1
AC20.2 AC20.3 AC20.4 AC20.5 AC20.7

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


ACCHGORDX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Required
CHX-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Acactivity ACACTIVITY Not Required
CHX-ACTIVITY->ACV-ACTIVITY
Acbudhdr ACBUDHDR Required
CHX-ACTIVITY-GRP->BDH-ACTIVITY-GRP
CHX-ACTIVITY->BDH-ACTIVITY
CHX-BUDGET-NBR->BDH-BUDGET-NBR
Acchgorder ACCHGORDER Required
When CHX-BUDGET-NBR !=Zeroes
CHX-ACTIVITY-GRP->CHO-ACTIVITY-GRP
CHX-ACTIVITY->CHO-ACTIVITY
CHX-BUDGET-NBR->CHO-BUDGET-NBR
CHX-CHG-ORDER-NBR->CHO-CHG-ORDER-NBR
Acchgorder Cnt ACCHGORDER Required
When ACV-POSTING-FLAG ="C"
CHX-ACTIVITY-GRP->CHO-ACTIVITY-GRP
CHX-ACTIVITY->CHO-ACTIVITY
CHX-BUDGET-NBR->CHO-BUDGET-NBR
CHX-CHG-ORDER-NBR->CHO-CHG-ORDER-NBR


ACCHGORDX FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acchgordx Dtl ACCHGORDX
Valid When ACV-POSTING-FLAG ="C"
CHX-ACTIVITY-GRP->CHX-ACTIVITY-GRP
  CHX-ACTIVITY
  CHX-BUDGET-NBR
  CHX-CHG-ORDER-NBR
  CHX-ACCT-CATEGORY
  CHX-FISCAL-YEAR
  CHX-PERIOD


File created: Thu Jun 09 02:02:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.