|
|
ACTRANSREL FILE
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
AC310 AC54.1 AC540
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRR-RUN-GROUP Alpha 15 AC54.1
Element: Run Group Required. Run Group and Sequence Number
are the keys to the file. They should be
used to group records together for
interfacing.
TRR-SEQ-NUMBER Numeric 6 AC54.1
Element: Sequence NumbeRequired. The Sequence number is a
unique number assigned to each
transaction to be transferred into the
Lawson system.
TRR-OLD-ACTIVITY Alpha 35 AC54.1
Element: Old Activity 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.
TRR-OLD-ACCT-CAT Alpha 35 AC54.1
Element: Old Acct Cat
TRR-POSTING-DATE Numeric 8 (yyyymmdd) AC54.1
Element: Posting Date Required. This is the posting date
assigned to the transaction.
TRR-TRANS-DATE Numeric 8 (yyyymmdd) AC54.1
Element: Trans Date The date of the transaction.
TRR-SYSTEM Alpha 2 AC54.1
Element: System Code 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.)
TRR-COMPANY Numeric 4 AC54.1
Element: Company This is the company number for the
transaction.
TRR-ACCT-UNIT Alpha 15 AC54.1
Element: Accounting UniThis is the accounting unit for the
transaction.
TRR-ACCOUNT Numeric 6 AC54.1
Element: Account This is the account for the
transaction.
TRR-SUB-ACCOUNT Numeric 4 AC54.1
Element: Subaccount This is the subaccount for the
transaction.
TRR-DESCRIPTION Alpha 30 (Lower Case) AC54.1
Transaction This is the transaction description.
Description
TRR-REFERENCE Alpha 10 (Lower Case) AC54.1
Element: Reference This is the reference number associated
with the transaction.
TRR-UNITS-AMOUNT Signed 15.2 AC54.1
Element: Units Amount This is the units amount for the
transaction.
TRR-TRAN-CURRENCY Alpha 5 AC54.1
Element: Transaction CuThis is the currency for the
transaction.
TRR-TRAN-AMOUNT Signed 18.2 AC54.1
Element: Transaction AmThis is the amount in transaction
currency.
TRR-RUN-DATE Numeric 8 (yyyymmdd) AC54.1
Element: Run Date This is the date the transaction was
posted to the general ledger.
TRR-RUN-TIME Numeric 6 (hhmmss) AC54.1
Element: Run Time This is the time the transaction was
posted to the general ledger.
TRR-SOURCE-CODE Alpha 2 AC54.1
Element: Source Code 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.
TRR-MATRIX-CAT-1 Alpha 12 AC54.1
Element: Attribute 1 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.
TRR-MATRIX-CAT-2 Alpha 12 AC54.1
Element: Attribute 2 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.
TRR-MATRIX-CAT-3 Alpha 12 AC54.1
Element: Attribute 3 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.
TRR-MX-VALUE-1 Alpha 32 AC54.1
Element: Attribute ValuThis is the value for attribute 1.
Attribute values can be used in
selection and sorting for reporting and
analysis.
TRR-MX-VALUE-2 Alpha 32 AC54.1
Element: Attribute ValuThis is the value for attribute 2.
Attribute values can be used in
selection and sorting for reporting and
analysis.
TRR-MX-VALUE-3 Alpha 32 AC54.1
Element: Attribute ValuThis is the value for attribute 3.
Attribute values can be used in
selection and sorting for reporting and
analysis.
TRR-RESOURCE-TYPE Alpha 1 AC54.1
Element: Resource Type This is the type of resource associated
with the transaction.
TRR-FROM-COMPANY Numeric 4 AC54.1
Element: Company This is the from company used for the GL
transaction. This is also the resource
company if the resource is type V or E.
TRR-RESOURCE-CODE Alpha 10 AC54.1
Element: Resource Code This is the resource code associated
with the transaction.
TRR-RESOURCE-DESC Alpha 30 (Lower Case) AC54.1
Element: Description This field displays the description.
TRR-UNIT-MEASURE Alpha 12 AC54.1
Element: Unit of MeasurThis is the unit of measure for the
transaction.
TRR-STD-COST-FLAG Alpha 1 AC54.1
Element: Standard Cost This field indicates whether standard
cost is associated with the transaction.
Y = Yes
N = No
TRR-SHORT-OLD-ACT Derived
Old Activity Short This is the short description for the
Description old activity.
TRR-BILLABLE-AMT Signed 18.2 AC54.1
Element: Intl Amt This field indicates the billable
amount for the transaction.
TRR-BILLABLE-UNIT Signed 15.2 AC54.1
Element: Billable Unit This field indicates the number of
billable units for the transaction.
TRR-SEGMENT-BLOCK Alpha 103 AC54.1
Element: Segment Block 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.
TRR-REVENUE-AMT Signed 18.2 AC54.1
Element: Intl Amt
TRR-AP-PAID Alpha 1 AC54.1
Element: Ap Paid " " = Eligible for Billing
H = Hold for Billing
TRR-COMMENTS-FLAG Alpha 1
Element: Flag Y = Yes
N = No
ACTRANSREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRRSET1 RUN-GROUP AC54.1 AC540
SEQ-NUMBER
TRRSET2 OLD-ACTIVITY KeyChange AC29.1 AC310
RUN-GROUP AC540
SEQ-NUMBER
|
