|
|
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
AC131 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 AC54.1
AC540 AC92.2 AC92.4 AC92.6 ACAC.1 BR40.3
BR43.1 BR430
UPDATED BY
AC03.1 AC520
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RSC-RESOURCE-CODE Alpha 10 AC03.1 AC520
Element: 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
Element: 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
Element: Resource DescrRequired. This is the description of AC218 AC520
the resource.
RSC-RESOURCE-CLASS Alpha 3 AC03.1 AC520
Element: Resource ClassThis is the resource class for the
activity resource.
RSC-LAST-NAME Alpha 30 (Lower Case) AC03.1 AC217
Element: Last Name Required. This is the last name of the AC218 AC520
personnel resource.
RSC-FIRST-NAME Alpha 15 (Lower Case) AC03.1 AC217
Element: First Name Required. This is the first name of the AC218 AC520
personnel resource.
RSC-MIDDLE-INIT Alpha 1 AC03.1 AC520
Element: Middle InitialOptional. This is the middle initial of
the personnel resource.
RSC-TITLE Alpha 30 (Lower Case) AC03.1 AC520
Element: Title Optional. This is the title of the
personnel resource.
RSC-PHONE-COUNTRY Alpha 6 AC03.1 AC520
Element: Telephone (CouOptional. 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
Element: Phone This is the telephone number.
RSC-PHONE-EXT Alpha 5 AC03.1 AC520
Element: Telephone ExteOptional. This is the telephone
extension for the resource.
RSC-E-MAIL-ADDR Alpha 60 AC03.1 AC520
Element: Email Address This is the E-mail address for the
resource.
RSC-COMPANY Numeric 4 AC03.1 AC520
Element: Company The company number represents an
established company and is entered on
all function codes.
RSC-ACCT-UNIT Alpha 15 AC03.1 AC520
Element: Accounting UniThe 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
Element: 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
Element: 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 AC131
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 AC54.1
AC540 AC92.2
AC92.4 AC92.6
ACAC.1 BR40.3
BR43.1 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
|
