FBINTBUAU – Budget Interbudget Rel Audit

System: General Ledger (GL)
Prefix: FIA
Primary key: COMPANY, BUDGET-A, BUDGET-B, ACTION, DATE, TIME, UNIQUE-I-D
Fields: 13
Updated by: 40 programs
Referenced by: 109 programs

FBINTBUAU is the Budget Interbudget Rel Audit table in Lawson General Ledger (prefix FIA). It is indexed by COMPANY, BUDGET-A, BUDGET-B, ACTION, DATE, TIME, UNIQUE-I-D (FIASET1); alternate indexes: FIASET2, FIASET3, FIASET4 and FIAUID. It is related 1:1 to FBINTBU. It is updated by CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 and 32 more and referenced by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 101 more. The table has 13 fields, 5 indexes and 1 documented relation.

About FBINTBUAU

No description in the Lawson data dictionary.

Fields (13)

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

Field / column	Type	Description & values	Updated by
`FIA-UNIQUE-I-D` PK UNIQUE_I_D	Bad Type 36	—	—
`FIA-COMPANY` PK COMPANY	Numeric 4	—	CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
`FIA-BUDGET-A` PK BUDGET_A	Numeric 3	—	CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
`FIA-BUDGET-B` PK BUDGET_B	Numeric 3	—	CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
`FIA-ACTION` PK ACTION	Alpha 1	— `A` Add `C` Change `D` Delete	CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
`FIA-OPERATOR` OPERATOR	Alpha 10	—	CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
`FIA-DATE` PK DATE	Numeric 8 (yyyymmdd)	—	CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
`FIA-TIME` PK TIME	Numeric 6 (hhmmss)	—	CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
`FIA-PROGRAM` PROGRAM	Alpha 5	—	CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
`FIA-FIELD-NAME` FIELD_NAME	Alpha 20 (Lower Case)	—	CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
`FIA-FIELD-ID` FIELD_ID	Numeric 3	—	CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
`FIA-OLD-VALUE` OLD_VALUE	Alpha 60 (Lower Case)	—	CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more
`FIA-NEW-VALUE` NEW_VALUE	Alpha 60 (Lower Case)	—	CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +31 more

Indexes (5)

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

Index	Keys	Flags	Used in
`FIASET1`	`COMPANY`, `BUDGET-A`, `BUDGET-B`, `ACTION`, `DATE`, `TIME`, `UNIQUE-I-D`	Primary	AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
`FIASET2`	`OPERATOR`, `ACTION`, `DATE`, `COMPANY`, `BUDGET-A`, `BUDGET-B`, `UNIQUE-I-D`		—
`FIASET3`	`ACTION`, `DATE`, `COMPANY`, `BUDGET-A`, `BUDGET-B`, `UNIQUE-I-D`		—
`FIASET4`	`DATE`, `COMPANY`, `ACTION`, `BUDGET-A`, `BUDGET-B`, `UNIQUE-I-D`		FB305
`FIAUID`	`UNIQUE-I-D`		—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Fbintbu	FBINTBU	Required		`FIA-COMPANY` → `FBI-COMPANY (FBISET1)`, `FIA-BUDGET-A` → `FBI-BUDGET-A`, `FIA-BUDGET-B` → `FBI-BUDGET-B`

Programs

Updated by (40)

CA110 Allocation Calculation
CA195 Budget Allocation Interface
FB10.1 Spread Code
FB100 Budget Calculation - Computes
FB101 Budget Calculation - Rates
FB11.1 Budget Edit Group
FB120 Intracompany Mass Budgeting
FB121 Intercompany Mass Budgeting
FB122 Budget Version
FB145 Budget Batch Journal Control
FB160 Budget Edit Group Interface
FB165 Budget Interface
FB190 Budget Double Entry Posting
FB20.1 Period Budget, Rate
FB20.2 Define Budget
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
FB305 Flex Budgeting Audit Analysis Purge
FB31.1 Computed By Account
FB325 Budget Actuals Rebuild
FB35.1 Interbudget Relationships
FB40.1 Budget Journal Entry
FB40.2 Define Budget Journal
FB40.3 Budget Speed Entry
FB40.4 Budget Journal Copy
FB42.1 Budget Adjustment Code
FB45.1 Budget Journal Control
GL110 Company Copy Delete
GL120 Level Reorganization
GL197 Period, Year End GL Commitments Processing
GL199 Period Closing
GL300 General Ledger History Delete
GL500 Fiscal Year Change
SNOP.1 REVENUE PLANNED
SNRP.1 REVENUE PLANNED
SNSP.1 REVENUE PLANNED

Referenced by (109)

AC191 Accounting Unit Balance Post
AP125 Batch Release
AP126 Mass Invoice Release
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
API1.1 Add Invoice
API2.1 Add Invoice
BR44.1 Mass Transaction Transfer
CB222 Cash Position Reconciliation
CU00.1 Currency Table
CU01.1 Currency Code
CU01.2 Currency Codes
CU02.1 Currency Relationship
CU02.2 Relationship Summary
CU03.1 Currency Gain Loss Accounts
CU10.1 Exchange Rates
CU10.2 Daily Rate Entry
CU20.1 Currency Table Translation Rates
CU20.2 Currency Table Period Rate Entry
CU20.3 Company Translation Rates
DR100 Distribution Requirements Report
FB278 Flex Budgeting Audit Analysis Report
FB91.8 Budget Interbudget Relationships Audit
GL00.2 Define Chart
GL00.3 Detail Accounts
GL00.6 Move Detail Account
GL00.7 System Accounts
GL00.9 Chart Copy
GL02.1 Detail Subaccount Definition
GL02.2 Multiple Detail Subaccount Definition
GL02.3 Template Subaccount Definition
GL02.6 Move Detail Account
GL03.6 Posting Account System Restriction
GL10.1 Company
GL10.2 Backposting Control
GL100 Mass Chart Account Change Delete
GL111 Backposting Control Mass Upd
GL121 Mass Account Addition
GL122 Mass Account Change Delete
GL124 Mass Accounting Unit Addition
GL125 Mass Accounting Unit Change
GL135 Intercompany Chart Map Posting
GL146 Batch Journal Control
GL148 Zone Rebalancing
GL160 Chart of Accounts Interface
GL161 Accounting Unit Interface
GL167 Balance Interface
GL190 Journal Posting
GL195 Translation Calculation
GL196 Report Currency Translation
GL20.1 Accounting Units - Accounts
GL20.2 Posting Accounts
GL20.4 Mass Add Accounts
GL330 Undistributed Retained Earnings 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
IC141 Location Replenishment Report
IC142 Replenishment by Requisition PO's
IC222 Unreleased Documents
IC83.1 Par Location Counts
IFAC.1 General Ledger Account Edit
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
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
MA61.1 Match Invoice Approval
MAI1.1 Invoke for MAMATCH Object
ML146 Batch Ledger Journal Control
ML167 Ledger Balance Interface
ML190 Ledger Journal Posting
ML195 Ledger Translation Calculation
ML196 Ledger Report Currency Translation
ML199 Ledger Period Closing
ML330 Ledger Undistributed RE Rebuil
ML40.1 Ledger Journal Entry
ML40.2 Define Ledger Journal
ML40.3 Ledger Speed Entry
ML40.7 Ledger Totals
ML40.8 Ledger Journal Entry
ML44.1 Ledger Report Currency Entry
ML45.1 Ledger Journal Control
RQ10.1 Requisition
RQ10.3 Select and Copy
RQ11.1 Kit Accessories
RQ13.2 Direct Line Approval
RQ35.1 Requisition Returns
RQ500 Requisition Interface
RQIB.1 RQRQHUPD Invoke Object
RQIF.1 RQRLNUPD Invoke Object
RQIJ.1 Requisition Copy