Lawson Insight Technical Documentation |
|
FBFUNDDTL
FBFUNDDTL FILE
Budget Fund Detail
The Budgt Edit Group Detail file contains a record for each member of the
group maintained in FB11.
REFERENCED BY
AC191 AC40.4 AC41.4 AC42.1 AP125 AP126
AP170 AP193 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP520 API1.1 API2.1
BR41.4 BR44.1 CB10.1 CB15.1 CB15.2 CB150
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 EE135 EE35.1
EE35.2 EE520 CA110 FB145 FB190 FB40.1
FB40.2 FB40.3 FB45.1 GL146 GL165 GL170
GL197 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8
GL44.1 GL45.1 GL65.1 GL70.1 GL70.2 GL70.3
GL70.5 GL70.6 GL75.1 IFAC.1 MA41.1 MA41.2
MA41.4 MA41.7 MA43.2 MA61.1 MAI1.1 PO150
PO25.1 PO25.6 PO25.7 PO536 POIM.1 RQ10.1
RQ10.3 RQ11.1 RQ13.2 RQ35.1 RQ500 RQIB.1
RQIF.1 RQIJ.1 CA195 FB100 FB101 FB120
FB121 FB122 FB165 FB20.1 FB20.3 FB20.4
FB20.6 FB20.7 FB21.1 FB30.1 FB31.1 GL167
GL190 GL191 GL199 GL500 IFGT.1
UPDATED BY
FB11.1 FB111 FB160 FB211 GL110
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FUD-COMPANY Numeric 4 FB11.1 FB111
Element: Company The company number represents an FB160 FB211
established General Ledger company. GL110
FUD-FUND-GROUP Alpha 15 FB11.1 FB111
Element: Fund Group The budget edit group established in FB160 FB211
FB11 represents a set of accounting
units and accounts that are grouped
together for budget editing purposes.
FUD-ACCT-UNIT Alpha 15 FB11.1 FB111
Element: Acct Unit The accounting unit along with the FB160 FB211
company and account represent a member
record for the budget edit group.
FUD-ACCOUNT Numeric 6 FB11.1 FB111
Element: Account The account along with the company and FB160 FB211
accounting unit represent a member
record for the budget edit group.
FUD-SUB-ACCOUNT Numeric 4 FB11.1 FB111
Element: Sub Acct The subaccount along with the company, FB160 FB211
accounting unit and account represent a
member record for the budget edit group.
FBFUNDDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FUDSET1 COMPANY AC191 AC40.4
FUND-GROUP AC41.4 AC42.1
ACCT-UNIT AP125 AP126
ACCOUNT AP170 AP193
SUB-ACCOUNT AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
API1.1 API2.1
BR41.4 BR44.1
CB10.1 CB15.1
CB15.2 CB150
...
FUDSET2 COMPANY AC191 AC40.4
ACCOUNT AC41.4 AC42.1
SUB-ACCOUNT AP125 AP126
ACCT-UNIT AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
API1.1 API2.1
BR41.4 BR44.1
CB10.1 CB15.1
CB15.2 CB150
...
FBFUNDDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Fbfundhdr FBFUNDHDR Required
FUD-COMPANY -> FUH-COMPANY
FUD-FUND-GROUP -> FUH-FUND-GROUP
|