Export Timesheets/Expenses to Lawson 7.x.x 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 |
| Databasics Values |
TRR-RUN-GROUP | Run Group | Alpha | 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 | Sequence Number | Numeric | 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 | Old Activity | Alpha | 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 | 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 | Posting Date | Numeric | 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 | System Code | Alpha | 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 | Company | Numeric | 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 | Accounting Unit | Alpha | 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 | Account | Numeric | 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 | 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 | Transaction Description | Alpha | Transaction description. | Last Name, First Name |
TRR-REFERENCE | Reference | Alpha | Reference number associated with the transaction. | Space |
TRR-UNITS-AMOUNT | Units Amount | Signed | Units amount for the transaction. Required if TRR-STD-COST = Y. | Hours (VALUE) |
TRR-TRAN-CURRENCY | Transaction Currency | Alpha | 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 | The amount in transaction currency to be posted. | Derived – Hours * Employee Cost Rate |
TRR-TRAN-ND | Transaction Number of Decimals | Numeric | The defined number of decimal positions used for the transaction. | User defined default value at the interface level |
TRR-RUN-DATE | Run date | Numeric | The date the transaction was posted to the general ledger. | System Date MM/DD/YYYY |
TRR-RUN-TIME | Run Time | Numeric | The time the transaction was posted to the general ledger. | System time HHMM |
TRR-SOURCE-CODE | Source Code | Alpha | 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 | 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 | 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 | 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 | The value for attribute 1. Three attribute values can be defined per source code. | Function Code |
TRR-MX-VALUE-2 | Attribute Value 2 | Alpha | The value for attribute 2. Three attribute values can be defined per source code. | Space |
TRR-MX-VALUE-3 | Attribute Value 3 | Alpha | The value for attribute 3. Three attribute values can be defined per source code. | Space |
TRR-RESOURCE-TYPE | Resource Type | Alpha | 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 | 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 | 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 | 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 | This field indicates the billable amount for the transaction. | Zero |
TRR-BILLABLE-UNIT | Billable Unit | Signed | This field indicated the billable units for the transaction. | Zero |
TRR-SEGMENT-BLOCK | User Analysis Field | Alpha | This field indicates the user analysis values included in the transaction. | space |