Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SBBUDREL


                             SBBUDREL FILE

UPDATED BY

SB15.1    SB515

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SBR-RUN-GROUP          Alpha 15                                  SB15.1
Element: Run Group

SBR-SEQ-NUMBER         Numeric 6                                 SB15.1
Element: Seq Number

SBR-OLD-ACT-GRP        Alpha 35                                  SB15.1
Element: Old Act Grp

SBR-OLD-ACTIVITY       Alpha 35                                  SB15.1
Element: Old Activity

SBR-BUDGET-NBR         Numeric 3                                 SB15.1
Element: Budget Nbr

SBR-ACCT-CATEGORY      Alpha 5                                   SB15.1
Element: Acct Category

SBR-FISCAL-YEAR        Numeric 4                                 SB15.1
Element: Year

SBR-CURRENCY-CODE      Alpha 5                                   SB15.1  SB515
Element: Currency Code

SBR-BEGIN-DATE         Numeric 8  (yyyymmdd)                     SB15.1  SB515
Element: Date

SBR-END-DATE           Numeric 8  (yyyymmdd)                     SB15.1  SB515
Element: Date

SBR-NBR-PERIODS        Numeric 2                                 SB15.1
Element: Nbr Flds

SBR-DESCRIPTION        Alpha 30  (Lower Case)                    SB15.1
Element: Description

SBR-RATE-VALUE         Signed 18.7                               SB15.1  SB515
Element: Psa Rate52

SBR-ROUND-TYPE         Alpha 1                                   SB15.1  SB515
Element: Round Type

SBR-UNT-ROUND-TYPE     Alpha 1                                   SB15.1  SB515
Element: Round Type

SBR-NUM-DECIMALS       Numeric 1                                 SB15.1
Element: Num Decimals

SBR-UNT-NUM-DEC        Numeric 1                                 SB15.1
Element: Num Decimals

SBR-VALUE-ENTERED      Alpha 1                                   SB15.1
Element: Ac Usage

SBR-LIFE-ONLY          Alpha 1                                   SB15.1  SB515
Element: All Flag

SBR-AMOUNT             Currency 15.2 Occurs 13 Times             SB15.1  SB515
Element: Amount

SBR-UNIT               Signed 15.2 Occurs 13 Times               SB15.1  SB515
Element: Unit

SBR-FACTOR             Alpha 15 Occurs 13 Times                  SB15.1  SB515
Element: Factor

SBR-FACTOR-RATE        Signed 18.7 Occurs 13 Times               SB15.1  SB515
Element: Psa Rate52

SBR-RPT-RATE-1         Signed 18.7                               SB15.1  SB515
Element: Psa Rate52

SBR-RPT-RATE-2         Signed 18.7                               SB15.1  SB515
Element: Psa Rate52

SBR-ACTIVE-FLAG        Alpha 1                                   SB15.1
Element: Active Flag

SBR-LOCK               Alpha 1                                   SB15.1
Element: Lock

SBR-BGPR-ID            Numeric 10
Element: Numeric 1

                         SBBUDREL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SBRSET1   RUN-GROUP                                              SB15.1  SB515
          SEQ-NUMBER*

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

SBRSET3   RUN-GROUP                                              SB15.1  SB515
          SEQ-NUMBER

SBRSET4   OLD-ACT-GRP   KeyChange                                SB15.1
          OLD-ACTIVITY
          BUDGET-NBR
          ACCT-CATEGORY
          FISCAL-YEAR
          RUN-GROUP
          SEQ-NUMBER