Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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