|
|
ACIFACTV FILE
This file contains activity import information from AC500 (Activity Import).
REFERENCED BY
AC10.1 AC10.5 AC110 AC113 AC120 AC121
AC135 AC165 AC190 AC191 AC192 AC196
AC198 AC210 AC213 AC218 AC220 AC240
AC258 AC261 AC265 AC290 AC295 AC297
AC298 AC310 AC40.1 AC40.4 AC400 AC401
AC41.1 AC41.4 AC410 AC42.1 AC420 AC440
AC460 AC471 AC472 AC473 AC480 AC490
AC493 AC494 AC530 AC54.1 AC540 AC541
AC551 AC90.1 AC90.2 AC90.4 AC90.6 AC90.8
AC92.1 AC92.2 AC92.4 AC92.6 AC93.1 AC93.4
AC93.5 AC94.1 AC94.2 AC94.4 AC94.6 AC95.1
AC95.2 AC95.4 AC95.6 AC97.1 ACBA.1 SE90.1
BR00.1 BR00.2 BR00.3 BR02.1 BR02.3 BR03.1
BR03.2 BR03.3 BR05.2 BR05.3 BR05.4 BR05.5
BR10.1 BR120 BR121 BR130 BR131 BR142
BR151 BR152 BR153 BR154 BR155 BR156
BR157 BR165 BR200 BR202 BR204 BR205
BR210 BR215 BR220 BR251 BR252 BR253
BR254 BR265 BR40.3 BR40.4 BR400 BR405
BR41.1 BR41.4 BR420 BR430 BR450 BR52.2
BR52.4 BR52.5 BR521 BR530 BR54.2 BR54.3
BR54.4 BR900 BRCC.1
UPDATED BY
AC50.1 AC500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AIV-RUN-GRP Alpha 10 AC50.1
Element: Base Name
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: Group
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: 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: 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 15.2 AC50.1
Element: Price This is the estimated amount for the
activity.
AIV-BILLABLE-FLAG Alpha 1 AC50.1
Element: Billable Flag This 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: Item DescriptiThis 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: Resource 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: Item DescriptiIf 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-RESOURCE-CLASS Alpha 3 AC50.1
Element: Resource ClassThis is the resource class for the
activity resource.
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-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 15.2 AC50.1
Element: Adj 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: Date
AIV-BILL-RATE Signed 13.4
Element: Document Total
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 AC10.5
ACTIVITY-GRP Where LEVEL-ONE != Zeroes AC110 AC113
LEVEL-ONE AC120 AC121
LEVEL-TWO AC135 AC165
LEVEL-THREE AC190 AC191
LEVEL-FOUR AC192 AC196
LEVEL-FIVE AC198 AC210
AC213 AC218
AC220 AC240
AC258 AC261
AC265 AC290
AC295 AC297
AC298 AC310
AC40.1 AC40.4
AC400 AC401
...
|
