Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCOMTMP


                             ACCOMTMP FILE

The Activity Management Commitment Template file stores the header
information for commitment journals defined in AC76.1 (Recurring Commitment
Entry).

REFERENCED BY

AC176     AC276

UPDATED BY

AC76.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

COT-JOURNAL-GROUP      Numeric 8                                 AC76.1
Element: Journal Group

COT-COMPANY            Numeric 4                                 AC76.1
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

COT-ACCT-UNIT          Alpha 15                                  AC76.1
Element: Accounting UniThe accounting unit is a shorthand
                       notation representing the variable level
                       number. When used in the General Ledger
                       Account Master file, the accounting unit
                       must be defined in the General Ledger
                       Names file as a posting accounting unit.


COT-ACCOUNT-X          Alpha 6                                   AC76.1
Element: Account X

COT-SUB-ACCOUNT        Numeric 4                                 AC76.1
Element: Subaccount

COT-DESCRIPTION        Alpha 30  (Lower Case)                    AC76.1
Element: Description   This field displays the description.

COT-AUTO-REV           Alpha 1                                   AC76.1
Element: Auto Reverse  When the Auto Reversal field is set to
                       "Y", the Lawson General Ledger Closing
                       program GL199 creates an opposite entry
                       for this transaction in the next period.


COT-LAST-LINE-NBR      Numeric 6                                 AC76.1
Element: Line Number

COT-ACTIVE-STATUS      Alpha 1                                   AC76.1
Element: Status        The status of the account. If Inactive,
                       no posting can be done to the account.

                         ACCOMTMP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

COTSET1   JOURNAL-GROUP                                          AC176   AC276
          COMPANY                                                AC76.1
          ACCT-UNIT
          ACCOUNT-X
          SUB-ACCOUNT

                         ACCOMTMP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accomtmpx      ACCOMTMPX

                            COT-JOURNAL-GROUP    -> COX-JOURNAL-GROUP
                            COT-COMPANY          -> COX-COMPANY
                            COT-ACCT-UNIT        -> COX-ACCT-UNIT
                            COT-ACCOUNT-X        -> COX-ACCOUNT-X
                            COT-SUB-ACCOUNT      -> COX-SUB-ACCOUNT
                                                    COX-LINE-NBR