|
|
ACIFRESC FILE
Activity Resource Interface
This file contains resource import information from AC520 (Resource Import).
UPDATED BY
AC52.1 AC520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AFR-RUN-GRP Alpha 10 AC52.1
Element: Base Name
AFR-OLD-ACTIVITY Alpha 35 AC52.1
Element: Old Activity Key field. This is the old, or
non-Lawson, activity.
AFR-RESOURCE-TYPE Alpha 1 AC52.1
Element: Resource Type Key field. This is the type for the
resource. Use E for employee, P for AC
person, Q for AC equipment, A for asset
, and V for vendor.
A = Asset
P = AC Person
E = Employee
V = Vendor
Q = Equipment
AFR-RESOURCE-CODE Alpha 10 AC52.1
Element: Resource Code Key field. This is the code for the
resource. Use E for employee, P for AC
person, Q for AC equipment, A for asset
, and V for vendor.
AFR-LAST-NAME Alpha 30 (Lower Case) AC52.1
Element: Name This is the last name for the resource.
AFR-FIRST-NAME Alpha 15 (Lower Case) AC52.1
Element: First Name This is the first name for the
resource.
AFR-MIDDLE-INIT Alpha 1 AC52.1
Element: Middle InitialThis is the middle initial for the
resource.
AFR-COMPANY Numeric 4 AC52.1
Element: Company This is the company for the resource.
This field is required if the Resource
Type is Human Resources employee or
vendor.
AFR-TITLE Alpha 30 (Lower Case) AC52.1
Element: Title This is the title for the resource.
AFR-PHONE-COUNTRY Alpha 6 AC52.1
Telephone Country This is the country code for the
Code resource person's telephone number.
AFR-PHONE Alpha 15 AC52.1
Element: Telephone NumbThis is the resource person's telephone
number.
AFR-PHONE-EXT Alpha 5 AC52.1
Element: Telephone ExteThis is the resource person's telephone
number.
AFR-E-MAIL-ADDR Alpha 60 AC52.1
Element: E Mail Addr This is E-mail for the resource person.
AFR-EMPLOYEE-ASSET Numeric 10 AC52.1
Element: Asset Number This field contains the Lawson Human
Resources employee number (9 digits) or
the Lawson Asset Management asset number
(10 digits). The field is required for
the Asset and HR Employee resource
types.
AFR-MGR-FLAG Alpha 1 AC52.1 AC520
Element: All Flag This field indicates whether the
resource is the activity manager. Only
one resource can be flagged as the
manager for each activity.
AFR-DESCRIPTION Alpha 30 (Lower Case) AC52.1 AC520
Element: Description Required. This is the resource
description.
AFR-STD-RATE Signed 13.5 AC52.1
Element: Std Rate This field contains the standard cost
rate for the resource.
AFR-UNIT-MEASURE Alpha 12 AC52.1
Element: Unit Measure This is the unit of measure code. It
must be a valid unit of measure code
defined in the ACUOM (Activity Unit of
Measure) file. This field is required if
you enter a standard rate.
AFR-RESOURCE-CLASS Alpha 3 AC52.1
Element: Resource ClassThis is the resource class for the
resource.
AFR-TO-COMPANY Numeric 4 AC52.1
Element: Company This is the post-to company for the
default expense account.
AFR-ACCT-UNIT Alpha 15 AC52.1
Element: Accounting UniThis is the accounting unit for the
default expense account.
AFR-ACCOUNT Numeric 6 AC52.1
Element: Account This is the account for the default
expense account.
AFR-SUB-ACCT Numeric 4 AC52.1
Element: Subaccount This is the subaccount for the default
expense account.
AFR-MATRIX-CAT Alpha 12 AC52.1
Element: Attribute Attribute name assigned to an object
(like accounting unit) to track
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
AFR-MX-VALUE Alpha 32 AC52.1
Element: Attribute Value
AFR-BEGIN-DATE Numeric 8 (yyyymmdd) AC52.1
Element: Date The beginning date in a range of dates.
AFR-END-DATE Numeric 8 (yyyymmdd) AC52.1
Element: Date The ending date in a range of dates.
AFR-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
AFR-UPDATE-FLAG Alpha 1 AC52.1
Element: Update Flag
AFR-MATRIX-LIST Alpha 12 AC52.1
Element: Attribute ListAttribute categories are selection
parameters used to build a list of
objects (accounting units). Attribute
categories and values are the basis of
the selection and sorting. A attribute
list can then be used for reporting on
and processing objects.
AFR-DELETE-FLAG Alpha 1 AC52.1
Element: Delete Flag
AFR-EFFECTIVE-DATE Numeric 8 (yyyymmdd) AC52.1
Element: Date
AFR-BILL-RATE Signed 13.4 AC52.1
Element: Document Total
ACIFRESC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AFRSET1 RUN-GRP AC52.1 AC520
OLD-ACTIVITY
RESOURCE-TYPE
RESOURCE-CODE
COMPANY
AFRSET2 RUN-GRP
OLD-ACTIVITY
RESOURCE-TYPE
COMPANY
RESOURCE-CODE
|
