GLCOMMITX

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 GL299 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 POIK.1 POIM.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 AP510 AP520 API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 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 GL76.1 PR521 DR100
IC12.1 IC140 IC141 IC142 IC145 IC243
IC330 IC64.1 IC64.2 IC64.3 IC64.4 IC64.5
IC64.6 IC64.7 IC64.8 IC64.9 IC66.1 IC83.1
EX175 EX542 EXI2.1 EXI4.1 IFGT.1 IFUC.1
LP130 MA180 MA278 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA66.2 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
PD570 PO04.1 PO04.2 PO10.1 PO10.2 PO100
PO101 PO115 PO120 PO122 PO131 PO132
PO135 PO136 PO15.1 PO15.2 PO15.4 PO150
PO17.1 PO18.1 PO190 PO20.1 PO20.6 PO20.9
PO204 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO22.3 PO22.4 PO220 PO222 PO224
PO225 PO229 PO23.1 PO230 PO234 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO251 PO26.2
PO26.3 PO26.4 PO26.5 PO26.6 PO26.7 PO26.9
PO27.2 PO27.3 PO27.4 PO275 PO276 PO277
PO28.2 PO280 PO29.1 PO30.1 PO30.2 PO30.3
PO30.4 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 PO54.5 POCP.1 POD0.1 POI3.1 POID.1
POIF.1 POII.1 POIJ.1 PR128 PR131 PR132
PR134 PR135 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
PR36.4 PR37.1 PR38.1 PR45.1 PR529 PR530
PR560 PR582 PR80.1 PR80.4 PR82.1 PR85.1
PR89.1 PRAT.1 UK102 RQ01.1 RQ10.1 RQ10.2
RQ10.3 RQ10.4 RQ10.5 RQ11.1 RQ12.1 RQ13.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQD0.1
RQIB.1 RQIF.1 RQII.1 RQIJ.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 WH32.5
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 GLRV.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GOX-COMPANY
Element: Company
Numeric 4
The company number represents an established company and is maintained on GL10.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-ACCT-UNIT
Element: Accounting Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. The accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location where amounts and other account information is stored.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-SUB-ACCOUNT
Element: Subaccount
Numeric 4
This field along with the accounting unit and account make up the location where amounts and other account information is stored.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
This is the fiscal year for the record.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-PERIOD
Element: Period
Numeric 2
This is the period for the record.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-SYSTEM
Element: System
Alpha 2
A two-character code representing the system in which the commitment is held.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-GLT-OBJ-ID
GL Transaction
Object ID
Numeric 12
This is the object ID sequence number.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-VAR-LEVELS
Element: Variable Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-AMOUNT
Element: Amount
Signed 18.2
The base amount for the record.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-UNIT
Element: Unit
Signed 15.2
The units for the record.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-BASERATE
Element: Base Rate
Signed 14.7
The exchange rate at the time the record was created.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-TRAN-AMOUNT
Element: Transaction Amount
Signed 18.2
This is the amount in transaction currency.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-TRAN-ND
Transaction Number
of Decimals
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
GL197 GL500
GOX-INVOICE
Element: Invoice
Alpha 22
Used to identify the invoice number.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-ITEM
Element: Item
Alpha 32
This field contains the item identifier.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-RESOURCE-COMP
Element: Resource Company
Numeric 4
Required if resource type is employee; capture HR company.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-RESOURCE-CODE
Element: Resource Code
Alpha 10
This field contains the subsystem resource number.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-RESOURCE-TYPE
Element: Resource Type
Alpha 1
This field contains the resource type.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-RESOURCE-DESC
Element: Resource Description
Alpha 30 (Lower Case)
This field contains the resource description. (Required if resource is entered).
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-CREATED-YEAR
Element: Created Year
Numeric 4
This is the fiscal year the record was created in.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-CREATED-PERIOD
Element: Created Period
Numeric 2
This is the period that the record was created in.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-TRANS-DATE
Element: Transaction Date
Numeric 8 (yyyymmdd)
Commitment transaction date. For payroll commitments created during salary encumbrance, this is the pay period end date.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-SOURCE-CODE
Element: Source Code
Alpha 2
A two character code assigned to a transaction to identify where the transaction was created.
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-FBY-OBJ-ID
Element: Obj Id
Numeric 12
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-ACTIVITY
Element: Activity
Alpha 15
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175
GOX-ACCT-CATEGORY
Element: Acct Category
Alpha 5
...
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
AP510 AP520
API1.1 API2.1
ARLL.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 CB57.1
CB80.1 CB82.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 EE135
EE35.1 EE35.2
EE520 EX175


GLCOMMITX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GOXSET1 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
PERIOD
SYSTEM
CURRENCY-CODE
GLT-OBJ-ID
...
FB11.1 FB111
FB160 FB211
FB296 FB60.1
FB95.1 FB95.2
FB95.3 FB95.4
FB95.5 FB95.6
GL120 GL197
GL298 GL299
GL500 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
GOXSET2 GLT-OBJ-ID
...
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
AP510 AP520
API1.1 API2.1
ARLL.1 BN150
BN66.1 CB10.1
CB15.1 CB150
GOXSET3 RESOURCE-COMP
RESOURCE-TYPE
RESOURCE-CODE
SYSTEM
TRANS-DATE
GLT-OBJ-ID
PR198


GLCOMMITX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Povadist POVADIST Not Required
GOX-GLT-OBJ-ID->PVD-GLT-OBJ-ID
Rjencumb RJENCUMB Required
GOX-GLT-OBJ-ID->RJE-GLT-OBJ-ID


GLCOMMITX FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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
Povacommit POVACOMMIT
Valid When GOX-SYSTEM ="PO"
GOX-GLT-OBJ-ID->PVC-GLT-OBJ-ID
  PVC-PROCURE-GROUP
  PVC-VEN-AGRMT-REF
  PVC-LINE-NBR
  PVC-SYSTEM
  PVC-LINE-SEQ
  PVC-COMMIT-DATE
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-GLT-OBJ-ID->PRD-GLT-OBJ-ID
GOX-ACCT-UNIT->PRD-DST-ACCT-UNIT
GOX-ACCOUNT->PRD-DST-ACCOUNT
GOX-SUB-ACCOUNT->PRD-DST-SUB-ACCT
  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


File created: Thu Jun 09 02:14:02 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.