FBCONTROL FILE
REFERENCED BY
FB240 GLCC.1
UPDATED BY
FB190 FB40.1 FB40.2 FB40.3 FB40.4 FB45.1
GL110
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FLC-COMPANY Numeric 4 FB40.2 FB40.4
Company The company number represents an FB45.1 GL110
established company and is entered on
all function codes.
FLC-FISCAL-YEAR Numeric 4 FB40.2 FB40.4
Fiscal Year This is the current fiscal year. This FB45.1
field is updated by Period Closing
(GL199).
FLC-BUDGET-NBR Numeric 3 FB40.2 FB40.4
Budget Number The Budget Number field contains the FB45.1
budget number.
FLC-CONTROL-GROUP Numeric 8 FB40.2 FB40.4
Control Groups This field displays the journal entry FB45.1
number used for process control of the
journal entry detail.
FLC-JE-SEQUENCE Numeric 2
Journal Entry
Sequence Number
FLC-STATUS Numeric 1 FB190 FB40.1
Status This field displays the status of the FB40.2 FB40.3
transaction. FB40.4 FB45.1
0 = Unreleased
1 = Released
9 = History
FLC-VERSION Numeric 2 FB190 FB40.1
Budget Version This field displays the budget version FB40.2 FB40.3
number. FB45.1
FLC-BASE-ND Numeric 1 FB40.2 FB40.4
Base Number Of The number of decimal positions defined FB45.1
Decimals for the company base currency.
FLC-BASE-DEBITS Signed 15.2 FB190 FB40.1
Base Debits The total positive detail amount in the FB40.2 FB40.3
company base currency. FB40.4 FB45.1
FLC-BASE-CREDITS Signed 15.2 FB190 FB40.1
Base Credits The total negative detail amount in the FB40.2 FB40.3
company base currency. FB40.4 FB45.1
FLC-UNIT-ENTRY-DB Signed 15.2 FB190 FB40.1
Unit Entry Db Displays the total debit units for the FB40.2 FB40.3
journal entry. FB40.4 FB45.1
FLC-UNIT-ENTRY-CR Signed 15.2 FB190 FB40.1
Unit Entry Cr Displays the total credit units for the FB40.2 FB40.3
journal entry. FB40.4 FB45.1
FLC-CNTRL-AMOUNT Signed 15.2 FB45.1
Control Amount
FLC-DESCRIPTION Alpha 30 (Lower Case) FB40.2 FB40.4
Description This field displays the description. FB45.1
FLC-LINE-NBR Numeric 6 FB190 FB40.1
Line Number This field contains the line number. FB40.2 FB40.3
FB45.1
FLC-NBR-LINES Numeric 6 FB190 FB40.1
Number of Lines This is the number of detail lines. FB40.2 FB40.3
FB45.1
FLC-DATE Numeric 8 (yyyymmdd) FB40.2 FB40.4
Date This field displays the system date FB45.1
when this was created.
FLC-OPERATOR Alpha 10 FB40.2 FB40.4
Operator Code This field is used to store the login FB45.1
id of the person who entered the record.
FLC-REL-OPERATOR Alpha 10 FB190 FB40.1
Release Operator FB40.2 FB40.3
FB45.1
FLC-TRAN-DESC-DFLT Alpha 1 FB40.2 FB45.1
Tran Desc Dflt
FBCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FLCSET1 COMPANY FB190 FB240
FISCAL-YEAR FB40.1 FB40.2
BUDGET-NBR FB40.3 FB40.4
CONTROL-GROUP FB40.5 FB45.1
GL110 GLCC.1
FLCSET2 COMPANY FB190 FB240
STATUS FB45.1 GL110
FISCAL-YEAR
BUDGET-NBR
CONTROL-GROUP
FLCSET3 COMPANY
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
|
