USR$MN SPEND

Списание сырья

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

CREATE TABLE USR$MN_SPEND (

 DOCUMENTKEY	          DINTKEY NOT NULL,
 RESERVED	          DINTEGER,
 USR$CARDKEY	          DINTEGER,
 USR$DATEBEGIN	          DDATE,
 USR$DATEEND	          DDATE,
 USR$DEPOTKEY	          USR$GS_DDEPARTMENT,
 USR$GOODKEY	          USR$GS_DGOOD,
 USR$QUANTITY	          DCURRENCY,
 USR$SELCOST	          DCURRENCY,
 USR$SELCOSTWITHDISCOUNT DCURRENCY,
 USR$SPENDCLIENT	  USR$GS_DCUSTOMER,
 USR$SPENDLINEKEY	  USR$MN_D_SPENDLINEKEY,
 USR$TYPE	          DINTEGER,
 PRIMARY KEY             (DOCUMENTKEY)

); syntaxhighlight lang="sql">