FBFUNDREL – Budget Fund Interface

System
General Ledger (GL)
Prefix
FFR
Primary key
RUN-GROUP, SEQ-NUMBER
Fields
12
Updated by
3 programs
Referenced by
1 program

FBFUNDREL is the Budget Fund Interface table in Lawson General Ledger (prefix FFR). It is indexed by RUN-GROUP, SEQ-NUMBER (FFRSET1); alternate indexes: FFRSET2. It is updated by FB11.1, FB160 and FB60.1 and referenced by FB260. The table has 12 fields, 2 indexes and 0 documented relations.

About FBFUNDREL

The Budget Edit Group conversion file contains information for budget edit groups from a non-ln-Lawson system to the Lawson General Ledger system.

Fields (12)

Column = COBOL field name without the FFR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
FFR-RUN-GROUP PK
RUN_GROUP		Alpha 15Run Group and Seq Number are the keys to the file. They are used to group records together for interfacing.FB60.1
FFR-SEQ-NUMBER PK
SEQ_NUMBER		Numeric 6A unique number assigned to each transaction to be interfaced into the Lawson system.FB60.1
FFR-COMPANY
COMPANY		Numeric 4The company number represents an established General Ledger company.FB60.1
FFR-FUND-GROUP
FUND_GROUP		Alpha 15The budget edit group name established in FB11 represents a set of acounting units and accounts that are grouped together for budget editing purposes.FB60.1
FFR-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The budget edit group description.FB60.1
FFR-ACCT-UNIT
ACCT_UNIT		Alpha 15An Accounting Unit. List or Level Group is required. The value is used to build the members of the group (FBFUNDDTL).FB60.1
FFR-ACCT-UNIT-LIST
ACCT_UNIT_LIST		Alpha 12An Accounting Unit. List or Level Group is required. The value is used to build the members of the group (FBFUNDDTL).FB60.1
FFR-LEVEL-GROUP
LEVEL_GROUP		Alpha 12An Accounting Unit. List or Level Group is required. The value is used to build the members of the group (FBFUNDDTL).FB60.1
FFR-SUMMARY-ACCT
SUMMARY_ACCT		Alpha 12A Summary Account, List or Account Group is required. The value is used to build the members of the group (FBFUNDDTL).FB60.1
FFR-ACCOUNT-GROUP
ACCOUNT_GROUP		Alpha 12A Summary Account, List or Account Group is required. The value is used to build the members of the group (FBFUNDDTL).FB60.1
FFR-ACCOUNT-LIST
ACCOUNT_LIST		Alpha 12A Summary Account, List or Account Group is required. The value is used to build the members of the group (FBFUNDDTL).FB60.1
FFR-SUB-ACCT-GRP
SUB_ACCT_GRP		Alpha 12The 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).FB60.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
FFRSET1RUN-GROUP, SEQ-NUMBERPrimaryFB160, FB260, FB60.1
FFRSET2FUND-GROUP, RUN-GROUP, SEQ-NUMBERFB11.1, FB160

Programs

Updated by (3)

Referenced by (1)