Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

                              ACTRANS FILE

                          Activity Transaction

This file contains the detail records for transactions posted to activities
in the Activity Management system (status 9). It also contains unreleased
transactions created in Activity Management (status 0) and transactions
released from subsystems (status 1).

This file can be listed by running AC290 (Transaction Detail).

REFERENCED BY

AC00.1    AC10.1    AC112     AC12.1    AC256     AC50.1
AC720     AC295     AC297     AC90.2    AC90.4    AC90.6
AC90.8    AC95.2    AC95.4    AC95.6    AC97.2    AC97.4
AC97.6    ACVW.1    SE90.1    BR450     AC06.1    AC240
AC61.1    AC96.1    AC96.2    BR10.1    ACAC.1    ACDL.1
BR430     BRIP.1    AC290     AC440     AC460     AC471
AC490

UPDATED BY

AC120     AC131     AC160     AC170     AC190     AC191
AC195     AC196     AC198     AC300     AC310     AC40.1
AC40.4    AC41.1    AC41.4    AC42.1    AC45.1    AC45.4
AC530     AC540     AC542     AC581     AC742     ACDR.1
GR742     BR120     BR142     BR21.1    BR40.3    BR40.4
BR41.1    BR42.1    GL146     GL190     GL199     GL45.1
IFGT.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ATN-ACTIVITY-GRP     Alpha 15                                    AC120   AC131
Activity Group       Required key. This is the activity          AC170   AC190
                     group for the transaction.                  AC196   AC198
                                                                 AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-CONTROL-GROUP    Numeric 8                                   AC131   AC310
Control Group        Required key. This field indicates the      AC40.1  AC40.4
                     control group number used for process       AC41.1  AC41.4
                     control of the activity transactions.       AC42.1  AC530
                                                                 GL199   IFGT.1

ATN-SEQUENCE-NBR     Numeric 4                                   AC131   AC310
Sequence Number      Required key. This user-assigned            AC40.1  AC40.4
                     sequence number is used to keep the         AC41.1  AC41.4
                     records unique and to determine order.      AC42.1  AC530
                                                                 GL199   IFGT.1

ATN-OBJ-ID           Numeric 12                                  AC131   AC170
Object Identifier    Required key. This is the object            AC190   AC196
                     identifier. It is used to relate            AC198   AC310
                     commitments or posted transactions back     AC40.1  AC40.4
                     to the originating subsystems. Each         AC41.1  AC41.4
                     subsystem record that is updated as a       AC42.1  AC530
                     commitment or posted transaction is         AC540   AC542
                     assigned an object identifier. The          AC742   BR40.3
                     object identifier is maintained in the      BR40.4  BR41.1
                     subsystem files and in the Activity         GL146   GL190
                     Commitments Detail and Activity             GL199   GL45.1
                     Transaction files. The object identifier    GR742   IFGT.1
                     is a unique key generated by the system
                     and used to drill back from Activity
                     Management to the subsystems.

ATN-TRANS-TYPE       Alpha 1                                     AC131   AC170
Transaction Type     This field determines if amounts or         AC310   AC40.1
                     units are processed in the transaction.     AC40.4  AC41.1
                     A = Activity Management Only                AC41.4  AC42.1
                     B = AC side of AC and GL trans              AC530   AC540
                     I = Interface                               AC542   AC742
                     G = GL side of AC and GL trans              GL199   GR742
                     T = Time Entry                              IFGT.1

ATN-COMPANY          Numeric 4                                   AC131   AC170
Company              This is the responsible company.            AC190   AC196
                                                                 AC198   AC310
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-FROM-COMPANY     Numeric 4                                   AC131   AC190
From Company         This is the company that is the source      AC196   AC198
                     of the items.                               AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC530   AC540
                                                                 AC542   AC742
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-TRAN-DATE        Numeric 8  (yyyymmdd)                       AC131   AC190
Transaction Date     This is the date the transaction is         AC196   AC198
                     posted.                                     AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC530   AC540
                                                                 AC542   AC742
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-ACTIVITY         Alpha 15                                    AC131   AC170
Activity             This is the activity for the                AC190   AC196
                     transaction.                                AC198   AC310
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.1
                                                                 AC530   AC540
                                                                 AC542   AC742
                                                                 BR40.3  BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-VAR-LEVELS       Alpha 30                                    AC120   AC131
Variable Levels      This is the variable level for the          AC170   AC190
                     transaction.                                AC196   AC198
                                                                 AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-STATUS           Numeric 1                                   AC131   AC170
Status               The transaction status tells whether        AC190   AC196
                     the transaction is released (these are      AC198   AC310
                     considered commitments), unreleased, or     AC40.1  AC40.4
                     posted.                                     AC41.1  AC41.4
                     0 = Unreleased                              AC42.1  AC45.1
                     1 = Released                                AC45.4  AC530
                     9 = Posted                                  AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR40.4  BR41.1
                                                                 GL146   GL190
                                                                 GL199   GL45.1
                                                                 GR742   IFGT.1

ATN-ACCT-CATEGORY    Alpha 5                                     AC131   AC170
Account Category     This is the account category for the        AC190   AC196
                     transaction.                                AC198   AC310
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.1
                                                                 AC530   AC540
                                                                 AC542   AC742
                                                                 BR40.3  BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-POSTING-DATE     Numeric 8  (yyyymmdd)                       AC131   AC170
Posting Date         For an Activity Management transaction,     AC190   AC195
                     this is the date the transaction was        AC196   AC198
                     posted to the Activity Transaction file.    AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC530   AC540
                                                                 AC542   AC742
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-SYSTEM           Alpha 2                                     AC131   AC170
System Code          This is the system in which this            AC190   AC196
                     transaction originated.                     AC198   AC310
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-ACCT-UNIT        Alpha 15                                    AC131   AC170
Accounting Unit      This is the general ledger accounting       AC190   AC196
                     unit for the transaction.                   AC198   AC310
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-ACCOUNT          Numeric 6                                   AC131   AC170
Account              This field along with the accounting        AC190   AC196
                     unit and subaccount make up the location    AC198   AC310
                     (account) where amounts and other           AC40.1  AC40.4
                     account information is stored.              AC41.1  AC41.4
                                                                 AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-SUB-ACCOUNT      Numeric 4                                   AC131   AC190
Subaccount           This is the general ledger subaccount       AC196   AC198
                     for the transaction.                        AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC530   AC540
                                                                 AC542   AC742
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-DESCRIPTION      Alpha 30  (Lower Case)                      AC131   AC170
Transaction          This is the description of the              AC190   AC198
Description          transaction.                                AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-REFERENCE        Alpha 10  (Lower Case)                      AC131   AC170
Reference            This is the reference for this              AC196   AC310
                     transaction.                                AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR40.4  BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-UNITS-AMOUNT     Signed 15.2                                 AC131   AC170
Units Amount         This is the units amount for this           AC196   AC310
                     transaction.                                AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.1
                                                                 AC530   AC540
                                                                 AC542   AC742
                                                                 BR40.3  BR40.4
                                                                 GL199   GL45.1
                                                                 GR742   IFGT.1

ATN-TRAN-CURRENCY    Alpha 5                                     AC131   AC190
Transaction Currency This is the currency for the                AC196   AC198
                     transaction.                                AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC530   AC540
                                                                 AC542   AC742
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-TRAN-AMOUNT      Signed 15.2                                 AC131   AC170
Transaction Amount   This is the amount in transaction           AC190   AC196
                     currency.                                   AC198   AC310
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR40.4  BR41.1
                                                                 GL199   GL45.1
                                                                 GR742   IFGT.1

ATN-TRAN-ND          Numeric 1                                   AC131   AC190
Transaction Number   This field indicates the defined number     AC196   AC198
of Decimals          of decimal positions used for the           AC310   AC40.1
                     transaction.                                AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC530   AC540
                                                                 AC542   AC742
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-ACT-CURRENCY     Alpha 5                                     AC131   AC190
Activity Currency    This is the activity currency.              AC196   AC198
                                                                 AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC530   AC540
                                                                 AC542   AC742
                                                                 BR40.3  BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-ACT-BASERATE     Signed 12.6                                 AC131   AC190
Activity Base Rate   This is the rate that converts the          AC196   AC198
                     transaction amount to the activity          AC310   AC40.1
                     amount.                                     AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-ACT-AMOUNT       Signed 15.2                                 AC131   AC190
Activity Amount      This is the amount for the activity.        AC196   AC198
                                                                 AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR40.4  BR41.1
                                                                 GL199   GL45.1
                                                                 GR742   IFGT.1

ATN-ACT-ND           Numeric 1                                   AC131   AC190
Activity Number of   This is the number of decimals for the      AC196   AC198
Decimals             activity.                                   AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-AG-CURRENCY      Alpha 5                                     AC131   AC190
Activity Group       This is the currency for the activity       AC196   AC198
Currency             group.                                      AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-AG-BASERATE      Signed 12.6                                 AC131   AC190
Activity Group Base  This is the rate that converts the          AC196   AC198
Rate                 transaction amount to the activity group    AC310   AC40.1
                     amount.                                     AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-AG-AMOUNT        Signed 15.2                                 AC131   AC190
Activity Group       This is the amount for the activity         AC196   AC198
Amount               group for this transaction.                 AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR40.4  BR41.1
                                                                 GL199   GL45.1
                                                                 GR742   IFGT.1

ATN-AG-ND            Numeric 1                                   AC131   AC190
Activity Group Nbr   This is the number of decimals for the      AC196   AC198
of Decimals          activity group.                             AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-BILL-DATE        Numeric 8  (yyyymmdd)                       AC196   AC310
Billing Date         This is the date the transaction was        AC40.1  AC40.4
                     billed.                                     AC41.1  AC41.4
                                                                 AC42.1  BR120
                                                                 BR40.3  GL199

ATN-RUN-DATE         Numeric 8  (yyyymmdd)                       AC131   AC190
Run Date             This is the date the transaction was        AC198   AC310
                     posted to the general ledger.               AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.4
                                                                 AC530   AC540
                                                                 AC542   AC742
                                                                 BR40.3  BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-RUN-TIME         Numeric 6  (hhmmss)                         AC131   AC190
Run Time             This is the time the transaction was        AC198   AC310
                     posted to the general ledger.               AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.4
                                                                 AC530   AC540
                                                                 AC542   AC742
                                                                 BR40.3  BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-SOURCE-CODE      Alpha 2                                     AC131   AC170
Source Code          This is the source code for the             AC190   AC196
                     transaction. This value defaults from       AC198   AC310
                     the program the user uses to enter a        AC40.1  AC40.4
                     journal entry. This value is not            AC41.1  AC41.4
                     necessarily the same as the system ID.      AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 BR40.4  BR41.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-BILL-RATE        Signed 13.4                                 AC131   AC170
Billing Rate         This is the billing rate for the            AC190   AC310
                     transaction.                                AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.1
                                                                 BR40.4  GL199

ATN-BILLABLE         Alpha 1                                     AC131   AC190
Billable             This field indicates whether the            AC196   AC198
                     transaction is billable, on hold, a         AC310   AC40.1
                     write-off, or a transfer.                   AC40.4  AC41.1
                     Y = Yes                                     AC41.4  AC42.1
                     N = No                                      AC45.1  BR142
                     H = Hold                                    BR40.3  BR40.4
                                                                 BR41.1  BR42.1
                                                                 GL199

ATN-BILLED           Alpha 1                                     AC131   AC190
Billed               This field indicates whether the            AC196   AC198
                     transaction has been billed.                AC310   AC40.1
                     Y = Yes                                     AC40.4  AC41.1
                     N = No                                      AC41.4  AC42.1
                     H = Hold                                    BR120   BR142
                     E = Exceeded ceiling                        BR21.1  BR41.1
                                                                 BR42.1  GL199

ATN-BILLABLE-AMT     Signed 15.2                                 AC131   AC190
Billable Amount      This is the billable amount for the         AC196   AC198
                     transaction.                                AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC540
                                                                 AC542   AC742
                                                                 BR40.4  GL146
                                                                 GL190   GL199
                                                                 GL45.1  GR742

ATN-BILLABLE-UNIT    Signed 15.2                                 AC131   AC190
Billable Units       This is the number of billable units        AC196   AC310
                     for the transaction.                        AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC45.1
                                                                 AC540   AC542
                                                                 AC742   GL146
                                                                 GL190   GL199
                                                                 GL45.1  GR742

ATN-OVERRIDE-FLAG    Alpha 1                                     AC190   AC198
Override Flag        This field determines whether billing       AC41.1  AC41.4
                     amounts are calculated or not. This flag    AC42.1  AC540
                     is set to Yes if the billing amount or      AC742   GL199
                     billing units values are defined for        GR742
                     this transaction by the client versus
                     being calculated by the billing
                     programs. If this flag is Yes, the
                     billing amount and unit will not be
                     initialized if the transaction is backed
                     out.

                     The default is Blank, which also means
                     No.
                     Y = Yes - Bill amts overridden
                     N = No - Bill amts calculated

ATN-REVENUE-FLAG     Alpha 1                                     AC131   AC190
Revenue Flag         This flag indicates whether revenue has     AC196   AC198
                     been recognized for the transaction.        AC310   AC40.1
                                                                 AC40.4  AC41.1
                     Valid values are                            AC41.4  AC42.1
                                                                 BR142   BR41.1
                     Y = Yes                                     BR42.1  GL199
                     N = No
                     H = Hold
                     E = Exceeded ceiling

ATN-CAPITALIZE-FLG   Alpha 1                                     AC131   AC160
Capitalization Flag  This flag indicates whether the             AC190   AC196
                     transaction has been capitalized.           AC198   AC310
                                                                 AC40.1  AC40.4
                     Use Yes if the transaction has been         AC41.1  AC41.4
                     capitalized. Use No if the transaction      AC42.1  BR41.1
                     has not been capitalized.                   GL199

ATN-MATRIX-CAT       Alpha 12                                    AC131   AC190
Attribute            Activity attributes can be assigned to      AC196   AC198
                     transaction objects to define additional    AC310   AC40.1
                     categories of information for reporting     AC40.4  AC41.1
                     and processing. You can assign three        AC41.4  AC42.1
                     user-defined attributes per source code.    AC45.1  BR40.3
                                                                 GL199

ATN-MX-VALUE         Alpha 32                                    AC131   AC190
Attribute Value      This is an attribute value assigned to      AC196   AC198
                     a transaction to track additional           AC310   AC40.1
                     information. Attribute values can then      AC40.4  AC41.1
                     be used in selection and sorting for        AC41.4  AC42.1
                     reporting and analysis.                     AC45.1  BR40.3
                                                                 GL199

ATN-RESOURCE-TYPE    Alpha 1                                     AC131   AC170
Resource Type        This field indicates the type of the        AC190   AC196
                     resource associated with the                AC198   AC310
                     transaction.                                AC40.1  AC40.4
                     E = PR Employee                             AC41.1  AC41.4
                     V = AP/EE Vendor                            AC42.1  AC530
                     A = AM Asset                                AC540   AC542
                     P = Person                                  AC742   BR40.3
                     Q = Equipment                               GL199   GR742
                                                                 IFGT.1

ATN-RESOURCE-CODE    Alpha 10                                    AC131   AC170
Resource Code        This is the resource code associated        AC190   AC196
                     with the transaction.                       AC198   AC310
                                                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-RESOURCE-DESC    Alpha 30  (Lower Case)                      AC170   AC190
Resource Desc                                                    AC191   AC196
                                                                 AC198   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC540   AC542
                                                                 AC742   BR40.3
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-UNIT-MEASURE     Alpha 12                                    AC131   AC170
Unit of Measure      This is the unit of measure for the         AC196   AC310
                     transaction.                                AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC540
                                                                 AC542   AC742
                                                                 BR40.3  GL199
                                                                 GR742

ATN-COMMENT-CD       Numeric 3                                   GL199
Comment Code         This is the number representing a
                     comment relating to the transaction.

ATN-GLT-OBJ-ID       Numeric 12                                  AC190   GL199
Subsystem GL         This is a subsystem-General Ledger          IFGT.1
Interface ID         interface identification number. It is
                     used for Drill Around purposes.

ATN-PERIOD           Numeric 2                                   AC131   AC190
Period               This is the period for the transaction.     AC196   AC198
                                                                 AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   ACDR.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-FISCAL-YEAR      Numeric 4                                   AC131   AC190
Year                 This is the fiscal year for the             AC196   AC198
                     transaction.                                AC310   AC40.1
                                                                 AC40.4  AC41.1
                                                                 AC41.4  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC542
                                                                 AC742   ACDR.1
                                                                 GL199   GR742
                                                                 IFGT.1

ATN-AC191-UPDATED.html">AC191-UPDATED    Alpha 1                                     AC190   AC191
AC191 Updated        This field indicates whether the            AC196   AC198
                     transaction has been updated to the         AC40.1  AC40.4
                     Activity GL Accounting Unit Master          AC41.1  AC41.4
                     header and detail files. If the             AC42.1  BR41.1
                     transaction has been added, this value      GL199
                     is Yes. If the transaction has not been
                     added, this value is No.
                     Y = Yes

ATN-RECONCILED       Alpha 1                                     AC190   AC196
Reconciled           This flag is set to Yes when the            AC198   AC40.1
                     payroll transaction has been reconciled     AC40.4  AC41.1
                     by AC196 (Activity Payroll                  AC41.4  AC42.1
                     Reconciliation). Before the transaction     BR41.1  GL199
                     is reconciled, the value in this field
                     is No.
                     Y = Yes
                     N = No

ATN-SEGMENT-FLAG     Alpha 1                                     AC190   AC198
Segment Flag         Y = Yes                                     AC40.1  AC40.4
                     N = No                                      AC41.1  AC41.4
                                                                 AC42.1  GL199

ATN-RPT-AMOUNT-1     Signed 15.2                                 AC131   AC190
Report Currency 1    The transaction amount for Report           AC196   AC198
Amount               Currency 1.                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC581   AC742
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-RPT-RATE-1       Signed 12.6                                 AC131   AC190
Rpt Rate 1           The exchange rate to convert the            AC196   AC198
                     transaction amount to Report Currency 1.    AC40.1  AC40.4
                     The exchange rate is defined in CU10.1      AC41.1  AC41.4
                     (Exchange Rate).                            AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC581   AC742
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-RPT-ND-1         Numeric 1                                   AC131   AC190
Rpt Nd 1             The number of decimal positions for         AC196   AC198
                     Report Currency 1.                          AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC581   AC742
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-RPT-AMOUNT-2     Signed 15.2                                 AC131   AC190
Report Currency 2    The transaction amount for Report           AC196   AC198
Amount               Currency 2.                                 AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC581   AC742
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-RPT-RATE-2       Signed 12.6                                 AC131   AC190
Rpt Rate 2           The exchange rate to convert the            AC196   AC198
                     transaction amount to Report Currency 2.    AC40.1  AC40.4
                     The exchange rate is defined in CU10.1      AC41.1  AC41.4
                     (Exchange Rate).                            AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC581   AC742
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-RPT-ND-2         Numeric 1                                   AC131   AC190
Rpt Nd 2             The number of decimal positions for         AC196   AC198
                     Report Currency 2.                          AC40.1  AC40.4
                                                                 AC41.1  AC41.4
                                                                 AC42.1  AC530
                                                                 AC540   AC542
                                                                 AC581   AC742
                                                                 BR41.1  GL199
                                                                 GR742   IFGT.1

ATN-BRDN-ORG-OBJID   Numeric 12                                  AC190
Brdn Org Objid

ATN-ORIG-OBJ-ID      Numeric 12                                  AC542   AC742
Orig Obj Id                                                      GR742

ATN-BILLED-AMT       Signed 15.2
Billed Amt

ATN-REVENUE-AMT      Signed 15.2                                 AC190   AC198
Revenue Amt                                                      AC540

ATN-EXPENSE-CODE     Alpha 20                                    AC542
Expense Code

ATN-REBILL-AMT       Signed 15.2
Rebill Amt

                         ACTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATNSET1   ACTIVITY-GRP                                           AC00.1  AC10.1
          ACTIVITY                                               AC112   AC12.1
          ACCT-CATEGORY                                          AC120   AC160
          COMPANY                                                AC170   AC190
          ACCT-UNIT                                              AC191   AC195
          ACCOUNT                                                AC196   AC256
          SUB-ACCOUNT                                            AC300   AC310
          OBJ-ID                                                 AC45.1  AC50.1
                                                                 AC581   AC720

ATNSET10  ACTIVITY-GRP  KeyChange, Subset                        AC295   AC297
          VAR-LEVELS    Where (STATUS != Zeroes )                AC90.2  AC90.4
          STATUS                                                 AC90.6  AC90.8
          ACCT-CATEGORY                                          AC95.2  AC95.4
          FISCAL-YEAR                                            AC95.6  AC97.2
          PERIOD                                                 AC97.4  AC97.6
          OBJ-ID                                                 ACVW.1  SE90.1

ATNSET11  ACCT-CATEGORY KeyChange, Subset
          OBJ-ID        Where (STATUS = 1 )

ATNSET12  OBJ-ID                                                 AC170   AC198
                                                                 AC542   AC742
                                                                 GR742   BR21.1
                                                                 BR41.1  BR450

ATNSET13  ACTIVITY      KeyChange                                AC06.1  AC10.1
          ACCT-CATEGORY                                          AC196   AC240
          POSTING-DATE                                           AC256   AC50.1
          SYSTEM                                                 AC61.1  AC96.1
          SOURCE-CODE                                            AC96.2  BR10.1
          OBJ-ID

ATNSET14  GLT-OBJ-ID    KeyChange                                GL146   GL190
          OBJ-ID                                                 GL45.1

ATNSET3   ACTIVITY-GRP  KeyChange, Subset                        AC190   AC196
          ACTIVITY      Where (STATUS = 1 )                      AC45.1  AC530
          ACCT-CATEGORY                                          ACAC.1  ACDL.1
          POSTING-DATE                                           BR430   BRIP.1
          OBJ-ID

ATNSET4   ACTIVITY      KeyChange, Subset                        AC196   AC290
          ACCT-CATEGORY Where (STATUS = 9 )                      AC310   AC440
          FISCAL-YEAR                                            AC460   AC471
          PERIOD                                                 AC490   ACDR.1
          OBJ-ID                                                 BR142   BR40.1
                                                                 BR40.3  BR40.4
                                                                 BR42.1  BR430
                                                                 BR450

ATNSET7   CONTROL-GROUP KeyChange, Subset                        AC240   AC40.1
          SEQUENCE-NBR  Where (STATUS = Zeroes )                 AC40.3  AC40.4
          TRAN-CURRENCY                                          AC40.6  AC41.1
          OBJ-ID                                                 AC41.3  AC41.4
          ACTIVITY-GRP                                           AC41.6  AC42.1
                                                                 AC45.4

ATNSET8   ACTIVITY      KeyChange, Subset                        BR120
          ACCT-CATEGORY Where((BILLABLE = "Y" )
          TRAN-CURRENCY Or    (BILLABLE = "H" ))
          UNIT-MEASURE
          MATRIX-CAT
          MX-VALUE
          POSTING-DATE
          OBJ-ID

ATNSET9   OBJ-ID        KeyChange                                AC256   AC40.1
          ACTIVITY-GRP                                           AC40.4  AC41.1
          ACTIVITY                                               AC41.4  AC42.1
          CONTROL-GROUP                                          BR120   IFGT.1
          SEQUENCE-NBR

                         ACTRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            ATN-ACCT-CATEGORY     -> AAX-ACCT-CATEGORY

Acacctcat Err  ACACCTCAT    Not Required

                            ATN-ACCT-CATEGORY     -> AAX-ACCT-CATEGORY

Acacctcatx     ACACCTCATX   Not Required

                            ATN-ACTIVITY-GRP      -> AXX-ACTIVITY-GRP
                            ATN-ACTIVITY          -> AXX-ACTIVITY
                            ATN-ACCT-CATEGORY     -> AXX-ACCT-CATEGORY

Acactgrp       ACACTGRP     Required

                            ATN-ACTIVITY-GRP      -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Required

                            ATN-ACTIVITY          -> ACV-ACTIVITY

Acassign       ACASSIGN     Not Required

                            ATN-ACTIVITY-GRP      -> AAN-ACTIVITY-GRP
                            ATN-ACTIVITY          -> AAN-ACTIVITY
                            ATN-RESOURCE-TYPE     -> AAN-RESOURCE-TYPE
                            ATN-RESOURCE-CODE     -> AAN-RESOURCE-CODE

Accuamt        ACCUAMT      Not Required
                            Valid When ATN-CURRENCY-CODE != ATN-CURRENCY-CODE

                            ATN-ACTIVITY-GRP      -> ACU-ACTIVITY-GRP
                            ATN-ACTIVITY          -> ACU-ACTIVITY
                            ATN-ACT-CURRENCY      -> ACU-CURRENCY-CODE
                            Zeroes                -> ACU-BUDGET-NBR
                            ATN-FISCAL-YEAR       -> ACU-FISCAL-YEAR
                            ATN-ACCT-CATEGORY     -> ACU-ACCT-CATEGORY

Accuamtx       ACCUAMTX     Not Required
                            Valid When ATN-CURRENCY-CODE != ATN-CURRENCY-CODE

                            ATN-ACTIVITY-GRP      -> ACX-ACTIVITY-GRP
                            ATN-ACTIVITY          -> ACX-ACTIVITY
                            ATN-ACT-CURRENCY      -> ACX-CURRENCY-CODE
                            Zeroes                -> ACX-BUDGET-NBR
                            ATN-FISCAL-YEAR       -> ACX-FISCAL-YEAR
                            ATN-ACCT-CATEGORY     -> ACX-ACCT-CATEGORY
                            ATN-PERIOD            -> ACX-PERIOD

Acglmastx      ACGLMASTX    Required

                            ATN-ACTIVITY-GRP      -> GMX-ACTIVITY-GRP
                            ATN-ACTIVITY          -> GMX-ACTIVITY
                            ATN-ACCT-CATEGORY     -> GMX-ACCT-CATEGORY
                            ATN-COMPANY           -> GMX-COMPANY
                            ATN-ACCT-UNIT         -> GMX-ACCT-UNIT
                            ATN-FISCAL-YEAR       -> GMX-FISCAL-YEAR
                            ATN-PERIOD            -> GMX-PERIOD
                            ATN-RESOURCE-TYPE     -> GMX-RESOURCE-TYPE
                            ATN-RESOURCE-CODE     -> GMX-RESOURCE-CODE

Aclevel        ACLEVEL      Required

                            ATN-ACTIVITY-GRP      -> LVL-ACTIVITY-GRP
                            ATN-VAR-LEVELS        -> LVL-VAR-LEVELS

Acmaster       ACMASTER     Not Required

                            ATN-ACTIVITY-GRP      -> MST-ACTIVITY-GRP
                            ATN-ACTIVITY          -> MST-ACTIVITY
                            ATN-ACCT-CATEGORY     -> MST-ACCT-CATEGORY
                            ATN-FISCAL-YEAR       -> MST-FISCAL-YEAR

Acmasterx      ACMASTERX    Not Required

                            ATN-ACTIVITY-GRP      -> MSX-ACTIVITY-GRP
                            ATN-ACTIVITY          -> MSX-ACTIVITY
                            ATN-ACCT-CATEGORY     -> MSX-ACCT-CATEGORY
                            ATN-FISCAL-YEAR       -> MSX-FISCAL-YEAR
                            ATN-PERIOD            -> MSX-PERIOD

Actranseg      ACTRANSEG    Not Required

                            ATN-OBJ-ID            -> TSG-OBJ-ID

Actranserr     ACTRANSERR   Required

                            ATN-OBJ-ID            -> TER-OBJ-ID

Amasset        AMASSET      Not Required
                            Valid When ATN-RESOURCE-TYPE = "A"

                            AAN-EMPLOYEE-ASSET    -> AST-ASSET

Employee       EMPLOYEE     Not Required
                            Valid When ATN-RESOURCE-TYPE = "E"

                            ATN-FROM-COMPANY      -> EMP-COMPANY
                            AAN-EMPLOYEE-ASSET    -> EMP-EMPLOYEE

Glnames        GLNAMES      Required

                            ATN-FROM-COMPANY      -> GLN-COMPANY
                            ATN-ACCT-UNIT         -> GLN-ACCT-UNIT

Glsystem       GLSYSTEM     Required

                            ATN-COMPANY           -> GLS-COMPANY

Gltrans        GLTRANS      Not Required

                            ATN-GLT-OBJ-ID        -> GLT-OBJ-ID

Oeinvcline     OEINVCLINE   Not Required

                            ATN-OBJ-ID            -> OIL-ATN-OBJ-ID

Oeinvcmisc     OEINVCMISC   Not Required

                            ATN-OBJ-ID            -> OIM-ATN-OBJ-ID

                         ACTRANS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acblactv       ACBLACTV

                            ATN-ACTIVITY          -> BLA-ACTIVITY
                            ATN-ACCT-CATEGORY     -> BLA-ACCT-CATEGORY
                            Spaces                -> BLA-ACCT-CAT-CLASS
                                                     BLA-BILL-ACTIVITY

Acblactv Class ACBLACTV

                            ATN-ACTIVITY          -> BLA-ACTIVITY
                            Spaces                -> BLA-ACCT-CATEGORY
                            AXX-ACCT-CAT-CLASS    -> BLA-ACCT-CAT-CLASS
                                                     BLA-BILL-ACTIVITY

Acbrdnadtr     ACBRDNADTR

                            ATN-OBJ-ID            -> BAT-ATN-OBJ-ID
                                                     BAT-BURDEN-CD
                                                     BAT-BURDEN-TYPE
                                                     BAT-POOL-NBR

Acclgtrans     ACCLGTRANS

                            ATN-OBJ-ID            -> CGT-OBJ-ID
                                                     CGT-CONT-ACTIVITY
                                                     CGT-BILL-ACTIVITY
                                                     CGT-ACCT-CATEGORY
                                                     CGT-ACCT-CAT-CLASS
                                                     CGT-MATRIX-CAT
                                                     CGT-MX-VALUE

Acmxval        ACMXVAL

                            ATN-OBJ-ID            -> ATV-OBJ-ID
                                                     ATV-MATRIX-CAT

Amtrans        AMTRANS

                            ATN-OBJ-ID            -> AMT-ATN-OBJ-ID
                                                     AMT-ASSET
                                                     AMT-SEQ-NUMBER
                                                     AMT-COMPANY

Apapdhist      APAPDHIST

                            ATN-OBJ-ID            -> AH2-ATN-OBJ-ID
                                                     AH2-COMPANY
                                                     AH2-VENDOR
                                                     AH2-INVOICE
                                                     AH2-SUFFIX
                                                     AH2-CANCEL-SEQ
                                                     AH2-DIST-SEQ-NBR

Apdistrib      APDISTRIB

                            ATN-OBJ-ID            -> APD-ATN-OBJ-ID
                                                     APD-COMPANY
                                                     APD-VENDOR
                                                     APD-INVOICE
                                                     APD-SUFFIX
                                                     APD-CANCEL-SEQ
                                                     APD-DIST-SEQ-NBR

Ardistrib      ARDISTRIB

                            ATN-OBJ-ID            -> AMD-ATN-OBJ-ID
                                                     AMD-GL-COMPANY
                                                     AMD-ACCT-UNIT
                                                     AMD-ACCOUNT
                                                     AMD-SUB-ACCT
                                                     AMD-GL-DATE
                                                     AMD-CREATE-DATE
                                                     AMD-CREATE-TIME
                                                     AMD-PROG-SEQ-NBR

Cbdistrib      CBDISTRIB

                            ATN-OBJ-ID            -> CBD-ACT-OBJ-ID
                                                     CBD-CASH-CODE
                                                     CBD-BANK-INST-CODE
                                                     CBD-TRANS-IDENT
                                                     CBD-DIST-TYPE
                                                     CBD-SEQ-NBR

Eedistrib      EEDISTRIB

                            ATN-OBJ-ID            -> EED-ACT-OBJ-ID
                                                     EED-COMPANY
                                                     EED-VENDOR
                                                     EED-EXPENSE-NBR
                                                     EED-SEQ-NBR

Icmmdist       MMDIST
                            Valid When ATN-SYSTEM = "IC"

                            ATN-OBJ-ID            -> MMD-ATN-OBJ-ID
                                                     MMD-COMPANY
                                                     MMD-SYSTEM-CD
                                                     MMD-LOCATION
                                                     MMD-DOC-TYPE
                                                     MMD-DOC-NUMBER
                                                     MMD-DOC-NBR-NUM
                                                     MMD-LINE-NBR
                                                     MMD-COMPONENT-SEQ
                                                     MMD-LINE-SEQ

Mmdist         MMDIST

                            ATN-OBJ-ID            -> MMD-ATN-OBJ-ID
                                                     MMD-COMPANY
                                                     MMD-SYSTEM-CD
                                                     MMD-LOCATION
                                                     MMD-DOC-TYPE
                                                     MMD-DOC-NUMBER
                                                     MMD-DOC-NBR-NUM
                                                     MMD-LINE-NBR
                                                     MMD-COMPONENT-SEQ
                                                     MMD-LINE-SEQ

Oedist         OEDIST

                            ATN-OBJ-ID            -> ODI-ATN-OBJ-ID
                                                     ODI-INVC-PREFIX
                                                     ODI-INVC-NUMBER
                                                     ODI-AUTH-NO
                                                     ODI-LINE-NBR
                                                     ODI-SEQ
                                                     ODI-POSTING-TYPE

Pbdistrib      PBDISTRIB

                            ATN-COMPANY           -> PDB-COMPANY
                            ATN-ACTIVITY          -> PDB-ACTIVITY
                            ATN-OBJ-ID            -> PDB-ATN-OBJ-ID
                                                     PDB-EMPLOYEE
                                                     PDB-OBJ-ID

Pommdist       MMDIST
                            Valid When ATN-SYSTEM = "PO"

                            ATN-OBJ-ID            -> MMD-ATN-OBJ-ID
                                                     MMD-COMPANY
                                                     MMD-SYSTEM-CD
                                                     MMD-LOCATION
                                                     MMD-DOC-TYPE
                                                     MMD-DOC-NUMBER
                                                     MMD-DOC-NBR-NUM
                                                     MMD-LINE-NBR
                                                     MMD-COMPONENT-SEQ
                                                     MMD-LINE-SEQ

Prdistrib      PRDISTRIB

                            ATN-FROM-COMPANY      -> PRD-COMPANY
                            ATN-ACTIVITY          -> PRD-ACTIVITY
                            ATN-OBJ-ID            -> PRD-ATN-OBJ-ID
                                                     PRD-EMPLOYEE
                                                     PRD-OBJ-ID

Sltrans        SLTRANS

                            ATN-GLT-OBJ-ID        -> SLT-GLT-OBJ-ID
                                                     SLT-OBJ-ID