|
|
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-GROUP Alpha 15 AC52.1
Element: Run Group Key field. This is the run group for
the import information.
AFR-SEQ-NUMBER Numeric 6 AC52.1
Record Sequence A unique numeric identifier for
Number interfaced record.
AFR-OLD-ACT-GRP Alpha 35 AC52.1
Element: Old Activity GThis field will contain the name of the
activity group the resource will be
assigned to.
AFR-OLD-ACTIVITY Alpha 35 AC52.1
Element: Old Activity This field will contain the name of the
activity that the resources will be
assigned to.
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: Last 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-ROLE Alpha 12 AC52.1
Element: Role The code that identifies a role that a
resource has in relation to activities.
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-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 ValuThe attribute value.
AFR-BEGIN-DATE Numeric 8 (yyyymmdd) AC52.1
Element: Begin Date The begin date for this effort period.
AFR-END-DATE Numeric 8 (yyyymmdd) AC52.1
Element: Ending Date The end date for this effort period.
AFR-CURRENCY-CODE Alpha 5 AC52.1
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: Effective DateThe effective date for the rate
assignment for the resource.
AFR-BILL-RATE Signed 13.4 AC52.1
Element: Bill Rate Billing rate for the resource.
AFR-ACTIVE-FLAG Alpha 1 AC52.1
Element: Status The status of the rate assignment for
this resource.
ACIFRESC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AFRSET1 RUN-GROUP AC52.1 AC520
SEQ-NUMBER
|
