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
| 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. |
|
||||||||||||
| FLT-FISCAL-YEAR Element: Year | Numeric 4 This is the current fiscal year for the record. |
|
||||||||||||
| FLT-BUDGET-NBR Element: Budget Nbr | Numeric 3 The number that identifies the budget. |
|
||||||||||||
| FLT-JE-TYPE Element: Je Type | Alpha 1 The type of journal entry. Valid values are: N = Normal I = Intercompany B = Interbudget |
|
||||||||||||
| FLT-CONTROL-GROUP Element: Control Group | Numeric 8 This field contains the journal entry number used for process control of the journal entry detail. |
|
||||||||||||
| FLT-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number. |
|
||||||||||||
| FLT-OBJ-ID Element: Obj Id | Numeric 12 This field contains the object ID sequence number. |
|
||||||||||||
| FLT-VERSION Element: Version | Numeric 2 This field displays the budget version number. |
|
||||||||||||
| FLT-STATUS Element: Status | Numeric 1 This field displays the status of the transaction. 0 = Unreleased 1 = Released 8 = Memo 9 = History |
|
||||||||||||
| 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. |
|
||||||||||||
| 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. |
|
||||||||||||
| 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. |
|
||||||||||||
| FLT-VAR-LEVELS Element: Var Levels | Alpha 30 A level that represents the location of an accounting unit in an organization's level structure. |
|
||||||||||||
| FLT-PERIOD Element: Period | Numeric 2 This field contains the period for this record. |
|
||||||||||||
| FLT-BASE-AMOUNT Element: Intl Amt | Signed 18.2 This is the base amount. |
|||||||||||||
| FLT-UNITS-AMOUNT Element: Units Amount | Signed 15.2 This is the units amount. |
|
||||||||||||
| FLT-BASE-ND Element: Base Nd | Numeric 1 The number of decimal positions defined for the company base currency. |
|
||||||||||||
| FLT-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field contains the description for the transaction line. |
|
||||||||||||
| 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. |
|
||||||||||||
| FLT-DATE Element: Date | Numeric 8 (yyyymmdd) This field contains the system date when the transaction line was created. |
|
||||||||||||
| FLT-UPDATE-DATE Element: Update Date | Numeric 8 (yyyymmdd) This field contains the date the record was updated. |
|
||||||||||||
| FLT-OPERATOR Element: Operator | Alpha 10 This field is used to store the login id of the person who entered the record. |
|
||||||||||||
| FLT-SOURCE-CODE Element: Source Code | Alpha 2 A two character code assigned to a transaction to identify where the transaction was created. |
|
||||||||||||
| FLT-TRAN-AMOUNT Element: Intl Amt | Signed 18.2 This is the amount in transaction currency to be posted. |
|
||||||||||||
| FLT-TRAN-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||||||||||
| 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. |
|
||||||||||||
| 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. |
|
||||||||||||
| FLT-TO-BUDGET Element: Budget Nbr | Numeric 3 The budget number to which the transaction line is posted. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FLTSET1 |
OBJ-ID |
|
|||||||||||||||||||||
| FLTSET2 |
COMPANY FISCAL-YEAR BUDGET-NBR JE-TYPE CONTROL-GROUP LINE-NBR |
|
| ||||||||||||||||||||
| FLTSET3 |
COMPANY FISCAL-YEAR BUDGET-NBR VERSION JE-TYPE CONTROL-GROUP LINE-NBR |
|
| ||||||||||||||||||||
| FLTSET5 |
TO-COMPANY FISCAL-YEAR BUDGET-NBR ACCT-UNIT ACCOUNT SUB-ACCOUNT OBJ-ID |
|
|||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Account | GLMASTER |
Required
| |||||||||||||||
| Chart Detail | GLCHARTDTL |
Not Required
| |||||||||||||||
| Company | GLSYSTEM |
Required
| |||||||||||||||
| Fbcontrol | FBCONTROL |
Required
| |||||||||||||||
| Fbheader | FBHEADER |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fbtrans | FBTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.