Database Tables "Employee" (emp)

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

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. $DebitPay=CompNo=Company=Number=1 9999
  2. $DebitPay=BranchNo=Branch=Number=1 9999
  3. $DebitPay=DebitTransNo=Debit-Trans-No.=Number=1 99999999
  4. DebitPay=TerminalNo=Terminal=Number=1 999999
  5. DebitPay=PosTransNo=Pos-Trans-No.=Number=1 99999999
  6. DebitPay=PosPositionNo=Position=Number=1 9999
  7. DebitPay=CustomerBankNo=Bank Code=Decimal=(13,0)
  8. DebitPay=CustomerAccountNo=Account No.=Decimal=(13,0)
  9. DebitPay=DebitAmount=Debit Amount=Decimal=(12,2)
  10. DebitPay=NextCardNo=Next Card No..=Decimal=(20,2)
  11. DebitPay=BookingDate=Booking Date=Date=
  12. DebitPay=BookingTime=Booking Time=Zeit=
  13. DebitPay=DTAUS0_Date=DTAUS0 Date=Date=
  14. DebitPay=DTAUS0_Cnt=DTAUS0 Write outs=Number=0 99999999
  15. DebitPay=Voided=Voided=Bool=(Y/N)
  16. DebitPay=ReceiptNo=Receipt=Number=1 999999
  1. $Employee=CompNo=Company=Number=1 9999
  2. $Employee=EmployeeNo=Employee No.=Number=1 99999999
  3. Employee=LongName=Name=String=(32)
  4. Employee=Position=Position=String=(32)
  5. Employee=Address1=Address 1=String=(32)
  6. Employee=Address2=Address 2=String=(32)
  7. Employee=CasualEmployee=Casual Employee=Bool=(Y/N)
  8. Employee=WorkingTime=Working Time (HHMM)==
  9. Employee=CustomerNo=Customer No.=Number=1 999999
  10. Employee=CustCardNo=Customer Card No.=Number=
  11. Employee=Supervisor=Supervisor=Number=1 99999999
  1. $OperState=CompNo=Company=Number=1 9999
  2. $OperState=BranchNo=Branch=Number=1 9999
  3. $OperState=OperatorNo=Operator=Number=1 99999999
  4. OperState=WorkingState=Actual working state=Number=
  5. OperState=BalancingState=Actual account state=Number=
  6. OperState=ActualPassword=Actual password=Number=
  7. OperState=LastActivDate=Last sign on date/time=Date=
  8. OperState=FirstSignOn=First Arrival Time=Time=
  9. OperState=LastArrivalTime=Last Arrival Time=Time=
  10. OperState=LastDepartureTime=Last Departure Time=Time=
  11. OperState=SignedOnTerminal=Terminal=Number=1 999999
  12. OperState=CurrentAccountNo=Current Account No.=Number=0 99999998
  13. OperState=FirstSignOnDone=First sign on done=Number=
  1. $Operator=CompNo=Company=Number=1 9999
  2. $Operator=BranchNo=Branch=Number=1 9999
  3. $Operator=OperatorNo=Operator=Number=1 99999999
  4. Operator=Name=Name=String=(20)
  5. Operator=EmployeeNo=Employee No.=Number=1 99999999
  6. Operator=SalesmanNo=Salesman=Number=1 99999999
  7. Operator=StartMenu=Start with menu=Number=
  8. Operator=PenNumber=Pen no.=Decimal=(20,0)
  9. Operator=DrinkDispId=Drink disp. waiter=Number=1 99999999
  10. Operator=MagCardId=Magnetic Card=Number=
  11. Operator=FromProfCent=From Profit Center=Number=1 9999
  12. Operator=ToProfCent=To Profit Center=Number=1 9999
  13. Operator=FromTerminal=From Terminal=Number=1 999999
  14. Operator=ToTerminal=To Terminal=Number=1 999999
  15. Operator=PriceLevel=Price level=Number=0 9
  16. Operator=FixedPassword=PIN=Number=
  17. Operator=OperatorProfil=Profile No.=Number=0 999
  18. Operator=Locked=Locked=Bool=(Y/N)
  19. Operator=AutoStartMenu=Autom. Start Menu=Bool=(Y/N)
  20. Operator=IsSupervisor=Supervisor=Bool=(Y/N)
  21. Operator=HasSupervKey= Supervisor Key =Bool=(Y/N)
  22. Operator=AccessOtherGC=Access other GCs=Bool=(Y/N)
  23. Operator=PasswordEnforced=PIN enforced=Bool=(Y/N)
  24. Operator=TrainingMode=Training Mode=Bool=(Y/N)
  25. Operator=ExternalService=External Service=Bool=(Y/N)
  26. Operator=FixedFloat=Fixed Float=Decimal=(12,2)
  27. Operator=DrawerNo=Drawer=Number=
  28. Operator=ServiceMoney=Service Charge=Number=1 99
  29. Operator=TroncNo=Tronc No.=Number=1 99999999
  30. Operator=StationNo=Station no.=Number=1 9999
  31. Operator=OnHandStockNo=Stock no.=Number=1 9999
  32. Operator=FromTable=From Table=Number=
  33. Operator=ToTable=To Table=Number=
  34. Operator=Menu=Menu=Number=
  35. Operator=HeadWaiter=Head Waiter=Bool=(Y/N)
  36. Operator=CheckOutCashier=Cashier-Waiter=Bool=(Y/N)
  37. Operator=AutomaticGc=Auto. GC=Bool=(Y/N)
  38. Operator=Service=Service=Bool=(Y/N)
  39. Operator=ItemServiceMoney=Item Serv. Charge=Bool=(Y/N)
  40. Operator=LevelForOrder=Autoriz.for Order =Number=
  41. Operator=OrdAutTypNo=Order Authorize=Number=0 9
  42. Operator=MaxOrdering=Max. Ordering Value=Decimal=(12,2)
  43. Operator=PreSetCompNo=Preset Company=Number=1 9999
  44. Operator=PreSetBranchNo=Preset Branch=Number=1 9999
  45. Operator=PreSetBranchGrpNo=Preset Branch Group=Number=1 99
  46. Operator=PreSetProfitCenterNo=Preset Profit Center=Number=1 9999
  47. Operator=PreSetPriceListNo=Preset Price List=Number=1 9999
  48. Operator=BookOnProfCNo=Profit Center=Number=1 9999
  49. Operator=TextGroupNo=Text Group=Number=1 65535 (not in database)
  50. Operator=MessageText=Text=Number=1 9999 (not in database)
  1. $PenTable=CompNo=Company=Number=1 9999
  2. $PenTable=BranchNo=Branch=Number=1 9999
  3. $PenTable=PenTableNo=Waiter Pen Table=Number=1 99
  4. $PenTable=PenNo=Waiter Pen=Number=1 99999999
  5. PenTable=OperatorNo=Operator=Number=1 99999999
  1. $Salesman=CompNo=Company=Number=1 9999
  2. $Salesman=BranchNo=Branch=Number=1 9999
  3. $Salesman=SalesmanNo=Salesman=Number=1 99999999
  4. Salesman=EmployeeNo=Employee No.=Number=1 99999999
  5. Salesman=Name=Name=String=(20)
  6. Salesman=BaseCommission=1st Commission=Decimal=(5,2)
  7. Salesman=ScndCommission=2nd Commission=Decimal=(5,2)
  8. Salesman=MasterSalesman=Supervisor=Number=1 99999999
  9. Salesman=MagCardId=Magnetic Card=Number =
MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin
Germany