Activity Transaction Relation

This file is used in conversion of non-Lawson activity transactions to the Lawson Activity Management system. It includes the Run Group and Sequence Number fields, which organize transaction records for conversion and interfacing. The field Old Activity links the old system and its transactions with the Lawson Activity Management system.

REFERENCED BY

AC29.1

UPDATED BY

AC54.1

AC540

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
TRR-RUN-GROUP Element: Run Group	Alpha 15 Required. Run Group and Sequence Number are the keys to the file. They should be used to group records together for interfacing.	AC54.1
TRR-SEQ-NUMBER Element: Sequence Number	Numeric 6 Required. The Sequence number is a unique number assigned to each transaction to be transferred into the Lawson system.	AC54.1
TRR-OLD-ACTIVITY Element: Old Activity	Alpha 35 Required. This is the old activity or project, to be associated with a new activity. If you are not upgrading and want to interface data on a regular basis, you can enter a valid activity in this field.	AC54.1
TRR-OLD-ACCT-CAT Element: Old Acct Cat	Alpha 35	AC54.1
TRR-POSTING-DATE Element: Posting Date	Numeric 8 (yyyymmdd) Required. This is the posting date assigned to the transaction.	AC54.1
TRR-TRANS-DATE Element: Trans Date	Numeric 8 (yyyymmdd) The date of the transaction.	AC54.1
TRR-SYSTEM Element: System Code	Alpha 2 Required. This is the system code for the transaction. 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.)	AC54.1
TRR-COMPANY Element: Company	Numeric 4 This is the company number for the transaction.	AC54.1
TRR-ACCT-UNIT Element: Accounting Unit	Alpha 15 This is the accounting unit for the transaction.	AC54.1
TRR-ACCOUNT Element: Account	Numeric 6 This is the account for the transaction.	AC54.1
TRR-SUB-ACCOUNT Element: Subaccount	Numeric 4 This is the subaccount for the transaction.	AC54.1
TRR-DESCRIPTION Transaction Description	Alpha 30 (Lower Case) This is the transaction description.	AC54.1
TRR-REFERENCE Element: Reference	Alpha 10 (Lower Case) This is the reference number associated with the transaction.	AC54.1
TRR-UNITS-AMOUNT Element: Units Amount	Signed 15.2 This is the units amount for the transaction.	AC54.1
TRR-TRAN-CURRENCY Element: Transaction Currency	Alpha 5 This is the currency for the transaction.	AC54.1
TRR-TRAN-AMOUNT Element: Transaction Amount	Signed 18.2 This is the amount in transaction currency.	AC54.1
TRR-RUN-DATE Element: Run Date	Numeric 8 (yyyymmdd) This is the date the transaction was posted to the general ledger.	AC54.1
TRR-RUN-TIME Element: Run Time	Numeric 6 (hhmmss) This is the time the transaction was posted to the general ledger.	AC54.1
TRR-SOURCE-CODE Element: Source Code	Alpha 2 This is the source code for the transaction. A source code is a two-character code assigned to a transaction to identify where the transaction was created.	AC54.1
TRR-MATRIX-CAT-1 Element: Attribute 1	Alpha 12 This is an attribute name assigned to a transaction to track additional information. Attribute values can then be selected and sorted for reporting and analysis. Three attributes can be defined per source code.	AC54.1
TRR-MATRIX-CAT-2 Element: Attribute 2	Alpha 12 This is an attribute name assigned to a transaction to track additional information. Attribute values can then be selected and sorted for reporting and analysis. Three attributes can be defined per source code.	AC54.1
TRR-MATRIX-CAT-3 Element: Attribute 3	Alpha 12 This is an attribute name assigned to a transaction to track additional information. Attribute values can then be selected and sorted for reporting and analysis. Three attributes can be defined per source code.	AC54.1
TRR-MX-VALUE-1 Element: Attribute Value 1	Alpha 32 This is the value for attribute 1. Attribute values can be used in selection and sorting for reporting and analysis.	AC54.1
TRR-MX-VALUE-2 Element: Attribute Value 2	Alpha 32 This is the value for attribute 2. Attribute values can be used in selection and sorting for reporting and analysis.	AC54.1
TRR-MX-VALUE-3 Element: Attribute Value 3	Alpha 32 This is the value for attribute 3. Attribute values can be used in selection and sorting for reporting and analysis.	AC54.1
TRR-RESOURCE-TYPE Element: Resource Type	Alpha 1 This is the type of resource associated with the transaction.	AC54.1
TRR-FROM-COMPANY Element: Company	Numeric 4 This is the from company used for the GL transaction. This is also the resource company if the resource is type V or E.	AC54.1
TRR-RESOURCE-CODE Element: Resource Code	Alpha 10 This is the resource code associated with the transaction.	AC54.1
TRR-RESOURCE-DESC Element: Description	Alpha 30 (Lower Case) This field displays the description.	AC54.1
TRR-UNIT-MEASURE Element: Unit of Measure	Alpha 12 This is the unit of measure for the transaction.	AC54.1
TRR-STD-COST-FLAG Element: Standard Cost Flag	Alpha 1 This field indicates whether standard cost is associated with the transaction. Y = Yes N = No	AC54.1
TRR-SHORT-OLD-ACT Old Activity Short Description	Derived This is the short description for the old activity.
TRR-BILLABLE-AMT Element: Intl Amt	Signed 18.2 This field indicates the billable amount for the transaction.	AC54.1
TRR-BILLABLE-UNIT Element: Billable Unit	Signed 15.2 This field indicates the number of billable units for the transaction.	AC54.1
TRR-SEGMENT-BLOCK Element: Segment Block	Alpha 103 This field identifies the user analysis values included in the transaction. You can either type up to four values or use Define (F6) to open the User Analysis Entry subform. Use this subform to select the user analysis values you want to include in the transaction. If you choose to type values, use commas to separate them. For example: value1,value2,value3,value4 There are three conditions that affect how you can select user analysis values. See the User Analysis Entry form help or the Strategic Ledger procedures manual for additional information.	AC54.1
TRR-REVENUE-AMT Element: Intl Amt	Signed 18.2	AC54.1
TRR-AP-PAID Element: Ap Paid	Alpha 1 " " = Eligible for Billing H = Hold for Billing	AC54.1
TRR-COMMENTS-FLAG Element: Flag	Alpha 1 Y = Yes N = No

ACTRANSREL FILE INDEX

All trademarks and registered trademarks are the property of their respective owners.