GD DOCUMENTTYPE OPTION

CREATE TABLE gd_documenttype_option (
  id                    dintkey,
  dtkey                 dintkey,
  option_name           dname,
  bool_value            dboolean,
  relationfieldkey      dforeignkey,
  contactkey            dforeignkey,
  currkey               dforeignkey,
  editiondate           deditiondate, 
  disabled              ddisabled,
 
  CONSTRAINT gd_pk_dt_option PRIMARY KEY (id),
  CONSTRAINT gd_fk_dt_option_dtkey FOREIGN KEY (dtkey)
    REFERENCES gd_documenttype (id)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT gd_fk_dt_option_relfkey FOREIGN KEY (relationfieldkey)
    REFERENCES at_relation_fields (id)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT gd_fk_dt_option_contactkey FOREIGN KEY (contactkey)
    REFERENCES gd_contact (id)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT gd_fk_dt_option_currkey FOREIGN KEY (currkey)
    REFERENCES gd_curr (id)
    ON DELETE CASCADE
    ON UPDATE CASCADE
);

Имя опции	Описание	bool	rfk	ck	currk
CM.SF			*
LF	Поле позиции прайс-листа.		*		*

См. также

• Конвертация параметров складских документов