Lawson Insight Technical Documentation |
|
ACASSIGN
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
AC01.1 AC105 AC112 AC113 AC121 AC123
AC128 AC13.3 AC130 AC135 AC145 AC160
AC165 AC169 AC190 AC191 AC197 AC198
AC200 AC203 AC206 AC207 AC210 AC213
AC218 AC220 AC225 AC240 AC246 AC261
AC265 AC290 AC295 AC298 AC30.3 AC32.1
AC34.1 AC346 AC35.1 AC36.1 AC400 AC401
AC41.1 AC41.4 AC410 AC412 AC42.1 AC420
AC421 AC440 AC46.1 AC460 AC471 AC472
AC473 AC480 AC490 AC493 AC494 AC50.1
AC52.1 AC527 AC54.1 AC540 AC55.1 AC580
AC583 AC90.1 AC92.1 AC93.1 AC94.1 AC95.1
ACAC.1 ACBA.1 ACDL.1 ACDM.2 ACDM.9 ACSB.1
ACVW.1 SE90.1 AP211 AR21.2 AR237 AR239
AR250 AR251 AR257 AR27.2 AR29.1 AR296
AR30.1 AR30.5 AR32.1 AR33.1 AR33.2 AR38.5
AR39.1 AR39.2 AR39.3 AR39.4 AR42.1 AR42.2
AR42.7 AR43.1 AR502 AR503 AR55.1 AR560
AR575 AR800 AR91.1 ARLL.1 BR10.4 BR120
BR121 BR13.1 BR130 BR131 BR140 BR142
BR145 BR151 BR152 BR153 BR154 BR155
BR156 BR157 BR165 BR19.2 BR190 BR20.9
BR200 BR202 BR204 BR205 BR210 BR212
BR215 BR220 BR245 BR251 BR252 BR253
BR254 BR265 BR300 BR40.3 BR400 BR405
BR422 BR43.1 BR430 BR450 BR46.1 BR521
BR530 BR580 BRIP.1 ET530 ET540 MX123
MX500 SN02.1 SNAC.1 BR96.1 ACBR.1 ET700
UPDATED BY
AC03.1 AC03.2 AC03.3 AC03.4 AC03.5 AC03.6
AC110 AC120 AC300 AC310 AC500 AC520
PW110 PW510 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 PW110
PW510
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
PW110 PW510
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: PW110 PW510
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 AR32.1
(Resource). AR33.1 AR39.1
AR39.2 PW110
PW510
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 PW110 PW510
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 PW110 PW510
Around and selects.
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 PW110
PW510
AAN-TO-COMPANY Numeric 4 AC03.2 AC03.3
Element: Company Identifies the AP company if the AC03.4 AC03.5
resource type = V. Identifies the HR AC03.6 AC110
company if the resource type = E. It is AC500 AC520
blank for type A, P or Q resources. PW110 PW510
AAN-ACCT-UNIT Alpha 15 AC03.2 AC03.3
Element: Acct 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 PW110 PW510
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. PW110 PW510
AAN-SUB-ACCT Numeric 4 AC03.2 AC03.3
Element: Sub Acct 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. PW110 PW510
AAN-MATRIX-CAT Alpha 12 AC03.2 AC03.3
Element: Matrix Cat Attribute name assigned to an object AC03.4 AC03.5
(like accounting unit) to track AC03.6 AC500
additional information. Attribute AC520 PW110
values may then be used in selection and PW510
sorting for report and analysis.
AAN-MX-VALUE Alpha 32 AC03.2 AC03.3
Element: Mx Value The attribute value. AC03.4 AC03.5
AC03.6 AC500
AC520 PW110
PW510
AAN-BEGIN-DATE Numeric 8 (yyyymmdd) AC03.2 AC03.3
Element: Begin Date The begin date for this effort period. AC03.4 AC03.5
AC03.6 AC500
AC520 PW110
PW510
AAN-END-DATE Numeric 8 (yyyymmdd) AC03.2 AC03.3
Element: End Date The end date for this effort period. AC03.4 AC03.5
AC03.6 AC500
AC520 PW110
PW510
AAN-BILL-RATE Signed 13.4
Element: Bill Rate The billing rate that is set up for a
resource for a specific activity.
ACASSIGN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
AANSET1 ACTIVITY-GRP AC01.1 AC03.7
ACTIVITY AC105 AC112
COMPANY AC113 AC120
RESOURCE-TYPE AC121 AC123
RESOURCE-CODE AC128 AC13.3
AC130 AC135
AC145 AC160
AC165 AC169
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC225 AC240
...
AANSET3 COMPANY AC03.1 AC203
RESOURCE-CODE AC520 ACDL.1
RESOURCE-TYPE BR96.1
ACTIVITY-GRP
ACTIVITY
AANSET5 ACTIVITY AC10.1 AC110
ACTIVITY-GRP AC203
COMPANY
RESOURCE-CODE
RESOURCE-TYPE
AANSET7 RESOURCE-TYPE AC03.2 AC03.3
ACTIVITY-GRP AC03.4 AC03.5
ACTIVITY AC03.6 AC50.1
COMPANY AC500 ACBR.1
RESOURCE-CODE ET700 PW110
PW510
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
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
ACASSIGN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acasnrole ACASNROLE
AAN-ACTIVITY-GRP -> ALE-ACTIVITY-GRP
AAN-ACTIVITY -> ALE-ACTIVITY
AAN-RESOURCE-TYPE -> ALE-RESOURCE-TYPE
AAN-COMPANY -> ALE-COMPANY
AAN-RESOURCE-CODE -> ALE-RESOURCE-CODE
ALE-ROLE
Accommitx ACCOMMITX
AAN-COMPANY -> MIX-RESOURCE-COMP
AAN-RESOURCE-TYPE -> MIX-RESOURCE-TYPE
AAN-RESOURCE-CODE -> MIX-RESOURCE-CODE
MIX-SYSTEM
MIX-TRANS-DATE
MIX-ACTIVITY-GRP
MIX-ACTIVITY
MIX-ACCT-CATEGORY
MIX-ATN-OBJ-ID
Acreshist ACRESHIST
AAN-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
AAN-ACTIVITY -> RSH-ACTIVITY
AAN-RESOURCE-TYPE -> RSH-RESOURCE-TYPE
RSH-RESOURCE-CODE
RSH-COMPANY
RSH-ROLE
RSH-FIELD-ID
RSH-SEQ-NUMBER
Histastasgn ACRESHIST
AAN-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
AAN-ACTIVITY -> RSH-ACTIVITY
AAN-RESOURCE-TYPE -> RSH-RESOURCE-TYPE
440 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histastrole ACRESHIST
AAN-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
AAN-ACTIVITY -> RSH-ACTIVITY
AAN-RESOURCE-TYPE -> RSH-RESOURCE-TYPE
441 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histempasgn ACRESHIST
AAN-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
AAN-ACTIVITY -> RSH-ACTIVITY
AAN-RESOURCE-TYPE -> RSH-RESOURCE-TYPE
420 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histemprole ACRESHIST
AAN-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
AAN-ACTIVITY -> RSH-ACTIVITY
AAN-RESOURCE-TYPE -> RSH-RESOURCE-TYPE
421 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histeqpasgn ACRESHIST
AAN-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
AAN-ACTIVITY -> RSH-ACTIVITY
AAN-RESOURCE-TYPE -> RSH-RESOURCE-TYPE
450 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histeqprole ACRESHIST
AAN-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
AAN-ACTIVITY -> RSH-ACTIVITY
AAN-RESOURCE-TYPE -> RSH-RESOURCE-TYPE
451 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histperasgn ACRESHIST
AAN-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
AAN-ACTIVITY -> RSH-ACTIVITY
AAN-RESOURCE-TYPE -> RSH-RESOURCE-TYPE
410 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histperrole ACRESHIST
AAN-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
AAN-ACTIVITY -> RSH-ACTIVITY
AAN-RESOURCE-TYPE -> RSH-RESOURCE-TYPE
411 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histvenasgn ACRESHIST
AAN-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
AAN-ACTIVITY -> RSH-ACTIVITY
AAN-RESOURCE-TYPE -> RSH-RESOURCE-TYPE
430 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
Histvenrole ACRESHIST
AAN-ACTIVITY-GRP -> RSH-ACTIVITY-GRP
AAN-ACTIVITY -> RSH-ACTIVITY
AAN-RESOURCE-TYPE -> RSH-RESOURCE-TYPE
431 -> RSH-FIELD-ID
RSH-COMPANY
RSH-RESOURCE-CODE
RSH-SEQ-NUMBER
|