ZGLXMONTHX

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MEX-COMPANY
Element: Company		Numeric 4
MEX-ASSIGNED-GL
Element: Assigned Gl		Numeric 4
MEX-AP-PO-COMPANY
Element: Ap Po Company		Numeric 4
MEX-FISCAL-YEAR
Element: Fiscal Year		Numeric 4
MEX-ACCT-PERIOD
Element: Acct Period		Numeric 2
MEX-SYSTEM
Element: System		Alpha 2
MEX-SOURCE-CODE
Element: Source Code		Alpha 2
MEX-OBJ-ID
Element: Obj Id		Numeric 12
MEX-API-OBJ-ID
Element: Api Obj Id		Numeric 12
MEX-RNI-OBJ-ID
Element: Rni Obj Id		Numeric 12
MEX-ACCT-UNIT
Element: Acct Unit		Alpha 15
MEX-ACCOUNT
Element: Account		Numeric 6
MEX-SUB-ACCOUNT
Element: Sub Account		Numeric 4
MEX-REPORT-ID-NBR
Element: Report Id Nbr		Numeric 9
MEX-MASTER-KEY
Element: Master Key		Alpha 80
MEX-ITEM
Element: Item		Alpha 32
MEX-TRANS-ID-TYPE
Element: Trans Id Type		Alpha 4
MEX-TRANS-DATE
Element: Trans Date		Numeric 8 (yyyymmdd)
MEX-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
MEX-DESCRIPTION-2
Element: Description 2		Alpha 30 (Lower Case)
MEX-UOM
Element: Uom		Alpha 4
MEX-QTY
Element: Qty		Signed 12.2
MEX-UNIT-PRICE
Element: Unit Price		Signed 13.5
MEX-EXT-PRICE
Element: Ext Price		Signed 13.5
MEX-ORIG-PROGRAM
Element: Orig Program		Alpha 5
MEX-ORIG-FILE
Element: Orig File		Alpha 12
MEX-ORIG-INDEX
Element: Orig Index		Alpha 10
MEX-LOCATION
Element: Location		Alpha 5
MEX-DOC-TYPE
Element: Doc Type		Alpha 2
MEX-DOCUMENT
Element: Document		Alpha 10 (Right Justified)
MEX-SHIPMENT-NBR
Element: Shipment Nbr		Numeric 10
MEX-LINE-NBR
Element: Line Nbr		Numeric 6
MEX-COMPONENT-SEQ
Element: Component Seq		Numeric 3
MEX-ITEM-GROUP
Element: Item Group		Alpha 5


ZGLXMONTHX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MEXSET1 FISCAL-YEAR
ACCT-PERIOD
ASSIGNED-GL
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
SYSTEM
ITEM
ORIG-PROGRAM
MASTER-KEY
KeyChange
MEXSET2 COMPANY
FISCAL-YEAR
ACCT-PERIOD
ITEM
LOCATION
MASTER-KEY
KeyChange, Subset
WhereLOCATION !=Spaces
MEXSET3 MASTER-KEY
KeyChange


ZGLXMONTHX FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompnay APCOMPANY Required
MEX-AP-PO-COMPANY->CPY-COMPANY (CPYSET1)
Glsystem GLSYSTEM Required
MEX-COMPANY->GLS-COMPANY
Pocompany POCOMPANY Required
MEX-AP-PO-COMPANY->PCY-COMPANY
Reqline REQLINE Required
MEX-COMPANY->RLN-COMPANY
MEX-DOCUMENT->RLN-REQ-NUMBER-A
MEX-LINE-NBR->RLN-LINE-NBR


ZGLXMONTHX FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Actrans ACTRANS
MEX-OBJ-ID->ATN-GLT-OBJ-ID
  ATN-OBJ-ID
Amtrans AMTRANS
MEX-OBJ-ID->AMT-GLT-OBJ-ID
  AMT-ASSET
  AMT-SEQ-NUMBER
Apdistrib APDISTRIB
MEX-API-OBJ-ID->APD-API-OBJ-ID
  APD-DIST-SEQ-NBR
Gltrans GLTRANS
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
Ictrans ICTRANS
MEX-COMPANY->ICT-COMPANY
MEX-LOCATION->ICT-LOCATION
MEX-ITEM->ICT-ITEM
  ICT-UPDATE-DATE
  ICT-UPDATE-TIME
  ICT-TRAN-COUNTER
Mmdistap MMDIST
MEX-AP-PO-COMPANY->MMD-COMPANY
MEX-API-OBJ-ID->MMD-API-OBJ-ID
  MMD-LINE-NBR
  MMD-AOC-CODE
  MMD-LINE-SEQ
Mmdistgl MMDIST
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
Mmdistrni MMDIST
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
Prdistrib PRDISTRIB
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
Reqheader REQHEADER
MEX-COMPANY->RQH-COMPANY
MEX-LOCATION->RQH-REQ-LOCATION
  RQH-REQUESTER
  RQH-REQ-NUMBER

File created: Thu Jun 09 11:18:55 2016

Home
Contact Us



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