ACACTGRP

Activity Group

This file contains information from AC00.1 (Activity Group) about activity group set up and definitions. The activity group is the highest reporting level in the Activity Management system. This file also includes information about the activity processing and reporting structure (work breakdown structure) and the appearance and function of the activity group in the Activity Management system.

REFERENCED BY
AC01.1 AC01.5 AC02.1 AC03.2 AC03.3 AC03.4
AC03.5 AC03.6 AC03.7 AC05.2 AC05.3 AC06.1
AC06.2 AC08.1 AC08.2 AC08.3 AC08.4 AC08.5
AC08.6 AC08.7 AC10.1 AC10.3 AC10.5 AC10.6
AC108 AC11.1 AC112 AC113 AC12.1 AC12.2
AC128 AC13.1 AC13.2 AC13.7 AC130 AC131
AC135 AC14.1 AC14.2 AC14.3 AC14.4 AC14.6
AC14.7 AC145 AC147 AC160 AC165 AC169
AC18.1 AC18.2 AC18.3 AC18.4 AC18.5 AC19.1
AC19.2 AC19.3 AC190 AC191 AC195 AC196
AC197 AC198 AC200 AC203 AC206 AC207
AC210 AC213 AC218 AC220 AC225 AC227
AC240 AC246 AC247 AC25.1 AC255 AC256
AC261 AC265 AC27.1 AC290 AC295 AC297
AC298 AC30.3 AC305 AC310 AC311 AC32.1
AC34.1 AC346 AC35.1 AC36.1 AC37.1 AC40.1
AC40.4 AC400 AC401 AC41.1 AC41.4 AC410
AC412 AC42.1 AC420 AC421 AC440 AC45.1
AC45.2 AC45.4 AC46.1 AC46.2 AC460 AC47.1
AC47.2 AC471 AC472 AC473 AC480 AC490
AC493 AC494 AC50.1 AC50.2 AC500 AC502
AC510 AC52.1 AC520 AC527 AC54.1 AC540
AC55.1 AC56.1 AC580 AC583 AC61.1 AC65.1
AC65.2 AC69.1 AC81.1 AC82.1 AC82.2 AC82.3
AC90.1 AC90.2 AC90.4 AC90.6 AC90.8 AC92.1
AC92.2 AC92.4 AC92.6 AC93.1 AC93.2 AC93.3
AC93.4 AC93.5 AC94.1 AC94.2 AC94.4 AC94.6
AC95.1 AC95.2 AC95.4 AC95.6 AC96.1 AC96.4
AC96.5 AC97.1 AC97.2 AC97.4 AC97.6 AC98.1
AC98.2 ACAC.1 ACBA.1 ACBD.2 ACCL.1 ACDL.1
ACDM.2 ACDM.9 ACSR.1 ACVW.1 SE90.1 AP125
AP126 AP131 AP170 AP190 AP193 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP211 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP510 AP520 AP95.3 API1.1
API2.1 ARLL.1 BN150 BN66.1 BR00.1 BR00.2
BR00.3 BR01.1 BR01.2 BR02.1 BR02.2 BR02.3
BR03.1 BR03.2 BR03.3 BR04.1 BR05.1 BR05.2
BR05.3 BR05.4 BR05.5 BR10.1 BR10.2 BR10.3
BR10.4 BR10.5 BR10.9 BR12.2 BR120 BR121
BR122 BR123 BR124 BR13.1 BR130 BR131
BR14.1 BR140 BR142 BR145 BR15.2 BR151
BR152 BR153 BR154 BR155 BR156 BR157
BR165 BR19.1 BR19.2 BR190 BR20.1 BR20.2
BR20.3 BR20.4 BR20.5 BR20.6 BR20.7 BR20.9
BR200 BR202 BR204 BR205 BR206 BR21.1
BR210 BR212 BR215 BR22.1 BR220 BR245
BR251 BR252 BR253 BR254 BR265 BR300
BR40.1 BR40.3 BR40.4 BR400 BR405 BR41.1
BR41.4 BR42.1 BR420 BR422 BR43.1 BR430
BR44.1 BR45.1 BR450 BR46.1 BR46.2 BR46.4
BR51.1 BR51.2 BR515 BR516 BR52.1 BR52.2
BR52.4 BR52.5 BR521 BR53.1 BR530 BR54.1
BR54.2 BR54.3 BR54.4 BR55.1 BR56.1 BR570
BR580 BR65.1 BR65.2 BR65.3 BR70.1 BR70.2
BR90.1 BR90.2 BR96.1 BRIP.1 CB10.1 CB15.1
CB15.2 CB150 CB180 CB191 CB20.1 CB30.1
CB45.1 CB46.1 CB500 CB543 CB544 CB55.1
CB554 CB57.1 CB80.1 CB82.1 CX05.1 CX100
CX20.1 CX20.2 CX20.4 CX20.5 CX220 CX30.1
CX300 CX506 CXCP.1 EE11.1 EE135 EE20.3
EE35.1 EE35.2 EE520 GL146 GL165 GL170
GL197 GL199 GL299 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GL70.1 GL70.2
GL70.3 GL70.5 GL70.6 GL75.1 GL76.1 HCHP.1
PR521 DR100 IC12.1 IC140 IC141 IC142
IC145 IC243 IC330 IC64.1 IC64.2 IC64.3
IC64.4 IC64.5 IC64.6 IC64.7 IC64.8 IC64.9
IC66.1 IC83.1 CU00.1 EX175 EX542 EX545
EXI2.1 EXI4.1 IFEB.1 IFGT.1 IFUC.1 MX123
MX500 LP130 MA180 MA278 MA41.1 MA41.2
MA41.4 MA41.7 MA42.2 MA43.2 MA43.7 MA44.1
MA44.2 MA53.1 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA70.1 MA75.1 MA80.1
MAI1.1 PA182 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO135 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO18.1 PO190 PO20.1
PO20.6 PO20.9 PO204 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO22.3 PO22.4 PO220
PO222 PO224 PO225 PO229 PO23.1 PO230
PO234 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO251 PO26.2 PO26.3 PO26.4 PO26.5 PO26.6
PO26.7 PO26.9 PO27.2 PO27.3 PO27.4 PO275
PO276 PO277 PO28.2 PO280 PO29.1 PO30.1
PO30.2 PO30.3 PO30.4 PO300 PO31.1 PO31.2
PO32.2 PO32.4 PO33.1 PO34.1 PO35.1 PO36.1
PO36.2 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 PO54.5 POCP.1 POD0.1
POI3.1 POID.1 POIF.1 POIG.1 POII.1 POIJ.1
POIK.1 PR128 PR131 PR132 PR134 PR135
PR136 PR137 PR140 PR189 PR195 PR197
PR29.1 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR36.4 PR37.1 PR38.1
PR45.1 PR529 PR530 PR560 PR582 PR80.1
PR80.4 PR82.1 PR85.1 PR89.1 PRAT.1 UK102
RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1
RQ500 RQ810 RQD0.1 RQIA.1 RQIB.1 RQIF.1
RQII.1 RQIJ.1 SN02.1 SNAC.1 TA147 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH32.5
WH33.1 WH33.2 WH33.3 WH33.4 WH33.5 WH33.6
WH33.8 WH33.9 WH34.1 WH34.2 WH34.3 WH34.4
WH40.1 WH40.2 WH520 WH830 MX202 MX223


UPDATED BY
AC00.1 AC00.3 AC07.1 AC105 AC110 AC120
AC121 AC123 AC127 AC20.1 AC20.2 AC20.3
AC20.4 AC20.5 AC20.6 AC20.7 AC21.5 AC22.1
AC300 AC560 AC581 ACDR.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AGP-ACTIVITY-GRP
Element: Activity Group
Alpha 15
Type or select an activity group or activity center is a group of activities related by process or function. An activity group is the highest entity for which you can inquire and report on costs, revenues, and budgets in Project Accounting. An activity group is set up to budget for, report on, process, and store information common to one or more activities. You must set up an activity group before you can set up activities, budgets, transactions, and inquiries. To collect costs and revenues, at least one activity must be linked to an activity group.
AC00.1 AC110
AC197 AC198
AGP-DESCRIPTION
Activity Group
Description
Alpha 30 (Lower Case)
This is the activity group description.
AC00.1 AC110
AC197 AC198
AGP-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate activity group attributes to the activity group.
AC00.1 AC110
AGP-CURRENCY-TABLE
Element: Currency Table
Alpha 12
This is the currency table, a table of currency relationships, currency exchange rates, and translation rates.
AC00.1
AGP-CURRENCY-CODE
Element: Currency Code
Alpha 5
This is the base currency code of the activity group. You define the base currency code in AC00.1 (Activity Group). Consolidation amounts are reported in activity group base currency.
AC00.1 AC197
AC198 BR02.3
BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
AGP-BEGIN-DATE
Element: Begin Date
Numeric 8 (yyyymmdd)
This is the beginning date for the activity group. If you leave this field blank, the activity group date range defaults to the activity date range. Activity dates cannot be outside the activity group date range.
AC00.1
AGP-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
This is the ending date for the activity group. If you leave this field blank, the activity group date range defaults to the activity date range. The activity date range cannot be outside the activity group date range.
AC00.1
AGP-CALENDAR-NAME
Element: Calendar Name
Alpha 12
Required. Enter the name of a calendar that defines the fiscal periods for the activity group. The calendar is defined in AC00.3 (Calendar).
AC00.1 BR02.3
BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
AGP-SECURITY-CD
Element: Security Code
Numeric 4
You can define a security code for the activity group. The security code is used with the Lawson Security module. Security in Activity Management is established by security code and activity.
AC00.1
AGP-LEVEL-DESC
Element: Level Description
Alpha 12 (Lower Case)
Occurs 5 Times
This is the level description. Levels define an addressing system that organizes activities into a reporting hierarchy. Level names are defined for an activity group and should be able to be used across all activities in an activity group. Levels facilitate rollup or consolidation of budgets, costs, and revenues from activities at lower levels to macro activities at a higher level within the hierarchy.
AC00.1
AGP-LEVEL-SIZE
Element: Level Size
Numeric 2 Occurs 5 Times
This is the level size. Variable levels make up a hierarchical numbering scheme that allows detail to be aggregated or "rolled-up" in summarized form. Five levels are available in the Activity Management system. No one level can be greater than 15; all of the levels taken together cannot exceed 30.
AC00.1
AGP-ACTIVE-STATUS
Element: Active Status
Alpha 1
The status of the activity group. If the activity group is inactive, no activities can be assigned to this activity group.
O = Open
C = Closed
G = GL only
AC00.1 AC00.3
AGP-BASE-ND
Base Number of
Decimals
Numeric 1
This is the number of decimal positions defined for the activity group base currency.
AC00.1 AC197
AC198
AGP-ACTIVE-BUD
Element: Active Budget
Numeric 3
This is the budget number for the activity group's active budget. The active budget is the default budget used for inquiries and reporting. It is also used for calculating percentage complete in AC65.1 (Account Category Percent of Completion). You can change the activity group active budget in AC20.4 (New Activity Group Budget).
AC110 AC127
AC20.6
AGP-TOTAL-BUDGET
Element: Total Budget
Signed 18.2
This is the sum of the activity budgets for the activity group. This field is used in editing to determine if the sum of the activity budgets exceeds the budget cap.
AC00.1 AC110
AC20.1 AC20.2
AC20.3 AC20.4
AC20.5 AC20.6
AC20.7 AC21.5
ACDR.1
AGP-BUDGET-CAP
Element: Budget Cap
Signed 18.2
This is the budget cap or budget maximum for the activity group. It is used in editing budget programs and in determining if the sum of the activity budgets exceeds the budget cap. If the sum of the activity budgets exceeds the budget cap, a warning message displays.
AC00.1
AGP-WORKFLOW-FLAG
Element: Workflow Flag
Alpha 1
This field will be used in implementing Activity Management Workflow.
Y = Yes
N = No
AGP-CHG-ORDER-FLAG
Element: Change Order Flag
Alpha 1
This is the change order flag. Yes = Change order records are kept on file to provide an audit trail of budget change order revisions. No = Change order detail records are deleted after the change order is released.
AC00.1
AGP-CONSOL-FLAG
Element: Consolidation Flag
Alpha 1
This is the consolidation flag. Use Yes to create consolidation files for actuals and budgets at the activity level within the activity group. Use No if you do not want to create consolidation files at the activity level. Consolidation files keep consolidated balances for summary level activities and for reporting summary balances. Consolidation records are always kept at the activity group level.
Y = Yes
N = No
AC00.1
AGP-ACCT-EDIT-FLAG
Element: Account Edit Flag
Alpha 1
This field determines the type of activity editing to be done in the Lawson subsystems. 1 is valid only for GL-only activity groups. Valid values are 1 = Activity 2 = Activity and Account Category 3 = Activity, Account Category, and Activity Account (Soft Errors) 4 = Activity, Account Category, and Activity Account (Hard Errors)
AC00.1
AGP-BUDGET-EDIT
Element: Budget Edit
Alpha 1
This field determines whether to edit budget amounts in the Purchase Order, Requisitions, or Accounts Payable systems. The default is no editing of budget amounts.
1 = No Edit
2 = Period Edit
3 = Annual Edit
4 = Total Edit
AC00.1
AGP-BUDGET-LEVEL
Element: Budget Level
Alpha 1
This flag determines which level of the budget to edit in Purchase Order, Requisitions, or Accounts Payable: the activity (posting) or the activity group (summary) level. This field is required if budgets are edited.
1 = Activity-Acct Cat
2 = Activity Group
3 = Activity
4 = Activity-Summary Account Cat
5 = Contract Funding
AC00.1
AGP-BUD-TOLERANCE
Element: Budget Tolerance
Signed 5.2
This field defines what percentage over the budget, if any, is acceptable. Budget Tolerance Percent is required if budgets are edited.
AC00.1
AGP-EDIT-PR
Element: Edit Payroll
Alpha 1
This field indicates whether to edit employee information in Payroll. Select Yes if you want to edit employee information.
Y = Yes
N = No
AC00.1
AGP-PR-COMMIT
Element: Pr Commit
Alpha 1
Overrides the PR Commit flag on the system codes (GL01.4) to determine whether PR commitments are created during PR processing for transactions involving activities associated with the activity group.
N = No
Y = Yes
AC00.1
AGP-EDIT-AP-EE
Element: Edit AP and EE
Alpha 1
This field indicates whether to edit vendor information in Accounts Payable (AP) and Employee Expense (EE). Select Yes if you want to edit vendor information. The default is No.
Y = Yes
N = No
AC00.1
AGP-EDIT-TRANSREL
Element: Edit Transrel
Alpha 1

Y = Yes
N = No
AC00.1
AGP-LAST-COMMENT
Element: Last Comment
Numeric 6
This is the last sequence number used for comments relating to the activity group.
AGP-LAST-AGA-SEQ
Last Activity Grp
Sequence Nbr
Numeric 6
This is the last line added in AC07.1 (Account Assignment). Account assignment records are stored in the Activity GL Accounts file.
AC07.1 AC105
AC110 AC120
AC560
AGP-RELEASED
Element: Released
Alpha 1
This is the change order status for the activity group. Only one change order for the activity group can be unreleased.
Y = Released
N = Not Released
AGP-INV-AUDIT
Element: Inv Audit
Alpha 1

Y = Yes
N = No
AC00.1
AGP-GL-CONSOL-FL
Accounting Unit
Consolidate
Alpha 1
This flag indicates whether you want to create summary-level activity consolidation records in the Activity CL Accounting Unit Consolidation header and detail files.
Y = Yes
N = No
AC00.1
AGP-RESOURCE-FL
Element: All Flag
Alpha 1

Y = Yes
N = No
AC00.1
AGP-LEVEL-1-DESC
Element: Level 1 Description
Derived
This is the description for level 1.
AGP-LEVEL-2-DESC
Element: Level 2 Description
Derived
This is the description for level 2.
AGP-LEVEL-3-DESC
Element: Level 3 Description
Derived
This is the description for level 3.
AGP-LEVEL-4-DESC
Element: Level 4 Description
Derived
This is the description for level 4.
AGP-LEVEL-5-DESC
Element: Level 5 Description
Derived
This is the description for level 5.
AGP-PURGE-STATUS
Element: Purge Status
Alpha 1
This field indicates the purge status for the activity group. Use C for a complete purge. Use B to purge balances only.
" " = No Purge
B = Balances Only
C = Complete
AC00.3 AC300
AGP-OUTPUT-MEASURE
Element: Intl Amt
Signed 18.2
This is the output measurement.
AC00.1
AGP-OUTPUT-DESC
Element: Output Desc
Alpha 30
This is the output description.
AC00.1
AGP-CURR-NAME-1
Element: Curr Name 1
Alpha 12
Type or select a name that identifies the report currency. You must define exchange rates (CU10.1) and currency relationships (CU02.1) for the report currency with the company base currency. The report currencies are additional non-base currencies that identify a company operating currency. This report currency is for reports and analysis only. The report currencies are calculated in the same manner as base currency. Transaction amounts will always be converted to the Base Currency. If you also use a report currency, amounts will convert to both the Base and Report Currency. Note: The report currency cannot be the same as the company base currency.
AC00.1 AC581
AGP-CURR-CODE-1
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
AC00.1 AC197
AC198 AC581
AGP-CURR-CODE-ND-1
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AC00.1 AC198
AC581
AGP-CURR-NAME-2
Element: Curr Name 2
Alpha 12
Type or select a name that identifies the report currency. You must define exchange rates (CU10.1) and currency relationships (CU02.1) for the report currency with the company base currency. The report currencies are additional non-base currencies that identify a company operating currency. This report currency is for reports and analysis only. The report currencies are calculated in the same manner as base currency. Transaction amounts will always be converted to the Base Currency. If you also use a report currency, amounts will convert to both the Base and Report Currency. Note: The report currency cannot be the same as the company base currency.
AC00.1 AC581
AGP-CURR-CODE-2
Element: Curr Code 2
Alpha 5
Type the currency code you want to associate with the report currency name. The currency code must exist in CU01.1 (Currency Codes).
AC00.1 AC197
AC198 AC581
AGP-CURR-CODE-ND-2
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
AC00.1 AC581
AGP-BURDEN-CALC-FL
Element: Burden Calc Fl
Alpha 1

Y = Yes
N = No
AC00.1
AGP-ACTIVITY-FLAG
Element: Activity Flag
Alpha 1

Y = Yes
N = No
AC00.1
AGP-ASSET-FLAG
Element: Asset Flag
Alpha 1

Y = Yes
N = No
AC00.1
AGP-RESC-ASSIGN-FL
Element: Resc Assign Fl
Alpha 1

Y = Yes
N = No
AC00.1
AGP-ATTRIBUTE-FLAG
Element: Attribute Flag
Alpha 1

Y = Yes
N = No
AC00.1
AGP-BILLING-FLAG
Element: Billing Flag
Alpha 1

Y = Yes
N = No
AC00.1
AGP-CONTRACT-FLAG
Element: Contract Flag
Alpha 1

Y = Yes
N = No
AC00.1
AGP-CEILING-FLAG
Element: Ceiling Flag
Alpha 1

Y = Yes
N = No
AC00.1
AGP-BILL-CONSOL-FL
Element: Bill Consol Fl
Alpha 1

Y = Yes
N = No
AC00.1 BR02.3
BR120 BR121
BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
AGP-DATE-EDIT
Element: Date Edit
Alpha 1
Used with the ACAC Edit. Valid values are posting and transaction date.
P = Posting Date
T = Transaction Date
AC00.1
AGP-BILL-CALC-DATE
Element: Bill Calc Date
Alpha 1
Used with the activity billing calculation logic. Valid values are posting and transaction date.
P = Posting Date
T = Transaction Date
AC00.1
AGP-TE-ACCT-DF-FL
Element: Te Acct Df Fl
Alpha 1

A = Activity Expense Account
E = Employee Expense Account
AC00.1
AGP-TE-ACCT-CAT-DF
Element: Te Acct Cat Df
Alpha 1

A = Activity Acct Category
E = Employee Acct Category
AC00.1
AGP-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AC00.1
AGP-SUB-ACCOUNT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AC00.1
AGP-GL-CODE
Element: Gl Code
Alpha 4
AC00.1
AGP-EXPENSE-FL
Element: Expense Fl
Alpha 1
AC00.1
AGP-ASSET-EDIT
Element: Asset Edit
Alpha 1

Y = Yes
N = No
AC00.1
AGP-POP-FLAG
Element: Pop Flag
Alpha 1
Period of Performance flag. Will indicate the use of period of performance. This will be edited when transactions are added.
N = No
Y = Yes
AC00.1
AGP-BRDN-DATE-EDIT
Element: Brdn Date Edit
Alpha 1
Determines whether burden rates are based on the ACTRANS transaction date or posting date.
P = Posting Date
T = Transaction Date
AC00.1
AGP-STRUCTURE
Element: Structure
Alpha 15
The name of the category structure. This represents the category structure assigned to the activity group.
AC00.1
AGP-CAT-CONSOL-FL
Element: Consol Flag
Alpha 1

Y = Yes
N = No
AC00.1
AGP-BEG-BAL-YEAR
Element: Year
Numeric 4
ACDR.1


ACACTGRP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AGPSET1 ACTIVITY-GRP
...
AC00.1 AC00.2
AC00.3 AC01.1
AC01.5 AC02.1
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC03.7
AC05.2 AC05.3
AC06.1 AC06.2
AC07.1 AC08.1
AC08.2 AC08.3
AC08.4 AC08.5
AC08.6 AC08.7
AC10.1 AC10.3
AC10.5 AC10.6
AC105 AC108
AGPSET2 OBJ-ID
...
AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC130 AC135
AC14.2 AC14.3
AC14.4 AC145
AC147 AC160
AC165 AC169
AC190 AC191
AC196 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC200 AC203
AGPSET3 STRUCTURE
ACTIVITY-GRP
KeyChange
AC08.7 ACDR.1


ACACTGRP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acaddlcntr ACADDLCNTR Not Required
AGP-ACTIVITY-GRP->ADN-ACTIVITY-GRP
Spaces->ADN-CONTRACT
Acbudhdr Actv ACBUDHDR Not Required
AGP-ACTIVITY-GRP->BDH-ACTIVITY-GRP
Spaces->BDH-ACTIVITY
AGP-ACTIVE-BUD->BDH-BUDGET-NBR
Acctgrpbod ACCTGRPBOD Not Required, Delete Cascades
AGP-ACTIVITY-GRP->YAA-ACTIVITY-GRP
Cucodes CUCODES Required
AGP-CURRENCY-CODE->CUC-CURRENCY-CODE
Curr 1 CUCODES Not Required
AGP-CURR-CODE-1->CUC-CURRENCY-CODE
Curr 2 CUCODES Not Required
AGP-CURR-CODE-2->CUC-CURRENCY-CODE
Cutable CUTABLE Not Required
AGP-CURRENCY-TABLE->CTB-CURRENCY-TABLE
Structure STRUCTURE Required
AGP-STRUCTURE->SRE-STRUCTURE


ACACTGRP FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acactivity ACACTIVITY
AGP-ACTIVITY-GRP->ACV-ACTIVITY-GRP
  ACV-ACTIVITY
Acactivity Lvl ACACTIVITY
AGP-ACTIVITY-GRP->ACV-ACTIVITY-GRP
  ACV-VAR-LEVELS
Acasnrole ACASNROLE
AGP-ACTIVITY-GRP->ALE-ACTIVITY-GRP
Spaces->ALE-ACTIVITY
  ALE-RESOURCE-TYPE
  ALE-COMPANY
  ALE-RESOURCE-CODE
  ALE-ROLE
Acassign ACASSIGN
AGP-ACTIVITY-GRP->AAN-ACTIVITY-GRP
Spaces->AAN-ACTIVITY
  AAN-COMPANY
  AAN-RESOURCE-TYPE
  AAN-RESOURCE-CODE
Acbrdndtl ACBRDNDTL
AGP-ACTIVITY-GRP->BRD-ACTIVITY-GRP
Spaces->BRD-ACTIVITY
  BRD-ACCT-CATEGORY
  BRD-BURDEN-CD
  BRD-POOL-NBR
Acbuddtl Actv ACBUDDTL
AGP-ACTIVITY-GRP->BDT-ACTIVITY-GRP
Spaces->BDT-ACTIVITY
AGP-ACTIVE-BUD->BDT-BUDGET-NBR
  BDT-ACCT-CATEGORY
  BDT-FISCAL-YEAR
Acbudhdr ACBUDHDR
AGP-ACTIVITY-GRP->BDH-ACTIVITY-GRP
Spaces->BDH-ACTIVITY
  BDH-BUDGET-NBR
Accal ACCAL
AGP-CALENDAR-NAME->CDH-CALENDAR-NAME
  CDH-FISCAL-YEAR
Accatsum ACCATSUM
AGP-STRUCTURE->SRS-STRUCTURE
  SRS-SUM-ACCT-CAT
Accatsumx ACCATSUMX
AGP-STRUCTURE->SRX-STRUCTURE
  SRX-ACCT-CATEGORY
Acchgorder ACCHGORDER
AGP-ACTIVITY-GRP->CHO-ACTIVITY-GRP
Spaces->CHO-ACTIVITY
AGP-ACTIVE-BUD->CHO-BUDGET-NBR
  CHO-CHG-ORDER-NBR
Accommit ACCOMMIT
AGP-ACTIVITY-GRP->MIT-ACTIVITY-GRP
  MIT-ACTIVITY
  MIT-ACCT-CATEGORY
  MIT-FISCAL-YEAR
  MIT-PERIOD
  MIT-SYSTEM
  MIT-COMPANY
  MIT-CURRENCY-CODE
Acconsol ACCONSOL
AGP-ACTIVITY-GRP->CSL-ACTIVITY-GRP
Spaces->CSL-ACTIVITY
  CSL-CURRENCY-CODE
  CSL-ACCT-CATEGORY
  CSL-BUDGET-NBR
  CSL-FISCAL-YEAR
Acconsol Bud ACCONSOL
AGP-ACTIVITY-GRP->CSL-ACTIVITY-GRP
Spaces->CSL-ACTIVITY
  CSL-CURRENCY-CODE
  CSL-ACCT-CATEGORY
  CSL-BUDGET-NBR
  CSL-FISCAL-YEAR
Accontacts ACCONTACTS
AGP-ACTIVITY-GRP->CTS-ACTIVITY-GRP
  CTS-CONTRACT
  CTS-RESP-CODE
Acglacct ACGLACCT
AGP-ACTIVITY-GRP->AGA-ACTIVITY-GRP
Spaces->AGA-ACTIVITY
  AGA-ACCT-CATEGORY
  AGA-SEQ-NUMBER
Acglconsl ACGLCONSL
AGP-ACTIVITY-GRP->GCO-ACTIVITY-GRP
  GCO-ACTIVITY
  GCO-ACCT-CATEGORY
  GCO-COMPANY
  GCO-ACCT-UNIT
  GCO-RESOURCE-TYPE
  GCO-RESOURCE-COMP
  GCO-RESOURCE-CODE
  GCO-FISCAL-YEAR
Acgrpmxval ACGRPMXVAL
AGP-OBJ-ID->AGV-OBJ-ID
  AGV-MATRIX-CAT
Acgrpmxvdt ACGRPMXVDT
AGP-OBJ-ID->GVD-OBJ-ID
  GVD-MATRIX-CAT
  GVD-EFFECTIVE-DATE
Acprdperf ACPRDPERF
AGP-ACTIVITY-GRP->PFM-ACTIVITY-GRP
Spaces->PFM-ACTIVITY
  PFM-SYSTEM
  PFM-SEQ-NUMBER
Acreshist ACRESHIST
AGP-ACTIVITY-GRP->RSH-ACTIVITY-GRP
  RSH-ACTIVITY
  RSH-RESOURCE-TYPE
  RSH-RESOURCE-CODE
  RSH-COMPANY
  RSH-ROLE
  RSH-FIELD-ID
  RSH-SEQ-NUMBER
Actotbal Base ACTOTBAL
AGP-ACTIVITY-GRP->TOT-ACTIVITY-GRP
Spaces->TOT-ACTIVITY
AGP-CURRENCY-CODE->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
Actotbal Cur1 ACTOTBAL
AGP-ACTIVITY-GRP->TOT-ACTIVITY-GRP
Spaces->TOT-ACTIVITY
AGP-CURR-CODE-1->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
Actotbal Cur2 ACTOTBAL
AGP-ACTIVITY-GRP->TOT-ACTIVITY-GRP
Spaces->TOT-ACTIVITY
AGP-CURR-CODE-2->TOT-CURRENCY-CODE
  TOT-BUDGET-NBR
  TOT-CATEGORY-TYPE
  TOT-FISCAL-YEAR
Aracpivot ARACPIVOT
AGP-ACTIVITY-GRP->CCP-ACTIVITY-GRP
  CCP-DUE-DATE
  CCP-TRANS-TYPE
  CCP-BATCH-NBR
  CCP-TRANSACTION
  CCP-PAYMENT-SEQ
  CCP-COMPANY
Histastasgn ACRESHIST
AGP-ACTIVITY-GRP->RSH-ACTIVITY-GRP
"A"->RSH-RESOURCE-TYPE
340->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histastrole ACRESHIST
AGP-ACTIVITY-GRP->RSH-ACTIVITY-GRP
"A"->RSH-RESOURCE-TYPE
341->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histempasgn ACRESHIST
AGP-ACTIVITY-GRP->RSH-ACTIVITY-GRP
"E"->RSH-RESOURCE-TYPE
320->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histemprole ACRESHIST
AGP-ACTIVITY-GRP->RSH-ACTIVITY-GRP
"E"->RSH-RESOURCE-TYPE
321->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histeqpasgn ACRESHIST
AGP-ACTIVITY-GRP->RSH-ACTIVITY-GRP
"Q"->RSH-RESOURCE-TYPE
350->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histeqprole ACRESHIST
AGP-ACTIVITY-GRP->RSH-ACTIVITY-GRP
"Q"->RSH-RESOURCE-TYPE
351->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histperasgn ACRESHIST
AGP-ACTIVITY-GRP->RSH-ACTIVITY-GRP
"P"->RSH-RESOURCE-TYPE
310->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histperrole ACRESHIST
AGP-ACTIVITY-GRP->RSH-ACTIVITY-GRP
"P"->RSH-RESOURCE-TYPE
311->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histvenasgn ACRESHIST
AGP-ACTIVITY-GRP->RSH-ACTIVITY-GRP
"V"->RSH-RESOURCE-TYPE
330->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Histvenrole ACRESHIST
AGP-ACTIVITY-GRP->RSH-ACTIVITY-GRP
"V"->RSH-RESOURCE-TYPE
331->RSH-FIELD-ID
  RSH-COMPANY
  RSH-RESOURCE-CODE
  RSH-SEQ-NUMBER
Perfhist ACPRDPERF
AGP-ACTIVITY-GRP->PFM-ACTIVITY-GRP
Spaces->PFM-ACTIVITY
  PFM-SYSTEM
  PFM-SEQ-NUMBER


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

Home
Contact Us



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