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
FB215 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
AP170 AP193 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.2 AP520 API1.1 API2.1
BR41.4 BR44.1 CB10.1 CB15.1 CB15.2 CB150
CB191 CB20.1 CB30.1 CB45.1 CB46.1 CB500
CB543 CB544 CB55.1 CB554 EE135 EE35.1
EE35.2 EE520 GL122 GL165 GL170 GL65.1
GL70.1 GL70.2 GL70.3 GL70.5 GL70.6 GL75.1
GL20.2 IFAC.1 MA41.1 MA41.2 MA41.4 MA41.7
MA43.2 MA61.1 MAI1.1 PO150 PO25.1 PO25.6
PO25.7 PO536 POIM.1 RQ10.1 RQ10.3 RQ11.1
RQ13.2 RQ35.1 RQ500 RQIB.1 RQIF.1 RQIJ.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 SNOP.1 SNRP.1
SNSP.1
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 SNRP.1
SNSP.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 SNRP.1
SNSP.1
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 SNRP.1
SNSP.1
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 SNRP.1
SNSP.1
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
SNRP.1 SNSP.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
SNRP.1 SNSP.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 SNRP.1
SNSP.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 SNOP.1
SNRP.1 SNSP.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 SNOP.1
SNRP.1 SNSP.1
FBD-DB-UNITS Signed 15.2 Occurs 13 Times CA195 FB100
Element: Auto Debits The total positive detail auto FB101 FB120
reversing amounts. 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 SNOP.1
SNRP.1 SNSP.1
FBD-CR-UNITS Signed 15.2 Occurs 13 Times CA195 FB100
Element: Auto Credits The total negative detail auto FB101 FB120
reversing amounts. 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 SNOP.1
SNRP.1 SNSP.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
SNOP.1 SNRP.1
SNSP.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
SNOP.1 SNRP.1
SNSP.1
FBD-CHART-NAME Alpha 12 CA110 CA195
Element: Chart Name This is the name you assigned to the FB120 FB121
chart of accounts when you defined your FB145 FB165
company structure in the General Ledger FB190 FB20.1
system. FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB40.1
FB40.2 FB40.3
FB45.1 GL197
GL500 GLSV.1
SNRP.1 SNSP.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 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 18.2 FB101 FB120
Element: Intl Amt 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 The element that affects the budget FB121 FB165
change. FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
FBD-BEG-BAL-RATE Signed 14.7 CA195 FB101
Element: Curr Rate The currency rate. FB120 FB121
FB165 FB20.1
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1
FBD-FACTOR Alpha 15 Occurs 13 Times FB100 FB120
Element: Factor The global factor defined in FB00.1 FB121 FB165
(Global Factors). FB20.1 FB20.3
FB20.4 FB20.6
FB20.7 FB21.1
GL500 SNOP.1
SNRP.1 SNSP.1
FBD-FACTOR-RATE Signed 14.7 Occurs 13 Times FB101 FB120
Element: Curr Rate The rate that affects the factor. For FB121 FB165
example, you could type the inflation FB20.1 FB20.3
rate. FB20.4 FB20.6
FB20.7 FB21.1
If you select units and amounts, the GL500 SNOP.1
rate is calculated. SNRP.1 SNSP.1
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
SNRP.1 SNSP.1
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: Cypbud1 Current 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: Cypbud2 Current 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: Cypbud3 Current 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: Cypbud4 Current 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: Cypbud5 Current 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: Cypbud6 Current 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: Cypbud7 Current 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: Cypbud8 Current 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: Cypbud9 Current 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: Cypbud10 Current 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: Cypbud11 Current 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: Cypbud12 Current 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: Cypbud13 Current 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 FB215
FB220 FB295
FB296 FB30.1
FB31.1 FB40.1
...
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 AP170 AP193
BUDGET-NBR AP20.1 AP20.2
FISCAL-YEAR AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP520
API1.1 API2.1
BR41.4 BR44.1
CB10.1 CB15.1
CB15.2 CB150
...
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
|