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
CB15.1 CB15.2 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 IC222 IFAC.1 POIM.1 RW80.1 GLRV.1
UPDATED BY
AP125 AP126 AP131 AP170 AP193 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
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 CB10.1
CB180 CB191 CB20.1 CB30.1 CB500 CB80.1
CXCP.1 EE135 EE35.1 EE35.2 EE520 GL120
GL170 GL197 GL199 GL500 GL70.1 GL70.2
GL70.3 GL70.5 GL70.6 GL75.1 DR100 IC140
IC28.1 IC531 IC83.1 IFGT.1 MA180 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 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE810
OE830 OE90.1 OE90.2 PA182 PO100 PO101
PO122 PO131 PO135 PO150 PO20.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO23.1 PO25.1
PO25.6 PO25.7 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.2 PO33.1 PO34.1
PO35.1 PO38.1 PO39.1 PO39.2 PO44.1 PO50.1
PO52.1 PO520 PO536 POCP.1 POI3.1 POID.1
POIE.1 POIF.1 POII.1 POIJ.1 PR128 PR130
PR131 PR132 PR134 PR136 PR137 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 PR82.1 PR85.1
PRSA.1 UK102 UK330 RQ10.1 RQ10.2 RQ12.1
RQ13.1 RQ13.2 RQ140 RQ300 RQ35.1 RQ40.1
RQ41.1 RQ42.1 RQ44.1 RQ44.2 RQ500 RQIF.1
TA147 TP135 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 AP125 AP126
Element: Company The company number represents an AP131 AP170
established company and is maintained on AP193 AP25.1
GL10. 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
GOT-ACCT-UNIT Alpha 15 AP125 AP126
Element: Accounting UniThe accounting unit is a shorthand AP131 AP170
notation representing the variable level AP193 AP25.1
number. The accounting unit must be AP25.2 AP26.1
defined in the General Ledger Names file AP27.1 AP30.2
as a posting accounting unit. AP30.4 AP520
API1.1 API2.1
AR115 AR124
AR190 AR20.1
AR21.1 AR21.2
AR21.3 AR24.1
AR29.2 AR30.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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
GOT-ACCOUNT Numeric 6 AP125 AP126
Element: Account This field along with the accounting AP131 AP170
unit and subaccount make up the location AP193 AP25.1
where amounts and other account AP25.2 AP26.1
information is stored. 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
GOT-SUB-ACCOUNT Numeric 4 AP125 AP126
Element: Subaccount This field along with the accounting AP131 AP170
unit and account make up the location AP193 AP25.1
where amounts and other account AP25.2 AP26.1
information is stored. 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
GOT-FISCAL-YEAR Numeric 4 AP125 AP126
Element: Fiscal Year This is the fiscal year for the record. AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
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 AP193 AP25.1
level structure. 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
GOT-SYSTEM Alpha 2 AP125 AP126
Element: System A two-character code representing the AP131 AP170
system in which the commitment is held. AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
GOT-TRAN-ND Numeric 1 GL500
Tran Curr Number of The number of decimal positions defined
Decimals for the transaction currency.
GOT-DB-AMOUNT Signed 18.2 Occurs 13 Times AP25.1 AP25.2
Element: Debit Amount The debit amount. AP30.2 AP30.4
AR20.1 AR21.1
AR21.2 AR21.3
AR29.2 AR30.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
CB20.1 CB30.1
CB80.1 EE35.1
EE35.2 GL197
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
GOT-CR-AMOUNT Signed 18.2 Occurs 13 Times AP25.1 AP25.2
Element: Credit Amount The credit amount. AP30.2 AP30.4
AR20.1 AR21.1
AR21.2 AR21.3
AR29.2 AR30.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
CB20.1 CB30.1
CB80.1 EE35.1
EE35.2 GL197
GL500 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
OE10.1 OE10.2
OE10.3 OE10.4
OE10.5 OE10.6
OE10.7 OE10.8
OE11.1 OE11.4
OE11.8 OE11.9
OE13.2 OE13.3
OE13.5 OE13.6
OE14.4 OE30.1
...
GOT-DB-UNITS Signed 15.2 Occurs 13 Times AP25.1 AP25.2
Element: Debit Units The debit units. AP30.2 AP30.4
AR20.1 AR21.1
AR21.2 AR21.3
AR29.2 AR30.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
CB20.1 CB30.1
CB80.1 EE35.1
EE35.2 GL197
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
OE30.1 OE30.2
...
GOT-CR-UNITS Signed 15.2 Occurs 13 Times AP25.1 AP25.2
Element: Credit Units The credit units. AP30.2 AP30.4
AR20.1 AR21.1
AR21.2 AR21.3
AR29.2 AR30.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
CB20.1 CB30.1
CB80.1 EE35.1
EE35.2 GL197
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE13.2
OE13.3 OE13.5
OE13.6 OE14.4
OE30.1 OE30.2
...
GOT-MAINT-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Maintenance DaThe date last changed. AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
GOT-MAINT-TIME Numeric 6 (hhmmss) AP125 AP126
Element: Maintenance TiThe time last changed. AP131 AP170
AP193 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
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 CB10.1
CB180 CB191
CB20.1 CB30.1
CB500 CB80.1
CXCP.1 DR100
EE135 EE35.1
EE35.2 EE520
...
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 AP193 AP25.1
SYSTEM 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
AR34.1 AR42.1
...
GOTSET2 COMPANY KeyChange RW80.1 GLRV.1
VAR-LEVELS
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
|