Database Tables "System" (sysCommon)

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

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. $DbText=LanguageNo=Language=Number=1 99
  2. $DbText=TableName=Table Name=String=(20)
  3. $DbText=ElementName=Attribute=String=(20)
  4. DbText=Text=Description=String=(32)
  5. DbText=ShortText=Short Descriptor=String=(12)
  1. $Device=InstallNo=Installation=Number=1 9999
  2. $Device=ProcUnitNo=Process Unit=Number=1 9999
  3. $Device=DeviceNo=Device No.=Number=1 9999
  4. Device=Text=Description=String=(20)
  5. Device=DevInterfNo=Device Interface=Number=1 99
  6. Device=SerialNumber=Serial No.=String=(32)
  7. Device=Parameter1=Parameter 1=String=(32)
  8. Device=Parameter2=Parameter 2=String=(32)
  9. Device=Parameter3=Parameter 3=String=(32)
  1. $DvRemote=InstallNo=Installation=Number=1 9999
  2. $DvRemote=ProcUnitNo=Process Unit=Number=1 9999
  3. $DvRemote=DeviceNo=Device No.=Number=1 9999
  4. DvRemote=Text=Description=String=(20)
  5. DvRemote=DevInterfNo=Device Interface=Number=1 99
  6. DvRemote=SerialNumber=Serial No.=String=(32)
  7. DvRemote=Parameter1=Parameter 1=String=(32)
  8. DvRemote=Parameter2=Parameter 2=String=(32)
  9. DvRemote=Parameter3=Parameter 3=String=(32)
  10. DvRemote=SrvProcUnitNo=Process Unit=Number=1 9999
  11. DvRemote=SrvDeviceNo=Device No.=Number=1 9999
  1. $Installation=InstallNo=Installation=Number=1 9999
  2. Installation=Text=Short Name=String=(20)
  3. Installation=SuperInstallNo=Main Installation=Number=1 9999
  4. Installation=Text1=Text1=String=(32)
  5. Installation=Text2=Text2=String=(32)
  6. Installation=Text3=Text3=String=(32)
  7. Installation=Text4=Text4=String=(32)
  8. Installation=UserNo=User=Number=1 1
  9. Installation=PortBase=Port base=Number=
  10. Installation=Licence=Licence=String=(32)
  11. Installation=LicenceDate=Licence Date=Date=
  12. Installation=Expiration=Valid until=Date=
  13. Installation=ActivationKey=Activation key=String=(8)
  14. Installation=MaxUser=Max.User=Number=
  15. Installation=CustOpt=Customer Option=Bool=(Y/N)
  16. Installation=StockOpt=Stock Option=Bool=(Y/N)
  17. Installation=SuppOpt=Supplier Option=Bool=(Y/N)
  1. $InterfType=DevInterfNo=Device Interface=Number=1 99
  2. InterfType=Text=Description=String=(20)
  3. InterfType=DevName=Device Name=String=(20)
  1. $KeybHead=KeyboardNo=Keyboard No.=Number=1 9999
  2. KeybHead=Text=Name=String=(20)
  1. $KeybKey=KeyboardNo=Keyboard No.=Number=1 9999
  2. $KeybKey=Row=Row=Number=1 99
  3. $KeybKey=Column=Column=Number=1 99
  4. KeybKey=EventName=Event=String=(20)
  5. KeybKey=EventData=Data=String=(20)
  6. KeybKey=AsciiData=Ascii Char =String=(1)
  1. $Language=LanguageNo=Language=Number=1 99
  2. Language=LangName=Name=String=(20)
  3. Language=YesChar=Character for YES=String=(1)
  4. Language=NoChar=Character for NO=String=(1)
  5. Language=DsLanguage=Char.Set Display=Number=
  6. Language=PrLanguage=Char.Set Printer=Number=
  7. Language=DateFormat=NOTEXT=Number=0 3
  1. $ProcUnit=InstallNo=Installation=Number=1 9999
  2. $ProcUnit=ProcUnitNo=Process Unit=Number=1 9999
  3. ProcUnit=Text=Description=String=(20)
  4. ProcUnit=SysUnitNo=System Unit=Number=1 9999
  5. ProcUnit=ProgrammName=Program Name=String=(32)
  6. ProcUnit=HomeDirectory=Description=String=(32)
  7. ProcUnit=Parameter1=Description=String=(32)
  8. ProcUnit=Parameter2=Description=String=(32)
  9. ProcUnit=Parameter3=Description=String=(32)
  10. ProcUnit=LoginName=Login Name=String=(20)
  11. ProcUnit=Gui=Graphic=Bool=(Y/N)
  12. ProcUnit=HasDb=has Database=Bool=(Y/N)
  13. ProcUnit=ProgType=Program Type=Number=
  14. ProcUnit=LanguageNo=Language=Number=1 99
  15. ProcUnit=Xserver=X Server=Bool=(Y/N)
  1. $SystemUnit=InstallNo=Installation=Number=1 9999
  2. $SystemUnit=SysUnitNo=System Unit=Number=1 9999
  3. SystemUnit=Text=Description=String=(20)
  4. SystemUnit=IPAddress=IP Address=String=(20)
  5. SystemUnit=Location=Location=String=(32)
  6. SystemUnit=Model=Model No.=String=(32)
  7. SystemUnit=SerialNumber=Serial No.=String=(32)
  8. SystemUnit=InstallDate=Installation Date=Date=
  9. SystemUnit=ApplicationUnit=Application Unit=Bool=(Y/N)
  10. SystemUnit=RoutingUnit=Routing Unit=Bool=(Y/N)
  11. SystemUnit=SMNPAgent=SMNP Agent=Bool=(Y/N)
  1. $UiMenuText=LanguageNo=Language=Number=1 99
  2. $UiMenuText=FrameName=Frame Name=String=(20)
  3. $UiMenuText=FieldName=Field Name=String=(20)
  4. UiMenuText=Text=Translation=String=(32)
  5. UiMenuText=SpeedKey=Speed Key=String=(20)
  6. UiMenuText=SpeedKeyLbl=Description=String=(8)
  1. $UiText=LanguageNo=Language=Number=1 99
  2. $UiText=FrameName=Frame-Name=String=(20)
  3. $UiText=FieldName=Field Name=String=(20)
  4. UiText=Text=Translation=String=(32)
  1. $UserNetwork=UserNo=User=Number=1 1
  2. UserNetwork=Text=Short Name=String=(8)
  3. UserNetwork=Name=Name=String=(32)
  4. UserNetwork=Adr1=Address 1=String=(32)
  5. UserNetwork=Adr2=Address 2=String=(32)
  6. UserNetwork=Adr3=Address 3=String=(32)
  7. UserNetwork=Contact=Contact=String=(20)
  8. UserNetwork=Telefon=Phone=String=(16)
  9. UserNetwork=Fax=Fax=String=(16)
  10. UserNetwork=Modem=Modem=String=(16)
  11. UserNetwork=EMail=eMail=String=(32)
  12. UserNetwork=CentralInstall=Installation=Number=1 9999
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany