MXOBJCAT

Attribute Object

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

REFERENCED BY
AC01.1 AC03.2 AC03.3 AC03.4 AC03.5 AC03.6
AC105 AC112 AC113 AC120 AC121 AC123
AC128 AC130 AC145 AC147 AC160 AC165
AC169 AC190 AC191 AC196 AC197 AC198
AC200 AC203 AC206 AC207 AC210 AC213
AC218 AC220 AC225 AC240 AC246 AC247
AC256 AC261 AC265 AC290 AC295 AC297
AC298 AC30.3 AC310 AC311 AC32.1 AC34.1
AC346 AC35.1 AC36.1 AC400 AC401 AC410
AC412 AC420 AC421 AC440 AC460 AC471
AC472 AC473 AC480 AC490 AC493 AC494
AC50.1 AC51.1 AC527 AC54.1 AC540 AC55.1
AC58.3 AC58.4 AC580 AC583 AC90.1 AC92.1
AC93.1 AC94.1 AC95.1 AC97.1 ACAC.1 ACBA.1
ACDL.1 ACDM.2 ACDM.8 ACDM.9 ACVW.1 ATVW.1
SE90.1 AM115 AM117 AM120 AM15.1 AM15.2
AM15.3 AM15.4 AM19.1 AM19.2 AM20.1 AM20.3
AM20.2 AM20.4 AM20.5 AM20.6 AM21.1 AM21.3
AM21.2 AM21.4 AM21.5 AM21.6 AM214 AM22.1
AM22.2 AM220 AM221 AM222 AM223 AM224
AM225 AM230 AM235 AM240 AM245 AM25.2
AM250 AM255 AM260 AM265 AM267 AM270
AM275 AM277 AM278 AM280 AM281 AM282
AM285 AM287 AM290 AM292 AM295 AM310
AM320 AM330 AM35.1 AM45.1 AM501 AM51.1
AM551 AM70.4 AM88.1 AM88.8 AM94.1 AM97.1
AMBL.1 AMDM.2 AP110 AP115 AP125 AP126
AP131 AP150 AP155 AP160 AP161 AP20.1
AP20.2 AP20.3 AP20.4 AP20.5 AP20.7 AP21.1
AP210 AP211 AP220 AP23.1 AP25.1 AP25.2
AP26.1 AP265 AP27.1 AP271 AP30.2 AP30.4
AP300 AP305 AP510 AP62.1 AP90.1 AP91.1
API1.1 API2.1 API3.1 API4.1 ZA161 AR01.3
AR210 AR211 AR217 AR301 ARLL.1 BR03.1
BR03.3 BR10.7 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 BR254 BR265 BR300
BR400 BR405 BR422 BR43.1 BR430 BR44.1
BR450 BR46.1 BR521 BR530 BR580 CB145
CB170 CB175 CB180 CB186 CB187 CB210
CB215 CB220 CB221 CB222 CB260 CB286
CB62.1 CBDM.5 CX100 CX20.1 CX20.2 CX20.4
CX20.5 CX220 CX30.1 CX300 CX506 CXCP.1
CA10.1 CA10.2 CA10.4 CA10.7 FB141 GL122
GL165 GL256 GL292 GL293 GL294 GL299
GL55.1 GL65.1 GL70.1 GL70.2 GL70.3 GL70.6
GL95.4 GL99.1 RW20.1 RW20.2 RW80.1 DR100
IC02.3 IC02.4 IC02.1 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 IC83.1 IC840
GL00.1 GL00.3 GL11.1 GL11.2 GL121 GL62.1
GLAC.1 GLBL.1 IFAS.2 MX05.1 MX05.2 MX06.1
MX06.2 MX10.1 MX10.2 MX123 MX20.1 MX20.2
MX20.4 MX20.5 MX201 MX202 MX500 MA126
MA180 MA278 MA279 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 MA540 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 ML165 ML191 ML292 ML293
ML65.1 ML70.1 ML70.2 ML70.3 ML70.6 ML95.4
ML99.1 PD10.1 PD10.2 PD130 PD20.1 PD20.2
PD20.3 PD230 PD235 PD570 PO04.1 PO04.2
PO04.5 PO04.6 PO10.1 PO10.2 PO100 PO101
PO115 PO120 PO122 PO131 PO132 PO136
PO15.1 PO15.2 PO15.4 PO150 PO17.1 PO190
PO192 PO195 PO20.1 PO20.6 PO20.9 PO204
PO21.1 PO21.2 PO21.3 PO21.4 PO21.5 PO22.1
PO22.2 PO22.3 PO22.4 PO22.5 PO220 PO222
PO223 PO224 PO225 PO229 PO23.1 PO230
PO233 PO234 PO24.1 PO25.1 PO25.5 PO25.6
PO25.7 PO251 PO253 PO254 PO26.3 PO26.7
PO26.9 PO26.4 PO26.5 PO27.2 PO27.3 PO27.4
PO275 PO276 PO277 PO278 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 PO529 PO536
PO54.1 PO54.2 PO54.3 PO54.4 PO54.5 POCP.1
POI3.1 POID.1 POII.1 POIJ.1 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 RQ01.1
RQ01.2 RQ01.3 RQ10.1 RQ10.2 RQ10.3 RQ10.4
RQ10.5 RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ260
RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1 RQIF.1
RQII.1 RQIJ.1 SLBL.1 SN02.1 SN70.1 SN70.4
SNAC.1 SNGL.1 WH110 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH226 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 AM170 AM96.1 AM98.1
CB00.3 IC802 IC81.1 IC811


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 AC40.1 AC40.4 AC41.1 AC41.4
AC42.1 AC45.1 AC500 AC510 AC558 AC560
AM192 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 GL146
GL190 GL191 GL197 GL199 GL300 GL40.1
GL40.2 GL40.3 GL40.6 GL40.7 GL40.8 GL44.1
GL45.1 ICBL.3 ICLM.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
ML110 ML146 ML199 ML300 ML40.1 ML40.2
ML40.3 ML40.6 ML40.7 ML40.8 ML44.1 ML45.1
MLIT.1 POBL.3 RQBL.3 SL00.1 SL00.3 SL00.5
SL00.6 SL40.1 AR10.1

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
AM22.2 AM500
AM551 AM96.1
AM98.1 AP115
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
Mxobjcatau MXOBJCATAU
MOC-OBJ-TYPE->MOA-OBJ-TYPE
MOC-MATRIX-CAT->MOA-MATRIX-CAT
  MOA-ACTION
  MOA-DATE
  MOA-TIME
  MOA-UNIQUE-I-D
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 02:20:58 2016

Home
Contact Us



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