Lawson Insight Technical Documentation |
|
FBTRANS
FBTRANS FILE
Budget Transactions
The Flex Budget Transaction file contains the Flex Budget journal entry detail
information to be posted to the budget detail records. The transactions are
not deleted when posted and GL300 (General Ledger History Delete) should be
run to clear out information no longer needed.
REFERENCED BY
FB240 FB296
UPDATED BY
FB145 FB190 FB40.1 FB40.2 FB40.3 FB40.4
FB45.1 GL110 GL120 GL197 GL300 GL500
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 GL500
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
GL500
FLT-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
FLT-JE-TYPE Alpha 1 FB145 FB190
Element: Journal Entry The type of journal entry. Valid values FB40.1 FB40.2
are: FB40.3 FB40.4
N = Normal FB45.1 GL197
I = Intercompany GL500
B = Interbudget
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
GL500
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 GL500
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 GL500
FLT-VERSION Numeric 2 FB145 FB190
Element: Budget VersionThis field displays the budget version FB40.1 FB40.2
number. FB40.3 FB45.1
GL197 GL500
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 GL500
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 GL500
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 GL500
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 GL500
information is stored.
FLT-VAR-LEVELS Alpha 30 FB145 FB190
Element: Variable LevelA 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
GL500
FLT-PERIOD Numeric 2 FB145 FB190
Element: Last Closed PeThis field contains the period for this FB40.1 FB40.2
record. FB40.3 FB45.1
GL197 GL500
FLT-BASE-AMOUNT Signed 18.2 FB145 FB190
Element: Intl Amt This is the base amount. FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL500
FLT-UNITS-AMOUNT Signed 15.2 FB145 FB190
Element: Units Amount This is the units amount. FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL500
FLT-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 FB45.1
GL197 GL500
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
GL500
FLT-AUTO-REV Alpha 1 GL197 GL500
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 contains the system date when FB40.1 FB40.2
the transaction line was created. FB40.3 FB40.4
FB45.1 GL197
GL500
FLT-UPDATE-DATE Numeric 8 (yyyymmdd) FB145 FB190
Element: Update Date This field contains the date the record FB40.1 FB40.2
was updated. FB40.3 FB45.1
GL197 GL500
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 GL500
FLT-SOURCE-CODE Alpha 2 FB145 FB190
Element: Source Code A two character code assigned to a FB40.1 FB40.2
transaction to identify where the FB40.3 FB45.1
transaction was created. GL197 GL500
FLT-TRAN-AMOUNT Signed 18.2 FB145 FB190
Element: Intl Amt This is the amount in transaction FB40.1 FB40.2
currency to be posted. FB40.3 FB45.1
GL197 GL500
FLT-TRAN-ND Numeric 1 FB145 FB190
Account Currency The number of decimal positions defined FB40.1 FB40.2
Code for the transaction currency. FB40.3 FB45.1
GL197 GL500
FLT-BASERATE Signed 14.7 FB145 FB190
Element: Currency Rate The exchange rate at the time the FB40.1 FB40.2
journal entry was made. If left blank, FB40.3 FB45.1
the current exchange rate will default. GL197 GL500
FLT-TO-COMPANY Numeric 4 FB145 FB190
Element: Company This is the company number to which FB40.1 FB40.2
this line is to be posted. FB40.3 FB45.1
GL110 GL197
GL500
FLT-TO-BUDGET Numeric 3 FB145 FB190
Element: Budget Number The budget number to which the FB40.1 FB40.2
transaction line is posted. FB40.3 FB45.1
GL197 GL500
FBTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FLTSET1 OBJ-ID FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL110 GL197
FLTSET2 COMPANY KeyChange FB145 FB190
FISCAL-YEAR FB240 FB40.1
BUDGET-NBR FB40.2 FB40.3
JE-TYPE FB40.4 FB45.1
CONTROL-GROUP GL110 GL120
LINE-NBR GL197 GL300
GL500
FLTSET3 COMPANY KeyChange FB145 FB190
FISCAL-YEAR FB296 FB40.1
BUDGET-NBR FB40.2 FB40.3
VERSION FB45.1 GL197
JE-TYPE
CONTROL-GROUP
LINE-NBR
FLTSET5 TO-COMPANY Subset
FISCAL-YEAR Where STATUS != 8
BUDGET-NBR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
OBJ-ID
FBTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
FLT-TO-COMPANY -> GLM-COMPANY (GLMSET2)
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-JE-TYPE -> FLC-JE-TYPE
FLT-CONTROL-GROUP -> FLC-CONTROL-GROUP
Fbheader FBHEADER Required
FLT-COMPANY -> FBH-COMPANY
FLT-FISCAL-YEAR -> FBH-FISCAL-YEAR
FLT-BUDGET-NBR -> FBH-BUDGET-NBR
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-JE-TYPE -> FLT-JE-TYPE
FLT-CONTROL-GROUP -> FLT-CONTROL-GROUP
FLT-LINE-NBR
|