FBCONTROL FILE
REFERENCED BY
FB11.1 FB111 FB211 FB240 FB296 FB95.1
FB95.2 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 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 GLCC.1
UPDATED BY
FB145 FB190 FB40.1 FB40.2 FB40.3 FB40.4
FB45.1 GL110 GL197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FLC-COMPANY Numeric 4 FB40.2 FB40.4
Element: Company The company number represents an FB45.1 GL110
established company and is maintained on GL197
GL10.
FLC-FISCAL-YEAR Numeric 4 FB40.2 FB40.4
Element: Last Closed YeThis is the fiscal year for the record. FB45.1 GL197
FLC-BUDGET-NBR Numeric 3 FB40.2 FB40.4
Element: Budget Number The number that identifies the budget. FB45.1 GL197
FLC-CONTROL-GROUP Numeric 8 FB40.2 FB40.4
Element: Control GroupsThis field contains the journal entry FB45.1 GL197
number used for process control of the
journal entry detail.
FLC-JE-SEQUENCE Numeric 2 GL197
Journal Entry The unique journal entry sequence
Sequence Number number.
FLC-STATUS Numeric 1 FB145 FB190
Element: Status This field contains the processing cycle FB40.1 FB40.2
status of the assigned journal entry. FB40.3 FB40.4
0 = Unreleased FB45.1 GL197
1 = Released
2 = Post In Progress
5 = Posted
9 = History
FLC-VERSION Numeric 2 FB145 FB190
Element: Budget VersionThis field displays the budget version FB40.1 FB40.2
number. FB40.3 FB45.1
GL197
FLC-BASE-ND Numeric 1 FB40.2 FB40.4
Account Currency The number of decimal positions defined FB45.1 GL197
Code for the company base currency.
FLC-BASE-DEBITS Signed 15.2 FB145 FB190
Element: Auto Debits The total base debit amounts for the FB40.1 FB40.2
journal entry. FB40.3 FB40.4
FB45.1 GL197
FLC-BASE-CREDITS Signed 15.2 FB145 FB190
Element: Auto Credits The total base credit amounts for the FB40.1 FB40.2
journal entry. FB40.3 FB40.4
FB45.1 GL197
FLC-UNIT-ENTRY-DB Signed 15.2 FB145 FB190
Element: Auto Debits The total debit units for the journal FB40.1 FB40.2
entry. FB40.3 FB40.4
FB45.1 GL197
FLC-UNIT-ENTRY-CR Signed 15.2 FB145 FB190
Element: Auto Credits The total credit units for the journal FB40.1 FB40.2
entry. FB40.3 FB40.4
FB45.1 GL197
FLC-CNTRL-AMOUNT Signed 15.2 FB45.1
Element: Adj Amt The control total for the journal entry.
FLC-DESCRIPTION Alpha 30 (Lower Case) FB40.2 FB40.4
Element: Description This field contains the description for FB45.1 GL197
the journal entry.
FLC-LINE-NBR Numeric 6 FB145 FB190
Element: Line Number This field contains the line number. FB40.1 FB40.2
FB40.3 FB45.1
GL197
FLC-NBR-LINES Numeric 6 FB145 FB190
Element: Line Number This is the number of detail lines. FB40.1 FB40.2
FB40.3 FB45.1
GL197
FLC-DATE Numeric 8 (yyyymmdd) FB40.2 FB40.4
Element: Date This field contains the system date when FB45.1 GL197
the journal entry was created.
FLC-OPERATOR Alpha 10 FB40.2 FB40.4
Element: Operator Code This field is used to store the login FB45.1 GL197
id of the person who entered the record.
FLC-REL-OPERATOR Alpha 10 FB145 FB190
Element: Operator Code This field is used to store the login ID FB40.1 FB40.2
of the person who released the journal FB40.3 FB45.1
entry. GL197
FLC-TRAN-DESC-DFLT Alpha 1 FB40.2 FB45.1
Element: Tran Desc DfltThis field indicates if the journal GL197
entry header or the prior transaction
line is used for the description.
FBCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FLCSET1 COMPANY FB11.1 FB111
FISCAL-YEAR FB145 FB190
BUDGET-NBR FB211 FB240
CONTROL-GROUP FB296 FB40.1
FB40.2 FB40.3
FB40.4 FB40.5
FB45.1 FB95.1
FB95.2 FB95.3
FB95.4 FB95.5
FB95.6 GL110
GL197 GL298
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
...
FLCSET2 COMPANY KeyChange FB145 FB190
STATUS FB240 FB45.1
FISCAL-YEAR GL110
BUDGET-NBR
CONTROL-GROUP
FLCSET3 COMPANY KeyChange
FISCAL-YEAR
BUDGET-NBR
VERSION
CONTROL-GROUP
FBCONTROL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
FLC-COMPANY -> GLS-COMPANY (GLSSET1)
FBCONTROL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Fbtrans FBTRANS Delete Cascades
FLC-COMPANY -> FLT-COMPANY
FLC-FISCAL-YEAR -> FLT-FISCAL-YEAR
FLC-BUDGET-NBR -> FLT-BUDGET-NBR
FLC-CONTROL-GROUP -> FLT-CONTROL-GROUP
FLT-LINE-NBR
|
