USR$MN CALCCARDLINE

Материал из GedeminWiki
Перейти к: навигация, поиск

Калькуляционная карточка

CREATE TABLE USR$MN_CALCCARDLINE 
(
  DOCUMENTKEY	        DINTKEY NOT NULL,
  RESERVED	        DINTEGER,
  MASTERKEY	        DMASTERKEY,
  USR$BASECOSTNCU	DCURRENCY,
  USR$BASEFAT	        DQUANTITY,
  USR$BASEHUMIDITY	DQUANTITY,
  USR$CALCCARDKEY	USR$MN_CALCCARD,
  USR$COSTBUYNCU	DCURRENCY,
  USR$COSTNCU	        DCURRENCY,
  USR$COSTPRICE 	DCURRENCY,
  USR$COSTTRADENCU	DCURRENCY,
  USR$COSTTRWITHNDS	DCURRENCY,
  USR$COSTWITHADDNCU	DCURRENCY,
  USR$EXTRA	        DCURRENCY,
  USR$EXTRACOST  	DCURRENCY,
  USR$EXTRANDS	        DCURRENCY,
  USR$EXTRAPERC	        DPERCENT,
  USR$EXTRASERVICECOST	DCURRENCY,
  USR$EXTTAXSALECOST	DCURRENCY,
  USR$FAT	        DQUANTITY,
  USR$GOODKEY	        USR$GS_DGOOD,
  USR$GROSSWEIGHT	DQUANTITY,
  USR$HUMIDITY	        DQUANTITY,
  USR$INV_CARDKEY	USR$MN_D_INVCARDKEY,
  USR$LOSSFACTOR	DCURRENCY,
  USR$NETWEIGHT	        DQUANTITY,
  USR$OLDGOODKEY	USR$GS_DGOOD,
  USR$OLDGROSSWEIGHT	DQUANTITY,
  USR$OLDLOSSFACTOR	DQUANTITY,
  USR$OLDNETWEIGHT	DQUANTITY,
  USR$PRINTINMENU	DBOOLEAN DEFAULT '1',
  USR$RATETAX_SALE	DCURRENCY,
  USR$RATETAX_SERVICE	DCURRENCY,
  USR$SELCOSTNCU	DCURRENCY,
  USR$SELLNDS	        DCURRENCY,
  USR$SUBLINEKEY	USR$MN_D_CALCCARDLINEKEY,
  USR$SUBRECEIPKEY	USR$MN_RECEIPTKEY,
  USR$SUMNCU	        DCURRENCY,
  USR$SUMRATE_SALE	DCURRENCY,
  USR$SUMRATE_SERVICE	DCURRENCY,
  USR$TAXSALE	        DCURRENCY,
  USR$TAXSERVICE	DCURRENCY,
  USR$VALUEKEY    	USR$INV_DVALUE,
  PRIMARY KEY           (DOCUMENTKEY)
);
Персональные инструменты
Пространства имён

Варианты
Действия
Навигация
Инструменты