USR$MN ORDERLINE

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

Заказ

CREATE TABLE USR$MN_ORDERLINE 
(
  DOCUMENTKEY	           DINTKEY NOT NULL,
  RESERVED	           DINTEGER,
  MASTERKEY	           DMASTERKEY,
  USR$CALCCARDKEY	   USR$MN_CALCCARD,
  USR$CAUSEDELETEKEY	   USR$COUSEDELEORDERLINEKEY,
  USR$COSTEQ	           DCURRENCY,
  USR$COSTEQWITHDISCOUNT   DCURRENCY,
  USR$COSTNCU	           DCURRENCY,
  USR$COSTNCUWITHDISCOUNT  DCURRENCY,
  USR$DELETEAMOUNT	   DCURRENCY,
  USR$DEPOTKEY	           USR$GS_DDEPARTMENT,
  USR$FROMDEPOT	           USR$GS_DDEPARTMENT,
  USR$GOODKEY	           USR$GS_DGOOD,
  USR$LOGICDATE	           DDATE,
  USR$MENULINEKEY	   USR$DMN_MENULINEKEY,
  USR$MODIFYSET	           USR$MN_MODIFYSET,
  USR$PAYTYPE	           DTEXT10,
  USR$PERSDISCOUNT	   DCURRENCY,
  USR$QUANT_SPECFOOD	   DCURRENCY,
  USR$QUANTITY	           DQUANTITY,
  USR$REGISTER	           DTEXT8,
  USR$SUMDISCOUNT	   DCURRENCY,
  USR$SUMNCU	           DCURRENCY,
  USR$SUMNCUWITHDISCOUNT   DCURRENCY,
  USR$SUMTRADE	           DCURRENCY,
  USR$SUMSELLNDS	   DCURRENCY,
  USR$SUMEXTRA	           DCURRENCY,
  USR$SUMEXTRANDS	   DCURRENCY,
  USR$SUMEXTRAUP	   DCURRENCY,
  USR$SUMEXTRANDSUP	   DCURRENCY,
  USR$SUMROUND	           DCURRENCY,
  USR$INV_CARDKEY	   USR$MN_D_INVCARDKEY,
  USR$FROMPRICE	           DBOOLEAN DEFAULT '0',
  USR$SUMBUY	           DCURRENCY,
  PRIMARY KEY             (DOCUMENTKEY)
);