Database Tables "Miscellaneous " (misc)

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

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. $ApplAdmin=ApplCompNo=Application=Number=1 9999
  2. ApplAdmin=ApplName=Description=String=(20)
  3. ApplAdmin=FsmName=FSM File=String=(20)
  4. ApplAdmin=FglName=4GL File=String=(20)
  5. ApplAdmin=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplAdmin=FrameNo=Frame No.=Number=1 99999999
  7. ApplAdmin=TableName=Object Name=String=(20)
  8. ApplAdmin=AutoSearch=With Search=Bool=(Y/N)
  9. ApplAdmin=FrameName=Frame Name=String=(20)
  10. ApplAdmin=AutoSave=Auto.Save=Bool=(Y/N)
  11. ApplAdmin=PrintFglName=Print Fgl-Name=String=(20)
  1. $ApplAscCom=ApplCompNo=Application=Number=1 9999
  2. ApplAscCom=ApplName=Program Name=String=(20)
  3. ApplAscCom=FsmName=FSM File=String=(20)
  4. ApplAscCom=FglName=4GL File=String=(20)
  5. ApplAscCom=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplAscCom=FrameNo=Frame No.=Number=1 99999999
  7. ApplAscCom=AsciiGroupNo=Ascii Group=Number=1 99
  8. ApplAscCom=NeedLogin=Need Login=Bool=(Y/N)
  9. ApplAscCom=Password=Description=String=(20)
  1. $ApplChain=ApplCompNo=Application=Number=1 9999
  2. ApplChain=ApplName=Description=String=(20)
  3. ApplChain=FsmName=FSM File=String=(20)
  4. ApplChain=FglName=4GL File=String=(20)
  5. ApplChain=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplChain=FrameNo=Frame No.=Number=1 99999999
  1. $ApplDetail=ApplCompNo=Application=Number=1 9999
  2. ApplDetail=ApplName=Description=String=(20)
  3. ApplDetail=FsmName=FSM File=String=(20)
  4. ApplDetail=FglName=4GL File=String=(20)
  5. ApplDetail=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplDetail=FrameNo=Frame No.=Number=1 99999999
  7. ApplDetail=TableName=Object Name=String=(20)
  8. ApplDetail=MasterApplNo=Administration=Number=1 9999
  9. ApplDetail=RefName=Reference Name=String=(20)
  10. ApplDetail=DeleteCascades=Delete with master=Bool=(Y/N)
  1. $ApplDispatch=ApplCompNo=Application=Number=1 9999
  2. ApplDispatch=ApplName=Description=String=(20)
  3. ApplDispatch=FsmName=FSM File=String=(20)
  4. ApplDispatch=FglName=4GL File=String=(20)
  5. ApplDispatch=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplDispatch=FrameNo=Frame No.=Number=1 99999999
  7. ApplDispatch=Preselect=Pre select=Bool=(Y/N)
  1. $ApplEdit=ApplCompNo=Application=Number=1 9999
  2. ApplEdit=ApplName=Description=String=(20)
  3. ApplEdit=FsmName=FSM File=String=(20)
  4. ApplEdit=FglName=4GL File=String=(20)
  5. ApplEdit=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplEdit=FrameNo=Frame No.=Number=1 99999999
  7. ApplEdit=TableName=Name=String=(20)
  1. $ApplHWTest=ApplCompNo=Application=Number=1 9999
  2. ApplHWTest=ApplName=Description=String=(20)
  3. ApplHWTest=FsmName=FSM File=String=(20)
  4. ApplHWTest=FglName=4GL File=String=(20)
  5. ApplHWTest=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplHWTest=FrameNo=Frame No.=Number=1 99999999
  1. $ApplNetTest=ApplCompNo=Application=Number=1 9999
  2. ApplNetTest=ApplName=Description=String=(20)
  3. ApplNetTest=FsmName=FSM File=String=(20)
  4. ApplNetTest=FglName=4GL File=String=(20)
  5. ApplNetTest=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplNetTest=FrameNo=Frame No.=Number=1 99999999
  1. $ApplOo=ApplCompNo=Application=Number=1 9999
  2. ApplOo=ApplName=Description=String=(20)
  3. ApplOo=FsmName=FSM File=String=(20)
  4. ApplOo=FglName=4GL File=String=(20)
  5. ApplOo=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplOo=FrameNo=Frame No.=Number=1 99999999
  1. $ApplRepgen=ApplCompNo=Application=Number=1 9999
  2. ApplRepgen=ApplName=Description=String=(20)
  3. ApplRepgen=FsmName=FSM File=String=(20)
  4. ApplRepgen=FglName=4GL File=String=(20)
  5. ApplRepgen=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplRepgen=FrameNo=Frame No.=Number=1 99999999
  1. $ApplReport=ApplCompNo=Application=Number=1 9999
  2. ApplReport=ApplName=Description=String=(20)
  3. ApplReport=FsmName=FSM File=String=(20)
  4. ApplReport=FglName=4GL File=String=(20)
  5. ApplReport=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplReport=FrameNo=Frame No.=Number=1 99999999
  7. ApplReport=FrameName=Object Name=String=(20)
  8. ApplReport=WithoutPrintout=Without Printout=Bool=(Y/N)
  1. $ApplTask=ApplCompNo=Application=Number=1 9999
  2. ApplTask=ApplName=Program name=String=(20)
  3. ApplTask=FsmName=FSM File=String=(20)
  4. ApplTask=FglName=4GL File=String=(20)
  5. ApplTask=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplTask=FrameNo=Frame No.=Number=1 99999999
  1. $ApplTouchSrv=ApplCompNo=Application=Number=1 9999
  2. ApplTouchSrv=ApplName=Program Name=String=(20)
  3. ApplTouchSrv=FsmName=FSM File=String=(20)
  4. ApplTouchSrv=FglName=4GL File=String=(20)
  5. ApplTouchSrv=ApplGroupNo=Appl.Group=Number=1 99
  6. ApplTouchSrv=FrameNo=Frame No.=Number=1 99999999
  7. ApplTouchSrv=PrepFrameName=Name=String=(20)
  8. ApplTouchSrv=ProdFrameName=Name=String=(20)
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany