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
AC145 AC17.2 AC17.6 AC18.1 AC18.5 AC210
AC217 AC218 AC240 AC295 AC297 AC41.1
AC41.4 AC42.1 AC420 AC46.1 AC50.1 AC500
AC52.1 AC54.1 AC540 AC69.2 AC92.2 AC92.4
AC92.6 ACAC.1 ACBD.2 BR40.3 BR43.1 BR46.1


UPDATED BY
AC03.1 AC520

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 AC520
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 AC520
RSC-DESCRIPTION
Element: Resource Description
Alpha 30 (Lower Case)
Required. This is the description of the resource.
AC03.1 AC217
AC218 AC520
RSC-LAST-NAME
Element: Last Name
Alpha 30 (Lower Case)
Required. This is the last name of the personnel resource.
AC03.1 AC217
AC218 AC520
RSC-FIRST-NAME
Element: First Name
Alpha 15 (Lower Case)
Required. This is the first name of the personnel resource.
AC03.1 AC217
AC218 AC520
RSC-MIDDLE-INIT
Element: Middle Initial
Alpha 1
Optional. This is the middle initial of the personnel resource.
AC03.1 AC520
RSC-TITLE
Element: Title
Alpha 30 (Lower Case)
Optional. This is the title of the personnel resource.
AC03.1 AC520
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 AC520
RSC-PHONE
Element: Phone
Alpha 15
This is the telephone number.
AC03.1 AC520
RSC-PHONE-EXT
Element: Telephone Extension
Alpha 5
Optional. This is the telephone extension for the resource.
AC03.1 AC520
RSC-E-MAIL-ADDR
Element: Email Address
Alpha 60
This is the E-mail address for the resource.
AC03.1 AC520
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 AC520
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 AC520
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 AC520
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 AC520
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
AC145 AC17.2
AC17.6 AC18.1
AC18.5 AC210
AC217 AC218
AC240 AC295
AC297 AC41.1
AC41.4 AC42.1
AC420 AC46.1
AC50.1 AC500
AC52.1 AC520
AC54.1 AC540
AC69.2 AC92.2
AC92.4 AC92.6
RSCSET2 LAST-NAME
FIRST-NAME
MIDDLE-INIT
RESOURCE-CODE
RESOURCE-TYPE
KeyChange
AC03.1


ACRESOURCE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Acrsrcbod ACRSRCBOD Not Required, Delete Cascades
RSC-RESOURCE-CODE->YAN-RESOURCE-CODE
RSC-RESOURCE-TYPE->YAN-RESOURCE-TYPE


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: Thu Jun 09 02:03:12 2016

Home
Contact Us



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