FBCONTROL

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
CA110 CA195 FB10.1 FB100 FB101 FB11.1
FB111 FB120 FB121 FB122 FB160 FB165
FB20.1 FB20.2 FB20.3 FB20.4 FB20.6 FB20.7
FB21.1 FB211 FB240 FB296 FB30.1 FB31.1
FB325 FB35.1 FB42.1 FB60.1 FB95.1 FB95.2
FB95.3 FB95.4 FB95.5 FB95.6 GL120 GL298
GL299 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 SNOP.1 SNRP.1 SNSP.1


UPDATED BY
FB145 FB190 FB40.1 FB40.2 FB40.3 FB40.4
FB45.1 GL110 GL197 GL199 GL300 GL500

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FLC-COMPANY
Element: Company
Numeric 4
The company number represents an established company and is maintained on GL10.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL110
GL197 GL199
GL500
FLC-FISCAL-YEAR
Element: Year
Numeric 4
This is the fiscal year for the record.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLC-BUDGET-NBR
Element: Budget Nbr
Numeric 3
The number that identifies the budget.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLC-JE-TYPE
Element: Je Type
Alpha 1
The type of journal entry. Valid values are Normal, Intercompany, and Multiple Budget.
N
I
B
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLC-CONTROL-GROUP
Element: Control Group
Numeric 8
This field contains the journal entry number used for process control of the journal entry detail.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLC-JE-SEQUENCE
Element: Je Sequence
Numeric 2
The unique journal entry sequence number.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLC-STATUS
Element: Status
Numeric 1
This field contains the processing cycle status of the assigned journal entry. 0 = Unreleased 1 = Released 2 = Post In Progress 5 = Posted
9 = History
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLC-VERSION
Element: Version
Numeric 2
This field displays the budget version number.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLC-CURRENCY-CODE
Element: Currency Code
Alpha 5
This is the transaction currency for the journal entry.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLC-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLC-BASE-DEBITS
Element: Intl Amt
Signed 18.2
The total base debit amounts for the journal entry.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLC-BASE-CREDITS
Element: Intl Amt
Signed 18.2
The total base credit amounts for the journal entry.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLC-UNIT-ENTRY-DB
Element: Auto Debits
Signed 15.2
The total debit units for the journal entry.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLC-UNIT-ENTRY-CR
Element: Auto Credits
Signed 15.2
The total credit units for the journal entry.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLC-CNTRL-AMOUNT
Element: Intl Amt
Signed 18.2
The control total for the journal entry.
FB45.1 GL500
FLC-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the description for the journal entry.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLC-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLC-NBR-LINES
Element: Nbr Lines
Numeric 6
This is the number of detail lines.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLC-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field contains the system date when the journal entry was created.
FB40.2 FB40.4
FB45.1 GL197
GL199 GL500
FLC-OPERATOR
Element: Operator
Alpha 10
This field is used to store the login id of the person who entered the record.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLC-REL-OPERATOR
Element: Operator
Alpha 10
This field is used to store the login ID of the person who released the journal entry.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLC-TRAN-DESC-DFLT
Element: Tran Desc Dflt
Alpha 1
This field indicates if the journal entry header or the prior transaction line is used for the description.
FB40.2 FB45.1
GL197 GL199
GL500
FLC-ADJ-CODE
Element: Auth Code
Alpha 3
FB40.2 FB40.4
FB45.1
FLC-ADJ-CODE-DESC
Element: Description
Alpha 30 (Lower Case)
FB40.2 FB40.4
FLC-BLANK
Element: Blankam
Derived
This field consists of blank spaces. It is used to provide column headings on Drill Arounds.
FLC-UPD-ROLLOVER
Element: Flag Num
Numeric 1
GL197 GL199


FBCONTROL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FLCSET1 COMPANY
FISCAL-YEAR
BUDGET-NBR
JE-TYPE
CONTROL-GROUP
...
CA110 CA195
FB10.1 FB100
FB101 FB11.1
FB111 FB120
FB121 FB122
FB145 FB160
FB165 FB190
FB20.1 FB20.2
FB20.3 FB20.4
FB20.6 FB20.7
FB21.1 FB211
FB240 FB296
FB30.1 FB31.1
FB325 FB35.1
FB40.1 FB40.2
FLCSET2 COMPANY
STATUS
FISCAL-YEAR
BUDGET-NBR
JE-TYPE
CONTROL-GROUP
KeyChange
FB145 FB190
FB240 FB45.1
GL110


FBCONTROL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Fbcntrlau FBCNTRLAU
FLC-COMPANY->FCA-COMPANY
FLC-FISCAL-YEAR->FCA-FISCAL-YEAR
FLC-BUDGET-NBR->FCA-BUDGET-NBR
FLC-JE-TYPE->FCA-JE-TYPE
FLC-CONTROL-GROUP->FCA-CONTROL-GROUP
  FCA-ACTION
  FCA-DATE
  FCA-TIME
  FCA-UNIQUE-I-D
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


File created: Thu Jun 09 02:13:43 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.