USR$BRD INTMOVELINE

Таблица-позиция складского документа "Внутреннее перемещение"

CREATE TABLE USR$BRD_INTMOVELINE 
(
  DOCUMENTKEY		DINTKEY NOT NULL,
  RESERVED		DINTEGER,
  MASTERKEY		DMASTERKEY,
  FROMCARDKEY		DINTKEY,
  QUANTITY		DQUANTITY,
  REMAINS		DQUANTITY,
  TOCARDKEY		DINTKEY,
  DISABLED		DDISABLED,
  USR$FROMCONTACTKEY	USR$BRD_DEPTKEY,       /* с контакта */
  USR$TOCONTACTKEY	USR$BRD_DEPTKEY,       /* на контакт */
  USR$WEIGHT		USR$BRD_D_COUNT,       /* общий вес */
  USR$SUMNCU		USR$BRD_D_COUNT,       /* вес 1-го ТМЦ */
  USR$AVGWEIGHT		USR$BRD_D_COUNT,       /* зачетный вес */ 
  USR$ACCWEIGHT		USR$BRD_D_COUNT,       /* сумма в рублях */
  USR$HAULNUMBER	USR$BRD_D_INT_NUMBER,  /* номер ездки */
 PRIMARY KEY (DOCUMENTKEY)
);
 
ALTER TABLE USR$BRD_INTMOVELINE ADD CONSTRAINT USR$FKBRD_INTMOVELINE____ 
  FOREIGN KEY (USR$FROMCONTACTKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_INTMOVELINE ADD CONSTRAINT USR$FKBRD_INTMOVELINE____ 
  FOREIGN KEY (USR$TOCONTACTKEY) REFERENCES GD_CONTACT (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_INTMOVELINE ADD CONSTRAINT USR$FKUSR$BRD_INTMOVELINE_DK 
  FOREIGN KEY (DOCUMENTKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;
 
ALTER TABLE USR$BRD_INTMOVELINE ADD CONSTRAINT USR$FKUSR$BRD_INTMOVELINE_FC 
  FOREIGN KEY (FROMCARDKEY) REFERENCES INV_CARD (ID) 
  ON UPDATE CASCADE;
 
ALTER TABLE USR$BRD_INTMOVELINE ADD CONSTRAINT USR$FKUSR$BRD_INTMOVELINE_MK 
  FOREIGN KEY (MASTERKEY) REFERENCES GD_DOCUMENT (ID) 
  ON UPDATE CASCADE 
  ON DELETE CASCADE;
 
ALTER TABLE USR$BRD_INTMOVELINE ADD CONSTRAINT USR$FKUSR$BRD_INTMOVELINE_TC 
  FOREIGN KEY (TOCARDKEY) REFERENCES INV_CARD (ID) 
  ON UPDATE CASCADE;