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

FB11.1    FB111     FB160     FB211     FB240     FB296
FB60.1    FB95.1    FB95.2    FB95.3    FB95.4    FB95.5
FB95.6    GL298     GL90.6    GL94.1    GL94.2    GL94.3
GL94.4    GL94.5    GL94.6    GL94.7    GL95.1    GL95.2
GL95.3    GL95.4    GL95.5    GL95.6    GL95.7    GL95.8
GL95.9    GL96.1    GL96.2    GL96.3    GL96.4    GL96.5
GL97.1    GL97.2    GL97.3    GL97.4    GL97.5    GL97.6
GL97.7    GL97.8    GL97.9    GL98.1    GL98.2    GL98.3
GL98.4    GL98.5    GL99.1    GL99.2    GL99.3    GL99.4
GL99.5    GL99.6

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: Year          This 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 Nbr    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: Je Type       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 Group This 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 Nbr      This field contains the line number.      FB40.1  FB40.2
                                                                 FB40.3  FB45.1
                                                                 GL197   GL500

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

FLT-VERSION            Numeric 2                                 FB145   FB190
Element: Version       This 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: Acct Unit     The 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: Sub Acct      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: Var Levels    A 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: Period        This 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
Element: Base Nd       The number of decimal positions defined   FB40.1  FB40.2
                       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 Rev      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      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
Element: Acct Nd       The number of decimals assigned to a      FB40.1  FB40.2
                       particular account as determined by the   FB40.3  FB45.1
                       account currency.                         GL197   GL500


FLT-BASERATE           Signed 14.7                               FB145   FB190
Element: Curr 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       Identifies the AP company if the          FB40.1  FB40.2
                       resource type = V.  Identifies the HR     FB40.3  FB45.1
                       company if the resource type = E.  It is  GL110   GL197
                       blank for type A, P or Q resources.       GL500

FLT-TO-BUDGET          Numeric 3                                 FB145   FB190
Element: Budget Nbr    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                                FB11.1  FB111
          FISCAL-YEAR                                            FB145   FB160
          BUDGET-NBR                                             FB190   FB211
          JE-TYPE                                                FB240   FB296
          CONTROL-GROUP                                          FB40.1  FB40.2
          LINE-NBR                                               FB40.3  FB40.4
                                                                 FB45.1  FB60.1
                                                                 FB95.1  FB95.2
                                                                 FB95.3  FB95.4
                                                                 FB95.5  FB95.6
                                                                 GL110   GL120
                                                                 GL197   GL298
                                                                 GL300   GL500
                                                                 GL90.6  GL94.1
                                                                 GL94.2  GL94.3
                                                                 ...

FLTSET3   COMPANY       KeyChange                                FB145   FB190
          FISCAL-YEAR                                            FB296   FB40.1
          BUDGET-NBR                                             FB40.2  FB40.3
          VERSION                                                FB45.1  GL120
          JE-TYPE                                                GL197
          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