Lawson Insight Technical Documentation |
|
GLCOMMITX
GLCOMMITX FILE
GL commitment Detail
The General Ledger Commitx file contains the detail encumbrance and commitment
records created by sub systems.
REFERENCED BY
FB11.1 FB111 FB160 FB211 FB296 FB60.1
FB95.1 FB95.2 FB95.3 FB95.4 FB95.5 FB95.6
GL298 GL90.6 GL94.1 GL94.2 GL94.3 GL94.4
GL94.5 GL94.6 GL94.7 GL95.1 GL95.2 GL95.3
GL95.4 GL95.5 GL95.6 GL95.7 GL95.8 GL95.9
GL96.1 GL96.2 GL96.3 GL96.4 GL96.5 GL97.1
GL97.2 GL97.3 GL97.4 GL97.5 GL97.6 GL97.7
GL97.8 GL97.9 GL98.1 GL98.2 GL98.3 GL98.4
GL98.5 GL99.1 GL99.2 GL99.3 GL99.4 GL99.5
GL99.6 POIM.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
GOX-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
...
GOX-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
...
GOX-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
...
GOX-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
...
GOX-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
...
GOX-PERIOD Numeric 2 AP125 AP126
Element: Period This is the period 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
...
GOX-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
...
GOX-GLT-OBJ-ID Numeric 12 AP125 AP126
GL Transaction This is the object ID sequence number. AP131 AP170
Object ID 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
...
GOX-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
...
GOX-AMOUNT Signed 18.2 AP125 AP126
Element: Amount The base amount 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
...
GOX-UNIT Signed 15.2 AP125 AP126
Element: Unit The units 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
...
GOX-CURRENCY-CODE Alpha 5 AP125 AP126
Element: Currency Code This field contains the company base AP131 AP170
currency code established in Company AP193 AP25.1
(GL10.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
...
GOX-BASERATE Signed 14.7 AP125 AP126
Element: Base Rate The exchange rate at the time the record AP131 AP170
was created. 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
...
GOX-TRAN-AMOUNT Signed 18.2 AP125 AP126
Element: Transaction AmThis is the amount in transaction AP131 AP170
currency. 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
...
GOX-TRAN-ND Numeric 1 GL197 GL500
Transaction Number The number of decimal positions defined
of Decimals for the transaction currency.
GOX-INVOICE Alpha 22 AP125 AP126
Element: Invoice Used to identify the invoice number. 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
...
GOX-ITEM Alpha 32 AP125 AP126
Element: Item This field contains the item AP131 AP170
identifier. 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
...
GOX-RESOURCE-COMP Numeric 4 AP125 AP126
Element: Resource CompaRequired if resource type is employee; AP131 AP170
capture HR company. 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
...
GOX-RESOURCE-CODE Alpha 10 AP125 AP126
Element: Resource Code This field contains the subsystem AP131 AP170
resource number. 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
...
GOX-RESOURCE-TYPE Alpha 1 AP125 AP126
Element: Resource Type This field contains the resource type. 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
...
GOX-RESOURCE-DESC Alpha 30 (Lower Case) AP125 AP126
Element: Resource DescrThis field contains the resource AP131 AP170
description. (Required if resource is AP193 AP25.1
entered). 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
...
GOX-CREATED-YEAR Numeric 4 AP125 AP126
Element: Created Year This is the fiscal year the record was AP131 AP170
created in. 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
...
GOX-CREATED-PERIOD Numeric 2 AP125 AP126
Element: Created PeriodThis is the period that the record was AP131 AP170
created in. 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
...
GOX-TRANS-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Transaction DaCommitment transaction date. AP131 AP170
For payroll commitments created during AP193 AP25.1
salary encumbrance, this is the pay AP25.2 AP26.1
period end date. 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
...
GOX-SOURCE-CODE Alpha 2 AP125 AP126
Element: Source Code A two character code assigned to a AP131 AP170
transaction to identify where the AP193 AP25.1
transaction was created. 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
...
GLCOMMITX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GOXSET1 COMPANY FB11.1 FB111
ACCT-UNIT FB160 FB211
ACCOUNT FB296 FB60.1
SUB-ACCOUNT FB95.1 FB95.2
FISCAL-YEAR FB95.3 FB95.4
PERIOD FB95.5 FB95.6
SYSTEM GL120 GL197
CURRENCY-CODE GL298 GL500
GLT-OBJ-ID GL90.6 GL94.1
GL94.2 GL94.3
GL94.4 GL94.5
GL94.6 GL94.7
GL95.1 GL95.2
GL95.3 GL95.4
GL95.5 GL95.6
...
GOXSET2 GLT-OBJ-ID 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
...
GOXSET3 RESOURCE-COMP PR198
RESOURCE-TYPE
RESOURCE-CODE
SYSTEM
TRANS-DATE
GLT-OBJ-ID
GLCOMMITX FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Account GLMASTER Required
GOX-COMPANY -> GLM-COMPANY
GOX-ACCT-UNIT -> GLM-ACCT-UNIT
GOX-ACCOUNT -> GLM-ACCOUNT
GOX-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
Glamounts GLAMOUNTS Required
GOX-COMPANY -> GAM-COMPANY
GOX-FISCAL-YEAR -> GAM-FISCAL-YEAR
GOX-ACCT-UNIT -> GAM-ACCT-UNIT
GOX-ACCOUNT -> GAM-ACCOUNT
GOX-SUB-ACCOUNT -> GAM-SUB-ACCOUNT
Glcommit GLCOMMIT Required
GOX-COMPANY -> GOT-COMPANY
GOX-ACCT-UNIT -> GOT-ACCT-UNIT
GOX-ACCOUNT -> GOT-ACCOUNT
GOX-SUB-ACCOUNT -> GOT-SUB-ACCOUNT
GOX-FISCAL-YEAR -> GOT-FISCAL-YEAR
GOX-SYSTEM -> GOT-SYSTEM
Paencumber PAENCUMBER Required
GOX-GLT-OBJ-ID -> PEN-GLT-OBJ-ID
Rjencumb RJENCUMB Required
GOX-GLT-OBJ-ID -> RJE-GLT-OBJ-ID
GLCOMMITX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Actrans ACTRANS
GOX-GLT-OBJ-ID -> ATN-GLT-OBJ-ID
ATN-OBJ-ID
Apapdhist APAPDHIST
GOX-GLT-OBJ-ID -> AH2-GLT-OBJ-ID
AH2-API-OBJ-ID
AH2-DIST-SEQ-NBR
Apdistrib APDISTRIB
GOX-GLT-OBJ-ID -> APD-GLT-OBJ-ID
APD-API-OBJ-ID
APD-DIST-SEQ-NBR
Apdrftdist APDRFTDIST
GOX-COMPANY -> DDT-DIST-COMPANY
GOX-ACCT-UNIT -> DDT-DST-ACCT-UNIT
GOX-ACCOUNT -> DDT-DST-ACCOUNT
GOX-SUB-ACCOUNT -> DDT-DST-SUB-ACCT
DDT-POST-DATE
DDT-GLT-OBJ-ID
DDT-BANK-INST-CODE
DDT-TRANS-IDENT
DDT-SEQ-NBR
Cbdistrib CBDISTRIB
GOX-COMPANY -> CBD-DIST-COMPANY
GOX-ACCT-UNIT -> CBD-DIS-ACCT-UNIT
GOX-ACCOUNT -> CBD-DIS-ACCOUNT
GOX-SUB-ACCOUNT -> CBD-DIS-SUB-ACCT
GOX-GLT-OBJ-ID -> CBD-GLT-OBJ-ID
CBD-CASH-CODE
CBD-TRANS-NBR
CBD-BANK-INST-CODE
CBD-DIST-TYPE
CBD-SEQ-NBR
CBD-TRANS-IDENT
Eedistrib EEDISTRIB
GOX-GLT-OBJ-ID -> EED-GLT-OBJ-ID
EED-COMPANY
EED-VENDOR
EED-EXPENSE-NBR
EED-SEQ-NBR
Fbdetail FBDETAIL
GOX-COMPANY -> FBD-COMPANY
GOX-ACCT-UNIT -> FBD-ACCT-UNIT
GOX-ACCOUNT -> FBD-ACCOUNT
GOX-SUB-ACCOUNT -> FBD-SUB-ACCOUNT
FBD-BUDGET-NBR
FBD-FISCAL-YEAR
Gltrans GLTRANS
GOX-COMPANY -> GLT-COMPANY
GOX-FISCAL-YEAR -> GLT-FISCAL-YEAR
GOX-PERIOD -> GLT-ACCT-PERIOD
GLT-CONTROL-GROUP
GLT-SYSTEM
GLT-JE-TYPE
GLT-JE-SEQUENCE
GLT-LINE-NBR
Pommdist MMDIST
Valid When GOX-SYSTEM = "PO"
GOX-GLT-OBJ-ID -> MMD-GLT-OBJ-ID
MMD-COMPANY
MMD-SYSTEM-CD
MMD-LOCATION
MMD-DOC-TYPE
MMD-DOC-NUMBER
MMD-DOC-NBR-NUM
MMD-LINE-NBR
MMD-COMPONENT-SEQ
MMD-LINE-SEQ
Povagrmthd POVAGRMTHD
Valid When GOX-SYSTEM = "PO"
GOX-GLT-OBJ-ID -> PVH-GLT-OBJ-ID
PVH-PROCURE-GROUP
PVH-VEN-AGRMT-REF
Prdistrib PRDISTRIB
GOX-COMPANY -> PRD-DIST-COMPANY
GOX-ACCT-UNIT -> PRD-DST-ACCT-UNIT
GOX-ACCOUNT -> PRD-DST-ACCOUNT
GOX-SUB-ACCOUNT -> PRD-DST-SUB-ACCT
GOX-GLT-OBJ-ID -> PRD-GLT-OBJ-ID
PRD-OBJ-ID
Rqmmdist MMDIST
Valid When GOX-SYSTEM = "RQ"
GOX-GLT-OBJ-ID -> MMD-GLT-OBJ-ID
MMD-COMPANY
MMD-SYSTEM-CD
MMD-LOCATION
MMD-DOC-TYPE
MMD-DOC-NUMBER
MMD-DOC-NBR-NUM
MMD-LINE-NBR
MMD-COMPONENT-SEQ
MMD-LINE-SEQ
|