|
|
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
AC131 AC191 AC203 AC213 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 BR43.1 AC01.1 AC105 AC112
AC113 AC121 AC123 AC13.3 AC130 AC135
AC160 AC165 AC190 AC196 AC198 AC200
AC206 AC207 AC210 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 SE90.1 BR10.4 BR120 BR121
BR13.1 BR130 BR131 BR142 BR15.3 BR151
BR152 BR153 BR154 BR155 BR156 BR157
BR165 BR200 BR202 BR204 BR205 BR210
BR215 BR220 BR251 BR252 BR253 BR254
BR265 BR400 BR405 BR420 BR430 BR450
BR521 BR530 BR900 BRCC.1 BRIP.1 BRPI.1
MX123 MX500 ACDL.1 BR42.1 ACBR.1
UPDATED BY
AC03.1 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
Element: Activity GroupRequired 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Resource DescrRequired. 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
Element: Resource ClassOptional. 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
Element: Company AC03.4 AC03.5
AC03.6 AC110
AC500 AC520
AAN-ACCT-UNIT Alpha 15 AC03.2 AC03.3
Element: Accounting UniThe 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
Element: 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
Element: 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
Element: 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
Element: Attribute Value AC03.4 AC03.5
AC03.6 AC520
AAN-BEGIN-DATE Numeric 8 (yyyymmdd) AC03.2 AC03.3
Element: 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
Element: Date The ending date in a range of dates. AC03.4 AC03.5
AC03.6 AC520
AAN-BILL-RATE Signed 13.4
Element: Document Total
ACASSIGN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AANSET1 ACTIVITY-GRP AC10.1 AC120
ACTIVITY AC131 AC191
RESOURCE-TYPE AC203 AC213
RESOURCE-CODE AC300 AC310
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
BR43.1
AANSET2 ACTIVITY-GRP KeyChange AC01.1 AC03.2
ACTIVITY AC03.3 AC03.4
MGR-FLAG AC105 AC112
RESOURCE-TYPE AC113 AC120
RESOURCE-CODE AC121 AC123
AC13.3 AC130
AC135 AC160
AC165 AC190
AC191 AC196
AC198 AC200
AC203 AC206
AC207 AC210
AC213 AC218
AC220 AC240
AC258 AC261
...
AANSET3 RESOURCE-CODE AC03.1 AC203
RESOURCE-TYPE AC520 ACDL.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
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
|
