FBTRANS FILE
REFERENCED BY
FB240 FB296
UPDATED BY
FB190 FB40.1 FB40.2 FB40.3 FB40.4 FB45.1
GL110 GL120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FLT-COMPANY Numeric 4 FB190 FB40.1
Company The company number represents an FB40.2 FB40.3
established company and is entered on FB40.4 FB45.1
all function codes. GL110
FLT-FISCAL-YEAR Numeric 4 FB190 FB40.1
Fiscal Year This is the current fiscal year. This FB40.2 FB40.3
field is updated by Period Closing FB40.4 FB45.1
(GL199).
FLT-BUDGET-NBR Numeric 3 FB190 FB40.1
Budget Number The Budget Number field contains the FB40.2 FB40.3
budget number. FB40.4 FB45.1
FLT-CONTROL-GROUP Numeric 8 FB190 FB40.1
Control Groups This field displays the journal entry FB40.2 FB40.3
number used for process control of the FB40.4 FB45.1
journal entry detail.
FLT-LINE-NBR Numeric 6 FB190 FB40.1
Line Number This field contains the line number. FB40.2 FB40.3
FB45.1
FLT-OBJ-ID Numeric 12 FB190 FB40.1
Object This is the object identifier. It is FB40.2 FB40.3
Identification used to relate commitments or posted FB40.4 FB45.1
transactions back to the originating GL110
subsystems. Each subsystem record that
is updated as a commitment or posted
transaction is assigned an object
identifier. The object identifier is
maintained in the subsystem files and in
the Activity Commitments Detail and
Activity Transaction files. The object
identifier is a unique key used to drill
back from Activity Management to the
subsystems.
FLT-VERSION Numeric 2 FB190 FB40.1
Budget Version This field displays the budget version FB40.2 FB40.3
number. FB45.1
FLT-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
FLT-ACCT-UNIT Alpha 15 FB190 FB40.1
Accounting Unit The accounting unit is a shorthand FB40.2 FB40.3
notation representing the variable level FB45.1
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
FLT-ACCOUNT Numeric 6 FB190 FB40.1
Account This field along with the accounting FB40.2 FB40.3
unit and subaccount make up the location FB45.1
(account) where amounts and other
account information is stored.
FLT-SUB-ACCOUNT Numeric 4 FB190 FB40.1
Subaccount This field along with the accounting FB40.2 FB40.3
unit and subaccount make up the location FB45.1
(account) where amounts and other
account information is stored.
FLT-VAR-LEVELS Alpha 30 FB190 FB40.1
Variable Levels A level that represents the location of FB40.2 FB40.3
an accounting unit in an organization's FB45.1 GL120
level structure.
FLT-PERIOD Numeric 2 FB190 FB40.1
Last Closed Period This is the current accounting period. FB40.2 FB40.3
This field is updated by Period Closing FB45.1
(GL199).
FLT-BASE-AMOUNT Signed 15.2 FB190 FB40.1
Base Amount The base amount to be posted to the FB40.2 FB40.3
General Ledger Account Master file. FB40.4 FB45.1
FLT-UNITS-AMOUNT Signed 15.2 FB190 FB40.1
Units Amount This is the units amount included in FB40.2 FB40.3
the file. FB40.4 FB45.1
FLT-BASE-ND Numeric 1 FB190 FB40.1
Base Number Of The number of decimal positions defined FB40.2 FB40.3
Decimals for the company base currency. FB45.1
FLT-DESCRIPTION Alpha 30 (Lower Case) FB190 FB40.1
Description This field displays the description. FB40.2 FB40.3
FB40.4 FB45.1
FLT-AUTO-REV Alpha 1
Auto Reverse When the Auto Reversal field is set to
"Y", the Lawson General Ledger Closing
program GL199 creates an opposite entry
for this transaction in the next period.
FLT-DATE Numeric 8 (yyyymmdd) FB190 FB40.1
Date This field displays the system date FB40.2 FB40.3
when this was created. FB40.4 FB45.1
FLT-UPDATE-DATE Numeric 8 (yyyymmdd) FB190 FB40.1
Update Date This field contains the date the record FB40.2 FB40.3
was updated. FB45.1
FLT-OPERATOR Alpha 10 FB190 FB40.1
Operator Code This field is used to store the login FB40.2 FB40.3
id of the person who entered the record. FB45.1
FBTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FLTSET1 OBJ-ID GL110
FLTSET2 COMPANY FB190 FB240
FISCAL-YEAR FB40.1 FB40.2
BUDGET-NBR FB40.3 FB40.4
CONTROL-GROUP FB45.1 GL110
LINE-NBR GL120
FLTSET3 COMPANY FB296
FISCAL-YEAR
BUDGET-NBR
VERSION
CONTROL-GROUP
LINE-NBR
FBTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
FLT-COMPANY -> GLM-COMPANY
FLT-ACCT-UNIT -> GLM-ACCT-UNIT
FLT-ACCOUNT -> GLM-ACCOUNT
FLT-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
Chart Detail GLCHARTDTL Not Required
GLS-CHART-NAME -> GDT-CHART-NAME
FLT-ACCOUNT -> GDT-ACCOUNT
FLT-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Company GLSYSTEM Required
FLT-COMPANY -> GLS-COMPANY
Fbcontrol FBCONTROL Required
FLT-COMPANY -> FLC-COMPANY
FLT-FISCAL-YEAR -> FLC-FISCAL-YEAR
FLT-BUDGET-NBR -> FLC-BUDGET-NBR
FLT-CONTROL-GROUP -> FLC-CONTROL-GROUP
FBTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Fbtrans FBTRANS
FLT-COMPANY -> FLT-COMPANY
FLT-FISCAL-YEAR -> FLT-FISCAL-YEAR
FLT-BUDGET-NBR -> FLT-BUDGET-NBR
FLT-CONTROL-GROUP -> FLT-CONTROL-GROUP
FLT-LINE-NBR
|
