ACRESOURCE FILE
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 AC18.1 AC18.5 AC210 AC217
AC218 AC240 AC295 AC297 AC41.1 AC41.4
AC42.1 AC50.1 AC500 AC52.1 AC540 AC551
AC92.2 AC92.4 AC92.6 BR430
UPDATED BY
AC03.1 AC520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RSC-RESOURCE-CODE Alpha 10 AC03.1 AC520
Resource Code 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).
RSC-RESOURCE-TYPE Alpha 1 AC03.1 AC520
Resource Type This is the resource type, indicating
whether the resource is equipment or a
person.
Q = Equipment
P = Person
RSC-DESCRIPTION Alpha 30 (Lower Case) AC03.1 AC217
Resource Description Required. This is the description of AC218 AC520
the resource.
RSC-RESOURCE-CLASS Alpha 3 AC03.1 AC520
Resource Class This is the resource class for the
activity resource.
RSC-LAST-NAME Alpha 30 (Lower Case) AC03.1 AC217
Last Name Required. This is the last name of the AC218 AC520
personnel resource.
RSC-FIRST-NAME Alpha 15 (Lower Case) AC03.1 AC217
First Name Required. This is the first name of the AC218 AC520
personnel resource.
RSC-MIDDLE-INIT Alpha 1 AC03.1 AC520
Middle Initial Optional. This is the middle initial of
the personnel resource.
RSC-TITLE Alpha 30 (Lower Case) AC03.1 AC520
Title Optional. This is the title of the
personnel resource.
RSC-PHONE-COUNTRY Alpha 6 AC03.1 AC520
Telephone (Country) Optional. This is the prefix of the
telephone number for the resource. For
example, the country or city telephone
code.
RSC-PHONE Alpha 15 AC03.1 AC520
Phone This is the telephone number.
RSC-PHONE-EXT Alpha 5 AC03.1 AC520
Telephone Extension Optional. This is the telephone
extension for the resource.
RSC-E-MAIL-ADDR Alpha 60 AC03.1 AC520
Email Address This is the E-mail address for the
resource.
RSC-COMPANY Numeric 4 AC03.1 AC520
Company The company number represents an
established company and is entered on
all function codes.
RSC-ACCT-UNIT Alpha 15 AC03.1 AC520
Accounting Unit 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.
RSC-ACCOUNT Numeric 6 AC03.1 AC520
Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
RSC-SUB-ACCT Numeric 4 AC03.1 AC520
Subaccount This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
ACRESOURCE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RSCSET1 RESOURCE-CODE AC03.1 AC03.2
RESOURCE-TYPE AC03.6 AC17.2
AC17.6 AC18.1
AC18.5 AC210
AC217 AC218
AC240 AC295
AC297 AC41.1
AC41.4 AC42.1
AC50.1 AC500
AC52.1 AC520
AC540 AC551
AC92.2 AC92.4
AC92.6 BR430
RSCSET2 LAST-NAME KeyChange AC03.1
FIRST-NAME
MIDDLE-INIT
RESOURCE-CODE
RESOURCE-TYPE
ACRESOURCE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acresclass ACRESCLASS Not Required
RSC-RESOURCE-TYPE -> RCL-RESOURCE-TYPE
RSC-RESOURCE-CLASS -> RCL-RESOURCE-CLASS
ACRESOURCE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acassign ACASSIGN
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
|
