ZGLXMONTHX – No description in the Lawson data dictionary

System
General Ledger Setup (IF)
Prefix
MEX
Primary key
FISCAL-YEAR, ACCT-PERIOD, ASSIGNED-GL, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEM, ITEM, ORIG-PROGRAM, MASTER-KEY
Fields
34
Updated by
0 programs
Referenced by
0 programs

ZGLXMONTHX is a Lawson General Ledger Setup table (prefix MEX); no description in the lawson data dictionary. It is indexed by FISCAL-YEAR, ACCT-PERIOD, ASSIGNED-GL, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, SYSTEM, ITEM, ORIG-PROGRAM, MASTER-KEY (MEXSET1); alternate indexes: MEXSET2 and MEXSET3. It is related 1:1 to APCOMPANY, GLSYSTEM, POCOMPANY and REQLINE and 1:M to ACTRANS, AMTRANS, APDISTRIB, GLTRANS, ICTRANS, MMDIST, PRDISTRIB and REQHEADER. The table has 34 fields, 3 indexes and 14 documented relations.

About ZGLXMONTHX

No description in the Lawson data dictionary.

Fields (34)

Column = COBOL field name without the MEX- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#MEX-COMPANY SET2
COMPANY		Numeric 4——
#MEX-ASSIGNED-GL PK
ASSIGNED_GL		Numeric 4——
#MEX-AP-PO-COMPANY
AP_PO_COMPANY		Numeric 4——
#MEX-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4——
#MEX-ACCT-PERIOD PK
ACCT_PERIOD		Numeric 2——
#MEX-SYSTEM PK
SYSTEM		Alpha 2——
#MEX-SOURCE-CODE
SOURCE_CODE		Alpha 2——
#MEX-OBJ-ID
OBJ_ID		Numeric 12——
#MEX-API-OBJ-ID
API_OBJ_ID		Numeric 12——
#MEX-RNI-OBJ-ID
RNI_OBJ_ID		Numeric 12——
#MEX-ACCT-UNIT PK
ACCT_UNIT		Alpha 15——
#MEX-ACCOUNT PK
ACCOUNT		Numeric 6——
#MEX-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4——
#MEX-REPORT-ID-NBR
REPORT_ID_NBR		Numeric 9——
#MEX-MASTER-KEY PK
MASTER_KEY		Alpha 80——
#MEX-ITEM PK
ITEM		Alpha 32——
#MEX-TRANS-ID-TYPE
TRANS_ID_TYPE		Alpha 4——
#MEX-TRANS-DATE
TRANS_DATE		Numeric 8 (yyyymmdd)——
#MEX-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)——
#MEX-DESCRIPTION-2
DESCRIPTION_2		Alpha 30 (Lower Case)——
#MEX-UOM
UOM		Alpha 4——
#MEX-QTY
QTY		Signed 12.2——
#MEX-UNIT-PRICE
UNIT_PRICE		Signed 13.5——
#MEX-EXT-PRICE
EXT_PRICE		Signed 13.5——
#MEX-ORIG-PROGRAM PK
ORIG_PROGRAM		Alpha 5——
#MEX-ORIG-FILE
ORIG_FILE		Alpha 12——
#MEX-ORIG-INDEX
ORIG_INDEX		Alpha 10——
#MEX-LOCATION SET2
LOCATION		Alpha 5——
#MEX-DOC-TYPE
DOC_TYPE		Alpha 2——
#MEX-DOCUMENT
DOCUMENT		Alpha 10 (Right Justified)——
#MEX-SHIPMENT-NBR
SHIPMENT_NBR		Numeric 10——
#MEX-LINE-NBR
LINE_NBR		Numeric 6——
#MEX-COMPONENT-SEQ
COMPONENT_SEQ		Numeric 3——
#MEX-ITEM-GROUP
ITEM_GROUP		Alpha 5——

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MEXSET1
  1. FISCAL-YEAR
  2. ACCT-PERIOD
  3. ASSIGNED-GL
  4. ACCT-UNIT
  5. ACCOUNT
  6. SUB-ACCOUNT
  7. SYSTEM
  8. ITEM
  9. ORIG-PROGRAM
  10. MASTER-KEY
Primary, KeyChange—
MEXSET2
  1. COMPANY
  2. FISCAL-YEAR
  3. ACCT-PERIOD
  4. ITEM
  5. LOCATION
  6. MASTER-KEY
KeyChange, SubsetWhere LOCATION != Spaces—
MEXSET3
  1. MASTER-KEY
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APCOMPANYGLSYSTEMPOCOMPANYREQLINEACTRANSAMTRANSAPDISTRIBGLTRANSICTRANSMMDISTPRDISTRIBREQHEADERZGLXMONTHX

One to one (4) — lookups and parents

RelationTableRulesConditionField map
ApcompnayAPCOMPANYRequired
MEX-AP-PO-COMPANY→CPY-COMPANY (CPYSET1)
GlsystemGLSYSTEMRequired
MEX-COMPANY→GLS-COMPANY
PocompanyPOCOMPANYRequired
MEX-AP-PO-COMPANY→PCY-COMPANY
ReqlineREQLINERequired
MEX-COMPANY→RLN-COMPANY
MEX-DOCUMENT→RLN-REQ-NUMBER-A
MEX-LINE-NBR→RLN-LINE-NBR

One to many (10) — child tables

RelationTableRulesConditionField map
ActransACTRANS
MEX-OBJ-ID→ATN-GLT-OBJ-ID
—→ATN-OBJ-ID
AmtransAMTRANS
MEX-OBJ-ID→AMT-GLT-OBJ-ID
—→AMT-ASSET
—→AMT-SEQ-NUMBER
ApdistribAPDISTRIB
MEX-API-OBJ-ID→APD-API-OBJ-ID
—→APD-DIST-SEQ-NBR
GltransGLTRANS
MEX-COMPANY→GLT-TO-COMPANY
MEX-FISCAL-YEAR→GLT-FISCAL-YEAR
MEX-ACCT-PERIOD→GLT-ACCT-PERIOD
MEX-ACCT-UNIT→GLT-ACCT-UNIT
MEX-ACCOUNT→GLT-ACCOUNT
MEX-SUB-ACCOUNT→GLT-SUB-ACCOUNT
MEX-TRANS-DATE→GLT-POSTING-DATE
MEX-SYSTEM→GLT-SYSTEM
—→GLT-CONTROL-GROUP
—→GLT-JE-TYPE
—→GLT-LINE-NBR
—→GLT-COMPANY
—→GLT-JE-SEQUENCE
IctransICTRANS
MEX-COMPANY→ICT-COMPANY
MEX-LOCATION→ICT-LOCATION
MEX-ITEM→ICT-ITEM
—→ICT-UPDATE-DATE
—→ICT-UPDATE-TIME
—→ICT-TRAN-COUNTER
MmdistapMMDIST
MEX-AP-PO-COMPANY→MMD-COMPANY
MEX-API-OBJ-ID→MMD-API-OBJ-ID
—→MMD-LINE-NBR
—→MMD-AOC-CODE
—→MMD-LINE-SEQ
MmdistglMMDIST
MEX-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
MmdistrniMMDIST
MEX-RNI-OBJ-ID→MMD-RNI-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
PrdistribPRDISTRIB
MEX-COMPANY→PRD-DIST-COMPANY
MEX-ACCT-UNIT→PRD-GLT-OBJ-ID
MEX-ACCOUNT→PRD-DST-ACCT-UNIT
MEX-SUB-ACCOUNT→PRD-DST-ACCOUNT
MEX-OBJ-ID→PRD-DST-SUB-ACCT
—→PRD-OBJ-ID
ReqheaderREQHEADER
MEX-COMPANY→RQH-COMPANY
MEX-LOCATION→RQH-REQ-LOCATION
—→RQH-REQUESTER
—→RQH-REQ-NUMBER

Programs

No Lawson programs are documented as updating or referencing this table.