FBUDGETREL – Budgeting Relationships

System: General Ledger (GL)
Prefix: FBR
Primary key: RUN-GROUP, SEQ-NUMBER
Fields: 18
Updated by: 4 programs
Referenced by: 2 programs

FBUDGETREL is the Budgeting Relationships table in Lawson General Ledger (prefix FBR). It is indexed by RUN-GROUP, SEQ-NUMBER (FBRSET1); alternate indexes: FBRSET2. It is related 1:1 to FBBGTRLBOD, GLACCTREL and GLCOMPREL. It is updated by AC527, FB165, FB195 and FB65.1 and referenced by FB265 and GLBO.2. The table has 18 fields, 2 indexes and 3 documented relations.

About FBUDGETREL

The Budget Relations file contains information for budget conversion from a non-Lawson system to the Lawson General Ledger system.

Fields (18)

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

Field / column	Type	Description & values	Updated by
`FBR-RUN-GROUP` PK RUN_GROUP	Alpha 15	The run group name. A run group name is the name you assigned to the file when you transferred the non-Lawson file to the target machine.	AC527, FB195, FB65.1
`FBR-SEQ-NUMBER` PK SEQ_NUMBER	Numeric 6	The sequence number is a unique number assigned to each transaction to be transferred into the Lawson system. Run Group and Sequence Number are the keys to this file. Use these fields to group records together for interfacing.	AC527, FB195, FB65.1
`FBR-OLD-COMPANY` OLD_COMPANY	Alpha 35	The old company identification code defined in GL08.1 (Organization Relationships).	AC527, FB195, FB65.1
`FBR-OLD-CPY-SHORT` OLD_CPY_SHORT	Derived	This is a short version of the old company structure.	—
`FBR-OLD-ACCT-NBR` OLD_ACCT_NBR	Alpha 25	The old account identification code defined in GL09.1 (Account Relationships).	AC527, FB195, FB65.1
`FBR-OLD-ACCT-SHORT` OLD_ACCT_SHORT	Derived	This is the short version of the old account structure.	—
`FBR-FISCAL-YEAR` FISCAL_YEAR	Numeric 4	This is the fiscal year budgets are transferred in.	AC527, FB195, FB65.1
`FBR-BUDGET-NBR` BUDGET_NBR	Numeric 3	The budget number as defined in FB20.1 (Period Budget, Rate) you are converting data to.	AC527, FB195, FB65.1
`FBR-BEGIN-BAL` BEGIN_BAL	Signed 18.2	The beginning balance period amount for balance sheet accounts. For example, the amount you spent for the computers in a particular period. If you select units and a rate, the system calculates the amount.	AC527, FB195, FB65.1
`FBR-AMOUNT` AMOUNT	Signed 18.2 Occurs 13 Times ×13	The period amount. For example, how much you spent on computers in a period.	AC527, FB195, FB65.1
`FBR-BEGIN-BAL-UNT` BEGIN_BAL_UNT	Signed 15.2	The units beginning balance for a balance sheet account. For example, a unit would be the number of computers purchased.	AC527, FB195, FB65.1
`FBR-UNITS` UNITS	Signed 15.2 Occurs 13 Times ×13	The budget unit. For example, a unit would be the number of computers purchased.	AC527, FB195, FB65.1
`FBR-BEG-BAL-RATE` BEG_BAL_RATE	Signed 14.7	The rate that affects the factor. For example, the inflation rate or an employees hourly contract salary.	AC527, FB165, FB65.1
`FBR-FACTOR-RATE` FACTOR_RATE	Signed 14.7 Occurs 13 Times ×13	The rate that affects the factor. For example, the inflation rate.	AC527, FB165, FB65.1
`FBR-BEG-BAL-FACTOR` BEG_BAL_FACTOR	Alpha 15	The global factor defined in FB00.1 (Global Factors) that is used to help calculate the budget amount.	AC527, FB65.1
`FBR-FACTOR` FACTOR	Alpha 15 Occurs 13 Times ×13	The global factor defined in FB00.1 (Global Factors) that is used to calculate the budget amount.	AC527, FB65.1
`FBR-AMOUNT-TYPE` AMOUNT_TYPE	Alpha 1	This field determines whether the amount fields are period balances or year-to-date balances. The interface program uses this field to load the files correctly. `P` Period `Y` YTD	AC527, FB165, FB195, FB65.1
`FBR-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	AC527, FB165, FB195, FB65.1

Indexes (2)

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

Index	Keys	Flags	Condition	Used in
`FBRSET1`	`RUN-GROUP`, `SEQ-NUMBER`	Primary		AC527, FB165, FB195, FB65.1, GLBO.2
`FBRSET2`	`RUN-GROUP`, `OLD-COMPANY`, `OLD-ACCT-NBR`, `FISCAL-YEAR`, `BUDGET-NBR`, `SEQ-NUMBER`	KeyChange		FB265

Relations

One to one (3) — lookups and parents

Relation	Table	Rules	Field map
Fbbtrlbod	FBBGTRLBOD	Not Required, Delete Cascades	`FBR-RUN-GROUP` → `YBP-RUN-GROUP`, `FBR-SEQ-NUMBER` → `YBP-SEQ-NUMBER`
Glacctrel	GLACCTREL	Not Required	`FBR-OLD-ACCT-NBR` → `GAR-OLD-ACCT-NBR`
Glcomprel	GLCOMPREL	Not Required	`FBR-OLD-COMPANY` → `GCR-OLD-COMPANY`

FBUDGETREL – Budgeting Relationships

About FBUDGETREL

Fields (18)

Indexes (2)

Relations

One to one (3) — lookups and parents

Programs

Updated by (4)

Referenced by (2)