https://gsbelarus.com:80/gs/wiki/index.php?action=history&feed=atom&title=AC_GENERALLEDGER
AC GENERALLEDGER - История изменений
2026-07-17T03:05:54Z
История изменений этой страницы в вики
MediaWiki 1.19.16
https://gsbelarus.com:80/gs/wiki/index.php?title=AC_GENERALLEDGER&diff=5660&oldid=prev
SYSDBA: Новая страница: «<syntaxhighlight lang="SQL"> CREATE TABLE AC_GENERALLEDGER ( ID DINTKEY NOT NULL, NAME DNAME NOT NULL COLLATE PXW_CYRL, DEFAULTUSE …»
2013-06-08T13:17:33Z
<p>Новая страница: «<syntaxhighlight lang="SQL"> CREATE TABLE AC_GENERALLEDGER ( ID DINTKEY NOT NULL, NAME DNAME NOT NULL COLLATE PXW_CYRL, DEFAULTUSE …»</p>
<p><b>Новая страница</b></p><div><syntaxhighlight lang="SQL"><br />
CREATE TABLE AC_GENERALLEDGER (<br />
ID DINTKEY NOT NULL,<br />
NAME DNAME NOT NULL COLLATE PXW_CYRL,<br />
DEFAULTUSE DBOOLEAN,<br />
INNCU DBOOLEAN,<br />
INCURR DBOOLEAN,<br />
NCUDECDIGITS DINTEGER_NOTNULL,<br />
NCUSCALE DINTEGER_NOTNULL,<br />
CURRDECDIGITS DINTEGER_NOTNULL NOT NULL,<br />
CURRSCALE DINTEGER_NOTNULL NOT NULL,<br />
CURRKEY DFOREIGNKEY,<br />
ACCOUNTKEY DFOREIGNKEY,<br />
ENHANCEDSALDO DBOOLEAN,<br />
EDITIONDATE DEDITIONDATE<br />
);<br />
<br />
ALTER TABLE AC_GENERALLEDGER ADD CONSTRAINT PK_AC_GENERALLEDGER<br />
PRIMARY KEY (ID);<br />
ALTER TABLE AC_GENERALLEDGER ADD CONSTRAINT FK_AC_GENERALLEDGER_ACKEY<br />
FOREIGN KEY (ACCOUNTKEY) REFERENCES AC_ACCOUNT (ID);<br />
ALTER TABLE AC_GENERALLEDGER ADD CONSTRAINT FK_AC_GENERALLEDGER_CURRKEY<br />
FOREIGN KEY (CURRKEY) REFERENCES GD_CURR (ID);<br />
<br />
CREATE UNIQUE INDEX ac_x_generalledger_name ON ac_generalledger<br />
(name);<br />
</syntaxhighlight><br />
<br />
[[Category:База данных]]</div>
SYSDBA