|
|
ACASSIGN FILE
Activity Resource Assignment
This file contains resource assignment information from AC03.2 (AC Person
Assignment), AC03.3 (HR Employee Assignment), AC03.4 (Vendor Assignment),
AC03.5 (Asset Assignment), and AC03.6 (Equipment Assignment). It includes
resource codes, their descriptions, and the assignment of resources to
activities and activity groups. The resources must have been defined already
in AC03.1 (Resource), HR11.1 (Employee), AM20.2 (Additions and Adjustments),
or AP10.1 (Vendor).
REFERENCED BY
AC203 AC41.1 AC42.1 AC52.1 AC54.1 AC540
AC70.3 AC70.1 ACAC.1 AC105 AC112 AC115
AC123 AC13.3 AC130 AC14.1 AC160 AC165
AC170 AC190 AC191 AC196 AC20.1 AC20.2
AC20.3 AC20.4 AC206 AC207 AC210 AC214
AC215 AC216 AC240 AC265 AC290 AC295
AC297 AC30.2 AC30.3 AC32.1 AC401 AC410
AC412 AC415 AC416 AC420 AC421 AC440
AC450 AC460 AC470 AC471 AC472 AC473
AC480 AC490 AC50.1 AC530 AC55.1 AC79.1
ACBA.1 MX123
UPDATED BY
AC03.2 AC03.3 AC03.4 AC03.5 AC03.6 AC10.1
AC110 AC120 AC300 AC310 AC500 AC520
AC950
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
AAN-ACTIVITY-GRP Alpha 15 AC03.2 AC03.3
Activity Group Required key. This is the activity AC03.4 AC03.5
group to which the resource is assigned. AC03.6 AC110
AC120 AC500
AC520 AC950
AAN-ACTIVITY Alpha 15 AC03.2 AC03.3
Activity Required key. This is the activity to AC03.4 AC03.5
which the resource is assigned. AC03.6 AC110
AC500 AC520
AC950
AAN-RESOURCE-TYPE Alpha 1 AC03.2 AC03.3
Resource Type Key field. This field indicates the AC03.4 AC03.5
type of resource this is. AC03.6 AC110
AC500 AC520
Valid values include: AC950
Q = Equipment
P = Person
E = Payroll Employee
A = Asset
V = AP/EE Vendor
AAN-RESOURCE-CODE Alpha 10 AC03.2 AC03.3
Resource Code Required key. This code identifies a AC03.4 AC03.5
resource assigned to an activity. The AC03.6 AC110
resource must first be defined in HR11.1 AC500 AC520
(Employee), AM20.2 (Additions and AC950
Adjustments), AP10.1 (Vendor), or AC03.1
(Resource).
AAN-COMPANY Numeric 4 AC03.2 AC03.3
Company Key field. Required for resource types AC03.4 AC03.5
Employee and Vendor. This is the company AC03.6 AC110
number for this assignment. If you leave AC500 AC520
this field blank, it defaults to the AC950
activity responsible company.
AAN-EMPLOYEE-ASSET Numeric 10 AC03.2 AC03.3
Employee This field is required for Employee and AC03.4 AC03.5
Asset resource types. It allows you to AC03.6 AC110
establish a relationship with the AC500 AC520
Employee and Asset files for Drill AC950
Around and selects.
AAN-MGR-FLAG Alpha 1 AC03.2 AC03.3
Manager Flag Resource type must be Employee, Vendor, AC03.4 AC03.5
or Person. This flag tells whether the AC03.6 AC110
resource person is the manager of the AC500 AC520
activity. There can be only one manager AC950
per activity. The default is No.
Y = Yes
N = No
AAN-DESCRIPTION Alpha 30 (Lower Case) AC03.2 AC03.3
Resource Description Required. This is the description of AC03.4 AC03.5
the resource. If you leave this field AC03.6 AC110
blank, the description defaults from the AC500 AC520
Resource Source file. AC950
AAN-STD-RATE Signed 13.5 AC03.2 AC03.3
Standard Rate This is the activity standard cost. It AC03.4 AC03.5
is used to calculate cost amount. AC03.6 AC110
AC500 AC520
AC950
AAN-UNIT-MEASURE Alpha 12 AC03.2 AC03.3
Unit of Measure This is the unit of measure code, AC03.4 AC03.5
indicating whether the unit of measure AC03.6 AC110
is units or hours. This field is AC500 AC520
required if standard cost is entered. AC950
Unit of measure must be defined in
AC17.1 (Labor Rates) before you define
it here.
AAN-RESOURCE-CLASS Alpha 3 AC03.2 AC03.3
Resource Class Optional. This is the resource class. AC03.4 AC03.5
Using this field, you can define AC03.6 AC110
standard costs at a resource class AC500 AC520
level. AC950
AAN-TO-COMPANY Numeric 4 AC03.2 AC03.3
To Company This is the company number to which AC03.4 AC03.5
this line is to be posted. AC03.6 AC110
AC500 AC520
AAN-ACCT-UNIT Alpha 15 AC03.2 AC03.3
Accounting Unit The accounting unit is a shorthand AC03.4 AC03.5
notation representing the variable level AC03.6 AC110
number. When used in the General Ledger AC500 AC520
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
AAN-ACCOUNT Numeric 6 AC03.2 AC03.3
Account This field along with the accounting AC03.4 AC03.5
unit and subaccount make up the location AC03.6 AC110
(account) where amounts and other AC500 AC520
account information is stored.
AAN-SUB-ACCT Numeric 4 AC03.2 AC03.3
Subaccount This field contains the subaccount from AC03.4 AC03.5
your general ledger chart of accounts AC03.6 AC110
that was charged with the amount carried AC500 AC520
on this record.
ACASSIGN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AANSET1 ACTIVITY-GRP AC10.1 AC120
ACTIVITY AC203 AC300
RESOURCE-TYPE AC310 AC41.1
RESOURCE-CODE AC42.1 AC52.1
AC54.1 AC540
AC70.3 ACAC.1
AANSET2 ACTIVITY-GRP Subset AC03.2 AC03.3
ACTIVITY Where (MGR-FLAG = "Y" ) AC03.4 AC105
RESOURCE-TYPE AC110 AC112
RESOURCE-CODE AC115 AC120
AC123 AC13.3
AC130 AC14.1
AC160 AC165
AC170 AC190
AC191 AC196
AC20.1 AC20.2
AC20.3 AC20.4
AC203 AC206
AC207 AC210
AC214 AC215
AC216 AC240
...
AANSET3 RESOURCE-CODE AC03.1 AC203
RESOURCE-TYPE AC520 AC70.1
ACTIVITY-GRP
ACTIVITY
AANSET4 RESOURCE-CODE Subset
ACTIVITY-GRP Where (MGR-FLAG = "Y" )
ACTIVITY
RESOURCE-TYPE
AANSET5 ACTIVITY AC10.1 AC110
ACTIVITY-GRP AC203
RESOURCE-CODE
RESOURCE-TYPE
AANSET6 ACTIVITY-GRP
ACTIVITY
RESOURCE-TYPE
COMPANY
EMPLOYEE-ASSET
RESOURCE-CODE
AANSET7 RESOURCE-TYPE AC03.2 AC03.3
ACTIVITY-GRP AC03.4 AC03.5
ACTIVITY AC03.6 AC03.8
RESOURCE-CODE AC50.1 AC500
AANSET8 COMPANY Subset
EMPLOYEE-ASSETWhere RESOURCE-TYPE = "E"
ACTIVITY-GRP
ACTIVITY
RESOURCE-TYPE
RESOURCE-CODE
ACASSIGN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acactgrp ACACTGRP Not Required
AAN-ACTIVITY-GRP -> AGP-ACTIVITY-GRP (AGPSET1)
Acactivity ACACTIVITY Not Required
AAN-ACTIVITY -> ACV-ACTIVITY
Acresclass ACRESCLASS Not Required
AAN-RESOURCE-TYPE -> RCL-RESOURCE-TYPE
AAN-RESOURCE-CLASS -> RCL-RESOURCE-CLASS
Acresource ACRESOURCE Not Required
Valid When AAN-RESOURCE-TYPE = "P"
Or AAN-RESOURCE-TYPE = "Q"
AAN-RESOURCE-CODE -> RSC-RESOURCE-CODE
AAN-RESOURCE-TYPE -> RSC-RESOURCE-TYPE
Acuom ACUOM Not Required
AAN-UNIT-MEASURE -> UOM-UNIT-MEASURE
Amasset AMASSET Not Required
Valid When AAN-RESOURCE-TYPE = "A"
AAN-EMPLOYEE-ASSET -> AST-ASSET
Apcompany APCOMPANY Not Required
Valid When AAN-RESOURCE-TYPE = "V"
AAN-COMPANY -> CPY-COMPANY
Apvenmast APVENMAST Not Required
Valid When AAN-RESOURCE-TYPE = "V"
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
AAN-RESOURCE-CODE -> VEN-VENDOR
Employee EMPLOYEE Not Required
Valid When AAN-RESOURCE-TYPE = "E"
AAN-COMPANY -> EMP-COMPANY
AAN-EMPLOYEE-ASSET -> EMP-EMPLOYEE
|