USR$MN ORDER

Питание персонала

Заказ

CREATE TABLE USR$MN_ORDER 
(
  DOCUMENTKEY	         DINTKEY NOT NULL,
  RESERVED	         DINTEGER,
  USR$CASH	         DCURRENCY,
  USR$CONCESSION	 DCURRENCY,
  USR$CONCESSIONKEY	 USR$MN_DCONCESSIONKEY,
  USR$CUSTOMER	         USR$GS_DCUSTOMER,
  USR$DISCOUNTNCU	 DCURRENCY,
  USR$EMPLKEY	         USR$MN_D_EMPLKEY,
  USR$GUESTCOUNT	 DSMALLINT,
  USR$LOGICDATE	         DDATE,
  USR$MENUKEY	         USR$DMENUKEY,
  USR$MN_FRONTKEY	 DINTEGER,
  USR$PAY	         DBOOLEAN,
  USR$PAYTYPE	         USR$INV_DPAYTYPE,
  USR$PLAN	         DBOOLEAN,
  USR$REGISTER	         DTEXT8,
  USR$RESPKEY	         USR$GS_DEMPLOYEE,
  USR$SYSNUM	         DINTEGER,
  USR$TIMECLOSEORDER     DTIME,
  USR$TIMEORDER	         DTIME,
  USR$WHOPAYOFFKEY       USR$GS_DEMPLOYEE,
  USR$SUMNCU	         DCURRENCY,
  USR$BONUSSUM	         DCURRENCY,
  USR$ADVANCESUM         DCURRENCY,
  USR$SUMNCUWITHDISCOUNT DCURRENCY,
  USR$STAFFKEY	         USR$INV_DEMPLOYEE,
  USR$STAFFCARDKEY	 USR$D_PF_STAFFCARD,
  USR$DISCCARDKEY	 USR$DDISCOUNTCARD,
  PRIMARY KEY            (DOCUMENTKEY)
);