...
Employee is the lowest level of the Organization Structure and as noted above, Employees are assigned to one and only Department. This element is used to identify the actual users of the DATABASICS system. Lawson maps to DATABASICS’ employee through EMPLOYEEà EMPLOYEE--> ACDBEMPLY.
Vendor
DATABASCS’s Vendor identifies time and expense reports from employees of outside organizations who are working under contract. Rules and reports can be driven off of Vendor. Lawson 8.0.1 maps to DATABASICS’s Vendor through ACEMPVEN → ACDBEEVEN. Lawson interface does not support subcontractors or employees outside of an organization. The use of vendors for the Lawson 8.0.1 interface is strictly for paying internal employees via Accounts Payable.
Work Breakdown Structure
...
The standard interface supports these scenarios:
Scenario 1
Activity (the posting level) in Lawson mapping to DATABASICS WBS Level 1.
Account Category in Lawson mapping to DATABASICS WBS Level 2.
In this scenario, the Lawson HR Job Code and Shift Code can optionally be mapped to DATABASICS Level 3 and Level 4 respectively.
Scenario 2
Activity (levels 1 – 4) in Lawson mapping to DATABASICS WBS Level 1 – Level 4.
Account Category in Lawson mapping to DATABASICS WBS function.
Scenario 3
Activity (the posting level) in Lawson—varying levels and different activity groups—mapping to DATABASICS WBS Level 1 – Level 4.
Account Category in Lawson mapping to DATABASICS WBS function.
For both scenarios, Account Category is optional. The entry of the Account Category is determined by a flag on the Activity Group. If no Account Categories are interfaced to DATABASICS, the Account Category will default from the Employee Master (HR 11) when running the Lawson interface program AC542.
...
DATABASICS Table | 7.2.2 Lawson Table | 8.0.0.1 Lawson Table | 8.0.1 Lawson Table |
|
|
|
|
Operating Unit | GLSYSTEM | ACDBSYSTEM | ACDBSYSTEM |
Department | GLNAMES | ACDBNAMES | ACDBNAMES |
Main WBS | ACACTGRP | ACDBACTGRP | ACDBACTGRP |
Level 1 | ACACTIVITY | ACDBACTVY | ACDBLEVEL1 – ACDBLEVEL5 |
Level 2 | * | ACDBACTCAT | ACDBACTCAT |
Function Relation | * | ACDBBLRATE | ACDBBLRATE |
Assigned Function | ACASSIGN | ACDBASSIGN | ACDBASSIGN |
Location | * | ACDBPCLVL | ACDBLOCATE |
Employee | EMPLOYEE | ACDBEMPLY | ACDBEMPLY |
Pay Group | PRPAYCODE | ACDBPYCLS | ACDBPYCLS |
Pay Code | PRPAYCODE | ACDBPYCLSX | ACDBPYCLSX |
Pay Code Assign | PRPAYCODE | ACDBPAYCD | ACDBPAYCD |
Vacation/Sick Balances | * | ACDBTABAL | ACDBTABAL |
Time Records | ACTRANSREL | ACTRANSREL | ACDBTRANS |