|
|
ACACTGRP FILE
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 AC03.2 AC03.3 AC03.4 AC03.5
AC03.6 AC03.7 AC06.1 AC06.2 AC08.2 AC08.3
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 AC160 AC165 AC169 AC18.1 AC18.2
AC18.3 AC18.4 AC18.5 AC19.1 AC19.2 AC19.3
AC190 AC191 AC197 AC198 AC200 AC203
AC206 AC207 AC21.1 AC21.2 AC21.3 AC21.4
AC210 AC213 AC218 AC220 AC225 AC227
AC240 AC246 AC25.1 AC255 AC256 AC261
AC265 AC27.1 AC290 AC295 AC298 AC30.3
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
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 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 AC98.1 AC98.2 ACAC.1 ACBA.1
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 AP520 AP95.3
API1.1 API2.1 AR115 AR124 AR129 AR130
AR131 AR135 AR190 AR20.1 AR21.1 AR21.2
AR21.3 AR237 AR239 AR24.1 AR250 AR257
AR27.2 AR29.1 AR29.2 AR296 AR30.1 AR30.5
AR30.8 AR32.1 AR33.1 AR33.2 AR33.3 AR33.6
AR34.1 AR35.1 AR36.1 AR38.5 AR39.1 AR39.2
AR39.3 AR39.4 AR42.1 AR42.2 AR42.7 AR43.1
AR48.3 AR502 AR503 AR55.1 AR560 AR570
AR575 AR580 AR800 AR91.1 ARLL.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.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 CB80.1 CB82.1
CXCP.1 EE135 EE20.3 EE35.1 EE35.2 EE520
ET175 ET530 ET540 ET542 ET700 ETI2.1
GL146 GL165 GL170 GL197 GL199 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
HCHP.1 CU00.1 IFGT.1 MX123 MX500 LP130
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA65.1 MA66.2 MA66.3
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 PO100 PO101
PO122 PO131 PO135 PO150 PO190 PO20.1
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO23.1 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 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 POCP.1
POD0.1 POI3.1 POID.1 POIF.1 POIG.1 POII.1
POIJ.1 PR128 PR130 PR131 PR132 PR134
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 PR37.1 PR38.1 PR45.1
PR529 PR530 PR560 PR80.1 PR82.1 PR85.1
PR89.1 UK102 UK330 UK560 PW110 PW510
PW90.1 PWI2.1 RQ10.1 RQ10.2 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ500 RQD0.1 RQIA.1 RQIF.1
SB15.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 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 AC22.1 AC300
AC310 AC560 AC581 ACDR.1 SB515
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AGP-ACTIVITY-GRP Alpha 15 AC00.1 AC110
Element: Activity GroupRequired key. An activity group or AC197 AC198
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.
AGP-DESCRIPTION Alpha 30 (Lower Case) AC00.1 AC110
Activity Group This is the activity group description. AC197 AC198
Description
AGP-OBJ-ID Numeric 12 AC00.1 AC110
Element: Obj Id This is the object identifier. It is
used to relate activity group attributes
to the activity group.
AGP-CURRENCY-TABLE Alpha 12 AC00.1
Element: Currency TableThis is the currency table, a table of
currency relationships, currency
exchange rates, and translation rates.
AGP-CURRENCY-CODE Alpha 5 AC00.1 AC197
Element: Currency Code This is the base currency code of the AC198 BR02.3
activity group. You define the base BR120 BR121
currency code in AC00.1 (Activity BR122 BR123
Group). Consolidation amounts are BR140 BR151
reported in activity group base BR152 BR156
currency. BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
AGP-BEGIN-DATE Numeric 8 (yyyymmdd) AC00.1
Element: Begin Date 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.
AGP-END-DATE Numeric 8 (yyyymmdd) AC00.1
Element: End Date 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.
AGP-CALENDAR-NAME Alpha 12 AC00.1 BR02.3
Element: Calendar Name Required. Enter the name of a calendar BR120 BR121
that defines the fiscal periods for the BR122 BR123
activity group. The calendar is defined BR140 BR151
in AC00.3 (Calendar). BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
AGP-SECURITY-CD Numeric 4 AC00.1
Element: Security Code 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.
AGP-LEVEL-DESC Alpha 12 (Lower Case) AC00.1
Element: Level DescriptOccurs 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.
AGP-LEVEL-SIZE Numeric 2 Occurs 5 Times AC00.1
Element: Level Size 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.
AGP-ACTIVE-STATUS Alpha 1 AC00.1 AC00.3
Element: Active Status 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
AGP-BASE-ND Numeric 1 AC00.1 AC197
Base Number of This is the number of decimal positions AC198
Decimals defined for the activity group base
currency.
AGP-ACTIVE-BUD Numeric 3 AC110 AC127
Element: Active Budget This is the budget number for the AC20.6 SB515
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).
AGP-TOTAL-BUDGET Signed 18.2 AC00.1 AC110
Element: Total Budget This is the sum of the activity budgets AC20.1 AC20.2
for the activity group. This field is AC20.3 AC20.4
used in editing to determine if the sum AC20.5 AC20.6
of the activity budgets exceeds the AC20.7 ACDR.1
budget cap.
AGP-BUDGET-CAP Signed 18.2 AC00.1
Element: Budget Cap 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.
AGP-WORKFLOW-FLAG Alpha 1
Element: Workflow Flag This field will be used in implementing
Activity Management Workflow.
Y = Yes
N = No
AGP-CHG-ORDER-FLAG Alpha 1 AC00.1
Element: Change Order FThis 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.
AGP-CONSOL-FLAG Alpha 1 AC00.1
Element: Consolidation 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
AGP-ACCT-EDIT-FLAG Alpha 1 AC00.1
Element: Account Edit FThis 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)
AGP-BUDGET-EDIT Alpha 1 AC00.1
Element: Budget Edit 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
AGP-BUDGET-LEVEL Alpha 1 AC00.1
Element: Budget Level 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
AGP-BUD-TOLERANCE Signed 5.2 AC00.1
Element: Budget ToleranThis field defines what percentage over
the budget, if any, is acceptable.
Budget Tolerance Percent is required if
budgets are edited.
AGP-EDIT-PR Alpha 1 AC00.1
Element: Edit Payroll This field indicates whether to edit
employee information in Payroll. Select
Yes if you want to edit employee
information.
Y = Yes
N = No
AGP-PR-COMMIT Alpha 1 AC00.1
Element: Pr Commit 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
AGP-EDIT-AP-EE Alpha 1 AC00.1
Element: Edit AP and EEThis 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
AGP-EDIT-TRANSREL Alpha 1 AC00.1
Element: Edit Transrel Y = Yes
N = No
AGP-LAST-COMMENT Numeric 6
Element: Last Comment This is the last sequence number used
for comments relating to the activity
group.
AGP-LAST-AGA-SEQ Numeric 6 AC07.1 AC105
Last Activity Grp This is the last line added in AC07.1 AC110 AC120
Sequence Nbr (Account Assignment). Account assignment AC560
records are stored in the Activity GL
Accounts file.
AGP-RELEASED Alpha 1
Element: Released 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 Alpha 1 AC00.1
Element: Inv Audit Y = Yes
N = No
AGP-BEGIN-YR Derived
Element: Begin Year This is the year in which activities in
the activity group begin.
AGP-END-YR Derived
Element: End Year This is the year in which the
activities in the activity group end.
AGP-GL-CONSOL-FL Alpha 1 AC00.1
Accounting Unit This flag indicates whether you want to
Consolidate create summary-level activity
consolidation records in the Activity CL
Accounting Unit Consolidation header and
detail files.
Y = Yes
N = No
AGP-RESOURCE-FL Alpha 1 AC00.1
Element: All Flag Y = Yes
N = No
AGP-LEVEL-1-DESC Derived
Element: Level 1 DescriThis is the description for level 1.
AGP-LEVEL-2-DESC Derived
Element: Level 2 DescriThis is the description for level 2.
AGP-LEVEL-3-DESC Derived
Element: Level 3 DescriThis is the description for level 3.
AGP-LEVEL-4-DESC Derived
Element: Level 4 DescriThis is the description for level 4.
AGP-LEVEL-5-DESC Derived
Element: Level 5 DescriThis is the description for level 5.
AGP-PURGE-STATUS Alpha 1 AC00.3 AC300
Element: Purge Status 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
AGP-OUTPUT-MEASURE Signed 18.2 AC00.1
Element: Intl Amt This is the output measurement.
AGP-OUTPUT-DESC Alpha 30 AC00.1
Element: Output Desc This is the output description.
AGP-CURR-NAME-1 Alpha 12 AC00.1 AC581
Element: Curr Name 1 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.
AGP-CURR-CODE-1 Alpha 5 AC00.1 AC197
Element: Currency Code This field contains the company base AC198 AC581
currency code established in Company
(GL10.1 ).
AGP-CURR-CODE-ND-1 Numeric 1 AC00.1 AC198
Element: Acct Nd The number of decimals assigned to a AC581
particular account as determined by the
account currency.
AGP-CURR-NAME-2 Alpha 12 AC00.1 AC581
Element: Curr Name 2 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.
AGP-CURR-CODE-2 Alpha 5 AC00.1 AC197
Element: Curr Code 2 Type the currency code you want to AC198 AC581
associate with the report currency name.
The currency code must exist in CU01.1
(Currency Codes).
AGP-CURR-CODE-ND-2 Numeric 1 AC00.1 AC581
Element: Acct Nd The number of decimals assigned to a
particular account as determined by the
account currency.
AGP-BURDEN-CALC-FL Alpha 1 AC00.1
Element: Burden Calc FlY = Yes
N = No
AGP-ACTIVITY-FLAG Alpha 1 AC00.1
Element: Activity Flag Y = Yes
N = No
AGP-ASSET-FLAG Alpha 1 AC00.1
Element: Asset Flag Y = Yes
N = No
AGP-RESC-ASSIGN-FL Alpha 1 AC00.1
Element: Resc Assign FlY = Yes
N = No
AGP-ATTRIBUTE-FLAG Alpha 1 AC00.1
Element: Attribute FlagY = Yes
N = No
AGP-BILLING-FLAG Alpha 1 AC00.1
Element: Billing Flag Y = Yes
N = No
AGP-CONTRACT-FLAG Alpha 1 AC00.1
Element: Contract Flag Y = Yes
N = No
AGP-CEILING-FLAG Alpha 1 AC00.1
Element: Ceiling Flag Y = Yes
N = No
AGP-BILL-CONSOL-FL Alpha 1 AC00.1 BR02.3
Element: Bill Consol FlY = Yes BR120 BR121
N = No BR122 BR123
BR140 BR151
BR152 BR156
BR20.1 BR20.2
BR20.3 BR20.4
BR20.5 BR420
BR521
AGP-DATE-EDIT Alpha 1 AC00.1
Element: Date Edit Used with the ACAC Edit. Valid values
are posting and transaction date.
P = Posting Date
T = Transaction Date
AGP-BILL-CALC-DATE Alpha 1 AC00.1
Element: Bill Calc DateUsed with the activity billing
calculation logic. Valid values are
posting and transaction date.
P = Posting Date
T = Transaction Date
AGP-TE-ACCT-DF-FL Alpha 1 AC00.1
Element: Te Acct Df Fl A = Activity Expense Account
E = Employee Expense Account
AGP-TE-ACCT-CAT-DF Alpha 1 AC00.1
Element: Te Acct Cat DfA = Activity Acct Category
E = Employee Acct Category
AGP-ACCOUNT Numeric 6 AC00.1
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
AGP-SUB-ACCOUNT Numeric 4 AC00.1
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
AGP-GL-CODE Alpha 4 AC00.1
Element: Gl Code
AGP-EXPENSE-FL Alpha 1 AC00.1
Element: Expense Fl
AGP-ASSET-EDIT Alpha 1 AC00.1
Element: Asset Edit Y = Yes
N = No
AGP-POP-FLAG Alpha 1 AC00.1
Element: Pop Flag Period of Performance flag. Will
indicate the use of period of
performance. This will be edited when
transactions are added.
N = No
Y = Yes
AGP-BRDN-DATE-EDIT Alpha 1 AC00.1
Element: Brdn Date EditDetermines whether burden rates are
based on the ACTRANS transaction date or
posting date.
P = Posting Date
T = Transaction Date
AGP-STRUCTURE Alpha 15 AC00.1
Element: Structure The name of the category structure.
This represents the category structure
assigned to the activity group.
AGP-CAT-CONSOL-FL Alpha 1 AC00.1
Element: Consol Flag Y = Yes
N = No
ACACTGRP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AGPSET1 ACTIVITY-GRP AC00.1 AC00.3
AC01.1 AC01.5
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC03.7
AC06.1 AC06.2
AC07.1 AC08.2
AC08.3 AC10.1
AC10.3 AC10.5
AC10.6 AC105
AC108 AC11.1
AC110 AC112
AC113 AC12.1
AC12.2 AC120
AC121 AC123
...
AGPSET2 OBJ-ID AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC128
AC130 AC135
AC14.2 AC14.3
AC14.4 AC145
AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC200 AC203
AC206 AC207
...
AGPSET3 STRUCTURE KeyChange AC08.7
ACTIVITY-GRP
ACACTGRP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
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 RELATED
NAME 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
|
