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
AP25.1 AP25.2 AP26.1 AP27.1 AP30.2 BR41.4
BR44.1 CB10.1 CB15.1 CB15.2 CB191 CB20.1
CB30.1 CB500 EE135 EE35.1 EE35.2 EE520
CA110 FB145 FB190 FB40.1 FB40.2 FB40.3
FB45.1 GL146 GL165 GL170 GL197 GL199
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 IC222 IFAC.1 PO150 PO25.1
PO25.6 PO25.7 PO536 POIM.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 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: Accounting UniThe 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: Subaccount 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 AP25.1 AP25.2
SUB-ACCOUNT AP26.1 AP27.1
AP30.2 BR41.4
BR44.1 CB10.1
CB15.1 CB15.2
CB191 CB20.1
CB30.1 CB500
EE135 EE35.1
EE35.2 EE520
CA110 FB11.1
FB11.2 FB111
FB145 FB160
...
FUDSET2 COMPANY AC191 AC40.4
ACCOUNT AC41.4 AC42.1
SUB-ACCOUNT AP125 AP126
ACCT-UNIT AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 BR41.4
BR44.1 CB10.1
CB15.1 CB15.2
CB191 CB20.1
CB30.1 CB500
EE135 EE35.1
EE35.2 EE520
CA110 CA195
FB100 FB101
FB11.1 FB111
...
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
|