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 AC200
AC210 ACAC.1 ACVW.1 AM120 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 AM70.4 AM94.1
AM97.1 AMBL.1 AP110 AP150 AP155 AP160
AP161 AP210 AP211 AP265 AP62.1 AP90.1
AP91.1 API3.1 API4.1 AR01.3 AR10.1 AR210
AR211 AR217 AR301 CB145 CB170 CB175
CB180 CB186 CB187 CB210 CB215 CB220
CB221 CB222 CB260 CB286 CB62.1 CA10.1
CA10.2 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 GL121 GL62.1 GLAC.1
GLBL.1 MX05.1 MX06.1 MX10.1 MX10.2 MX123
MX500 PR05.1 PR05.3 PR226 PR247 PR26.1
PR47.1 PR514 UK47.1 SLBL.1 SN02.1 SNAC.1
SNGL.1


UPDATED BY
AC00.1 AC10.1 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 ICLM.3 GL05.1 GL05.2
GL124 GL14.5 GL14.7 GL16.1 GL16.2 GL16.3
GL16.4 GL161 GL162 GL20.1 GL20.5 GL20.7
GL20.8 GL20.9 IFGT.1 IFOS.3 IFOS.2 MX00.3
MX00.1 MX00.2 MX100 MX135 POBL.3 RQBL.3
SL00.1 SL00.3 SL00.5 SL00.6 SL40.1 AM115
AM117 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 AM551 AM88.8 AMDM.2 AP115 AP125
AP126 AP131 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 CBDM.5 GL00.1 GL00.3
GL11.1 GL11.2 IFAS.2 MX201 MX202 MA41.1
MA41.2 MA41.4 MA41.7 MA43.1 MA43.2 MA43.3
MA43.4 MA43.6 MA43.7 MAI1.1 PO04.5 PO04.6
PO04.1 PO04.2 PO10.1 PO10.2 PO136 PO190
PO300 PO520 POCP.1 POI3.1 POII.1 POIJ.1
RQ01.2 RQ01.3 RQ01.1 SN70.4 AM170 AM96.1
AM98.1 CB00.3 PO15.1 PO15.2 PO15.4 PO204

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.
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
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.
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-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.
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 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 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
ICLM.3 IFGT.1
IFOS.3 MX135
POBL.3 RQBL.3
SL00.5 SL00.6
SL40.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 AC03.2
AC03.3 AC03.4
AC03.5 AC03.6
AC10.1 AC200
AC210 ACAC.1
ACVW.1 AM115
AM117 AM120
AM15.1 AM15.2
AM15.3 AM15.4
AM19.1 AM19.2
AM192 AM20.1
AM20.3 AM21.1
AM21.3 AM214
AM220 AM221
AM222 AM223
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 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 AP131
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: Wed Jun 08 20:49:46 2016

Home
Contact Us



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