 |
Lawson Insight Technical Documentation |
|
GLCOMMIT FILE
REFERENCED BY
AC191 CA110 FB190 FB40.1 FB40.2 FB40.3
FB45.1 GL146 GL165 GL170 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL65.1
GL75.1 IC222 IFAC.1 POIM.1 GLRV.1
UPDATED BY
AC541 AC542 AP125 AP126 AP170 AP193
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP32.2 AP520 API1.1 API2.1 AR115
AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3
AR24.1 AR29.2 AR30.1 AR30.2 AR30.4 AR42.1
AR42.2 AR42.7 AR43.1 AR560 AR570 AR575
AR580 BN150 BN66.1 CB10.1 CB180 CB191
CB20.1 CB30.1 CB500 CB80.1 EE135 EE35.1
EE35.2 EE520 GL120 GL197 GL199 IFGT.1
MA41.2 MA43.2 MA61.1 MA70.1 MAI1.1 PO135
POIF.1 PR128 PR130 PR131 PR132 PR134
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 PR36.1 PR37.1 PR38.1 PR45.1 PR529
PR530 PR560 PR80.1 PR82.1 PR85.1 PR89.1
PRSA.1 UK102 UK330 TA147 UK120 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GOT-COMPANY Numeric 4 AC541 AC542
Company The company number represents an AP125 AP126
established company and is entered on AP170 AP193
all function codes. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
GL197 GL199
IFGT.1 MA41.2
...
GOT-ACCT-UNIT Alpha 15 AC541 AC542
Accounting Unit The accounting unit is a shorthand AP125 AP126
notation representing the variable level AP170 AP193
number. When used in the General Ledger AP20.1 AP20.2
Account Master file, the accounting unit AP20.3 AP20.4
must be defined in the General Ledger AP20.5 AP20.7
Names file as a posting accounting unit. AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
GL197 GL199
IFGT.1 MA41.2
...
GOT-ACCOUNT Numeric 6 AC541 AC542
Account This field along with the accounting AP125 AP126
unit and subaccount make up the location AP170 AP193
(account) where amounts and other AP20.1 AP20.2
account information is stored. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
GL197 GL199
IFGT.1 MA41.2
...
GOT-SUB-ACCOUNT Numeric 4 AC541 AC542
Subaccount This field along with the accounting AP125 AP126
unit and subaccount make up the location AP170 AP193
(account) where amounts and other AP20.1 AP20.2
account information is stored. AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
GL197 GL199
IFGT.1 MA41.2
...
GOT-FISCAL-YEAR Numeric 4 AC541 AC542
Fiscal Year This is the current fiscal year. This AP125 AP126
field is updated by Period Closing AP170 AP193
(GL199). AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
GL197 GL199
IFGT.1 MA41.2
...
GOT-VAR-LEVELS Alpha 30 AC541 AC542
Variable Levels A level that represents the location of AP125 AP126
an accounting unit in an organization's AP170 AP193
level structure. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
GL120 GL199
IFGT.1 MA41.2
...
GOT-SYSTEM Alpha 2 AC541 AC542
System Code A two-character code representing an AP125 AP126
application used within the Lawson AP170 AP193
system. (i.e.: GL = General Ledger, AP = AP20.1 AP20.2
Accounts Payable, etc.) AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
GL197 GL199
IFGT.1 MA41.2
...
GOT-TRAN-ND Numeric 1
Transaction Number The number of decimal positions defined
of Decimals for the transaction currency.
GOT-DB-AMOUNT Currency 15.2 Occurs 13 Times AP20.1 AP20.2
Debit Amount The budget debit amount. AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.2 AP30.4
AP32.2 AR20.1
AR21.1 AR21.2
AR21.3 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 CB10.1
CB20.1 CB30.1
CB80.1 EE35.1
EE35.2 GL197
MA41.2 MA43.2
MA61.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 PR36.1
PR80.1 PR82.1
PR85.1 WH20.7
GOT-CR-AMOUNT Currency 15.2 Occurs 13 Times AP20.1 AP20.2
Credit Amount The budget credit amount. AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.2 AP30.4
AP32.2 AR20.1
AR21.1 AR21.2
AR21.3 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 CB10.1
CB20.1 CB30.1
CB80.1 EE35.1
EE35.2 GL197
MA41.2 MA43.2
MA61.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 PR36.1
PR80.1 PR82.1
PR85.1 WH20.7
GOT-DB-UNITS Signed 15.2 Occurs 13 Times AP20.1 AP20.2
Debit Units Select the unit for the activity you AP20.3 AP20.4
performed. For example, a unit would be AP20.5 AP20.7
the number of computers purchased. AP25.1 AP25.2
AP30.2 AP30.4
AP32.2 AR20.1
AR21.1 AR21.2
AR21.3 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 CB10.1
CB20.1 CB30.1
CB80.1 EE35.1
EE35.2 GL197
MA41.2 MA43.2
MA61.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 PR36.1
PR80.1 PR82.1
PR85.1 WH20.7
GOT-CR-UNITS Signed 15.2 Occurs 13 Times AP20.1 AP20.2
Credit Unit Select the unit for the activity you AP20.3 AP20.4
performed. For example, a unit would be AP20.5 AP20.7
the number of computers purchased. AP25.1 AP25.2
AP30.2 AP30.4
AP32.2 AR20.1
AR21.1 AR21.2
AR21.3 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 CB10.1
CB20.1 CB30.1
CB80.1 EE35.1
EE35.2 GL197
MA41.2 MA43.2
MA61.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 PR36.1
PR80.1 PR82.1
PR85.1 WH20.7
GOT-MAINT-DATE Numeric 8 (yyyymmdd) AC541 AC542
Maintenance Date The date last changed. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
GL197 GL199
IFGT.1 MA41.2
...
GOT-MAINT-TIME Numeric 6 (hhmmss) AC541 AC542
Maintenance Time The time last changed. AP125 AP126
AP170 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP32.2
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR30.2
AR30.4 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 BN150
BN66.1 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
EE135 EE35.1
EE35.2 EE520
GL197 GL199
IFGT.1 MA41.2
...
GLCOMMIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GOTSET1 COMPANY AC191 AC541
ACCT-UNIT AC542 AP125
ACCOUNT AP126 AP170
SUB-ACCOUNT AP193 AP20.1
FISCAL-YEAR AP20.2 AP20.3
SYSTEM AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP32.2 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
...
GOTSET2 COMPANY GLRV.1
VAR-LEVELS
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
SYSTEM
GOTSET3 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR*
SYSTEM
GLCOMMIT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glcommitx GLCOMMITX
GOT-COMPANY -> GOX-COMPANY (GOXSET1)
GOT-ACCT-UNIT -> GOX-ACCT-UNIT
GOT-ACCOUNT -> GOX-ACCOUNT
GOT-SUB-ACCOUNT -> GOX-SUB-ACCOUNT
GOT-FISCAL-YEAR -> GOX-FISCAL-YEAR
GOX-PERIOD
GOX-SYSTEM
GOX-CURRENCY-CODE
GOX-GLT-OBJ-ID
|