ACIFRESC

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
Element: Run Group
Alpha 15
Key field. This is the run group for the import information.
AC52.1
AFR-SEQ-NUMBER
Element: Seq Number
Numeric 6
A unique numeric identifier for interfaced record.
AC52.1
AFR-OLD-ACT-GRP
Element: Old Act Grp
Alpha 35
This field will contain the name of the activity group the resource will be assigned to.
AC52.1
AFR-OLD-ACTIVITY
Element: Old Activity
Alpha 35
This field will contain the name of the activity that the resources will be assigned to.
AC52.1
AFR-RESOURCE-TYPE
Element: Resource Type
Alpha 1
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
AC52.1
AFR-RESOURCE-CODE
Element: Resource Code
Alpha 10
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.
AC52.1
AFR-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
This is the last name for the resource.
AC52.1
AFR-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
This is the first name for the resource.
AC52.1
AFR-MIDDLE-INIT
Element: Middle Init
Alpha 1
This is the middle initial for the resource.
AC52.1
AFR-COMPANY
Element: Company
Numeric 4
This is the company for the resource. This field is required if the Resource Type is Human Resources employee or vendor.
AC52.1
AFR-TITLE
Element: Title
Alpha 30 (Lower Case)
This is the title for the resource.
AC52.1
AFR-PHONE-COUNTRY
Element: Phone Country
Alpha 6
This is the country code for the resource person's telephone number.
AC52.1
AFR-PHONE
Element: Phone
Alpha 15
This is the resource person's telephone number.
AC52.1
AFR-PHONE-EXT
Element: Phone Ext
Alpha 5
This is the resource person's telephone number.
AC52.1
AFR-E-MAIL-ADDR
Element: E Mail Addr
Alpha 60
This is E-mail for the resource person.
AC52.1
AFR-EMPLOYEE-ASSET
Element: Asset
Numeric 10
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.
AC52.1
AFR-ROLE
Element: Role
Alpha 12
The code that identifies a role that a resource has in relation to activities.
AC52.1
AFR-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
Required. This is the resource description.
AC52.1 AC520
AFR-STD-RATE
Element: Std Rate
Signed 13.5
This field contains the standard cost rate for the resource.
AC52.1
AFR-UNIT-MEASURE
Element: Unit Measure
Alpha 12
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.
AC52.1
AFR-TO-COMPANY
Element: Company
Numeric 4
This is the post-to company for the default expense account.
AC52.1
AFR-ACCT-UNIT
Element: Acct Unit
Alpha 15
This is the accounting unit for the default expense account.
AC52.1
AFR-ACCOUNT
Element: Account
Numeric 6
This is the account for the default expense account.
AC52.1
AFR-SUB-ACCT
Element: Sub Acct
Numeric 4
This is the subaccount for the default expense account.
AC52.1
AFR-MATRIX-CAT
Element: Matrix Cat
Alpha 12
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.
AC52.1
AFR-MX-VALUE
Element: Mx Value
Alpha 32
The attribute value.
AC52.1
AFR-BEGIN-DATE
Element: Begin Date
Numeric 8 (yyyymmdd)
The begin date for this effort period.
AC52.1
AFR-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
The end date for this effort period.
AC52.1
AFR-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
AC52.1
AFR-UPDATE-FLAG
Element: Update Flag
Alpha 1
AC52.1
AFR-MATRIX-LIST
Element: Matrix List
Alpha 12
Attribute 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.
AC52.1
AFR-DELETE-FLAG
Element: Delete Flag
Alpha 1
AC52.1
AFR-EFFECTIVE-DATE
Element: Effective Date
Numeric 8 (yyyymmdd)
The effective date for the rate assignment for the resource.
AC52.1
AFR-BILL-RATE
Element: Bill Rate
Signed 13.4
Billing rate for the resource.
AC52.1
AFR-ACTIVE-FLAG
Element: Active Flag
Alpha 1
The status of the rate assignment for this resource.
AC52.1


ACIFRESC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AFRSET1 RUN-GROUP
SEQ-NUMBER
AC52.1 AC520


File created: Thu Jun 09 11:04:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.