MAELMGPREL

Match Element Group Relation

REFERENCED BY
AP125 AP126 AP131 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.4 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 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
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
MA65.1 MA66.2 MA67.2 MA67.3 MA68.2 MA68.3
MA68.5 MA70.1 MA75.1 MA80.1 MAI1.1 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 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.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.3 PO26.4 PO26.5 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 POI3.1 POID.1
POII.1 POIJ.1 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 RQIB.1 RQIF.1
RQII.1 RQIJ.1 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


UPDATED BY
MA00.7

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MGR-MATCH-CLASS
Element: Match Class		Alpha 10
MA00.7
MGR-RELATION
Element: Relation		Alpha 15
The user analysis value relation assigned to the detail or summary account. The relation must exist in SL02.1 (User Analysis Value Relation).
MA00.7
MGR-SEQ-TRNS-NBR
Element: Seq Trns Nbr		Numeric 10
MA00.7
MGR-ELEMENT-GRP-1
Element: Element Grp 1		Alpha 10
MA00.7
MGR-ELEMENT-GRP-2
Element: Element Grp 2		Alpha 1
MA00.7
MGR-ELEMENT-GRP-3
Element: Element Grp 3		Alpha 10
MA00.7
MGR-ELEMENT-GRP-4
Element: Element Grp 4		Alpha 10
MA00.7
MGR-ELEMENT-GRP-5
Element: Element Grp 5		Alpha 10
MA00.7
MGR-ELEMENT-GRP-6
Element: Element Grp 6		Alpha 10
MA00.7
MGR-ELEMENT-GRP-7
Element: Element Grp 7		Alpha 10
MA00.7
MGR-ELEMENT-GRP-8
Element: Element Grp 8		Alpha 10
MA00.7
MGR-ELEMENT-GRP-9
Element: Element Grp 9		Alpha 10
MA00.7
MGR-ELEMENT-GRP-10
Element: Element Grp 10		Alpha 10
MA00.7


MAELMGPREL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MGRSET1 MATCH-CLASS
RELATION
SEQ-TRNS-NBR
MA00.7
MGRSET2 MATCH-CLASS
ELEMENT-GRP-1
ELEMENT-GRP-2
ELEMENT-GRP-3
ELEMENT-GRP-4
ELEMENT-GRP-5
ELEMENT-GRP-6
ELEMENT-GRP-7
ELEMENT-GRP-8
SEQ-TRNS-NBR
...
AP125 AP126
AP131 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.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100


MAELMGPREL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Matchclass MATCHCLASS Required
MGR-MATCH-CLASS->MAL-MATCH-CLASS

File created: Thu Jun 09 02:22:47 2016

Home
Contact Us



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