Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCNTRACCT


                            ACCNTRACCT FILE

REFERENCED BY

AC04.1    BR130     BR131     BR210     BR430     BR530

UPDATED BY

AC300     AC310     BR10.1    BR10.3    AC10.1    BR15.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CNA-CONTRACT           Alpha 10                                  BR10.1  BR10.3
Element: Bid Name

CNA-ACTIVITY           Alpha 15                                  BR10.1  BR10.3
Element: Activity      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


CNA-ACCT-CATEGORY      Alpha 5                                   BR10.1  BR10.3
Element: Account CategoAccount categories are groupings of
                       costs, revenues, or a combination of
                       both used for reporting and inquiries
                       for activities in the Activity
                       Management system. All transactions are
                       posted to an account category within an
                       activity. You can assign a specific
                       General Ledger account or range of
                       accounts (company, accounting unit,
                       account, and subaccount) that make up
                       the transactions posted to an account
                       category using AC07.1 (Account
                       Assignment).

                       Period-to-date, year-to-date, and
                       life-to-date balances are maintained by
                       account category for activities. Account
                       categories must be assigned to
                       activities before you do any budgeting
                       or transaction processing.

CNA-REVENUE-GL-CD      Alpha 4                                   BR10.1  BR10.3
Element: Retain Gl Cd

CNA-REV-ACCT-CAT       Alpha 5                                   BR10.1  BR10.3
Element: Account Category

CNA-REV-ACCT           Numeric 6                                 BR10.1  BR10.3
Element: Account

CNA-REV-SUB-ACCT       Numeric 4                                 BR10.1  BR10.3
Element: Subaccount

CNA-LOSS-GL-CD         Alpha 4                                   BR10.1  BR10.3
Element: Retain Gl Cd

CNA-LOSS-ACCT-CAT      Alpha 5                                   BR10.1  BR10.3
Element: Account Category

CNA-RSRV-LSS-GL-CD     Alpha 4                                   BR10.1  BR10.3
Element: Retain Gl Cd

CNA-C-GAIN-GL-CD       Alpha 4                                   BR10.1  BR10.3
Element: C Gain Gl Cd

CNA-C-LOSS-GL-CD       Alpha 4                                   BR10.1  BR10.3
Element: C Loss Gl Cd

CNA-ADJ-GL-CD          Alpha 4
Element: Adj Gl Cd

CNA-ADJ-ACCT-CAT       Alpha 5                                   BR10.1  BR10.3
Element: Adj Acct Cat

CNA-ADJ-ACCOUNT        Numeric 6                                 BR10.1  BR10.3
Element: Account

CNA-ADJ-SUB-ACCT       Numeric 4                                 BR10.1  BR10.3
Element: Subaccount

                         ACCNTRACCT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CNASET1   CONTRACT                                               AC04.1  AC10.1
          ACCT-CATEGORY                                          AC300   AC310
                                                                 BR10.1  BR10.3
                                                                 BR130   BR131
                                                                 BR15.1  BR210
                                                                 BR430   BR530

                         ACCNTRACCT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acacctcat      ACACCTCAT    Required

                            CNA-ACCT-CATEGORY    -> AAX-ACCT-CATEGORY

Accntract      ACCNTRACT    Required

                            CNA-CONTRACT         -> CNT-CONTRACT