Lawson Insight Technical Documentation |
|
FBCONTROL
FBCONTROL FILE
Budget Journal Control
This file contains Flex Budget journal ectry control information. This
information is used to process the Flex Budget journal entry detail records.
REFERENCED BY
FB11.1 FB111 FB160 FB20.2 FB211 FB240
FB296 FB60.1 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 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 GL300 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FLC-COMPANY Numeric 4 FB145 FB190
Element: Company The company number represents an FB40.1 FB40.2
established company and is maintained on FB40.3 FB40.4
GL10. FB45.1 GL110
GL197 GL500
FLC-FISCAL-YEAR Numeric 4 FB145 FB190
Element: Year This is the fiscal year for the record. FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL500
FLC-BUDGET-NBR Numeric 3 FB145 FB190
Element: Budget Nbr The number that identifies the budget. FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL500
FLC-JE-TYPE Alpha 1 FB145 FB190
Element: Je Type The type of journal entry. Valid values FB40.1 FB40.2
are Normal, Intercompany, and Multiple FB40.3 FB40.4
Budget. FB45.1 GL197
N GL500
I
B
FLC-CONTROL-GROUP Numeric 8 FB145 FB190
Element: Control Group This field contains the journal entry FB40.1 FB40.2
number used for process control of the FB40.3 FB40.4
journal entry detail. FB45.1 GL197
GL500
FLC-JE-SEQUENCE Numeric 2 FB145 FB190
Element: Je Sequence The unique journal entry sequence FB40.1 FB40.2
number. FB40.3 FB45.1
GL197 GL500
FLC-STATUS Numeric 1 FB145 FB190
Element: Status This field contains the processing FB40.1 FB40.2
cycle status of the assigned journal FB40.3 FB40.4
entry. FB45.1 GL197
0 = Unreleased GL500
1 = Released
2 = Post In Progress
5 = Posted
9 = History
FLC-VERSION Numeric 2 FB145 FB190
Element: Version This field displays the budget version FB40.1 FB40.2
number. FB40.3 FB45.1
GL197 GL500
FLC-CURRENCY-CODE Alpha 5 FB145 FB190
Element: Currency Code This is the transaction currency for the FB40.1 FB40.2
journal entry. FB40.3 FB45.1
GL197 GL500
FLC-BASE-ND Numeric 1 FB145 FB190
Element: Base Nd The number of decimal positions defined FB40.1 FB40.2
for the company base currency. FB40.3 FB40.4
FB45.1 GL197
GL500
FLC-BASE-DEBITS Signed 18.2 FB145 FB190
Element: Intl Amt The total base debit amounts for the FB40.1 FB40.2
journal entry. FB40.3 FB40.4
FB45.1 GL197
GL500
FLC-BASE-CREDITS Signed 18.2 FB145 FB190
Element: Intl Amt The total base credit amounts for the FB40.1 FB40.2
journal entry. FB40.3 FB40.4
FB45.1 GL197
GL500
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
GL500
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
GL500
FLC-CNTRL-AMOUNT Signed 18.2 FB45.1 GL500
Element: Intl Amt The control total for the journal entry.
FLC-DESCRIPTION Alpha 30 (Lower Case) FB145 FB190
Element: Description This field contains the description for FB40.1 FB40.2
the journal entry. FB40.3 FB40.4
FB45.1 GL197
GL500
FLC-LINE-NBR Numeric 6 FB145 FB190
Element: Line Nbr This field contains the line number. FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL500
FLC-NBR-LINES Numeric 6 FB145 FB190
Element: Nbr Lines This is the number of detail lines. FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL500
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. GL500
FLC-OPERATOR Alpha 10 FB145 FB190
Element: Operator This field is used to store the login FB40.1 FB40.2
id of the person who entered the record. FB40.3 FB40.4
FB45.1 GL197
GL500
FLC-REL-OPERATOR Alpha 10 FB145 FB190
Element: Operator 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 GL500
FLC-TRAN-DESC-DFLT Alpha 1 FB40.2 FB45.1
Element: Tran Desc DfltThis field indicates if the journal GL197 GL500
entry header or the prior transaction
line is used for the description.
FLC-BLANK Derived
Element: Blankam This field consists of blank spaces. It
is used to provide column headings on
Drill Arounds.
FBCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FLCSET1 COMPANY FB11.1 FB111
FISCAL-YEAR FB145 FB160
BUDGET-NBR FB190 FB20.2
JE-TYPE FB211 FB240
CONTROL-GROUP FB296 FB40.1
FB40.2 FB40.3
FB40.4 FB40.5
FB45.1 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL110 GL197
GL298 GL300
GL500 GL90.6
GL94.1 GL94.2
...
FLCSET2 COMPANY KeyChange FB145 FB190
STATUS FB240 FB45.1
FISCAL-YEAR GL110
BUDGET-NBR
JE-TYPE
CONTROL-GROUP
FBCONTROL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company GLSYSTEM Required
FLC-COMPANY -> GLS-COMPANY
Fbheader FBHEADER Required
FLC-COMPANY -> FBH-COMPANY
FLC-FISCAL-YEAR -> FBH-FISCAL-YEAR
FLC-BUDGET-NBR -> FBH-BUDGET-NBR
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-JE-TYPE -> FLT-JE-TYPE
FLC-CONTROL-GROUP -> FLT-CONTROL-GROUP
FLT-LINE-NBR
|