|
|
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
FB165 FB195 FB65.1 CU00.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBR-RUN-GROUP Alpha 12 FB195 FB65.1
Run Group 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.
FBR-SEQ-NUMBER Numeric 6 FB195 FB65.1
Sequence 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.
FBR-OLD-COMPANY Alpha 35 FB195 FB65.1
Organizational Code The old company identification code
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 FB195 FB65.1
Old Account Number The old account identification code
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 FB195 FB65.1
Year This is the fiscal year budgets are
transferred in.
FBR-BUDGET-NBR Numeric 3 FB195 FB65.1
Budget The budget number as defined in FB20.1
(Period Budget, Rate) you are converting
data to.
FBR-BEGIN-BAL Signed 15.2 FB195 FB65.1
Beginning balance 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.
FBR-AMOUNT Currency 15.2 Occurs 13 Times FB195 FB65.1
Amounts The period amount. For example, how
much you spent on computers in a period.
FBR-BEGIN-BAL-UNT Signed 15.2 FB195 FB65.1
Units Beginnign The units beginning balance for a
Balance balance sheet account. For example, a
unit would be the number of computers
purchased.
FBR-UNITS Signed 15.2 Occurs 13 Times FB195 FB65.1
Units The budget unit. For example, a unit
would be the number of computers
purchased.
FBR-BEG-BAL-RATE Signed 12.6 FB165 FB195
Rate Beginning The rate that affects the factor. For FB65.1
Balance example, the inflation rate or an
employees hourly contract salary.
FBR-FACTOR-RATE Signed 12.6 Occurs 13 Times FB165 FB195
Rate The rate that affects the factor. For FB65.1
example, the inflation rate.
FBR-BEG-BAL-FACTOR Alpha 15 FB195 FB65.1
Factor Beginning The global factor defined in FB00.1
Balance (Global Factors) that is used to help
calculate the budget amount.
FBR-FACTOR Alpha 15 Occurs 13 Times FB195 FB65.1
Factor The global factor defined in FB00.1
(Global Factors) that is used to
calculate the budget amount.
FBR-AMOUNT-TYPE Alpha 1 FB165 FB195
Type This field determines whether the 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
FBUDGETREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBRSET1 RUN-GROUP FB165 FB195
SEQ-NUMBER* FB65.1 CU00.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
|