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
FB240 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: Last Closed YeThis 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 Number 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: Journal Entry The type of journal entry. Valid values FB40.1 FB40.2
are Normal, Intercompany and FB40.3 FB40.4
Interbudget. FB45.1 GL197
N GL500
I
B
FLC-CONTROL-GROUP Numeric 8 FB145 FB190
Element: Control GroupsThis 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
Journal Entry The unique journal entry sequence FB40.1 FB40.2
Sequence Number number. FB40.3 FB45.1
GL197 GL500
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 GL500
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 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
Base Number Of The number of decimal positions defined FB40.1 FB40.2
Decimals 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 Number This field contains the line number. FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL500
FLC-NBR-LINES Numeric 6 FB145 FB190
Element: Number of LineThis 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 Code 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 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 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: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
FBCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FLCSET1 COMPANY FB145 FB190
FISCAL-YEAR FB240 FB40.1
BUDGET-NBR FB40.2 FB40.3
JE-TYPE FB40.4 FB40.5
CONTROL-GROUP FB45.1 GL110
GL197 GL300
GL500 GLCC.1
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
|