ACCHGORDER

Activity Change Order

This file contains budget change order information from AC21.1 (Budget Change Orders). It includes activity group, activity, budget number, change order number, approval information, maintenance date and time, and a released flag.

REFERENCED BY
AC121 AC127 AC27.1 AC310


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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CHO-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
AC22.1 BR22.1
CHO-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 AC22.1
BR22.1
CHO-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 AC22.1
CHO-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 AC22.1
BR22.1
CHO-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
AC21.1 AC21.2
AC21.3 AC21.4
AC21.5 BR22.1
CHO-APPROVAL-FLAG
Element: Approval Flag
Alpha 1
This flag indicates whether the change order is approved.. Use Yes if the change order is approved. Use No if the change order is not approved.
Y = Approved
N = Not Approved
AC21.1 AC21.2
AC21.3 AC21.4
AC21.5 AC22.1
BR22.1
CHO-APPROVAL
Element: Approval
Alpha 15
This field is for the name of the person who approved the change order.
AC21.1 AC21.2
AC21.3 AC21.4
AC21.5 AC22.1
BR22.1
CHO-MAINT-DATE
Element: Maintenance Date
Numeric 8 (yyyymmdd)
This is the date the budget was last changed.
AC21.1 AC21.2
AC21.3 AC21.4
AC21.5 AC22.1
BR22.1
CHO-MAINT-TIME
Element: Maintenance Time
Numeric 6 (hhmmss)
This is the time the budget was last changed.
AC21.1 AC21.2
AC21.3 AC21.4
AC21.5 AC22.1
BR22.1
CHO-RELEASED
Element: Released
Alpha 1
This flag indicates whether the change order has been released. Budgets are not changed until the change orders are released.
Y = Released
N = Unreleased
AC21.1 AC21.2
AC21.3 AC21.4
AC21.5 AC22.1
BR22.1
CHO-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
The date a vendor's prices will be in effect.
AC21.1 AC21.2
AC21.3 AC21.4
AC21.5 BR22.1
CHO-FORMED-USED
Element: Formed Used
Numeric 1
This field indicates the form used to define the change order. Use 1 for AC21.1 (Activity Group Budget Change Orders) and use 2 for AC21.2 (Activity Budget Change Orders). You must maintain a change order on the same form where you defined it originally.
1 = AC21.1
2 = AC21.2
3 = AC21.3
4 = AC21.4
5 = BR22
AC21.1 AC21.2
AC21.3 AC21.4
AC21.5 BR22.1


ACCHGORDER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CHOSET1 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
CHG-ORDER-NBR
AC10.1 AC10.5
AC120 AC121
AC127 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC20.6 AC20.7
AC21.1 AC21.2
AC21.3 AC21.4
AC21.5 AC22.1
AC27.1 AC300
AC310 AC311
AC421 BR10.1
BR10.2 BR22.1
BR422
CHOSET2 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
CHG-ORDER-NBR
KeyChange, Subset
Where(RELEASED ="N")
AC21.1 AC21.2
AC21.3 AC21.4
BR22.1
CHOSET3 ACTIVITY-GRP
ACTIVITY
BUDGET-NBR
MAINT-DATE
MAINT-TIME
CHG-ORDER-NBR
KeyChange
AC21.1 AC21.2
AC21.3 AC21.4
AC421


ACCHGORDER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Required
CHO-ACTIVITY-GRP->AGP-ACTIVITY-GRP
Acactivity ACACTIVITY Required
CHO-ACTIVITY->ACV-ACTIVITY
Acbudhdr ACBUDHDR Required
CHO-ACTIVITY-GRP->BDH-ACTIVITY-GRP
CHO-ACTIVITY->BDH-ACTIVITY
CHO-BUDGET-NBR->BDH-BUDGET-NBR


ACCHGORDER FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acchgordx ACCHGORDX
Valid When CHO-BUDGET-NBR !=Zeroes
CHO-ACTIVITY-GRP->CHX-ACTIVITY-GRP
CHO-ACTIVITY->CHX-ACTIVITY
CHO-BUDGET-NBR->CHX-BUDGET-NBR
CHO-CHG-ORDER-NBR->CHX-CHG-ORDER-NBR
  CHX-ACCT-CATEGORY
  CHX-FISCAL-YEAR
  CHX-PERIOD
Acchgordx Cnt ACCHGORDX
Valid When CHO-BUDGET-NBR =Zeroes
CHO-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:55 2016

Home
Contact Us



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