Lawson Insight Technical Documentation |
|
ACACTIVITY
ACACTIVITY FILE
Activity
This file contains activity set-up and definition information from AC10.1
(Activity). Activities identify the actual tasks that make up an activity. The
Lawson Activity Management system stores data such as activity group,
responsible company, date ranges, status, long description, levels and
location. This information is used to collect and report on costs and
revenues. You must set up an activity before you can create activity budgets
and post transactions.
An activity's level number configuration relates it to other activities in a
hierarchy for consolidating, or rolling up, data on certain forms and reports.
Transactions in the Activity Management system are posted to activities.
Journal entries destined for activity posting are entered in the General
Ledger or a subledger with an entry in the Activity and Account Category
fields on the transaction line.
REFERENCED BY
AC01.1 AC02.1 AC03.2 AC03.3 AC03.4 AC03.5
AC03.6 AC03.7 AC06.1 AC06.2 AC07.1 AC08.3
AC105 AC108 AC11.1 AC121 AC123 AC13.1
AC13.2 AC13.3 AC13.4 AC13.7 AC13.8 AC130
AC131 AC135 AC145 AC160 AC165 AC18.1
AC18.2 AC18.3 AC18.4 AC18.5 AC191 AC197
AC198 AC200 AC203 AC206 AC207 AC21.1
AC21.2 AC21.3 AC21.4 AC210 AC213 AC218
AC22.1 AC220 AC225 AC227 AC240 AC246
AC25.1 AC256 AC261 AC265 AC27.1 AC29.1
AC290 AC295 AC298 AC30.1 AC30.2 AC30.3
AC30.4 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 AC42.3 AC420
AC421 AC440 AC45.1 AC46.1 AC46.2 AC460
AC471 AC472 AC473 AC480 AC490 AC493
AC494 AC50.1 AC50.2 AC502 AC51.1 AC510
AC52.1 AC520 AC54.1 AC540 AC55.1 AC580
AC581 AC583 AC60.1 AC60.2 AC61.1 AC65.1
AC65.2 AC81.1 AC881 AC90.1 AC90.2 AC90.4
AC90.6 AC90.8 AC92.1 AC92.2 AC92.4 AC92.6
AC93.1 AC93.4 AC93.5 AC93.2 AC93.3 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 ACSB.1
ACSR.1 ACVW.1 SE10.1 SE90.1 AM18.2 AP125
AP126 AP131 AP170 AP175 AP178 AP193
AP211 AP237 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP520 AP95.3 API1.1 API2.1
AR115 AR124 AR190 AR20.1 AR21.1 AR21.2
AR21.3 AR24.1 AR250 AR251 AR29.2 AR293
AR30.1 AR30.5 AR33.1 AR33.2 AR34.1 AR42.1
AR42.2 AR42.7 AR43.1 AR560 AR570 AR575
AR580 ARLL.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 BN150 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 BR06.1 BR121 BR13.1 BR131
BR14.1 BR142 BR145 BR15.2 BR165 BR18.1
BR18.2 BR18.3 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 BR220 BR245
BR265 BR300 BR40.1 BR40.3 BR40.4 BR400
BR405 BR41.1 BR41.4 BR42.1 BR42.2 BR420
BR43.1 BR430 BR44.1 BR45.1 BR450 BR46.1
BR46.2 BR46.3 BR46.4 BR515 BR516 BR580
BR65.1 BR65.2 BR90.1 BR96.1 BRCC.1 BRIP.1
CB10.1 CB15.1 CB15.2 CB180 CB191 CB20.1
CB30.1 CB500 CB80.1 CXCP.1 EE135 EE20.3
EE35.1 EE35.2 EE520 GL146 GL165 GL170
GL197 GL199 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 GL50.4 GL70.1 GL70.2
GL70.3 GL70.5 GL70.6 GL75.1 GL90.3 HCHP.1
HACV.1 DR100 IC140 IC28.1 IC531 IC83.1
IFGT.1 MX123 MX500 MA180 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA65.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE810
OE830 OE90.1 OE90.2 PA182 PO100 PO101
PO122 PO131 PO150 PO20.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO25.1 PO25.6
PO25.7 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 POCP.1 POI3.1 POID.1 POIE.1
POIF.1 POII.1 POIJ.1 HS36.1 PR128 PR130
PR131 PR132 PR134 PR136 PR137 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 PR82.1 PR85.1 PRSA.1
UK102 UK330 RQ10.1 RQ10.2 RQ12.1 RQ13.1
RQ13.2 RQ140 RQ300 RQ35.1 RQ40.1 RQ41.1
RQ42.1 RQ44.1 RQ44.2 RQ500 RQIF.1 TA147
TP135 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH25.1 WH25.2 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 WO132 WO140 MX202 MX223
UPDATED BY
AC00.1 AC10.1 AC10.5 AC10.6 AC110 AC112
AC113 AC12.1 AC120 AC127 AC190 AC20.7
AC300 AC310 AC500 ACDR.1 BR10.1 BR120
BR122 BR130 BR140 BR521 BR530
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ACV-ACTIVITY Alpha 15 AC10.1 AC110
Element: Activity Activities are the processes or AC197 AC198
procedures that produce work. Cost AC500 AC540
objects (products, services, customers, AC90.2 AC90.4
and so on) are the reasons for AC90.6 AC90.8
performing the activity. Activities and AC95.2
cost object activities are used
synonymously in the Lawson Activity
Management system. Direct costs are
posted to activities, and indirect costs
are allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two types of
activities: posting allowed and summary
only. Use posting level activities to
budget and maintain all posted
transactions. Summary activities or
macro activities combine information and
balances from lower level activities for
reporting and inquiries.
ACV-DESCRIPTION Alpha 30 (Lower Case) AC10.1 AC110
Element: Activity DescrThis is the activity description. AC145 AC197
AC198 AC500
ACV-ACTIVITY-GRP Alpha 15 AC10.1 AC110
Element: Activity GroupThis is the activity group for the AC120 AC500
activity. AC90.2 AC90.4
AC90.6 AC90.8
AC95.2
ACV-CONTRACT Alpha 10 BR10.1
Element: Contract If this Activity is a Contract type, and
is idetified in BR0 as the 'Contract
Activity', th name of the related
Contrct will be updated to this field.
ACV-COMPANY Numeric 4 AC10.1 AC110
Element: Company This field defines the responsible AC113 AC500
company number for the activity. The AC540
responsible company is defined in the
General Ledger system. The responsible
company determines the activity
currency.
ACV-ACCT-UNIT Alpha 15 AC10.1 AC110
Element: Accounting UniThis is an accounting unit for the AC113 AC500
activity. The accounting unit is a
shorthand notation representing a
location or variable level. The
accounting unit must be defined in the
General Ledger Names file as a posting
accounting unit.
ACV-ACCOUNT Numeric 6 AC10.1 AC110
Element: Account This field along with the accounting AC113 AC500
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
ACV-SUB-ACCT Numeric 4 AC10.1 AC110
Element: Subaccount This field contains the subaccount from AC113 AC500
your general ledger chart of accounts
that was charged with the amount carried
on this record.
ACV-ACCT-CATEGORY Alpha 5 AC10.1 AC110
Element: Account CategoThis is an account category for the AC500
activity. Account categories are
groupings of costs, revenues, or a
combination of both used for reporting
and inquiries for activities in the
Lawson Activity Management system. All
transactions are posted to an account
category within an activity. Using
AC07.1 (Account Assignment), you can
assign a specific General Ledger account
or range of accounts (company,
accounting unit, account, and
subaccount) to the transactions posted
to an account category .
ACV-CURRENCY-CODE Alpha 5 AC10.1 AC110
Element: Currency Code This is the company currency code. AC197 AC198
AC500
ACV-USR-STATUS Alpha 2 AC10.1 AC110
Element: Status This is a user-defined code indicating AC112 AC12.1
the status of the activity. You can AC500
define various parameters relating to
the status in AC02.1 (Status), including
whether an activity allows posting,
billing, revenue recognition, budgeting,
capitalization, or purging. This field
is required for activities assigned to
Activity Management activity groups. It
is not required for GL-only activities.
ACV-VAR-LEVELS Alpha 30 AC10.1 AC110
Element: Variable LevelLevels define an addressing system that AC120 AC500
organizes activities into a reporting AC90.2 AC90.4
hierarchy. Level names are defined for AC90.6 AC90.8
an activity group and should be able to AC95.2
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.
Up to 15 characters can be used to name
a single level. The number of characters
used to name all levels can total 30.
ACV-VAR-LEVEL-DISP Alpha 34 AC10.1 AC110
Variable Level This field shows the hierarchical AC120 AC197
Display numbering scheme that allows detail to AC198 AC500
be aggregated or "rolled-up" in
summarized form. Five levels are
available in the Activity Management
system.
ACV-BEGIN-DATE Numeric 8 (yyyymmdd) AC10.1 AC110
Element: Begin Date This is the beginning date for the AC500
activity. The activity date range must
be within the date range for the
activity group. If you leave this field
blank, the activity group begin date
defaults.
ACV-END-DATE Numeric 8 (yyyymmdd) AC10.1 AC110
Element: End Date This is the ending date for the AC500
activity. The activity date range must
be within the date range for the
activity group. If you leave this field
blank, the activity group begin date
defaults.
ACV-ACTIVE-BUD Numeric 3 AC110 AC127
Element: Active Budget This is the budget number for the AC20.7 AC310
activity group active budget. The active
budget is the default budget used for
inquiries and reporting and in
calculating percentage of completion for
AC65.1 (Account Category Percent of
Completion).
ACV-LONG-DESC Alpha 60 (Lower Case) AC10.1 AC110
Element: Long DescriptiOccurs 4 Times AC500
This is the long description of the
activity.
ACV-ESTIMATE Signed 18.2 AC10.1 AC110
Element: Estimate This is a budget estimate for the AC500
activity. This estimate is informational
only.
ACV-OBJ-ID Numeric 12 AC10.1 AC110
Element: Activity ObjecThis field defines the activity. The AC197 AC198
object ID is used with activity AC500
attributes. Attribute matrix files are
keyed by object ID. The value in this
field is unique and generated by the
system.
ACV-PARENT-ACTV Alpha 15 AC10.1 AC110
Element: Parent Actv The parent activity field contains the AC120 AC500
activity name of the member parent.
ACV-ACTIVITY-ND Numeric 1 AC10.1 AC110
Activity Curr Nbr This is the number of decimal positions AC145 AC197
of Decimals defined for the activity currency. AC198 AC500
ACV-HIGH-PST-DATE Numeric 8 (yyyymmdd) AC110 AC190
Element: Highest PostinThis is the latest posting date for AC300 AC500
transactions posted to the activity. ACDR.1
ACV-BALANCE-AMOUNT Signed 18.2 AC110 AC300
Element: Balance AmountThis is the amount balance for the ACDR.1
life-to-date activity actuals amount.
ACV-BALANCE-UNIT Signed 17.2 AC110 AC300
Element: Units Balance This is the unit balance for the ACDR.1
activity actuals.
ACV-SHORT-DESC Derived
Element: Short DescriptThis is the short description of the
activity.
ACV-BILLABLE-FLAG Alpha 1 AC10.1 AC110
Element: Billable Flag This field indicates whether the AC197 AC198
activity is billable. Use Yes (Y) for AC500
billable. Use No (N) for nonbillable.
Y = Yes
N = No
H = Hold
ACV-SECURITY-CD Numeric 4 AC00.1 AC10.1
Element: Security Cd This field contains the security code AC110 AC120
for the activity. AC500
ACV-POST-OR-GLONLY Derived
Element: Post Or Glonly
ACV-OUTPUT-MEASURE Signed 18.2 AC10.1 AC500
Element: Intl Amt This is the output measurement.
ACV-OUTPUT-DESC Alpha 30 AC10.1 AC500
Element: Output Desc This is the output description.
ACV-SEGMENT-FLAG Alpha 1 AC10.1 AC110
Element: Segment Flag Indicates whether user analysis values AC500
(SL segment) have been populated for the
distribution line.
ACV-GRP-CURR-CODE1 Derived
Element: Grp Curr Code1
ACV-GRP-CURR-CODE2 Derived
Element: Grp Curr Code2
ACV-ACT-SEG-BLOCK Derived
Element: Act Seg Block
ACV-BILL-WBS-CODE Alpha 3 AC10.1
Element: Bill Wbs Code
ACV-LOCATION-NAME Alpha 15 AC10.1
Element: Location Name A user-defined location name which
represents where an asset is physically
located. Locations are used to report
asset information.
ACV-DIVISION Alpha 15 AC10.1
Element: Division A user-defined division which is used
for reporting assets.
ACV-POP-FLAG Alpha 1 AC10.6 AC110
Element: Pop Flag Period of Performance flag. If records AC120
are added into the ACPRDPERF file for
the related activity, the flag will be
updated to Y.
N = No
Y = Yes
ACV-AWARD-FLAG Alpha 1 AC10.1 AC110
Element: Award Flag Flag to indicate whether this activity AC500
is an award for the GM system or a
posting level activity within an award.
Y = Yes
N = No
ACV-EFFORT-FLAG Alpha 1 AC10.1 AC110
Element: Effort Flag Flag to indicate whether this activity AC500
is subject to effort reporting, and if
it is, whether it prints in the
sponsored or non-sponsored section of
the report for effort reporting.
Y = Yes
N = No
ACV-SALARY-CAP-FL Alpha 1 AC10.1 AC110
Element: Salary Cap Fl This flag indicates whether the salary AC500
cap applies to this grant/project. The
actual salary cap amount is stored on
the GMSALCAP record.
Y = Yes
N = No
ACV-FRNG-RATE Signed 14.7 AC10.1 AC110
Element: Currency Rate A default fringe rate that can be sued AC500
by the GM110 program to create
commitments for fringe amounts. There
is a parameter choice on the GM110
program that allows the user to default
the fringe rate, post-to account and
account category information from the
activity or the employee.
ACV-FRNG-ACCT-CAT Alpha 5 AC10.1 AC110
Element: Frng Acct Cat A default post-to fringe account AC500
category that can be used by GM110
program to create commitments for fringe
amounts. There is a parameter choice on
the GM110 program that allows the user
to default the rate, post-to account and
account category information from the
activity or employee.
ACV-FRNG-ACCOUNT Numeric 6 AC10.1 AC110
Element: Frng Account A default post-to fringe account that AC500
can be used by the GM110 program to
create commitments for fringe amounts.
There is a parameter choice on the GM110
program that allows the user to default
the fringe rate, post-to account and
account category information from the
activity or employee.
ACV-FRNG-SUB-ACCT Numeric 4 AC10.1 AC110
Element: Frng Sub Acct A default post-to fringe sub account AC500
that can be used by the GM110 program to
create commitments for fringe amounts.
There is a parameter choice on the GM110
program that allows the user to default
the fringe rate, post-to account and
account category information from the
activity or employee.
ACV-SALARY-CAP-AMT Signed 18.2 AC10.1 AC110
Element: Intl Amt Salary cap amount for the activity. It AC500
is assummed to be in the activity
currency.
ACV-STRUCTURE Alpha 15 AC10.1 AC110
Element: Structure The name of the category structure. AC500
This represents the category structure
assigned to the activity.
ACV-BILL-REV-FLAG Alpha 1 AC10.1 AC120
Element: Bill Rev Flag Y = Yes BR120 BR122
N = No BR130 BR140
BR521 BR530
ACV-BACKOUT-STATUS Alpha 1 AC10.1 AC10.5
Element: Backout StatusY = Yes AC120 BR140
N = No
ACV-PAR-ACT-STRCT Alpha 15 Occurs 4 Times AC10.1 AC110
Element: Parent Actv This field will contain the parent of AC120 AC500
the Activity at each variable level in
the Activity Groups hierarchy.
ACV-POSTING-FLAG Alpha 1 AC10.1 AC110
Element: Posting Flag P = Posting AC500
S = Summary
C = Contract
ACV-LEVEL-DEPTH Numeric 1 AC10.1 AC110
Element: Level Depth The number of variable levels AC120 AC500
pertaining
to this record.
ACV-LEVEL-DETAIL Numeric 15 Occurs 5 Times AC10.1 AC110
Element: Level Detail AC120 AC500
ACACTIVITY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ACVSET1 ACTIVITY AC01.1 AC02.1
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC03.7
AC06.1 AC06.2
AC07.1 AC08.3
AC10.1 AC10.2
AC10.3 AC10.5
AC10.6 AC105
AC108 AC11.1
AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC127
AC13.1 AC13.2
...
ACVSET2 ACTIVITY-GRP KeyChange AC00.1 AC01.1
ACTIVITY AC10.1 AC10.5
AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC135
AC145 AC160
AC165 AC190
AC191 AC197
AC198 AC20.5
AC20.8 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
...
ACVSET3 COMPANY KeyChange AC12.1
ACTIVITY
ACVSET4 ACTIVITY-GRP KeyChange AC01.1
LEVEL-DEPTH
VAR-LEVELS*
ACTIVITY
ACVSET6 OBJ-ID AC01.1 AC105
AC112 AC113
AC120 AC121
AC123 AC13.2
AC13.3 AC13.4
AC130 AC135
AC145 AC160
AC165 AC190
AC191 AC197
AC198 AC20.1
AC20.2 AC20.3
AC20.4 AC20.5
AC200 AC203
AC206 AC207
AC210 AC213
...
ACVSET7 PARENT-ACTV KeyChange
ACTIVITY
ACVSET8 ACTIVITY-GRP KeyChange, Subset AC01.1 AC10.1
VAR-LEVELS Where (VAR-LEVELS != Spaces ) AC10.5 AC11.1
AC110 AC112
AC113 AC12.1
AC120 AC121
AC123 AC135
AC145 AC160
AC165 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC246 AC256
...
ACACTIVITY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acacctcat ACACCTCAT Not Required
ACV-ACCT-CATEGORY -> AAX-ACCT-CATEGORY
Acactgrp ACACTGRP Required
ACV-ACTIVITY-GRP -> AGP-ACTIVITY-GRP
Acactseg ACACTSEG Not Required
ACV-OBJ-ID -> CSG-OBJ-ID
Acaddlcntr ACADDLCNTR Not Required
ACV-ACTIVITY-GRP -> ADN-ACTIVITY-GRP
CNT-CONTRACT -> ADN-CONTRACT
Acbill ACBILL Not Required
ACV-ACTIVITY -> ACI-ACTIVITY
Acbudhdr Set1 ACBUDHDR Not Required
Valid When ACV-ACTIVE-BUD != Zeroes
ACV-ACTIVITY-GRP -> BDH-ACTIVITY-GRP
ACV-ACTIVITY -> BDH-ACTIVITY
ACV-ACTIVE-BUD -> BDH-BUDGET-NBR
Accntract ACCNTRACT Not Required
ACV-CONTRACT -> CNT-CONTRACT
Accustomer ACCUSTOMER Not Required
CNT-COMPANY -> CMR-COMPANY
CNT-CUSTOMER -> CMR-CUSTOMER
CNT-AC-CUSTOMER-ID -> CMR-AC-CUSTOMER-ID
Aclevel ACLEVEL Required
ACV-ACTIVITY-GRP -> LVL-ACTIVITY-GRP
ACV-VAR-LEVELS -> LVL-VAR-LEVELS
Acstatus ACSTATUS Required
ACV-USR-STATUS -> STS-USR-STATUS
Cucodes CUCODES Required
ACV-CURRENCY-CODE -> CUC-CURRENCY-CODE
Glnames GLNAMES Not Required
ACV-COMPANY -> GLN-COMPANY
ACV-ACCT-UNIT -> GLN-ACCT-UNIT
Glsystem GLSYSTEM Required
ACV-COMPANY -> GLS-COMPANY
Gmaward GMAWARD Not Required
ACV-ACTIVITY -> GMG-ACTIVITY
Object Id OBJID Not Required
"ACTVY" -> OBI-OBJ-TYPE
Parent ACACTIVITY Not Required
ACV-PARENT-ACTV -> ACV-ACTIVITY
Structure STRUCTURE Required
ACV-STRUCTURE -> SRE-STRUCTURE
ACACTIVITY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
A Assign ACASSIGN
"A" -> AAN-RESOURCE-TYPE
ACV-ACTIVITY-GRP -> AAN-ACTIVITY-GRP
ACV-ACTIVITY -> AAN-ACTIVITY
AAN-COMPANY
AAN-RESOURCE-CODE
Acacctcatx ACACCTCATX
ACV-ACTIVITY-GRP -> AXX-ACTIVITY-GRP
ACV-ACTIVITY -> AXX-ACTIVITY
AXX-ACCT-CATEGORY
Acacctcatxset2 ACACCTCATX
ACV-ACTIVITY-GRP -> AXX-ACTIVITY-GRP
AXX-ACCT-CATEGORY
AXX-ACTIVITY
Acacresrtx ACACRESRTX
ACV-ACTIVITY-GRP -> CRX-ACTIVITY-GRP
ACV-ACTIVITY -> CRX-ACTIVITY
CRX-RESOURCE-TYPE
CRX-RESOURCE-CODE
CRX-COMPANY
CRX-EFFECTIVE-DATE
Acacresrtx Grp ACACRESRTX
ACV-ACTIVITY-GRP -> CRX-ACTIVITY-GRP
Spaces -> CRX-ACTIVITY
CRX-RESOURCE-TYPE
CRX-RESOURCE-CODE
CRX-COMPANY
CRX-EFFECTIVE-DATE
Acactmxval ACACTMXVAL
ACV-OBJ-ID -> AJV-OBJ-ID
AJV-MATRIX-CAT
Acaddassgn ACADDASSGN
ACV-ACTIVITY -> AAS-ACTIVITY
AAS-ADDRESS-CODE
Acamcode ACAMCODE
ACV-ACTIVITY -> MCD-ACTIVITY
MCD-ACCT-CATEGORY
Acamcode 1 ACAMCODE
ACV-ACTIVITY -> MCD-ACTIVITY
MCD-ACCT-CATEGORY
Acasnrole ACASNROLE
ACV-ACTIVITY-GRP -> ALE-ACTIVITY-GRP
ACV-ACTIVITY -> ALE-ACTIVITY
ALE-RESOURCE-TYPE
ALE-COMPANY
ALE-RESOURCE-CODE
ALE-ROLE
Acassign ACASSIGN
ACV-ACTIVITY-GRP -> AAN-ACTIVITY-GRP
ACV-ACTIVITY -> AAN-ACTIVITY
AAN-COMPANY
AAN-RESOURCE-TYPE
AAN-RESOURCE-CODE
Acaudit ACAUDIT
ACV-ACTIVITY -> AUD-ACTIVITY
AUD-PROCESS-DATE
AUD-PROCESS-TIME
AUD-COPY-FR-AG
AUD-COPY-TO-AG
AUD-REORG-OR-COPY
Acbillx ACBILLX
ACV-ACTIVITY -> AIX-ACTIVITY
AIX-SUM-ACCT-CAT
AIX-CTR-CAT-GRP
AIX-ACCT-CATEGORY
Acblactv ACBLACTV
ACV-ACTIVITY -> BLA-ACTIVITY
BLA-ACCT-CATEGORY
BLA-CTR-CAT-GRP
BLA-SUM-ACCT-CAT
BLA-BILL-ACTIVITY
Acblratex ACBLRATEX
ACV-ACTIVITY -> ALX-ACTIVITY
ALX-SUM-ACCT-CAT
ALX-CTR-CAT-GRP
ALX-ACCT-CATEGORY
ALX-SOURCE-CODE
ALX-MATRIX-CAT
ALX-EFFECTIVE-DT
ALX-MX-VALUE
Acbrdnblrx ACBRDNBLRX
ACV-ACTIVITY -> BRX-ACTIVITY
BRX-BURDEN-CD
BRX-BURDEN-TYPE
BRX-POOL-NBR
BRX-EFFECTIVE-DATE
Acbrdndtl ACBRDNDTL
ACV-ACTIVITY-GRP -> BRD-ACTIVITY-GRP
ACV-ACTIVITY -> BRD-ACTIVITY
BRD-ACCT-CATEGORY
BRD-BURDEN-CD
BRD-POOL-NBR
Acbudhdr ACBUDHDR
ACV-ACTIVITY-GRP -> BDH-ACTIVITY-GRP
ACV-ACTIVITY -> BDH-ACTIVITY
BDH-BUDGET-NBR
Accatsum ACCATSUM
ACV-STRUCTURE -> SRS-STRUCTURE
SRS-SUM-ACCT-CAT
Accatsumx ACCATSUMX
ACV-STRUCTURE -> SRX-STRUCTURE
SRX-ACCT-CATEGORY
Acceilingx ACCEILINGX
ACV-ACTIVITY -> CEX-ACTIVITY
CEX-ACCT-CATEGORY
CEX-SUM-ACCT-CAT
CEX-CTR-CAT-GRP
CEX-MATRIX-CAT
CEX-MX-VALUE
Acchgord All ACCHGORDER
ACV-ACTIVITY-GRP -> CHO-ACTIVITY-GRP
ACV-ACTIVITY -> CHO-ACTIVITY
CHO-BUDGET-NBR
CHO-CHG-ORDER-NBR
Acchgorder ACCHGORDER
ACV-ACTIVITY-GRP -> CHO-ACTIVITY-GRP
ACV-ACTIVITY -> CHO-ACTIVITY
ACV-ACTIVE-BUD -> CHO-BUDGET-NBR
CHO-CHG-ORDER-NBR
Accntractx ACCNTRACTX
ACV-ACTIVITY -> CNX-ACTIVITY
CNX-CONTRACT
Accommit ACCOMMIT
ACV-ACTIVITY-GRP -> MIT-ACTIVITY-GRP
ACV-ACTIVITY -> MIT-ACTIVITY
MIT-ACCT-CATEGORY
MIT-FISCAL-YEAR
MIT-PERIOD
MIT-SYSTEM
MIT-COMPANY
MIT-CURRENCY-CODE
Acconsol ACCONSOL
ACV-ACTIVITY-GRP -> CSL-ACTIVITY-GRP
ACV-ACTIVITY -> CSL-ACTIVITY
AGP-CURRENCY-CODE -> CSL-CURRENCY-CODE
Zeroes -> CSL-BUDGET-NBR
CSL-ACCT-CATEGORY
CSL-FISCAL-YEAR
Accuamt Allbud ACCUAMT
ACV-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
ACV-ACTIVITY -> ACU-ACTIVITY
ACU-CURRENCY-CODE
ACU-BUDGET-NBR
ACU-ACCT-CATEGORY
ACU-FISCAL-YEAR
Acempexpx ACEMPEXPX
ACV-ACTIVITY-GRP -> AEA-ACTIVITY-GRP
ACV-ACTIVITY -> AEA-ACTIVITY
AEA-ACCT-CATEGORY
AEA-EXPENSE-CODE
Acempexpx Grp ACEMPEXPX
ACV-ACTIVITY-GRP -> AEA-ACTIVITY-GRP
Spaces -> AEA-ACTIVITY
AEA-ACCT-CATEGORY
AEA-EXPENSE-CODE
Acglacct ACGLACCT
ACV-ACTIVITY-GRP -> AGA-ACTIVITY-GRP
ACV-ACTIVITY -> AGA-ACTIVITY
AGA-ACCT-CATEGORY
AGA-SEQ-NUMBER
Acglacct All ACGLACCT
ACV-ACTIVITY-GRP -> AGA-ACTIVITY-GRP
Spaces -> AGA-ACTIVITY
AGA-ACCT-CATEGORY
AGA-SEQ-NUMBER
Acglconsl ACGLCONSL
ACV-ACTIVITY-GRP -> GCO-ACTIVITY-GRP
ACV-ACTIVITY -> GCO-ACTIVITY
GCO-ACCT-CATEGORY
GCO-COMPANY
GCO-ACCT-UNIT
GCO-RESOURCE-TYPE
GCO-RESOURCE-COMP
GCO-RESOURCE-CODE
GCO-FISCAL-YEAR
Acglmast ACGLMAST
ACV-ACTIVITY-GRP -> GMT-ACTIVITY-GRP
ACV-ACTIVITY -> GMT-ACTIVITY
GMT-ACCT-CATEGORY
GMT-COMPANY
GMT-ACCT-UNIT
GMT-FISCAL-YEAR
GMT-RESOURCE-TYPE
GMT-RESOURCE-COMP
GMT-RESOURCE-CODE
Acgltotrev ACGLTOTREV
ACV-ACTIVITY -> GRV-ACTIVITY
GRV-ACCT-CATEGORY
GRV-COMPANY
GRV-ACCT-UNIT
Achistory ACHISTORY
ACV-ACTIVITY -> HST-ACTIVITY
HST-FIELD-ID
HST-DATE-STAMP
HST-SEQ-NBR
Acmaster ACMASTER
ACV-ACTIVITY-GRP -> MST-ACTIVITY-GRP
ACV-ACTIVITY -> MST-ACTIVITY
MST-ACCT-CATEGORY
MST-FISCAL-YEAR
Acmilestn ACMILESTN
ACV-ACTIVITY -> MLS-ACTIVITY
MLS-MILESTONE-CAT
Acmilestnx ACMILESTNX
ACV-ACTIVITY -> MLX-ACTIVITY
MLX-MILESTONE-CAT
MLX-MILESTONE
Acperccmpl ACPERCCMPL
ACV-ACTIVITY -> PEC-ACTIVITY
PEC-RECORD-TYPE
PEC-BUDGET-TYPE
PEC-DATE
Acpercmplx ACPERCMPLX
ACV-ACTIVITY -> PEX-ACTIVITY
PEX-RECORD-TYPE
PEX-BUDGET-TYPE
PEX-ACCT-CATEGORY
PEX-DATE
Acprdperf ACPRDPERF
ACV-ACTIVITY-GRP -> PFM-ACTIVITY-GRP
ACV-ACTIVITY -> PFM-ACTIVITY
PFM-SYSTEM
PFM-SEQ-NUMBER
Acreshist ACRESHIST
ACV-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
ACV-ACTIVITY -> RSH-ACTIVITY
RSH-RESOURCE-TYPE
RSH-RESOURCE-CODE
RSH-COMPANY
RSH-ROLE
RSH-FIELD-ID
RSH-SEQ-NUMBER
Acretain ACRETAIN
ACV-ACTIVITY -> RET-ACTIVITY
RET-RETAIN-ID
Acretng ACRETNG
ACV-ACTIVITY -> RTG-ACTIVITY
RTG-SUM-ACCT-CAT
RTG-CTR-CAT-GRP
RTG-ACCT-CATEGORY
Actotbal Base ACTOTBAL
ACV-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
ACV-ACTIVITY -> TOT-ACTIVITY
AGP-CURRENCY-CODE -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR
TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
Actotbal Cur1 ACTOTBAL
ACV-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
ACV-ACTIVITY -> TOT-ACTIVITY
AGP-CURR-CODE-1 -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR
TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
Actotbal Cur2 ACTOTBAL
ACV-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
ACV-ACTIVITY -> TOT-ACTIVITY
AGP-CURR-CODE-2 -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR
TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
Actrans Commit ACTRANS
ACV-ACTIVITY-GRP -> ATN-ACTIVITY-GRP
ACV-ACTIVITY -> ATN-ACTIVITY
ATN-ACCT-CATEGORY
ATN-POSTING-DATE
ATN-OBJ-ID
Actrans Error ACTRANS
ACV-ACTIVITY-GRP -> ATN-ACTIVITY-GRP
ACV-ACTIVITY -> ATN-ACTIVITY
ATN-ACCT-CATEGORY
ATN-POSTING-DATE
ATN-OBJ-ID
Actrans Hist ACTRANS
ACV-ACTIVITY -> ATN-ACTIVITY
ATN-ACCT-CATEGORY
ATN-FISCAL-YEAR
ATN-PERIOD
ATN-OBJ-ID
Actrans Posted ACTRANS
ACV-ACTIVITY -> ATN-ACTIVITY
ATN-ACCT-CATEGORY
ATN-FISCAL-YEAR
ATN-PERIOD
ATN-OBJ-ID
Actrans Releas ACTRANS
ACV-ACTIVITY-GRP -> ATN-ACTIVITY-GRP
ACV-ACTIVITY -> ATN-ACTIVITY
ATN-ACCT-CATEGORY
ATN-POSTING-DATE
ATN-OBJ-ID
Acu Act Curr ACCUAMT
ACV-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
ACV-ACTIVITY -> ACU-ACTIVITY
ACV-CURRENCY-CODE -> ACU-CURRENCY-CODE
Zeroes -> ACU-BUDGET-NBR
ACU-FISCAL-YEAR
ACU-ACCT-CATEGORY
Acu Rpt Curr 1 ACCUAMT
ACV-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
ACV-ACTIVITY -> ACU-ACTIVITY
AGP-CURR-CODE-1 -> ACU-CURRENCY-CODE
Zeroes -> ACU-BUDGET-NBR
ACU-FISCAL-YEAR
ACU-ACCT-CATEGORY
Acu Rpt Curr 2 ACCUAMT
ACV-ACTIVITY-GRP -> ACU-ACTIVITY-GRP
ACV-ACTIVITY -> ACU-ACTIVITY
AGP-CURR-CODE-2 -> ACU-CURRENCY-CODE
Zeroes -> ACU-BUDGET-NBR
ACU-FISCAL-YEAR
ACU-ACCT-CATEGORY
Atnset4 ACTRANS
ACV-ACTIVITY -> ATN-ACTIVITY
ATN-ACCT-CATEGORY
ATN-FISCAL-YEAR
ATN-PERIOD
ATN-OBJ-ID
Billable ACTRANS
ACV-ACTIVITY -> ATN-ACTIVITY
ATN-ACCT-CATEGORY
ATN-TRAN-CURRENCY
ATN-UNIT-MEASURE
ATN-MATRIX-CAT
ATN-MX-VALUE
ATN-POSTING-DATE
ATN-OBJ-ID
Children ACACTIVITY
ACV-ACTIVITY -> ACV-PARENT-ACTV
ACV-ACTIVITY
Csl Bud Base ACCONSOL
ACV-ACTIVITY-GRP -> CSL-ACTIVITY-GRP
ACV-ACTIVITY -> CSL-ACTIVITY
AGP-CURRENCY-CODE -> CSL-CURRENCY-CODE
CSL-BUDGET-NBR
CSL-ACCT-CATEGORY
CSL-FISCAL-YEAR
Csl Bud Rpt 1 ACCONSOL
ACV-ACTIVITY-GRP -> CSL-ACTIVITY-GRP
ACV-ACTIVITY -> CSL-ACTIVITY
AGP-CURR-CODE-1 -> CSL-CURRENCY-CODE
CSL-BUDGET-NBR
CSL-ACCT-CATEGORY
CSL-FISCAL-YEAR
Csl Bud Rpt 2 ACCONSOL
ACV-ACTIVITY-GRP -> CSL-ACTIVITY-GRP
ACV-ACTIVITY -> CSL-ACTIVITY
AGP-CURR-CODE-2 -> CSL-CURRENCY-CODE
CSL-BUDGET-NBR
CSL-ACCT-CATEGORY
CSL-FISCAL-YEAR
Csl Cur1 ACCONSOL
ACV-ACTIVITY-GRP -> CSL-ACTIVITY-GRP
ACV-ACTIVITY -> CSL-ACTIVITY
AGP-CURR-CODE-1 -> CSL-CURRENCY-CODE
Zeroes -> CSL-BUDGET-NBR
CSL-ACCT-CATEGORY
CSL-FISCAL-YEAR
Csl Cur2 ACCONSOL
ACV-ACTIVITY-GRP -> CSL-ACTIVITY-GRP
ACV-ACTIVITY -> CSL-ACTIVITY
AGP-CURR-CODE-2 -> CSL-CURRENCY-CODE
Zeroes -> CSL-BUDGET-NBR
CSL-ACCT-CATEGORY
CSL-FISCAL-YEAR
Gmcostshr GMCOSTSHR
ACV-ACTIVITY -> GMO-ACTIVITY
GMO-CS-ACTIVITY
Gmdeliv GMDELIV
ACV-ACTIVITY -> GLV-ACTIVITY
GLV-DELIV-CODE-DE
Gmlabdistx GMLABDISTX
ACV-ACTIVITY -> GMA-ACTIVITY
GMA-ACCT-CATEGORY
GMA-COMPANY
GMA-ACCT-UNIT
GMA-ACCOUNT
GMA-EFFECT-DATE
GMA-GML-OBJ-ID
GMA-OBJ-ID
Gmpgminc GMPGMINC
ACV-ACTIVITY -> GMQ-ACTIVITY
GMQ-PI-ACTIVITY
Gmprotocol GMPROTOCOL
ACV-ACTIVITY -> GMM-ACTIVITY
GMM-PROT-CODE-PC
GMM-PROTOCOL-NBR
GMM-EXPIRE-DATE
Gmretdistx GMRETDISTX
ACV-ACTIVITY -> GMH-ACTIVITY
GMH-ACCT-CATEGORY
GMH-COMPANY
GMH-ACCT-UNIT
GMH-ACCOUNT
GMH-SUB-ACCOUNT
GMH-GMI-OBJ-ID
GMH-OBJ-ID
Gmtranefrt GMTRANEFRT
ACV-ACTIVITY -> GEF-ACTIVITY
GEF-ACCT-CATEGORY
GEF-OBJ-ID
Histastasgn ACRESHIST
ACV-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
ACV-ACTIVITY -> RSH-ACTIVITY
"A" -> RSH-RESOURCE-TYPE
440 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histastrole ACRESHIST
ACV-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
ACV-ACTIVITY -> RSH-ACTIVITY
"A" -> RSH-RESOURCE-TYPE
441 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histempasgn ACRESHIST
ACV-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
ACV-ACTIVITY -> RSH-ACTIVITY
"E" -> RSH-RESOURCE-TYPE
420 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histemprole ACRESHIST
ACV-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
ACV-ACTIVITY -> RSH-ACTIVITY
"E" -> RSH-RESOURCE-TYPE
421 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histeqpasgn ACRESHIST
ACV-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
ACV-ACTIVITY -> RSH-ACTIVITY
"Q" -> RSH-RESOURCE-TYPE
450 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histeqprole ACRESHIST
ACV-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
ACV-ACTIVITY -> RSH-ACTIVITY
"Q" -> RSH-RESOURCE-TYPE
451 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histperasgn ACRESHIST
ACV-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
ACV-ACTIVITY -> RSH-ACTIVITY
"P" -> RSH-RESOURCE-TYPE
410 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histperrole ACRESHIST
ACV-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
ACV-ACTIVITY -> RSH-ACTIVITY
"P" -> RSH-RESOURCE-TYPE
411 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histvenasgn ACRESHIST
ACV-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
ACV-ACTIVITY -> RSH-ACTIVITY
"V" -> RSH-RESOURCE-TYPE
430 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histvenrole ACRESHIST
ACV-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
ACV-ACTIVITY -> RSH-ACTIVITY
"V" -> RSH-RESOURCE-TYPE
431 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Member In List MXLISTMBR
"ACTVY" -> MLM-OBJ-TYPE
ACV-OBJ-ID -> MLM-OBJ-ID
MLM-MATRIX-LIST
Mxlisthdr MXLISTHDR
"ACTVY" -> MLH-OBJ-TYPE
MLH-MATRIX-LIST
Pr Accommit ACCOMMIT
ACV-ACTIVITY-GRP -> MIT-ACTIVITY-GRP
ACV-ACTIVITY -> MIT-ACTIVITY
"PR" -> MIT-SYSTEM
MIT-COMPANY
MIT-CURRENCY-CODE
MIT-ACCT-CATEGORY
MIT-FISCAL-YEAR
MIT-PERIOD
Tot Child Base ACTOTBAL
ACV-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
ACV-ACTIVITY -> TOT-PARENT-ACTV
AGP-CURRENCY-CODE -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR
TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
TOT-ACTIVITY
Tot Child Cur1 ACTOTBAL
ACV-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
ACV-ACTIVITY -> TOT-PARENT-ACTV
AGP-CURR-CODE-1 -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR
TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
TOT-ACTIVITY
Tot Child Cur2 ACTOTBAL
ACV-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
ACV-ACTIVITY -> TOT-PARENT-ACTV
AGP-CURR-CODE-2 -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR
TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
TOT-ACTIVITY
Tot Parnt Base ACTOTBAL
ACV-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
ACV-PARENT-ACTV -> TOT-ACTIVITY
AGP-CURRENCY-CODE -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR
TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
Tot Parnt Cur1 ACTOTBAL
ACV-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
ACV-PARENT-ACTV -> TOT-ACTIVITY
AGP-CURR-CODE-1 -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR
TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
Tot Parnt Cur2 ACTOTBAL
ACV-ACTIVITY-GRP -> TOT-ACTIVITY-GRP
ACV-PARENT-ACTV -> TOT-ACTIVITY
AGP-CURR-CODE-2 -> TOT-CURRENCY-CODE
TOT-BUDGET-NBR
TOT-CATEGORY-TYPE
TOT-FISCAL-YEAR
|