|
|
FBFUNDREL FILE
Budget Fund Interface
The Budget Edit Group conversion file contains information for budget edit
groups from a non-ln-Lawson system to the Lawson General Ledger system.
REFERENCED BY
FB260
UPDATED BY
FB160 FB60.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FFR-RUN-GROUP Alpha 15 FB60.1
Element: Run Group Run Group and Seq Number are the keys to
the file. They are used to group
records together for interfacing.
FFR-SEQ-NUMBER Numeric 6 FB60.1
Record Sequence A unique number assigned to each
Number transaction to be interfaced into the
Lawson system.
FFR-COMPANY Numeric 4 FB60.1
Element: Company The company number represents an
established General Ledger company.
FFR-FUND-GROUP Alpha 15 FB60.1
Element: Fund Group The budget edit group name established
in FB11 represents a set of acounting
units and accounts that are grouped
together for budget editing purposes.
FFR-DESCRIPTION Alpha 30 (Lower Case) FB60.1
Element: Description The budget edit group description.
FFR-ACCT-UNIT Alpha 15 FB60.1
Element: Accounting UniAn Accounting Unit. List or Level Group
is required.
The value is used to build the members
of the group (FBFUNDDTL).
FFR-ACCT-UNIT-LIST Alpha 12 FB60.1
Element: Acct Unit ListAn Accounting Unit. List or Level Group
is required.
The value is used to build the members
of the group (FBFUNDDTL).
FFR-LEVEL-GROUP Alpha 12 FB60.1
Element: Level Group An Accounting Unit. List or Level Group
is required.
The value is used to build the members
of the group (FBFUNDDTL).
FFR-SUMMARY-ACCT Alpha 12 FB60.1
Element: Summary AccounA Summary Account, List or Account Group
is required.
The value is used to build the members
of the group (FBFUNDDTL).
FFR-ACCOUNT-GROUP Alpha 12 FB60.1
Element: Account Group A Summary Account, List or Account Group
is required.
The value is used to build the members
of the group (FBFUNDDTL).
FFR-ACCOUNT-LIST Alpha 12 FB60.1
Element: Account List A Summary Account, List or Account Group
is required.
The value is used to build the members
of the group (FBFUNDDTL).
FFR-SUB-ACCT-GRP Alpha 12 FB60.1
Element: Sub Acct Grp The Subaccount Group is not required. If
a value is entered the specified
subaccounts will be included in the
detail members. If the value is blank,
only major accounts will be included in
the members (FBFUNDDTL).
FBFUNDREL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FFRSET1 RUN-GROUP FB160 FB260
SEQ-NUMBER FB60.1
FFRSET2 FUND-GROUP FB160
RUN-GROUP
SEQ-NUMBER
|
