Lawson Insight Technical Documentation |
|
GLCOMMIT
GLCOMMIT FILE
GL Commitments
The General Ledger Commit file contains beginning and period account balances
by company, accounting unit, account, subaccount, fiscal year, and system.
REFERENCED BY
AC191 AC40.4 AC41.4 AC42.1 BR41.4 BR44.1
CA110 FB145 FB190 FB40.1 FB40.2 FB40.3
FB45.1 GL146 GL165 GL40.1 GL40.2 GL40.3
GL40.7 GL40.8 GL44.1 GL45.1 GL65.1 IFAC.1
POIM.1 RQ11.1 RQIB.1 RQIJ.1 RW80.1 GLRV.1
UPDATED BY
AP125 AP126 AP131 AP170 AP190 AP193
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP23.1 AP25.1 AP25.2 AP26.1 AP27.1
AP30.2 AP30.4 AP520 API1.1 API2.1 AR115
AR124 AR190 AR20.1 AR21.1 AR21.2 AR21.3
AR24.1 AR29.2 AR30.1 AR32.1 AR34.1 AR42.1
AR42.2 AR42.7 AR43.1 AR560 AR570 AR575
AR580 ARLL.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 BN150 BN66.1 CB10.1 CB15.1
CB150 CB180 CB191 CB20.1 CB30.1 CB45.1
CB46.1 CB500 CB543 CB544 CB55.1 CB554
CB80.1 CB82.1 CXCP.1 EE135 EE35.1 EE35.2
EE520 ET530 ETI2.1 GL120 GL170 GL197
GL199 GL500 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 IFGT.1 LP130 MA180 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.7 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 MA66.3 MA67.2 MA67.3 MA68.2
MA68.3 MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1
PA182 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PO100 PO101 PO122 PO131 PO135
PO150 PO190 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 POCP.1 POD0.1 POI3.1 POID.1
POIF.1 POII.1 POIJ.1 PR128 PR130 PR131
PR132 PR134 PR136 PR137 PR140 PR189
PR195 PR197 PR198 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 PR35.9 PR36.1
PR37.1 PR38.1 PR45.1 PR529 PR530 PR560
PR80.1 PR82.1 PR85.1 PR89.1 UK102 UK330
UK560 RQ10.1 RQ10.2 RQ12.1 RQ13.1 RQ13.2
RQ35.1 RQ500 RQD0.1 RQIF.1 TA147 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH30.1
WH30.2 WH30.3 WH30.4 WH31.1 WH31.2 WH31.3
WH31.4 WH32.1 WH32.2 WH32.3 WH32.4 WH33.1
WH33.2 WH33.3 WH33.4 WH33.5 WH33.6 WH33.8
WH33.9 WH34.1 WH34.2 WH34.3 WH34.4 WH40.1
WH40.2 WH520 WH830
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GOT-COMPANY Numeric 4 AP125 AP126
Element: Company The company number represents an AP131 AP170
established company and is maintained on AP190 AP193
GL10. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
CB10.1 CB15.1
...
GOT-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThe accounting unit is a shorthand AP131 AP170
notation representing the variable level AP190 AP193
number. The accounting unit must be AP20.1 AP20.2
defined in the General Ledger Names file AP20.3 AP20.4
as a posting accounting unit. AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
CB10.1 CB15.1
...
GOT-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field along with the accounting AP131 AP170
unit and subaccount make up the location AP190 AP193
where amounts and other account AP20.1 AP20.2
information is stored. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
CB10.1 CB15.1
...
GOT-SUB-ACCOUNT Numeric 4 AP125 AP126
Element: Subaccount This field along with the accounting AP131 AP170
unit and account make up the location AP190 AP193
where amounts and other account AP20.1 AP20.2
information is stored. AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
CB10.1 CB15.1
...
GOT-FISCAL-YEAR Numeric 4 AP125 AP126
Element: Fiscal Year This is the fiscal year for the record. AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
CB10.1 CB15.1
...
GOT-VAR-LEVELS Alpha 30 AP125 AP126
Element: Variable LevelA level that represents the location of AP131 AP170
an accounting unit in an organization's AP190 AP193
level structure. AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
CB10.1 CB15.1
...
GOT-SYSTEM Alpha 2 AP125 AP126
Element: System A two-character code representing the AP131 AP170
system in which the commitment is held. AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
CB10.1 CB15.1
...
GOT-TRAN-ND Numeric 1 GL500
Tran Curr Number of The number of decimals assigned to a
Decimals particular account as determined by the
account currency.
GOT-DB-AMOUNT Signed 18.2 Occurs 13 Times AP20.1 AP20.2
Element: Debit Amount The debit amount. AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.2 AP30.4
AR20.1 AR21.1
AR21.2 AR21.3
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
CB10.1 CB15.1
CB20.1 CB30.1
CB45.1 CB46.1
CB55.1 CB80.1
CB82.1 EE35.1
EE35.2 GL197
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
GOT-CR-AMOUNT Signed 18.2 Occurs 13 Times AP20.1 AP20.2
Element: Credit Amount The credit amount. AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.2 AP30.4
AR20.1 AR21.1
AR21.2 AR21.3
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
CB10.1 CB15.1
CB20.1 CB30.1
CB45.1 CB46.1
CB55.1 CB80.1
CB82.1 EE35.1
EE35.2 GL197
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
GOT-DB-UNITS Signed 15.2 Occurs 13 Times AP20.1 AP20.2
Element: Debit Units The debit units. AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.2 AP30.4
AR20.1 AR21.1
AR21.2 AR21.3
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
CB10.1 CB15.1
CB20.1 CB30.1
CB45.1 CB46.1
CB55.1 CB80.1
CB82.1 EE35.1
EE35.2 GL197
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
...
GOT-CR-UNITS Signed 15.2 Occurs 13 Times AP20.1 AP20.2
Element: Credit Units The credit units. AP20.3 AP20.4
AP20.5 AP20.7
AP25.1 AP25.2
AP30.2 AP30.4
AR20.1 AR21.1
AR21.2 AR21.3
AR29.2 AR30.1
AR32.1 AR34.1
AR42.1 AR42.2
AR42.7 AR43.1
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
CB10.1 CB15.1
CB20.1 CB30.1
CB45.1 CB46.1
CB55.1 CB80.1
CB82.1 EE35.1
EE35.2 GL197
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
...
GOT-MAINT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Maintenance DaThe date last changed. AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
CB10.1 CB15.1
...
GOT-MAINT-TIME Numeric 6 (hhmmss) AP125 AP126
Element: Maintenance Time AP131 AP170
AP190 AP193
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR29.2
AR30.1 AR32.1
AR34.1 AR42.1
AR42.2 AR42.7
AR43.1 AR560
AR570 AR575
AR580 ARLL.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
BN150 BN66.1
CB10.1 CB15.1
...
GLCOMMIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GOTSET1 COMPANY AC191 AC40.4
ACCT-UNIT AC41.4 AC42.1
ACCOUNT AP125 AP126
SUB-ACCOUNT AP131 AP170
FISCAL-YEAR AP190 AP193
SYSTEM AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.2 AP30.4
AP520 API1.1
API2.1 AR115
AR124 AR190
...
GOTSET2 COMPANY KeyChange GL120 RW80.1
VAR-LEVELS GLRV.1
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
SYSTEM
GLCOMMIT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glamounts GLAMOUNTS Required
GOT-COMPANY -> GAM-COMPANY
GOT-FISCAL-YEAR -> GAM-FISCAL-YEAR
GOT-ACCT-UNIT -> GAM-ACCT-UNIT
GOT-ACCOUNT -> GAM-ACCOUNT
GOT-SUB-ACCOUNT -> GAM-SUB-ACCOUNT
Glmaster GLMASTER Required
GOT-COMPANY -> GLM-COMPANY
GOT-ACCT-UNIT -> GLM-ACCT-UNIT
GOT-ACCOUNT -> GLM-ACCOUNT
GOT-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
GLCOMMIT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Fbdetail FBDETAIL
GOT-COMPANY -> FBD-COMPANY
GOT-ACCT-UNIT -> FBD-ACCT-UNIT
GOT-ACCOUNT -> FBD-ACCOUNT
GOT-SUB-ACCOUNT -> FBD-SUB-ACCOUNT
FBD-BUDGET-NBR
FBD-FISCAL-YEAR
Glcommitx GLCOMMITX
GOT-COMPANY -> GOX-COMPANY
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
Gltrans GLTRANS
GOT-COMPANY -> GLT-TO-COMPANY
GOT-ACCOUNT -> GLT-ACCOUNT
GOT-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
GOT-ACCT-UNIT -> GLT-ACCT-UNIT
GOT-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLT-ACCT-PERIOD
GLT-SYSTEM
GLT-CONTROL-GROUP
GLT-JE-TYPE
GLT-JE-SEQUENCE
GLT-LINE-NBR
GLT-COMPANY
Gltransc GLTRANS
GOT-COMPANY -> GLT-COMPANY
GOT-VAR-LEVELS -> GLT-VAR-LEVELS
GOT-ACCT-UNIT -> GLT-ACCT-UNIT
GOT-ACCOUNT -> GLT-ACCOUNT
GOT-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
GOT-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLT-ACCT-PERIOD
GLT-SYSTEM
GLT-OBJ-ID
|