FBCONTROL – Budget Journal Control

System: General Ledger (GL)
Prefix: FLC
Primary key: COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP
Fields: 26
Updated by: 12 programs
Referenced by: 83 programs

FBCONTROL is the Budget Journal Control table in Lawson General Ledger (prefix FLC). It is indexed by COMPANY, FISCAL-YEAR, BUDGET-NBR, JE-TYPE, CONTROL-GROUP (FLCSET1); alternate indexes: FLCSET2. It is related 1:1 to GLSYSTEM and FBHEADER and 1:M to FBCNTRLAU and FBTRANS. It is updated by FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL110 and 4 more and referenced by CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB111, FB120 and 75 more. The table has 26 fields, 2 indexes and 4 documented relations.

About FBCONTROL

This file contains Flex Budget journal ectry control information. This information is used to process the Flex Budget journal entry detail records.

Fields (26)

Column = COBOL field name without the FLC- 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 / column	Type	Description & values	Updated by
#`FLC-COMPANY` PK COMPANY	Numeric 4	The 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
#`FLC-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	This is the fiscal year for the record.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
#`FLC-BUDGET-NBR` PK BUDGET_NBR	Numeric 3	The number that identifies the budget.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
#`FLC-JE-TYPE` PK JE_TYPE	Alpha 1	The type of journal entry. Valid values are Normal, Intercompany, and Multiple Budget. N I B	FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
#`FLC-CONTROL-GROUP` PK CONTROL_GROUP	Numeric 8	This 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
#`FLC-JE-SEQUENCE` JE_SEQUENCE	Numeric 2	The unique journal entry sequence number.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
#`FLC-STATUS` SET2 STATUS	Numeric 1	This field contains the processing cycle status of the assigned journal entry. `0` Unreleased `1` Released `2` Post In Progress `5` Posted `9` History	FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
#`FLC-VERSION` VERSION	Numeric 2	This field displays the budget version number.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
#`FLC-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This is the transaction currency for the journal entry.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
#`FLC-BASE-ND` BASE_ND	Numeric 1	The number of decimal positions defined for the company base currency.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
#`FLC-BASE-DEBITS` BASE_DEBITS	Signed 18.2	The total base debit amounts for the journal entry.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
#`FLC-BASE-CREDITS` BASE_CREDITS	Signed 18.2	The total base credit amounts for the journal entry.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
#`FLC-UNIT-ENTRY-DB` UNIT_ENTRY_DB	Signed 15.2	The total debit units for the journal entry.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
#`FLC-UNIT-ENTRY-CR` UNIT_ENTRY_CR	Signed 15.2	The total credit units for the journal entry.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
#`FLC-CNTRL-AMOUNT` CNTRL_AMOUNT	Signed 18.2	The control total for the journal entry.	FB45.1, GL500
#`FLC-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field contains the description for the journal entry.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
#`FLC-LINE-NBR` LINE_NBR	Numeric 6	This field contains the line number.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
#`FLC-NBR-LINES` NBR_LINES	Numeric 6	This is the number of detail lines.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
#`FLC-DATE` DATE	Numeric 8 (yyyymmdd)	This field contains the system date when the journal entry was created.	FB40.2, FB40.4, FB45.1, GL197, GL199, GL500
#`FLC-OPERATOR` OPERATOR	Alpha 10	This field is used to store the login id of the person who entered the record.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB40.4, FB45.1, GL197 +2 more
#`FLC-REL-OPERATOR` REL_OPERATOR	Alpha 10	This field is used to store the login ID of the person who released the journal entry.	FB145, FB190, FB40.1, FB40.2, FB40.3, FB45.1, GL197, GL199 +1 more
#`FLC-TRAN-DESC-DFLT` TRAN_DESC_DFLT	Alpha 1	This field indicates if the journal entry header or the prior transaction line is used for the description.	FB40.2, FB45.1, GL197, GL199, GL500
#`FLC-ADJ-CODE` ADJ_CODE	Alpha 3	—	FB40.2, FB40.4, FB45.1
#`FLC-ADJ-CODE-DESC` ADJ_CODE_DESC	Alpha 30 (Lower Case)	—	FB40.2, FB40.4
#`FLC-BLANK` BLANK	Derived	This field consists of blank spaces. It is used to provide column headings on Drill Arounds.	—
#`FLC-UPD-ROLLOVER` UPD_ROLLOVER	Numeric 1	—	GL197, GL199

Indexes (2)

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.

Index	Keys	Flags	Condition	Used in
`FLCSET1`	`COMPANY` `FISCAL-YEAR` `BUDGET-NBR` `JE-TYPE` `CONTROL-GROUP`	Primary		CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB111, FB120 +22 more (list truncated in source)
`FLCSET2`	`COMPANY` `STATUS` `FISCAL-YEAR` `BUDGET-NBR` `JE-TYPE` `CONTROL-GROUP`	KeyChange		FB145, FB190, FB240, FB45.1, GL110

Relations

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

One to one (2) — lookups and parents

Relation Table Rules Condition Field map

Company

GLSYSTEM

Required

FLC-COMPANY → GLS-COMPANY

Fbheader

FBHEADER

Required

`FLC-COMPANY`	→	`FBH-COMPANY`
`FLC-FISCAL-YEAR`	→	`FBH-FISCAL-YEAR`
`FLC-BUDGET-NBR`	→	`FBH-BUDGET-NBR`

One to many (2) — child tables

Relation Table Rules Condition Field map

Fbcntrlau

FBCNTRLAU

`FLC-COMPANY`	→	`FCA-COMPANY`
`FLC-FISCAL-YEAR`	→	`FCA-FISCAL-YEAR`
`FLC-BUDGET-NBR`	→	`FCA-BUDGET-NBR`
`FLC-JE-TYPE`	→	`FCA-JE-TYPE`
`FLC-CONTROL-GROUP`	→	`FCA-CONTROL-GROUP`
—	→	`FCA-ACTION`
—	→	`FCA-DATE`
—	→	`FCA-TIME`
—	→	`FCA-UNIQUE-I-D`

Fbtrans

FBTRANS

Delete Cascades

`FLC-COMPANY`	→	`FLT-COMPANY`
`FLC-FISCAL-YEAR`	→	`FLT-FISCAL-YEAR`
`FLC-BUDGET-NBR`	→	`FLT-BUDGET-NBR`
`FLC-JE-TYPE`	→	`FLT-JE-TYPE`
`FLC-CONTROL-GROUP`	→	`FLT-CONTROL-GROUP`
—	→	`FLT-LINE-NBR`

Programs

Updated by (12)

FB145 Budget Batch Journal Control
FB190 Budget Double Entry Posting
FB40.1 Budget Journal Entry
FB40.2 Define Budget Journal
FB40.3 Budget Speed Entry
FB40.4 Budget Journal Copy
FB45.1 Budget Journal Control
GL110 Company Copy Delete
GL197 Period, Year End GL Commitments Processing
GL199 Period Closing
GL300 General Ledger History Delete
GL500 Fiscal Year Change

Referenced by (83)

CA110 Allocation Calculation
CA195 Budget Allocation Interface
FB10.1 Spread Code
FB100 Budget Calculation - Computes
FB101 Budget Calculation - Rates
FB11.1 Budget Edit Group
FB111 Budget Edit Group Build
FB120 Intracompany Mass Budgeting
FB121 Intercompany Mass Budgeting
FB122 Budget Version
FB160 Budget Edit Group Interface
FB165 Budget Interface
FB20.1 Period Budget, Rate
FB20.2 Define Budget
FB20.3 By Account
FB20.4 By Accounting Unit
FB20.6 Period Budget, Amounts
FB20.7 Period Budget, Units
FB21.1 Budget by Period
FB211 Budget Edit Group Listing
FB240 Budget Journal Edit Listing
FB296 Budget Audit
FB30.1 Computed By Accounting Unit
FB31.1 Computed By Account
FB325 Budget Actuals Rebuild
FB35.1 Interbudget Relationships
FB42.1 Budget Adjustment Code
FB60.1 Budget Edit Group Interface Maintenance
FB95.1 Budget Analysis
FB95.2 Account, Period
FB95.3 Account, Year to Date
FB95.4 Accounting Unit, Period
FB95.5 Accounting Unit, Year to Date
FB95.6 Totals
GL120 Level Reorganization
GL298 GL Commitment Analysis Report
GL299 GL and AC History commitment
GL90.6 Compare Transaction Analysis
GL94.1 Commitment Analysis
GL94.2 Account
GL94.3 Account Totals
GL94.4 Accounting Unit
GL94.5 Accounting Unit Totals
GL94.6 Commitment Account Detail
GL94.7 Commitment Accounting Unit Detail
GL95.1 Account Analysis
GL95.2 Fiscal Year Summary
GL95.3 Totals
GL95.4 Chart Query
GL95.5 Periods versus Year to Date
GL95.6 Year to Date Current Year versus Last Year
GL95.7 Periods Current Year versus Last Year
GL95.8 Year to Date Actual versus Budget
GL95.9 Periods Actual versus Budget
GL96.1 Accounting Units
GL96.2 Year to Date Current Year versus Last Year
GL96.3 Periods Current Year versus Last Year
GL96.4 Year to Date Actual versus Budget
GL96.5 Periods Actual versus Budget
GL97.1 Accounts
GL97.2 Year to Date Current Year versus Last Year
GL97.3 Periods Current Year versus Last Year
GL97.4 Year to Date Actual versus Budget
GL97.5 Periods Actual versus Budget
GL97.6 Year to Date Account Currencies
GL97.7 Periods Account Currencies
GL97.8 Fiscal Year Summary
GL97.9 Totals
GL98.1 Companies
GL98.2 Year to Date Current Year versus Last Year
GL98.3 Periods Current Year versus Last Year
GL98.4 Year to Date Actual versus Budget
GL98.5 Periods Actual versus Budget
GL99.1 Organization Query
GL99.2 Periods versus Year to Date
GL99.3 Year to Date Current Year versus Last Year
GL99.4 Periods Current Year versus Last Year
GL99.5 Year to Date Actual versus Budget
GL99.6 Periods Actual versus Budget
GLCC.1 Print interface for Glp65pd
SNOP.1 REVENUE PLANNED
SNRP.1 REVENUE PLANNED
SNSP.1 REVENUE PLANNED

FBCONTROL – Budget Journal Control

About FBCONTROL

Fields (26) Copy as SQL

Indexes (2)

Relations

One to one (2) — lookups and parents

One to many (2) — child tables

Programs

Updated by (12)

Referenced by (83)

Fields (26)