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

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