Lawson Insight Technical Documentation |
|
FBDETAIL
FBDETAIL FILE
Budget Detail
The Budgeting detail file contains the budget information for each budget
number, fiscal year and account. Thirteen amount fields are maintained on each
detail record.
REFERENCED BY
FB141 FB195 FB220 FB295 FB296 FB95.2
FB95.3 FB95.4 FB95.5 FB95.6 FB95.1 GL295
GLOP.1 FB11.1 FB111 FB211 GL298 GL94.1
GL94.2 GL94.3 GL94.4 GL94.5 GL94.6 GL94.7
GL95.1 GL95.2 GL95.3 GL95.4 GL95.5 GL95.6
GL95.7 GL95.8 GL95.9 GL96.1 GL96.2 GL96.3
GL96.4 GL96.5 GL97.1 GL97.2 GL97.3 GL97.4
GL97.5 GL97.6 GL97.7 GL97.8 GL97.9 GL98.1
GL98.2 GL98.3 GL98.4 GL98.5 GL99.1 GL99.2
GL99.3 GL99.4 GL99.5 GL99.6 GLSV.1 RW80.1
GLRV.1 AC191 AC40.4 AC41.4 AC42.1 AP125
AP126 AP20.1 AP20.2 AP20.3 AP20.4 AP20.5
AP20.7 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
API1.1 API2.1 BR41.4 CB10.1 CB191 CB20.1
CB30.1 CB500 EE135 EE35.1 EE35.2 EE520
GL122 GL146 GL165 GL170 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL65.1
GL75.1 IC222 GL20.2 IFAC.1 MA41.2 MA41.7
MA43.2 MA61.1 MAI1.1 PO150 PO25.1 PO25.6
PO25.7 PO536 POIM.1 FB230 FB231 RW298
GL320
UPDATED BY
CA110 CA195 FB100 FB101 FB120 FB121
FB122 FB145 FB165 FB190 FB20.1 FB20.2
FB20.3 FB20.4 FB20.6 FB20.7 FB21.1 FB30.1
FB31.1 FB40.1 FB40.2 FB40.3 FB45.1 GL110
GL120 GL197 GL300 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBD-COMPANY Numeric 4 CA110 CA195
Element: Company The company number you are defining FB120 FB121
budgets for. FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL110
GL197 GL500
GLSV.1 RW298
RW80.1
FBD-FISCAL-YEAR Numeric 4 CA110 CA195
Element: Fiscal Year This is the fiscal year you are FB120 FB121
defining budgets in. FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL197
GL500 GLSV.1
RW298
FBD-BUDGET-NBR Numeric 3 CA110 CA195
Element: Budget The number that identifies the budget. FB100 FB101
FB120 FB121
FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL197
GL500 GLSV.1
RW298
FBD-ACCT-UNIT Alpha 15 CA110 CA195
Element: Accounting UniThe accounting unit you are defining FB120 FB121
budget values for. FB145 FB165
FB190 FB20.1
This field, along with the account and FB20.3 FB20.4
subaccount, make up the location FB20.6 FB20.7
(account) where amounts and other FB21.1 FB30.1
account information is stored. FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL197
GL500 GLSV.1
RW298
FBD-ACCOUNT Numeric 6 CA110 CA195
Element: Account The account number you are defining FB120 FB121
budget values for. FB145 FB165
FB190 FB20.1
This field, along with the accounting FB20.3 FB20.4
unit and subaccount, make up the FB20.6 FB20.7
location (account) where amounts and FB21.1 FB30.1
other account information are stored. FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL197
GL500 GLSV.1
RW298 RW80.1
FBD-SUB-ACCOUNT Numeric 4 CA110 CA195
Element: Subaccount The subaccount number you are defining FB120 FB121
budget values for. FB145 FB165
FB190 FB20.1
This field along with the accounting FB20.3 FB20.4
unit and account make up the location FB20.6 FB20.7
(account) where amounts and other FB21.1 FB30.1
account information is stored. FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL197
GL500 GLSV.1
RW298 RW80.1
FBD-VAR-LEVELS Alpha 30 CA110 CA195
Element: Variable LevelA variable level represents the FB120 FB121
location of an accounting unit in an FB145 FB165
organization's level structure. FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 FB40.1
FB40.2 FB40.3
FB45.1 GL120
GL197 GL500
GLSV.1
FBD-DB-AMOUNT Currency 15.2 Occurs 13 Times CA195 FB100
Element: Debit Amount This is the budget debit amount. FB101 FB120
FB121 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL500
GLSV.1
FBD-CR-AMOUNT Currency 15.2 Occurs 13 Times CA195 FB100
Element: Credit Amount This is the budget credit amount. FB101 FB120
FB121 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL500
GLSV.1
FBD-DB-UNITS Signed 15.2 Occurs 13 Times CA195 FB100
Element: Auto Debits FB101 FB120
FB121 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL500
GLSV.1
FBD-CR-UNITS Signed 15.2 Occurs 13 Times CA195 FB100
Element: Auto Credits FB101 FB120
FB121 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL500
GLSV.1
FBD-COMPUTE-NAME Alpha 12 CA195 FB100
Element: Compute FB120 FB121
FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB30.1
FB31.1 GL500
GLSV.1
FBD-MAINT-DATE Numeric 8 (yyyymmdd) CA195 FB100
Element: Maintenance DaThe last date the budget was FB120 FB121
maintained. FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL197
GL500 GLSV.1
FBD-MAINT-TIME Numeric 6 (hhmmss) CA195 FB100
Element: Maintenance TiThe last time the budget was FB120 FB121
maintained. FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL197
GL500 GLSV.1
FBD-CHART-NAME Alpha 12 CA110 CA195
Element: Chart Name This is the name you assigned to the FB120 FB145
chart of accounts when you defined your FB165 FB190
company structure in the General Ledger FB20.1 FB20.3
system. FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL500
GLSV.1
FBD-SPREAD-CODE Alpha 3 CA195 FB120
Element: Spread Code A spread code is a budget spending FB121 FB165
activity formula set up in FB10.1 FB20.1 FB20.3
(Spread Codes) for each budget period. FB20.4 FB20.6
FB20.7 FB21.1
GL500 GLSV.1
FBD-DB-BEG-BAL Currency 15.2 CA195 FB101
Debit Beginning This is the debit beginning balance. FB120 FB121
Balance FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL197
GL500 GLSV.1
FBD-CR-BEG-BAL Currency 15.2 CA195 FB101
Credit Beginning This is the credit beginning balance. FB120 FB121
Balance FB145 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL197
GL500 GLSV.1
FBD-DB-BEG-BAL-UNT Signed 15.2 FB101 FB120
Element: Auto Debits FB121 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL500
GLSV.1
FBD-CR-BEG-BAL-UNT Signed 15.2 FB101 FB120
Element: Auto Debits FB121 FB145
FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL500
GLSV.1
FBD-BEG-BAL-FACTOR Alpha 15 CA195 FB120
Element: Factor FB121 FB165
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FBD-BEG-BAL-RATE Signed 12.6 CA195 FB101
Element: Account Rate FB120 FB121
FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1
FBD-FACTOR Alpha 15 Occurs 13 Times CA195 FB100
Element: Factor The global factor defined in FB00.1 FB120 FB121
(Global Factors). FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 GL500
FBD-FACTOR-RATE Signed 12.6 Occurs 13 Times CA195 FB101
Element: Account Rate The rate that affects the factor. For FB120 FB121
example, you could type the inflation FB165 FB20.1
rate. FB20.3 FB20.4
FB20.6 FB20.7
If you select units and amounts, the FB21.1 GL500
rate is calculated.
FBD-CYBBUD Derived
Current Year This is the current year beginning
Beginning Budget budget.
FBD-CPBUD-DR Derived
Current Period This is the current period debit
Debit Amount amount.
FBD-CPBUD-CR Derived
Current Period This is the current period credit
Credit Amount amount.
FBD-CPBUD Derived
Current Net Debit This is the current period net debit
and Credit and credit amount.
FBD-CUR-PD-SUM-B-D Derived
Current YTD Debit This is the current year-to-date debit
Amount amount.
FBD-CUR-PD-SUM-B-C Derived
Current YTD Credit This is the current year-to-date credit
Amount amount.
FBD-CYDBUD Derived
Element: Current YTD BuThis is the current year-to-date
budget.
FBD-CYPBUD1-DR Derived
Period 1 Debit This is the period 1 debit budget.
Budget
FBD-CYPBUD1-CR Derived
Period 1 Credit This is the period 1 credit budget.
Budget
FBD-CYPBUD1 Derived
Element: Period 1 BudgeThis is the period 1 budget.
FBD-CYPBUD2-DR Derived
Period 2 Debit This is the period 2 debit budget.
Budget
FBD-CYPBUD2-CR Derived
Period 2 Credit This is the period 2 credit budget.
Budget
FBD-CYPBUD2 Derived
Element: Period 2 BudgeThis is the period 2 budget.
FBD-CYPBUD3-DR Derived
Period 3 Debit This is the period 3 debit budget.
Budget
FBD-CYPBUD3-CR Derived
Period 3 Credit This is the period 3 credit budget.
Budget
FBD-CYPBUD3 Derived
Element: Period 3 BudgeThis is the period 3 budget.
FBD-CYPBUD4-DR Derived
Period 4 Debit This is the period 4 debit budget.
Budget
FBD-CYPBUD4-CR Derived
Period 4 Credit This is the period 4 credit budget.
Budget
FBD-CYPBUD4 Derived
Element: Period 4 BudgeThis is the period 4 budget.
FBD-CYPBUD5-DR Derived
Period 5 Debit This is the period 5 debit budget.
Budget
FBD-CYPBUD5-CR Derived
Period 5 Credit This is the period 5 credit budget.
Budget
FBD-CYPBUD5 Derived
Element: Period 5 BudgeThis is the period 5 budget.
FBD-CYPBUD6-DR Derived
Period 6 Debit This is the period 6 debit budget.
Budget
FBD-CYPBUD6-CR Derived
Period 6 Credit This is the period 6 credit budget.
Budget
FBD-CYPBUD6 Derived
Element: Period 6 BudgeThis is the period 6 budget.
FBD-CYPBUD7-DR Derived
Period 7 Debit This is the period 7 debit budget.
Budget
FBD-CYPBUD7-CR Derived
Period 7 Credit This is the period 7 credit budget.
Budget
FBD-CYPBUD7 Derived
Element: Period 7 BudgeThis is the period 7 budget.
FBD-CYPBUD8-DR Derived
Period 8 Debit This is the period 8 debit budget.
Budget
FBD-CYPBUD8-CR Derived
Period 8 Credit This is the period 8 credit budget.
Budget
FBD-CYPBUD8 Derived
Element: Period 8 BudgeThis is the period 8 budget.
FBD-CYPBUD9-DR Derived
Period 9 Debit This is the period 9 debit budget.
Budget
FBD-CYPBUD9-CR Derived
Period 9 Credit This is the period 9 credit budget.
Budget
FBD-CYPBUD9 Derived
Element: Period 9 BudgeThis is the period 9 budget.
FBD-CYPBUD10-DR Derived
Period 10 Debit This is the period 10 debit budget.
Budget
FBD-CYPBUD10-CR Derived
Period 10 Credit This is the period 10 credit budget.
Budget
FBD-CYPBUD10 Derived
Element: Period 10 BudgThis is the period 10 budget.
FBD-CYPBUD11-DR Derived
Period 11 Debit This is the period 11 debit budget.
Budget
FBD-CYPBUD11-CR Derived
Period 11 Credit This is the period 11 credit budget.
Budget
FBD-CYPBUD11 Derived
Element: Period 11 BudgThis is the period 11 budget.
FBD-CYPBUD12-DR Derived
Period 12 Debit This is the period 12 debit budget.
Budget
FBD-CYPBUD12-CR Derived
Period 12 Credit This is the period 12 credit budget.
Budget
FBD-CYPBUD12 Derived
Element: Period 12 BudgThis is the period 12 budget.
FBD-CYPBUD13-DR Derived
Period 13 Debit This is the period 13 debit budget.
Budget
FBD-CYPBUD13-CR Derived
Period 13 Credit This is the period 13 credit budget.
Budget
FBD-CYPBUD13 Derived
Element: Period 13 BudgThis is the period 13 budget.
FBD-BLANK Derived
Element: Blank This derived field is always blank. It
is used in drill around to allow column
headings.
FBD-UNT-BEG-BAL Derived
Element: Unt Beg Bal This is the unit beginning balance.
FBD-UNTBUD1-DR Derived
Element: Untbud1 Dr This is the period 1 debit budget unit.
FBD-UNTBUD1-CR Derived
Element: Untbud1 Cr This is the period 1 credit budget
unit.
FBD-UNTBUD1 Derived
Element: Untbud1 This is the period 1 budget unit.
FBD-UNTBUD2-DR Derived
Element: Untbud2 Dr This is the period 2 debit budget unit.
FBD-UNTBUD2-CR Derived
Element: Untbud2 Cr This is the period 2 credit budget
unit.
FBD-UNTBUD2 Derived
Element: Untbud2 This is the period 2 budget unit.
FBD-UNTBUD3-DR Derived
Element: Untbud3 Dr This is the period 3 debit budget unit.
FBD-UNTBUD3-CR Derived
Element: Untbud3 Cr This is the period 3 credit budget unit
FBD-UNTBUD3 Derived
Element: Untbud3 This is the period 3 budget unit.
FBD-UNTBUD4-DR Derived
Element: Untbud4 Dr This is the period 4 debit budget unit.
FBD-UNTBUD4-CR Derived
Element: Untbud4 Cr This is the period 4 credit budget
unit.
FBD-UNTBUD4 Derived
Element: Untbud4 This is the period 4 budget unit.
FBD-UNTBUD5-DR Derived
Element: Untbud5 Dr This is the period 5 debit budget unit.
FBD-UNTBUD5-CR Derived
Element: Untbud5 Cr This is the period 5 credit budget
unit.
FBD-UNTBUD5 Derived
Element: Untbud5 This is the period 5 budget unit.
FBD-UNTBUD6-DR Derived
Element: Untbud6 Dr This is the period 6 debit budget unit.
FBD-UNTBUD6-CR Derived
Element: Untbud6 Cr This is the period 6 credit budget
unit.
FBD-UNTBUD6 Derived
Element: Untbud6 This is the period 6 budget unit.
FBD-UNTBUD7-DR Derived
Element: Untbud7 Dr This is the period 7 debit budget unit.
FBD-UNTBUD7-CR Derived
Element: Untbud7 Cr This is the period 7 credit budget
unit.
FBD-UNTBUD7 Derived
Element: Untbud7 This is the period 7 budget unit.
FBD-UNTBUD8-DR Derived
Element: Untbud8 Dr This is the period 8 debit budget unit.
FBD-UNTBUD8-CR Derived
Element: Untbud8 Cr This is the period 8 credit budget
unit.
FBD-UNTBUD8 Derived
Element: Untbud8 This is the period 8 budget unit.
FBD-UNTBUD9-DR Derived
Element: Untbud9 Dr This is the period 9 debit budget unit.
FBD-UNTBUD9-CR Derived
Element: Untbud9 Cr This is the period 9 credit budget
unit.
FBD-UNTBUD9 Derived
Element: Untbud9 This is the period 9 budget unit.
FBD-UNTBUD10-DR Derived
Element: Untbud10 Dr This is the period 10 debut budget
unit.
FBD-UNTBUD10-CR Derived
Element: Untbud10 Cr This is the period 10 credit budget
unit.
FBD-UNTBUD10 Derived
Element: Untbud10 This is the period 10 budget unit.
FBD-UNTBUD11-DR Derived
Element: Untbud11 Dr This is the period 11 debit budget
unit.
FBD-UNTBUD11-CR Derived
Element: Untbud11 Cr This is the period 11 credit budget
unit.
FBD-UNTBUD11 Derived
Element: Untbud11 This is the period 11 budget unit.
FBD-UNTBUD12-DR Derived
Element: Untbud12 Dr This is the period 12 debit budget
unit.
FBD-UNTBUD12-CR Derived
Element: Untbud12 Cr This is the period 12 credit budget
unit.
FBD-UNTBUD12 Derived
Element: Untbud12 This is the period 12 budget unit.
FBD-UNTBUD13-DR Derived
Element: Untbud13 Dr This is the period 13 debit budget
unit.
FBD-UNTBUD13-CR Derived
Element: Untbud13 Cr This is the period 13 credit budget
unit.
FBD-UNTBUD13 Derived
Element: Untbud13 This is the period 13 budget unit.
FBDETAIL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBDSET1 COMPANY CA110 FB100
FISCAL-YEAR FB101 FB120
BUDGET-NBR FB121 FB122
ACCT-UNIT FB141 FB145
ACCOUNT FB165 FB190
SUB-ACCOUNT FB195 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB220 FB295
FB296 FB30.1
FB40.1 FB40.2
FB40.3 FB45.1
FB95.2 FB95.3
FB95.4 FB95.5
...
FBDSET2 FISCAL-YEAR KeyChange CA195 FB100
BUDGET-NBR FB101 FB11.1
COMPANY FB111 FB120
VAR-LEVELS FB121 FB195
ACCOUNT FB211 FB296
SUB-ACCOUNT FB95.1 FB95.2
ACCT-UNIT FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
...
FBDSET3 COMPANY AC191 AC40.4
ACCT-UNIT AC41.4 AC42.1
ACCOUNT AP125 AP126
SUB-ACCOUNT AP20.1 AP20.2
BUDGET-NBR AP20.3 AP20.4
FISCAL-YEAR AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 API1.1
API2.1 BR41.4
CB10.1 CB191
CB20.1 CB30.1
CB500 EE135
EE35.1 EE35.2
EE520 CA110
...
FBDSET4 COMPANY Subset FB100 FB230
FISCAL-YEAR Where COMPUTE-NAME != Spaces FB231 RW298
BUDGET-NBR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FBDSET5 FISCAL-YEAR KeyChange FB100 FB101
BUDGET-NBR FB231 FB295
COMPANY GL320 GLSV.1
ACCOUNT GLRV.1
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
FBDSET6 FISCAL-YEAR KeyChange GLSV.1 GLRV.1
BUDGET-NBR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
FBDSET7 FISCAL-YEAR KeyChange GLSV.1 GLRV.1
BUDGET-NBR
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
ACCT-UNIT
FBDSET8 COMPANY FB31.1 FB95.2
FISCAL-YEAR FB95.3
BUDGET-NBR
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
FBDETAIL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
FBD-COMPANY -> GLM-COMPANY
FBD-ACCT-UNIT -> GLM-ACCT-UNIT
FBD-ACCOUNT -> GLM-ACCOUNT
FBD-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
Acct Unit GLNAMES Required
FBD-COMPANY -> GLN-COMPANY
FBD-ACCT-UNIT -> GLN-ACCT-UNIT
Budget FBHEADER Required
FBD-COMPANY -> FBH-COMPANY
FBD-FISCAL-YEAR -> FBH-FISCAL-YEAR
FBD-BUDGET-NBR -> FBH-BUDGET-NBR
Chart Detail GLCHARTDTL Required
FBD-CHART-NAME -> GDT-CHART-NAME
FBD-ACCOUNT -> GDT-ACCOUNT
FBD-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Company GLSYSTEM Required
FBD-COMPANY -> GLS-COMPANY
Compute CMPUTE Not Required
FBD-COMPUTE-NAME -> CMP-COMPUTE-NAME
Fbspread FBSPREAD Not Required
FBD-COMPANY -> FBS-COMPANY
FBD-FISCAL-YEAR -> FBS-FISCAL-YEAR
FBD-SPREAD-CODE -> FBS-SPREAD-CODE
|