Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACBUDREL


                             ACBUDREL FILE

                        Activity Budget Relation

This file is used in conversion of non-Lawson activity budget information to
the LAWSON INSIGHT Activity Management system. The file contains activity
budget relations information from AC27.1 (Budget Relationship). It relates
activity budgets to the Run Group and Sequence Number fields, which organize
transaction records for conversion and importing. In addition to run group and
sequence number, this file includes old activity group, old activity, budget
number and description, account category, budget begin and end dates, as well
as other budget information.

REFERENCED BY

AC227

UPDATED BY

AC127     AC27.1    AC300     AC310

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ACB-RUN-GROUP          Alpha 15                                  AC27.1
Element: Run Group     Required key. This is the run group.
                       The Run Group and Sequence Number fields
                       are the keys to the file. They should be
                       used to group records together for
                       importing.

ACB-SEQ-NUMBER         Numeric 6                                 AC27.1
Element: Sequence NumbeRequired key. Sequence number is a
                       unique number assigned to each
                       transaction. The Sequence  Number and
                       Run Group fields are the keys to the
                       file. They should be used to group
                       records together for importing.

ACB-OLD-ACT-GRP        Alpha 35                                  AC27.1
Element: Old Activity GThis is the old activity group.

ACB-OLD-ACTIVITY       Alpha 35                                  AC27.1
Element: Old Activity  This is the old activity.

ACB-BUDGET-NBR         Numeric 3                                 AC27.1
Element: Budget Number This is the budget number as defined in
                       the Activity Management system.

ACB-ACCT-CATEGORY      Alpha 5                                   AC27.1
Element: Account CategoThis is the account category for the
                       budget relationship information.

ACB-FISCAL-YEAR        Numeric 4                                 AC27.1
Element: Last Closed YeThis is the current fiscal year.  This
                       field is updated by Period Closing
                       (GL199).

ACB-CURRENCY-CODE      Alpha 5                                   AC127   AC27.1
Element: Currency Code This field contains the company base
                       currency code established in Company
                       (GL10.1 ).

ACB-BEGIN-DATE         Numeric 8  (yyyymmdd)                     AC127   AC27.1
Element: Begin Date    This is the begin date of the date
                       range for the budget.

ACB-END-DATE           Numeric 8  (yyyymmdd)                     AC127   AC27.1
Element: End Date      This is the end date of the date range
                       for the budget.

ACB-NBR-PERIODS        Numeric 2                                 AC27.1
Element: Number Fields This is the number of periods for the
                       budget.

ACB-DESCRIPTION        Alpha 30  (Lower Case)                    AC27.1
Element: Budget DescripThis is the budget description.

ACB-RATE-VALUE         Signed 12.6                               AC127   AC27.1
Element: Account Rate

ACB-ROUND-TYPE         Alpha 1                                   AC127   AC27.1
Element: Round Type    Select a round type to use in rounding
                       budget amounts. You can choose one of
                       the following values:

                       1 = 1 Decimal
                       2 = 2 Decimals
                       W = Whole Numbers
                       H = Hundreds
                       T = Thousands

                       The default is 2 (2 Decimals).

ACB-UNT-ROUND-TYPE     Alpha 1                                   AC127   AC27.1
Element: Round Type    Select a round type to use in rounding
                       units budget values. You can choose one
                       of the following values:

                       1 = 1 Decimal
                       2 = 2 Decimals
                       W = Whole Numbers
                       H = Hundreds
                       T = Thousands

                       The default is 2 (2 Decimals).

ACB-NUM-DECIMALS       Numeric 1                                 AC27.1
Element: Num Decimals  This is the number of decimals for the
                       amount budget.

ACB-UNT-NUM-DEC        Numeric 1                                 AC27.1
Element: Num Decimals  This is the number of decimals for the
                       units budget.

ACB-VALUE-ENTERED      Alpha 1                                   AC27.1
Element: Ac Usage      This field indicates whether the budget
                       is life, annual, or period.

ACB-LIFE-ONLY          Alpha 1                                   AC127   AC27.1
Element: All Flag      This field indicates whether the budget
                       is life-only.

ACB-AMOUNT             Currency 15.2 Occurs 53 Times             AC127   AC27.1
Element: Amount        This is the amounts by period for the
                       specified record.

ACB-UNIT               Signed 15.2 Occurs 53 Times               AC127   AC27.1
Element: Unit          This is the number of units for the new
                       budget.

ACB-FACTOR             Alpha 15 Occurs 53 Times                  AC127   AC27.1
Element: Factor        The element that affects the budget
                       change.

ACB-FACTOR-RATE        Signed 12.6 Occurs 53 Times               AC127   AC27.1
Element: Account Rate

ACB-RPT-RATE-1         Signed 12.6                               AC127   AC27.1
Element: Rpt Rate 1    The exchange rate to convert the
                       transaction amount to Report Currency 1.
                       The exchange rate is defined in CU10.1
                       (Exchange Rate).

ACB-RPT-RATE-2         Signed 12.6                               AC127   AC27.1
Element: Rpt Rate 1

ACB-ACTIVE-FLAG        Alpha 1                                   AC27.1
Element: Status        The Active flag indicates if this record
                       contains the active budget for the
                       activity or group.
                       Y
                       N

                         ACBUDREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACBSET1   RUN-GROUP                                              AC127   AC227
          SEQ-NUMBER*                                            AC27.1

ACBSET2   RUN-GROUP     KeyChange                                AC310
          OLD-ACT-GRP
          OLD-ACTIVITY
          BUDGET-NBR
          ACCT-CATEGORY
          FISCAL-YEAR
          SEQ-NUMBER

ACBSET3   RUN-GROUP                                              AC127   AC227
          SEQ-NUMBER                                             AC27.1

ACBSET4   OLD-ACT-GRP   KeyChange                                AC27.1  AC300
          OLD-ACTIVITY
          BUDGET-NBR
          ACCT-CATEGORY
          FISCAL-YEAR
          RUN-GROUP
          SEQ-NUMBER