ACIFACTV FILE
This file contains activity import information from AC500 (Activity Import).
REFERENCED BY
AC10.1 AC110 AC170 AC190 AC198 AC40.1
AC40.4 AC41.1 AC41.4 AC42.1 AC530 AC54.1
AC540 AC541 AC551 AC70.1 AC70.4 AC741
ACBA.1 GR741 BR00.1 BR00.2 BR00.3 BR02.3
BR03.1 BR03.2 BR03.3 BR120 BR121 BR200
BR202 BR220 BR40.3 BR41.1 BR420 BR450
UPDATED BY
AC50.1 AC500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIV-RUN-GRP Alpha 10 AC50.1
Run Grp
AIV-OLD-ACTIVITY Alpha 35 AC50.1
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
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
Description This is the activity description.
AIV-ACTIVITY-GRP Alpha 15 AC50.1
Activity Group
AIV-OLD-ACT-GRP Alpha 35 AC50.1
Old Activity Group This is the old, or non-Lawson, project
or activity group. Required.
AIV-COMPANY Numeric 4 AC50.1
Company Required. This is the company for the
imported activity.
AIV-ACCT-UNIT Alpha 15 AC50.1
Accounting Unit This is the accounting unit for the
imported activity.
AIV-ACCOUNT Numeric 6 AC50.1
Account This is the account for the imported
activity.
AIV-SUB-ACCT Numeric 4 AC50.1
Subaccount This is the subaccount for the imported
activity.
AIV-ACCT-CATEGORY Alpha 5 AC50.1
Account Category This 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
Usr Status Required. This is the status of the
imported activity.
AIV-LEVEL-ONE Numeric 15 AC50.1
Level 1 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
Level 2 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
Level 3 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
Level 4 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
Level 5 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
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
Ending Date This is the ending date for the
activity.
AIV-LONG-DESC Alpha 60 (Lower Case) AC50.1
Long Description This is the long description of the
activity. If left blank, AC500 (Activity
Import) will default the short
description.
AIV-ESTIMATE Signed 15.2 AC50.1
Estimate This is the estimated amount for the
activity.
AIV-BILLABLE-FLAG Alpha 1 AC50.1
Billable Flag This field indicates whether the
activity is billable. The default is
"N".
AIV-POSTING-FLAG Alpha 1 AC50.1
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
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
Address Description This is the address description.
AIV-RESOURCE-TYPE Alpha 1 AC50.1
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
Res Company This is the company for the activity
resource. Required for resource types
"H" and "V".
AIV-RES-EMPLOYEE Alpha 10 AC50.1 AC500
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
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
Std Rate This is the standard rate for the
resource.
AIV-UNIT-MEASURE Alpha 12 AC50.1
Unit Measure This is the unit of measure code for
the resource. This field is required if
you enter a standard rate.
AIV-RESOURCE-CLASS Alpha 3 AC50.1
Resource Class This is the resource class for the
activity resource.
AIV-RES-TO-COMP Numeric 4 AC50.1
Res To Comp This is the post-to company for the
default expense account.
AIV-RES-ACCT-UNIT Alpha 15 AC50.1
Res Acct Unit This is the accounting unit for the
default expense account.
AIV-RES-ACCOUNT Numeric 6 AC50.1
Res Account This is the account for the default
expense account.
AIV-RES-SUB-ACCT Numeric 4 AC50.1
Res Sub Acct This is the subaccount for the default
expense account.
AIV-MATRIX-CAT-1 Alpha 12 AC50.1
Attribute 1 This is the first attribute to import.
AIV-MX-VALUE-1 Alpha 32 AC50.1
Attribute Value This is the first attribute value to
import.
AIV-MATRIX-CAT-2 Alpha 12 AC50.1
Attribute 2 This is the second attribute to import.
AIV-MX-VALUE-2 Alpha 32 AC50.1
Attribute Value This is the second attribute value to
import.
AIV-MATRIX-CAT-3 Alpha 12 AC50.1
Attribute 3 This is the third attribute to import.
AIV-MX-VALUE-3 Alpha 32 AC50.1
Attribute Value This is the third attribute value to
import.
AIV-MATRIX-CAT-4 Alpha 12 AC50.1
Attribute 4 This is the fourth attribute to import.
AIV-MX-VALUE-4 Alpha 32 AC50.1
Attribute Value This is the fourth attribute value to
import.
AIV-MATRIX-CAT-5 Alpha 12 AC50.1
Attribute 5 This is the fifth attribute to import.
AIV-MX-VALUE-5 Alpha 32 AC50.1
Attribute Value This is the fifth attribute value to
import.
AIV-MATRIX-CAT-6 Alpha 12 AC50.1
Attribute 6 This is the sixth attribute to import.
AIV-MX-VALUE-6 Alpha 32 AC50.1
Attribute Value This is the sixth attribute value to
import.
AIV-MATRIX-CAT-7 Alpha 12 AC50.1
Attribute 7 This is the seventh attribute to
import.
AIV-MX-VALUE-7 Alpha 32 AC50.1
Attribute Value This is the seventh attribute value to
import.
AIV-MATRIX-CAT-8 Alpha 12 AC50.1
Attribute 8 This is the eighth attribute to import.
AIV-MX-VALUE-8 Alpha 32 AC50.1
Attribute Value This is the eighth attribute value to
import.
AIV-MATRIX-CAT-9 Alpha 12 AC50.1
Attribute 9 This is the ninth attribute to import.
AIV-MX-VALUE-9 Alpha 32 AC50.1
Attribute Value This is the ninth attribute value to
import.
AIV-MATRIX-CAT-10 Alpha 12 AC50.1
Attribute 10 This is the tenth attribute to import.
AIV-MX-VALUE-10 Alpha 32 AC50.1
Attribute Value This is the tenth attribute value to
import.
AIV-SEGMENT-BLOCK Alpha 103 AC50.1
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
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
AIV-OUTPUT-MEASURE Signed 15.2 AC50.1
Output Measure 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
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
Bill Wbs Code
AIV-RES-CURR-CODE Alpha 5
Res Curr Code
AIV-EFFECTIVE-DATE Numeric 8 (yyyymmdd)
Effective Date The date a vendor's prices will be in
effect.
AIV-BILL-RATE Signed 13.4
Bill Rate
ACIFACTV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIVSET1 RUN-GRP AC50.1 AC500
OLD-ACTIVITY
ACTIVITY
AIVSET2 RUN-GRP KeyChange, Subset AC10.1 AC110
ACTIVITY-GRP Where LEVEL-ONE != Zeroes AC170 AC190
LEVEL-ONE AC198 AC40.1
LEVEL-TWO AC40.4 AC41.1
LEVEL-THREE AC41.4 AC42.1
LEVEL-FOUR AC50.1 AC500
LEVEL-FIVE AC530 AC54.1
AC540 AC541
AC551 AC70.1
AC70.4 AC741
ACBA.1 GR741
BR00.1 BR00.2
BR00.3 BR02.3
BR03.1 BR03.2
BR03.3 BR120
...
|
