Lawson Insight Technical Documentation


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    AC256     AC440     AC295     AC297     AC90.1
AC90.2    AC95.1    AC95.2    AC97.1    AC97.2    AC06.1
AC96.1    AC96.2    AC10.1    AC415     AC460     AC470
AC471     AC490     ACDL.1    ACAC.1    AC290     AC450
AC980     AC112     AC800     AC240

UPDATED BY

AC115     AC120     AC131     AC160     AC170     AC190
AC191     AC195     AC196     AC300     AC310     AC40.1
AC41.1    AC42.1    AC45.1    AC530     AC540     AC580
AC70.1    AC70.3    AC70.4    AC730     AC952     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          AC196   AC310
                     group for the transaction.                  AC40.1  AC41.1
                                                                 AC42.1  AC45.1
                                                                 AC530   AC540
                                                                 AC70.3  AC730
                                                                 AC952   GL199
                                                                 IFGT.1

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

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

ATN-OBJ-ID           Numeric 12                                  AC131   AC196
Object Identifier    Required key. This is the object            AC310   AC40.1
                     identifier. It is used to relate            AC41.1  AC42.1
                     commitments or posted transactions back     AC530   AC540
                     to the originating subsystems. Each         AC70.3  AC70.4
                     subsystem record that is updated as a       AC730   AC952
                     commitment or posted transaction is         GL146   GL190
                     assigned an object identifier. The          GL199   GL45.1
                     object identifier is maintained in the      IFGT.1
                     subsystem files and in the Activity
                     Commitments Detail and Activity
                     Transaction files. The object identifier
                     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   AC310
Transaction Type     This field determines if amounts or         AC40.1  AC41.1
                     units are processed in the transaction.     AC42.1  AC530
                     A = Activity Management Only                AC540   AC730
                     B = Both GL and AC Transaction              AC952   GL199
                     I = Interface                               IFGT.1
                     T = Time Entry

ATN-COMPANY          Numeric 4                                   AC131   AC196
Company              This is the responsible company.            AC310   AC40.1
                                                                 AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-FROM-COMPANY     Numeric 4                                   AC131   AC196
From Company         This is the company that is the source      AC310   AC40.1
                     of the items.                               AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-TRAN-DATE        Numeric 8  (yyyymmdd)                       AC131   AC196
Transaction Date     This is the date the transaction is         AC310   AC40.1
                     posted.                                     AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-ACTIVITY         Alpha 15                                    AC131   AC196
Activity             This is the activity for the                AC310   AC40.1
                     transaction.                                AC41.1  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC70.3
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-VAR-LEVELS       Alpha 30                                    AC120   AC131
Variable Levels      This is the variable level for the          AC196   AC310
                     transaction.                                AC40.1  AC41.1
                                                                 AC42.1  AC45.1
                                                                 AC530   AC540
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

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

ATN-ACCT-CATEGORY    Alpha 5                                     AC131   AC196
Account Category     This is the account category for the        AC310   AC40.1
                     transaction.                                AC41.1  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC70.3
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

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

ATN-SYSTEM           Alpha 2                                     AC131   AC196
System Code          This is the system in which this            AC310   AC40.1
                     transaction originated.                     AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-ACCT-UNIT        Alpha 15                                    AC131   AC196
Accounting Unit      This is the general ledger accounting       AC310   AC40.1
                     unit for the transaction.                   AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-ACCOUNT          Numeric 6                                   AC131   AC196
Account              This field along with the accounting        AC310   AC40.1
                     unit and subaccount make up the location    AC41.1  AC42.1
                     (account) where amounts and other           AC530   AC540
                     account information is stored.              AC730   AC952
                                                                 GL199   IFGT.1

ATN-SUB-ACCOUNT      Numeric 4                                   AC131   AC196
Subaccount           This is the general ledger subaccount       AC310   AC40.1
                     for the transaction.                        AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-DESCRIPTION      Alpha 30  (Lower Case)                      AC131   AC196
Transaction          This is the description of the              AC310   AC40.1
Description          transaction.                                AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-REFERENCE        Alpha 10  (Lower Case)                      AC131   AC196
Reference            This is the reference for this              AC310   AC40.1
                     transaction.                                AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC70.3  AC70.4
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-UNITS-AMOUNT     Signed 15.2                                 AC131   AC196
Units Amount         This is the units amount for this           AC310   AC40.1
                     transaction.                                AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC70.3  AC70.4
                                                                 AC730   AC952
                                                                 GL199   GL45.1
                                                                 IFGT.1

ATN-TRAN-CURRENCY    Alpha 5                                     AC131   AC196
Transaction Currency This is the currency for the                AC310   AC40.1
                     transaction.                                AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-TRAN-AMOUNT      Signed 15.2                                 AC131   AC196
Transaction Amount   This is the amount in transaction           AC310   AC40.1
                     currency.                                   AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC70.3  AC70.4
                                                                 AC730   AC952
                                                                 GL199   GL45.1
                                                                 IFGT.1

ATN-TRAN-ND          Numeric 1                                   AC131   AC196
Transaction Number   This field indicates the defined number     AC310   AC40.1
of Decimals          of decimal positions used for the           AC41.1  AC42.1
                     transaction.                                AC530   AC540
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-ACT-CURRENCY     Alpha 5                                     AC131   AC196
Activity Currency    This is the activity currency.              AC310   AC40.1
                                                                 AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC70.3  AC730
                                                                 AC952   GL199
                                                                 IFGT.1

ATN-ACT-BASERATE     Signed 12.6                                 AC131   AC196
Activity Base Rate   This is the rate that converts the          AC310   AC40.1
                     transaction amount to the activity          AC41.1  AC42.1
                     amount.                                     AC45.1  AC530
                                                                 AC540   AC70.3
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-ACT-AMOUNT       Signed 15.2                                 AC131   AC196
Activity Amount      This is the amount for the activity.        AC310   AC40.1
                                                                 AC41.1  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC70.3
                                                                 AC70.4  AC730
                                                                 AC952   GL199
                                                                 GL45.1  IFGT.1

ATN-ACT-ND           Numeric 1                                   AC131   AC196
Activity Number of   This is the number of decimals for the      AC310   AC40.1
Decimals             activity.                                   AC41.1  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC70.3
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-AG-CURRENCY      Alpha 5                                     AC131   AC196
Activity Group       This is the currency for the activity       AC310   AC40.1
Currency             group.                                      AC41.1  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC70.3
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-AG-BASERATE      Signed 12.6                                 AC131   AC196
Activity Group Base  This is the rate that converts the          AC310   AC40.1
Rate                 transaction amount to the activity group    AC41.1  AC42.1
                     amount.                                     AC45.1  AC530
                                                                 AC540   AC70.3
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-AG-AMOUNT        Signed 15.2                                 AC131   AC196
Activity Group       This is the amount for the activity         AC310   AC40.1
Amount               group for this transaction.                 AC41.1  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC70.3
                                                                 AC70.4  AC730
                                                                 AC952   GL199
                                                                 GL45.1  IFGT.1

ATN-AG-ND            Numeric 1                                   AC131   AC196
Activity Group Nbr   This is the number of decimals for the      AC310   AC40.1
of Decimals          activity group.                             AC41.1  AC42.1
                                                                 AC45.1  AC530
                                                                 AC540   AC70.3
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-BILL-DATE        Numeric 8  (yyyymmdd)                       AC115   AC196
Billing Date         This is the date the transaction was        AC310   AC40.1
                     billed.                                     AC41.1  AC42.1
                                                                 AC70.3  AC730
                                                                 AC952   GL199

ATN-RUN-DATE         Numeric 8  (yyyymmdd)                       AC131   AC310
Run Date             This is the date the transaction was        AC40.1  AC41.1
                     posted to the general ledger.               AC42.1  AC530
                                                                 AC540   AC70.3
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

ATN-RUN-TIME         Numeric 6  (hhmmss)                         AC131   AC310
Run Time             This is the time the transaction was        AC40.1  AC41.1
                     posted to the general ledger.               AC42.1  AC530
                                                                 AC540   AC70.3
                                                                 AC730   AC952
                                                                 GL199   IFGT.1

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

ATN-BILL-RATE        Signed 13.4                                 AC131   AC190
Billing Rate         This is the billing rate for the            AC310   AC70.4
                     transaction.                                AC730   GL199

ATN-BILLABLE         Alpha 1                                     AC115   AC131
Billable             This field indicates whether the            AC170   AC190
                     transaction is billable, on hold, a         AC196   AC310
                     write-off, or a transfer.                   AC40.1  AC41.1
                     Y = Yes                                     AC42.1  AC70.1
                     N = No                                      AC70.3  AC70.4
                     H = Hold                                    AC730   AC952
                     W = Write-off                               GL199
                     T = Transfer

ATN-BILLED           Alpha 1                                     AC115   AC131
Billed               This field indicates whether the            AC190   AC196
                     transaction has been billed.                AC310   AC40.1
                     Y = Yes                                     AC41.1  AC42.1
                     N = No                                      AC730   AC952
                                                                 GL199

ATN-BILLABLE-AMT     Signed 15.2                                 AC131   AC190
Billable Amount      This is the billable amount for the         AC196   AC310
                     transaction.                                AC40.1  AC41.1
                                                                 AC42.1  AC540
                                                                 AC70.3  AC70.4
                                                                 AC730   AC952
                                                                 GL146   GL190
                                                                 GL199   GL45.1

ATN-BILLABLE-UNIT    Signed 15.2                                 AC131   AC190
Billable Units       This is the number of billable units        AC196   AC310
                     for the transaction.                        AC40.1  AC41.1
                                                                 AC42.1  AC540
                                                                 AC70.3  AC730
                                                                 AC952   GL146
                                                                 GL190   GL199
                                                                 GL45.1

ATN-REVENUE-FLAG     Alpha 1                                     AC131   AC170
Revenue Flag         This flag indicates whether revenue has     AC190   AC196
                     been recognized for the transaction.        AC310   AC40.1
                                                                 AC41.1  AC42.1
                     Valid values are                            AC730   AC952
                                                                 GL199
                     Y = Yes
                     N = No
                     H = Hold

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

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


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

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

ATN-RESOURCE-CODE    Alpha 10                                    AC131   AC196
Resource Code        This is the resource code associated        AC310   AC40.1
                     with the transaction.                       AC41.1  AC42.1
                                                                 AC530   AC540
                                                                 AC70.3  AC730
                                                                 AC952   GL199
                                                                 IFGT.1

ATN-UNIT-MEASURE     Alpha 12                                    AC131   AC196
Unit of Measure      This is the unit of measure for the         AC310   AC40.1
                     transaction.                                AC41.1  AC42.1
                                                                 AC540   AC70.3
                                                                 AC730   AC952
                                                                 GL199

ATN-COMMENT-CD       Numeric 3                                   AC70.3  AC70.4
Comment Code         This is the number representing a           AC730   AC952
                     comment relating to the transaction.

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

ATN-PERIOD           Numeric 2                                   AC120   AC190
Period               This is the period for the transaction.     AC580   AC730
                                                                 AC952

ATN-FISCAL-YEAR      Numeric 4                                   AC120   AC190
Year                 This is the fiscal year for the             AC580   AC730
                     transaction.                                AC952

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

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

ATN-SEGMENT-FLAG     Alpha 1                                     AC730
Segment Flag

                         ACTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATNSET1   ACTIVITY-GRP  KeyChange                                AC00.1  AC120
          CONTROL-GROUP                                          AC190   AC191
          SEQUENCE-NBR                                           AC256   AC300
          OBJ-ID                                                 AC42.1  AC440
                                                                 AC580   AC730

ATNSET10  ACTIVITY-GRP  KeyChange, Subset                        AC295   AC297
          VAR-LEVELS    Where (STATUS = 1 )                      AC90.1  AC90.2
          ACCT-CATEGORY                                          AC95.1  AC95.2
          OBJ-ID                                                 AC97.1  AC97.2

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

ATNSET12  COMPANY       KeyChange, Subset                        AC195   AC45.1
          OBJ-ID        Where (STATUS != 9 )                     IFGT.1

ATNSET13  ACTIVITY      KeyChange, Duplicates                    AC06.1  AC256
          ACCT-CATEGORY                                          AC96.1  AC96.2
          POSTING-DATE
          SYSTEM
          SOURCE-CODE
          OBJ-ID

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

ATNSET15  OBJ-ID        KeyChange                                AC256
          ACTIVITY-GRP
          ACTIVITY
          CONTROL-GROUP
          SEQUENCE-NBR

ATNSET2   ACTIVITY-GRP  KeyChange                                AC00.1  AC10.1
          STATUS                                                 AC196   AC310
          ACTIVITY                                               AC415   AC440
          ACCT-CATEGORY                                          AC460   AC470
          OBJ-ID                                                 AC471   AC490
          CONTROL-GROUP                                          AC530   ACDL.1
          SEQUENCE-NBR

ATNSET3   ACTIVITY-GRP  KeyChange, Subset                        AC190   ACAC.1
          ACTIVITY      Where (STATUS = 1 )
          ACCT-CATEGORY
          POSTING-DATE
          OBJ-ID

ATNSET4   ACTIVITY      KeyChange, Subset                        AC120   AC196
          ACCT-CATEGORY Where (STATUS = 9 )                      AC290   AC440
          OBJ-ID                                                 AC450   AC580
                                                                 AC70.1  AC70.3
                                                                 AC70.4  AC980

ATNSET5   ACTIVITY-GRP  KeyChange, Subset                        AC170
          ACTIVITY      Where (REVENUE-FLAG = "N" )
          ACCT-CATEGORY And  ((BILLABLE     = "Y" )
          COMPANY       Or    (BILLABLE     = "H" ))
          ACCT-UNIT
          OBJ-ID

ATNSET6   ACTIVITY-GRP  KeyChange                                AC06.1  AC10.1
          ACTIVITY                                               AC112   AC120
          ACCT-CATEGORY                                          AC160   AC191
          COMPANY                                                AC800
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          OBJ-ID
          CONTROL-GROUP
          SEQUENCE-NBR

ATNSET7   ACTIVITY      KeyChange, Duplicates, Subset            AC240   AC40.1
          CONTROL-GROUP Where (STATUS = Zeroes )                 AC41.1
          SEQUENCE-NBR
          OBJ-ID
          ACTIVITY-GRP

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

ATNSET9   ACTIVITY-GRP  Subset
          ACTIVITY      Where (BILLABLE     != "N" )
          ACCT-CATEGORY And   (BILLED       =  "N" )
          OBJ-ID        And   (REVENUE-FLAG =  "Y" )

                         ACTRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            ATN-ACCT-CATEGORY     -> AAX-ACCT-CATEGORY  (AAXSET1)

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

Accatrans      ACCATRANS    Not Required

                            ATN-ACTIVITY-GRP      -> TRN-ACTIVITY-GRP
                            ATN-ACTIVITY          -> TRN-ACTIVITY
                            ATN-ACCT-CATEGORY     -> TRN-ACCT-CATEGORY
                            ATN-CONTROL-GROUP     -> TRN-CONTROL-GROUP
                            ATN-SEQUENCE-NBR      -> TRN-LINE-NBR
                            ATN-OBJ-ID            -> TRN-SEQ-NUMBER

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

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

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

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

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

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

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

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

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-NBR
                                                     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-NBR
                                                     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

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-NBR
                                                     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