Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

FBTRANS


                              FBTRANS FILE

                          Budget Transactions

The Flex Budget Transaction file contains the Flex Budget journal entry detail
information to be posted to the budget detail records. The transactions are
not deleted when posted and GL300 (General Ledger History Delete) should be
run to clear out information no longer needed.

REFERENCED BY

FB240     FB296

UPDATED BY

FB145     FB190     FB40.1    FB40.2    FB40.3    FB40.4
FB45.1    GL110     GL120     GL197     GL300     GL500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FLT-COMPANY            Numeric 4                                 FB145   FB190
Element: Company       The company number represents an          FB40.1  FB40.2
                       established company and is maintained on  FB40.3  FB40.4
                       GL10.                                     FB45.1  GL110
                                                                 GL197   GL500

FLT-FISCAL-YEAR        Numeric 4                                 FB145   FB190
Element: Last Closed YeThis is the current fiscal year for the   FB40.1  FB40.2
                       record.                                   FB40.3  FB40.4
                                                                 FB45.1  GL197
                                                                 GL500

FLT-BUDGET-NBR         Numeric 3                                 FB145   FB190
Element: Budget Number The number that identifies the budget.    FB40.1  FB40.2
                                                                 FB40.3  FB40.4
                                                                 FB45.1  GL197
                                                                 GL500

FLT-JE-TYPE            Alpha 1                                   FB145   FB190
Element: Journal Entry The type of journal entry. Valid values   FB40.1  FB40.2
                       are:                                      FB40.3  FB40.4
                       N = Normal                                FB45.1  GL197
                       I = Intercompany                          GL500
                       B = Interbudget

FLT-CONTROL-GROUP      Numeric 8                                 FB145   FB190
Element: Control GroupsThis field contains the journal entry     FB40.1  FB40.2
                       number used for process control of the    FB40.3  FB40.4
                       journal entry detail.                     FB45.1  GL197
                                                                 GL500

FLT-LINE-NBR           Numeric 6                                 FB145   FB190
Element: Line Number   This field contains the line number.      FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL197   GL500

FLT-OBJ-ID             Numeric 12                                FB145   FB190
Object                 This field contains the object ID         FB40.1  FB40.2
Identification         sequence number.                          FB40.3  FB40.4
                                                                 FB45.1  GL110
                                                                 GL197   GL500

FLT-VERSION            Numeric 2                                 FB145   FB190
Element: Budget VersionThis field displays the budget version    FB40.1  FB40.2
                       number.                                   FB40.3  FB45.1
                                                                 GL197   GL500

FLT-STATUS             Numeric 1                                 FB145   FB190
Element: Status        This field displays the status of the     FB40.1  FB40.2
                       transaction.                              FB40.3  FB40.4
                       0 = Unreleased                            FB45.1  GL197
                       1 = Released                              GL500
                       8 = Memo
                       9 = History

FLT-ACCT-UNIT          Alpha 15                                  FB145   FB190
Element: Accounting UniThe accounting unit is a shorthand        FB40.1  FB40.2
                       notation representing the variable level  FB40.3  FB45.1
                       number. The accounting unit entered in    GL197   GL500
                       this field must be  defined in the
                       General Ledger Names file as a  posting
                       accounting unit.

FLT-ACCOUNT            Numeric 6                                 FB145   FB190
Element: Account       This field along with the accounting      FB40.1  FB40.2
                       unit and subaccount make up the location  FB40.3  FB45.1
                       where amounts and other account           GL197   GL500
                       information is stored.

FLT-SUB-ACCOUNT        Numeric 4                                 FB145   FB190
Element: Subaccount    This field along with the accounting      FB40.1  FB40.2
                       unit and account make up the location     FB40.3  FB45.1
                       where amounts and other account           GL197   GL500
                       information is stored.

FLT-VAR-LEVELS         Alpha 30                                  FB145   FB190
Element: Variable LevelA level that represents the location of   FB40.1  FB40.2
                       an accounting unit in an organization's   FB40.3  FB45.1
                       level structure.                          GL120   GL197
                                                                 GL500

FLT-PERIOD             Numeric 2                                 FB145   FB190
Element: Last Closed PeThis field contains the period for this   FB40.1  FB40.2
                       record.                                   FB40.3  FB45.1
                                                                 GL197   GL500

FLT-BASE-AMOUNT        Signed 18.2                               FB145   FB190
Element: Intl Amt      This is the base amount.                  FB40.1  FB40.2
                                                                 FB40.3  FB40.4
                                                                 FB45.1  GL197
                                                                 GL500

FLT-UNITS-AMOUNT       Signed 15.2                               FB145   FB190
Element: Units Amount  This is the units amount.                 FB40.1  FB40.2
                                                                 FB40.3  FB40.4
                                                                 FB45.1  GL197
                                                                 GL500

FLT-BASE-ND            Numeric 1                                 FB145   FB190
Base Number Of         The number of decimal positions defined   FB40.1  FB40.2
Decimals               for the company base currency.            FB40.3  FB45.1
                                                                 GL197   GL500

FLT-DESCRIPTION        Alpha 30  (Lower Case)                    FB145   FB190
Element: Description   This field contains the description for   FB40.1  FB40.2
                       the transaction line.                     FB40.3  FB40.4
                                                                 FB45.1  GL197
                                                                 GL500

FLT-AUTO-REV           Alpha 1                                   GL197   GL500
Element: Auto Reverse  When the Auto Reversal field is set to
                       "Y", the Lawson General Ledger Closing
                       program GL199 creates an opposite entry
                       for this transaction in the next period.


FLT-DATE               Numeric 8  (yyyymmdd)                     FB145   FB190
Element: Date          This field contains the system date when  FB40.1  FB40.2
                       the transaction line was created.         FB40.3  FB40.4
                                                                 FB45.1  GL197
                                                                 GL500

FLT-UPDATE-DATE        Numeric 8  (yyyymmdd)                     FB145   FB190
Element: Update Date   This field contains the date the record   FB40.1  FB40.2
                       was updated.                              FB40.3  FB45.1
                                                                 GL197   GL500

FLT-OPERATOR           Alpha 10                                  FB145   FB190
Element: Operator Code This field is used to store the login     FB40.1  FB40.2
                       id of the person who entered the record.  FB40.3  FB45.1
                                                                 GL197   GL500

FLT-SOURCE-CODE        Alpha 2                                   FB145   FB190
Element: Source Code   A two character code assigned to a        FB40.1  FB40.2
                       transaction to identify where the         FB40.3  FB45.1
                       transaction was created.                  GL197   GL500

FLT-TRAN-AMOUNT        Signed 18.2                               FB145   FB190
Element: Intl Amt      This is the amount in transaction         FB40.1  FB40.2
                       currency to be posted.                    FB40.3  FB45.1
                                                                 GL197   GL500

FLT-TRAN-ND            Numeric 1                                 FB145   FB190
Account Currency       The number of decimal positions defined   FB40.1  FB40.2
Code                   for the transaction currency.             FB40.3  FB45.1
                                                                 GL197   GL500

FLT-BASERATE           Signed 14.7                               FB145   FB190
Element: Currency Rate The exchange rate at the time the         FB40.1  FB40.2
                       journal entry was made.  If left blank,   FB40.3  FB45.1
                       the current exchange rate will default.   GL197   GL500

FLT-TO-COMPANY         Numeric 4                                 FB145   FB190
Element: Company       This is the company number to which       FB40.1  FB40.2
                       this line is to be posted.                FB40.3  FB45.1
                                                                 GL110   GL197
                                                                 GL500

FLT-TO-BUDGET          Numeric 3                                 FB145   FB190
Element: Budget Number The budget number to which the            FB40.1  FB40.2
                       transaction line is posted.               FB40.3  FB45.1
                                                                 GL197   GL500

                         FBTRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FLTSET1   OBJ-ID                                                 FB145   FB190
                                                                 FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL110   GL197

FLTSET2   COMPANY       KeyChange                                FB145   FB190
          FISCAL-YEAR                                            FB240   FB40.1
          BUDGET-NBR                                             FB40.2  FB40.3
          JE-TYPE                                                FB40.4  FB45.1
          CONTROL-GROUP                                          GL110   GL120
          LINE-NBR                                               GL197   GL300
                                                                 GL500

FLTSET3   COMPANY       KeyChange                                FB145   FB190
          FISCAL-YEAR                                            FB296   FB40.1
          BUDGET-NBR                                             FB40.2  FB40.3
          VERSION                                                FB45.1  GL197
          JE-TYPE
          CONTROL-GROUP
          LINE-NBR

FLTSET5   TO-COMPANY    Subset
          FISCAL-YEAR   Where STATUS != 8
          BUDGET-NBR
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          OBJ-ID

                         FBTRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Account        GLMASTER     Required

                            FLT-TO-COMPANY       -> GLM-COMPANY  (GLMSET2)
                            FLT-ACCT-UNIT        -> GLM-ACCT-UNIT
                            FLT-ACCOUNT          -> GLM-ACCOUNT
                            FLT-SUB-ACCOUNT      -> GLM-SUB-ACCOUNT

Chart Detail   GLCHARTDTL   Not Required

                            GLS-CHART-NAME       -> GDT-CHART-NAME
                            FLT-ACCOUNT          -> GDT-ACCOUNT
                            FLT-SUB-ACCOUNT      -> GDT-SUB-ACCOUNT

Company        GLSYSTEM     Required

                            FLT-COMPANY          -> GLS-COMPANY

Fbcontrol      FBCONTROL    Required

                            FLT-COMPANY          -> FLC-COMPANY
                            FLT-FISCAL-YEAR      -> FLC-FISCAL-YEAR
                            FLT-BUDGET-NBR       -> FLC-BUDGET-NBR
                            FLT-JE-TYPE          -> FLC-JE-TYPE
                            FLT-CONTROL-GROUP    -> FLC-CONTROL-GROUP

Fbheader       FBHEADER     Required

                            FLT-COMPANY          -> FBH-COMPANY
                            FLT-FISCAL-YEAR      -> FBH-FISCAL-YEAR
                            FLT-BUDGET-NBR       -> FBH-BUDGET-NBR

                         FBTRANS FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Fbtrans        FBTRANS

                            FLT-COMPANY          -> FLT-COMPANY
                            FLT-FISCAL-YEAR      -> FLT-FISCAL-YEAR
                            FLT-BUDGET-NBR       -> FLT-BUDGET-NBR
                            FLT-JE-TYPE          -> FLT-JE-TYPE
                            FLT-CONTROL-GROUP    -> FLT-CONTROL-GROUP
                                                    FLT-LINE-NBR