Budgeting Relationships

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

REFERENCED BY

FB265

UPDATED BY

AC527

FB165

FB195

FB65.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
FBR-RUN-GROUP Element: 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 Element: Sequence	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 Element: Organizational Code	Alpha 35 The old company identification code defined in GL08.1 (Organization Relationships).	AC527 FB195 FB65.1
FBR-OLD-CPY-SHORT Old Company (Short Version)	Derived This is a short version of the old company structure.
FBR-OLD-ACCT-NBR Element: Old Account Number	Alpha 25 The old account identification code defined in GL09.1 (Account Relationships).	AC527 FB195 FB65.1
FBR-OLD-ACCT-SHORT Old Acct Nbr (Short Version)	Derived This is the short version of the old account structure.
FBR-FISCAL-YEAR Element: Year	Numeric 4 This is the fiscal year budgets are transferred in.	AC527 FB195 FB65.1
FBR-BUDGET-NBR Element: Budget	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 Element: Beg 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 Element: Amounts	Signed 18.2 Occurs 13 Times The period amount. For example, how much you spent on computers in a period.	AC527 FB195 FB65.1
FBR-BEGIN-BAL-UNT Element: Beg Bal	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 Element: Amounts	Signed 15.2 Occurs 13 Times The budget unit. For example, a unit would be the number of computers purchased.	AC527 FB195 FB65.1
FBR-BEG-BAL-RATE Element: Curr 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 Element: Curr Rate	Signed 14.7 Occurs 13 Times The rate that affects the factor. For example, the inflation rate.	AC527 FB165 FB65.1
FBR-BEG-BAL-FACTOR Element: 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 Element: Factor	Alpha 15 Occurs 13 Times The global factor defined in FB00.1 (Global Factors) that is used to calculate the budget amount.	AC527 FB65.1
FBR-AMOUNT-TYPE Element: 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 Element: Currency Code	Alpha 5 This field contains the company base currency code established in Company (GL10.1 ).	AC527 FB165 FB195 FB65.1

FBUDGETREL FILE INDEX

FBUDGETREL FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.