FBTRANS

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
CA110 CA195 FB10.1 FB100 FB101 FB120
FB121 FB122 FB165 FB20.1 FB20.2 FB20.3
FB20.4 FB20.6 FB20.7 FB21.1 FB30.1 FB31.1
FB325 FB35.1 FB42.1 SNOP.1 SNRP.1 SNSP.1
FB240


UPDATED BY
AP125 AP126 AP131 AP170 AP190 AP193
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP510 AP520 API1.1 API2.1
ARLL.1 BN150 BN66.1 CB10.1 CB15.1 CB150
CB180 CB191 CB20.1 CB30.1 CB45.1 CB46.1
CB500 CB543 CB544 CB55.1 CB554 CB57.1
CB80.1 CB82.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
EE135 EE35.1 EE35.2 EE520 FB145 FB190
FB40.1 FB40.2 FB40.3 FB40.4 FB45.1 GL110
GL120 GL170 GL197 GL199 GL300 GL500
GL70.1 GL70.2 GL70.3 GL70.5 GL70.6 GL75.1
GL76.1 PR521 DR100 IC12.1 IC140 IC141
IC142 IC145 IC243 IC330 IC64.1 IC64.2
IC64.3 IC64.4 IC64.5 IC64.6 IC64.7 IC64.8
IC64.9 IC66.1 IC83.1 EX175 EX542 EXI2.1
EXI4.1 IFGT.1 IFUC.1 LP130 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA43.7 MA44.1 MA44.2 MA53.1 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PA182 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PD570 PO04.1 PO04.2
PO10.1 PO10.2 PO100 PO101 PO115 PO120
PO122 PO131 PO132 PO135 PO136 PO15.1
PO15.2 PO15.4 PO150 PO17.1 PO18.1 PO190
PO20.1 PO20.6 PO20.9 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO22.3 PO22.4
PO220 PO222 PO224 PO225 PO229 PO23.1
PO230 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO26.2 PO26.3 PO26.4 PO26.5
PO26.6 PO26.7 PO26.9 PO27.2 PO27.3 PO27.4
PO275 PO276 PO277 PO28.2 PO280 PO29.1
PO30.1 PO30.2 PO30.3 PO30.4 PO300 PO31.1
PO31.2 PO32.2 PO32.4 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 PO54.5 POCP.1
POD0.1 POI3.1 POID.1 POIF.1 POII.1 POIJ.1
PR128 PR131 PR132 PR134 PR135 PR136
PR137 PR140 PR189 PR195 PR197 PR29.1
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR35.9 PR36.1 PR36.4 PR37.1 PR38.1 PR45.1
PR529 PR530 PR560 PR582 PR80.1 PR80.4
PR82.1 PR85.1 PR89.1 PRAT.1 UK102 RQ01.1
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500
RQ810 RQD0.1 RQIB.1 RQIF.1 RQII.1 RQIJ.1
TA147 WH130 WH132 WH190 WH20.2 WH20.7
WH222 WH30.1 WH30.2 WH30.3 WH30.4 WH31.1
WH31.2 WH31.3 WH31.4 WH32.1 WH32.2 WH32.3
WH32.4 WH32.5 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 WH40.1 WH40.2 WH520 WH830
FB11.1 FB160 GL298 FB296 FB111 FB211
FB60.1 FB95.1 FB95.2 FB95.3 FB95.4 FB95.5
FB95.6 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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
FLT-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
FLT-FISCAL-YEAR
Element: Year
Numeric 4
This is the current fiscal year for the record.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLT-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
FLT-JE-TYPE
Element: Je Type
Alpha 1
The type of journal entry. Valid values are: N = Normal I = Intercompany B = Interbudget
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLT-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
FLT-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
FLT-OBJ-ID
Element: Obj Id
Numeric 12
This field contains the object ID sequence number.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL110
GL197 GL199
GL500
FLT-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
FLT-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction. 0 = Unreleased 1 = Released 8 = Memo 9 = History
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLT-ACCT-UNIT
Element: Acct Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. The accounting unit entered in this field must be defined in the General Ledger Names file as a posting accounting unit.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLT-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location where amounts and other account information is stored.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLT-SUB-ACCOUNT
Element: Sub Acct
Numeric 4
This field along with the accounting unit and account make up the location where amounts and other account information is stored.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLT-VAR-LEVELS
Element: Var Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL120 GL197
GL199 GL500
FLT-PERIOD
Element: Period
Numeric 2
This field contains the period for this record.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLT-BASE-AMOUNT
Element: Intl Amt
Signed 18.2
This is the base amount.
...
AP125 AP126
AP131 AP170
AP190 AP193
AP21.1 AP23.1
AP26.1 AP27.1
AP510 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB150
CB180 CB191
CB500 CB543
CB544 CB554
CB57.1 CX100
CX220 CX30.1
CX300 CX506
CXCP.1 DR100
EE135 EE520
EX175 EX542
EXI2.1 EXI4.1
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL170
GL197 GL199
GL500 GL75.1
IC140 IC141
IC142 IC145
IC243 IC330
IC83.1 IFGT.1
IFUC.1 LP130
FLT-UNITS-AMOUNT
Element: Units Amount
Signed 15.2
This is the units amount.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLT-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 FB45.1
GL197 GL199
GL500
FLT-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the description for the transaction line.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLT-AUTO-REV
Element: Auto Rev
Alpha 1
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.
GL197 GL199
GL500
FLT-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field contains the system date when the transaction line was created.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLT-UPDATE-DATE
Element: Update Date
Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLT-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 FB45.1
GL197 GL199
GL500
FLT-SOURCE-CODE
Element: Source Code
Alpha 2
A two character code assigned to a transaction to identify where the transaction was created.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLT-TRAN-AMOUNT
Element: Intl Amt
Signed 18.2
This is the amount in transaction currency to be posted.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB40.4
FB45.1 GL197
GL199 GL500
FLT-TRAN-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLT-BASERATE
Element: Curr Rate
Signed 14.7
The exchange rate at the time the journal entry was made. If left blank, the current exchange rate will default.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500
FLT-TO-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL110 GL197
GL199 GL500
FLT-TO-BUDGET
Element: Budget Nbr
Numeric 3
The budget number to which the transaction line is posted.
FB145 FB190
FB40.1 FB40.2
FB40.3 FB45.1
GL197 GL199
GL500


FBTRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
FLTSET1 OBJ-ID
...
AP125 AP126
AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP510 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
FLTSET2 COMPANY
FISCAL-YEAR
BUDGET-NBR
JE-TYPE
CONTROL-GROUP
LINE-NBR
KeyChange
FB145 FB190
FB240 FB40.1
FB40.2 FB40.3
FB40.4 FB45.1
GL110 GL120
GL197 GL199
GL300 GL500
FLTSET3 COMPANY
FISCAL-YEAR
BUDGET-NBR
VERSION
JE-TYPE
CONTROL-GROUP
LINE-NBR
KeyChange
FB145 FB190
FB296 FB40.1
FB40.2 FB40.3
FB45.1 GL120
GL197 GL199
FLTSET5 TO-COMPANY
FISCAL-YEAR
BUDGET-NBR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
OBJ-ID
Subset
WhereSTATUS !=8
...
FB11.1 FB111
FB160 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
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


FBTRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
FLT-TO-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-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
NAME
RELATED 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
Fbtransau FBTRANSAU
FLT-COMPANY->FTA-COMPANY
FLT-FISCAL-YEAR->FTA-FISCAL-YEAR
FLT-BUDGET-NBR->FTA-BUDGET-NBR
FLT-JE-TYPE->FTA-JE-TYPE
FLT-CONTROL-GROUP->FTA-CONTROL-GROUP
FLT-LINE-NBR->FTA-LINE-NBR
  FTA-ACTION
  FTA-DATE
  FTA-TIME
  FTA-UNIQUE-I-D


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

Home
Contact Us



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