Database Tables "Special" (spec)

The following description shows the layout of the database tables for the component spec.

Each of the database tables listed here contains the number of fields with the corresponding table name, the internal field description, the field name, the data type and the field length.

Fields characterized by the "$" sign are primary keys.

For more detailed information on the database tables (e.g. attributes, references, indices etc.) go to the update program System -> Database-> Database Tables.

  1. $ApplChainPar=ChainName=Chain Name=String=(20)
  2. $ApplChainPar=PositionNo=Position=Number=1 9999
  3. $ApplChainPar=EventNo=Event No.=Number=1 9999
  4. ApplChainPar=FieldName=Field Name=String=(20)
  5. ApplChainPar=FieldValue=Field Value=String=(20)
  1. $ApplChainPos=ChainName=Chain Name=String=(20)
  2. $ApplChainPos=PositionNo=Position=Number=1 9999
  3. ApplChainPos=ApplName=Appl.Name=String=(20)
  4. ApplChainPos=Interactive=Interactive
  5. =Bool=(Y/N)
  1. $ApplGroup=ApplGroupNo=Appl.Group=Number=1 99
  2. ApplGroup=GroupName=Name=String=(20)
  1. $ApplTaskPos=TaskName=Scheduler name=String=(20)
  2. $ApplTaskPos=PositionNo=Position=Number=1 9999
  3. ApplTaskPos=ApplName=Program name=String=(20)
  4. ApplTaskPos=TaskMode=Mode=Number=
  5. ApplTaskPos=TaskTime=Time=Time=
  6. ApplTaskPos=TaskDay=Day of the Month=Number=
  1. $AsciiClass=AsciiGroupNo=Ascii Group=Number=1 99
  2. $AsciiClass=AsciiClassNo=Ascii Class=Number=1 9999
  3. AsciiClass=ClassName=Class Name=String=(20)
  4. AsciiClass=IntervalNo=Time Interval=Number=1 9 (not in database)
  5. AsciiClass=AsciiDate=NOTEXT=Date (not in database)=
  1. $AsciiField=AsciiGroupNo=Ascii Group=Number=1 99
  2. $AsciiField=AsciiClassNo=Ascii Class=Number=1 9999
  3. $AsciiField=PositionNo=Position=Number=1 9999
  4. AsciiField=FieldName=Field Name=String=(20)
  5. AsciiField=AscLen=Field length Ascii=Number=
  6. AsciiField=KeyPart=Key field=Bool=(Y/N)
  1. $AsciiGroup=AsciiGroupNo=Ascii Group=Number=1 99
  2. AsciiGroup=GroupName=Group Name=String=(20)
  3. AsciiGroup=MaxTlen=Max. Message Length=Number=
  4. AsciiGroup=MaxDlen=Max. Record Length=Number=
  5. AsciiGroup=Ebcdic=Ebcdic=Bool=(Y/N)
  6. AsciiGroup=CrLfOnDisc=CRLF=Bool=(Y/N)
  7. AsciiGroup=AckNakMode=Ack-Nak Mode=Bool=(Y/N)
  8. AsciiGroup=ErrClassNo=Error Class=Number=
  1. $CodeTabEnt=CodeTableNo=Code Table No..=Number=1 9999
  2. $CodeTabEnt=CodeNo=Number=Number=1 9999
  3. CodeTabEnt=EventName=Event Name=String=(20)
  4. CodeTabEnt=EventData=Data=String=(20)
  1. $CodeTable=CodeTableNo=Code Table No..=Number=1 9999
  2. CodeTable=Text=Name=String=(20)
  1. FglClipboard=DateFormat=NOTEXT=String=(20)
  2. FglClipboard=DecimalPoint=NOTEXT=String=(20)
  3. FglClipboard=FieldSep=NOTEXT=String=(20)
  4. FglClipboard=RecordSep=NOTEXT=String=(20)
  1. FglDate=Value=NOTEXT=Date=
  1. FglReport=TabName=NOTEXT=String=(20)
  1. FglTime=Value=NOTEXT=Time=
  1. FglTreeAttr=LanguageNo=Language=Number=1 99
  2. FglTreeAttr=Label=NOTEXT=String=(20)
  3. FglTreeAttr=TabName=NOTEXT=String=(20)
  4. FglTreeAttr=PositionNo=NOTEXT=Number=
  5. FglTreeAttr=IsRefBy=NOTEXT=Number=
  6. FglTreeAttr=IsPrimAttr=NOTEXT=Number=
  1. $GroupProfil=ProfilNo=Profile No.=Number=0 999
  2. $GroupProfil=ApplGroupNo=Appl.Group=Number=1 99
  3. GroupProfil=RunAppl=Run Application=Bool=(Y/N)
  4. GroupProfil=UpdateObj=Update data=Bool=(Y/N)
  5. GroupProfil=InsertObj=Insert Data=Bool=(Y/N)
  6. GroupProfil=DeleteObj=Delete Data=Bool=(Y/N)
  1. VirtualAttr=PathName=NOTEXT=String=(20)
  2. VirtualAttr=Hide=NOTEXT=Number=
  3. VirtualAttr=Sort=NOTEXT=Number=
  4. VirtualAttr=Label=NOTEXT=String=(20)
  5. VirtualAttr=CmpOper=NOTEXT=String=(20)
  6. VirtualAttr=CmpVal=NOTEXT=String=(20)
  7. VirtualAttr=Func=NOTEXT=String=(20)
  8. VirtualAttr=RollupBy=NOTEXT=String=(20)
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany