 |
Lawson Insight Technical Documentation |
|
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 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 AP125 AP126 AP25.1 AP25.2 AP26.1
AP27.1 CB10.1 CB191 CB20.1 CB30.1 CB500
EE135 EE35.1 EE35.2 EE520 GL122 GL146
GL165 GL170 GL197 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GL65.1 GL75.1
IC222 GL20.2 IFAC.1 POIM.1 FB230 FB231
RW298 GL320
UPDATED BY
CA110 CA195 FB100 FB101 FB120 FB121
FB122 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
GL300 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FBD-COMPANY Numeric 4 CA110 CA195
Company The company number you are defining FB120 FB121
budgets for. 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 GL500
GLSV.1 RW298
RW80.1
FBD-FISCAL-YEAR Numeric 4 CA110 CA195
Fiscal Year This is the fiscal year you are FB120 FB121
defining budgets in. 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
GL500 GLSV.1
RW298
FBD-BUDGET-NBR Numeric 3 CA110 CA195
Budget The number that identifies the budget. FB100 FB101
FB120 FB121
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
GL500 GLSV.1
RW298
FBD-ACCT-UNIT Alpha 15 CA110 CA195
Accounting Unit The accounting unit you are defining FB120 FB121
budget values for. FB165 FB190
FB20.1 FB20.3
This field, along with the account and FB20.4 FB20.6
subaccount, make up the location FB20.7 FB21.1
(account) where amounts and other FB30.1 FB31.1
account information is stored. FB40.1 FB40.2
FB40.3 FB45.1
GL500 GLSV.1
RW298
FBD-ACCOUNT Numeric 6 CA110 CA195
Account The account number you are defining FB120 FB121
budget values for. FB165 FB190
FB20.1 FB20.3
This field, along with the accounting FB20.4 FB20.6
unit and subaccount, make up the FB20.7 FB21.1
location (account) where amounts and FB30.1 FB31.1
other account information are stored. FB40.1 FB40.2
FB40.3 FB45.1
GL500 GLSV.1
RW298 RW80.1
FBD-SUB-ACCOUNT Numeric 4 CA110 CA195
Subaccount The subaccount number you are defining FB120 FB121
budget values for. FB165 FB190
FB20.1 FB20.3
This field along with the accounting FB20.4 FB20.6
unit and account make up the location FB20.7 FB21.1
(account) where amounts and other FB30.1 FB31.1
account information is stored. FB40.1 FB40.2
FB40.3 FB45.1
GL500 GLSV.1
RW298 RW80.1
FBD-VAR-LEVELS Alpha 30 CA110 CA195
Variable Level A variable level represents the FB120 FB121
location of an accounting unit in an FB165 FB190
organization's level structure. 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 GL500
GLSV.1
FBD-DB-AMOUNT Currency 15.2 Occurs 13 Times CA195 FB100
Debit Amount This is the budget debit amount. FB101 FB120
FB121 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL500
GLSV.1
FBD-CR-AMOUNT Currency 15.2 Occurs 13 Times CA195 FB100
Credit Amount This is the budget credit amount. FB101 FB120
FB121 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL500
GLSV.1
FBD-DB-UNITS Signed 15.2 Occurs 13 Times CA195 FB100
Debit Units Select the unit for the activity you FB101 FB120
performed. For example, a unit would be FB121 FB165
the number of computers purchased. FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL500
GLSV.1
FBD-CR-UNITS Signed 15.2 Occurs 13 Times CA195 FB100
Credit Unit Select the unit for the activity you FB101 FB120
performed. For example, a unit would be FB121 FB165
the number of computers purchased. FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL500
GLSV.1
FBD-COMPUTE-NAME Alpha 12 CA195 FB100
Compute The name assigned to an arithmetic FB120 FB121
equation created in Compute Statement FB165 FB20.1
(RW50.1). A compute statement consists FB20.3 FB20.4
of data dictionary items and operation FB20.6 FB20.7
symbols. FB21.1 FB30.1
FB31.1 GL500
GLSV.1
FBD-MAINT-DATE Numeric 8 (yyyymmdd) CA195 FB100
Maintenance Date The last date the budget was FB120 FB121
maintained. FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL500 GLSV.1
FBD-MAINT-TIME Numeric 6 (hhmmss) CA195 FB100
Maintenance Time The last time the budget was FB120 FB121
maintained. FB165 FB190
FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL500 GLSV.1
FBD-CHART-NAME Alpha 12 CA110 CA195
Chart Name This is the name you assigned to the FB120 FB165
chart of accounts when you defined your FB190 FB20.1
company structure in the General Ledger FB20.3 FB20.4
system. FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL500
GLSV.1
FBD-SPREAD-CODE Alpha 3 CA195 FB120
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 FB100
Debit Beginning This is the debit beginning balance. FB101 FB120
Balance FB121 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL500
GLSV.1
FBD-CR-BEG-BAL Currency 15.2 CA195 FB100
Credit Beginning This is the credit beginning balance. FB101 FB120
Balance FB121 FB165
FB190 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL500
GLSV.1
FBD-DB-BEG-BAL-UNT Signed 15.2 FB100 FB101
Unit Debit You can enter the units beginning FB120 FB121
Beginning Balance balance. For example, a unit would be FB165 FB190
the number of computers purchased. FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL500 GLSV.1
FBD-CR-BEG-BAL-UNT Signed 15.2 FB100 FB101
Unit Credit You can enter the units beginning FB120 FB121
Beginning Balance balance in this field. For example, a FB165 FB190
unit would be the number of computers FB20.1 FB20.3
purchased. FB20.4 FB20.6
FB20.7 FB21.1
FB40.1 FB40.2
FB40.3 FB45.1
GL500 GLSV.1
FBD-BEG-BAL-FACTOR Alpha 15 CA195 FB100
Factor Beginning You can type or select the global FB120 FB121
Balance factor that is used to help calculate FB165 FB20.1
the budget amount. FB20.3 FB20.4
FB20.6 FB20.7
You define global factors in FB00.1 FB21.1
(Global Factors).
FBD-BEG-BAL-RATE Signed 12.6 CA195 FB101
Rate Beginning You can type or select the rate that FB120 FB121
Balance affects the factor. For example, you FB165 FB20.1
could type the inflation rate or an FB20.3 FB20.4
employees hourly contract salary. FB20.6 FB20.7
FB21.1
FBD-FACTOR Alpha 15 Occurs 13 Times CA195 FB100
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
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
Current YTD Budget This 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
Period 1 Budget This 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
Period 2 Budget This 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
Period 3 Budget This 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
Period 4 Budget This 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
Period 5 Budget This 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
Period 6 Budget This 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
Period 7 Budget This 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
Period 8 Budget This 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
Period 9 Budget This 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
Period 10 Budget This 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
Period 11 Budget This 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
Period 12 Budget This 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
Period 13 Budget This is the period 13 budget.
FBD-BLANK Derived
Blank This derived field is always blank. It
is used in drill around to allow column
headings.
FBD-UNT-BEG-BAL Derived
Unt Beg Bal This is the unit beginning balance.
FBD-UNTBUD1-DR Derived
Untbud1 Dr This is the period 1 debit budget unit.
FBD-UNTBUD1-CR Derived
Untbud1 Cr This is the period 1 credit budget
unit.
FBD-UNTBUD1 Derived
Untbud1 This is the period 1 budget unit.
FBD-UNTBUD2-DR Derived
Untbud2 Dr This is the period 2 debit budget unit.
FBD-UNTBUD2-CR Derived
Untbud2 Cr This is the period 2 credit budget
unit.
FBD-UNTBUD2 Derived
Untbud2 This is the period 2 budget unit.
FBD-UNTBUD3-DR Derived
Untbud3 Dr This is the period 3 debit budget unit.
FBD-UNTBUD3-CR Derived
Untbud3 Cr This is the period 3 credit budget unit
FBD-UNTBUD3 Derived
Untbud3 This is the period 3 budget unit.
FBD-UNTBUD4-DR Derived
Untbud4 Dr This is the period 4 debit budget unit.
FBD-UNTBUD4-CR Derived
Untbud4 Cr This is the period 4 credit budget
unit.
FBD-UNTBUD4 Derived
Untbud4 This is the period 4 budget unit.
FBD-UNTBUD5-DR Derived
Untbud5 Dr This is the period 5 debit budget unit.
FBD-UNTBUD5-CR Derived
Untbud5 Cr This is the period 5 credit budget
unit.
FBD-UNTBUD5 Derived
Untbud5 This is the period 5 budget unit.
FBD-UNTBUD6-DR Derived
Untbud6 Dr This is the period 6 debit budget unit.
FBD-UNTBUD6-CR Derived
Untbud6 Cr This is the period 6 credit budget
unit.
FBD-UNTBUD6 Derived
Untbud6 This is the period 6 budget unit.
FBD-UNTBUD7-DR Derived
Untbud7 Dr This is the period 7 debit budget unit.
FBD-UNTBUD7-CR Derived
Untbud7 Cr This is the period 7 credit budget
unit.
FBD-UNTBUD7 Derived
Untbud7 This is the period 7 budget unit.
FBD-UNTBUD8-DR Derived
Untbud8 Dr This is the period 8 debit budget unit.
FBD-UNTBUD8-CR Derived
Untbud8 Cr This is the period 8 credit budget
unit.
FBD-UNTBUD8 Derived
Untbud8 This is the period 8 budget unit.
FBD-UNTBUD9-DR Derived
Untbud9 Dr This is the period 9 debit budget unit.
FBD-UNTBUD9-CR Derived
Untbud9 Cr This is the period 9 credit budget
unit.
FBD-UNTBUD9 Derived
Untbud9 This is the period 9 budget unit.
FBD-UNTBUD10-DR Derived
Untbud10 Dr This is the period 10 debut budget
unit.
FBD-UNTBUD10-CR Derived
Untbud10 Cr This is the period 10 credit budget
unit.
FBD-UNTBUD10 Derived
Untbud10 This is the period 10 budget unit.
FBD-UNTBUD11-DR Derived
Untbud11 Dr This is the period 11 debit budget
unit.
FBD-UNTBUD11-CR Derived
Untbud11 Cr This is the period 11 credit budget
unit.
FBD-UNTBUD11 Derived
Untbud11 This is the period 11 budget unit.
FBD-UNTBUD12-DR Derived
Untbud12 Dr This is the period 12 debit budget
unit.
FBD-UNTBUD12-CR Derived
Untbud12 Cr This is the period 12 credit budget
unit.
FBD-UNTBUD12 Derived
Untbud12 This is the period 12 budget unit.
FBD-UNTBUD13-DR Derived
Untbud13 Dr This is the period 13 debit budget
unit.
FBD-UNTBUD13-CR Derived
Untbud13 Cr This is the period 13 credit budget
unit.
FBD-UNTBUD13 Derived
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 FB165
ACCOUNT FB190 FB195
SUB-ACCOUNT 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 FB95.6
...
FBDSET2 FISCAL-YEAR CA195 FB100
BUDGET-NBR FB101 FB11.1
COMPANY FB120 FB121
VAR-LEVELS FB195 FB211
ACCOUNT FB296 FB95.1
SUB-ACCOUNT FB95.2 FB95.3
ACCT-UNIT 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 GL95.7
...
FBDSET3 COMPANY AC191 AP125
ACCT-UNIT AP126 AP25.1
ACCOUNT AP25.2 AP26.1
SUB-ACCOUNT AP27.1 CB10.1
BUDGET-NBR CB191 CB20.1
FISCAL-YEAR CB30.1 CB500
EE135 EE35.1
EE35.2 EE520
CA110 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL110 GL120
GL122 GL146
GL165 GL170
GL197 GL40.1
...
FBDSET4 COMPANY Subset FB100 FB230
FISCAL-YEAR Where COMPUTE-NAME != Spaces FB231 RW298
BUDGET-NBR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FBDSET5 FISCAL-YEAR FB100 FB101
BUDGET-NBR FB231 FB295
COMPANY GL320 GLSV.1
ACCOUNT GLRV.1
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
FBDSET6 FISCAL-YEAR GLSV.1 GLRV.1
BUDGET-NBR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
FBDSET7 FISCAL-YEAR 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
|