FBTRANS – Budget Transactions

System
General Ledger (GL)
Prefix
FLT
Primary key
OBJ-ID
Fields
28
Updated by
386 programs
Referenced by
25 programs

FBTRANS is the Budget Transactions table in Lawson General Ledger (prefix FLT). It is indexed by OBJ-ID (FLTSET1); alternate indexes: FLTSET2, FLTSET3 and FLTSET5. It is related 1:1 to GLMASTER, GLCHARTDTL, GLSYSTEM, FBCONTROL and FBHEADER and 1:M to FBTRANS and FBTRANSAU. It is updated by AP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 and 378 more and referenced by CA110, CA195, FB10.1, FB100, FB101, FB120, FB121, FB122 and 17 more. The table has 28 fields, 4 indexes and 7 documented relations.

About FBTRANS

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.

Fields (28)

Column = COBOL field name without the FLT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
FLT-COMPANY
COMPANY
Numeric 4The company number represents an established company and is maintained on GL10.FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL110 +3 more
FLT-FISCAL-YEAR
FISCAL_YEAR
Numeric 4This is the current fiscal year for the record.FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
FLT-BUDGET-NBR
BUDGET_NBR
Numeric 3The number that identifies the budget.FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
FLT-JE-TYPE
JE_TYPE
Alpha 1The type of journal entry. Valid values are:
  • N Normal
  • I Intercompany
  • B Interbudget
FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
FLT-CONTROL-GROUP
CONTROL_GROUP
Numeric 8This field contains the journal entry number used for process control of the journal entry detail.FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
FLT-LINE-NBR
LINE_NBR
Numeric 6This field contains the line number.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
FLT-OBJ-ID PK
OBJ_ID
Numeric 12This field contains the object ID sequence number.FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL110 +3 more
FLT-VERSION
VERSION
Numeric 2This field displays the budget version number.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
FLT-STATUS
STATUS
Numeric 1This field displays the status of the transaction.
  • 0 Unreleased
  • 1 Released
  • 8 Memo
  • 9 History
FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
FLT-ACCT-UNIT
ACCT_UNIT
Alpha 15The accounting unit is a shorthand notation representing the variable level number. The accounting unit entered in this field must be defined in the General Ledger Names file as a posting accounting unit.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
FLT-ACCOUNT
ACCOUNT
Numeric 6This field along with the accounting unit and subaccount make up the location where amounts and other account information is stored.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
FLT-SUB-ACCOUNT
SUB_ACCOUNT
Numeric 4This field along with the accounting unit and account make up the location where amounts and other account information is stored.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
FLT-VAR-LEVELS
VAR_LEVELS
Alpha 30A level that represents the location of an accounting unit in an organization's level structure.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL120, GL197 +2 more
FLT-PERIOD
PERIOD
Numeric 2This field contains the period for this record.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
FLT-BASE-AMOUNT
BASE_AMOUNT
Signed 18.2This is the base amount.AP125, AP126, AP131, AP170, AP190, AP193, AP21.1, AP23.1 +52 more (list truncated in source)
FLT-UNITS-AMOUNT
UNITS_AMOUNT
Signed 15.2This is the units amount.FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
FLT-BASE-ND
BASE_ND
Numeric 1The number of decimal positions defined for the company base currency.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
FLT-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field contains the description for the transaction line.FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
FLT-AUTO-REV
AUTO_REV
Alpha 1When 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.GL197, GL199, GL500
FLT-DATE
DATE
Numeric 8 (yyyymmdd)This field contains the system date when the transaction line was created.FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
FLT-UPDATE-DATE
UPDATE_DATE
Numeric 8 (yyyymmdd)This field contains the date the record was updated.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
FLT-OPERATOR
OPERATOR
Alpha 10This field is used to store the login id of the person who entered the record.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
FLT-SOURCE-CODE
SOURCE_CODE
Alpha 2A two character code assigned to a transaction to identify where the transaction was created.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
FLT-TRAN-AMOUNT
TRAN_AMOUNT
Signed 18.2This is the amount in transaction currency to be posted.FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
FLT-TRAN-ND
TRAN_ND
Numeric 1The number of decimals assigned to a particular account as determined by the account currency.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
FLT-BASERATE
BASERATE
Signed 14.7The exchange rate at the time the journal entry was made. If left blank, the current exchange rate will default.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
FLT-TO-COMPANY
TO_COMPANY
Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL110, GL197 +2 more
FLT-TO-BUDGET
TO_BUDGET
Numeric 3The budget number to which the transaction line is posted.FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
FLTSET1OBJ-IDPrimaryAP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +22 more (list truncated in source)
FLTSET2COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP, LINE-NBRKeyChangeFB145, FB190, FB240, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1 +6 more
FLTSET3COMPANY, FISCAL-YEAR, BUDGET-NBR, VERSION, JE-TYPE, CONTROL-GROUP, LINE-NBRKeyChangeFB145, FB190, FB296, FB40.1, FB40.2, FB40.3, FB45.1, GL120 +2 more
FLTSET5TO-COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, OBJ-IDSubsetWhere STATUS != 8FB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequiredFLT-TO-COMPANYGLM-COMPANY, FLT-ACCT-UNITGLM-ACCT-UNIT, FLT-ACCOUNTGLM-ACCOUNT, FLT-SUB-ACCOUNTGLM-SUB-ACCOUNT
Chart DetailGLCHARTDTLNot RequiredGLS-CHART-NAMEGDT-CHART-NAME, FLT-ACCOUNTGDT-ACCOUNT, FLT-SUB-ACCOUNTGDT-SUB-ACCOUNT
CompanyGLSYSTEMRequiredFLT-COMPANYGLS-COMPANY
FbcontrolFBCONTROLRequiredFLT-COMPANYFLC-COMPANY, FLT-FISCAL-YEARFLC-FISCAL-YEAR, FLT-BUDGET-NBRFLC-BUDGET-NBR, FLT-JE-TYPEFLC-JE-TYPE, FLT-CONTROL-GROUPFLC-CONTROL-GROUP
FbheaderFBHEADERRequiredFLT-COMPANYFBH-COMPANY, FLT-FISCAL-YEARFBH-FISCAL-YEAR, FLT-BUDGET-NBRFBH-BUDGET-NBR

One to many (2) — child tables

RelationTableRulesConditionField map
FbtransFBTRANSFLT-COMPANYFLT-COMPANY, FLT-FISCAL-YEARFLT-FISCAL-YEAR, FLT-BUDGET-NBRFLT-BUDGET-NBR, FLT-JE-TYPEFLT-JE-TYPE, FLT-CONTROL-GROUPFLT-CONTROL-GROUP, FLT-LINE-NBR
FbtransauFBTRANSAUFLT-COMPANYFTA-COMPANY, FLT-FISCAL-YEARFTA-FISCAL-YEAR, FLT-BUDGET-NBRFTA-BUDGET-NBR, FLT-JE-TYPEFTA-JE-TYPE, FLT-CONTROL-GROUPFTA-CONTROL-GROUP, FLT-LINE-NBRFTA-LINE-NBR, FTA-ACTION, FTA-DATE, FTA-TIME, FTA-UNIQUE-I-D

Programs

Updated by (386)

Referenced by (25)