FBFUNDDTL – Budget Fund Detail
- System
- General Ledger (GL)
- Prefix
FUD- Primary key
COMPANY,FUND-GROUP,ACCT-UNIT,ACCOUNT,SUB-ACCOUNT- Fields
- 5
- Updated by
- 5 programs
- Referenced by
- 372 programs
FBFUNDDTL is the Budget Fund Detail table in Lawson General Ledger (prefix FUD). It is indexed by COMPANY, FUND-GROUP, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT (FUDSET1); alternate indexes: FUDSET2. It is related 1:1 to FBFUNDHDR. It is updated by FB11.1, FB111, FB160, FB211 and GL110 and referenced by AC191, AC40.4, AC41.4, AC42.1, AP125, AP126, AP131, AP170 and 364 more. The table has 5 fields, 2 indexes and 1 documented relation.
About FBFUNDDTL
The Budgt Edit Group Detail file contains a record for each member of the group maintained in FB11.
Fields (5)
Column = COBOL field name without the FUD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
FUD-COMPANY PKCOMPANY | Numeric 4 | The company number represents an established General Ledger company. | FB11.1, FB111, FB160, FB211, GL110 |
FUD-FUND-GROUP PKFUND_GROUP | Alpha 15 | The budget edit group established in FB11 represents a set of accounting units and accounts that are grouped together for budget editing purposes. | FB11.1, FB111, FB160, FB211, GL322 |
FUD-ACCT-UNIT PKACCT_UNIT | Alpha 15 | The accounting unit along with the company and account represent a member record for the budget edit group. | FB11.1, FB111, FB160, FB211 |
FUD-ACCOUNT PKACCOUNT | Numeric 6 | The account along with the company and accounting unit represent a member record for the budget edit group. | FB11.1, FB111, FB160, FB211 |
FUD-SUB-ACCOUNT PKSUB_ACCOUNT | Numeric 4 | The subaccount along with the company, accounting unit and account represent a member record for the budget edit group. | FB11.1, FB111, FB160, FB211 |
Indexes (2)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
FUDSET1 | COMPANY, FUND-GROUP, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT | Primary | FB11.1, FB11.2, FB111, FB160, FB211, GL110 | |
FUDSET2 | COMPANY, ACCOUNT, SUB-ACCOUNT, ACCT-UNIT | AC191, AC40.4, AC41.4, AC42.1, AP125, AP126, AP131, AP170 +22 more (list truncated in source) |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Fbfundhdr | FBFUNDHDR | Required | FUD-COMPANY → FUH-COMPANY, FUD-FUND-GROUP → FUH-FUND-GROUP |
Programs
Updated by (5)
- FB11.1 Budget Edit Group
- FB111 Budget Edit Group Build
- FB160 Budget Edit Group Interface
- FB211 Budget Edit Group Listing
- GL110 Company Copy Delete
Referenced by (372)
- AC191 Accounting Unit Balance Post
- AC40.4 Journal Entry (AC and GL)
- AC41.4 Resource Time Entry (AC and GL)
- AC42.1 Subcontractor Time and Material Entry
- AP125 Batch Release
- AP126 Mass Invoice Release
- AP131 Chargeback
- AP170 Payment Closing
- AP190 Invoice Reinstatement
- AP193 Recurring Invoice Update
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP25.1 Batch Control
- AP25.2 Batch Review
- AP26.1 Invoice Release
- AP27.1 Single Invoice Release
- AP30.2 Distribution Adjustments
- AP30.4 Invoice Cancel
- AP510 Vendor Conversion
- AP520 Invoice Interface
- API1.1 Add Invoice
- API2.1 Add Invoice
- ARLL.1 AR Transaction Interface
- BN150 Life Insurance Reportable Income
- BN66.1 Estimated Pay Calculation
- BR41.4 Contract Adjustment (AC and GL)
- BR44.1 Mass Transaction Transfer
- CA110 Allocation Calculation
- CA195 Budget Allocation Interface
- CB10.1 Cash Receipt Deposit
- CB15.1 Bank Fund Transfer - Multiple Deposits
- CB15.2 Bank Fund Transfer - Multiple Withdrawals
- CB150 Mass Release
- CB180 Cash Ledger Void Update
- CB191 Bank Statement Close
- CB20.1 Bank Transaction Entry
- CB222 Cash Position Reconciliation
- CB30.1 Reconciliation Variance Adjustment
- CB45.1 EFT/CC Extract Entry
- CB46.1 Returned Payment Entry
- CB500 Bank Transaction Interface
- CB543 Receipts Load
- CB544 Returned Payment Load
- CB55.1 Payment Entry
- CB554 Payment Load
- CB57.1 Payment Cancel
- CB80.1 Bank Transaction Adjustment
- CB82.1 Statement Reconciliation
- CX100 Pick List Print
- CX20.1 Case Build
- CX20.2 Case Detail
- CX20.4 Substitute Items
- CX20.5 Insert line
- CX220 Case, Preference Listing
- CX30.1 Case Completion Feedback
- CX300 Preference List Purge
- CX506 HL7 Schedules Import Interface
- CXCP.1 Copy preference to case
- DR100 Distribution Requirements Report
- EE135 Mass Employee Release
- EE35.1 Advance Release
- EE35.2 Expense Release
- EE520 Expense Interface
- EX175 Company Expense Posting
- EX542 Expense Creation
- EX545 Advance Payback Creation
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- FB100 Budget Calculation - Computes
- FB101 Budget Calculation - Rates
- FB120 Intracompany Mass Budgeting
- FB121 Intercompany Mass Budgeting
- FB122 Budget Version
- FB145 Budget Batch Journal Control
- FB165 Budget Interface
- FB190 Budget Double Entry Posting
- FB20.1 Period Budget, Rate
- FB20.3 By Account
- FB20.4 By Accounting Unit
- FB20.6 Period Budget, Amounts
- FB20.7 Period Budget, Units
- FB21.1 Budget by Period
- FB30.1 Computed By Accounting Unit
- FB31.1 Computed By Account
- FB40.1 Budget Journal Entry
- FB40.2 Define Budget Journal
- FB40.3 Budget Speed Entry
- FB45.1 Budget Journal Control
- GL146 Batch Journal Control
- GL165 Transaction Interface
- GL167 Balance Interface
- GL170 Recurring Journal Interface
- GL190 Journal Posting
- GL191 Currency Revaluation
- GL197 Period, Year End GL Commitments Processing
- GL199 Period Closing
- GL322 GLHISCOMBL File Rebuild
- GL40.1 Journal Entry
- GL40.2 Define Journal
- GL40.3 Speed Entry
- GL40.7 Totals
- GL40.8 Journal Entry
- GL44.1 Report Currency Entry
- GL45.1 Journal Control
- GL500 Fiscal Year Change
- GL65.1 Transaction Interface Maintenance
- GL70.1 Recurring Journal
- GL70.2 Define Recurring Journal
- GL70.3 Amounts Only
- GL70.5 Filter
- GL70.6 Recurring Copy
- GL75.1 Recurring Journal Control
- GL76.1 Manual Commitment Entry
- IC12.1 Item Location
- IC140 Vendor Reorder Advice
- IC141 Location Replenishment Report
- IC142 Replenishment by Requisition PO's
- IC145 Stock Status Report
- IC222 Unreleased Documents
- IC243 Killed Item Report
- IC330 Item Mass Change
- IC64.1 Global Location Nbr Assignment GL/IC Company
- IC64.2 Global Location Nbr Assignment IC Location
- IC64.3 Global Location Number Assignment RQ Location
- IC64.4 Global Location Number Assignment Manuf Code
- IC64.5 Global Location Number Assignment Manuf Div
- IC64.6 Global Location Number Assignment Vendor
- IC64.7 Global Location Number Assignment Vendor Location
- IC64.8 Global Location Number Assignment IC Bin
- IC64.9 Global Location Number Assignment Buyer
- IC66.1 Replenishment PO Worksheet
- IC83.1 Par Location Counts
- IFAC.1 General Ledger Account Edit
- IFEB.1 GL and AC Budget Edit
- IFGT.1 GLTRANS Interface
- IFUC.1 Commitment Update GL and AC
- LP130 Absence Plan Payout
- MA180 Open Receipt Archive
- MA278 Cost Variance Analysis
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA43.7 GL Distribution
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA53.1 Receipt Interface
- MA530 ERS Invoice Creation
- MA531 Receipt Interface
- MA60.2 Invoice Level Match
- MA60.3 Detail Level Match
- MA60.5 Receipt Match Reference Adjustment
- MA61.1 Match Invoice Approval
- MA66.2 Invoice Message - Details
- MA67.2 Invoice Match from frontend
- MA67.3 Detail Match from frontend
- MA68.2 Invoice Level Match - Prepaid
- MA68.3 Detail Level Match - Prepaid
- MA68.5 Receipt Match Reference Adjustment
- MA70.1 Invoice Unmatch
- MA75.1 PO Invoice Cancel
- MA80.1 Receipt Archive
- MAI1.1 Invoke for MAMATCH Object
- ML165 Ledger Transaction Interface
- ML65.1 Ledger Transaction Interface Maintenance
- PA182 Salary Encumbrance Update
- PD10.1 P-Card Card Request
- PD10.2 P-Card Cardholder
- PD130 P-Card Invoice and Release
- PD20.1 P-Card Charge Approval
- PD20.2 P-Card Charge Approval Level
- PD20.3 P-Card Charge Approval SEA
- PD570 P-Card Charge Import
- PO04.1 Buyer
- PO04.2 Buyer Purchasing Class
- PO10.1 PO Vendor
- PO10.2 Vendor Purchase From Location
- PO100 Purchase Order Interface from Lawson Applications
- PO101 Create Standing PO Release
- PO115 Procurement Template Mass Changes
- PO120 Mass PO Issue
- PO122 Transmitted PO Acknowledgement
- PO131 Receiving Log
- PO132 Print Vendor Return Material Authorization
- PO135 Received, Not Invoiced Report
- PO136 Matched, Not Received Report
- PO15.1 Procurement Templates
- PO15.2 Procurement Template Participants
- PO15.4 Procurement Template Line Detail
- PO150 Bid Load to Contract or Catalog
- PO17.1 Purchase Order Approval Review
- PO18.1 Workflow Approval Maintenance
- PO190 Close Purchase Order Header
- PO20.1 Purchase Order Entry
- PO20.6 Substitute Vendor Items
- PO20.9 Multiple Lines
- PO204 Buyer Master Listing
- PO21.1 Select and Copy
- PO21.2 Add-On Cost Spread
- PO21.3 Account Distribution
- PO21.4 Miscellaneous Add-On Cost
- PO21.5 Item Add-On Cost
- PO22.1 Authorization, Release
- PO22.3 Mass Cancel or Delete Purchase Orders
- PO22.4 Mass Cancel or Delete Purchase Order Lines
- PO220 PO Status Report
- PO222 Remaining PO Balance Report
- PO224 PO Revision Report
- PO225 Vendor Agreement Listing
- PO229 Vendor Agreement Format Print
- PO23.1 Purchase Order Worksheet
- PO230 Unreleased Receivings Listing
- PO234 PO Interface Listing Report
- PO24.1 Purchase Order Direct Approval
- PO25.1 Vendor Agreements
- PO25.5 Vendor Agreement Item Add-On Cost
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO251 PO Buyer Message Listing
- PO26.2 Vendor Agreement Line Distributions
- PO26.3 Vendor Agreement Commitments Spread
- PO26.4 Vendor Agreement Line Price Breaks
- PO26.5 Vendor Agreement Line Price Breaks
- PO26.6 Vendor Agreement Line Maximums
- PO26.7 Mass Release of Vendor Agreements
- PO26.9 Vendor Agreement Release
- PO27.2 Select Blanket Lines
- PO27.3 Create PO From Procurement Template
- PO27.4 Select and Copy Template
- PO275 Delivery Date Analysis
- PO276 Deliver Quantity Analysis
- PO277 Deliver Quality Analysis
- PO28.2 Vendor Agreement Line Detail List
- PO280 Purchases By Class
- PO29.1 Copy Purchase Order
- PO30.1 PO Receiving
- PO30.2 Substitute Item
- PO30.3 Additional Tracking Numbers
- PO30.4 PO Receiving Line Detail List
- PO300 PO and Receipt Purge
- PO31.1 Vendor Return
- PO31.2 Vendor Return Item Selection
- PO32.2 Item Detail
- PO32.4 Cancel Detail
- PO33.1 Receiving Adjustment
- PO34.1 Inspection Accept or Reject
- PO35.1 Receiving Approval and Release
- PO36.1 Identify Lawson Items by Vendor Agreement Line
- PO36.2 Vendor Agreement Import Manual Input
- PO38.1 Invoice AOC
- PO39.1 Additional Receiving Entry
- PO39.2 Additional Adjustment/Rejection Entry
- PO44.1 PO Line Source
- PO50.1 Buyer Message Entry
- PO52.1 Buyer Message - Receiving
- PO520 Purchase Order Interface from Non Lawson
- PO536 Vendor Price Agreement Load
- PO54.5 PO Line Detail List
- POCP.1 POC Comments Copy
- POD0.1 Po Orphan Record Check
- POI3.1 Invoke for POPI70PD
- POID.1 PO Delivery Ticket Select
- POIF.1 MMDIST Activity Commit
- POII.1 Invoke for POPCRUPD
- POIJ.1 Invoke for POPLIUPD
- POIK.1 Edit AC and GL Budgets
- POIM.1 GL Budget Ck for PO and RQ
- PR128 Offset Time Record Creation
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR140 Earnings and Deductions Calculation
- PR189 Gross Up Calculation
- PR195 Accrual Program
- PR197 Payroll Close
- PR29.1 Pension Payment Maintenance
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR37.1 Batch Time Control
- PR38.1 Time Record Selection
- PR45.1 Error Processing
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR530 Time Record Interface CSV
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR80.1 Manual Check
- PR80.4 Manual Payment
- PR82.1 Adjustment
- PR85.1 Bank Account Reconciliation
- PR89.1 Payment Modeling
- PRAT.1 Alltax connection test
- RQ01.1 Requesting Locations
- RQ10.1 Requisition
- RQ10.2 Account Distribution
- RQ10.3 Select and Copy
- RQ10.4 Requisition Line Entry Detail
- RQ10.5 Substitutes
- RQ11.1 Kit Accessories
- RQ12.1 Approval Review
- RQ13.1 Direct Approval
- RQ13.2 Direct Line Approval
- RQ35.1 Requisition Returns
- RQ44.1 Requisition Inquiry
- RQ500 Requisition Interface
- RQ810 Request Location Load
- RQD0.1 Invoke for RQ Orphan Check
- RQIB.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQII.1 Invoke for Reqheader Inquiry
- RQIJ.1 Requisition Copy
- TA147 Canada Vacation Audit
- UK102 Bonus Pay Update
- WH130 Pick List Print
- WH132 Batch Feedback
- WH190 Shipment Release
- WH20.2 Nonstock and Special Allocation
- WH20.7 Substitute Location
- WH222 Shipments In Process
- WH30.1 Picking Feedback by Document
- WH30.2 Picking Feedback by Shipment
- WH30.3 Picking by Batch
- WH30.4 Bin Sequence Picking Feedback
- WH31.1 Packing Feedback by Document
- WH31.2 Packing Feedback by Shipment
- WH31.3 Packing by Batch
- WH31.4 Bin Sequence Packing Feedback
- WH32.1 Shipping Feedback by Document
- WH32.2 Shipping Feedback by Shipment
- WH32.3 Shipping by Batch
- WH32.4 Bin Sequence Shipping Feedback
- WH32.5 Shipping Line Feedback
- WH33.1 Bins
- WH33.2 Lots
- WH33.3 Serials
- WH33.4 UOMs
- WH33.5 Additional Shipment Information
- WH33.6 Catch Weight
- WH33.8 Preassembled Kits
- WH33.9 Line Options
- WH34.1 Component Bins
- WH34.2 Component Lots
- WH34.3 Component Serials
- WH34.4 Component UOMs
- WH40.1 Bill of Lading
- WH40.2 Bill of Lading Feedback
- WH520 Batch Feedback Interface
- WH830 Shipment Load Program