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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#FLT-COMPANY SET2 SET3
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 SET2 SET3 SET5
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 SET2 SET3 SET5
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 SET2 SET3
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 SET2 SET3
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 SET2 SET3
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 SET3
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 SET5
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 SET5
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 SET5
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 SET5
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
FLTSET1
  1. OBJ-ID
PrimaryAP125, AP126, AP131, AP170, AP190, AP193, AP20.1, AP20.2 +22 more (list truncated in source)
FLTSET2
  1. COMPANY
  2. FISCAL-YEAR
  3. BUDGET-NBR
  4. JE-TYPE
  5. CONTROL-GROUP
  6. LINE-NBR
KeyChangeFB145, FB190, FB240, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1 +6 more
FLTSET3
  1. COMPANY
  2. FISCAL-YEAR
  3. BUDGET-NBR
  4. VERSION
  5. JE-TYPE
  6. CONTROL-GROUP
  7. LINE-NBR
KeyChangeFB145, FB190, FB296, FB40.1, FB40.2, FB40.3, FB45.1, GL120 +2 more
FLTSET5
  1. TO-COMPANY
  2. FISCAL-YEAR
  3. BUDGET-NBR
  4. ACCT-UNIT
  5. ACCOUNT
  6. SUB-ACCOUNT
  7. OBJ-ID
SubsetWhere STATUS != 8FB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLMASTERGLCHARTDTLGLSYSTEMFBCONTROLFBHEADERFBTRANSFBTRANSAUFBTRANS

One to one (5) — lookups and parents

RelationTableRulesConditionField map
AccountGLMASTERRequired
FLT-TO-COMPANY→GLM-COMPANY
FLT-ACCT-UNIT→GLM-ACCT-UNIT
FLT-ACCOUNT→GLM-ACCOUNT
FLT-SUB-ACCOUNT→GLM-SUB-ACCOUNT
Chart DetailGLCHARTDTLNot Required
GLS-CHART-NAME→GDT-CHART-NAME
FLT-ACCOUNT→GDT-ACCOUNT
FLT-SUB-ACCOUNT→GDT-SUB-ACCOUNT
CompanyGLSYSTEMRequired
FLT-COMPANY→GLS-COMPANY
FbcontrolFBCONTROLRequired
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
FbheaderFBHEADERRequired
FLT-COMPANY→FBH-COMPANY
FLT-FISCAL-YEAR→FBH-FISCAL-YEAR
FLT-BUDGET-NBR→FBH-BUDGET-NBR

One to many (2) — child tables

RelationTableRulesConditionField map
FbtransFBTRANS
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
FbtransauFBTRANSAU
FLT-COMPANY→FTA-COMPANY
FLT-FISCAL-YEAR→FTA-FISCAL-YEAR
FLT-BUDGET-NBR→FTA-BUDGET-NBR
FLT-JE-TYPE→FTA-JE-TYPE
FLT-CONTROL-GROUP→FTA-CONTROL-GROUP
FLT-LINE-NBR→FTA-LINE-NBR
—→FTA-ACTION
—→FTA-DATE
—→FTA-TIME
—→FTA-UNIQUE-I-D

Programs

Updated by (386)

Referenced by (25)