Lawson Insight Technical Documentation |
|
FBTRANS
FBTRANS FILE
REFERENCED BY
FB11.1 FB111 FB211 FB240 FB296 FB95.1
FB95.2 FB95.3 FB95.4 FB95.5 FB95.6 GL298
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
UPDATED BY
FB145 FB190 FB40.1 FB40.2 FB40.3 FB40.4
FB45.1 GL110 GL120 GL197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FLT-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
FLT-FISCAL-YEAR Numeric 4 FB145 FB190
Element: Last Closed YeThis is the current fiscal year for the FB40.1 FB40.2
record. FB40.3 FB40.4
FB45.1 GL197
FLT-BUDGET-NBR Numeric 3 FB145 FB190
Element: Budget Number The number that identifies budget. FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
FLT-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
FLT-LINE-NBR Numeric 6 FB145 FB190
Element: Line Number This field contains the line number. FB40.1 FB40.2
FB40.3 FB45.1
GL197
FLT-OBJ-ID Numeric 12 FB145 FB190
Object This field contains the object ID FB40.1 FB40.2
Identification sequence number. FB40.3 FB40.4
FB45.1 GL110
GL197
FLT-VERSION Numeric 2 FB145 FB190
Element: Budget VersionThis field displays the budget version FB40.1 FB40.2
number. FB40.3 FB45.1
GL197
FLT-STATUS Numeric 1 FB145 FB190
Element: Status This field displays the status of the FB40.1 FB40.2
transaction. FB40.3 FB40.4
0 = Unreleased FB45.1 GL197
1 = Released
8 = Memo
9 = History
FLT-ACCT-UNIT Alpha 15 FB145 FB190
Element: Accounting UniThe accounting unit is a shorthand FB40.1 FB40.2
notation representing the variable level FB40.3 FB45.1
number. The accounting unit entered in GL197
this field must be defined in the
General Ledger Names file as a posting
accounting unit.
FLT-ACCOUNT Numeric 6 FB145 FB190
Element: Account This field along with the accounting FB40.1 FB40.2
unit and subaccount make up the location FB40.3 FB45.1
where amounts and other account GL197
information is stored.
FLT-SUB-ACCOUNT Numeric 4 FB145 FB190
Element: Subaccount This field along with the accounting FB40.1 FB40.2
unit and account make up the location FB40.3 FB45.1
where amounts and other account GL197
information is stored.
FLT-VAR-LEVELS Alpha 30 FB145 FB190
Element: New Levels A level that represents the location of FB40.1 FB40.2
an accounting unit in an organization's FB40.3 FB45.1
level structure. GL120 GL197
FLT-PERIOD Numeric 2 FB145 FB190
Element: Current PeriodThis field contains the period for this FB40.1 FB40.2
record. FB40.3 FB45.1
GL197
FLT-BASE-AMOUNT Signed 15.2 FB145 FB190
Element: Adj Amt This is the base amount. FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
FLT-UNITS-AMOUNT Signed 15.2 FB145 FB190
Element: Adj Amt This is the units amount. FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
FLT-BASE-ND Numeric 1 FB145 FB190
Account Currency The number of decimal positions defined FB40.1 FB40.2
Code for the company base currency. FB40.3 FB45.1
GL197
FLT-DESCRIPTION Alpha 30 (Lower Case) FB145 FB190
Element: Description This field contains the description for FB40.1 FB40.2
the transaction line. FB40.3 FB40.4
FB45.1 GL197
FLT-AUTO-REV Alpha 1 GL197
Element: 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) FB145 FB190
Element: Date This field displays the system date when FB40.1 FB40.2
the transaction line was created. FB40.3 FB40.4
FB45.1 GL197
FLT-UPDATE-DATE Numeric 8 (yyyymmdd) FB145 FB190
Element: Date This field contains the date the record FB40.1 FB40.2
was updated. FB40.3 FB45.1
GL197
FLT-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 FB45.1
GL197
FBTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FLTSET1 OBJ-ID GL110
FLTSET2 COMPANY KeyChange FB11.1 FB111
FISCAL-YEAR FB145 FB190
BUDGET-NBR FB211 FB240
CONTROL-GROUP FB296 FB40.1
LINE-NBR FB40.2 FB40.3
FB40.4 FB45.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL110 GL120
GL197 GL298
GL94.1 GL94.2
GL94.3 GL94.4
GL94.5 GL94.6
GL94.7 GL95.1
...
FLTSET3 COMPANY KeyChange 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
|