Database Tables "Network" (net)

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

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. $IPInterface=InstallNo=Installation=Number=1 9999
  2. $IPInterface=SysUnitNo=System Unit=Number=1 9999
  3. $IPInterface=InterfaceNo=Interface=Number=1 99
  4. IPInterface=Text=Description=String=(20)
  5. IPInterface=IPAddress=IP Address=String=(20)
  6. IPInterface=WANNo=WAN=Number=1 9999
  7. IPInterface=LANNo=LAN=Number=1 9999
  8. IPInterface=LANSegNo=Segment=Number=1 99
  1. LAN=Text=Short description=String=(20)
  2. LAN=NetworkName=Name=String=(32)
  3. LAN=NetworkClass=Network Class=String=(4)
  4. LAN=NetworkAdress=Network-Address=String=(32)
  5. LAN=NetworkMask=Network Mask=String=(32)
  6. $LAN=InstallNo=Installation=Number=1 9999
  7. $LAN=LANNo=LAN=Number=1 9999
  1. $LANSeg=InstallNo=Installation=Number=1 9999
  2. $LANSeg=LANNo=LAN=Number=1 9999
  3. $LANSeg=SegmentNo=Segment=Number=1 99
  4. LANSeg=Text=Name=String=(20)
  5. LANSeg=SegmentType=Segment Type=Number=
  1. $LConnection=InstallNo=Installation=Number=1 9999
  2. $LConnection=LANNo=LAN=Number=1 9999
  3. $LConnection=ConnectorNo=Coupler No.=Number=1 99
  4. $LConnection=LANSegNo=Segment=Number=1 99
  1. $LConnector=InstallNo=Installation=Number=1 9999
  2. $LConnector=LANNo=LAN=Number=1 9999
  3. $LConnector=ConnectorNo=Coupler No.=Number=1 99
  4. LConnector=Text=Descriptor=String=(8)
  5. LConnector=Location=Location=String=(32)
  6. LConnector=Model=Model=String=(32)
  7. LConnector=SerialNumber=Serial No.=String=(32)
  8. LConnector=InstallDate=Installation Date=date=
  9. LConnector=ConnectorType=Type of Coupler=Number=
  1. Net=Text=Name=String=(20)
  2. Net=NetworkName=Network Name=String=(32)
  3. Net=NetworkClass=Network Class=String=(4)
  4. Net=NetworkAdress=Network Address=String=(32)
  5. Net=NetworkMask=Network Mask=String=(32)
  1. $ProcInfo=ProcInfoNo=Number=Number=1 1
  2. ProcInfo=InstallNo=Installation=Number=1 9999
  3. ProcInfo=ProcUnitNo=Process Unit=Number=1 9999
  4. ProcInfo=ServerIP=Description=String=(32)
  5. ProcInfo=PortBase=Port base=Number=
  1. $ProcType=ProcUnitNo=Process Unit=Number=1 9999
  2. ProcType=Text=Name=String=(20)
  1. WAN=Text=Short description=String=(20)
  2. WAN=NetworkName=Name=String=(32)
  3. WAN=NetworkClass=Network Class=String=(4)
  4. WAN=NetworkAdress=Network Address=String=(32)
  5. WAN=NetworkMask=Network Mask=String=(32)
  6. $WAN=WANNo=WAN=Number=1 9999
  7. WAN=WANType=Number=Number=
  8. WAN=UserNo=User=Number=1 1
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany