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 AC750 ACAC.1
ACDL.1 AR250 AR251 AR30.1 AR30.2 AR30.3
AR30.5 BR40.3 BR40.1 AC01.1 AC105 AC112
AC121 AC123 AC13.3 AC160 AC165 AC190
AC196 AC198 AC206 AC207 AC210 AC213
AC218 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 SE90.1 BR10.1
BR10.4 BR120 BR121 BR13.1 BR142 BR200
BR202 BR204 BR205 BR210 BR220 BR265
BR400 BR405 BR420 BR430 BR450 BRCC.1
BRIP.1 MX123 MX500 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
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
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
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
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 AC750
ACAC.1 ACDL.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
AC160 AC165
AC190 AC191
AC196 AC198
AC203 AC206
AC207 AC210
AC213 AC218
AC240 AC258
AC261 AC265
AC290 AC295
AC297 AC298
...
AANSET3 RESOURCE-CODE AC03.1 AC203
RESOURCE-TYPE AC520 BR40.1
ACTIVITY-GRP 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
AC750 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
|
