Budgeting Relationships
The Budget Relations file contains information for budget conversion from a
non-Lawson system to the Lawson General Ledger system.
UPDATED BY
| FB195 | FB65.1 | FB165 | FB265 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||
|---|---|---|---|---|---|---|
| FBR-RUN-GROUP Element: Run Group | Alpha 15 The run group name. A run group name is the name you assigned to the file when you transferred the non-Lawson file to the target machine. |
|
||||
| FBR-SEQ-NUMBER Element: Sequence | Numeric 6 The sequence number is a unique number assigned to each transaction to be transferred into the Lawson system. Run Group and Sequence Number are the keys to this file. Use these fields to group records together for interfacing. |
|
||||
| FBR-OLD-COMPANY Element: Organizational Code | Alpha 35 The old company identification code defined in GL08.1 (Organization Relationships). |
|
||||
| FBR-OLD-CPY-SHORT Old Company (Short Version) | Derived This is a short version of the old company structure. |
|
||||
| FBR-OLD-ACCT-NBR Element: Old Account Number | Alpha 25 The old account identification code defined in GL09.1 (Account Relationships). |
|
||||
| FBR-OLD-ACCT-SHORT Old Acct Nbr (Short Version) | Derived This is the short version of the old account structure. |
|
||||
| FBR-FISCAL-YEAR Element: Year | Numeric 4 This is the fiscal year budgets are transferred in. |
|
||||
| FBR-BUDGET-NBR Element: Budget | Numeric 3 The budget number as defined in FB20.1 (Period Budget, Rate) you are converting data to. |
|
||||
| FBR-BEGIN-BAL Element: Beg Bal | Signed 18.2 The beginning balance period amount for balance sheet accounts. For example, the amount you spent for the computers in a particular period. If you select units and a rate, the system calculates the amount. |
|
||||
| FBR-AMOUNT Element: Amounts | Signed 18.2 Occurs 13 Times The period amount. For example, how much you spent on computers in a period. |
|
||||
| FBR-BEGIN-BAL-UNT Element: Beg Bal | Signed 15.2 The units beginning balance for a balance sheet account. For example, a unit would be the number of computers purchased. |
|
||||
| FBR-UNITS Element: Amounts | Signed 15.2 Occurs 13 Times The budget unit. For example, a unit would be the number of computers purchased. |
|
||||
| FBR-BEG-BAL-RATE Element: Curr Rate | Signed 14.7 The rate that affects the factor. For example, the inflation rate or an employees hourly contract salary. |
|
||||
| FBR-FACTOR-RATE Element: Curr Rate | Signed 14.7 Occurs 13 Times The rate that affects the factor. For example, the inflation rate. |
|
||||
| FBR-BEG-BAL-FACTOR Element: Factor | Alpha 15 The global factor defined in FB00.1 (Global Factors) that is used to help calculate the budget amount. |
|
||||
| FBR-FACTOR Element: Factor | Alpha 15 Occurs 13 Times The global factor defined in FB00.1 (Global Factors) that is used to calculate the budget amount. |
|
||||
| FBR-AMOUNT-TYPE Element: Type | Alpha 1 This field determines whether the amount fields are period balances or year-to-date balances. The interface program uses this field to load the files correctly. P = Period Y = YTD |
|
||||
| FBR-CURRENCY-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FBRSET1 |
RUN-GROUP SEQ-NUMBER |
|
| ||||||||||
| FBRSET2 |
RUN-GROUP OLD-COMPANY OLD-ACCT-NBR FISCAL-YEAR BUDGET-NBR SEQ-NUMBER |
|
| ||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
|---|---|---|---|---|---|
| Glacctrel | GLACCTREL |
Not Required
| |||
| Glcomprel | GLCOMPREL |
Not Required
|
All trademarks and registered trademarks are the property of their
respective owners.