GL Balance Conversion
The General Ledger Period Balance Interface (GLMASTREL) file contains the information needed to create period balances in the Lawson General Ledger system when converting from another system in GL67.1 (Balance Interface Maintenance).
REFERENCED BY
GL267 |
GL167 | GL194 | GL67.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
GMR-COMPANY Element: Company | Numeric 4 The company number as defined in GL10.1 (Company). |
|
||
GMR-FISCAL-YEAR Element: Fiscal Year | Numeric 4 Contains the fiscal year for the data stored on this record. |
|
||
GMR-OLD-COMPANY Element: Old Company | Alpha 35 The old company structure associated with the Lawson Company and Accounting Unit. |
|
||
GMR-OLD-CPY-SHORT Old Company Short Desc | Derived The old company short description. |
|
||
GMR-OLD-ACCT-NBR Element: Old Account Number | Alpha 25 This is the old account structure to be associated with the new account/subaccount within the Lawson system. |
|
||
GMR-OLD-ACCT-SHORT Old Account Short Desc | Derived The old account short description. |
|
||
GMR-ACTIVE-STATUS Element: Active Status | Alpha 1 The status of the account. If Inactive, no posting can be done to the account. A = Active I = Inactive |
|
||
GMR-OPTION-FLD-1 Element: Option Field | Alpha 2 (Lower Case) Free-form field used to store any information relevant to an account. This field is used only for reporting purposes. |
|
||
GMR-OPTION-FLD-2 Element: Option Field | Alpha 7 (Lower Case) Free-form field used to store information relevant to an account. This field is used only for reporting purposes. |
|
||
GMR-OPTION-FLD-3 Element: Option Field | Alpha 12 (Lower Case) This is the level description. |
|
||
GMR-PERIOD-AMOUNT Element: Period Amount | Signed 18.2 Occurs 13 Times The net period amount. |
|
||
GMR-PERIOD-UNITS Element: Period Units | Signed 15.2 Occurs 13 Times The net period units amount. |
|
||
GMR-TRAN-CURR Element: Currency Code | Alpha 5 The transaction currency code. |
|
||
GMR-TRAN-AMOUNT Element: Intl Amt | Signed 18.2 Occurs 13 Times |
|
||
GMR-TRAN-BEG-BAL Element: Intl Amt | Signed 18.2 The transaction currency beginning balance amount. |
|
||
GMR-BEGIN-BAL Element: Begin Balance | Signed 18.2 If prior year balances are converted, then this field needs the beginning balance for balance sheet accounts for the prior year. |
|
||
GMR-BEGIN-UNIT-BAL Element: Begin Unit Balance | Signed 15.2 The beginning unit balance for balance sheet accounts for the prior year. |
|
||
GMR-ACCT-ND Account Number of Decimals | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||
GMR-RPT-PER-AMT-1 Element: Intl Amt | Signed 18.2 Occurs 13 Times |
|
||
GMR-RPT-PER-AMT-2 Element: Intl Amt | Signed 18.2 Occurs 13 Times |
|
||
GMR-RPT-BEG-BAL-1 Element: Intl Amt | Signed 18.2 |
|
||
GMR-RPT-BEG-BAL-2 Element: Intl Amt | Signed 18.2 |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GMRSET1 |
COMPANY FISCAL-YEAR OLD-COMPANY OLD-ACCT-NBR TRAN-CURR |
|
|
All trademarks and registered trademarks are the property of their
respective owners.