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
FB11.1 FB111 FB141 FB160 FB195 FB211
FB220 FB295 FB296 FB95.2 FB95.3 FB95.4
FB95.5 FB95.6 FB95.1 GL146 GL167 GL190
GL191 GL199 GL295 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GLOP.1 IFGT.1
FB60.1 GL298 GL90.6 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 AP25.1
AP25.2 AP26.1 AP27.1 AP30.2 BR41.4 BR44.1
CB10.1 CB15.1 CB15.2 CB191 CB20.1 CB30.1
CB500 EE135 EE35.1 EE35.2 EE520 GL122
GL165 GL170 GL65.1 GL70.1 GL70.2 GL70.3
GL70.5 GL70.6 GL75.1 IC222 GL20.2 IFAC.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 Signed 18.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 Signed 18.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 Select the unit for the activity you FB101 FB120
performed. For example, a unit would be FB121 FB145
the number of computers purchased. 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 Select the unit for the activity you FB101 FB120
performed. For example, a unit would be FB121 FB145
the number of computers purchased. 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 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
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 Signed 18.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 Signed 18.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 18.2 FB101 FB120
Element: Intl Amt You can enter the units beginning FB121 FB145
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
GL197 GL500
GLSV.1
FBD-CR-BEG-BAL-UNT Signed 18.2 FB101 FB120
Element: Intl Amt You can enter the units beginning FB121 FB145
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
GL197 GL500
GLSV.1
FBD-BEG-BAL-FACTOR Alpha 15 CA195 FB120
Element: Factor You can type or select the global FB121 FB165
factor that is used to help calculate FB20.1 FB20.3
the budget amount. FB20.4 FB20.6
FB20.7 FB21.1
You define global factors in FB00.1
(Global Factors).
FBD-BEG-BAL-RATE Signed 14.7 CA195 FB101
Element: Currency Rate You can type or select the rate that FB120 FB121
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
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 14.7 Occurs 13 Times CA195 FB101
Element: Currency 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-PARENT-VAR-LEV Alpha 30 CA110 CA195
Element: Parent Var LevThe variable level address of the parent FB120 FB121
accounting unit. 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 GL120
GL197 GL500
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-CYPYTD1 Derived
Element: Period 1 BudgeCurrent year period year to date
period 1.
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-CYPYTD2 Derived
Element: Period 2 BudgeCurrent year period year to date
period 2.
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-CYPYTD3 Derived
Element: Period 3 BudgeCurrent year period year to date
period 3.
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-CYPYTD4 Derived
Element: Period 4 BudgeCurrent year period year to date
period 4.
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-CYPYTD5 Derived
Element: Period 5 BudgeCurrent year period year to date
period 5.
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-CYPYTD6 Derived
Element: Period 6 BudgeCurrent year period year to date
period 6.
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-CYPYTD7 Derived
Element: Period 7 BudgeCurrent year period year to date
period 7.
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-CYPYTD8 Derived
Element: Period 8 BudgeCurrent year period year to date
period 8.
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-CYPYTD9 Derived
Element: Period 9 BudgeCurrent year period year to date
period 9.
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-CYPYTD10 Derived
Element: Period 10 BudgCurrent year period year to date
period 10.
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-CYPYTD11 Derived
Element: Period 11 BudgCurrent year period year to date
period 11.
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-CYPYTD12 Derived
Element: Period 12 BudgCurrent year period year to date
period 12.
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-CYPYTD13 Derived
Element: Period 13 BudgCurrent year period year to date
period 13.
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 Units current year period year to date
period 1.
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 Units current year period year to date
period 2.
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 Units current year period year to date
period 3.
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 Units current year period year to date
period 4.
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 Units current year period year to date
period 5.
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 Units current year period year to date
period 6.
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 Units current year period year to date
period 7.
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 Units current year period year to date
period 8.
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 Units current year period year to date
period 9.
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 Units current year period year to date
period 10.
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 Units current year period year to date
period 11.
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 Units current year period year to date
period 12.
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 Units current year period year to date
period 13.
FBDETAIL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FBDSET1 COMPANY CA110 CA195
FISCAL-YEAR FB100 FB101
BUDGET-NBR FB11.1 FB111
ACCT-UNIT FB120 FB121
ACCOUNT FB122 FB141
SUB-ACCOUNT FB145 FB160
FB165 FB190
FB195 FB20.1
FB20.2 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FB211 FB220
FB295 FB296
FB30.1 FB31.1
FB40.1 FB40.2
...
FBDSET2 FISCAL-YEAR KeyChange CA195 FB100
BUDGET-NBR FB101 FB11.1
COMPANY FB111 FB120
VAR-LEVELS FB121 FB160
ACCOUNT FB195 FB211
SUB-ACCOUNT FB296 FB60.1
ACCT-UNIT FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL298 GL90.6
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
GL95.2 GL95.3
...
FBDSET3 COMPANY AC191 AC40.4
ACCT-UNIT AC41.4 AC42.1
ACCOUNT AP125 AP126
SUB-ACCOUNT AP25.1 AP25.2
BUDGET-NBR AP26.1 AP27.1
FISCAL-YEAR AP30.2 BR41.4
BR44.1 CB10.1
CB15.1 CB15.2
CB191 CB20.1
CB30.1 CB500
EE135 EE35.1
EE35.2 EE520
CA110 FB145
FB190 FB40.1
FB40.2 FB40.3
...
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
FBDSET9 PARENT-VAR-LEV
FISCAL-YEAR
BUDGET-NBR
COMPANY
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 (GLMSET2)
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
FBDETAIL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bud Unt Parent GLCONSOL
FBD-PARENT-VAR-LEV -> GCN-VAR-LEVELS
"N" -> GCN-TRANS-TYPE
FBD-COMPANY -> GCN-COMPANY
FBD-ACCOUNT -> GCN-ACCOUNT
FBD-SUB-ACCOUNT -> GCN-SUB-ACCOUNT
FBD-FISCAL-YEAR -> GCN-FISCAL-YEAR
FBD-BUDGET-NBR -> GCN-BUDGET-NBR
GCN-LEVEL-DEPTH
GCN-CURRENCY-CODE
Budget Parent GLCONSOL
FBD-PARENT-VAR-LEV -> GCN-VAR-LEVELS
"B" -> GCN-TRANS-TYPE
FBD-COMPANY -> GCN-COMPANY
FBD-ACCOUNT -> GCN-ACCOUNT
FBD-SUB-ACCOUNT -> GCN-SUB-ACCOUNT
FBD-FISCAL-YEAR -> GCN-FISCAL-YEAR
FBD-BUDGET-NBR -> GCN-BUDGET-NBR
GCN-LEVEL-DEPTH
GCN-CURRENCY-CODE
Fbtrans FBTRANS
FBD-COMPANY -> FLT-TO-COMPANY
FBD-FISCAL-YEAR -> FLT-FISCAL-YEAR
FBD-BUDGET-NBR -> FLT-BUDGET-NBR
FBD-ACCT-UNIT -> FLT-ACCT-UNIT
FBD-ACCOUNT -> FLT-ACCOUNT
FBD-SUB-ACCOUNT -> FLT-SUB-ACCOUNT
FLT-OBJ-ID
Glcommitx GLCOMMITX
FBD-COMPANY -> GOX-COMPANY
FBD-ACCT-UNIT -> GOX-ACCT-UNIT
FBD-ACCOUNT -> GOX-ACCOUNT
FBD-SUB-ACCOUNT -> GOX-SUB-ACCOUNT
FBD-FISCAL-YEAR -> GOX-FISCAL-YEAR
GOX-PERIOD
GOX-SYSTEM
GOX-CURRENCY-CODE
GOX-GLT-OBJ-ID
Gltrans GLTRANS
FBD-COMPANY -> GLT-TO-COMPANY
FBD-ACCOUNT -> GLT-ACCOUNT
FBD-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
FBD-ACCT-UNIT -> GLT-ACCT-UNIT
FBD-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLT-ACCT-PERIOD
GLT-SYSTEM
GLT-CONTROL-GROUP
GLT-JE-TYPE
GLT-JE-SEQUENCE
GLT-LINE-NBR
GLT-COMPANY
|