...
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 |
Export Timesheets/Expenses to Lawson 7.2.2 Activity Transaction Relation File (ACTRANSREL)
DATABASICS exports timesheets/expenses to Lawson in two ways:
Direct link to ACTRANSREL: Databasics exports the data to the Lawson interface table directly either using ODBC or Native drivers.
File Export: Databasics exports the data to an ASCII file to be later imported into ACDBTRANS. This method is used when there is no direct connectivity to the Lawson database server.
ACTRANSREL
...
Field Type
and Length
...
Databasics Values
...
TRR-RUN-GROUP
Required
...
Run Group
...
Alpha
12 positions
...
A required key. A user-defined unique identifier used to group together a set of records to process selectively or concurrently.
Run Group and Sequence Number are the keys to the ACTRANSREL file. They should be used to group records for interfacing.
...
YYYYMMDDHHMM
...
TRR-SEQ-NUMBER
Required
...
Sequence Number
...
Numeric
6 positions
...
A required key. A user-defined unique identifier assigned to each transaction to be transferred into the Lawson system. If all other key fields are alike, this may be used so that no duplicates will occur.
...
Sequential Number
...
TRR-OLD-ACTIVITY
Required
...
Old Activity
...
Alpha
35 positions
...
A required key. This is the old activity or project structure to be associated with the Lawson activity. This is validated in AC29.1 (Activity Relationship) or AC10.1 (Activity).
...
Concatenation of WBS Level 2, 3 or 4
...
TRR-ACCT-CATEGORY
...
Account Category
...
Alpha
5 positions
...
A required key. Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity.
To associate the account category with an activity or activity group, the account category must be valid in the ACACCTCATX file.
...
Custom value
...
TRR-POSTING-DATE
Required
...
Posting Date
...
Numeric
8 positions
...
The date assigned to the journal entry that determines what period and year the transaction (journal entry) will reside in after completing the Transaction Conversion process.
...
Supplied Posting Date
...
TRR-SYSTEM
Required
...
System Code
...
Alpha
2 positions
...
The system code is a two-character code representing an application used within the Lawson system (i.e., GL = General Ledger, AP = Accounts Payable, etc.). It must be a valid system code in the GLCODES database file.
...
Default value ‘PR’
...
TRR-COMPANY
Required
...
Company
...
Numeric
4 positions
...
Company number. Required if billable, capital expense, or if the activity group “Accounting Unit Detail” field is set to Yes.
...
Operating Unit
OP_UNIT
...
TRR-ACCT-UNIT
Required
...
Accounting Unit
...
Alpha
15 positions
...
The accounting unit is a shorthand notation representing the variable level number. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit. Required if billable, capital expense, or if the activity group “Accounting Unit Detail” field is set to Yes.
...
Department
DEPT_CODE
...
TRR-ACCOUNT
Required
...
Account
...
Numeric
6 positions
...
This account field, the accounting unit and the subaccount make up the location where amounts and other account information are stored. Required if billable, capital expense, or if the activity group “Accounting Unit Detail” field is set to Yes.
...
User defined default value at the interface level
...
TRR-SUB-ACCOUNT
...
Subaccount
...
Numeric
4 positions
...
This subaccount field, the account unit, and the account make up the location where amounts and other account information are stored.
...
User defined default value at the interface level
...
TRR-DESCRIPTION
Required
...
Transaction Description
...
Alpha
30 positions (lower case)
...
Transaction description.
...
Last Name, First Name
...
TRR-REFERENCE
...
Reference
...
Alpha
10 positions (lower case)
...
Reference number associated with the transaction.
...
Space
...
TRR-UNITS-AMOUNT
Required
...
Units Amount
...
Signed
15 positions
(2 are decimals)
...
Units amount for the transaction. Required if TRR-STD-COST = Y.
...
Hours (VALUE)
...
TRR-TRAN-CURRENCY
Required
...
Transaction Currency
...
Alpha
5 positions
...
Currency for the transaction. Required if TRR-TRAN-AMOUNT is not equal to spaces. If left blank, the company description defaults.
...
Employee Currency
...
TRR-TRAN-AMOUNT
...
Transaction Amount
...
Signed
15 positions
(2 are decimals)
...
The amount in transaction currency to be posted.
...
Derived – Hours * Employee Cost Rate
...
TRR-TRAN-ND
...
Transaction Number of Decimals
...
Numeric
1 position
...
The defined number of decimal positions used for the transaction.
...
User defined default value at the interface level
...
TRR-RUN-DATE
...
Run date
...
Numeric
8 positions
...
The date the transaction was posted to the general ledger.
...
System Date MM/DD/YYYY
...
TRR-RUN-TIME
...
Run Time
...
Numeric
6 positions
...
The time the transaction was posted to the general ledger.
...
System time HHMM
...
TRR-SOURCE-CODE
Required
...
Source Code
...
Alpha
2 positions
...
Source code is a two-character code assigned to a transaction to identify where the transaction was created.
...
Default value ‘PW’
...
TRR-MATRIX-CAT-1
...
Attribute 1
...
Alpha
12 positions
...
Attribute name assigned to a transaction to track additional information.
Three attributes can be defined per source code.
...
Default value ‘BILLING_ROLE’
...
TRR-MATRIX-CAT-2
...
Attribute 2
...
Alpha
12 positions
...
Attribute name assigned to a transaction to track additional information.
Three attributes can be defined per source code
...
Space
...
TRR-MATRIX-CAT-3
...
Attribute 3
...
Alpha
12 positions
...
Attribute name assigned to a transaction to track additional information.
Three attributes can be defined per source code
...
Space
...
TRR-MX-VALUE-1
...
Attribute Value 1
...
Alpha
20 positions
...
The value for attribute 1.
Three attribute values can be defined per source code.
...
Function Code
...
TRR-MX-VALUE-2
...
Attribute Value 2
...
Alpha
20 positions
...
The value for attribute 2.
Three attribute values can be defined per source code.
...
Space
...
TRR-MX-VALUE-3
...
Attribute Value 3
...
Alpha
20 positions
...
The value for attribute 3.
Three attribute values can be defined per source code.
...
Space
...
TRR-RESOURCE-TYPE
...
Resource Type
...
Alpha
1 position
...
Type of resource associated with the transaction. Must be entered if TRR-STD-COST-FLAG = Y.
...
Default value ‘E’
...
TRR-RESOURCE-CODE
...
Resource Code
...
Alpha
10 positions
...
Resource code associated with the transaction. It must be a valid code in the ACASSIGN file.
Must be entered if TRR-STD-COST-FLAG=Y.
...
Employee Id
...
TRR-UNIT-MEASURE
...
Unit of Measure
...
Alpha
12 positions
...
Unit of measure for the transaction. Must be entered if TRR-STD-COST-FLAG=Y. It must be valid in ACUOM file.
...
Default value ‘HOURS’
...
TRR-STD-COST-FLAG
...
Standard Cost Flag
...
Alpha
1 position
...
Indicates whether standard cost is associated with the transaction. If set you Yes, the system searches for the standard cost assigned in the resource file first, then the resource class file, and lastly the resource.
If set to Yes, the amount field is zero. The system used the standard amount multiplied by the units to determine the transaction amount.
...
Default value ‘N’
...
TRR-BILLABLE-AMT
...
Billable Amount
...
Signed
15.2 positions
...
This field indicates the billable amount for the transaction.
...
Zero
...
TRR-BILLABLE-UNIT
...
Billable Unit
...
Signed
15.2 positions
...
This field indicated the billable units for the transaction.
...
Zero
...
TRR-SEGMENT-BLOCK
...
User Analysis Field
...
Alpha
103 positions
...
This field indicates the user analysis values included in the transaction.
...
space