|
|
ACIFACTV FILE
This file contains activity import information from AC500 (Activity Import).
REFERENCED BY
AC10.1 AC10.5 AC110 AC112 AC113 AC12.1
AC120 AC121 AC123 AC128 AC135 AC145
AC160 AC165 AC169 AC190 AC191 AC197
AC198 AC200 AC203 AC206 AC207 AC210
AC213 AC218 AC220 AC225 AC240 AC246
AC261 AC265 AC290 AC295 AC298 AC346
AC40.1 AC40.4 AC400 AC401 AC41.1 AC41.4
AC410 AC412 AC42.1 AC420 AC421 AC440
AC45.1 AC460 AC471 AC472 AC473 AC480
AC490 AC493 AC494 AC527 AC54.1 AC540
AC56.1 AC560 AC90.1 AC90.2 AC90.4 AC90.6
AC90.8 AC92.1 AC92.2 AC92.4 AC92.6 AC93.4
AC93.5 AC94.1 AC94.2 AC94.4 AC94.6 AC95.1
AC95.2 AC95.4 AC95.6 ACAC.1 ACBA.1 AP211
AR237 AR239 AR257 AR296 AR32.1 BR00.1
BR00.2 BR00.3 BR01.1 BR01.2 BR02.1 BR02.3
BR03.1 BR03.2 BR03.3 BR05.2 BR05.3 BR05.4
BR05.5 BR10.1 BR120 BR121 BR122 BR123
BR130 BR131 BR140 BR142 BR145 BR151
BR152 BR153 BR154 BR155 BR156 BR157
BR165 BR19.1 BR190 BR20.1 BR20.2 BR20.3
BR20.4 BR20.5 BR20.6 BR200 BR202 BR204
BR205 BR206 BR210 BR212 BR215 BR220
BR245 BR251 BR252 BR253 BR265 BR300
BR40.3 BR40.4 BR400 BR405 BR41.1 BR41.4
BR42.1 BR420 BR422 BR430 BR450 BR46.1
BR46.2 BR46.4 BR52.2 BR52.4 BR52.5 BR521
BR530 BR54.2 BR54.3 BR54.4 BR580 BR96.1
ET175 ET540 ET542
UPDATED BY
AC50.1 AC500 PW110 PW510 PW90.1 PWI2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIV-RUN-GROUP Alpha 15 AC50.1 PW90.1
Element: Run Group Required. This is the run group for the PWI2.1
import of non-Lawson activity or project
information.
AIV-OLD-ACTIVITY Alpha 35 AC50.1
Element: Old Activity This is the old, or non-Lawson
activity. Either this field or the
Activity field is required.
If you enter an Old Activity and leave
the Activity field blank, you must
define a relationship in AC29.1
(Activity Relationship).
If you enter both the Old Activity and
Activity the AC500 will define the
relationship in AC29 for you.
AIV-ACTIVITY Alpha 15 AC50.1 PW90.1
Element: Activity This is the new, or Lawson, activity. PWI2.1
Either this field or the Old Activity
field is required.
AIV-DESCRIPTION Alpha 30 (Lower Case) AC50.1 PW90.1
Element: Description This is the activity description. PWI2.1
AIV-ACTIVITY-GRP Alpha 15 AC50.1 PW90.1
Element: Activity Grp The activity group is the overall PWI2.1
project.
AIV-OLD-ACT-GRP Alpha 35 AC50.1
Element: Old Act Grp This is the old, or non-Lawson, project
or activity group. Required.
AIV-COMPANY Numeric 4 AC50.1 PW90.1
Element: Company Required. This is the company for the PWI2.1
imported activity.
AIV-ACCT-UNIT Alpha 15 AC50.1 PW90.1
Element: Acct Unit This is the accounting unit for the PWI2.1
imported activity.
AIV-ACCOUNT Numeric 6 AC50.1 PW90.1
Element: Account This is the account for the imported PWI2.1
activity.
AIV-SUB-ACCT Numeric 4 AC50.1 PW90.1
Element: Sub Acct This is the subaccount for the imported PWI2.1
activity.
AIV-ACCT-CATEGORY Alpha 5 AC50.1 PW90.1
Element: Acct Category This is the account category for the PWI2.1
imported activity.
You can enter an account category that
is assigned to the activity group in the
AC06.1 (Account Category Assignment). If
you plan to do assignments by activity,
leave this field blank.
AIV-USR-STATUS Alpha 2 AC50.1 PW90.1
Element: Usr Status Required. This is the status of the PWI2.1
imported activity.
AIV-LEVEL-ONE Numeric 15 AC50.1 PW90.1
Element: Level Detail Required. Levels define an addressing PWI2.1
system that organizes activities into a
reporting hierarchy. Levels facilitate
rollup or consolidation of budgets,
costs, and revenues from activities at
lower levels to activities at a higher
level within the hierarchy. This is the
first level.
AIV-LEVEL-TWO Numeric 15 AC50.1 PW90.1
Element: Level Detail Required. Levels define an addressing PWI2.1
system that organizes activities into a
reporting hierarchy. Levels facilitate
rollup or consolidation of budgets,
costs, and revenues from activities at
lower levels to activities at a higher
level within the hierarchy. This is the
second level.
AIV-LEVEL-THREE Numeric 15 AC50.1 PW90.1
Element: Level Detail Required. Levels define an addressing PWI2.1
system that organizes activities into a
reporting hierarchy. Levels facilitate
rollup or consolidation of budgets,
costs, and revenues from activities at
lower levels to activities at a higher
level within the hierarchy. This is the
third level.
AIV-LEVEL-FOUR Numeric 15 AC50.1 PW90.1
Element: Level Detail Required. Levels define an addressing PWI2.1
system that organizes activities into a
reporting hierarchy. Levels facilitate
rollup or consolidation of budgets,
costs, and revenues from activities at
lower levels to activities at a higher
level within the hierarchy. This is the
fourth level.
AIV-LEVEL-FIVE Numeric 15 AC50.1 PW90.1
Element: Level Detail Required. Levels define an addressing PWI2.1
system that organizes activities into a
reporting hierarchy. Levels facilitate
rollup or consolidation of budgets,
costs, and revenues from activities at
lower levels to activities at a higher
level within the hierarchy. This is the
fifth level.
AIV-BEGIN-DATE Numeric 8 (yyyymmdd) AC50.1 AC500
Element: Begin Date This is the beginning date for the PW110 PW510
activity. If left blank, AC500 PWI2.1
(Activity Import) will default the
values from the activity group date
range.
AIV-END-DATE Numeric 8 (yyyymmdd) AC50.1 AC500
Element: End Date This is the ending date for the PW110 PW510
activity. PWI2.1
AIV-LONG-DESC Alpha 60 (Lower Case) AC50.1 PW90.1
Element: Long Desc This is the long description of the PWI2.1
activity. If left blank, AC500 (Activity
Import) will default the short
description.
AIV-ESTIMATE Signed 18.2 AC50.1
Element: Intl Amt This is the estimated amount for the
activity.
AIV-BILLABLE-FLAG Alpha 1 AC50.1 PW90.1
Element: Billable This field indicates whether the PWI2.1
activity is billable. The default is
"N".
AIV-POSTING-FLAG Alpha 1 AC50.1 PW90.1
Element: Posting Flag Required. This field indicates whether PWI2.1
the activity is a posting-level
activity. Use P for posting level and S
for summary level.
AIV-ADDRESS-CODE Alpha 9 AC50.1
Element: Address Code This is the address code for the new
activity. Address codes are defined in
AC10.4 (Location).
AIV-ADDR-DESC Alpha 30 AC50.1
Element: Addr Desc This is the address description.
AIV-RESOURCE-TYPE Alpha 1 AC50.1
Element: Resource Type This is the type for the activity
resource, it can be used to import a
manager for the activity.
This field is required if you enter a
resource employee.
Valid values are Human Resource
Employee (H), Activity Management Person
(P), or Accounts Payable Vendor (V).
AIV-RES-COMPANY Numeric 4 AC50.1
Element: Company This is the company for the activity
resource. Required for resource types
"H" and "V".
AIV-RES-EMPLOYEE Alpha 10 AC50.1 AC500
Element: Res Employee Required if the resource type is not PW110 PW510
blank. Enter the HR Employee number
(numeric 9), the AP vendor number (alpha
9), or the AC person code (alpha 10).
AIV-RES-DESC Alpha 30 AC50.1 AC500
Element: Res Desc If blank and a resource is used, AC500 PW110 PW510
(Activity Import) will default the
description from the AP vendor, HR
employee, or AC person.
AIV-STD-RATE Signed 13.5 AC50.1
Element: Std Rate This is the standard rate for the
resource.
AIV-UNIT-MEASURE Alpha 12 AC50.1
Element: Unit Measure This is the unit of measure code for
the resource. This field is required if
you enter a standard rate.
AIV-RES-TO-COMP Numeric 4 AC50.1
Element: Company This is the post-to company for the
default expense account.
AIV-RES-ACCT-UNIT Alpha 15 AC50.1
Element: Acct Unit This is the accounting unit for the
default expense account.
AIV-RES-ACCOUNT Numeric 6 AC50.1
Element: Account This is the account for the default
expense account.
AIV-RES-SUB-ACCT Numeric 4 AC50.1
Element: Sub Acct This is the subaccount for the default
expense account.
AIV-MATRIX-CAT-11 Alpha 12 AC50.1
Element: Matrix Cat 11 This is the billing category attribute
that can be associated with the manager
resource for this activity.
AIV-MX-VALUE-11 Alpha 32 AC50.1
Element: Mx Value 11 This is the value for the billing
category attribute associated with the
manager resource for this activity.
AIV-MATRIX-CAT-1 Alpha 12 AC50.1 PW90.1
Element: Matrix Cat This is the first attribute to import.
AIV-MX-VALUE-1 Alpha 32 AC50.1 PW90.1
Element: Mx Value 1 This is the first attribute value to
import.
AIV-MATRIX-CAT-2 Alpha 12 AC50.1 PW90.1
Element: Matrix Cat This is the second attribute to import.
AIV-MX-VALUE-2 Alpha 32 AC50.1 PW90.1
Element: Mx Value 2 This is the second attribute value to
import.
AIV-MATRIX-CAT-3 Alpha 12 AC50.1 PW90.1
Element: Matrix Cat This is the third attribute to import.
AIV-MX-VALUE-3 Alpha 32 AC50.1 PW90.1
Element: Mx Value This is the third attribute value to
import.
AIV-MATRIX-CAT-4 Alpha 12 AC50.1 PW90.1
Element: Matrix Cat This is the fourth attribute to import.
AIV-MX-VALUE-4 Alpha 32 AC50.1 PW90.1
Element: Mx Value This is the fourth attribute value to
import.
AIV-MATRIX-CAT-5 Alpha 12 AC50.1 PW90.1
Element: Matrix Cat This is the fifth attribute to import.
AIV-MX-VALUE-5 Alpha 32 AC50.1 PW90.1
Element: Mx Value This is the fifth attribute value to
import.
AIV-MATRIX-CAT-6 Alpha 12 AC50.1 PW90.1
Element: Matrix Cat This is the sixth attribute to import.
AIV-MX-VALUE-6 Alpha 32 AC50.1 PW90.1
Element: Mx Value This is the sixth attribute value to
import.
AIV-MATRIX-CAT-7 Alpha 12 AC50.1 PW90.1
Element: Matrix Cat This is the seventh attribute to
import.
AIV-MX-VALUE-7 Alpha 32 AC50.1 PW90.1
Element: Mx Value This is the seventh attribute value to
import.
AIV-MATRIX-CAT-8 Alpha 12 AC50.1 PW90.1
Element: Matrix Cat This is the eighth attribute to import.
AIV-MX-VALUE-8 Alpha 32 AC50.1 PW90.1
Element: Mx Value This is the eighth attribute value to
import.
AIV-MATRIX-CAT-9 Alpha 12 AC50.1 PW90.1
Element: Matrix Cat This is the ninth attribute to import.
AIV-MX-VALUE-9 Alpha 32 AC50.1 PW90.1
Element: Mx Value This is the ninth attribute value to
import.
AIV-MATRIX-CAT-10 Alpha 12 AC50.1 PW90.1
Element: Matrix Cat This is the tenth attribute to import.
AIV-MX-VALUE-10 Alpha 32 AC50.1 PW90.1
Element: Mx Value This is the tenth attribute value to
import.
AIV-SEGMENT-BLOCK Alpha 103 AC50.1
Element: Segment Block This field identifies the user analysis
values included in the transaction.
You can either type up to four values
or use Define (F6) to open the User
Analysis Entry subform. Use this subform
to select the user analysis values you
want to include in the transaction. If
you choose to type values, use commas to
separate them. For example:
value1,value2,value3,value4
There are three conditions that affect
how you can select user analysis values.
See the User Analysis Entry form help or
the Strategic Ledger procedures manual
for additional information.
AIV-CURRENCY-CODE Alpha 5 AC50.1 PW90.1
Element: Currency Code This field contains the company base PWI2.1
currency code established in Company
(GL10.1 ).
AIV-OUTPUT-MEASURE Signed 18.2 AC50.1
Element: Intl Amt
AIV-OUTPUT-DESC Alpha 30 AC50.1
Element: Output Desc This is the description of the output
measure. If you enter an output measure,
this field is required.
AIV-BILL-WBS-CODE Alpha 3 AC50.1
Element: Bill Wbs Code
AIV-RES-CURR-CODE Alpha 5 AC50.1
Element: Res Curr Code
AIV-EFFECTIVE-DATE Numeric 8 (yyyymmdd) AC50.1
Element: Effective DateThe effective date for the rate
assignment for the resource.
AIV-BILL-RATE Signed 13.4 AC50.1
Element: Bill Rate The billing rate that is set up for a
resource for a specific activity.
AIV-ACTIVE-FLAG Alpha 1 AC50.1
Element: Active Flag The status of the rate assignment for a
resource.
A = Active
I = Inactive
AIV-RESC-BEG-DATE Numeric 8 (yyyymmdd) AC50.1
Element: Date The beginning of the date range that
this resource assignment is effective
for.
AIV-RESC-END-DATE Numeric 8 (yyyymmdd) AC50.1
Element: Date The end of the date range that this
resource assignment is effective for.
AIV-AWARD-FLAG Alpha 1 AC50.1
Element: Award Flag Flag to indicate whether this activity
is an award for the GM system or a
posting level activity within an award.
Y = Yes
N = No
AIV-EFFORT-FLAG Alpha 1 AC50.1
Element: Effort Flag Flag to indicate whether this activity
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
AIV-SALARY-CAP-FL Alpha 1 AC50.1
Element: Salary Cap Fl This flag indicates whether the salary
cap applies to this grant/project. The
actual salary cap amount is stored on
the GMSALCAP record.
Y = Yes
N = No
AIV-SALARY-CAP-AMT Signed 18.2
Element: Intl Amt
AIV-FRNG-RATE Signed 14.7 AC50.1
Element: Curr Rate The currency rate.
AIV-FRNG-ACCT-CAT Alpha 5 AC50.1
Element: Frng Acct Cat A default post-to fringe account
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.
AIV-FRNG-ACCOUNT Numeric 6 AC50.1
Element: Frng Account A default post-to fringe account 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.
AIV-FRNG-SUB-ACCT Numeric 4 AC50.1
Element: Frng Sub Acct A default post-to fringe sub account
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.
AIV-STRUCTURE Alpha 15
Element: Structure The name of the category structure.
AIV-BUDGET-EDIT Alpha 1 AC50.1
Element: Budget Edit 1 = No Edit
2 = Period Edit
3 = Annual Edit
4 = Total Edit
AIV-BUDGET-LEVEL Alpha 1 AC50.1
Element: Budget Level 1 = Activity-Acct Cat
3 = Activity
4 = Activity-Summary Account Cat
AIV-BUD-TOLERANCE Signed 5.2 AC50.1
Element: Bud Tolerance
AIV-SCHEDULE Alpha 9 AC50.1
Element: Schedule A salary cap schedule is required if the
activity is subject to a salary cap
(SALARY-CAP-FL=Y).
AIV-CURRENT-CAP Alpha 1 AC50.1
Element: Flag This flag determines which salary cap
amount is used to determine salary cap
overage in labor distribution templates
and reports.
Y indicates that the most recent active
salary cap in the schedule is used.
N or blank indicates that the salary cap
amount in effect on the activity's start
date is used.
Y = Yes
N = No
AIV-CAP-ACTIVITY Alpha 15 AC50.1
Element: Activity Identifies the activity to be charged
with the salary cap overage when the
salary cap is applied to the labor
distribution template. If blank, the
salary cap overage is not charged to any
activity or account category.
AIV-CAP-ACCT-CAT Alpha 5 AC50.1
Element: Acct Category Identifies the account category to be
charged with salary cap overage when the
salary cap is applied to a labor
distribution template.
If the account category field is blank
and the activity field is polupated,
overage is charged to the account
category in the template line from which
the overage is initiated.
If the activity field is blank, no
account category can be specified.
AIV-CAP-COMPANY Numeric 4 AC50.1
Element: Company This field identifies the GL company to
be charged with the salary cap overage
when the salary cap is applied to the
labor distribution template.
If this field is blank, the overage is
charged to the GL company on the labor
distribution template from which the
overage is initiated
(GMLABDISTX.COMPANY).
AIV-CAP-ACCT-UNIT Alpha 15 AC50.1
Element: Acct Unit This field identifies the accounting
unit to charge with the salary cap
overage when a salary cap is applied to
the salary distribution template.
If this field is blank, the overage is
charged to the accounting unit on the
labor distribution template line from
which the overage was initiated
(GMLABDISTX.ACCT-UNIT).
AIV-CAP-ACCOUNT Numeric 6 AC50.1
Element: Account This field identifies the account to
charge with the salary cap overage when
a salary cap is applied to the labor
distribution template
If this field is blank, the overage is
charged to the account on the labor
distribution template line from which
the overage is initiated
(GMLABDISTX.ACCOUNT).
AIV-CAP-SUB-ACCT Numeric 4 AC50.1
Element: Sub Acct This field identifies the subaccount to
charge with the salary cap overage when
a salary cap is applied to the labor
distribution template.
If this field is blank, the overage is
charged to the subaccount on the labor
distribution template line from which
the overage is inititated
(GMLABDISTX.SUB-ACCOUNT).
AIV-CAP-SEG-BLOCK Alpha 103 AC50.1
Element: Segment Block This field identifies the SL user
analysis (if any) to charge with the
salary cap overage when a salary cap is
applied to the labor distribution
template.
This field determines whether the salary
cap overage should be posted to the
Strategic Ledger; if overage user
analysis values are populated the
ACV-CAP-SEG-FLAG flag is set to Y and
user analysis values for overage are
stored in the ACACTSEG file. If the
overages user analysis values are blank,
the overage is charged to the user
analysis (if any) on the labor
distribution teamplate line from which
the overage is intitiated.
(GMLABDISTX.SEGMENT=N and values come
from the GMGMASEG file.)
ACIFACTV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIVSET1 RUN-GROUP AC50.1 AC500
OLD-ACTIVITY PW110 PW510
ACTIVITY PW90.1 PWI2.1
AIVSET2 RUN-GROUP KeyChange, Subset AC10.1 AC10.5
ACTIVITY-GRP Where LEVEL-ONE != Zeroes AC110 AC112
LEVEL-ONE AC113 AC12.1
LEVEL-TWO AC120 AC121
LEVEL-THREE AC123 AC128
LEVEL-FOUR AC135 AC145
LEVEL-FIVE AC160 AC165
AC169 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC225
AC240 AC246
...
|
