MXOBJCAT

Attribute Object

This file contains the valid object and attribute records and determines how an object is used by the attribute.

REFERENCED BY
AC03.2 AC03.3 AC03.4 AC03.5 AC03.6 AC112
AC113 AC120 AC121 AC123 AC128 AC130
AC145 AC147 AC165 AC169 AC190 AC191
AC196 AC197 AC198 AC200 AC203 AC206
AC207 AC210 AC218 AC220 AC225 AC240
AC246 AC247 AC256 AC261 AC265 AC290
AC295 AC297 AC298 AC30.3 AC310 AC311
AC32.1 AC346 AC400 AC401 AC410 AC412
AC420 AC421 AC440 AC460 AC471 AC472
AC473 AC480 AC490 AC493 AC494 AC50.1
AC527 AC54.1 AC540 AC580 AC583 AC90.1
AC92.1 AC93.1 AC94.1 AC95.1 AC97.1 ACAC.1
SE90.1 AM120 AM220 AM221 AM222 AM223
AM224 AM225 AM230 AM235 AM240 AM245
AM25.2 AM250 AM255 AM260 AM265 AM267
AM270 AM275 AM277 AM278 AM280 AM281
AM285 AM287 AM290 AM292 AM295 AM310
AM320 AM330 AM35.1 AM45.1 AM501 AM51.1
AM70.4 AM97.1 AMBL.1 AP110 AP150 AP155
AP160 AP161 AP210 AP211 AP265 AP271
AP300 AP90.1 AP91.1 API3.1 API4.1 ZA161
AR01.3 AR10.1 AR210 AR211 AR217 AR301
ARLL.1 BR120 BR121 BR130 BR131 BR140
BR142 BR145 BR151 BR152 BR153 BR154
BR155 BR156 BR157 BR165 BR19.2 BR190
BR20.6 BR20.9 BR200 BR202 BR204 BR205
BR210 BR212 BR215 BR220 BR245 BR251
BR252 BR253 BR265 BR300 BR400 BR405
BR422 BR43.1 BR430 BR44.1 BR450 BR46.1
BR521 BR530 BR580 CB145 CB170 CB175
CB180 CB186 CB187 CB215 CB220 CB221
CB222 CB260 CB286 CA10.1 CA10.2 CA10.7
GL122 GL165 GL256 GL292 GL293 GL299
GL65.1 GL70.1 GL70.2 GL70.3 GL70.6 GL95.4
GL99.1 GLAC.1 MX123 MX500 MA279 ML165
ML65.1 PD230 PD235 PO223 PO233 PO253
PO254 PO278 PR05.1 PR05.3 PR226 PR247
PR26.1 PR47.1 PR514 UK47.1 RQ260 WH110
WH226 AC01.1 AC105 AC34.1 AC35.1 AC36.1
AC51.1 AC55.1 AC58.3 AC58.4 ACBA.1 ACDL.1
ACDM.2 ACDM.8 ACDM.9 ACVW.1 ATVW.1 AM214
AM282 AM94.1 AMDM.2 AP62.1 BR03.1 BR03.3
BR254 CB210 CB62.1 CBDM.5 FB141 GL294
GL55.1 RW20.1 RW20.2 RW80.1 GL11.1 GL11.2
GL121 GL62.1 GLBL.1 IFAS.2 MX05.1 MX06.1
MX10.1 MX10.2 MX201 ML191 ML292 ML293
ML70.1 ML70.2 ML70.3 ML70.6 ML95.4 ML99.1
SLBL.1 SN02.1 SN70.1 SN70.4 SNAC.1 SNGL.1


UPDATED BY
AC00.1 AC08.1 AC08.2 AC08.3 AC08.6 AC10.1
AC13.1 AC13.2 AC13.7 AC13.8 AC135 AC14.1
AC14.2 AC14.6 AC14.7 AC16.1 AC16.2 AC16.7
AC16.8 AC16.9 AC160 AC213 AC40.1 AC40.4
AC41.1 AC41.4 AC42.1 AC45.1 AC500 AC510
AC558 AC560 AM115 AM117 AM15.1 AM15.2
AM15.3 AM15.4 AM170 AM19.1 AM19.2 AM192
AM20.1 AM20.2 AM20.3 AM20.4 AM20.5 AM20.6
AM21.1 AM21.2 AM21.3 AM21.4 AM21.5 AM21.6
AM22.1 AM23.1 AM23.2 AM40.1 AM500 AM551
AM88.8 AM96.1 AM98.1 AP03.1 AP03.2 AP115
AP125 AP126 AP131 AP162 AP20.1 AP20.2
AP20.3 AP20.4 AP20.5 AP20.7 AP21.1 AP220
AP23.1 AP25.1 AP25.2 AP26.1 AP27.1 AP30.2
AP30.4 AP305 AP510 API1.1 API2.1 AR23.1
AR23.2 AR501 AR550 BR10.7 CB00.3 CB01.4
CB01.5 CB162 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
GL110 GL120 GL146 GL190 GL191 GL197
GL199 GL300 GL40.1 GL40.2 GL40.3 GL40.6
GL40.7 GL40.8 GL44.1 GL45.1 DR100 IC02.1
IC02.3 IC02.4 IC12.1 IC140 IC141 IC142
IC145 IC243 IC330 IC56.1 IC56.2 IC64.1
IC64.2 IC64.3 IC64.4 IC64.5 IC64.6 IC64.7
IC64.8 IC64.9 IC66.1 IC802 IC81.1 IC811
IC83.1 IC840 ICBL.3 ICLM.3 GL00.1 GL00.3
GL05.1 GL05.2 GL124 GL125 GL14.5 GL16.1
GL16.2 GL16.3 GL16.4 GL161 GL162 GL20.1
GL20.5 GL20.7 GL20.8 GL20.9 IFGT.1 IFOS.3
MX00.3 MX100 MX135 MX202 MA180 MA278
MA41.1 MA41.2 MA41.4 MA41.7 MA42.1 MA42.2
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MA44.1 MA44.2 MA53.1 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA63.1 MA65.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA69.1
MA70.1 MA75.1 MA80.1 MAI1.1 ML110 ML146
ML199 ML300 ML40.1 ML40.2 ML40.3 ML40.6
ML40.7 ML40.8 ML44.1 ML45.1 MLIT.1 PD10.1
PD10.2 PD130 PD20.1 PD20.2 PD20.3 PO04.1
PO04.2 PO04.5 PO04.6 PO10.1 PO10.2 PO100
PO101 PO115 PO120 PO122 PO131 PO136
PO15.1 PO15.2 PO15.4 PO150 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.4 PO26.5 PO27.2 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 POBL.3 POCP.1 POI3.1
POID.1 POII.1 POIJ.1 RQ01.1 RQ01.2 RQ01.3
RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ11.1 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810
RQBL.3 RQIB.1 RQIF.1 RQII.1 RQIJ.1 SL00.1
SL00.3 SL00.5 SL00.6 SL40.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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MOC-OBJ-TYPE
Element: Object Type		Alpha 5
This field determines the type of object used by the Attribute. These values are not user maintainable.
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
GL05.1 GL05.2
GL146 GL190
GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
ML146 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1 MX00.3
MX100 SL40.1
MOC-MATRIX-CAT
Element: Matrix Category		Alpha 12
Attribute name assigned to an object (like an accounting unit) to track additional information. Attribute values are used in selection and sorting for reporting and analysis.
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
GL05.1 GL05.2
GL146 GL190
GL191 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
ML146 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLIT.1 MX00.3
MX100 SL40.1
MOC-REQUIRED
Element: Required		Alpha 1
Indicates if a attribute category is required.
Y = Yes
N = No
GL05.1 GL05.2
MX00.3 MX100
MOC-APPLY-TO-GROUP
Element: Apply to Group		Alpha 15
Indicates if the attribute category applies to a company group or template.
MX00.3
MOC-USAGE-COUNT
Element: Usage Count		Numeric 12
The object record count. 		...
AC13.1 AC13.2
AC13.7 AC13.8
AC135 AC14.1
AC14.2 AC14.6
AC14.7 AC16.1
AC16.2 AC16.7
AC16.8 AC16.9
AC40.1 AC40.4
AC41.1 AC41.4
AC42.1 AC45.1
AC500 AC510
AC558 AC560
AM23.1 AM23.2
AM40.1 AM500
AP03.1 AP03.2
AP162 AR23.1
AR23.2 AR501
AR550 CB01.4
CB01.5 CB162
GL110 GL120
GL124 GL125
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL161
GL162 GL190
GL191 GL197
GL199 GL20.1
GL20.5 GL20.7
GL20.8 GL20.9
GL300 GL40.1
MOC-CALL-TOKEN
Element: Call Token		Alpha 6
Not referenced at this time.
MOC-DERIVED-DESC
Element: Description		Derived
The attribute description.
MOC-DERIVED-TYPE
Element: Type		Derived
The attribute type.
MOC-DERIVED-ELEM
Element: Element		Derived
The element associated with the attribute category.
MOC-DERIVED-SIZE
Element: Size		Derived
The element field size.
MOC-DERIVED-DATA
Element: Data		Derived
The attribute object.


MXOBJCAT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MOCSET1 OBJ-TYPE
MATRIX-CAT
...
AC00.1 AC01.1
AC03.2 AC03.3
AC03.4 AC03.5
AC03.6 AC08.1
AC08.2 AC08.3
AC08.6 AC10.1
AC105 AC112
AC113 AC120
AC121 AC123
AC128 AC13.1
AC13.2 AC13.3
AC13.7 AC13.8
AC130 AC135
AC14.1 AC14.2
AC14.3 AC14.6
MOCSET2 OBJ-TYPE
APPLY-TO-GROUP
MATRIX-CAT
KeyChange, Subset
Where(APPLY-TO-GROUP !=Spaces)
MOCSET3 OBJ-TYPE
MATRIX-CAT
KeyChange, Subset
Where(REQUIRED ="Y")
...
AC10.1 AC160
AM115 AM117
AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM19.1
AM19.2 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM22.1
AM500 AM551
AM96.1 AM98.1
AP115 AP125
MOCSET4 MATRIX-CAT
OBJ-TYPE
MX00.1 MX00.2
MX00.3 MX100
MX201


MXOBJCAT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company Group GLCPYGRP Not Required
Valid When (MOC-OBJ-TYPE ="ACCTU" )
MOC-APPLY-TO-GROUP->GCG-COMPANY-GROUP
Mxcatdef MXCATDEF Required
MOC-MATRIX-CAT->MXC-MATRIX-CAT
Mxelement MXELEMENT Required
MXC-ELEMENT-NAME->MXE-ELEMENT-NAME
Object Id OBJID Required
MOC-OBJ-TYPE->OBI-OBJ-TYPE


MXOBJCAT FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accatmxvdt ACCATMXVDT
MOC-MATRIX-CAT->MXB-MATRIX-CAT
  MXB-EFFECTIVE-DATE
  MXB-OBJ-ID
Aumxconv AUMXCONV
MOC-MATRIX-CAT->AUC-MATRIX-CAT
  AUC-OLD-COMPANY
  AUC-RUN-GROUP
  AUC-EFFECTIVE-DATE
Cbmxconv CBMXCONV
MOC-MATRIX-CAT->CBN-MATRIX-CAT
  CBN-COMPANY
  CBN-CASH-CODE
  CBN-RUN-GROUP
Edtemplate MXTMPLEFDT
MOC-OBJ-TYPE->MTE-OBJ-TYPE
MOC-MATRIX-CAT->MTE-MATRIX-CAT
  MTE-EFFECTIVE-DATE
  MTE-TEMPLATE-NAME
Glsccat GLSCCAT
MOC-MATRIX-CAT->GSC-MATRIX-CAT
  GSC-SOURCE-CODE
  GSC-SEQ-NBR
Matrix Values AUMXVALUE
Valid When (MOC-OBJ-TYPE ="ACCTU" )
MOC-MATRIX-CAT->AMV-MATRIX-CAT
  AMV-MX-VALUE
  AMV-OBJ-ID
Mxvalidate MXVALIDATE
MOC-MATRIX-CAT->MVL-MATRIX-CAT
  MVL-TH-MX-VAL
Templates MXTMPLDTL
MOC-OBJ-TYPE->MTD-OBJ-TYPE
MOC-MATRIX-CAT->MTD-MATRIX-CAT
  MTD-TEMPLATE-NAME
Used In Lists MXLISTDTL Delete Restricted
MOC-OBJ-TYPE->MLD-OBJ-TYPE
MOC-MATRIX-CAT->MLD-MATRIX-CAT
  MLD-MATRIX-LIST
  MLD-OR-GROUP
  MLD-SEQ-NUMBER
Vnmxconv VNMXCONV
MOC-MATRIX-CAT->VNC-MATRIX-CAT
  VNC-VENDOR-GROUP
  VNC-VENDOR

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

Home
Contact Us



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