USR$MN ORDER
Материал из GedeminWiki
(Различия между версиями)
MoS (обсуждение | вклад) |
MoS (обсуждение | вклад) |
||
| Строка 1: | Строка 1: | ||
| − | [[Питание персонала]] [[Заказ]] | + | [[Питание персонала]] [[Заказ]] |
<syntaxhighlight lang="sql"> | <syntaxhighlight lang="sql"> | ||
Версия 18:25, 8 февраля 2022
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) );