USR$MN RECEIPT

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

Документ 01. Рецепт (форма)

CREATE TABLE USR$MN_RECEIPT 
(
  DOCUMENTKEY	DINTKEY NOT NULL,
  RESERVED	DINTEGER,
  USR$OUTHOT	DCURRENCY,
  USR$COUNTCOURSE	DQUANTITY,
  USR$GOODKEY	USR$GS_DGOOD,
  USR$OUTCOLD	DCURRENCY,
  USR$ZAPAH	DBLOBTEXT80_1251,
  USR$NETWEIGHT	DQUANTITY,
  USR$OUTPUT	DTEXT20,
  USR$COMMENT	DBLOBTEXT80,
  USR$CATEGORYKEY	USR$MN_D_CATEGORYKEY,
  USR$CONSISTENCE2	DBLOBTEXT80,
  USR$VIEW2	DBLOBTEXT80,
  USR$MODIFYGROUPKEY	USR$MN_DMODIFY,
  USR$TERM	DBLOBTEXT80_1251,
  USR$PRNGROUPKEY	USR$MN_DPRNGROUP,
  USR$TEMPERATURE_BLOB	DBLOBTEXT80,
  USR$COLOR_BLOB	DBLOBTEXT80,
  USR$TASTE_BLOB	DBLOBTEXT80,
  USR$MODIFYSET	USR$MN_MODIFYSET,
  USR$EXTRACATEGORYKEY	USR$MN_EXTRACATEGORY,
  USR$QUANTITYCALC	DCURRENCY,
  USR$PRIKAZNUMBER	DTEXT60,
  USR$COLLECTIONNUM	DTEXT20,
  USR$DEPOTKEY	USR$GS_DDEPARTMENT,
  USR$PRIKAZDATE	DDATE,
  USR$STB	DTEXT32,
  USR$TERMUSE	DTEXT20,
  USR$MN_KISL	DCURRENCY,
  USR$HUMIDITY	DCURRENCY,
  USR$DISCOUNT	DCURRENCY,
  USR$OUTWEIGHT	DCURRENCY,
  USR$HUMSAVING	DTEXT32,
  USR$TEMPSAVING	DTEXT40,
  USR$MN_TNPA	USR$MN_TNPA,
 PRIMARY KEY (DOCUMENTKEY)
);
Персональные инструменты
Пространства имён

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