Object Main

Table

• Table-Name: aobjmt

Fields

--> Key fields Main, Group, Type
OBJMID  Key decimal(15,0)
OBJGID  Object Group Key decimal(15,0)
OBJTID  Object Type Key decimal(15,0)

--> varchar 100 
OBJTX1  varchar(100) --> Business key that is used in Combo-Boxes, Object Relations ...
OBJTX2  varchar(100)
OBJTX3  varchar(100)
OBJTX4  varchar(100)
OBJTX5  varchar(100)
OBJTX6  varchar(100)
OBJTX7  varchar(100)
OBJTX8  varchar(100)
OBJTX9  varchar(100)
OBJTXA  varchar(100)
OBJTXB  varchar(100)
OBJTXC  varchar(100)
OBJTXD  varchar(100)
OBJTXE  varchar(100)
OBJTXF  varchar(100)

--> varchar 1000
OBJ1T1  varchar(1000)
OBJ1T2  varchar(1000)
OBJ1T3  varchar(1000)
OBJ1T4  varchar(1000)
OBJ1T5  varchar(1000)
OBJ1T6  varchar(1000)
OBJ1T7  varchar(1000)
OBJ1T8  varchar(1000)
OBJ1T9  varchar(1000)
OBJ1TA  varchar(1000)

--> varchar 4000
OBJ4T1  varchar(4000)
OBJ4T2  varchar(4000)
OBJ4T3  varchar(4000)
OBJ4T4  varchar(4000)
OBJ4T5  varchar(4000)

--> Time
OBJTI1  time
OBJTI2  time
OBJTI3  time
OBJTI4  time

--> ISO Date
OBJD01  date
OBJD02  date
OBJD03  date
OBJD04  date
OBJD05  date
OBJD06  date
OBJD07  date
OBJD08  date

--> Int 4
OBJIN1  decimal(4,0)
OBJIN2  decimal(4,0)
OBJIN3  decimal(4,0)
OBJIN4  decimal(4,0)
OBJIN5  decimal(4,0)
OBJIN6  decimal(4,0)
OBJIN7  decimal(4,0)
OBJIN8  decimal(4,0)
OBJIN9  decimal(4,0)
OBJINA  decimal(4,0)

--> Double 15.2
OBJN21  double (15,2)
OBJN22  double (15,2)
OBJN23  double (15,2)
OBJN24  double (15,2)
OBJN25  double (15,2)
OBJN26  double (15,2)
OBJN27  double (15,2)
OBJN28  double (15,2) --> Contains the average rating value if you use the Object Memo-Rating field.

--> Double 15.5
OBJN51  double (15,5)
OBJN52  double (15,5)
OBJN53  double (15,5)
OBJN54  double (15,5)
OBJN55  double (15,5)
OBJN56  double (15,5)
OBJN57  double (15,5)
OBJN58  double (15,5)

--> Free ForeignKey fields
OBJKE1  ForeignKey decimal(15,0)
OBJKE2  ForeignKey decimal(15,0)
OBJKE3  ForeignKey decimal(15,0)
OBJKE4  ForeignKey decimal(15,0)
OBJKE5  ForeignKey decimal(15,0)

--> Status fields 1
OBJS11  Status char(1)
OBJS12  Status char(1)
OBJS13  Status char(1)
OBJS14  Status char(1)
OBJS15  Status char(1)
OBJS16  Status char(1)
OBJS17  Status char(1)
OBJS18  Status char(1)
OBJS19  Status char(1)
OBJS1A  Status char(1)
OBJS1B  Status char(1)
OBJS1C  Status char(1)
OBJS1D  Status char(1)
OBJS1E  Status char(1)
OBJS1F  Status char(1)

--> Status fields 15
OBJS51  Status char(15)
OBJS52  Status char(15)
OBJS53  Status char(15)
OBJS54  Status char(15)
OBJS55  Status char(15)
OBJS56  Status char(15)
OBJS57  Status char(15)
OBJS58  Status char(15)
OBJS59  Status char(15)
OBJS5A  Status char(15) --> Customized Counter (Year/month etc.) is Object Parameter STS15 IS NUMBER = 1 

--> Reference to ObjectMain
OBJRM1  OBJReference decimal(15,0)
OBJRT1  OBJReference decimal(15,0)
OBJRM2  OBJReference decimal(15,0)
OBJRT2  OBJReference decimal(15,0)
OBJRM3  OBJReference decimal(15,0)
OBJRT3  OBJReference decimal(15,0)
OBJRM4  OBJReference decimal(15,0)
OBJRT4  OBJReference decimal(15,0)
OBJRM5  OBJReference decimal(15,0)
OBJRT5  OBJReference decimal(15,0)
OBJRM6  OBJReference decimal(15,0)
OBJRT6  OBJReference decimal(15,0)
OBJRID  OBJReference decimal(15,0)

--> Default fields
UsrAdd  char(15)
DatAdd  datetime
SysAdd  char(15)
UsrChg  char(15)
DatChg  datetime
SysChg  char(15)
UsrDel  char(15)
DatDel  datetime
SysDel  char(15)
STHash  char(20)
RecSts  char(1) --> L=Locked is used for new/not jet saved records and is generally excluded in FindBrowse, Combo-Boxes...
SOwner  char(15)
STDSof  char(15)
STDEnt  char(5)
STDShp  char(15)
STDSec  char(15)
SAuthr  char(1)
LogNbr  decimal(15,0)

Indexes