MAXIMO技术参考—数据库结构

MAXIMO

4星 · 超过85%的资源需积分: 50 51 浏览量更新于2023-07-24 评论 3 收藏 642KB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

2-1

CHAPTER 2

TABLES AND COLUMNS FOR MAXIMO RELEASE 5.2

This chapter lists the tables and columns in the MAXIMO Release 5.2 database, including basic column definition

information.

At the end of this chapter there are three additional sections relating to database function:

• Nonpersistent Tables

• MAXIMO Database Triggers

• MAXIMO Database Sequences

Table/Column Information

NOTE: Each table has an additional column, ROWSTAMP, which the application populates automatically.

ACCOUNTDEFAULTS

Column Name Col Type Length Scale Null? Must be Same As

DFLTGROUP 1 UPPER 20 0 N Y

GROUPVALUE 2 UPPER 50 0 N Y

GLDEFAULT 3 ALN 20 0 Y Y CHARTOFACCOUNTS.GLACCOUNT

OLDGLDEFAULT 4 ALN 20 0 Y Y CHARTOFACCOUNTS.GLACCOUNT

ORGID 5 UPPER 8 0 N N ORGANIZATION.ORGID

ADDRESS

Column Name Col Type Length Scale Null? Must be Same As

ORGID 1 UPPER 8 0 N N ORGANIZATION.ORGID

ADDRESSCODE 2 UPPER 12 0 N N

DESCRIPTION 3 ALN 50 0 Y N

ADDRESS1 4 ALN 36 0 Y N

ADDRESS2 5 ALN 36 0 Y N

ADDRESS3 6 ALN 36 0 Y N

ADDRESS4 7 ALN 36 0 Y N

ADDRESS5 8 ALN 36 0 Y N

LDKEY 9 INTEGER 4 0 Y Y

CHANGEBY 10 UPPER 18 0 Y Y MAXGROUPS.GRPNAME

CHANGEDATE 11 DATETIME 10 0 N N

ALNDOMAINVALUE

Column Name Col Type Length Scale Null? Must be Same As

DOMAINID 1 UPPER 18 0 N Y MAXDOMAIN.DOMAINID

ALNVALUE 2 ALN 16 0 Y N

DESCRIPTION 3 ALN 30 0 Y N

ALTITEM

MAXIMO Database Columns

2-2

Column Name Col Type Length Scale Null? Must be Same As

ITEMNUM 1 UPPER 30 0 N N ITEM.ITEMNUM

ALTITEMNUM 2 UPPER 30 0 N N ITEM.ITEMNUM

ORGID 3 UPPER 8 0 N N ORGANIZATION.ORGID

APPDOCTYPE

Column Name Col Type Length Scale Null? Must be Same As

APP 1 UPPER 10 0 N Y MAXAPPS.APP

DOCTYPE 2 ALN 15 0 N N DOCTYPES.DOCTYPE

SITEID 3 UPPER 8 0 N N SITE.SITEID

ORGID 4 UPPER 8 0 N N ORGANIZATION.ORGID

APPFIELDDEFAULTS

Column Name Col Type Length Scale Null? Must be Same As

APP 1 UPPER 10 0 N Y MAXAPPS.APP

TBNAME 2 UPPER 18 0 N Y MAXTABLES.TBNAME

COLNAME 3 UPPER 18 0 N Y MAXSYSCOLUMNS.NAME

SITEID 4 UPPER 8 0 N N SITE.SITEID

GRPNAME 5 UPPER 18 0 Y Y MAXGROUPS.GRPNAME

USERNAME 6 UPPER 18 0 Y Y MAXGROUPS.GRPNAME

DEFAULTVALUE 7 ALN 50 0 Y N

APPLAUNCH

Column Name Col Type Length Scale Null? Must be Same As

LAUNCHINGAPP 1 UPPER 10 0 N Y MAXAPPS.APP

LAUNCHINGITEM 2 ALN 32 0 N Y

LAUNCHINGDATAFIELD 3 ALN 32 0 Y Y

LAUNCHINGTYPE 4 UPPER 1 0 N Y

LAUNCHEDAPP 5 ALN 128 0 N Y

LAUNCHEDDATAFIELD 6 ALN 32 0 Y Y

LAUNCHEDTYPE 7 UPPER 1 0 N Y

LAUNCHPARAMETERS 8 ALN 124 0 Y Y

LAUNCHINGPARENT 9 UPPER 10 0 N Y MAXSCREENS.SCREEN

LDKEY 10 INTEGER 4 0 Y Y

APPROVALLIMIT

Column Name Col Type Length Scale Null? Must be Same As

ORGID 1 UPPER 8 0 N N ORGANIZATION.ORGID

GRPNAME 2 UPPER 18 0 N Y MAXGROUPS.GRPNAME

POLIMIT 3 DECIMAL 8 0 Y Y

PRLIMIT 4 DECIMAL 8 0 Y Y

INVOICELIMIT 5 DECIMAL 8 0 Y Y

MRLIMIT 6 DECIMAL 8 0 Y N

ARCHIVE

Column Name Col Type Length Scale Null? Must be Same As

ARCHIVEDATE 1 DATETIME 10 0 N Y

MODULE 2 UPPER 30 0 N Y

TYPE 3 ALN 8 0 Y Y

PATH 4 ALN 63 0 Y Y

ARCHSCRIPT 5 ALN 12 0 Y Y

RESTSCRIPT 6 ALN 12 0 Y Y

VIEWSQL 7 ALN 254 0 Y Y

SITEID 8 UPPER 8 0 Y N SITE.SITEID

ORGID 9 UPPER 8 0 Y N ORGANIZATION.ORGID

MAXIMO Database Columns

2-5

GLCOMP01 2 ALN 20 0 Y Y

GLCOMP02 3 ALN 20 0 Y Y

GLCOMP03 4 ALN 20 0 Y Y

GLCOMP04 5 ALN 20 0 Y Y

GLCOMP05 6 ALN 20 0 Y Y

GLCOMP06 7 ALN 20 0 Y Y

GLCOMP07 8 ALN 20 0 Y Y

GLCOMP08 9 ALN 20 0 Y Y

GLCOMP09 10 ALN 20 0 Y Y

GLCOMP10 11 ALN 20 0 Y Y

GLCOMP11 12 ALN 20 0 Y Y

GLCOMP12 13 ALN 20 0 Y Y

GLCOMP13 14 ALN 20 0 Y Y

GLCOMP14 15 ALN 20 0 Y Y

GLCOMP15 16 ALN 20 0 Y Y

GLCOMP16 17 ALN 20 0 Y Y

GLCOMP17 18 ALN 20 0 Y Y

GLCOMP18 19 ALN 20 0 Y Y

GLCOMP19 20 ALN 20 0 Y Y

GLCOMP20 21 ALN 20 0 Y Y

ACCOUNTNAME 22 ALN 50 0 Y N

GLACCTYPE 23 ALN 3 0 Y N

CH1 24 ALN 10 0 Y N

CH2 25 ALN 10 0 Y N

CH3 26 ALN 10 0 Y N

CH4 27 DECIMAL 15 2 Y N

CH5 28 INTEGER 4 0 Y N

DISABLED 29 YORN 1 0 N Y

LDKEY 30 INTEGER 4 0 Y Y

SOURCESYSID 31 ALN 10 0 Y N MXCOLLAB.OWNER1SYSID

OWNERSYSID 32 ALN 10 0 Y N MXCOLLAB.OWNER1SYSID

EXTERNALREFID 33 ALN 10 0 Y N

APISEQ 34 ALN 50 0 Y N

INTERID 35 ALN 50 0 Y N

MIGCHANGEID 36 ALN 50 0 Y N

SENDERSYSID 37 ALN 50 0 Y N

ORGID 38 UPPER 8 0 N N ORGANIZATION.ORGID

CLASSSPEC

Column Name Col Type Length Scale Null? Must be Same As

CLASSSTRUCTUREID 1 UPPER 20 0 N Y CLASSSTRUCTURE.CLASSSTRUCTUREID

ASSETATTRID 2 UPPER 8 0 N N ASSETATTRIBUTE.ASSETATTRID

MEASUREUNITID 3 UPPER 8 0 Y N MEASUREUNIT.MEASUREUNITID

DOMAINID 4 UPPER 18 0 Y Y MAXDOMAIN.DOMAINID

DEFAULTNUMVALUE 5 DECIMAL 10 2 Y Y NUMDOMAINVALUE.NUMVALUE

DEFAULTALNVALUE 6 ALN 16 0 Y N ALNDOMAINVALUE.ALNVALUE

ATTRDESCPREFIX 7 ALN 8 0 Y N ASSETATTRIBUTE.ATTRDESCPREFIX

USEINITEMSPEC 8 YORN 1 0 N Y

ITEMSEQUENCE 9 SMALLINT 2 0 N Y

ITEMREQUIREVALUE 10 YORN 1 0 N Y

USEINITEMDESC 11 YORN 1 0 N Y

USEINEQSPEC 12 YORN 1 0 N Y

EQSEQUENCE 13 SMALLINT 2 0 N Y

EQREQUIREVALUE 14 YORN 1 0 N Y

USEINEQDESC 15 YORN 1 0 N Y

剩余96页未读，继续阅读

strawberry_wine

2014-04-28

很好，有用。。但有点旧了。

freebell2008

粉丝: 0
资源: 9

会员权益专享

MAXIMO技术参考—数据库结构

评论4

会员权益专享

最新资源

MAXIMO技术参考—数据库结构

评论4

maximo系统表

IBM maximo 系统架构和技术概述

maximo7.1安装及数据库建表SQL命令

maximo数据库配置

maximo 7.1管理员指南(中文)

maximo 7.6用户手册

maximo 跳转新建某个应用

Maximo工作流设计知识

maximo用户手册

maximo自动编号

maximo系统开发

maximo数据集成

能制作工厂数字孪生的软件有哪些

maximo体系架构

MAXIMO技术参考—数据库索引

IBMMAXIMO系统架构和技术概述.pdf

毕业设计基于STC12C5A、SIM800C、GPS的汽车防盗报警系统源码.zip

基于tensorflow2.x卷积神经网络字符型验证码识别.zip

【三维装箱】遗传和模拟退火算法求解三维装箱优化问题【含Matlab源码 031期】.zip

自己编写的python 程序计算cpk/ppk

会员权益专享

最新资源