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
FB11.1 FB111 FB160 FB211 FB240 FB296
FB60.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5
FB95.6 GL298 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
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: Year This 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 Nbr 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: Je Type 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 Group This 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 Nbr This field contains the line number. FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL500
FLT-OBJ-ID Numeric 12 FB145 FB190
Element: Obj Id This field contains the object ID FB40.1 FB40.2
sequence number. FB40.3 FB40.4
FB45.1 GL110
GL197 GL500
FLT-VERSION Numeric 2 FB145 FB190
Element: Version This 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: Acct Unit The 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: Sub Acct 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: Var 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
GL500
FLT-PERIOD Numeric 2 FB145 FB190
Element: Period This 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
Element: Base Nd The number of decimal positions defined FB40.1 FB40.2
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 Rev 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 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
Element: Acct Nd The number of decimals assigned to a FB40.1 FB40.2
particular account as determined by the FB40.3 FB45.1
account currency. GL197 GL500
FLT-BASERATE Signed 14.7 FB145 FB190
Element: Curr 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 Identifies the AP company if the FB40.1 FB40.2
resource type = V. Identifies the HR FB40.3 FB45.1
company if the resource type = E. It is GL110 GL197
blank for type A, P or Q resources. GL500
FLT-TO-BUDGET Numeric 3 FB145 FB190
Element: Budget Nbr 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 FB11.1 FB111
FISCAL-YEAR FB145 FB160
BUDGET-NBR FB190 FB211
JE-TYPE FB240 FB296
CONTROL-GROUP FB40.1 FB40.2
LINE-NBR FB40.3 FB40.4
FB45.1 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL110 GL120
GL197 GL298
GL300 GL500
GL90.6 GL94.1
GL94.2 GL94.3
...
FLTSET3 COMPANY KeyChange FB145 FB190
FISCAL-YEAR FB296 FB40.1
BUDGET-NBR FB40.2 FB40.3
VERSION FB45.1 GL120
JE-TYPE GL197
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
|