|
|
FBUDGETREL FILE
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 FB195 FB65.1 FB165
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBR-RUN-GROUP Alpha 15 AC527 FB195
Element: Run Group The run group name. A run group name is FB65.1
the name you assigned to the file when
you transferred the non-Lawson file to
the target machine.
FBR-SEQ-NUMBER Numeric 6 AC527 FB195
Element: Sequence The sequence number is a unique number FB65.1
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.
FBR-OLD-COMPANY Alpha 35 AC527 FB195
Element: OrganizationalThe old company identification code FB65.1
defined in GL08.1 (Organization
Relationships).
FBR-OLD-CPY-SHORT Derived
Old Company (Short This is a short version of the old
Version) company structure.
FBR-OLD-ACCT-NBR Alpha 25 AC527 FB195
Element: Old Account NuThe old account identification code FB65.1
defined in GL09.1 (Account
Relationships).
FBR-OLD-ACCT-SHORT Derived
Old Acct Nbr (Short This is the short version of the old
Version) account structure.
FBR-FISCAL-YEAR Numeric 4 AC527 FB195
Element: Year This is the fiscal year budgets are FB65.1
transferred in.
FBR-BUDGET-NBR Numeric 3 AC527 FB195
Element: Budget The budget number as defined in FB20.1 FB65.1
(Period Budget, Rate) you are converting
data to.
FBR-BEGIN-BAL Signed 18.2 AC527 FB195
Element: Beg Bal The beginning balance period amount for FB65.1
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.
FBR-AMOUNT Signed 18.2 Occurs 13 Times AC527 FB195
Element: Amounts The period amount. For example, how FB65.1
much you spent on computers in a period.
FBR-BEGIN-BAL-UNT Signed 15.2 AC527 FB195
Element: Beg Bal The units beginning balance for a FB65.1
balance sheet account. For example, a
unit would be the number of computers
purchased.
FBR-UNITS Signed 15.2 Occurs 13 Times AC527 FB195
Element: Amounts The budget unit. For example, a unit FB65.1
would be the number of computers
purchased.
FBR-BEG-BAL-RATE Signed 14.7 AC527 FB165
Element: Curr Rate The rate that affects the factor. For FB65.1
example, the inflation rate or an
employees hourly contract salary.
FBR-FACTOR-RATE Signed 14.7 Occurs 13 Times AC527 FB165
Element: Curr Rate The rate that affects the factor. For FB65.1
example, the inflation rate.
FBR-BEG-BAL-FACTOR Alpha 15 AC527 FB65.1
Element: Factor The global factor defined in FB00.1
(Global Factors) that is used to help
calculate the budget amount.
FBR-FACTOR Alpha 15 Occurs 13 Times AC527 FB65.1
Element: Factor The global factor defined in FB00.1
(Global Factors) that is used to
calculate the budget amount.
FBR-AMOUNT-TYPE Alpha 1 AC527 FB165
Element: Type This field determines whether the FB195 FB65.1
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
FBR-CURRENCY-CODE Alpha 5 AC527 FB165
Element: Currency Code This field contains the company base FB195 FB65.1
currency code established in Company
(GL10.1 ).
FBUDGETREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBRSET1 RUN-GROUP AC527 FB165
SEQ-NUMBER FB195 FB65.1
FBRSET2 RUN-GROUP KeyChange FB265
OLD-COMPANY
OLD-ACCT-NBR
FISCAL-YEAR
BUDGET-NBR
SEQ-NUMBER
FBUDGETREL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
