|
|
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 AC135 AC145 AC160
AC165 AC190 AC191 AC197 AC198 AC200
AC203 AC206 AC207 AC210 AC213 AC218
AC220 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
AC54.1 AC540 ACAC.1 ACBA.1 AP211 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 BR130
BR131 BR140 BR142 BR145 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 BR265
BR300 BR40.3 BR40.4 BR400 BR405 BR41.1
BR41.4 BR420 BR430 BR450 BR46.1 BR46.2
BR46.4 BR521 BR530 BR580 BR96.1
UPDATED BY
AC50.1 AC500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIV-RUN-GROUP Alpha 15 AC50.1
Element: Run Group Required. This is the run group for the
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
Element: Activity This is the new, or Lawson, activity.
Either this field or the Old Activity
field is required.
AIV-DESCRIPTION Alpha 30 (Lower Case) AC50.1
Element: Description This is the activity description.
AIV-ACTIVITY-GRP Alpha 15 AC50.1
Element: Activity GroupThe activity group is the overall
project.
AIV-OLD-ACT-GRP Alpha 35 AC50.1
Element: Old Activity GThis is the old, or non-Lawson, project
or activity group. Required.
AIV-COMPANY Numeric 4 AC50.1
Element: Company Required. This is the company for the
imported activity.
AIV-ACCT-UNIT Alpha 15 AC50.1
Element: Accounting UniThis is the accounting unit for the
imported activity.
AIV-ACCOUNT Numeric 6 AC50.1
Element: Account This is the account for the imported
activity.
AIV-SUB-ACCT Numeric 4 AC50.1
Element: Subaccount This is the subaccount for the imported
activity.
AIV-ACCT-CATEGORY Alpha 5 AC50.1
Element: Account CategoThis is the account category for the
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
Element: Usr Status Required. This is the status of the
imported activity.
AIV-LEVEL-ONE Numeric 15 AC50.1
Element: Level Detail Required. Levels define an addressing
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
Element: Level Detail Required. Levels define an addressing
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
Element: Level Detail Required. Levels define an addressing
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
Element: Level Detail Required. Levels define an addressing
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
Element: Level Detail Required. Levels define an addressing
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
activity. If left blank, AC500
(Activity Import) will default the
values from the activity group date
range.
AIV-END-DATE Numeric 8 (yyyymmdd) AC50.1 AC500
Element: Ending Date This is the ending date for the
activity.
AIV-LONG-DESC Alpha 60 (Lower Case) AC50.1
Element: Long DescriptiThis is the long description of the
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
Element: Billable IndicThis field indicates whether the
activity is billable. The default is
"N".
AIV-POSTING-FLAG Alpha 1 AC50.1
Element: Posting Flag Required. This field indicates whether
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: Address DescriThis 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
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
(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: Accounting UniThis 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: Subaccount This is the subaccount for the default
expense account.
AIV-MATRIX-CAT-11 Alpha 12 AC50.1
Element: Matrix Cat 11
AIV-MX-VALUE-11 Alpha 32 AC50.1
Element: Mx Value 11
AIV-MATRIX-CAT-1 Alpha 12 AC50.1
Element: Attribute This is the first attribute to import.
AIV-MX-VALUE-1 Alpha 32 AC50.1
Element: Attribute ValuThis is the first attribute value to
import.
AIV-MATRIX-CAT-2 Alpha 12 AC50.1
Element: Attribute This is the second attribute to import.
AIV-MX-VALUE-2 Alpha 32 AC50.1
Element: Attribute ValuThis is the second attribute value to
import.
AIV-MATRIX-CAT-3 Alpha 12 AC50.1
Element: Attribute This is the third attribute to import.
AIV-MX-VALUE-3 Alpha 32 AC50.1
Element: Attribute ValuThis is the third attribute value to
import.
AIV-MATRIX-CAT-4 Alpha 12 AC50.1
Element: Attribute This is the fourth attribute to import.
AIV-MX-VALUE-4 Alpha 32 AC50.1
Element: Attribute ValuThis is the fourth attribute value to
import.
AIV-MATRIX-CAT-5 Alpha 12 AC50.1
Element: Attribute This is the fifth attribute to import.
AIV-MX-VALUE-5 Alpha 32 AC50.1
Element: Attribute ValuThis is the fifth attribute value to
import.
AIV-MATRIX-CAT-6 Alpha 12 AC50.1
Element: Attribute This is the sixth attribute to import.
AIV-MX-VALUE-6 Alpha 32 AC50.1
Element: Attribute ValuThis is the sixth attribute value to
import.
AIV-MATRIX-CAT-7 Alpha 12 AC50.1
Element: Attribute This is the seventh attribute to
import.
AIV-MX-VALUE-7 Alpha 32 AC50.1
Element: Attribute ValuThis is the seventh attribute value to
import.
AIV-MATRIX-CAT-8 Alpha 12 AC50.1
Element: Attribute This is the eighth attribute to import.
AIV-MX-VALUE-8 Alpha 32 AC50.1
Element: Attribute ValuThis is the eighth attribute value to
import.
AIV-MATRIX-CAT-9 Alpha 12 AC50.1
Element: Attribute This is the ninth attribute to import.
AIV-MX-VALUE-9 Alpha 32 AC50.1
Element: Attribute ValuThis is the ninth attribute value to
import.
AIV-MATRIX-CAT-10 Alpha 12 AC50.1
Element: Attribute This is the tenth attribute to import.
AIV-MX-VALUE-10 Alpha 32 AC50.1
Element: Attribute ValuThis is the tenth attribute value to
import.
AIV-SEGMENT-BLOCK Alpha 103 AC50.1
Element: User Analysis 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
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
AIV-OUTPUT-MEASURE Signed 18.2 AC50.1
Element: Intl Amt Use this field to enter units of amount
produced by the activity. For example,
if an activity is tracking the cost of
training service consultants, the output
measure is the number of full-time
training equivalents (FTEs). Using this
field, along with the total activity
costs, you can determine the cost per
FTE.
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: Status The status of the rate assignment for a
resouce.
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 AC50.1
Element: Intl Amt Salary cap amount.
AIV-FRNG-RATE Signed 14.7 AC50.1
Element: Currency Rate A default fringe rate that can be sued
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.
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.
ACIFACTV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIVSET1 RUN-GROUP AC50.1 AC500
OLD-ACTIVITY
ACTIVITY
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 AC135
LEVEL-FOUR AC145 AC160
LEVEL-FIVE AC165 AC190
AC191 AC197
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC246 AC261
AC265 AC290
...
|
