|
|
ACCHGORDER FILE
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
AC10.1 AC10.5 AC421 BR422
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
AC22.1 AC300 AC310 BR10.1 BR22.1 PW110
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CHO-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 AC22.1
BR22.1
CHO-ACTIVITY Alpha 15 AC21.1 AC21.2
Element: Activity Required key. This is the activity for AC21.3 AC21.4
the change order. AC22.1 BR22.1
CHO-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. AC22.1
CHO-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 AC22.1 BR22.1
order.
CHO-DESCRIPTION Alpha 30 (Lower Case) AC21.1 AC21.2
Element: Description This field displays the description. AC21.3 AC21.4
BR22.1
CHO-APPROVAL-FLAG Alpha 1 AC21.1 AC21.2
Element: Approval Flag This flag indicates whether the change AC21.3 AC21.4
order is approved.. Use Yes if the AC22.1 BR22.1
change order is approved. Use No if the
change order is not approved.
Y = Approved
N = Not Approved
CHO-APPROVAL Alpha 15 AC21.1 AC21.2
Element: Approval This field is for the name of the AC21.3 AC21.4
person who approved the change order. AC22.1 BR22.1
CHO-MAINT-DATE Numeric 8 (yyyymmdd) AC21.1 AC21.2
Element: Maintenance DaThis is the date the budget was last AC21.3 AC21.4
changed. AC22.1 BR22.1
CHO-MAINT-TIME Numeric 6 (hhmmss) AC21.1 AC21.2
Element: Maintenance TiThis is the time the budget was last AC21.3 AC21.4
changed. AC22.1 BR22.1
CHO-RELEASED Alpha 1 AC21.1 AC21.2
Element: Released This flag indicates whether the change AC21.3 AC21.4
order has been released. Budgets are not AC22.1 BR22.1
changed until the change orders are
released.
Y = Released
N = Not Released
CHO-EFFECTIVE-DATE Numeric 8 (yyyymmdd) AC21.1 AC21.2
Element: Effective DateThe date a vendor's prices will be in AC21.3 AC21.4
effect. BR22.1
CHO-FORMED-USED Numeric 1 AC21.1 AC21.2
Element: Formed Used This field indicates the form used to AC21.3 AC21.4
define the change order. Use 1 for BR22.1
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
ACCHGORDER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CHOSET1 ACTIVITY-GRP AC10.1 AC10.5
ACTIVITY AC120 AC20.1
BUDGET-NBR AC20.2 AC20.3
CHG-ORDER-NBR AC20.4 AC20.5
AC20.6 AC20.7
AC21.1 AC21.2
AC21.3 AC21.4
AC22.1 AC300
AC310 AC421
BR10.1 BR10.2
BR22.1 BR422
PW110
CHOSET2 ACTIVITY-GRP KeyChange, Subset AC21.1 AC21.2
ACTIVITY Where (RELEASED = "N" ) AC21.3 AC21.4
BUDGET-NBR BR22.1
CHG-ORDER-NBR
CHOSET3 ACTIVITY-GRP KeyChange AC21.1 AC21.2
ACTIVITY AC21.3 AC21.4
BUDGET-NBR AC421
MAINT-DATE
MAINT-TIME
CHG-ORDER-NBR
ACCHGORDER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acchgordx ACCHGORDX
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
|
