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
AC13.3 AC130 AC135 AC14.3 AC145 AC160
AC165 AC190 AC191 AC197 AC198 AC200
AC203 AC206 AC207 AC210 AC213 AC218
AC220 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 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 ACSB.1 ACVW.1 SE90.1 AP211 AR250
AR251 AR30.1 AR30.5 AR33.1 AR33.2 BR10.4
BR120 BR121 BR13.1 BR130 BR131 BR140
BR142 BR145 BR165 BR19.2 BR190 BR20.9
BR200 BR202 BR204 BR205 BR210 BR212
BR215 BR220 BR245 BR265 BR300 BR40.3
BR400 BR405 BR43.1 BR430 BR450 BR46.1
BR521 BR530 BR580 BRCC.1 BRIP.1 MX123
MX500 BR42.2 BR96.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 AR33.1
(Resource).
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-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-TO-COMPANY Numeric 4 AC03.2 AC03.3
Element: 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
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 AC500
additional information. Attribute AC520
values may then be used in selection and
sorting for report and analysis.
AAN-MX-VALUE Alpha 32 AC03.2 AC03.3
Element: Attribute ValuThe attribute value. AC03.4 AC03.5
AC03.6 AC500
AC520
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
AAN-END-DATE Numeric 8 (yyyymmdd) AC03.2 AC03.3
Element: Ending Date The end date for this effort period. AC03.4 AC03.5
AC03.6 AC500
AC520
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 AC10.1 AC105
COMPANY AC112 AC113
RESOURCE-TYPE AC120 AC121
RESOURCE-CODE AC123 AC13.3
AC130 AC135
AC14.3 AC145
AC160 AC165
AC190 AC191
AC197 AC198
AC200 AC203
AC206 AC207
AC210 AC213
AC218 AC220
AC240 AC246
...
AANSET3 COMPANY AC03.1 AC203
RESOURCE-CODE AC520 ACDL.1
RESOURCE-TYPE BR42.2 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
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
|