MXOBJCAT FILE
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 AC121 AC123 AC160 AC165
AC170 AC190 AC191 AC196 AC198 AC203
AC206 AC207 AC210 AC213 AC218 AC240
AC256 AC258 AC261 AC265 AC290 AC295
AC297 AC298 AC30.3 AC310 AC32.1 AC34.1
AC35.1 AC36.1 AC400 AC401 AC410 AC412
AC420 AC421 AC440 AC460 AC471 AC472
AC473 AC480 AC490 AC493 AC494 AC50.1
AC51.1 AC530 AC54.1 AC540 AC55.1 AC70.1
AC70.4 AC90.1 AC92.1 AC93.1 AC94.1 AC95.1
AC97.1 ACBA.1 ACDM.8 ACVW.1 SE90.1 AM120
AM220 AM221 AM222 AM223 AM224 AM225
AM230 AM235 AM240 AM245 AM25.2 AM250
AM255 AM260 AM265 AM270 AM275 AM277
AM278 AM280 AM281 AM282 AM285 AM290
AM292 AM295 AM320 AM35.1 AM45.1 AM70.4
AM88.1 AM88.8 AM94.1 AMBL.1 AMDM.2 AR250
AR251 AR30.5 BR03.1 BR03.3 BR120 BR121
BR142 BR200 BR202 BR204 BR205 BR210
BR220 BR265 BR400 BR405 BR420 BR430
BR450 BRCC.1 CA10.1 CA10.2 CA10.7 GL165
GL256 GL55.1 GL65.1 GL70.1 GL70.2 GL70.3
GL70.6 RW80.1 GL00.1 GL00.3 GL11.1 GL11.2
GL62.1 GLAC.1 GLBL.1 IFAS.2 IFOS.2 MX05.1
MX06.1 MX10.1 MX10.2 MX123 MX135 MX201
MX202 MX500 SLBL.1 AM115 AM15.1 AM15.2
AM15.3 AM15.4 AM170 AM20.1 AM20.2 AM20.3
AM20.4 AM20.5 AM20.6 AM21.1 AM21.2 AM21.3
AM21.4 AM21.5 AM21.6 AM551 AM96.1 AM98.1
UPDATED BY
AC10.1 AC110 AC120 AC13.1 AC13.2 AC40.1
AC40.4 AC41.1 AC41.4 AC42.1 AC45.1 AC500
AC510 AM192 AM23.1 AM23.2 AM40.1 AM500
GL110 GL120 GL146 GL190 GL191 GL199
GL300 GL40.1 GL40.2 GL40.3 GL40.6 GL40.7
GL40.8 GL44.1 GL45.1 GL05.1 GL05.2 GL124
GL14.5 GL16.1 GL16.2 GL16.3 GL16.4 GL161
GL162 GL20.1 GL20.5 GL20.7 GL20.8 GL20.9
IFGT.1 MX00.3 MX100
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MOC-OBJ-TYPE Alpha 5 AC40.1 AC40.4
Object Type This field determines the type of AC41.1 AC41.4
object used by the Attribute. These AC42.1 AC45.1
values are not user maintainable. GL05.1 GL05.2
GL146 GL190
GL191 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
MX00.3 MX100
MOC-MATRIX-CAT Alpha 12 AC40.1 AC40.4
Matrix Category Attribute name assigned to an object AC41.1 AC41.4
(like an accounting unit) to track AC42.1 AC45.1
additional information. Attribute GL05.1 GL05.2
values are used in selection and sorting GL146 GL190
for reporting and analysis. GL191 GL199
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
MX00.3 MX100
MOC-REQUIRED Alpha 1 GL05.1 GL05.2
Required Indicates if a attribute category is MX00.3 MX100
required.
Y = Yes
N = No
MOC-APPLY-TO-GROUP Alpha 15 MX00.3
Apply to Group Indicates if the attribute category
applies to a company group or template.
MOC-USAGE-COUNT Numeric 12 AC10.1 AC110
Usage Count The object record count. AC120 AC13.1
AC13.2 AC40.1
AC40.4 AC41.1
AC41.4 AC42.1
AC45.1 AC500
AC510 AM23.1
AM23.2 AM40.1
AM500 GL110
GL120 GL124
GL146 GL16.1
GL16.2 GL16.3
GL16.4 GL161
GL162 GL190
GL191 GL199
GL20.1 GL20.5
GL20.7 GL20.8
GL20.9 GL300
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
IFGT.1
MOC-CALL-TOKEN Alpha 6
Call Token Not referenced at this time.
MOC-DERIVED-DESC Derived
Description The attribute description.
MOC-DERIVED-TYPE Derived
Type The attribute type.
MOC-DERIVED-ELEM Derived
Element The element associated with the
attribute category.
MOC-DERIVED-SIZE Derived
Size The element field size.
MOC-DERIVED-DATA Derived
Data The attribute object.
MXOBJCAT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MOCSET1 OBJ-TYPE AC01.1 AC03.2
MATRIX-CAT AC03.3 AC03.4
AC03.5 AC03.6
AC10.1 AC105
AC110 AC112
AC120 AC121
AC123 AC13.1
AC13.2 AC13.3
AC160 AC165
AC170 AC190
AC191 AC196
AC198 AC203
AC206 AC207
AC210 AC213
AC218 AC240
...
MOCSET2 OBJ-TYPE KeyChange, Subset
APPLY-TO-GROUPWhere (APPLY-TO-GROUP != Spaces )
MATRIX-CAT
MOCSET3 OBJ-TYPE KeyChange, Subset AC10.1 AM115
MATRIX-CAT Where (REQUIRED = "Y" ) AM15.1 AM15.2
AM15.3 AM15.4
AM170 AM20.1
AM20.2 AM20.3
AM20.4 AM20.5
AM20.6 AM21.1
AM21.2 AM21.3
AM21.4 AM21.5
AM21.6 AM500
AM551 AM96.1
AM98.1 GL00.1
GL00.3 GL20.1
MOCSET4 MATRIX-CAT MX00.1 MX00.2
OBJ-TYPE MX00.3 MX201
MXOBJCAT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Aumxconv AUMXCONV
MOC-MATRIX-CAT -> AUC-MATRIX-CAT
AUC-OLD-COMPANY
AUC-RUN-GROUP
AUC-EFFECTIVE-DATE
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
|