ACRESOURCE

Activity Resource

This file contains resource definition information from AC03.1 (Resource). It includes resource code, type, description, standard cost, resource class, as well as resource names, title, telephone number, and E-mail address.

REFERENCED BY
AC17.2 AC17.6 AC210 ACAC.1


UPDATED BY
AC03.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RSC-RESOURCE-CODE
Element: Resource Code
Alpha 10
Required key. This code identifies a personnel or equipment resource assigned to an activity. The resource must first be defined in HR11 (Employee) or AC03.1 (Resource).
AC03.1
RSC-RESOURCE-TYPE
Element: Resource Type
Alpha 1
This is the resource type, indicating whether the resource is equipment or a person.
Q = Equipment
P = Person
AC03.1
RSC-DESCRIPTION
Element: Resource Description
Alpha 30 (Lower Case)
Required. This is the description of the resource.
AC03.1
RSC-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
Required. This is the last name of the personnel resource.
AC03.1
RSC-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
Required. This is the first name of the personnel resource.
AC03.1
RSC-MIDDLE-INIT
Element: Middle Initial
Alpha 1
Optional. This is the middle initial of the personnel resource.
AC03.1
RSC-TITLE
Element: Title
Alpha 30 (Lower Case)
Optional. This is the title of the personnel resource.
AC03.1
RSC-PHONE-COUNTRY
Element: Telephone (Country)
Alpha 6
Optional. This is the prefix of the telephone number for the resource. For example, the country or city telephone code.
AC03.1
RSC-PHONE
Element: Phone
Alpha 15
This is the telephone number.
AC03.1
RSC-PHONE-EXT
Element: Telephone Extension
Alpha 5
Optional. This is the telephone extension for the resource.
AC03.1
RSC-E-MAIL-ADDR
Element: Email Address
Alpha 60
This is the E-mail address for the resource.
AC03.1
RSC-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
AC03.1
RSC-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
AC03.1
RSC-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
AC03.1
RSC-SUB-ACCT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
AC03.1
RSC-ROLE
Element: Role
Alpha 12
The code that identifies a role that a resource has in relation to activities.
AC03.1


ACRESOURCE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RSCSET1 RESOURCE-CODE
RESOURCE-TYPE
AC03.1 AC03.2
AC03.6 AC03.7
AC17.2 AC17.6
AC210 ACAC.1
RSCSET2 LAST-NAME
FIRST-NAME
MIDDLE-INIT
RESOURCE-CODE
RESOURCE-TYPE
KeyChange
AC03.1


ACRESOURCE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acassign ACASSIGN
Zeroes->AAN-COMPANY
RSC-RESOURCE-CODE->AAN-RESOURCE-CODE
RSC-RESOURCE-TYPE->AAN-RESOURCE-TYPE
  AAN-ACTIVITY-GRP
  AAN-ACTIVITY
Acresrtx ACRESRTX
RSC-RESOURCE-TYPE->RRX-RESOURCE-TYPE
RSC-RESOURCE-CODE->RRX-RESOURCE-CODE
  RRX-COMPANY
  RRX-EFFECTIVE-DATE


File created: Wed Jun 08 20:46:56 2016

Home
Contact Us



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