Table Name Column Name Col Type Length Scale Req’d? Must be Same as
ACCOUNTDEFAULTS DFLTGROUP 1 UPPER 20 0 1 1 ACCOUNTDEFAULTS GROUPVALUE 2 UPPER 50 0 1 1 ACCOUNTDEFAULTS GLDEFAULT 3 GL 23 0 0 1 ACCOUNTDEFAULTS OLDGLDEFAULT 4 GL 23 0 0 1
ACCOUNTDEFAULTS ORGID 5 UPPER 8 0 1 0 ORGANIZATION.ORGID ACCOUNTDEFAULTS ACCOUNTDEFAULTSID 6 INTEGER 12 0 1 1
ACTION ACTIONID 1 INTEGER 12 0 1 1 ACTION ACTION 2 UPPER 30 0 1 0 ACTION DESCRIPTION 3 ALN 100 0 0 0
ACTION OBJECTNAME 4 UPPER 18 0 0 1 MAXOBJECT.OBJECTNAME ACTION TYPE 5 UPPER 12 0 0 0
ACTION VALUE 6 ALN 254 0 0 0 ACTION PARAMETER 8 ALN 254 0 0 0
ACTION LANGCODE 13 UPPER 4 0 1 1 LANGUAGE.MAXLANGCODE ACTION MEMO 14 ALN 50 0 0 0
ACTION USEWITH 15 UPPER 10 0 1 0 ACTION HASLD 16 YORN 1 0 1 1 ACTION SENDERSYSID 17 ALN 50 0 0 0 ACTIONGROUP ACTIONGROUPID 1 INTEGER 12 0 1 1
ACTIONGROUP ACTION 2 UPPER 30 0 0 0 ACTION.ACTION ACTIONGROUP MEMBER 3 UPPER 30 0 0 0 ACTION.ACTION ACTIONGROUP SEQUENCE 4 INTEGER 12 0 0 0
ACTIONSCFG ACTIONSCFGID 1 INTEGER 12 0 1 1 ACTIONSCFG OPTIONNAME 2 UPPER 10 0 0 0 ACTIONSCFG APP 3 UPPER 10 0 0 0 ACTIONSCFG ORDERNUM 4 INTEGER 12 0 0 0 ACTIONSCFG LAYOUTID 5 INTEGER 12 0 0 0 ACTIONSCFG DESCRIPTION 6 ALN 100 0 0 0
ADDRESS ORGID 1 UPPER 8 0 1 0 ORGANIZATION.ORGID ADDRESS ADDRESSCODE 2 UPPER 30 0 1 0
ADDRESS DESCRIPTION 3 ALN 100 0 0 0 ADDRESS ADDRESS1 4 ALN 50 0 0 0 ADDRESS ADDRESS2 5 ALN 50 0 0 0 ADDRESS ADDRESS3 6 ALN 50 0 0 0 ADDRESS ADDRESS4 7 ALN 50 0 0 0
ADDRESS HASLD 14 YORN 1 0 1 1
ALNDOMAIN DOMAINID 1 UPPER 18 0 1 1 MAXDOMAIN.DOMAINID ALNDOMAIN VALUE 2 ALN 25 0 1 1
ALNDOMAIN DESCRIPTION 3 ALN 100 0 0 0
ALNDOMAIN SITEID 4 UPPER 8 0 0 0 SITE.SITEID
ALNDOMAIN ORGID 5 UPPER 8 0 0 0 ORGANIZATION.ORGID ALNDOMAIN ALNDOMAINID 6 INTEGER 12 0 1 1
ALTITEM ITEMNUM 1 UPPER 30 0 1 0 ITEM.ITEMNUM ALTITEM ALTITEMNUM 2 UPPER 30 0 1 0 ITEM.ITEMNUM ALTITEM ITEMSETID 3 UPPER 8 0 1 0 SETS.SETID ALTITEM ALTITEMID 4 INTEGER 12 0 1 1
APPDOCTYPE APP 1 UPPER 10 0 1 1 MAXAPPS.APP APPDOCTYPE DOCTYPE 2 ALN 16 0 1 0 DOCTYPES.DOCTYPE APPDOCTYPE APPDOCTYPEID 3 INTEGER 12 0 1 1
APPFIELDDEFAULTS APP 1 UPPER 10 0 1 1 MAXAPPS.APP APPFIELDDEFAULTS SITEID 2 UPPER 8 0 1 0 SITE.SITEID APPFIELDDEFAULTS GRPNAME 3 UPPER 30 0 0 0 PERSON.PERSONID APPFIELDDEFAULTS USERNAME 4 UPPER 30 0 0 0 PERSON.PERSONID APPFIELDDEFAULTS DEFAULTVALUE 5 ALN 50 0 0 0
APPFIELDDEFAULTS OBJECTNAME 6 UPPER 18 0 1 1 MAXOBJECT.OBJECTNAME APPFIELDDEFAULTS ATTRIBUTENAME 7 UPPER 50 0 1 0 MAXATTRIBUTE.ATTRIBUTENAME APPFIELDDEFAULTS APPFIELDDEFAULTSID 8 INTEGER 12 0 1 1
APPLICATIONAUTH GROUPNAME 1 UPPER 30 0 1 1 MAXGROUP.GROUPNAME APPLICATIONAUTH APP 2 UPPER 10 0 1 1 MAXAPPS.APP
APPLICATIONAUTH OPTIONNAME 3 UPPER 10 0 1 1 APPLICATIONAUTH APPLICATIONAUTHID 4 INTEGER 12 0 1 1
ARCHIVE ARCHIVEDATE 1 DATETIME 10 0 1 1 ARCHIVE MODULE 2 UPPER 30 0 1 1 ARCHIVE TYPE 3 ALN 8 0 0 1 ARCHIVE PATH 4 ALN 63 0 0 1 ARCHIVE ARCHSCRIPT 5 ALN 12 0 0 1 ARCHIVE RESTSCRIPT 6 ALN 12 0 0 1 ARCHIVE VIEWSQL 7 ALN 254 0 0 1
ARCHIVE SITEID 8 UPPER 8 0 0 0 SITE.SITEID
ARCHIVE ORGID 9 UPPER 8 0 0 0 ORGANIZATION.ORGID ARCHIVE ARCHIVEID 10 INTEGER 12 0 1 1
AREASAFFECTED AREASAFFECTEDID 1 INTEGER 12 0 1 1
AREASAFFECTED WONUM 2 UPPER 10 0 1 0 WORKORDER.WONUM AREASAFFECTED SITEID 3 UPPER 8 0 0 0 SITE.SITEID
AREASAFFECTED DESCRIPTION 4 ALN 100 0 0 0
AREASAFFECTED CONTACT 6 UPPER 30 0 0 0 PERSON.PERSONID
AREASAFFECTED CONTACTGROUP 7 UPPER 8 0 0 0 PERSONGROUP.PERSONGROUP AREASAFFECTED NOTIFY 8 YORN 1 0 1 1
AREASAFFECTED APPROVE 9 YORN 1 0 1 1
Table Name Column Name Col Type Length Scale Req’d? Must be Same as
AREASAFFECTED AFFECTEDCOMMODITY 12 UPPER 8 0 0 1 COMMODITIES.COMMODITY AREASAFFECTED AFFECTEDLOCATION 13 UPPER 12 0 0 0 LOCATIONS.LOCATION AREASAFFECTED AFFECTEDASSETNUM 14 UPPER 12 0 0 0 ASSET.ASSETNUM
AREASAFFECTED LANGCODE 15 UPPER 4 0 1 1 LANGUAGE.MAXLANGCODE AREASAFFECTED HASLD 16 YORN 1 0 1 1
ASSET ASSETNUM 1 UPPER 12 0 1 0
ASSET PARENT 2 UPPER 12 0 0 0 ASSET.ASSETNUM ASSET SERIALNUM 3 UPPER 15 0 0 0
ASSET ASSETTAG 4 ALN 15 0 0 0
ASSET LOCATION 5 UPPER 12 0 0 0 LOCATIONS.LOCATION ASSET DESCRIPTION 6 ALN 100 0 0 0 ITEM.DESCRIPTION ASSET VENDOR 7 UPPER 12 0 0 0 COMPANIES.COMPANY ASSET FAILURECODE 8 UPPER 8 0 0 0 FAILURECODE.FAILURECODE ASSET MANUFACTURER 9 UPPER 12 0 0 0 COMPANIES.COMPANY ASSET PURCHASEPRICE 10 AMOUNT 10 2 1 1
ASSET REPLACECOST 11 AMOUNT 10 2 1 1 ASSET INSTALLDATE 12 DATE 4 0 0 1 ASSET WARRANTYEXPDATE 13 DATE 4 0 0 1 ASSET TOTALCOST 14 AMOUNT 10 2 1 1 ASSET YTDCOST 15 AMOUNT 10 2 1 1 ASSET BUDGETCOST 16 AMOUNT 10 2 1 1
ASSET CALNUM 17 UPPER 8 0 0 0 CALENDAR.CALNUM ASSET ISRUNNING 18 YORN 1 0 1 1
ASSET ITEMNUM 19 UPPER 30 0 0 0 ITEM.ITEMNUM ASSET UNCHARGEDCOST 20 AMOUNT 10 2 1 1
ASSET TOTUNCHARGEDCOST 21 AMOUNT 10 2 1 1 ASSET TOTDOWNTIME 22 DURATION 8 0 1 1 ASSET STATUSDATE 23 DATETIME 10 0 0 1 ASSET CHANGEDATE 24 DATETIME 10 0 1 1
ASSET CHANGEBY 25 UPPER 30 0 1 0 PERSON.PERSONID ASSET EQ1 26 ALN 10 0 0 0
ASSET EQ2 27 ALN 10 0 0 0 ASSET EQ3 28 ALN 10 0 0 0 ASSET EQ4 29 ALN 10 0 0 0 ASSET EQ5 30 AMOUNT 10 2 0 0 ASSET EQ6 31 DATETIME 10 0 0 0 ASSET EQ7 32 DECIMAL 15 2 0 0 ASSET EQ8 33 ALN 10 0 0 0 ASSET EQ9 34 ALN 10 0 0 0 ASSET EQ10 35 ALN 10 0 0 0 ASSET EQ11 36 ALN 10 0 0 0
ASSET GLACCOUNT 42 GL 23 0 0 1 ASSET ROTSUSPACCT 43 GL 23 0 0 1 ASSET CHILDREN 44 YORN 1 0 1 1
ASSET BINNUM 45 ALN 8 0 0 0 INVENTORY.BINNUM ASSET DISABLED 46 YORN 1 0 1 1
ASSET CLASSSTRUCTUREID 47 UPPER 20 0 0 1 CLASSSTRUCTURE.CLASSSTRUCTUREID ASSET SOURCESYSID 48 ALN 10 0 0 0 MXCOLLAB.OWNER1SYSID ASSET OWNERSYSID 49 ALN 10 0 0 0 MXCOLLAB.OWNER1SYSID ASSET EXTERNALREFID 50 ALN 10 0 0 0
ASSET SITEID 51 UPPER 8 0 1 0 SITE.SITEID
ASSET ORGID 52 UPPER 8 0 1 0 ORGANIZATION.ORGID ASSET AUTOWOGEN 53 YORN 1 0 1 1 ASSET.ISRUNNING ASSET ITEMSETID 54 UPPER 8 0 0 0 SETS.SETID
ASSET CONDITIONCODE 66 UPPER 30 0 0 0 ITEMCONDITION.CONDITIONCODE ASSET GROUPNAME 67 UPPER 10 0 0 0 METERGROUP.GROUPNAME ASSET ASSETTYPE 69 ALN 15 0 0 0
ASSET USAGE 70 ALN 15 0 0 0 ASSET STATUS 71 ALN 20 0 0 0 ASSET MAINTHIERCHY 72 YORN 1 0 1 0 ASSET ASSETID 73 INTEGER 12 0 1 0 ASSET MOVED 74 YORN 1 0 1 0 ASSET ASSETUID 80 INTEGER 12 0 1 1
ASSET LANGCODE 86 UPPER 4 0 1 1 LANGUAGE.MAXLANGCODE ASSET TOOLRATE 87 AMOUNT 10 2 0 0
ASSET ITEMTYPE 88 UPPER 8 0 0 0
ASSET ANCESTOR 89 UPPER 12 0 0 0 ASSET.ASSETNUM ASSET SENDERSYSID 93 ALN 50 0 0 1
ASSET SHIFTNUM 94 UPPER 8 0 0 0 SHIFT.SHIFTNUM ASSET TOOLCONTROLACCOUNT 95 GL 23 0 0 1
ASSET HASLD 96 YORN 1 0 1 1 ASSETANCESTOR ASSETANCESTORID 1 INTEGER 12 0 1 1
ASSETANCESTOR ASSETNUM 2 UPPER 12 0 1 0 ASSET.ASSETNUM ASSETANCESTOR ANCESTOR 3 UPPER 12 0 1 0 ASSET.ASSETNUM ASSETANCESTOR SITEID 4 UPPER 8 0 1 0 SITE.SITEID
ASSETANCESTOR ORGID 5 UPPER 8 0 1 0 ORGANIZATION.ORGID ASSETANCESTOR HIERARCHYLEVELS 6 INTEGER 12 0 1 0
ASSETATTRIBUTE ASSETATTRID 1 UPPER 8 0 1 0 ASSETATTRIBUTE DESCRIPTION 2 ALN 100 0 0 0 ASSETATTRIBUTE DATATYPE 3 UPPER 8 0 1 0
ASSETATTRIBUTE MEASUREUNITID 4 UPPER 8 0 0 0 MEASUREUNIT.MEASUREUNITID ASSETATTRIBUTE DOMAINID 5 UPPER 18 0 0 1 MAXDOMAIN.DOMAINID
ASSETATTRIBUTE ATTRDESCPREFIX 6 ALN 8 0 0 0
ASSETATTRIBUTE ORGID 7 UPPER 8 0 0 0 ORGANIZATION.ORGID ASSETATTRIBUTE SITEID 8 UPPER 8 0 0 0 SITE.SITEID
Table Name Column Name Col Type Length Scale Req’d? Must be Same as
ASSETCUST PARENT 2 UPPER 12 0 0 0 ASSET.ASSETNUM ASSETCUST SERIALNUM 3 UPPER 15 0 0 0 ASSET.SERIALNUM ASSETCUST ASSETTAG 4 ALN 15 0 0 0 ASSET.ASSETTAG ASSETCUST LOCATION 5 UPPER 12 0 0 0 LOCATIONS.LOCATION ASSETCUST DESCRIPTION 6 ALN 100 0 0 0 ITEM.DESCRIPTION ASSETCUST VENDOR 7 UPPER 12 0 0 0 COMPANIES.COMPANY ASSETCUST FAILURECODE 8 UPPER 8 0 0 0 FAILURECODE.FAILURECODE ASSETCUST MANUFACTURER 9 UPPER 12 0 0 0 COMPANIES.COMPANY ASSETCUST PURCHASEPRICE 10 AMOUNT 10 2 1 1 ASSET.PURCHASEPRICE ASSETCUST REPLACECOST 11 AMOUNT 10 2 1 1 ASSET.REPLACECOST ASSETCUST INSTALLDATE 12 DATE 4 0 0 1 ASSET.INSTALLDATE ASSETCUST WARRANTYEXPDATE 13 DATE 4 0 0 1 ASSET.WARRANTYEXPDATE ASSETCUST TOTALCOST 14 AMOUNT 10 2 1 1 ASSET.TOTALCOST
ASSETCUST YTDCOST 15 AMOUNT 10 2 1 1 ASSET.YTDCOST ASSETCUST BUDGETCOST 16 AMOUNT 10 2 1 1 ASSET.BUDGETCOST ASSETCUST CALNUM 17 UPPER 8 0 0 0 CALENDAR.CALNUM ASSETCUST ISRUNNING 18 YORN 1 0 1 1 ASSET.ISRUNNING ASSETCUST ITEMNUM 19 UPPER 30 0 0 0 ITEM.ITEMNUM ASSETCUST UNCHARGEDCOST 20 AMOUNT 10 2 1 1 ASSET.UNCHARGEDCOST ASSETCUST TOTUNCHARGEDCOST 21 AMOUNT 10 2 1 1 ASSET.TOTUNCHARGEDCOST ASSETCUST TOTDOWNTIME 22 DURATION 8 0 1 1 ASSET.TOTDOWNTIME ASSETCUST STATUSDATE 23 DATETIME 10 0 0 1 ASSET.STATUSDATE ASSETCUST CHANGEDATE 24 DATETIME 10 0 1 1 ASSET.CHANGEDATE ASSETCUST CHANGEBY 25 UPPER 30 0 1 0 PERSON.PERSONID ASSETCUST EQ1 26 ALN 10 0 0 0 ASSET.EQ1 ASSETCUST EQ2 27 ALN 10 0 0 0 ASSET.EQ2 ASSETCUST EQ3 28 ALN 10 0 0 0 ASSET.EQ3 ASSETCUST EQ4 29 ALN 10 0 0 0 ASSET.EQ4 ASSETCUST EQ5 30 AMOUNT 10 2 0 0 ASSET.EQ5 ASSETCUST EQ6 31 DATETIME 10 0 0 0 ASSET.EQ6 ASSETCUST EQ7 32 DECIMAL 15 2 0 0 ASSET.EQ7 ASSETCUST EQ8 33 ALN 10 0 0 0 ASSET.EQ8 ASSETCUST EQ9 34 ALN 10 0 0 0 ASSET.EQ9 ASSETCUST EQ10 35 ALN 10 0 0 0 ASSET.EQ10 ASSETCUST EQ11 36 ALN 10 0 0 0 ASSET.EQ11 ASSETCUST EQ12 37 AMOUNT 10 2 0 0 ASSET.EQ12 ASSETCUST EQ23 38 DATETIME 10 0 0 0 ASSET.EQ23 ASSETCUST EQ24 39 DECIMAL 15 2 0 0 ASSET.EQ24 ASSETCUST PRIORITY 40 INTEGER 12 0 0 1 ASSET.PRIORITY ASSETCUST INVCOST 41 AMOUNT 10 2 1 1 ASSET.INVCOST ASSETCUST GLACCOUNT 42 GL 23 0 0 1
ASSETCUST SOURCESYSID 48 ALN 10 0 0 0 MXCOLLAB.OWNER1SYSID ASSETCUST OWNERSYSID 49 ALN 10 0 0 0 MXCOLLAB.OWNER1SYSID ASSETCUST EXTERNALREFID 50 ALN 10 0 0 0 ASSET.EXTERNALREFID ASSETCUST SITEID 51 UPPER 8 0 1 0 SITE.SITEID
ASSETCUST ORGID 52 UPPER 8 0 1 0 ORGANIZATION.ORGID ASSETCUST AUTOWOGEN 53 YORN 1 0 1 1 ASSET.ISRUNNING ASSETCUST ITEMSETID 54 UPPER 8 0 0 0 SETS.SETID
ASSETCUST CONDITIONCODE 66 UPPER 30 0 0 0 ITEMCONDITION.CONDITIONCODE ASSETCUST GROUPNAME 67 UPPER 10 0 0 0 METERGROUP.GROUPNAME ASSETCUST ASSETTYPE 69 ALN 15 0 0 0 ASSET.ASSETTYPE
ASSETCUST USAGE 70 ALN 15 0 0 0 ASSET.USAGE ASSETCUST STATUS 71 ALN 20 0 0 0 ASSET.STATUS ASSETCUST MAINTHIERCHY 72 YORN 1 0 1 0 ASSET.MAINTHIERCHY ASSETCUST ASSETID 73 INTEGER 12 0 1 0 ASSET.ASSETID ASSETCUST MOVED 74 YORN 1 0 1 0 ASSET.MOVED ASSETCUST ASSETUID 80 INTEGER 12 0 1 1 ASSET.ASSETUID
ASSETCUST LANGCODE 86 UPPER 4 0 1 1 LANGUAGE.MAXLANGCODE ASSETCUST TOOLRATE 87 AMOUNT 10 2 0 0 ASSET.TOOLRATE
ASSETCUST ITEMTYPE 88 UPPER 8 0 0 0 ASSET.ITEMTYPE ASSETCUST ANCESTOR 89 UPPER 12 0 0 0 ASSET.ASSETNUM ASSETCUST SENDERSYSID 93 ALN 50 0 0 1 ASSET.SENDERSYSID ASSETCUST SHIFTNUM 94 UPPER 8 0 0 0 SHIFT.SHIFTNUM ASSETCUST TOOLCONTROLACCOUNT 95 GL 23 0 0 1
ASSETCUST PERSONID 96 UPPER 30 0 1 0 PERSON.PERSONID ASSETCUST ISUSER 97 YORN 1 0 1 0 ASSETUSERCUST.ISUSER ASSETCUST ISCUSTODIAN 98 YORN 1 0 1 0 ASSETUSERCUST.ISCUSTODIAN ASSETCUST ASSETUSERCUSTID 99 INTEGER 12 0 1 1 ASSETUSERCUST.ASSETUSERCUSTID ASSETCUST ISPRIMARY 100 YORN 1 0 1 0 ASSETUSERCUST.ISPRIMARY
ASSETCUST HASLD 101 YORN 1 0 1 1
ASSETHIERARCHY ASSETNUM 1 UPPER 12 0 1 0 ASSET.ASSETNUM ASSETHIERARCHY PARENT 2 UPPER 12 0 0 0 ASSET.ASSETNUM ASSETHIERARCHY WONUM 3 UPPER 10 0 1 0 WORKORDER.WONUM ASSETHIERARCHY LOCATION 4 UPPER 12 0 0 0 LOCATIONS.LOCATION ASSETHIERARCHY SITEID 5 UPPER 8 0 1 0 SITE.SITEID
ASSETHIERARCHY ORGID 6 UPPER 8 0 1 0 ORGANIZATION.ORGID ASSETHIERARCHY ASSETHIERARCHYID 7 INTEGER 12 0 1 1
ASSETHISTORY ASSETNUM 1 UPPER 12 0 1 0 ASSET.ASSETNUM ASSETHISTORY WONUM 2 UPPER 10 0 1 0 WORKORDER.WONUM ASSETHISTORY TOTALCOST 3 AMOUNT 10 2 0 1 ASSET.TOTALCOST ASSETHISTORY YTDCOST 4 AMOUNT 10 2 0 1 ASSET.YTDCOST ASSETHISTORY TOTUNCHARGEDCOST 5 AMOUNT 10 2 0 1 ASSET.TOTUNCHARGEDCOST ASSETHISTORY BUDGETCOST 6 AMOUNT 10 2 0 1 ASSET.BUDGETCOST ASSETHISTORY SITEID 7 UPPER 8 0 1 0 SITE.SITEID
ASSETHISTORY ORGID 8 UPPER 8 0 1 0 ORGANIZATION.ORGID ASSETHISTORY ASSETHISTORYID 9 INTEGER 12 0 1 1
Table Name Column Name Col Type Length Scale Req’d? Must be Same as
ASSETLOCCOMM ASSETNUM 2 UPPER 12 0 0 0 ASSET.ASSETNUM ASSETLOCCOMM ASSETTYPE 3 ALN 15 0 0 0 ASSET.ASSETTYPE ASSETLOCCOMM LOCATION 4 UPPER 12 0 0 0 LOCATIONS.LOCATION ASSETLOCCOMM SITEID 5 UPPER 8 0 1 0 SITE.SITEID
ASSETLOCCOMM ORGID 6 UPPER 8 0 1 0 ORGANIZATION.ORGID ASSETLOCCOMM ITEMSETID 7 UPPER 8 0 0 0 SETS.SETID
ASSETLOCCOMM ASSETLOCCOMMID 8 INTEGER 12 0 1 1
ASSETLOCCOMM COMMODITYGROUP 11 UPPER 8 0 1 1 COMMODITIES.COMMODITY ASSETMETER ASSETNUM 1 UPPER 12 0 1 0 ASSET.ASSETNUM ASSETMETER METERNAME 2 UPPER 10 0 1 0 METER.METERNAME ASSETMETER ACTIVE 3 YORN 1 0 1 1
ASSETMETER MEASUREUNITID 4 UPPER 8 0 0 0 MEASUREUNIT.MEASUREUNITID ASSETMETER ROLLOVER 5 DECIMAL 15 2 0 1 METERINGROUP.ROLLOVER ASSETMETER AVGCALCMETHOD 6 UPPER 25 0 0 0
ASSETMETER SLIDINGWINDOWSIZE 7 INTEGER 12 0 0 1 ASSETMETER ROLLDOWNSOURCE 8 UPPER 10 0 0 0 ASSETMETER SINCELASTREPAIR 9 DECIMAL 15 2 1 1 ASSETMETER SINCELASTOVERHAUL 10 DECIMAL 15 2 1 1 ASSETMETER SINCELASTINSPECT 11 DECIMAL 15 2 1 1 ASSETMETER SINCEINSTALL 12 DECIMAL 15 2 1 1 ASSETMETER LIFETODATE 13 DECIMAL 15 2 1 1
ASSETMETER CHANGEBY 14 UPPER 30 0 1 0 PERSON.PERSONID ASSETMETER CHANGEDATE 15 DATETIME 10 0 1 1
ASSETMETER REMARKS 16 ALN 50 0 0 0
ASSETMETER SITEID 17 UPPER 8 0 1 0 SITE.SITEID
ASSETMETER ORGID 18 UPPER 8 0 1 0 ORGANIZATION.ORGID ASSETMETER LASTREADINGDATE 24 DATETIME 10 0 0 1 ASSETMETER.NEWREADINGDATE ASSETMETER LASTREADING 25 ALN 16 0 0 0 ASSETMETER.NEWREADING ASSETMETER POINTNUM 31 UPPER 8 0 0 0 MEASUREPOINT.POINTNUM ASSETMETER AVERAGE 32 DECIMAL 15 2 0 1
ASSETMETER READINGTYPE 33 UPPER 10 0 0 1 METER.READINGTYPE ASSETMETER LASTREADINGINSPCTR 36 UPPER 30 0 0 0 PERSON.PERSONID ASSETMETER ASSETMETERID 39 INTEGER 12 0 1 1
ASSETMETER LANGCODE 50 UPPER 4 0 1 1 LANGUAGE.MAXLANGCODE ASSETMETER HASLD 52 YORN 1 0 1 1
ASSETSPEC ASSETNUM 1 UPPER 12 0 1 0 ASSET.ASSETNUM ASSETSPEC ASSETATTRID 2 UPPER 8 0 1 0 ASSETATTRIBUTE.ASSETATTRID ASSETSPEC CLASSSTRUCTUREID 3 UPPER 20 0 1 1 CLASSSTRUCTURE.CLASSSTRUCTUREID ASSETSPEC INHERITEDFROMITEM 4 YORN 1 0 1 1
ASSETSPEC ITEMSPECVALCHANGED 5 YORN 1 0 1 1 ASSETSPEC DISPLAYSEQUENCE 6 SMALLINT 10 0 1 1
ASSETSPEC ES01 12 ALN 10 0 0 0 ASSETSPEC ES02 13 ALN 10 0 0 0 ASSETSPEC ES03 14 ALN 10 0 0 0 ASSETSPEC ES04 15 DATETIME 10 0 0 0 ASSETSPEC ES05 16 DECIMAL 15 2 0 0
ASSETSPEC SITEID 17 UPPER 8 0 1 0 SITE.SITEID
ASSETSPEC ORGID 18 UPPER 8 0 1 0 ORGANIZATION.ORGID ASSETSPEC SECTION 19 UPPER 10 0 0 0 CLASSSPEC.SECTION ASSETSPEC ASSETSPECID 20 INTEGER 12 0 1 1
ASSETSTATUS ASSETNUM 1 UPPER 12 0 1 0 ASSET.ASSETNUM ASSETSTATUS WONUM 2 UPPER 10 0 1 0 WORKORDER.WONUM ASSETSTATUS ISRUNNING 3 YORN 1 0 1 1 ASSET.ISRUNNING ASSETSTATUS CHANGEDATE 4 DATETIME 10 0 1 1
ASSETSTATUS CHANGEBY 5 UPPER 30 0 1 0 PERSON.PERSONID ASSETSTATUS DOWNTIME 6 DURATION 8 0 1 1
ASSETSTATUS CALNUM 7 UPPER 8 0 0 0 CALENDAR.CALNUM ASSETSTATUS CODE 8 UPPER 12 0 0 0
ASSETSTATUS OPERATIONAL 9 YORN 1 0 1 0
ASSETSTATUS LOCATION 10 UPPER 12 0 0 0 LOCATIONS.LOCATION ASSETSTATUS SITEID 11 UPPER 8 0 1 0 SITE.SITEID
ASSETSTATUS ORGID 12 UPPER 8 0 1 0 ORGANIZATION.ORGID ASSETSTATUS ASSETSTATUSID 13 INTEGER 12 0 1 1
ASSETTRANS ASSETNUM 1 UPPER 12 0 1 0 ASSET.ASSETNUM ASSETTRANS DATEMOVED 2 DATETIME 10 0 1 1
ASSETTRANS FROMPARENT 3 UPPER 12 0 0 0 ASSET.ASSETNUM ASSETTRANS TOPARENT 4 UPPER 12 0 0 0 ASSET.ASSETNUM ASSETTRANS FROMLOC 5 UPPER 12 0 0 0 LOCATIONS.LOCATION ASSETTRANS TOLOC 6 UPPER 12 0 0 0 LOCATIONS.LOCATION ASSETTRANS GLCREDITACCT 7 GL 23 0 0 1
ASSETTRANS GLDEBITACCT 8 GL 23 0 0 1 ASSETTRANS TRANSDATE 9 DATETIME 10 0 1 1
ASSETTRANS ENTERBY 10 UPPER 30 0 1 0 PERSON.PERSONID ASSETTRANS MEMO 11 ALN 254 0 0 0
ASSETTRANS WONUM 12 UPPER 10 0 0 0 WORKORDER.WONUM ASSETTRANS PONUM 13 UPPER 8 0 0 0 PO.PONUM
ASSETTRANS ASSETTRANSID 14 INTEGER 12 0 1 1
ASSETTRANS MATRECTRANSID 15 INTEGER 12 0 0 1 MATRECTRANS.MATRECTRANSID ASSETTRANS MATUSETRANSID 16 INTEGER 12 0 0 1 MATUSETRANS.MATUSETRANSID ASSETTRANS SOURCESYSID 17 ALN 10 0 0 0 MXCOLLAB.OWNER1SYSID ASSETTRANS OWNERSYSID 18 ALN 10 0 0 0 MXCOLLAB.OWNER1SYSID ASSETTRANS EXTERNALREFID 19 ALN 10 0 0 0
ASSETTRANS SITEID 20 UPPER 8 0 1 0 SITE.SITEID
ASSETTRANS ORGID 21 UPPER 8 0 1 0 ORGANIZATION.ORGID ASSETTRANS TOSITEID 22 UPPER 8 0 1 0 SITE.SITEID
Table Name Column Name Col Type Length Scale Req’d? Must be Same as
ASSETTRANS FROMDEPT 25 ALN 30 0 0 0 PERSON.DEPARTMENT ASSETTRANS TODEPT 26 ALN 30 0 0 0 PERSON.DEPARTMENT ASSETTRANS ASSETID 27 INTEGER 12 0 0 0 ASSET.ASSETID ASSETTRANS TOORGID 28 UPPER 8 0 0 0 ORGANIZATION.ORGID ASSETTRANS TASKID 29 INTEGER 12 0 0 1 WORKORDER.TASKID ASSETTRANS TRANSTYPE 30 UPPER 16 0 0 0
ASSETTRANS POSITEID 31 UPPER 8 0 0 0 SITE.SITEID ASSETUSERCUST ASSETNUM 1 UPPER 12 0 1 0 ASSET.ASSETNUM ASSETUSERCUST PERSONID 2 UPPER 30 0 1 0 PERSON.PERSONID ASSETUSERCUST ORGID 3 UPPER 8 0 1 0 ORGANIZATION.ORGID ASSETUSERCUST SITEID 4 UPPER 8 0 1 0 SITE.SITEID
ASSETUSERCUST ISUSER 5 YORN 1 0 1 0 ASSETUSERCUST ISCUSTODIAN 6 YORN 1 0 1 0 ASSETUSERCUST ASSETUSERCUSTID 7 INTEGER 12 0 1 1 ASSETUSERCUST ISPRIMARY 8 YORN 1 0 1 0
ASSIGNMENT WPLABORID 1 ALN 20 0 0 1 WPLABOR.WPLABORID ASSIGNMENT WONUM 2 UPPER 10 0 1 0 WORKORDER.WONUM ASSIGNMENT CRAFT 3 UPPER 8 0 0 0 CRAFT.CRAFT ASSIGNMENT LABORHRS 4 DURATION 8 0 0 1
ASSIGNMENT STATUS 5 UPPER 12 0 1 1 ASSIGNMENT SCHEDULEDATE 6 DATETIME 10 0 0 0
ASSIGNMENT LABORCODE 7 UPPER 8 0 0 0 LABOR.LABORCODE ASSIGNMENT STARTDATE 8 DATETIME 10 0 0 1
ASSIGNMENT FINISHDATE 9 DATETIME 10 0 0 1
ASSIGNMENT ORGID 10 UPPER 8 0 1 0 ORGANIZATION.ORGID ASSIGNMENT SITEID 11 UPPER 8 0 0 0 SITE.SITEID
ASSIGNMENT ASSIGNMENTID 17 INTEGER 12 0 1 1
ASSIGNMENT SKILLLEVEL 18 UPPER 12 0 0 0 CRAFTSKILL.SKILLLEVEL ASSIGNMENT CONTRACTNUM 19 UPPER 8 0 0 0 CONTRACT.CONTRACTNUM ASSIGNMENT VENDOR 20 UPPER 12 0 0 0 COMPANIES.COMPANY ATTENDANCE LABORCODE 1 UPPER 8 0 1 0 LABOR.LABORCODE ATTENDANCE STARTDATE 2 DATE 4 0 1 1
ATTENDANCE STARTTIME 3 TIME 3 0 0 1 ATTENDANCE FINISHDATE 4 DATE 4 0 0 1 ATTENDANCE FINISHTIME 5 TIME 3 0 0 1 ATTENDANCE LABORHOURS 6 DURATION 8 0 1 1 ATTENDANCE ENTERDATE 7 DATETIME 10 0 1 1 ATTENDANCE TRANSDATE 8 DATETIME 10 0 1 1
ATTENDANCE ENTERBY 9 UPPER 30 0 1 0 PERSON.PERSONID ATTENDANCE ORGID 10 UPPER 8 0 0 0 ORGANIZATION.ORGID ATTENDANCE ATTENDANCEID 11 INTEGER 12 0 1 1
AUTOATTRUPDATE OLDALNVALUE 6 ALN 25 0 0 1 ALNDOMAIN.VALUE AUTOATTRUPDATE NEWALNVALUE 7 ALN 25 0 0 1 ALNDOMAIN.VALUE AUTOATTRUPDATE OLDNUMVALUE 8 DECIMAL 10 2 0 1 NUMERICDOMAIN.VALUE AUTOATTRUPDATE NEWNUMVALUE 9 DECIMAL 10 2 0 1 NUMERICDOMAIN.VALUE AUTOATTRUPDATE COMPLETEDATETIME 10 DATETIME 10 0 0 0
AUTOATTRUPDATE COMPLETEDBY 11 UPPER 30 0 0 0 PERSON.PERSONID AUTOATTRUPDATE SITEID 12 UPPER 8 0 1 0 SITE.SITEID
AUTOATTRUPDATE ORGID 13 UPPER 8 0 1 0 ORGANIZATION.ORGID AUTOATTRUPDATE SECTION 16 UPPER 10 0 0 0 CLASSSPEC.SECTION AUTOKEY PREFIX 1 ALN 8 0 0 1
AUTOKEY SEED 2 INTEGER 12 0 1 1
AUTOKEY ORGID 3 UPPER 8 0 0 0 ORGANIZATION.ORGID AUTOKEY SITEID 4 UPPER 8 0 0 0 SITE.SITEID
AUTOKEY AUTOKEYNAME 5 UPPER 40 0 1 0
AUTOKEY SETID 6 UPPER 8 0 0 0 SETS.SETID
AUTOKEY LANGCODE 7 UPPER 4 0 1 1 LANGUAGE.MAXLANGCODE AUTOKEY AUTOKEYID 8 INTEGER 12 0 1 1
A_ASSET ANCESTOR 1 UPPER 12 0 0 0 ASSET.ASSETNUM A_ASSET ASSETID 2 INTEGER 12 0 0 0 ASSET.ASSETID A_ASSET ASSETNUM 3 UPPER 12 0 0 0 ASSET.ASSETNUM A_ASSET ASSETTAG 4 ALN 15 0 0 0 ASSET.ASSETTAG A_ASSET ASSETTYPE 5 ALN 15 0 0 0 ASSET.ASSETTYPE A_ASSET ASSETUID 6 INTEGER 12 0 0 1 ASSET.ASSETUID A_ASSET AUTOWOGEN 7 YORN 1 0 0 1 ASSET.ISRUNNING A_ASSET BINNUM 8 ALN 8 0 0 0 INVENTORY.BINNUM A_ASSET BUDGETCOST 9 AMOUNT 10 2 0 1 ASSET.BUDGETCOST A_ASSET CALNUM 10 UPPER 8 0 0 0 CALENDAR.CALNUM A_ASSET CHANGEBY 11 UPPER 30 0 0 0 PERSON.PERSONID A_ASSET CHANGEDATE 12 DATETIME 10 0 0 1 ASSET.CHANGEDATE A_ASSET CHILDREN 13 YORN 1 0 0 1 ASSET.CHILDREN
A_ASSET CLASSSTRUCTUREID 14 UPPER 20 0 0 1 CLASSSTRUCTURE.CLASSSTRUCTUREID A_ASSET CONDITIONCODE 15 UPPER 30 0 0 0 ITEMCONDITION.CONDITIONCODE A_ASSET DESCRIPTION 16 ALN 100 0 0 0 ITEM.DESCRIPTION
A_ASSET DISABLED 17 YORN 1 0 0 1 ASSET.DISABLED A_ASSET EQ1 18 ALN 10 0 0 0 ASSET.EQ1 A_ASSET EQ10 19 ALN 10 0 0 0 ASSET.EQ10 A_ASSET EQ11 20 ALN 10 0 0 0 ASSET.EQ11 A_ASSET EQ12 21 AMOUNT 10 2 0 0 ASSET.EQ12 A_ASSET EQ2 22 ALN 10 0 0 0 ASSET.EQ2 A_ASSET EQ23 23 DATETIME 10 0 0 0 ASSET.EQ23 A_ASSET EQ24 24 DECIMAL 15 2 0 0 ASSET.EQ24 A_ASSET EQ3 25 ALN 10 0 0 0 ASSET.EQ3 A_ASSET EQ4 26 ALN 10 0 0 0 ASSET.EQ4 A_ASSET EQ5 27 AMOUNT 10 2 0 0 ASSET.EQ5 A_ASSET EQ6 28 DATETIME 10 0 0 0 ASSET.EQ6
Table Name Column Name Col Type Length Scale Req’d? Must be Same as
A_ASSET EQ8 30 ALN 10 0 0 0 ASSET.EQ8 A_ASSET EQ9 31 ALN 10 0 0 0 ASSET.EQ9
A_ASSET EXTERNALREFID 32 ALN 10 0 0 0 ASSET.EXTERNALREFID A_ASSET FAILURECODE 33 UPPER 8 0 0 0 FAILURECODE.FAILURECODE A_ASSET GLACCOUNT 34 GL 23 0 0 1 ASSET.GLACCOUNT
A_ASSET GROUPNAME 35 UPPER 10 0 0 0 METERGROUP.GROUPNAME A_ASSET HASLD 36 YORN 1 0 0 1 ASSET.HASLD
A_ASSET INSTALLDATE 37 DATE 4 0 0 1 ASSET.INSTALLDATE A_ASSET INVCOST 38 AMOUNT 10 2 0 1 ASSET.INVCOST A_ASSET ISRUNNING 39 YORN 1 0 0 1 ASSET.ISRUNNING A_ASSET ITEMNUM 40 UPPER 30 0 0 0 ITEM.ITEMNUM A_ASSET ITEMSETID 41 UPPER 8 0 0 0 SETS.SETID A_ASSET ITEMTYPE 42 UPPER 8 0 0 0 ASSET.ITEMTYPE
A_ASSET LANGCODE 43 UPPER 4 0 0 1 LANGUAGE.MAXLANGCODE A_ASSET LOCATION 44 UPPER 12 0 0 0 LOCATIONS.LOCATION A_ASSET MAINTHIERCHY 45 YORN 1 0 0 0 ASSET.MAINTHIERCHY A_ASSET MANUFACTURER 46 UPPER 12 0 0 0 COMPANIES.COMPANY A_ASSET MOVED 47 YORN 1 0 0 0 ASSET.MOVED A_ASSET ORGID 48 UPPER 8 0 0 0 ORGANIZATION.ORGID A_ASSET OWNERSYSID 49 ALN 10 0 0 0 MXCOLLAB.OWNER1SYSID A_ASSET PARENT 50 UPPER 12 0 0 0 ASSET.ASSETNUM A_ASSET PRIORITY 51 INTEGER 12 0 0 1 ASSET.PRIORITY A_ASSET PURCHASEPRICE 52 AMOUNT 10 2 0 1 ASSET.PURCHASEPRICE A_ASSET REPLACECOST 53 AMOUNT 10 2 0 1 ASSET.REPLACECOST A_ASSET ROTSUSPACCT 54 GL 23 0 0 1 ASSET.ROTSUSPACCT A_ASSET SENDERSYSID 55 ALN 50 0 0 1 ASSET.SENDERSYSID A_ASSET SERIALNUM 56 UPPER 15 0 0 0 ASSET.SERIALNUM A_ASSET SHIFTNUM 57 UPPER 8 0 0 0 SHIFT.SHIFTNUM A_ASSET SITEID 58 UPPER 8 0 0 0 SITE.SITEID
A_ASSET SOURCESYSID 59 ALN 10 0 0 0 MXCOLLAB.OWNER1SYSID A_ASSET STATUS 60 ALN 20 0 0 0 ASSET.STATUS
A_ASSET STATUSDATE 61 DATETIME 10 0 0 1 ASSET.STATUSDATE
A_ASSET TOOLCONTROLACCOUNT 62 GL 23 0 0 1 ASSET.TOOLCONTROLACCOUNT A_ASSET TOOLRATE 63 AMOUNT 10 2 0 0 ASSET.TOOLRATE
A_ASSET TOTALCOST 64 AMOUNT 10 2 0 1 ASSET.TOTALCOST A_ASSET TOTDOWNTIME 65 DURATION 8 0 0 1 ASSET.TOTDOWNTIME A_ASSET TOTUNCHARGEDCOST 66 AMOUNT 10 2 0 1 ASSET.TOTUNCHARGEDCOST A_ASSET UNCHARGEDCOST 67 AMOUNT 10 2 0 1 ASSET.UNCHARGEDCOST A_ASSET USAGE 68 ALN 15 0 0 0 ASSET.USAGE
A_ASSET VENDOR 69 UPPER 12 0 0 0 COMPANIES.COMPANY A_ASSET WARRANTYEXPDATE 70 DATE 4 0 0 1 ASSET.WARRANTYEXPDATE
A_ASSET ESIGTRANSID 76 ALN 40 0 0 1
A_JOBTASK DESCRIPTION 1 ALN 100 0 0 0 JOBTASK.DESCRIPTION A_JOBTASK JO1 2 ALN 10 0 0 0 JOBTASK.JO1 A_JOBTASK JO2 3 ALN 10 0 0 0 JOBTASK.JO2 A_JOBTASK JO3 4 ALN 10 0 0 0 JOBTASK.JO3 A_JOBTASK JO4 5 DECIMAL 15 2 0 0 JOBTASK.JO4 A_JOBTASK JO5 6 ALN 10 0 0 0 JOBTASK.JO5 A_JOBTASK JO6 7 ALN 10 0 0 0 JOBTASK.JO6 A_JOBTASK JO7 8 ALN 10 0 0 0 JOBTASK.JO7 A_JOBTASK JO8 9 ALN 10 0 0 0 JOBTASK.JO8 A_JOBTASK JOBPLANID 10 INTEGER 12 0 0 1 JOBPLAN.JOBPLANID A_JOBTASK JOBTASKID 11 INTEGER 12 0 0 1 JOBTASK.JOBTASKID A_JOBTASK JPNUM 12 UPPER 10 0 0 0 JOBPLAN.JPNUM A_JOBTASK JPTASK 13 INTEGER 12 0 0 1 WORKORDER.TASKID A_JOBTASK LANGCODE 14 UPPER 4 0 0 1 LANGUAGE.MAXLANGCODE A_JOBTASK METERNAME 15 UPPER 10 0 0 0 METER.METERNAME A_JOBTASK ORGID 19 UPPER 8 0 0 0 ORGANIZATION.ORGID A_JOBTASK SITEID 20 UPPER 8 0 0 0 SITE.SITEID
A_JOBTASK TASKDURATION 21 DURATION 8 0 0 1 JOBTASK.TASKDURATION A_JOBTASK TASKSEQUENCE 22 INTEGER 12 0 0 1 WORKORDER.WOSEQUENCE A_JOBTASK EAUDITUSERNAME 23 UPPER 18 0 1 1
A_JOBTASK EAUDITTIMESTAMP 24 DATETIME 10 0 1 1 A_JOBTASK EAUDITTYPE 25 UPPER 1 0 1 1 A_JOBTASK EAUDITTRANSID 26 ALN 40 0 1 1 A_JOBTASK ESIGTRANSID 27 ALN 40 0 0 1
A_JOBTASK HASLD 28 YORN 1 0 0 1 JOBTASK.HASLD A_LONGDESCRIPTION LDKEY 1 INTEGER 12 0 0 1 LONGDESCRIPTION.LDKEY A_LONGDESCRIPTION LDOWNERTABLE 2 UPPER 18 0 0 1 MAXOBJECT.OBJECTNAME A_LONGDESCRIPTION LDOWNERCOL 3 UPPER 18 0 0 1 MAXOBJECT.OBJECTNAME A_LONGDESCRIPTION LDTEXT 4 CLOB 32000 0 0 1 LONGDESCRIPTION.LDTEXT A_LONGDESCRIPTION EAUDITUSERNAME 5 UPPER 18 0 1 1
A_LONGDESCRIPTION EAUDITTIMESTAMP 6 DATETIME 10 0 1 1 A_LONGDESCRIPTION EAUDITTYPE 7 UPPER 1 0 1 1 A_LONGDESCRIPTION EAUDITTRANSID 8 ALN 40 0 1 1 A_LONGDESCRIPTION ESIGTRANSID 9 ALN 40 0 0 1
A_LONGDESCRIPTION LANGCODE 10 UPPER 4 0 0 1 LANGUAGE.MAXLANGCODE
A_LONGDESCRIPTION LONGDESCRIPTIONID 11 INTEGER 12 0 1 1 LONGDESCRIPTION.LONGDESCRIPTIONID A_PM ADJNEXTDUE 1 YORN 1 0 0 1 PM.ADJNEXTDUE A_PM ALERTLEAD 2 INTEGER 12 0 0 1 PM.LEADTIME A_PM ASSETNUM 3 UPPER 12 0 0 0 ASSET.ASSETNUM A_PM CALENDAR 4 UPPER 8 0 0 0 CALENDAR.CALNUM A_PM CHANGEBY 5 UPPER 30 0 0 0 PERSON.PERSONID A_PM CHANGEDATE 6 DATETIME 10 0 0 1 PM.CHANGEDATE A_PM CREWID 7 ALN 12 0 0 1 LABOR.CREWID
Table Name Column Name Col Type Length Scale Req’d? Must be Same as
A_PM EXTDATE 10 DATE 4 0 0 1 PM.EXTDATE A_PM FIRSTDATE 11 DATE 4 0 0 1 PM.FIRSTDATE A_PM FREQUENCY 12 INTEGER 12 0 0 1 PM.FREQUENCY A_PM FREQUNIT 13 UPPER 8 0 0 0 PM.FREQUNIT A_PM FRIDAY 14 YORN 1 0 0 1 PM.FRIDAY A_PM GLACCOUNT 15 GL 23 0 0 1
A_PM HASCHILDREN 16 YORN 1 0 0 1 PM.HASCHILDREN A_PM INTERRUPTIBLE 17 YORN 1 0 0 1 PM.INTERRUPTIBLE A_PM JPNUM 18 UPPER 10 0 0 0 JOBPLAN.JPNUM A_PM JPSEQINUSE 19 YORN 1 0 0 1 PM.JPSEQINUSE
A_PM LANGCODE 20 UPPER 4 0 0 1 LANGUAGE.MAXLANGCODE A_PM LASTCOMPDATE 21 DATE 4 0 0 1 PM.LASTCOMPDATE A_PM LASTSTARTDATE 22 DATE 4 0 0 1 PM.LASTSTARTDATE A_PM LEAD 23 UPPER 30 0 0 0 PERSON.PERSONID A_PM LEADTIME 24 INTEGER 12 0 0 1 PM.LEADTIME
A_PM LOCATION 25 UPPER 12 0 0 0 LOCATIONS.LOCATION A_PM MASTERPM 26 UPPER 8 0 0 0 PM.PMNUM
A_PM MONDAY 27 YORN 1 0 0 1 PM.MONDAY A_PM NEXTDATE 28 DATE 4 0 0 1 PM.NEXTDATE A_PM ORGID 29 UPPER 8 0 0 0 ORGANIZATION.ORGID A_PM OVERRIDEMASTERUPD 30 YORN 1 0 0 1 PM.OVERRIDEMASTERUPD A_PM OWNER 31 UPPER 30 0 0 0 PERSON.PERSONID
A_PM OWNERGROUP 32 UPPER 8 0 0 0 PERSONGROUP.PERSONGROUP A_PM PARENT 33 UPPER 8 0 0 0 PM.PMNUM
A_PM PARENTCHGSSTATUS 34 YORN 1 0 0 0 PM.PARENTCHGSSTATUS A_PM PERSONGROUP 35 UPPER 8 0 0 0 PERSONGROUP.PERSONGROUP A_PM PMACTMETER 36 YORN 1 0 0 1 PM.USEFREQUENCY
A_PM PMASSETWOGEN 37 YORN 1 0 0 1 PM.USEFREQUENCY A_PM PMCOUNTER 38 INTEGER 12 0 0 1 PM.PMCOUNTER A_PM PMEQ1 39 ALN 10 0 0 0 ASSET.EQ9 A_PM PMEQ2 40 DATETIME 10 0 0 0 ASSET.EQ23 A_PM PMEQ3 41 DECIMAL 15 2 0 0 ASSET.EQ24 A_PM PMNUM 42 UPPER 8 0 0 0 PM.PMNUM A_PM PMUID 43 INTEGER 12 0 0 1 PM.PMUID A_PM PRIORITY 44 INTEGER 12 0 0 1 PM.PRIORITY A_PM ROUTE 45 UPPER 8 0 0 0 ROUTES.ROUTE A_PM SATURDAY 46 YORN 1 0 0 1 PM.SATURDAY A_PM SITEID 47 UPPER 8 0 0 0 SITE.SITEID A_PM STATUS 48 UPPER 20 0 0 0 PM.STATUS
A_PM STORELOC 49 UPPER 12 0 0 0 LOCATIONS.LOCATION A_PM STORELOCSITE 50 UPPER 8 0 0 0 SITE.SITEID
A_PM USETARGETDATE 56 YORN 1 0 0 1 PM.USETARGETDATE A_PM WEDNESDAY 57 YORN 1 0 0 1 PM.WEDNESDAY A_PM WORKTYPE 58 UPPER 5 0 0 0 WORKTYPE.WORKTYPE A_PM WOSEQUENCE 59 INTEGER 12 0 0 1 WORKORDER.WOSEQUENCE
A_PM WOSTATUS 60 UPPER 16 0 0 1 WORKORDER.STATUS A_PM EAUDITUSERNAME 61 UPPER 18 0 1 1
A_PM EAUDITTIMESTAMP 62 DATETIME 10 0 1 1 A_PM EAUDITTYPE 63 UPPER 1 0 1 1 A_PM EAUDITTRANSID 64 ALN 40 0 1 1 A_PM ESIGTRANSID 65 ALN 40 0 0 1
A_PM HASLD 66 YORN 1 0 0 1 PM.HASLD BBOARDAUDIENCE BULLETINBOARDID 1 UPPER 10 0 1 0
BBOARDAUDIENCE MSGORGID 2 UPPER 8 0 0 0 ORGANIZATION.ORGID BBOARDAUDIENCE MSGSITEID 3 UPPER 8 0 0 0 SITE.SITEID
BBOARDAUDIENCE BBOARDAUDIENCEID 4 INTEGER 12 0 1 1
BBOARDAUDIENCE PERSONGROUP 5 UPPER 8 0 0 0 PERSONGROUP.PERSONGROUP BOOKMARK APP 1 UPPER 10 0 1 1 MAXAPPS.APP
BOOKMARK KEYVALUE 2 INTEGER 12 0 1 1 BOOKMARK ENTERDATE 3 DATETIME 10 0 1 0
BOOKMARK USERID 4 UPPER 30 0 1 0 PERSON.PERSONID BOOKMARK BOOKMARKID 6 INTEGER 12 0 1 1
BULLETINBOARD BULLETINBOARDID 1 UPPER 10 0 1 0 BULLETINBOARD SUBJECT 2 ALN 200 0 1 0 BULLETINBOARD MESSAGE 3 ALN 4000 0 0 0 BULLETINBOARD POSTBY 4 UPPER 18 0 1 1 BULLETINBOARD POSTDATE 5 DATETIME 10 0 1 1 BULLETINBOARD EXPIREDATE 6 DATETIME 10 0 1 1 BULLETINBOARD BULLETINBOARDUID 7 INTEGER 12 0 1 1 CALENDAR CALNUM 1 UPPER 8 0 1 0 CALENDAR DESCRIPTION 2 ALN 100 0 0 0 CALENDAR STARTDATE 3 DATE 4 0 1 1 CALENDAR ENDDATE 4 DATE 4 0 1 1
CALENDAR ORGID 5 UPPER 8 0 1 0 ORGANIZATION.ORGID CALENDAR CALENDARID 7 INTEGER 12 0 1 1
CALENDAR LANGCODE 8 UPPER 4 0 1 1 LANGUAGE.MAXLANGCODE CALENDAR HASLD 9 YORN 1 0 1 1
CHARPOINTACTION POINTNUM 1 UPPER 8 0 1 0 MEASUREPOINT.POINTNUM CHARPOINTACTION VALUE 2 ALN 25 0 1 1 ALNDOMAIN.VALUE CHARPOINTACTION PMNUM 3 UPPER 8 0 0 0 PM.PMNUM CHARPOINTACTION JPNUM 4 UPPER 10 0 0 0 JOBPLAN.JPNUM CHARPOINTACTION PRIORITY 5 INTEGER 12 0 0 1
CHARPOINTACTION SITEID 6 UPPER 8 0 1 0 SITE.SITEID
CHARPOINTACTION ORGID 7 UPPER 8 0 1 0 ORGANIZATION.ORGID CHARPOINTACTION CHARPOINTACTIONID 11 INTEGER 12 0 1 1
Table Name Column Name Col Type Length Scale Req’d? Must be Same as
CHARTOFACCOUNTS GLCOMP02 3 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP03 4 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP04 5 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP05 6 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP06 7 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP07 8 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP08 9 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP09 10 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP10 11 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP11 12 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP12 13 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP13 14 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP14 15 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP15 16 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP16 17 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP17 18 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP18 19 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP19 20 ALN 20 0 0 1 CHARTOFACCOUNTS GLCOMP20 21 ALN 20 0 0 1 CHARTOFACCOUNTS ACCOUNTNAME 22 ALN 100 0 0 0 CHARTOFACCOUNTS GLACCTYPE 23 ALN 3 0 0 0
CHARTOFACCOUNTS SOURCESYSID 24 ALN 10 0 0 0 MXCOLLAB.OWNER1SYSID CHARTOFACCOUNTS OWNERSYSID 25 ALN 10 0 0 0 MXCOLLAB.OWNER1SYSID CHARTOFACCOUNTS EXTERNALREFID 26 ALN 10 0 0 0
CHARTOFACCOUNTS SENDERSYSID 27 ALN 50 0 0 0
CHARTOFACCOUNTS ORGID 28 UPPER 8 0 1 0 ORGANIZATION.ORGID CHARTOFACCOUNTS ACTIVE 29 YORN 1 0 1 1
CHARTOFACCOUNTS CHARTOFACCOUNTSID 31 INTEGER 12 0 1 1
CHARTOFACCOUNTS LANGCODE 32 UPPER 4 0 1 1 LANGUAGE.MAXLANGCODE CHARTOFACCOUNTS HASLD 33 YORN 1 0 1 1
CLASSANCESTOR CLASSANCESTORID 1 INTEGER 12 0 1 1
CLASSANCESTOR CLASSSTRUCTUREID 2 UPPER 20 0 0 1 CLASSSTRUCTURE.CLASSSTRUCTUREID CLASSANCESTOR CLASSIFICATIONID 3 UPPER 8 0 0 0 CLASSIFICATION.CLASSIFICATIONID CLASSANCESTOR ANCESTOR 4 UPPER 20 0 0 1 CLASSSTRUCTURE.CLASSSTRUCTUREID CLASSANCESTOR ANCESTORCLASSID 5 UPPER 8 0 0 0 CLASSIFICATION.CLASSIFICATIONID CLASSANCESTOR HIERARCHYLEVELS 6 INTEGER 12 0 0 0
CLASSANCESTOR ORGID 7 UPPER 8 0 0 0 ORGANIZATION.ORGID CLASSANCESTOR SITEID 8 UPPER 8 0 0 0 SITE.SITEID
CLASSIFICATION CLASSIFICATIONID 1 UPPER 8 0 1 0 CLASSIFICATION DESCRIPTION 2 ALN 100 0 0 0
CLASSSPEC DOMAINID 4 UPPER 18 0 0 1 MAXDOMAIN.DOMAINID CLASSSPEC DEFAULTNUMVALUE 5 DECIMAL 10 2 0 1 NUMERICDOMAIN.VALUE CLASSSPEC DEFAULTALNVALUE 6 ALN 25 0 0 1 ALNDOMAIN.VALUE
CLASSSPEC ATTRDESCPREFIX 7 ALN 8 0 0 0 ASSETATTRIBUTE.ATTRDESCPREFIX CLASSSPEC USEINITEMSPEC 8 YORN 1 0 1 1
CLASSSPEC ITEMSEQUENCE 9 SMALLINT 10 0 1 1 CLASSSPEC ITEMREQUIREVALUE 10 YORN 1 0 1 1 CLASSSPEC USEINITEMDESC 11 YORN 1 0 1 1 CLASSSPEC USEINASSETSPEC 12 YORN 1 0 1 1 CLASSSPEC ASSETSEQUENCE 13 SMALLINT 10 0 1 1 CLASSSPEC ASSETREQUIREVALUE 14 YORN 1 0 1 1 CLASSSPEC USEINASSETDESC 15 YORN 1 0 1 1 CLASSSPEC USEINLOCSPEC 16 YORN 1 0 1 1 CLASSSPEC LOCSEQUENCE 17 SMALLINT 10 0 1 1 CLASSSPEC LOCREQUIREVALUE 18 YORN 1 0 1 1 CLASSSPEC USEINLOCDESC 19 YORN 1 0 1 1 CLASSSPEC CS01 20 ALN 10 0 0 0 CLASSSPEC CS02 21 ALN 10 0 0 0 CLASSSPEC CS03 22 ALN 10 0 0 0 CLASSSPEC CS04 23 DATETIME 10 0 0 0 CLASSSPEC CS05 24 DECIMAL 15 2 0 0
CLASSSPEC ORGID 25 UPPER 8 0 0 0 ORGANIZATION.ORGID CLASSSPEC SECTION 28 UPPER 10 0 0 0
CLASSSPEC SITEID 29 UPPER 8 0 0 0 SITE.SITEID CLASSSPEC CLASSSPECID 30 INTEGER 12 0 1 1
CLASSSTRUCTURE CLASSSTRUCTUREID 1 UPPER 20 0 1 1 CLASSSTRUCTURE DESCRIPTION 2 ALN 100 0 0 0 CLASSSTRUCTURE GENASSETDESC 3 YORN 1 0 1 1
CLASSSTRUCTURE ORGID 4 UPPER 8 0 0 0 ORGANIZATION.ORGID
CLASSSTRUCTURE PARENT 6 UPPER 20 0 0 1 CLASSSTRUCTURE.CLASSSTRUCTUREID CLASSSTRUCTURE CLASSIFICATIONID 7 UPPER 8 0 1 0 CLASSIFICATION.CLASSIFICATIONID CLASSSTRUCTURE USECLASSINDESC 8 YORN 1 0 1 0
CLASSSTRUCTURE TYPE 9 UPPER 10 0 0 0 CLASSSTRUCTURE USEWITHASSETS 10 YORN 1 0 1 0 CLASSSTRUCTURE USEWITHLOCATIONS 11 YORN 1 0 1 0 CLASSSTRUCTURE USEWITHITEMS 12 YORN 1 0 1 0 CLASSSTRUCTURE USEWITHWORKORDERS 13 YORN 1 0 1 0 CLASSSTRUCTURE USEWITHCHANGES 14 YORN 1 0 1 0 CLASSSTRUCTURE USEWITHRELEASES 15 YORN 1 0 1 0 CLASSSTRUCTURE USEWITHACTIVITIES 16 YORN 1 0 1 0 CLASSSTRUCTURE USEWITHSERVREQS 17 YORN 1 0 1 0 CLASSSTRUCTURE USEWITHINCIDENTS 18 YORN 1 0 1 0 CLASSSTRUCTURE USEWITHPROBLEMS 19 YORN 1 0 1 0 CLASSSTRUCTURE USEWITHFAILURES 20 YORN 1 0 1 0
Table Name Column Name Col Type Length Scale Req’d? Must be Same as
CLASSSTRUCTURE HASCHILDREN 24 YORN 1 0 1 0
CLASSSTRUCTURE LANGCODE 28 UPPER 4 0 1 1 LANGUAGE.MAXLANGCODE