ACIFRESC – Activity Resource Interface

System: Activity Management (AC)
Prefix: AFR
Primary key: RUN-GROUP, SEQ-NUMBER
Fields: 35
Updated by: 2 programs
Referenced by: 0 programs

ACIFRESC is the Activity Resource Interface table in Lawson Activity Management (prefix AFR). It is indexed by RUN-GROUP, SEQ-NUMBER (AFRSET1). It is updated by AC52.1 and AC520. The table has 35 fields, 1 index and 0 documented relations.

About ACIFRESC

No description in the Lawson data dictionary.

Fields (35)

Column = COBOL field name without the AFR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`AFR-RUN-GROUP` PK RUN_GROUP	Alpha 15	Key field. This is the run group for the import information.	AC52.1
`AFR-SEQ-NUMBER` PK SEQ_NUMBER	Numeric 6	A unique numeric identifier for interfaced record.	AC52.1
`AFR-OLD-ACT-GRP` 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` 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` 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` 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` LAST_NAME	Alpha 30 (Lower Case)	This is the last name for the resource.	AC52.1
`AFR-FIRST-NAME` FIRST_NAME	Alpha 15 (Lower Case)	This is the first name for the resource.	AC52.1
`AFR-MIDDLE-INIT` MIDDLE_INIT	Alpha 1	This is the middle initial for the resource.	AC52.1
`AFR-COMPANY` 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` TITLE	Alpha 30 (Lower Case)	This is the title for the resource.	AC52.1
`AFR-PHONE-COUNTRY` PHONE_COUNTRY	Alpha 6	This is the country code for the resource person's telephone number.	AC52.1
`AFR-PHONE` PHONE	Alpha 15	This is the resource person's telephone number.	AC52.1
`AFR-PHONE-EXT` PHONE_EXT	Alpha 5	This is the resource person's telephone number.	AC52.1
`AFR-E-MAIL-ADDR` E_MAIL_ADDR	Alpha 60	This is E-mail for the resource person.	AC52.1
`AFR-EMPLOYEE-ASSET` EMPLOYEE_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` ROLE	Alpha 12	The code that identifies a role that a resource has in relation to activities.	AC52.1
`AFR-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Required. This is the resource description.	AC52.1, AC520
`AFR-STD-RATE` STD_RATE	Signed 13.5	This field contains the standard cost rate for the resource.	AC52.1
`AFR-UNIT-MEASURE` 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` TO_COMPANY	Numeric 4	This is the post-to company for the default expense account.	AC52.1
`AFR-ACCT-UNIT` ACCT_UNIT	Alpha 15	This is the accounting unit for the default expense account.	AC52.1
`AFR-ACCOUNT` ACCOUNT	Numeric 6	This is the account for the default expense account.	AC52.1
`AFR-SUB-ACCT` SUB_ACCT	Numeric 4	This is the subaccount for the default expense account.	AC52.1
`AFR-MATRIX-CAT` 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` MX_VALUE	Alpha 32	The attribute value.	AC52.1
`AFR-BEGIN-DATE` BEGIN_DATE	Numeric 8 (yyyymmdd)	The begin date for this effort period.	AC52.1
`AFR-END-DATE` END_DATE	Numeric 8 (yyyymmdd)	The end date for this effort period.	AC52.1
`AFR-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	AC52.1
`AFR-UPDATE-FLAG` UPDATE_FLAG	Alpha 1	—	AC52.1
`AFR-MATRIX-LIST` 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` DELETE_FLAG	Alpha 1	—	AC52.1
`AFR-EFFECTIVE-DATE` EFFECTIVE_DATE	Numeric 8 (yyyymmdd)	The effective date for the rate assignment for the resource.	AC52.1
`AFR-BILL-RATE` BILL_RATE	Signed 13.4	Billing rate for the resource.	AC52.1
`AFR-ACTIVE-FLAG` ACTIVE_FLAG	Alpha 1	The status of the rate assignment for this resource.	AC52.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`AFRSET1`	`RUN-GROUP`, `SEQ-NUMBER`	Primary		AC52.1, AC520

Programs

Updated by (2)

AC52.1 Resource Interface Adjustment
AC520 Resource Interface