Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
Journal Group

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

COT-ACCT-UNIT        Alpha 15                                    AC76.1
Accounting Unit      The 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
Account X

COT-SUB-ACCOUNT      Numeric 4                                   AC76.1
Subaccount           This field along with the accounting
                     unit and subaccount make up the location
                     (account) where amounts and other
                     account information is stored.

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

COT-AUTO-REV         Alpha 1                                     AC76.1
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
Last Line Number     This field contains the number of the
                     last line item added to the document. It
                     is used to determine what the next line
                     number is when you add another
                     item.

COT-ACTIVE-STATUS    Alpha 1                                     AC76.1
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