CREATE VIEW VIEW01
(
  ID,
  USERID,
  DEVICEID,
  DATUM,
  INOUT,
  VERIFYMODE,
  UPDATEUSERID,
  UPDATEREMARK,
  UPDATEINOUT,
  UPDATEWHEN,
  UPDATECHANGEWHEN,
  WORKCODE
)
AS
SELECT 
  ID,
  USERID,
  DEVICEID,
  "WHEN",
  INOUT,
  VERIFYMODE,
  UPDATEUSERID,
  UPDATEREMARK,
  UPDATEINOUT,
  UPDATEWHEN,
  UPDATECHANGEWHEN,
  WORKCODE
FROM ATTENDANT;