ACTRANSREL – Activity Transaction Relation

System: Activity Management (AC)
Prefix: TRR
Primary key: RUN-GROUP, SEQ-NUMBER
Fields: 38
Updated by: 2 programs
Referenced by: 1 program

ACTRANSREL is the Activity Transaction Relation table in Lawson Activity Management (prefix TRR). It is indexed by RUN-GROUP, SEQ-NUMBER (TRRSET1); alternate indexes: TRRSET2. It is updated by AC54.1 and AC540 and referenced by AC29.1. The table has 38 fields, 2 indexes and 0 documented relations.

About ACTRANSREL

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.

Fields (38)

Column = COBOL field name without the TRR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`TRR-RUN-GROUP` PK 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` PK SEQ_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` 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` OLD_ACCT_CAT	Alpha 35	—	AC54.1
`TRR-POSTING-DATE` POSTING_DATE	Numeric 8 (yyyymmdd)	Required. This is the posting date assigned to the transaction.	AC54.1
`TRR-TRANS-DATE` TRANS_DATE	Numeric 8 (yyyymmdd)	The date of the transaction.	AC54.1
`TRR-SYSTEM` SYSTEM	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` COMPANY	Numeric 4	This is the company number for the transaction.	AC54.1
`TRR-ACCT-UNIT` ACCT_UNIT	Alpha 15	This is the accounting unit for the transaction.	AC54.1
`TRR-ACCOUNT` ACCOUNT	Numeric 6	This is the account for the transaction.	AC54.1
`TRR-SUB-ACCOUNT` SUB_ACCOUNT	Numeric 4	This is the subaccount for the transaction.	AC54.1
`TRR-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This is the transaction description.	AC54.1
`TRR-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	This is the reference number associated with the transaction.	AC54.1
`TRR-UNITS-AMOUNT` UNITS_AMOUNT	Signed 15.2	This is the units amount for the transaction.	AC54.1
`TRR-TRAN-CURRENCY` TRAN_CURRENCY	Alpha 5	This is the currency for the transaction.	AC54.1
`TRR-TRAN-AMOUNT` TRAN_AMOUNT	Signed 18.2	This is the amount in transaction currency.	AC54.1
`TRR-RUN-DATE` RUN_DATE	Numeric 8 (yyyymmdd)	This is the date the transaction was posted to the general ledger.	AC54.1
`TRR-RUN-TIME` RUN_TIME	Numeric 6 (hhmmss)	This is the time the transaction was posted to the general ledger.	AC54.1
`TRR-SOURCE-CODE` 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` MATRIX_CAT_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` MATRIX_CAT_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` MATRIX_CAT_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` MX_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` MX_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` MX_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` RESOURCE_TYPE	Alpha 1	This is the type of resource associated with the transaction.	AC54.1
`TRR-FROM-COMPANY` FROM_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` RESOURCE_CODE	Alpha 10	This is the resource code associated with the transaction.	AC54.1
`TRR-RESOURCE-DESC` RESOURCE_DESC	Alpha 30 (Lower Case)	This field displays the description.	AC54.1
`TRR-UNIT-MEASURE` UNIT_MEASURE	Alpha 12	This is the unit of measure for the transaction.	AC54.1
`TRR-STD-COST-FLAG` STD_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` SHORT_OLD_ACT	Derived	This is the short description for the old activity.	—
`TRR-BILLABLE-AMT` BILLABLE_AMT	Signed 18.2	This field indicates the billable amount for the transaction.	AC54.1
`TRR-BILLABLE-UNIT` BILLABLE_UNIT	Signed 15.2	This field indicates the number of billable units for the transaction.	AC54.1
`TRR-SEGMENT-BLOCK` 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` REVENUE_AMT	Signed 18.2	—	AC54.1
`TRR-AP-PAID` AP_PAID	Alpha 1	" " = Eligible for Billing `H` Hold for Billing	AC54.1
`TRR-COMMENTS-FLAG` COMMENTS_FLAG	Alpha 1	— `Y` Yes `N` No	—

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`TRRSET1`	`RUN-GROUP`, `SEQ-NUMBER`	Primary		AC54.1, AC540
`TRRSET2`	`OLD-ACTIVITY`, `RUN-GROUP`, `SEQ-NUMBER`	KeyChange		AC29.1, AC540

ACTRANSREL – Activity Transaction Relation

About ACTRANSREL

Fields (38)

Indexes (2)

Programs

Updated by (2)

Referenced by (1)