|
|
ACIFACTV FILE
Activity Import
This file contains activity import information from AC500 (Activity Import).
UPDATED BY
AC50.1 AC500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIV-RUN-GROUP Alpha 12 AC50.1
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
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-OLD-ACT-GRP Alpha 35 AC50.1
Old Account 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 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 AC500
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-TOTAL-COST Signed 15.2 AC50.1
Total Cost Total cost of work order item
AIV-TOTAL-BILLED Signed 15.2 AC50.1
Total Billed
AIV-TOTAL-BILLABLE Signed 15.2 AC50.1
Total Billable
AIV-TOTAL-REVENUE Signed 15.2 AC50.1
Total Revenue
AIV-TOTAL-LOSS Signed 15.2 AC50.1
Total Loss
AIV-CONTRACT-AMT Signed 15.2 AC50.1 AC500
Contract Amt This is the contract amount for the
activity. This field is required if you
selected Yes for Billable.
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
Matrix Cat 1 This is the first attribute to import.
AIV-MX-VALUE-1 Alpha 20 AC50.1
Attribute Value This is the first attribute value to
import.
AIV-MATRIX-CAT-2 Alpha 12 AC50.1
Matrix Cat 2 This is the second attribute to import.
AIV-MX-VALUE-2 Alpha 20 AC50.1
Attribute Value This is the second attribute value to
import.
AIV-MATRIX-CAT-3 Alpha 12 AC50.1
Matrix Cat 3 This is the third attribute to import.
AIV-MX-VALUE-3 Alpha 20 AC50.1
Attribute Value This is the third attribute value to
import.
AIV-MATRIX-CAT-4 Alpha 12 AC50.1
Matrix Cat 4 This is the fourth attribute to import.
AIV-MX-VALUE-4 Alpha 20 AC50.1
Attribute Value This is the fourth attribute value to
import.
AIV-MATRIX-CAT-5 Alpha 12 AC50.1
Matrix Cat 5 This is the fifth attribute to import.
AIV-MX-VALUE-5 Alpha 20 AC50.1
Attribute Value This is the fifth attribute value to
import.
AIV-MATRIX-CAT-6 Alpha 12 AC50.1
Matrix Cat 6 This is the sixth attribute to import.
AIV-MX-VALUE-6 Alpha 20 AC50.1
Attribute Value This is the sixth attribute value to
import.
AIV-MATRIX-CAT-7 Alpha 12 AC50.1
Matrix Cat 7 This is the seventh attribute to
import.
AIV-MX-VALUE-7 Alpha 20 AC50.1
Attribute Value This is the seventh attribute value to
import.
AIV-MATRIX-CAT-8 Alpha 12 AC50.1
Matrix Cat 8 This is the eighth attribute to import.
AIV-MX-VALUE-8 Alpha 20 AC50.1
Attribute Value This is the eighth attribute value to
import.
AIV-MATRIX-CAT-9 Alpha 12 AC50.1
Matrix Cat 9 This is the ninth attribute to import.
AIV-MX-VALUE-9 Alpha 20 AC50.1
Attribute Value This is the ninth attribute value to
import.
AIV-MATRIX-CAT-10 Alpha 12 AC50.1
Matrix Cat 10 This is the tenth attribute to import.
AIV-MX-VALUE-10 Alpha 20 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.
ACIFACTV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AIVSET1 RUN-GROUP AC50.1 AC500
OLD-ACTIVITY
ACTIVITY
AIVSET2 RUN-GROUP KeyChange, Duplicates, Subset AC50.1 AC500
LEVEL-ONE Where LEVEL-ONE != Zeroes
LEVEL-TWO
LEVEL-THREE
LEVEL-FOUR
LEVEL-FIVE
|