|
|
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
AC115 AC210 AC256 AC295 AC297 AC41.1
AC415 AC42.1 AC440 AC470 AC50.1 AC500
AC52.1 AC540
UPDATED BY
AC03.1 AC520 AC950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RSC-RESOURCE-CODE Alpha 10 AC03.1 AC520
Resource Code Required key. This code identifies a AC950
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 AC950
whether the resource is equipment or a
person.
Q = Equipment
P = Person
RSC-DESCRIPTION Alpha 30 (Lower Case) AC03.1 AC520
Resource Description Required. This is the description of AC950
the resource.
RSC-STD-RATE Signed 13.5 AC03.1 AC520
Standard Cost Optional. This is the activity standard AC950
cost. If you leave this field blank, its
value defaults to the standard cost
value in the Activity Resource
Assignment file.
RSC-RESOURCE-CLASS Alpha 3 AC03.1 AC520
Resource Class This is the resource class for the AC950
activity resource.
RSC-LAST-NAME Alpha 30 (Lower Case) AC03.1 AC520
Last Name Required. This is the last name of the AC950
personnel resource.
RSC-FIRST-NAME Alpha 15 (Lower Case) AC03.1 AC520
First Name Required. This is the first name of the AC950
personnel resource.
RSC-MIDDLE-INIT Alpha 1 AC03.1 AC520
Middle Initial Optional. This is the middle initial of AC950
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 AC950
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. AC950
RSC-PHONE-EXT Alpha 5 AC03.1 AC520
Telephone Extension Optional. This is the telephone AC950
extension for the resource.
RSC-E-MAIL-ADDR Alpha 60 AC03.1 AC520
Email Address This is the E-mail address for the AC950
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.
RSC-UOM Alpha 4
Unit of Measure This field contains the valid stock
unit of measure for this item.
ACRESOURCE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RSCSET1 RESOURCE-CODE AC03.1 AC03.2
RESOURCE-TYPE AC03.6 AC115
AC210 AC256
AC295 AC297
AC41.1 AC415
AC42.1 AC440
AC470 AC50.1
AC500 AC52.1
AC520 AC540
RSCSET2 LAST-NAME 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
|