FBUDGETREL

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBRSET1 RUN-GROUP
SEQ-NUMBER
AC527 FB165
FB195 FB65.1
FBRSET2 RUN-GROUP
OLD-COMPANY
OLD-ACCT-NBR
FISCAL-YEAR
BUDGET-NBR
SEQ-NUMBER
KeyChange
FB265


FBUDGETREL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Glacctrel GLACCTREL Not Required
FBR-OLD-ACCT-NBR->GAR-OLD-ACCT-NBR
Glcomprel GLCOMPREL Not Required
FBR-OLD-COMPANY->GCR-OLD-COMPANY


File created: Thu Jun 09 11:13:06 2016

Home
Contact Us



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