Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACTOTBALX FILE

UPDATED BY

AC190     AC20.7    AC300     AC310     AC45.1    ACDR.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

TOX-FISCAL-YEAR      Numeric 4                                   AC190   AC20.7
Fiscal Year          This is the current fiscal year.  This      AC45.1  ACDR.1
                     field is updated by Period Closing
                     (GL199).

TOX-BUDGET-NBR       Numeric 3                                   AC190   AC20.7
Budget Number        The Budget Number field contains the        AC45.1  ACDR.1
                     budget number.

TOX-ACTIVITY-GRP     Alpha 15                                    AC190   AC20.7
Activity Group                                                   AC45.1  ACDR.1

TOX-ACTIVITY         Alpha 15                                    AC190   AC20.7
Activity             Activities are the processes or             AC45.1  ACDR.1
                     procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity.



TOX-CATEGORY-TYPE    Alpha 1                                     AC190   AC20.7
Category Type        This Field is used to set up the            AC45.1  ACDR.1
                     default category type for the
                     Distribution File.
                     (EEDISTRIB)
                     A = Accrual
                     C = Cost
                     R = Revenue
                     F = Fee

TOX-CURRENCY-CODE    Alpha 5                                     AC190   AC20.7
Currency Code        This field contains the company base        AC45.1  ACDR.1
                     currency code established in Company
                     (GL10.1 ).


TOX-PERIOD           Numeric 2                                   AC190   AC20.7
Last Closed Period   This is the current accounting period.      AC45.1  ACDR.1
                     This field is updated by Period Closing
                     (GL199).

TOX-PARENT-ACTV      Alpha 15                                    AC190   AC20.7
Parent Actv                                                      AC45.1  ACDR.1

TOX-AMOUNT           Currency 15.2                               AC190   AC20.7
Amount               This is the amounts by period for the       AC310   AC45.1
                     specified record.                           ACDR.1

TOX-UNIT             Signed 15.2                                 AC190   AC20.7
Unit                                                             AC310   AC45.1
                                                                 ACDR.1

                         ACTOTBALX FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

TOXSET1   FISCAL-YEAR                                            AC190   AC20.7
          BUDGET-NBR                                             AC310   AC45.1
          ACTIVITY-GRP                                           ACDR.1
          ACTIVITY
          CURRENCY-CODE
          CATEGORY-TYPE
          PERIOD

TOXSET2   ACTIVITY-GRP                                           AC300   AC310
          PARENT-ACTV                                            ACDR.1
          CURRENCY-CODE
          BUDGET-NBR
          CATEGORY-TYPE
          FISCAL-YEAR
          PERIOD
          ACTIVITY

                         ACTOTBALX FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactgrp       ACACTGRP     Required

                            TOX-ACTIVITY-GRP     -> AGP-ACTIVITY-GRP

Acactivity     ACACTIVITY   Required

                            TOX-ACTIVITY         -> ACV-ACTIVITY

Aclevel        ACLEVEL      Required

                            TOX-ACTIVITY-GRP     -> LVL-ACTIVITY-GRP
                            ACV-VAR-LEVELS       -> LVL-VAR-LEVELS

Actotbalx Prnt ACTOTBALX    Not Required
                            Valid When TOX-ACTIVITY != Spaces

                            TOX-FISCAL-YEAR      -> TOX-FISCAL-YEAR
                            TOX-BUDGET-NBR       -> TOX-BUDGET-NBR
                            TOX-ACTIVITY-GRP     -> TOX-ACTIVITY-GRP
                            TOX-PARENT-ACTV      -> TOX-ACTIVITY
                            TOX-CURRENCY-CODE    -> TOX-CURRENCY-CODE
                            TOX-CATEGORY-TYPE    -> TOX-CATEGORY-TYPE
                            TOX-PERIOD           -> TOX-PERIOD

                         ACTOTBALX FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acconsolx      ACCONSOLX

                            TOX-FISCAL-YEAR      -> CSX-FISCAL-YEAR
                            TOX-PERIOD           -> CSX-PERIOD
                            TOX-ACTIVITY-GRP     -> CSX-ACTIVITY-GRP
                            TOX-ACTIVITY         -> CSX-ACTIVITY
                            TOX-CURRENCY-CODE    -> CSX-CURRENCY-CODE
                            TOX-BUDGET-NBR       -> CSX-BUDGET-NBR
                                                    CSX-ACCT-CATEGORY

Acconsolx Grp  ACCONSOLX

                            TOX-FISCAL-YEAR      -> CSX-FISCAL-YEAR
                            TOX-PERIOD           -> CSX-PERIOD
                            TOX-ACTIVITY-GRP     -> CSX-ACTIVITY-GRP
                            Spaces               -> CSX-ACTIVITY
                            TOX-CURRENCY-CODE    -> CSX-CURRENCY-CODE
                            TOX-BUDGET-NBR       -> CSX-BUDGET-NBR
                                                    CSX-ACCT-CATEGORY

Accuamtx       ACCUAMTX

                            TOX-ACTIVITY-GRP     -> ACX-ACTIVITY-GRP
                            TOX-ACTIVITY         -> ACX-ACTIVITY
                            TOX-CURRENCY-CODE    -> ACX-CURRENCY-CODE
                            TOX-FISCAL-YEAR      -> ACX-FISCAL-YEAR
                            TOX-PERIOD           -> ACX-PERIOD
                            TOX-BUDGET-NBR       -> ACX-BUDGET-NBR
                                                    ACX-ACCT-CATEGORY

Acmasterx      ACMASTERX

                            TOX-ACTIVITY-GRP     -> MSX-ACTIVITY-GRP
                            TOX-ACTIVITY         -> MSX-ACTIVITY
                            TOX-FISCAL-YEAR      -> MSX-FISCAL-YEAR
                            TOX-PERIOD           -> MSX-PERIOD
                                                    MSX-ACCT-CATEGORY

Actotbalx Chld ACTOTBALX
                            Valid When TOX-ACTIVITY != Spaces

                            TOX-ACTIVITY-GRP     -> TOX-ACTIVITY-GRP
                            TOX-ACTIVITY         -> TOX-PARENT-ACTV
                            TOX-CURRENCY-CODE    -> TOX-CURRENCY-CODE
                            TOX-BUDGET-NBR       -> TOX-BUDGET-NBR
                            TOX-CATEGORY-TYPE    -> TOX-CATEGORY-TYPE
                            TOX-FISCAL-YEAR      -> TOX-FISCAL-YEAR
                            TOX-PERIOD           -> TOX-PERIOD
                                                    TOX-ACTIVITY