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
AC310 |
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 | AC311 | AC421 |
BR10.1 | BR10.2 | BR22.1 | BR422 |
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. |
|
||||||||
CHX-ACTIVITY Element: Activity | Alpha 15 Required key. This is the activity for the change order. |
|
||||||||
CHX-BUDGET-NBR Element: Budget Number | Numeric 3 Required key. This is the budget number uniquely defined in budget setup. |
|
||||||||
CHX-CHG-ORDER-NBR Element: Change Order Number | Alpha 5 Required key. This is the identification number for the change order. |
|
||||||||
CHX-ACCT-CATEGORY Element: Account Category | Alpha 5 Required key. This is the account category for the change order. |
|
||||||||
CHX-FISCAL-YEAR Element: Fiscal Year | Numeric 4 Required key. This is the fiscal year for the budget. |
|
||||||||
CHX-PERIOD Element: Fiscal Period | Numeric 2 Required key. This is the fiscal period for the budget. |
|
||||||||
CHX-BASE-ND Base Number of Decimals | Numeric 1 Required. This is the number of decimal positions defined for the budget currency. |
|
||||||||
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. |
|
||||||||
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. |
|
||||||||
CHX-PRIOR-AMOUNT Element: Prior Amount | Signed 18.2 This is the period amount for the account category prior to the budget change order. |
|
||||||||
CHX-UNIT Element: Unit | Signed 15.2 This is the calculated units budget, including the change order, for the account category for the period. |
|
||||||||
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. |
|
||||||||
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. |
|
||||||||
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. |
|
||||||||
CHX-PRIOR-FACTOR Element: Prior Factor | Alpha 15 This is the prior factor for the budget. |
|
||||||||
CHX-FACTOR-RATE Element: Factor Rate | Signed 14.7 This is the calculated factor rate, including the change order, for the budget. |
|
||||||||
CHX-ENTERED-F-RATE Element: Acct Rate | Signed 14.7 This is the factor rate, including the change order, as entered for the budget. |
|
||||||||
CHX-PRIOR-F-RATE Element: Acct Rate | Signed 14.7 This is the prior factor rate for the budget. |
|
||||||||
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. |
|
||||||||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CHXSET1 |
ACTIVITY-GRP ACTIVITY BUDGET-NBR CHG-ORDER-NBR ACCT-CATEGORY FISCAL-YEAR PERIOD |
|
| ||||||||||||||||||||||||||||
CHXSET3 |
ACTIVITY-GRP ACTIVITY BUDGET-NBR CHG-ORDER-NBR FISCAL-YEAR PERIOD ACCT-CATEGORY |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acacctcat | ACACCTCAT |
Required
| ||||||||||||||||||
Acactivity | ACACTIVITY |
Not Required
| ||||||||||||||||||
Acbudhdr | ACBUDHDR |
Required
| ||||||||||||||||||
Acchgorder | ACCHGORDER |
Required
| ||||||||||||||||||
Acchgorder Cnt | ACCHGORDER |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acchgordx Dtl | ACCHGORDX |
|
All trademarks and registered trademarks are the property of their
respective owners.