Lawson Insight Technical Documentation |
|
GLAMOUNTSX
GLAMOUNTSX FILE
General Ledger Amounts-Daily
The General Ledger Amounts-Daily file contains daily account balances by
accounting unit, account, and subaccount for the date specified.
REFERENCED BY
GLOP.1 GL243 GL43.1
UPDATED BY
GL110 GL120 GL146 GL148 GL167 GL190
GL197 GL300 GL326 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GAX-COMPANY Numeric 4 GL110 GL146
Element: Company The Company field contains the company GL148 GL167
number this is used in the Organization GL190 GL197
dimension. GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GAX-DATE Numeric 8 (yyyymmdd) GL146 GL148
Element: Date The Date field contains the system date GL167 GL190
this was created. The Date format used GL197 GL326
is YYYYMMDD. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
GAX-ACCT-UNIT Alpha 15 GL146 GL148
Element: Accounting UniThe Accounting Unit field contains the GL167 GL190
name of the accounting unit that is used GL197 GL326
in the Organization dimension. If this GL40.1 GL40.2
field is blank, all accounting units are GL40.3 GL40.7
included as members in the dimension GL40.8 GL44.1
outline. This name can contain up to 15 GL45.1
alphabetic characters.
GAX-ACCOUNT Numeric 6 GL146 GL148
Element: Account This field along with the accounting GL167 GL190
unit and subaccount make up the location GL197 GL326
(account) where amounts and other GL40.1 GL40.2
account information is stored. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
GAX-SUB-ACCOUNT Numeric 4 GL146 GL148
Element: Subaccount This field along with the accounting GL167 GL190
unit and subaccount make up the location GL197 GL326
(account) where amounts and other GL40.1 GL40.2
account information is stored. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
GAX-VAR-LEVELS Alpha 30 GL120 GL146
Element: Variable LevelA level that represents the location of GL148 GL167
an accounting unit in an organization's GL190 GL197
level structure. GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GAX-CHART-NAME Alpha 12 GL146 GL148
Element: Chart Name The Chart of Accounts Name field GL167 GL190
contains the name of the chart of GL197 GL326
accounts that is used by the GL40.1 GL40.2
Organization dimension. This name can GL40.3 GL40.7
contain up to 12 alphabetic characters. GL40.8 GL44.1
GL45.1
GAX-DB-AMOUNT Signed 18.2 GL110 GL146
Element: Intl Amt The Debit Amount field contains the GL148 GL167
debit amount. GL190 GL197
GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GAX-CR-AMOUNT Signed 18.2 GL110 GL146
Element: Intl Amt The Credit Amount field contains the GL148 GL167
credit amount. GL190 GL197
GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GAX-FISCAL-YEAR Numeric 4 GL146 GL148
Element: Last Closed YeThe Fiscal Year field contains the GL167 GL190
numeric fiscal year. This field can GL197 GL326
contain up to four numeric characters. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GAX-ACCT-PERIOD Numeric 2 GL146 GL148
Element: Account PeriodThis is the current accounting period. GL167 GL190
This field is updated by GL199 (Period GL197 GL326
Closing). GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GAX-MAINT-DATE Numeric 8 (yyyymmdd) GL120 GL146
Element: Maintenance DaThe Maintenance Date field contains the GL148 GL167
date that this file was last updated. GL190 GL197
The date format used is YYYYMMDD. GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GAX-MAINT-TIME Numeric 6 (hhmmss) GL120 GL146
Element: Sys Time The Maintenance Time field contains the GL148 GL167
time that this file was last updated. GL190 GL197
The time format used is HHMMSS. GL326 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GAX-NET-AMOUNT Derived
Element: Net Amount The net daily base amount. This amount
is the debit amount added to the credit
amount.
GLAMOUNTSX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GAXSET1 COMPANY GL146 GL148
DATE GL167 GL190
ACCT-UNIT GL197 GL326
ACCOUNT GL40.1 GL40.2
SUB-ACCOUNT GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLOP.1
GAXSET2 MAINT-DATE KeyChange GLOP.1
MAINT-TIME
COMPANY
DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
GAXSET3 COMPANY KeyChange GL110 GL300
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
DATE
GAXSET4 COMPANY GL120 GL243
ACCT-UNIT GL43.1
ACCOUNT
SUB-ACCOUNT
DATE
GLAMOUNTSX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Gltrans GLTRANS
GAX-COMPANY -> GLT-TO-COMPANY
GAX-FISCAL-YEAR -> GLT-FISCAL-YEAR
GAX-ACCT-PERIOD -> GLT-ACCT-PERIOD
GAX-ACCT-UNIT -> GLT-ACCT-UNIT
GAX-ACCOUNT -> GLT-ACCOUNT
GAX-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
GAX-DATE -> GLT-POSTING-DATE
GLT-SYSTEM
GLT-CONTROL-GROUP
GLT-JE-TYPE
GLT-LINE-NBR
GLT-COMPANY
GLT-JE-SEQUENCE
|