|
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 AC113 AC120 AC121 AC123
AC128 AC130 AC145 AC160 AC165 AC169
AC190 AC191 AC197 AC198 AC200 AC203
AC206 AC207 AC210 AC213 AC218 AC220
AC225 AC240 AC246 AC256 AC261 AC265
AC290 AC295 AC298 AC30.3 AC310 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 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 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 AP30.2 AP30.4 AP305 AP510 AP62.1
AP90.1 AP91.1 API1.1 API2.1 API3.1 API4.1
AR01.3 AR120 AR129 AR130 AR131 AR135
AR170 AR21.2 AR210 AR211 AR217 AR222
AR223 AR227 AR228 AR229 AR230 AR232
AR233 AR235 AR237 AR238 AR239 AR245
AR250 AR251 AR253 AR257 AR258 AR264
AR265 AR27.2 AR271 AR275 AR282 AR285
AR29.1 AR290 AR291 AR292 AR293 AR294
AR296 AR30.5 AR300 AR301 AR32.1 AR33.2
AR38.5 AR39.3 AR39.4 AR42.1 AR42.2 AR42.7
AR42.8 AR43.1 AR502 AR503 AR55.1 AR560
AR575 AR800 AR91.1 ARLL.1 BL120 BL122
BL130 BL20.1 BL20.3 BL21.2 BL21.5 BL232
BL29.1 BL29.2 BL290 BL520 BL820 BL92.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 BR521 BR530 BR580 CB145
CB170 CB175 CB180 CB186 CB187 CB210
CB215 CB220 CB221 CB260 CB286 CB62.1
CBDM.5 ET540 ET700 CA10.1 CA10.2 CA10.7
FB141 GL165 GL256 GL292 GL293 GL294
GL55.1 GL65.1 GL70.1 GL70.2 GL70.3 GL70.6
GL95.4 GL99.1 RW20.1 RW20.2 RW80.1 IC02.3
IC02.4 IC02.1 GL00.1 GL00.3 GL11.1 GL11.2
GL62.1 GLAC.1 GLBL.1 IFAS.2 MX05.1 MX06.1
MX10.1 MX10.2 MX123 MX201 MX202 MX500
MA180 MA279 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA43.7
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA63.1 MA65.1 MA66.2 MA66.3 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 PD230 PD235 PO04.5 PO04.6 PO04.1
PO04.2 PO10.1 PO10.2 PO100 PO101 PO120
PO122 PO131 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO220 PO223 PO23.1
PO233 PO24.1 PO25.1 PO25.5 PO25.6 PO25.7
PO253 PO254 PO27.2 PO278 PO29.1 PO30.1
PO30.2 PO30.3 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.1 PO54.2 PO54.3 PO54.4
POI3.1 POID.1 POII.1 POIJ.1 PR05.1 PR05.3
PR226 PR247 PR26.1 PR47.1 PR514 UK47.1
RQ01.2 RQ01.3 RQ01.1 RQ10.1 RQ10.2 RQ10.3
SLBL.1 SN02.1 SN70.1 SN70.4 SNAC.1 SNGL.1
WH110 WH130 WH20.2 WH20.7 WH226 AM170
AM96.1 AM98.1 CB00.3 IC12.1 IC330 IC811
MA278 MA53.1 PO115 PO15.1 PO15.2 PO150
PO204 PO224 PO225 PO229 PO230 PO234
PO251 PO275 PO276 PO277 PO280 RQ11.1
RQ13.2 RQ35.1 RQ44.1 RQ500 RQ810 RQIB.1
RQIF.1 RQII.1 RQIJ.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 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 AR515
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 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
POBL.3 PW110 PW510 RQBL.3 SL00.1 SL00.3
SL00.5 SL00.6 SL40.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MOC-OBJ-TYPE Alpha 5 AC40.1 AC40.4
Element: 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 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
MX00.3 MX100
SL40.1
MOC-MATRIX-CAT Alpha 12 AC40.1 AC40.4
Element: Matrix CategorAttribute 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 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 IFGT.1
MX00.3 MX100
SL40.1
MOC-REQUIRED Alpha 1 GL05.1 GL05.2
Element: Required Indicates if a attribute category is MX00.3 MX100
required.
Y = Yes
N = No
MOC-APPLY-TO-GROUP Alpha 15 MX00.3
Element: Apply to GroupIndicates if the attribute category
applies to a company group or template.
MOC-USAGE-COUNT Numeric 12 AC13.1 AC13.2
Element: Usage Count The object record count. 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
AR515 AR550
CB01.4 CB01.5
CB162 GL110
GL120 GL124
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 Alpha 6
Element: Call Token Not referenced at this time.
MOC-DERIVED-DESC Derived
Element: Description The attribute description.
MOC-DERIVED-TYPE Derived
Element: Type The attribute type.
MOC-DERIVED-ELEM Derived
Element: Element The element associated with the
attribute category.
MOC-DERIVED-SIZE Derived
Element: Size The element field size.
MOC-DERIVED-DATA Derived
Element: Data The attribute object.
MXOBJCAT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MOCSET1 OBJ-TYPE AC00.1 AC01.1
MATRIX-CAT 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 KeyChange, Subset
APPLY-TO-GROUPWhere (APPLY-TO-GROUP != Spaces )
MATRIX-CAT
MOCSET3 OBJ-TYPE KeyChange, Subset AC10.1 AC160
MATRIX-CAT Where (REQUIRED = "Y" ) 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 AM500
AM551 AM96.1
AM98.1 AP115
AP125 AP126
...
MOCSET4 MATRIX-CAT MX00.1 MX00.2
OBJ-TYPE MX00.3 MX100
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
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
|