AC GENERALLEDGER

CREATE TABLE AC_GENERALLEDGER (
    ID             DINTKEY NOT NULL,
    NAME           DNAME NOT NULL COLLATE PXW_CYRL,
    DEFAULTUSE     DBOOLEAN,
    INNCU          DBOOLEAN,
    INCURR         DBOOLEAN,
    NCUDECDIGITS   DINTEGER_NOTNULL,
    NCUSCALE       DINTEGER_NOTNULL,
    CURRDECDIGITS  DINTEGER_NOTNULL NOT NULL,
    CURRSCALE      DINTEGER_NOTNULL NOT NULL,
    CURRKEY        DFOREIGNKEY,
    ACCOUNTKEY     DFOREIGNKEY,
    ENHANCEDSALDO  DBOOLEAN,
    EDITIONDATE    DEDITIONDATE
);
 
ALTER TABLE AC_GENERALLEDGER ADD CONSTRAINT PK_AC_GENERALLEDGER
  PRIMARY KEY (ID);
ALTER TABLE AC_GENERALLEDGER ADD CONSTRAINT FK_AC_GENERALLEDGER_ACKEY
  FOREIGN KEY (ACCOUNTKEY) REFERENCES AC_ACCOUNT (ID);
ALTER TABLE AC_GENERALLEDGER ADD CONSTRAINT FK_AC_GENERALLEDGER_CURRKEY
  FOREIGN KEY (CURRKEY) REFERENCES GD_CURR (ID);
 
CREATE UNIQUE INDEX ac_x_generalledger_name ON ac_generalledger
  (name);