FBBATRANS – No description in the Lawson data dictionary
- System
- General Ledger (GL)
- Prefix
FBT- Primary key
COMPANY,FISCAL-YEAR,BUDGET-NBR,ACCT-UNIT,ACCOUNT,SUB-ACCOUNT,UNIQUE-I-D- Fields
- 12
- Updated by
- 14 programs
- Referenced by
- 57 programs
FBBATRANS is a Lawson General Ledger table (prefix FBT); no description in the lawson data dictionary. It is indexed by COMPANY, FISCAL-YEAR, BUDGET-NBR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, UNIQUE-I-D (FBTSET1); alternate indexes: FBTSET2, FBTSET3, FBTSET4 and FBTUID. It is updated by GL110, GL146, GL197, GL199, GL300, GL40.1, GL40.2, GL40.3 and 6 more and referenced by FB11.1, FB111, FB160, FB211, FB296, FB325, FB60.1, FB95.1 and 49 more. The table has 12 fields, 5 indexes and 0 documented relations.
About FBBATRANS
No description in the Lawson data dictionary.
Fields (12)
Column = COBOL field name without the FBT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#FBT-UNIQUE-I-D PKUNIQUE_I_D | Bad Type 36 | — | — |
#FBT-COMPANY PKCOMPANY | Numeric 4 | — | GL199, IFGT.1 |
#FBT-FISCAL-YEAR PKFISCAL_YEAR | Numeric 4 | — | GL199, GL500, IFGT.1 |
#FBT-PERIODPERIOD | Numeric 2 | — | GL199, GL500, IFGT.1 |
#FBT-BUDGET-NBR PKBUDGET_NBR | Numeric 3 | — | GL199, IFGT.1 |
#FBT-ACCT-UNIT PKACCT_UNIT | Alpha 15 | — | GL199, IFGT.1 |
#FBT-ACCOUNT PKACCOUNT | Numeric 6 | — | GL199, IFGT.1 |
#FBT-SUB-ACCOUNT PKSUB_ACCOUNT | Numeric 4 | — | GL199, IFGT.1 |
#FBT-ACTUAL-AMTACTUAL_AMT | Signed 18.2 | — | GL199, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8, GL45.1, IFGT.1 |
#FBT-FUTURE-AMTFUTURE_AMT | Signed 18.2 | — | GL40.1, GL40.2, GL40.3, GL40.7, GL40.8, GL45.1, IFGT.1 |
#FBT-GLT-OBJ-ID SET4GLT_OBJ_ID | Numeric 12 | — | GL199, IFGT.1 |
#FBT-UNRELEASED-GLTUNRELEASED_GLT | Alpha 1 | — | GL146, GL197, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8, GL44.1 +1 more |
Indexes (5)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
FBTSET1 |
| Primary, KeyChange, Subset | Where UNRELEASED-GLT = Spaces | FB325 |
FBTSET2 |
| KeyChange | GL110, GL300 | |
FBTSET3 |
| KeyChange, Subset | Where UNRELEASED-GLT = Spaces | FB11.1, FB111, FB160, FB211, FB296, FB60.1, FB95.1, FB95.2 +22 more (list truncated in source) |
FBTSET4 |
| KeyChange, Subset | Where UNRELEASED-GLT = Spaces | GL110, GL146, GL197, GL40.1, GL40.2, GL40.3, GL40.7, GL40.8 +4 more |
FBTUID |
| — |
Programs
Updated by (14)
- GL110 Company Copy Delete
- GL146 Batch Journal Control
- GL197 Period, Year End GL Commitments Processing
- GL199 Period Closing
- GL300 General Ledger History Delete
- 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
- IFGT.1 GLTRANS Interface
Referenced by (57)
- FB11.1 Budget Edit Group
- FB111 Budget Edit Group Build
- FB160 Budget Edit Group Interface
- FB211 Budget Edit Group Listing
- FB296 Budget Audit
- FB325 Budget Actuals Rebuild
- FB60.1 Budget Edit Group Interface Maintenance
- FB95.1 Budget Analysis
- FB95.2 Account, Period
- FB95.3 Account, Year to Date
- FB95.4 Accounting Unit, Period
- FB95.5 Accounting Unit, Year to Date
- FB95.6 Totals
- GL298 GL Commitment Analysis Report
- GL299 GL and AC History commitment
- GL90.6 Compare Transaction Analysis
- GL94.1 Commitment Analysis
- GL94.2 Account
- GL94.3 Account Totals
- GL94.4 Accounting Unit
- GL94.5 Accounting Unit Totals
- GL94.6 Commitment Account Detail
- GL94.7 Commitment Accounting Unit Detail
- GL95.1 Account Analysis
- GL95.2 Fiscal Year Summary
- GL95.3 Totals
- GL95.4 Chart Query
- GL95.5 Periods versus Year to Date
- GL95.6 Year to Date Current Year versus Last Year
- GL95.7 Periods Current Year versus Last Year
- GL95.8 Year to Date Actual versus Budget
- GL95.9 Periods Actual versus Budget
- GL96.1 Accounting Units
- GL96.2 Year to Date Current Year versus Last Year
- GL96.3 Periods Current Year versus Last Year
- GL96.4 Year to Date Actual versus Budget
- GL96.5 Periods Actual versus Budget
- GL97.1 Accounts
- GL97.2 Year to Date Current Year versus Last Year
- GL97.3 Periods Current Year versus Last Year
- GL97.4 Year to Date Actual versus Budget
- GL97.5 Periods Actual versus Budget
- GL97.6 Year to Date Account Currencies
- GL97.7 Periods Account Currencies
- GL97.8 Fiscal Year Summary
- GL97.9 Totals
- GL98.1 Companies
- GL98.2 Year to Date Current Year versus Last Year
- GL98.3 Periods Current Year versus Last Year
- GL98.4 Year to Date Actual versus Budget
- GL98.5 Periods Actual versus Budget
- GL99.1 Organization Query
- GL99.2 Periods versus Year to Date
- GL99.3 Year to Date Current Year versus Last Year
- GL99.4 Periods Current Year versus Last Year
- GL99.5 Year to Date Actual versus Budget
- GL99.6 Periods Actual versus Budget