FBINTBU – Interbudget Relationship

System
General Ledger (GL)
Prefix
FBI
Primary key
COMPANY, BUDGET-A, BUDGET-B
Fields
15
Updated by
2 programs
Referenced by
38 programs

FBINTBU is the Interbudget Relationship table in Lawson General Ledger (prefix FBI). It is indexed by COMPANY, BUDGET-A, BUDGET-B (FBISET1). It is related 1:M to FBINTBUAU. It is updated by FB35.1 and GL110 and referenced by CA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 and 30 more. The table has 15 fields, 1 index and 1 documented relation.

About FBINTBU

This file contains the budget relationships set up in the Interbudget Relationships Program (FB35). The budget relationships contain budgets with payable and receivable accounts.

Fields (15)

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

Field / columnTypeDescription & valuesUpdated by
FBI-COMPANY PK
COMPANY		Numeric 4The company whose interbudget relationship is being established.FB35.1, GL110
FBI-BUDGET-A PK
BUDGET_A		Numeric 3This field represents the originating budget for an interbudget relationship where balances are transferred from.FB35.1
FBI-BUDGET-B PK
BUDGET_B		Numeric 3This field represents the budget of an interbudget relationship where balances are transferred to.FB35.1
FBI-AR-ACCTUNIT-A
AR_ACCTUNIT_A		Alpha 15This field represents the Receivable posting accounting unit, amounts are transferred from.FB35.1
FBI-AR-ACCOUNT-A
AR_ACCOUNT_A		Numeric 6This field represents the Receivable account, amounts are transferred from.FB35.1
FBI-AR-SUB-ACCT-A
AR_SUB_ACCT_A		Numeric 4This field represents the Receivable subaccount, amounts are transferred from.FB35.1
FBI-AP-ACCTUNIT-A
AP_ACCTUNIT_A		Alpha 15This field represents the Payable accounting unit, amounts are transferred from.FB35.1
FBI-AP-ACCOUNT-A
AP_ACCOUNT_A		Numeric 6This field represents the Payable account, amounts are transferred from.FB35.1
FBI-AP-SUB-ACCT-A
AP_SUB_ACCT_A		Numeric 4This field represents the Payable subaccount, amounts are transferred from.FB35.1
FBI-AR-ACCTUNIT-B
AR_ACCTUNIT_B		Alpha 15This field represents the Receivable posting accounting unit, amounts are transferred to.FB35.1
FBI-AR-ACCOUNT-B
AR_ACCOUNT_B		Numeric 6This field represents the Receivable account, amounts are transferred to.FB35.1
FBI-AR-SUB-ACCT-B
AR_SUB_ACCT_B		Numeric 4This field represents the Receivable subaccount, amounts are transferred to.FB35.1
FBI-AP-ACCTUNIT-B
AP_ACCTUNIT_B		Alpha 15This field represents the Payable accounting unit, amounts are transferred to.FB35.1
FBI-AP-ACCOUNT-B
AP_ACCOUNT_B		Numeric 6This field represents the Payable account, amounts are transferred to.FB35.1
FBI-AP-SUB-ACCT-B
AP_SUB_ACCT_B		Numeric 4This field represents the Payable subaccount, amounts are transferred to.FB35.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
FBISET1COMPANY, BUDGET-A, BUDGET-BPrimaryCA110, CA195, FB10.1, FB100, FB101, FB11.1, FB120, FB121 +22 more (list truncated in source)

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
FbintbuauFBINTBUAUFBI-COMPANY → FIA-COMPANY, FBI-BUDGET-A → FIA-BUDGET-A, FBI-BUDGET-B → FIA-BUDGET-B, → FIA-ACTION, → FIA-DATE, → FIA-TIME, → FIA-UNIQUE-I-D

Programs

Updated by (2)

Referenced by (38)