Lawson Insight Technical Documentation |
|
GLCOMMIT
GLCOMMIT FILE
REFERENCED BY
AC191 AC40.4 AC41.4 AC42.1 BR41.4 CA110
FB145 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 RW80.1 GLRV.1
UPDATED BY
AC541 AC542 AP125 AP126 AP131 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 CXCP.1
EE135 EE35.1 EE35.2 EE520 GL120 GL197
GL199 DR100 IC140 IC28.1 IC531 IC83.1
IFGT.1 MA180 MA41.2 MA41.7 MA43.1 MA43.2
MA43.3 MA43.9 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.1 MA67.2
MA70.1 MA75.1 MA80.1 MAI1.1 PO100 PO101
PO122 PO131 PO135 PO150 PO20.1 PO21.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.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 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 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 UK560
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ12.1 RQ13.1
RQ140 RQ300 RQ35.1 RQ40.1 RQ41.1 RQ42.1
RQ44.1 RQ44.2 RQ500 RQD0.1 RQIE.1 RQIF.1
TA147 UK120 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH25.1 WH25.2 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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GOT-COMPANY Numeric 4 AC541 AC542
Element: Company The company number represents an AP125 AP126
established company and is maintained on AP131 AP170
GL10. 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 GL197
...
GOT-ACCT-UNIT Alpha 15 AC541 AC542
Element: Accounting UniThe accounting unit is a shorthand AP125 AP126
notation representing the variable level AP131 AP170
number. The accounting unit must be AP193 AP20.1
defined in the General Ledger Names file AP20.2 AP20.3
as a posting accounting unit. 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 GL197
...
GOT-ACCOUNT Numeric 6 AC541 AC542
Element: Account This field along with the accounting AP125 AP126
unit and subaccount make up the location AP131 AP170
where amounts and other account AP193 AP20.1
information is stored. 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 GL197
...
GOT-SUB-ACCOUNT Numeric 4 AC541 AC542
Element: Subaccount This field along with the accounting AP125 AP126
unit and account make up the location AP131 AP170
where amounts and other account AP193 AP20.1
information is stored. 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 GL197
...
GOT-FISCAL-YEAR Numeric 4 AC541 AC542
Element: Last Closed YeThis is the fiscal year for the record. AP125 AP126
AP131 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 GL197
...
GOT-VAR-LEVELS Alpha 30 AC541 AC542
Element: New Levels A level that represents the location of AP125 AP126
an accounting unit in an organization's AP131 AP170
level structure. 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 GL120
...
GOT-SYSTEM Alpha 2 AC541 AC542
Element: System Code A two-character code representing the AP125 AP126
system in which the commitment is held. AP131 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 GL197
...
GOT-TRAN-ND Numeric 1
Account Currency The number of decimal positions defined
Code for the transaction currency.
GOT-DB-AMOUNT Currency 15.2 Occurs 13 Times AP20.1 AP20.2
Element: Amount The 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 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
PO30.1 PO30.2
PO30.3 PO31.1
...
GOT-CR-AMOUNT Currency 15.2 Occurs 13 Times AP20.1 AP20.2
Element: Amount The 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 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
PO30.1 PO30.2
PO30.3 PO31.1
...
GOT-DB-UNITS Signed 15.2 Occurs 13 Times AP20.1 AP20.2
Element: Auto Debits The debit units. 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 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
PO30.1 PO30.2
PO30.3 PO31.1
...
GOT-CR-UNITS Signed 15.2 Occurs 13 Times AP20.1 AP20.2
Element: Auto Credits The credit units. 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 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
PO20.1 PO21.1
PO21.2 PO21.3
PO21.4 PO21.5
PO23.1 PO25.1
PO25.5 PO25.6
PO25.7 PO27.2
PO30.1 PO30.2
PO30.3 PO31.1
...
GOT-MAINT-DATE Numeric 8 (yyyymmdd) AC541 AC542
Element: Date The date last changed. AP125 AP126
AP131 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 GL197
...
GOT-MAINT-TIME Numeric 6 (hhmmss) AC541 AC542
Element: Sys Time The time last changed. AP125 AP126
AP131 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 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 GL197
...
GLCOMMIT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GOTSET1 COMPANY AC191 AC40.4
ACCT-UNIT AC41.4 AC42.1
ACCOUNT AC541 AC542
SUB-ACCOUNT AP125 AP126
FISCAL-YEAR AP131 AP170
SYSTEM 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
...
GOTSET2 COMPANY KeyChange RW80.1 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
|