Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCTLGRPHD


                            ACCTLGRPHD FILE

                     Activity Control Group Header

This file contains header information about activity control groups from
AC40.1 (Journal Entry) and AC41.1 (Resource Journal Entry).

REFERENCED BY

AC240     AC256     AC290

UPDATED BY

AC40.1    AC40.4    AC41.1    AC41.4    AC45.4    BR41.1
BR41.4    BR43.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CGH-TRANS-TYPE         Alpha 1                                   AC40.1  AC40.4
Element: Transaction TyRequired key. This field determines if    AC41.1  AC41.4
                       the transaction processes amounts or      BR41.1  BR41.4
                       units.                                    BR43.1
                       A = AC Only
                       B = Both AC & GL
                       T = Time Entry
                       R = Resource AC Only
                       G = Resource AC & GL
                       C = Contract Only
                       D = Contract & GL
                       E = Revenue Only

CGH-CONTROL-GROUP      Numeric 8                                 AC40.1  AC40.4
Element: Control Group Required key. This field contains the     AC41.1  AC41.4
                       control group number used for process     BR41.1  BR41.4
                       control of the journal entry detail.      BR43.1

CGH-DESCRIPTION        Alpha 30  (Lower Case)                    AC40.1  AC40.4
Control Group          This is the control group description.    AC41.1  AC41.4
Description                                                      BR41.1  BR41.4
                                                                 BR43.1

CGH-BATCH-DATE         Numeric 8  (yyyymmdd)                     AC40.1  AC40.4
Element: Batch Date    This is the date the batch of             AC41.1  AC41.4
                       transactions for the control group was    BR41.1  BR41.4
                       processed.                                BR43.1

CGH-COMPANY            Numeric 4                                 AC40.1  AC40.4
Element: Company       This is the responsible company.          AC41.1  AC41.4
                                                                 BR41.1  BR41.4
                                                                 BR43.1

CGH-BASE-ND            Numeric 1                                 AC40.1  AC40.4
Base Number of         This is the number of decimal positions   AC41.1  AC41.4
Decimals               defined for the activity group currency.  BR41.1  BR41.4
                                                                 BR43.1

CGH-DEBIT-TOTAL        Signed 15.2                               AC40.1  AC40.4
Element: Debit Total   This is the total debit amount for this   AC41.1  AC41.4
                       batch of transactions. The debit amount   BR41.1  BR41.4
                       must equal the credit amount.             BR43.1

CGH-CREDIT-TOTAL       Signed 15.2                               AC40.1  AC40.4
Element: Credit Total  This is the total credit amount for       AC41.1  AC41.4
                       this batch of transactions. The credit    BR41.1  BR41.4
                       amount must equal the debit amount.       BR43.1

CGH-UNIT-DEBITS        Signed 15.2                               AC40.1  AC40.4
Element: Unit Debits   This is the total of unit debits.         AC41.1  AC41.4
                                                                 BR41.1  BR41.4
                                                                 BR43.1

CGH-UNIT-CREDITS       Signed 15.2                               AC40.1  AC40.4
Element: Unit Credits  This is the total of unit credits.        AC41.1  AC41.4
                                                                 BR41.1  BR41.4
                                                                 BR43.1

CGH-LAST-REC-SEQ       Numeric 6                                 AC40.1  AC40.4
Last Record            This is the sequence number of the last   AC41.1  AC41.4
Sequence Number        record processed.                         BR41.1  BR41.4
                                                                 BR43.1

                         ACCTLGRPHD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CGHSET1   CONTROL-GROUP                                          AC240   AC256
                                                                 AC290   AC40.1
                                                                 AC40.3  AC40.4
                                                                 AC40.6  AC41.1
                                                                 AC41.3  AC41.4
                                                                 AC41.6  AC45.4
                                                                 BR41.1  BR41.4

CGHSET2   TRANS-TYPE                                             AC40.1  AC40.3
          CONTROL-GROUP                                          AC40.4  AC40.6
                                                                 AC41.1  AC41.3
                                                                 AC41.4  AC41.6
                                                                 AC45.4  BR41.1
                                                                 BR41.4

                         ACCTLGRPHD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glsystem       GLSYSTEM     Required

                            CGH-COMPANY          -> GLS-COMPANY

                         ACCTLGRPHD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Actrans        ACTRANS

                            CGH-CONTROL-GROUP    -> ATN-CONTROL-GROUP
                                                    ATN-SEQUENCE-NBR
                                                    ATN-TRAN-CURRENCY
                                                    ATN-OBJ-ID
                                                    ATN-ACTIVITY-GRP