USR$BRD DISPOSAL

Таблица-шапка складского документа "Выбытие"

CREATE TABLE USR$BRD_DISPOSAL 
(
  DOCUMENTKEY		DINTKEY NOT NULL,
  RESERVED		DINTEGER,
  USR$TOCONTACTKEY	USR$BRD_D_CONTACTKEY,         /* на контакт (Псевдоклиент) */
  USR$MAINDEPTKEY	USR$BRD_DEPTKEY,              /* с подразделения (ограничение для позиции) */  
  USR$EMPLOYEEKEY	USR$BRD_D_EMPLOYEEKEY,        /* МОЛ */ 
  USR$REASONKEY		USR$BRD_D_DISPOSALREASONKEY,  /* причина выбытия */
  USR$PRICEKEY		USR$BRD_D_PRICEKEY,           /* прайс-лист */
  USR$TODEPTINFOKEY	USR$BRD_DEPTKEY,              /* подразделение выбытия для информации */
 PRIMARY KEY (DOCUMENTKEY)
);
 
ALTER TABLE USR$BRD_DISPOSAL ADD CONSTRAINT USR$FKBRD_DISPOSAL____ 
  FOREIGN KEY (USR$TOCONTACTKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_DISPOSAL ADD CONSTRAINT USR$FKBRD_DISPOSAL____ 
  FOREIGN KEY (USR$MAINDEPTKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_DISPOSAL ADD CONSTRAINT USR$FKBRD_DISPOSAL____ 
  FOREIGN KEY (USR$EMPLOYEEKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_DISPOSAL ADD CONSTRAINT USR$FKBRD_DISPOSAL____ 
  FOREIGN KEY (USR$REASONKEY) REFERENCES USR$BRD_DISPOSALREASON (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_DISPOSAL ADD CONSTRAINT USR$FKBRD_DISPOSAL____ 
  FOREIGN KEY (USR$PRICEKEY) REFERENCES INV_PRICE (DOCUMENTKEY) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_DISPOSAL ADD CONSTRAINT USR$FKBRD_DISPOSAL____ 
  FOREIGN KEY (USR$TODEPTINFOKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_DISPOSAL ADD CONSTRAINT USR$FKUSR$BRD_DISPOSAL_DK 
  FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;