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
AC191 AC203 AC41.1 AC41.4 AC42.1 AC52.1
AC54.1 AC540 AC550 AC551 ACAC.1 AR250
AR251 AR30.1 AR30.2 AR30.3 AR30.5 BR40.3
BR40.1 AC01.1 AC105 AC112 AC121 AC123
AC13.3 AC135 AC160 AC165 AC190 AC196
AC198 AC206 AC207 AC210 AC213 AC218
AC220 AC240 AC258 AC261 AC265 AC290
AC295 AC297 AC298 AC30.3 AC32.1 AC34.1
AC35.1 AC36.1 AC400 AC401 AC410 AC412
AC420 AC421 AC440 AC460 AC471 AC472
AC473 AC480 AC490 AC493 AC494 AC50.1
AC530 AC55.1 AC90.1 AC92.1 AC93.1 AC94.1
AC95.1 AC97.1 ACBA.1 ACVW.1 DA233 DA240
GR240 SE90.1 BR10.4 BR120 BR121 BR13.1
BR130 BR131 BR142 BR165 BR200 BR202
BR204 BR205 BR210 BR220 BR265 BR400
BR405 BR420 BR430 BR450 BRCC.1 BRIP.1
MX123 MX500 ACDL.1 BR42.1 ACBR.1
UPDATED BY
AC03.2 AC03.3 AC03.4 AC03.5 AC03.6 AC110
AC120 AC300 AC310 AC500 AC520 AC10.1
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
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
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:
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 AR250 AR251
Adjustments), AP10.1 (Vendor), or AC03.1 AR30.1 AR30.2
(Resource). AR30.3
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
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
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
per activity. The default is No.
Y = Yes
N = No
A = Administrator
AAN-DESCRIPTION Alpha 30 (Lower Case) AC03.1 AC03.2
Resource Description Required. This is the description of AC03.3 AC03.4
the resource. If you leave this field AC03.5 AC03.6
blank, the description defaults from the AC110 AC500
Resource Source file. AC520
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.
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.
AAN-MATRIX-CAT Alpha 12 AC03.2 AC03.3
Attribute Attribute name assigned to an object AC03.4 AC03.5
(like accounting unit) to track AC03.6 AC520
additional information. Attribute
values may then be used in selection and
sorting for report and analysis.
AAN-MX-VALUE Alpha 32 AC03.2 AC03.3
Attribute Value AC03.4 AC03.5
AC03.6 AC520
AAN-BEGIN-DATE Numeric 8 (yyyymmdd) AC03.2 AC03.3
Begin Date The beginning date in a range of dates. AC03.4 AC03.5
AC03.6 AC520
AAN-END-DATE Numeric 8 (yyyymmdd) AC03.2 AC03.3
Ending Date The ending date in a range of dates. AC03.4 AC03.5
AC03.6 AC520
AAN-BILL-RATE Signed 13.4
Bill Rate
ACASSIGN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AANSET1 ACTIVITY-GRP AC10.1 AC120
ACTIVITY AC191 AC203
RESOURCE-TYPE AC300 AC310
RESOURCE-CODE AC41.1 AC41.4
AC42.1 AC52.1
AC520 AC54.1
AC540 AC550
AC551 ACAC.1
AR250 AR251
AR30.1 AR30.2
AR30.3 BR40.3
AANSET2 ACTIVITY-GRP KeyChange AC01.1 AC03.2
ACTIVITY AC03.3 AC03.4
MGR-FLAG AC105 AC112
RESOURCE-TYPE AC120 AC121
RESOURCE-CODE AC123 AC13.3
AC135 AC160
AC165 AC190
AC191 AC196
AC198 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC240 AC258
AC261 AC265
AC290 AC295
...
AANSET3 RESOURCE-CODE AC03.1 AC203
RESOURCE-TYPE AC520 ACDL.1
ACTIVITY-GRP BR40.1 BR42.1
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 KeyChange
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
AC550 ACBR.1
AANSET8 COMPANY KeyChange, 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
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
|
