ÈÍÔÈÍ-Óïðàâëåíèå

Author: Óñïåíñêèé Ì Ë
Version: 3.0
Date: 

Table List
Code	Label	 
T_ACC_SETUP	Êëàññèôèêàòîð  ñ÷åòîâ ïî ïåðèîäàì	 
T_ACCOUNT	Ñïèñîê  ñ÷åòîâ	 
T_ALBUM	Àëüáîìû ñ ìàãíèòíûìè íîñèòåëÿìè	 
T_ALBUM_BRANCH	Ïóòè äëÿ àëüáîìîâ ïî ïðåäïðèÿòèÿì	 
T_ALTER_HELP	Òàáëèöà ñ àëüòåðíàòèâíûìè íîìåðàìè HELP'a	 
T_BAK_BAL	Ïðîòîêîë èçìåíåíèÿ ïðîâîäîê	 
T_BAK_CREESTR	Æóðíàëû ðåãèñòðàöèé(öèêë. ÷àñòü) - ïðòîêîë èçìåíåèé	 
T_BAK_KLS_ALL	Ñïðàâî÷íèêè - ïðòîêîë èçìåíåèé	 
T_BAK_KLS_FORM	Ïðîòîêîë èçìåíåíèÿ ôîðì îò÷åòíîñòè	 
T_BAL_0_9	Ïðîâîäêè	 
T_BAL_DEL	Òàáëèöà óäàëåííûõ îïåðàöèé	 
T_BAL_SETUP	Ïðîâîäêè-íàñòðîéêà	 
T_BARCODE	Øòðèõ-êîäû äëÿ ñïðàâî÷íèêîâ	 
T_CALC_CHANGE	Òàáëèöà âîçìîæíûõ çàìåí	 
T_CALC_IMPORT	Íàñòðîéêà èìïîðòà äëÿ ñïåöèôèêàöèé	 
T_CALC_INC	Êîëè÷åñòâåííûå âõîæäåíèÿ â êàëüê. êàðòó ïî ïîçèöèÿì	 
T_CALC_ITEM	Ïîçèöèè êàëüêóëÿöèîííûõ êàðò	 
T_CALC_LINK	Çàãîëîâêè êàëüêóëÿöèîííûõ êàðò	 
T_CALC_NONE	Îòñóòñòâóþùèå êîìïîíåíòû	 
T_COMM	Ñïðàâî÷íèê êîììåíòàðèåâ	 
T_COMPLECT	Êîìëåêòû	 
T_CONST	Òàáëèöà êîíñòàíò	 
T_CURR	Êëàññèôèêàòîð âàëþò	 
T_DBINFO	Èíôîðìàöèÿ î áàçå äàííûõ	 
T_DOKTYP	Êëàññèôèêàòîð âõîäíûõ äîêóìåíòîâ	 
T_DOKTYP_NEXT_SETUP	Ñïèñîê ïîëåé äëÿ ñáîðà æóðíàëîâ ðåãèñòðàöèè	 
T_DOKTYP_SPR	Êëàññèôèêàòîð äîï. ïîëåé æóðíàëà ðåãèñòðàöèè	 
T_ENTRY_EXEC	Ñòàòóñ âûïîëíåíèÿ îïåðàöèé	 
T_EXPERIENCE	Ñâåäåíèÿ î ñòàæå	 
T_EXPERIENCE_PFR	Ñòàæ äëÿ ÏÔÐ è ñâåäåíèÿ î ïðåä-õ ìåñòàõ ðàáîòû	 
T_EXPORT_DBF	Îïèñàíèå ñòðóêòóðû ýêñïîðòíîãî dbf ôàéëà	 
T_EXPORT_JOB	Ñïèñîê çàäàíèé íà ýêñïîðò ñïðàâ-â â dbf	 
T_EXPORT_KLS	Ñïèñîê íàñòðîåê äëÿ ýêñïîðòà ñïðàâî÷íèêîâ	 
T_EXTERNAL_TASK	Ñïèñîê âíåøíèõ çàäà÷	 
T_FILIAL	òàáëèöà ôèëèàëîâ	 
T_GLOSSARY	Ñëîâàðü òåðìèíîâ	 
T_GRAPH_CHANGES	Òàáëèöà èçìåíåíèé ãðàôèêà (íå èñïîëüçóåòñÿ)	 
T_GRAPH_DAYS	Îïèñàíèå  ãðàôèêà ðàáî÷åé íåäåëè ïî äíÿì	 
T_GROUP_USER	Ïîëüçîâàòåëè - ãðóïïû	 
T_GRP_SETUP	Íàñòðîéêà ïîëåé äëÿ òîâàðîâ ïî ãðóïïàì òîâàðîâ	 
T_HOLIDAYS	òàáëèöà îôèöèàëüíûõ ïðàçäíèêîâ	 
T_IMAGE_LIST	Ñïèñîê êàðòèíîê	 
T_ITEMLIST	Òàáëèöà çàïóñêàåìûõ êëàññîâ	 
T_JOB	Ñïèñîê çàäàíèé	 
T_JOB_JOURNAL	Æóðíàë âûïîëíåíèÿ çàäàíèÿ	 
T_KLS_ALL	Ñïðàâî÷íèêè	 
T_KLS_ALL_DEL	Óäàëåííûå çàïèñè èç ñïðàâî÷íèêîâ	 
T_KLS_CURS	Ñïðàâî÷íèê êóðñîâ	 
T_KLS_FORM	Ôîðìû îò÷åòíîñòè	 
T_KLS_FORM_BLOB	Øàáëîíû ôîðìû îò÷åòíîñòè	 
T_KLS_FORM_BRANCH	Ðàññ÷èòàííûå ôîðìû îò÷åòíîñòè	 
T_KLS_GROUP	Ñïèñîê ñïðàâî÷íèêîâ ïî ãðóïïàì	 
T_KLS_IMPORT	Èìïîðò ñïðàâî÷íèêîâ èç ïðîèçâîëüíûõ îò÷åòîâ	 
T_KLS_KLS	Êëàññèôèêàòîð ñïðàâî÷íèêîâ	 
T_KLS_OPER	Íàñòðîéêà îïåðàöèé	 
T_LAST_NUM	Òàáëèöà ïîñëåäíèõ íîìåðîâ	 
T_LIST_ACC	Íàáîðû ñ÷åòîâ äëÿ îáîð. âåäîìîñòè	 
T_LIST_DEDUCTION	Ñïèñîê âû÷åòîâ ïî ñîòðóäíèêàì	 
T_MENU	Ìåíþ	 
T_MESSAGE	Ñîîáùåíèÿ	 
T_MIN_SALARY	Òàáëèöà ìèíèìàëüíûõ çàðîáîòíûõ ïëàò	 
T_MREPORT	îò÷åòû íà ìàãíèòíûõ íîñèòåëÿõ	 
T_NALOG_SCALE	Øêàëû íàëîãîâ	 
T_NODEDATATREE	Îïèñàíèå ïðîñìîòðîâ	 
T_NSYSTEM	Íàñòðîéêà ïî çàäà÷àì	 
T_NUMB	Êîëè÷åñòâî	 
T_OPER_0_9	Îïåðàöèè	 
T_OPER_CLOSE	Íàñòðîéêà îïåðàöèé àâòîçàêðûòèÿ	 
T_OPER_COPY	Òàáëèöà äëÿ êîïèðîâàíèÿ ïðîâîäîê	 
T_OPER_DEL	Òàáëèöà óäàëåííûõ îïåðàöèé	 
T_OPER_DOC	Íàñòðîéêà äîêóìåíòîâ â îïåðàöèè	 
T_OPER_EXPORT	Òàáëèöà ñîîòâåòñòâèÿ ïðîâîäîê ýêñïîðòà	 
T_OPER_IMPORT	Íàñòðîéêà èìïîðòà ïðîâîäîê èç ïðîèçâîëüíûõ îò÷åòîâ	 
T_OPER_PRDOC	Ñïèñîê âûõîäíûõ äîêóìåíòîâ â îïåðàöèè	 
T_OPER_RECORD	Ñïèñîê çàïèñåé â îïåðàöèè	 
T_ORDER	Êëàññèôèêàòîð ðàçäåëîâ â çàäà÷àõ	 
T_ORDER_KLS_FORM	Êëàññèôèêàòîð ðàçäåëîâ îò÷åòíîñòè	 
T_ORDER_LIST_ACC	Ñïèñîê ðàçäåëîâ äëÿ îáîð.âåä ïî íàáîðó ñ÷åòîâ	 
T_ORDER_POINT	Ðàçäåëû îò÷åòíûõ ïîêàçàòåëåé	 
T_OST_0_9	Îñòàòêè	 
T_PERC_ACC	äàííûå äëÿ ðàñ÷åòà çàðïëàòû	 
T_PERC_LEAVE	äàííûå äëÿ ðàñ÷åòà îòïóñêà	 
T_PERIOD_88	Ïåðèîäû	 
T_POINT	Òàáëèöà îò÷åòíûõ ïîêàçàòåëåé	 
T_POINT_RESULT	Òàáëèöà ðàññ÷èòàííûõ îò÷åòíûõ ïîêàçàòåëåé	 
T_PRDOC_TYPE	Êëàññèôèêàòîð âûõîäíûõ äîêóìåíòîâ	 
T_PREDEF_REF	Ñïèñîê òèïîâ ïðåäîïðåäåëåííûõ ñïðàâî÷íèêîâ	 
T_PREDEF_REF_SPR	Êëàññèôèêàòîð äîï. ïîëåé ïðåäîïðåäåëåííûõ ñïðàâî÷íèêîâ	 
T_PRICE	Ïðàéñ-ëèñòû	 
T_PROJECT	Òàáëèöà ïðîåêòîâ	 
T_PROJECTTREE	Äåðåâî ïðîåêòà	 
T_PROTOCOL_LOG	Ïðîòîêîë èçìåíåííûõ çàïèñåé- äàííûå ïî ïîëüçîâàòåëþ	 
T_REESTR_DEL	Òàáëèöà óäàëåííûõ äîêóìåíòîâ	 
T_REF_SPR	Êëàññèôèêàòîð äîï. ïîëåé ñïðàâî÷íèêîâ	 
T_REG_PRINT	Òàáëèöà øàáëîíîâ âíóòð. äîêóìåíòîâ	 
T_REG_PRINT_BLOB	Òàáëèöà ðàçìåùåíèÿ øàáëîíîâ âíóòð. äîêóìåíòîâ	 
T_REG_PRINT_BRANCH	Òàáëèöà ðàññ÷èòàííûõ âíóòð. äîêóìåíòîâ	 
T_REKV	îïèñàíèå ðåêâèçèòîâ ìàãíèòíûõ íîñèòåëåé	 
T_RESERV_NUM	Òàáëèöà ðåçåðâèðîâàííûõ íîìåðîâ	 
T_RULE	ïðàâèëà äëÿ çàïèñåé îïåðàöèè	 
T_SALBOOK_ENTRY	Íàñòðîéêà æóðíàëîâ îðäåðîâ â çàðïëàòå - ïðîâîäêè	 
T_SALBOOK_LIST	Íàñòðîéêà æóðíàëîâ îðäåðîâ â çàðïëàòå - ïåðå÷èñëåíèÿ	 
T_SEMAFOR	Ñåìàôîð	 
T_SHEDULE_BACKUP	Ïëàíèðîâùèê çàäàíèé	 
T_SPR_RULE	ïðàâèëà äëÿ ïîëåé ñïðàâî÷íèêîâ	 
T_STAFF	Èñïîëíåíèí øòàòíîãî ðàñïèñàíèÿ	 
T_STAFF_DISTRIBUTION	Ðàññòàíîâêà øòàòíîãî ðàñïèñàíèÿ	 
T_STAFF_LIST	Ñïèñîê øòàòíûõ ðàñïèñàíèé	 
T_STAFF_TABLE	Øòàòíîå ðàñïèñàíèå	 
T_STATUS	Òàáëèöà ñòàòóñîâ îïåðàöèé	 
T_STEP	Ñïèñîê øàãîâ â çàäàíèè	 
T_TAB_ACCOUNT_0_9	Äàííûå òàáåëÿ (õðàíÿòñÿ ïî-êâàðòàëüíî)	 
T_TAB_IMPORT	Èìïîðò òàáåëÿ èç ïðîèçâîëüíûõ îò÷åòîâ	 
T_TASK	Êëàññèôèêàòîð çàäà÷	 
T_TASK_ENTITY	Ïåðå÷åíü ñóùíîñòåé äëÿ ðàçäåëåíèÿ ïðàâ äîñòóïà	 
T_USER_ACC	Ðàçãðàíè÷åíèå äîñòóïà ïî ñ÷åòàì	 
T_USER_DOC	Ðàçãðàíè÷åíèå äîñòóïà ïî ðååñòðàì äîêóìåíòîâ	 
T_USER_ENTITY	Ðàçãðàíè÷åíèå äîñòóïà ïî ñóùíîñòÿì	 
T_USER_INSIDE	Òàáëèöà ðàáîòàþùèõ ïîëüçîâàòåëåé ïî çàäà÷àì	 
T_USER_KLS	Ðàçãðàíè÷åíèå äîñòóïà ïî ñïðàâî÷íèêàì	 
T_USER_KLSALL	Ðàçãðàíè÷åíèå äîñòóïà ïî çàïèñÿì ñïðàâî÷íèêà	 
T_USER_KLSFORM	Ïðàâà äîñòóðà íà ôîðìû îò÷åòíîñòè	 
T_USER_ORDERFORM	Ïðàâà äîñòóðà íà ðàçäåëû ôîðì îò÷åòíîñòè	 
T_USER_PT	Ðàçãðàíè÷åíèå äîñòóïà ïî ðåæèìàì	 
T_USER_VID	Âèäû äåÿòåëüíîñòè ïî þçåðàì	 
T_USERS_BLOB	Òàáëèöà èíäèâèäóàëüíûõ íàñòðîåê	 
T_VID	Âèäû äåÿòåëüíîñòè	 

T_acc_setup
Column List
Code	Type	P	M	Label	 
ACC_NUM	varchar(21)	Yes	Yes	íîìåð á/ñ÷åòà	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ACC_PERIOD_BEG	datetime	Yes	Yes	Íà÷àëî äåéñòâèÿ íàñðîéêè	 
ACC_PERIOD_END	datetime	No	No	Êîíåö äåéñòâèÿ íàñðîéêè	 
ACC_NAME	varchar(250)	No	No	íàèìåíîâàíèå á/ñ÷åòà	 
ACC_TYPE	numeric(2)	No	Yes	òèï á/ñ÷åòà(áàë,çàáàë,ñëóæåáíûé)	 
ACC_CURR	numeric(1)	No	Yes	ïðèçíàê ó÷åòà âàëþòû íà á/ñ÷åòå	 
ACC_NUMB	numeric(1)	No	No	ïðèçíàê ó÷åòà êîë-âà íà á/ñ÷åòå	 
ACC_DEF_TYPE	numeric(2)	No	Yes	ïðåäîïðåäåë.òèï ñ÷åòà(çàðïëàòíûé,òîâàðû è ò.ï.)	 
ACC_AN1	int	No	No	íîìåð ñïðàâî÷íèêà	 
ACC_AN2	int	No	No	íîìåð ñïðàâî÷íèêà	 
ACC_AN3	int	No	No	íîìåð ñïðàâî÷íèêà	 
ACC_AN4	int	No	No	íîìåð ñïðàâî÷íèêà	 
ACC_AN5	int	No	No	íîìåð ñïðàâî÷íèêà	 
ACC_AN6	int	No	No	íîìåð ñïðàâî÷íèêà	 
ACC_AN7	int	No	No	íîìåð ñïðàâî÷íèêà	 
ACC_USER_ID	char(32)	No	No	êòî ìîíîïîëüíî ðàáîòàåò ñ äàííûì ñ÷åòîì	 
ACC_VID	numeric(1)	No	No	âèä äåÿòåëüíîñòè (äëÿ áþäæåòíîé á-ðèè)	 
ACC_TURN_LEVEL	numeric(1)	No	No	Óðîâåíü ðàçâîðîòà ñàëüäî	 
ACC_FULLNAME	varchar(250)	No	No	ïîëíîå íàèìåíîâàíèå ñ÷åòà (äëÿ áþäæåòêè)	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 

T_account
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ACC_NUM	varchar(21)	Yes	Yes	íîìåð á/ñ÷åòà	 

T_album
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ãðóïïû çàäà÷	 
PERIOD	datetime	Yes	Yes	ïåðèîä íà÷àëà ÓÏ	 
ALBUM_NUM	int	Yes	Yes	íîìåð àëüáîìà	 
ALBUM_NAME	varchar(60)	No	No	íàèìåíîâàíèå àëüáîìà	 
ALBUM_CP	int	No	No	êîäîâàÿ ñòðàíèöà	 
ALBUM_INFO	text	No	No	Èíôîðìàöèÿ	 
ALBUM_OUTPUT	numeric(1)	No	No	âûâîäèòü (1-òîëüêî â ôàéë, 2 - â ôàéë è íà ýêðàí)	 
ALBUM_FILE	text	No	No	èìÿ ôàéëà (ôîðìóëà)	 
ALBUM_BLOB_BEG	image	No	No	øàáëîí øàïêè ôàéëà	 
ALBUM_BLOB_END	image	No	No	øàáëîí ïîäâàëà ôàéëà	 

T_album_branch
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ãðóïïû çàäà÷	 
PERIOD	datetime	Yes	Yes	ïåðèîä íà÷àëà ÓÏ	 
ALBUM_NUM	int	Yes	Yes	íîìåð àëüáîìà	 
BRANCH	numeric(9)	Yes	Yes	Ïðåäïðèÿòèå	 
ALBUM_PATH	text	No	No	äèðåêòîðèÿ äëÿ âûõîäíûõ ôàéëîâ	 
ALBUM_LAST_NUM	int	No	No	Ïîñëåäíèé íîìåð ôàéëà	 

T_alter_help
Column List
Code	Type	P	M	Label	 
PT_ID	numeric(9)	Yes	Yes	àâòîèíêðåìåíòíîå ïîëå	 
ITEM_CODE	int	Yes	Yes	íîìåð êëàññà	 
HELP_ID	int	No	No	òîïèê HELP'à	 
HELP_FILE	varchar(60)	No	No	èìÿ help-ôàéëà áåç ïóòè  è ðàñøèðåíèÿ	 

T_bak_Bal
Column List
Code	Type	P	M	Label	 
OPER_IDENT	char(26)	Yes	Yes	óíèêàëüíûé íîìåð îïåðàöèè	 
ENTRY_NUM	int	Yes	Yes	íîìåð ïðîâîäêå â íàñòðîéêå	 
BAL_NN	int	Yes	Yes	N ïðîâîäêè â îïåðàöèè	 
PROTOCOL_DATE	datetime	Yes	Yes	äàòà è âðåìÿ èçìåíåíèÿ	 
DT	varchar(21)	No	No	Äò	 
DT_AN1	numeric(9)	No	No	Àíàëèòèêà 1 óð. Äò	 
DT_AN2	numeric(9)	No	No	Àíàëèòèêà 2 óð. Äò	 
DT_AN3	numeric(9)	No	No	Àíàëèòèêà 3 óð. Äò	 
DT_AN4	numeric(9)	No	No	Àíàëèòèêà 4 óð. Äò	 
DT_AN5	numeric(9)	No	No	Àíàëèòèêà 5 óð. Äò	 
DT_AN6	numeric(9)	No	No	Àíàëèòèêà 6 óð. Äò	 
DT_AN7	numeric(9)	No	No	Àíàëèòèêà 7 óð. Äò	 
KT	varchar(21)	No	No	Êò	 
KT_AN1	numeric(9)	No	No	Àíàëèòèêà 1 óð. Êò	 
KT_AN2	numeric(9)	No	No	Àíàëèòèêà 2 óð. Êò	 
KT_AN3	numeric(9)	No	No	Àíàëèòèêà 3 óð. Êò	 
KT_AN4	numeric(9)	No	No	Àíàëèòèêà 4 óð. Êò	 
KT_AN5	numeric(9)	No	No	Àíàëèòèêà 5 óð. Êò	 
KT_AN6	numeric(9)	No	No	Àíàëèòèêà 6 óð. Êò	 
KT_AN7	numeric(9)	No	No	Àíàëèòèêà 7 óð. Êò	 
ENTRY_DATE	datetime	No	No	äàòà äîêóìåíòà	 
OPER_DATE	datetime	No	No	ïåðèîä ðåãèñòàöèè äîêóìåíòà	 
SUMMA	numeric(19,2)	No	No	ñóììà	 
CURR_SUMMA	numeric(19,2)	No	No	ñóììà â âàëþòå	 
CURR_NUM	int	No	No	íîìåð âàëþòû	 
PRICE	numeric(19,7)	No	No	öåíà	 
CURR_KURS	numeric(19,10)	No	No	êóðñ âûëþòû	 
DOC	varchar(30)	No	No	äîêóìåíò	 
QUANTITY1	numeric(19,7)	No	No	êîëè÷åñòâî 1	 
QUANTITY2	numeric(19,7)	No	No	êîëè÷åñòâî 2	 
QUANTITY3	numeric(19,7)	No	No	êîëè÷åñòâî 3	 
COMENT	varchar(250)	No	No	êîììåíòàðèé	 
FILIAL_NUM	char(2)	No	No	ôèëèàë-ñîçäàòåëü	 
TASK_NUM	int	No	No	íîìåð çàäà÷è	 
ORDER_NUM	int	No	No	íîìåð ðàçäåëà	 
VID_NUM	int	No	No	âèä äåÿòåëüíîñòè	 
DOC_DIGIT_NUM	numeric(20)	No	No	íîìåð äîêóìåíòà â âèäå ÷èñëà	 
B_ENTRY_NUM	int	No	No	íîìåð ñâÿçàííîé ïðîâîäêè (äëÿ áþäæåòêè - ïåðâàÿ çàïèñü)	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	No	íîìåð ïîëüçîâàòåëÿ	 
BRANCH	numeric(9)	No	No	ïðåäïðèÿòèå	 
PERIOD	datetime	No	No	ïåðèîä	 
DOKTYP_ID	int	No	No	òèï äîêóìåíòà	 
STATUS_NUM	int	No	No	ñòàòóñ çàïèñè	 
PROTOCOL_TYPE	numeric(1)	No	No	òèï çàïèñè â ïðîòîêîëå (0 - êîððåêòèðîâêà, 1-óäàëåíèå)	 
PROTOCOL_LOGIN	varchar(60)	No	No	ñèñòåìíîå èìÿ ïîëüçîâàòåëÿ	 
PROTOCOL_HOST	varchar(250)	No	No	èìÿ õîñò-ìàøèíû	 

T_bak_creestr
Column List
Code	Type	P	M	Label	 
PROTOCOL_ID	numeric(9)	Yes	Yes	óíèêàëüíûé èäåíòèôèêàòîð	 
DOKTYP_ID	int	Yes	Yes	íîìåð æóðíàëà ðåãèñòðàöèé	 
CREGIST_ID	numeric(9)	Yes	Yes		 
REGSPR_ALIAS	varchar(20)	Yes	Yes	ïîëüçîâàòåëüñêîå óñë.îáîçíà÷åíèå	 
REGIST_NUM	char(20)	No	Yes	íîìåð äîêóìåíòà	 
REGIST_PERIOD	datetime	No	Yes	ïåðèîä ðåãèñòðàöèè äîêóìåíòà	 
BRANCH	numeric(9)	No	Yes	ïðåäïðèÿòèå	 
REGSPR_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå ïîëÿ äîêóìåíòà	 
PROJECT_NUM	int	No	No	íîìåð ïðîåêòà	 
PROTOCOL_OLD	varchar(100)	No	No	ñòàðîå çíà÷åíèå ïîëÿ	 
PROTOCOL_NEW	varchar(100)	No	No		 
REGSPR_TYPE	char(2)	No	No	Òèï ïîëÿ	 
REGSPR_TYPELEN	numeric(3)	No	No	Êîë-âî ñèìâîëîâ (äëèíà)	 
REGSPR_TYPELEN2	numeric(2)	No	No	Êîë-âî ñèìâîëîâ ïîñëå çàïÿòîé	 

T_bak_kls_all
Column List
Code	Type	P	M	Label	 
KLS_ID	numeric(9)	Yes	Yes	id çíà÷åíèÿ ñïðàâî÷íèêà	 
PROTOCOL_DATE	datetime	Yes	Yes	âðåìÿ èçìåíåèÿ	 
KLS_END	datetime	No	No	äàòà âûáûòèÿ	 
KLS_NUM	varchar(20)	No	No	ïîëüçîâàòåëüñêèé íîìåð	 
KLS_NAME	varchar(60)	No	No	íàèìåíîâàíèå	 
KLS_DIGIT_NUM	numeric(20)	No	No	Íîìåð ïðåäñòàâëåííûé êàê ÷èñëî	 
FILIAL_NUM	char(2)	No	No	ôèëèàë-ñîçäàòåëü	 
BRANCH	numeric(9)	No	No	ïðåäïðèÿòèå	 
NUMB_ID	int	No	No	ññûëêà íà åäèíèöó èçìåðåíèÿ	 
NUMB_ID2	int	No	No	ññûëêà íà âòîðóþ åäèíèöó èçìåðåíèÿ	 
FILIAL_USER	char(2)	No	No	ôèëèàë ïîëüçîâàòåëÿ	 
USER_ID	char(32)	No	No	ïîëüçîâàòåëü	 
PAR_ID	numeric(9)	No	No	ññûëêà íà ðîäèòåëÿ	 
KLSREF_NUM	int	No	No	íîìåð ñïðàâî÷íèêà	 
PROTOCOL_TYPE	numeric(1)	No	No	òèï çàïèñè â ïðîòîêîëå (0 - êîððåêòèðîâêà, 1-óäàëåíèå)	 
PROTOCOL_LOGIN	varchar(60)	No	No	ñèñòåìíîå èìÿ ïîëüçîâàòåëÿ	 
PROTOCOL_HOST	varchar(250)	No	No	èìÿ õîñò-ìàøèíû	 

T_bak_kls_form
Column List
Code	Type	P	M	Label	 
KEY_MENU	varchar(60)	Yes	Yes	ïîëíûé ïóòü ê ïóíêòó ìåíþ	 
ORDER_NUM	int	Yes	Yes	id ðàçäåëà	 
PERIOD	datetime	Yes	Yes	ïåðèîä íà÷àëà ÓÏ	 
KLSFORM_NUM	char(20)	Yes	Yes	íîìåð	 
PROTOCOL_DATE	datetime	Yes	Yes	äàòà ïðîòîêîëà	 
KLSFORM_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå	 
KLSFORM_DIGIT_NUM	numeric(20)	No	No	ïîëüçîâàòåëüñêèé íîìåð â ÷èñëîâîì âèäå	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 
KLSFORM_BLOB	image	No	No	øàáëîí ïåðâîíà÷àëüíîé íàñòðîéêè	 
BLOB_PARAMS	text	No	No	ïàðàìåòðû øàáëîíà	 
PROTOCOL_TYPE	numeric(1)	No	No	òèï çàïèñè â ïðîòîêîëå (0 - êîððåêòèðîâêà, 1-óäàëåíèå)	 
PROTOCOL_LOGIN	varchar(60)	No	No	ñèñòåìíîå èìÿ ïîëüçîâàòåëÿ	 
PROTOCOL_HOST	varchar(250)	No	No		 
PROTOCOL_MARK_DATE	char(30)	No	Yes	äàòà ïðîòîêîëà â ôîðìàòå 109 äëÿ âûáîðà	 

T_Bal_0_9
Column List
Code	Type	P	M	Label	 
OPER_IDENT	char(26)	Yes	Yes	óíèêàëüíûé èä. îïåðàöèè	 
ENTRY_NUM	int	Yes	Yes	íîìåð ïðîâîäêå â íàñòðîéêå	 
BAL_NN	int	Yes	Yes	N ïðîâîäêè â îïåðàöèè	 
CURR_NUM	int	No	No	íîìåð âàëþòû	 
PERIOD	datetime	No	No	Ïåðèîä - ïåðâîå ÷èñëî ìåñÿöà	 
ENTRY_DATE	datetime	No	No	äàòà äîêóìåíòà	 
OPER_DATE	datetime	No	No	ïåðèîä ðåãèñòàöèè äîêóìåíòà	 
SUMMA	numeric(19,2)	No	Yes	ñóììà	 
CURR_SUMMA	numeric(19,2)	No	No	ñóììà â âàëþòå	 
CURR_KURS	numeric(19,10)	No	No	êóðñ âàëþòû	 
DOC	varchar(30)	No	No	äîêóìåíò	 
QUANTITY1	numeric(19,7)	No	No	êîëè÷åñòâî 1	 
QUANTITY2	numeric(19,7)	No	No	êîëè÷åñòâî 2	 
QUANTITY3	numeric(19,7)	No	No	êîëè÷åñòâî 3	 
COMENT	varchar(250)	No	No	êîììåíòàðèé	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
DT_AN1	numeric(9)	No	Yes	Àíàëèòèêà 1 óð. Äò	 
DT_AN2	numeric(9)	No	Yes	Àíàëèòèêà 2 óð. Äò	 
DT_AN3	numeric(9)	No	Yes	Àíàëèòèêà 3 óð. Äò	 
DT_AN4	numeric(9)	No	Yes	Àíàëèòèêà 4 óð. Äò	 
DT_AN5	numeric(9)	No	Yes	Àíàëèòèêà 5 óð. Äò	 
DT_AN6	numeric(9)	No	Yes	Àíàëèòèêà 6 óð. Äò	 
DT_AN7	numeric(9)	No	Yes	Àíàëèòèêà 7 óð. Äò	 
KT_AN1	numeric(9)	No	Yes	Àíàëèòèêà 1 óð. Êò	 
KT_AN2	numeric(9)	No	Yes	Àíàëèòèêà 2 óð. Êò	 
KT_AN3	numeric(9)	No	Yes	Àíàëèòèêà 3 óð. Êò	 
KT_AN4	numeric(9)	No	Yes	Àíàëèòèêà 4 óð. Êò	 
KT_AN5	numeric(9)	No	Yes	Àíàëèòèêà 5 óð. Êò	 
KT_AN6	numeric(9)	No	Yes	Àíàëèòèêà 6 óð. Êò	 
KT_AN7	numeric(9)	No	Yes	Àíàëèòèêà 7 óð. Êò	 
DT	varchar(21)	No	No	Äò	 
KT	varchar(21)	No	No	Êò	 
DOKTYP_ID	int	No	Yes	id  òèïà äîê-òà	 
SEND	numeric(1)	No	No	èçìåíåíà ëè çàïèñü (äëÿ êîðïîð. Null-äà)	 
CREAT_DATE	datetime	No	Yes	äàòà ñîçäàíèÿ (ñëóæåáíàÿ)	 
PRICE	numeric(19,7)	No	No	öåíà	 
FILIAL_NUM	char(2)	No	Yes	ôèëèàë-ñîçäàòåëü	 
TASK_NUM	int	No	No	íîìåð çàäà÷è	 
ORDER_NUM	int	No	No	íîìåð ðàçäåëà	 
DOC_DIGIT_NUM	numeric(20)	No	No	íîìåð äîêóìåíòà â âèäå ÷èñëà	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	No	íîìåð ïîëüçîâàòåëÿ	 
B_ENTRY_NUM	int	No	No	íîìåð ñâÿçàííîé ïðîâîäêè (äëÿ áþäæåòêè - ïåðâàÿ çàïèñü)	 
VID_NUM	int	No	No	âèä äåÿòåëüíîñòè	 
BRANCH	numeric(9)	No	No	ïðåäïðèÿòèå	 
STATUS_NUM	int	No	No	Ñòàòóñ çàïèñè	 
CARGO	varchar(250)	No	No	äîïîëíèòåëüíîå ïîëå	 

T_Bal_del
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ãðóïïû çàäà÷	 
OPER_IDENT	char(26)	Yes	Yes	èäåíòèôèêàòîð îïåðàöèè	 
ENTRY_NUM	int	Yes	Yes	íîìåð ïðîâîäêè â íàñòðîéêå	 
BAL_NN	int	Yes	Yes	íîìåð ïðîâîäêè â îïåðàöèè	 
SEND	numeric(1)	No	No	èçìåíåíà ëè çàïèñü (äëÿ êîðïîð. Null-äà)	 

T_Bal_setup
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
ENTRY_NUM	int	Yes	Yes	íîìåð çàïèñè	 
AUTO_ENTRY_OUTPUT	numeric(1)	No	No	ïå÷àòü ïîñëå àâòîïðîâîäêè	 
S_ENTRY_DATE	varchar(30)	No	No	ô-öèÿ ðàñ÷åòà äàòû äîêóìåíòà	 
N_ENTRY_DATE	varchar(20)	No	No	íàèìåíîâàíèå äàòû ïðîâîäêè	 
S_OPER_DATE	varchar(30)	No	No	ô-öèÿ ðàñ÷åòà äàòû îïåðàöèè	 
N_OPER_DATE	varchar(20)	No	No	íàèìåíîâàíèå äàòû îïåðàöèè	 
S_SUMMA	text	No	No	ô-öèÿ ðàñ÷åòà ñóììû	 
N_SUMMA	varchar(20)	No	No	íàèìåíîâàíèå ñóììû	 
S_PRICE	text	No	No	ô-öèÿ ðàñ÷åòà öåíû	 
N_PRICE	varchar(20)	No	No	íàèìåíîâàíèå öåíû	 
S_CURR_PRICE	text	No	No	ô-öèÿ ðàñ÷åòà öåíû â âàëþòå	 
N_CURR_PRICE	varchar(20)	No	No	íàèìåíîâàíèå  âàëþòíîé ñóììû	 
S_CURR_NUM	varchar(30)	No	No	ô-öèÿ ðàñ÷åòà íîìåðà âëþòû	 
N_CURR_NUM	varchar(20)	No	No	íàèìåíîâàíèå íîìåðà âàëþòû	 
S_CURR_SUMMA	text	No	No	ô-öèÿ ðàñ÷åòà ñóììû â âàëþòå	 
N_CURR_SUMMA	varchar(20)	No	No	íàì. âàë. ïåðåìåííîé	 
S_CURR_KURS	text	No	No	ô-öèÿ ðàñ÷åòà êóðñà âàëþòû	 
N_CURR_KURS	varchar(20)	No	No	íàèìåíîâàíèå âàë. êóðñà	 
S_DOC	varchar(30)	No	No	ô-öèÿ ðàñ÷åòà íîìåðà äîêóìåíòà	 
N_DOC	varchar(20)	No	No	íàèìåíîâàíèå äîêóìåíòà	 
S_DOKTYP_ID	varchar(30)	No	No	ô-öèÿ ðàñ÷åòà òèïà äîêóìåíòà	 
N_DOKTYP_ID	varchar(20)	No	No	íàèìåíîâàíèå òèïà äîê-òà	 
S_QUANTITY1	text	No	No	ô-öèÿ ðàñ÷åòà êîëè÷åñòâà 1	 
N_QUANTITY1	varchar(20)	No	No	íàèìåíîâàíèå êîë-âî	 
S_QUANTITY2	text	No	No	ô-öèÿ ðàñ÷åòà êîëè÷åñòâà 2	 
N_QUANTITY2	varchar(20)	No	No	íàèìåíîâàíèå êîë-âî 2	 
S_COMENT	text	No	No	ô-öèÿ ðàñ÷åòà êîììåíòàðèÿ	 
N_COMENT	varchar(20)	No	No	íàèìåíîâàíèå êîììåíòàðèÿ	 
BLABEL	numeric(2)	No	Yes	ô-öèÿ ðàñ÷åòà ×Ì	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
S_DT	varchar(21)	No	No	äåáåò	 
N_DT	varchar(20)	No	No	íàèìåíîâàíèå Äò	 
S_KT	varchar(21)	No	No	Êðåäèò	 
N_KT	varchar(20)	No	No	íàèìåíîâàíèå Êò	 
S_DT_AN1	text	No	No	ô-ëà àíàëèòèêè Äò 1	 
S_DT_AN2	text	No	No	ô-ëà àíàëèòèêè Äò 2	 
S_DT_AN3	text	No	No	ô-ëà àíàëèòèêè Äò 3	 
S_DT_AN4	text	No	No	ô-ëà àíàëèòèêè Äò 4	 
S_DT_AN5	text	No	No	ô-ëà àíàëèòèêè Äò 5	 
S_DT_AN6	text	No	No	ô-ëà àíàëèòèêè Äò 6	 
S_DT_AN7	text	No	No	ô-ëà àíàëèòèêè Äò 7	 
S_KT_AN1	text	No	No	ô-ëà àíàëèòèêè Êò 1	 
S_KT_AN2	text	No	No	ô-ëà àíàëèòèêè Êò 2	 
S_KT_AN3	text	No	No	ô-ëà àíàëèòèêè Êò 3	 
S_KT_AN4	text	No	No	ô-ëà àíàëèòèêè Êò 4	 
S_KT_AN5	text	No	No	ô-ëà àíàëèòèêè Êò 5	 
S_KT_AN6	text	No	No	ô-ëà àíàëèòèêè Êò 6	 
S_KT_AN7	text	No	No	ô-ëà àíàëèòèêè Êò 7	 
N_DT_AN1	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Äò 1	 
N_DT_AN2	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Äò 2	 
N_DT_AN3	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Äò 3	 
N_DT_AN4	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Äò 4	 
N_DT_AN5	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Äò 5	 
N_DT_AN6	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Äò 6	 
N_DT_AN7	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Äò 7	 
N_KT_AN1	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Êò 1	 
N_KT_AN2	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Êò 2	 
N_KT_AN3	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Êò 3	 
N_KT_AN4	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Êò 4	 
N_KT_AN5	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Êò 5	 
N_KT_AN6	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Êò 6	 
N_KT_AN7	varchar(40)	No	No	íàèìåíîâàíèå àíàëèòèêè Êò 7	 
S_SIGNED	varchar(30)	No	No	ô-öèÿ âèäèìîñòè â îñíîâíîé çàäà÷å	 
N_MAIN_BLOCK	varchar(20)	No	Yes	Íàèìåíîâàíèå ïåðâîãî áëîêà	 
N_DT_AN_BLOCK	varchar(20)	No	No	íàèìåíîâàíèå áëîêà Äò	 
N_KT_AN_BLOCK	varchar(20)	No	No	íàèìåíîâàíèå áëîêà Êò	 
N_PARAM_BLOCK	varchar(20)	No	No	íàèìåíîâàíèå áëîêà ïàðàìåòðîâ	 
PROPERTY	text	No	No	óïàêîâàííûå ïàðàìåòðû	 
ENTRY_TYPE	int	No	No	òèï ïðîâîäêè (íàïðèìåð ÊÏÏ)	 
S_BLOCK_POSITION	char(5)	No	No	Ïîðÿäîê Äò-Êò	 
ALTER_ORDER_NUM	text	No	No	Àëüòåðíàòèâíûé íîìåð ðàçäåëà	 

T_barcode
Column List
Code	Type	P	M	Label	 
KLSREF_NUM	int	Yes	Yes	íîìåð ñïðàâî÷íèêà	 
BARCODE_NUM	varchar(20)	Yes	Yes	íîìåð øòðèõ-êîäà	 
BARCODE_NAME	varchar(60)	No	No	íàèìåíîâàíèå øòðèõ-êîäà	 
BARCODE_ID	char(32)	No	Yes	guid äëÿ äîáàâëåíèÿ	 
KLS_ID	numeric(9)	No	No	id çíà÷åíèÿ ñïðàâî÷íèêà	 
BARCODE_QUANTITY	numeric(10,3)	No	No	êîëè÷åñòâî åäèíèö â óïàêîâêå	 

t_calc_change
Column List
Code	Type	P	M	Label	 
CALC_CHANGE_ID	numeric(9,0)	Yes	Yes	Èäåíòèôèêàòîð çàïèñè id	 
ITEM	int	No	Yes	Íîìåð çàìåíû	 
PERIOD_BEG	datetime	No	No	Íà÷àëî äåéñòâèÿ	 
PERIOD_END	datetime	No	No	Îêîí÷àíèå äåéñòâèÿ	 
QUANTITY	numeric(19,7)	No	No	Çàìåíÿåìîå êîëè÷åñòâî	 
QUANTITY_CHANGE	numeric(19,7)	No	No	Çàìåíÿþùåå êîëè÷åñòâî	 
COMENT	varchar(250)	No	No	Êîììåíòàðèé	 
INPUT_DATE	datetime	No	No	Äàòà ïîñëåäíåé êîððåêòèðîâêè	 
USER_ID	varchar(20)	No	No	Ïîëüçîâàòåëü	 
KLS_ID_CHANGE	numeric(9)	No	No	Çàìåíÿþùèé êîìïîíåíò	 
KLS_ID	numeric(9)	No	No	id çíà÷åíèÿ ñïðàâî÷íèêà	 
FILIAL_NUM	char(2)	No	No	ôèëèàë ñîçäàòåëü	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 
T_K_KLS_ID	numeric(9)	No	No	id çíà÷åíèÿ ñïðàâî÷íèêà	 

T_CALC_IMPORT
Column List
Code	Type	P	M	Label	 
S_KLSREF_SPEC	text	No	No	Íîìåð ñïðàâî÷íèêà ñïåöèôèêàöèé (ôîðìóëà)	 
S_KLSREF_NUM	text	No	No	Íîìåð ñïðàâî÷íèêà êîìïîíåíòà (ôîðìóëà)	 
S_SPEC	text	No	No	Êîä ñïåöèôèêàöèè (ôîðìóëà)	 
S_ITEM	text	No	No	Íîìåð ï/ï (ôîðìóëà)	 
S_KLS_NUM	text	No	No	Êîä êîìïîíåíòà (ôîðìóëà)	 
S_SPEC_NUM	text	No	No	Êîä ñïåöèôèêàöèè êîìïîíåíòà (ôîðìóëà)	 
S_EXPENSE	text	No	No	Êîä ñòàòüè çàòðàò (ôîðìóëà)	 
S_QUANTITY	text	No	No	Êîëè÷åñòâî (ôîðìóëà)	 
S_CATHEGORY	text	No	No	Êîä êàòåãîðèè (ôîðìóëà)	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
ENTRY_NUM	int	Yes	Yes	íîìåð çàïèñè	 

t_calc_inc
Column List
Code	Type	P	M	Label	 
CALC_INC_ID	numeric(9,0)	Yes	Yes	Èäåíòèôèêàòîð çàïèñè id	 
CATHEGORY_ID	numeric(9)	No	No	Êîä êàòåãîðèè (ì.á. ïóñòûì)	 
BRUTTO	numeric(19,7)	No	Yes	Âõîä (áðóòòî)	 
NETTO	numeric(19,7)	No	Yes	Âûõîä (íåòòî)	 
INPUT_DATE	datetime	No	No	Äàòà ïîñëåäíåé êîððåêòèðîâêè	 
USER_ID	varchar(20)	No	No	Ïîëüçîâàòåëü	 
CALC_ITEM_ID	numeric(9)	No	No	Èäåíòèôèêàòîð çàïèñè id	 
FILIAL_NUM	char(2)	No	No	ôèëèàë ñîçäàòåëü	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 

t_calc_item
Column List
Code	Type	P	M	Label	 
CALC_ITEM_ID	numeric(9)	Yes	Yes	Èäåíòèôèêàòîð çàïèñè id	 
ITEM	int	No	No	Íîìåð ïî ïîðÿäêó	 
SUBITEM	int	No	No	Ïîðÿäîê âíóòðè Íîìåðà ï/ï (ìèíèì. - îñíîâíàÿ çàïèñü)	 
S_SUMMA	datetime	No	No	Ôîðìóëà äëÿ ðàñ÷åòà ñóììû	 
INPUT_DATE	datetime	No	No	Äàòà ïîñëåäíåé êîððåêòèðîâêè	 
USER_ID	varchar(20)	No	No	Ïîëüçîâàòåëü	 
CALC_ID	numeric(9)	No	Yes	Ññûëêà íà ñïåöèôèêàöèþ	 
EXPENSE_ID	numeric(9)	No	No	Ññûëêà íà ñòàòüþ çàòðàò	 
SPEC_ID	numeric(9)	No	No	Ññûëêà íà ñïåöèôèêàöèþ êîìïîíåíòà	 
NOT_CALC	char(1)	No	No	Ïðèçíàê: íå ðàññ÷èòûâàòü	 
T_C_CALC_ID	numeric(9)	No	No	Èäåíòèôèêàòîð çàïèñè id	 
KLS_ID	numeric(9)	No	No	id çíà÷åíèÿ ñïðàâî÷íèêà	 
FILIAL_NUM	char(2)	No	No	ôèëèàë ñîçäàòåëü	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 

t_calc_link
Column List
Code	Type	P	M	Label	 
CALC_ID	numeric(9,0)	Yes	Yes	Èäåíòèôèêàòîð çàïèñè id	 
TYPE	char(1)	No	Yes	Òèï çàïèñè (0- îñíîâíàÿ / 1 - âðåìåííàÿ çàìåíà)	 
PERIOD_BEG	datetime	No	No	Íà÷àëî äåéñòâèÿ	 
PERIOD_END	datetime	No	No	Îêîí÷àíèå äåéñòâèÿ	 
CALC_NUM	varchar(60)	No	No	Íîìåð êàðòû	 
NAME	varchar(60)	No	No	Íàèìåíîâàíèå	 
QUANTITY	numeric(19,7)	No	Yes	Ðàçìåð èçãîòàâëèâàåìîé ïàðòèè	 
COMENT	text	No	No	Êîììåíòàðèé	 
INPUT_DATE	datetime	No	No	Äàòà êîððåêòèðîâêè	 
USER_ID	varchar(20)	No	No	Ïîëüçîâàòåëü	 
FILIAL_NUM	char(2)	No	No	Íîìåð ôèëèàëà	 
FILIAL_USER	char(2)	No	No	Ïîëüçîâàòåëü ôèëèàëà	 
CALC_DIGIT_NUM	numeric(20)	No	No	÷èñëîâîå ïðåäñòàâëåíèå íîìåðà	 
KLS_ID	numeric(9)	No	No	id çíà÷åíèÿ ñïðàâî÷íèêà	 

t_calc_none
Column List
Code	Type	P	M	Label	 
CALC_NONE_ID	numeric(9,0)	Yes	Yes	Èäåíòèôèêàòîð çàïèñè id	 
PERIOD_BEG	datetime	No	No	Íà÷àëî äåéñòâèÿ	 
PERIOD_END	datetime	No	No	Îêîí÷àíèå äåéñòâèÿ	 
QUANTITY	numeric(19,7)	No	No	Çàìåíÿåìîå êîëè÷åñòâî	 
QUANTITY_CHANGE	numeric(19,7)	No	No	Çàìåíÿþùåå êîëè÷åñòâî	 
COMENT	varchar(250)	No	No	Êîììåíòàðèé	 
INPUT_DATE	datetime	No	No	Äàòà ïîñëåäíåé êîððåêòèðîâêè	 
USER_ID	varchar(20)	No	No	Ïîëüçîâàòåëü	 
S_FORMULA	varchar(250)	No	No	Ôîðìóëà ðàñ÷åòà	 
KLS_ID_CHANGE	numeric(9)	No	No	Çàìåíÿþùèé êîìïîíåíò	 
KLS_ID	numeric(9)	No	No	id çíà÷åíèÿ ñïðàâî÷íèêà	 
FILIAL_NUM	char(2)	No	No	ôèëèàë ñîçäàòåëü	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 
T_K_KLS_ID	numeric(9)	No	No	id çíà÷åíèÿ ñïðàâî÷íèêà	 

T_comm
Column List
Code	Type	P	M	Label	 
COMM_NUM	int	Yes	Yes	íîìåð êîììåíòàðèÿ	 
COMM_NAME	text	No	No	íàèìåíîâàíèå êîììåíòàðèÿ (ìîæåò áûòü ôîðìóëà)	 

T_COMPLECT
Column List
Code	Type	P	M	Label	 
KLS_ID	numeric(9)	Yes	Yes	ID òîâàðà, ÿâëÿþùåãîñÿ êîìïëåêòîì	 
KLS_NUM_ITEM	int	Yes	Yes	ïîðÿäêîâûé íîìåð â êîìëåêòå	 
KLS_ID_ITEM	numeric(9)	No	Yes	ID òîâàðà, âõîäÿùåãî â êîìïëåêò	 
KLS_UPAK	numeric(9)	No	No	ID óïàêîâêè	 
QUANTITY_UPAK1	numeric(19,7)	No	No	Êîëè÷åñòâî óïàêîâîê êîìïëåêòàöèè	 
QUANTITY1	numeric(19,7)	No	No	Êîëè÷åñòâî êîìïëåêòàöèè	 
PRICE1	numeric(19,2)	No	No	Öåíà êîìïëåêòàöèè	 
SUMMA1	numeric(19,2)	No	No	Ñóììà êîìïëåêòàöèè	 
QUANTITY_UPAK2	numeric(19,7)	No	No	Êîëè÷åñòâî óïàêîâîê ðàçóêîìïëåêòàöèè	 
QUANTITY2	numeric(19,7)	No	No	Êîëè÷åñòâî ðàçóêîìïëåêòàöèè	 
PRICE2	numeric(19,2)	No	No	Öåíà ðàçóêîìïëåêòàöèè	 
SUMMA2	numeric(19,2)	No	No	Ñóììà ðàçóêîìïëåêòàöèè	 

T_const
Column List
Code	Type	P	M	Label	 
CONST_ALIAS	char(15)	Yes	Yes	óñëîâíîå îáîçíà÷åíèå	 
CONST_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå êîíñòàíòû	 
CONST_VALUE	varchar(250)	No	Yes	Çíà÷åíèå	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
CONST_TYPE	numeric(1)	No	Yes	òèï êîíñòàíòû (0-ñòðîêà,1-÷èñëî,2-äàòà)	 
PROJECT_NUM	int	No	No	íîìåð ïðîåêòà	 

T_curr
Column List
Code	Type	P	M	Label	 
CURR_NUM	int	Yes	Yes	íîìåð âàëþòû	 
CURR_SHNAME	char(5)	No	Yes	êðàòêîå íàèì-èå âàëþòû	 
CURR_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå âàëþòû	 
CURR_WIDTH	numeric(2)	No	Yes	øèðèíà êóðñà	 
CURR_DEC	numeric(2)	No	Yes	òî÷íîñòü êóðñà	 
CURR_DOL	varchar(20)	No	No	íàèìåíîâàíèå äåíåæíîé åäèíèöû	 
CURR_CENT	varchar(20)	No	No	íàèìåíîâàíèå ðàçìåííîé ìîíåòû	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
CURR_DOL_GENDER	numeric(1)	No	No	ðîä âàëþòû	 
CURR_CENT_GENDER	numeric(1)	No	No	ðîä ðàçìåííîé ìîíåòû	 
CURR_DOL1_RUS	varchar(20)	No	No	îäèí äîëëàð ðóñ	 
CURR_DOL2_RUS	varchar(20)	No	No	äâà äîëëàðà ðóñ	 
CURR_DOL5_RUS	varchar(20)	No	No	ïÿòü äîëëàðîâ ðóñ	 
CURR_DOL1_ENG	varchar(20)	No	No	îäèí äîëëàð àíã	 
CURR_DOL2_ENG	varchar(20)	No	No	ìíîãî äîëëàðîâ àíã	 
CURR_CENT1_RUS	varchar(20)	No	No	îäèí öåíò ðóñ	 
CURR_CENT2_RUS	varchar(20)	No	No	äâà öåíòà ðóñ	 
CURR_CENT5_RUS	varchar(20)	No	No	ïÿòü öåíòîâ ðóñ	 
CURR_CENT1_ENG	varchar(20)	No	No	îäèí öåíò àíã	 
CURR_CENT2_ENG	varchar(20)	No	No	ìíîãî öåíòîâ àíã	 
CURR_DOL_ENG	varchar(20)	No	No	ñîêð. àíã. íàèìåíîâàíèå äîëëàðà	 
CURR_CENT_ENG	varchar(20)	No	No	ñîêð. àíã. íàèìåíîâàíèå öåíòà	 

T_dbinfo
Column List
Code	Type	P	M	Label	 
DBINFO_NUM	int	Yes	Yes	íîìåð	 
DBINFO_NAME	varchar(60)	No	No	íàèìåíîâàíèå	 
DBINFO_VALUE	text	No	No	çíà÷åíèå	 

T_doktyp
Column List
Code	Type	P	M	Label	 
DOKTYP_ID	int	Yes	Yes	id  òèïà äîê-òà	 
DOKTYP_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå òèïà äîê-òà	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
DOKTYP_REGIST	int	No	No	ïðèçíàê ðåãèñòðàöèè	 
DOKTYP_MASK	text	No	No	øàáëîí íîìåðà	 
DOKTYP_TYP	numeric(3)	No	No	òèï äîêóìåíòà (null,0-îáû÷íûé,  1- ìàãíèòíûé íîñèòåëü)	 
DOKTYP_COLLATE	numeric(1)	No	No	êîäèðîâêà ìàãíèòíûõ íîñèòåëåé 0-DOS, 1- Win	 
DOKTYP_ARCH	numeric(1)	No	No	àðõèâèðîâàòü ëè ôàéë ìàãíèòíîãî íîñèòåëÿ (0-íåò, 1-äà)	 
PROJECT_NUM	int	No	No	íîìåð ïðîåêòà	 
DOKTYP_PROTOCOL	numeric(1)	No	No	âåäåíèå ïðîòîêîëà èçìåíåíèé 0-íåò, 1-äà	 
DOKTYP_IN_BOOK	int	No	No	íîìåð ñîîòâåòñòâóþùåé êíèãè ïðèêàçîâ	 
DOKTYP_PICTURE	varchar(30)	No	No	Øàáëîí íîìåðà äîêóìåíòà	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 

T_doktyp_next_setup
Column List
Code	Type	P	M	Label	 
DOKTYP_ID	int	Yes	Yes	id  òèïà äîê-òà	 
SPR_NUM	int	Yes	Yes	Íîìåð ïîëÿ	 
NEXTSETUP_ALIAS	varchar(30)	Yes	Yes	óñëîâíîå îáîçíà÷åíèå ïîëÿ ñïðàâî÷íèêà	 

T_doktyp_spr
Column List
Code	Type	P	M	Label	 
DOKTYP_ID	int	Yes	Yes	id  òèïà äîê-òà	 
SPR_NUM	int	Yes	Yes	Íîìåð ïîëÿ	 
REGSPR_SNAME	varchar(60)	No	Yes	íàèìåíîâàíèå ïîëåé  (ðåàëüíîå)	 
REGSPR_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå ïîëåé  (ïîëüçîâàòåëüñêèå)	 
REGSPR_ALIAS	char(20)	No	Yes	íàèìåíîâàíèå ïîëåé (ïîëüçîâàòåëüñêèå óñë.îáîçíà÷åíèÿ)	 
REGSPR_TYPE	char(2)	No	Yes	òèï ïîëåé	 
REGSPR_TYPELEN	numeric(3)	No	Yes	Êîë-âî ñèìâîëîâ (äëèíà)	 
REGSPR_TYPELEN2	numeric(2)	No	Yes	Êîë-âî ñèìâîëîâ ïîñëå çàïÿòîé	 
REGSPR_SERVISE	numeric(1)	No	Yes	Ñëóæåáíîå èëè ïîëüçîâàòåëüñêîå	 
REGSPR_ORDER	int	No	No	íîìåð ïîëÿ äëÿ ôîðìèïîâàíèÿ ôèçè÷åñêîãî èìåíè	 
REGSPR_NEXT	int	No	No	ïîëå-ññûëêà íà äð.ñïðàâî÷íèê	 
REGSPR_VISIBLE	numeric(1)	No	No	âèäèìîñòü â ðåññòðå	 
REGSPR_CYCLE	numeric(2)	No	No	íîìåð öèêëà	 
REGSPR_CHOICE	numeric(1)	No	No	âîçìîæíîñòü âûáîðà äî ïðîñìîòðà	 
REGSPR_FTYPE	char(2)	No	No	òèï ðåçóëüòàòà ôîðìóëû	 
REGSPR_FORMULA	text	No	No	ôîðìóëà	 
PROJECT_NUM	int	No	No	íîìåð ïðîåêòà, èç êîòîðîãî ïîëå	 
REGSPR_NEXT_SETUP	int	No	No	ïîêàçûâàòü âñå ïîëÿ ñïðàâî÷íèêà èëè íåò	 
REGSPR_LIST	text	No	No	çíà÷åíèÿ äëÿ ïîëåé òèïà ñïèñîê	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 
REGSPR_UNIQUE	numeric(1)	No	No	êîíòðîëü óíèêàëüíîñòè çíà÷åíèÿ (1-íåò, 2 - äà, 3 -çàïðîñ ) ïî óìîë÷àíèþ "íåò"	 

T_entry_exec
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
ENTRY_NUM	int	Yes	Yes	íîìåð çàïèñè	 
PERIOD	datetime	Yes	Yes	ïåðèîä	 

t_experience
Column List
Code	Type	P	M	Label	 
TAB_ID	numeric(9)	Yes	Yes	Id ñîòðóäíèêà	 
EXPER_NUM	int	Yes	Yes	Íîìåð	 
EXPER_DATE_BEG	datetime	No	No	Äàòà íà÷àëà	 
EXPER_DATE_END	datetime	No	No	Äàòà îêîí÷àíèÿ	 
EXPER_WORK_USL	numeric(9)	No	No	Ññûëêà íà ñïðàâî÷íèê  óñëîâèé òðóäà	 
EXPER_RATE	numeric(4,2)	No	No	Êîýôôèöèåíò	 
EXPER_COMM	varchar(250)	No	No	Êîììåíòàðèé	 
EXPER_GENERAL	numeric(1)	No	No	Îáùèé (1-äà , 2- íåò)	 
EXPER_UNBROKEN	numeric(1)	No	No	Íåïðåðûâíûé (1-äà , 2- íåò)	 
EXPER_INDUSTRY	numeric(1)	No	No	Îòðàñëåâîé (1-äà , 2- íåò)	 
EXPER_MAINPOST	numeric(1)	No	No	Â îñíîâíîé äîëæíîñòè (1-äà , 2- íåò)	 

t_experience_pfr
Column List
Code	Type	P	M	Label	 
EXPER_TYPE	numeric(1)	Yes	Yes	Òèï ñòàæà (0- äëÿ ÏÔÐ, 1 - ïðîøëûå ìåñòà ðàáîòû)	 
TAB_ID	numeric(9)	Yes	Yes	Id ñîòðóäíèêà	 
EXPER_NUM	int	Yes	Yes	Íîìåð	 
EXPER_DATE_BEG	datetime	No	No	Äàòà íà÷àëà	 
EXPER_DATE_END	datetime	No	No	Äàòà îêîí÷àíèÿ	 
EXPER_PRED	numeric(9)	No	No	Ññûëêà íà ñïðàâî÷íèê íàçâàíèé ïðåäïðèÿòèé (äëÿ ïðîøëûõ ìåñò ðàáîòû)	 
EXPER_VID_ACTION	numeric(9)	No	No	Âèä äåÿòåëüíîñòè (äëÿ ïðîøëûõ ìåñò ðàáîòû)	 
EXPER_POST	varchar(250)	No	No	Äðëæíîñòü (äëÿ ïðîøëûõ ìåñò ðàáîòû)	 
EXPER_TER_USL	numeric(9)	No	No	Ññûëêà íà ñïðàâî÷íèê òåððèòîðèàëüíûõ óñëîâèé	 
EXPER_RATE	numeric(4,2)	No	No	Ðàéîííûé êîýôôèöèåíò (ïîäñò-ñÿ èç ñïð-êà òåððèò. óñëîâèé)	 
EXPER_SPEC_USL	numeric(9)	No	No	Ññûëêà íà ñïðàâî÷íèê îñîáûõ óñëîâèé	 
EXPER_WORK_EXPER	numeric(9)	No	No	Ññûëêà íà ñïðàâî÷íèê òðóäîâîé ñòàæ	 
EXPER_WE_USL0	numeric(2)	No	No	×èñëî ëåò ïî òðóäîâîìó ñòàæó (äëÿ ïðîøëûõ ìåñ ò ðàáîòû)	 
EXPER_WE_USL1	numeric(4)	No	No	×èñëî ìåñÿöåâ èëè ÷àñîâ äëÿ òðóäîâîãî ñòàæà	 
EXPER_WE_USL2	numeric(2)	No	No	×èñëî äíåé èëè ìèíóò äëÿ òðóäîâîãî ñòàæà	 
EXPER_WE_USL3	numeric(1)	No	No	(0-íå çàäàíî, 1-äåòè ,2- äåêðåò)	 
EXPER_LONG_SERVICE	numeric(9)	No	No	Ññûëêà íà âûñëóãó ëåò	 
EXPER_LS_USL1	numeric(4)	No	No	×èñëî ìåñÿöåâ èëè ÷àñîâ äëÿ âûñëóãè ëåò	 
EXPER_LS_USL2	numeric(2)	No	No	×èñëî äíåé èëè ìèíóò äëÿ âûñëóãè ëåò	 
EXPER_LS_USL3	numeric(3,2)	No	No		 
EXPER_KOD_POS	numeric(9)	No	No	Ññûëêà íà êîä ïîçèöèè ñïèñêà	 

T_export_dbf
Column List
Code	Type	P	M	Label	 
JOB_NUM	int	Yes	Yes	íîìåð çàäàíèÿ	 
EXP_NUM	int	Yes	Yes	íîìåð íàñòðîéêè	 
DBF_NUM	int	Yes	Yes	íîìåð ïîëÿ	 
DBF_NAME	varchar(10)	No	No	íàçâàíèå ïîëÿ dbf	 
DBF_TYPE	char(1)	No	No	òèï ïîëÿ	 
DBF_SIZE	numeric(3)	No	No	ðàçìåð ïîëÿ	 
DBF_SCALE	numeric(2)	No	No	òî÷íîñòü ïîëÿ	 
DBF_FORMULA	text	No	No	ôîðìóëà äëÿ âû÷èñëåíèÿ ñîäåðæèìîãî ïîëÿ	 
DBF_USL_FORMULA	text	No	No	óñëîâèå äëÿ âû÷èñëåíèÿ	 

T_export_job
Column List
Code	Type	P	M	Label	 
JOB_NUM	int	Yes	Yes	íîìåð çàäàíèÿ	 
JOB_NAME	varchar(60)	No	No	íàèìåíîâàíèå çàäàíèÿ	 
JOB_PATH	text	No	No	ïóòü	 

T_export_kls
Column List
Code	Type	P	M	Label	 
JOB_NUM	int	Yes	Yes	íîìåð çàäàíèÿ	 
EXP_NUM	int	Yes	Yes	íîìåð íàñòðîéêè	 
KLSREF_NUM	int	No	Yes	íîìåð ñïðàâî÷íèêà	 
EXP_NAME	varchar(60)	No	No	íàèìåíîâàíèå íàñòðîéêè	 
EXP_CODE	numeric(2)	No	No	êîäèðîâêà (WIN, DOS)	 
EXP_FILTER	text	No	No	ôîðìóëà äëÿ ôèëüòðà	 
EXP_DBF	varchar(30)	No	No	èìÿ ôàéëà áåç ðàñøèðåíèÿ	 

T_external_task
Column List
Code	Type	P	M	Label	 
EXT_NUM	int	Yes	Yes	íîìåð âíåøíåé çàäà÷è	 
EXT_NAME	varchar(60)	No	No	íàèìåíîâàíèå âíåøíåé çàäà÷è	 

T_filial
Column List
Code	Type	P	M	Label	 
FILIAL_NUM	char(2)	Yes	Yes	íîìåð ôèëèàëà	 
FILIAL_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå ôèëèàëà	 
FILIAL_IS_ALL_DATA	numeric(1)	No	No	Ñòàòóñ ôèëèàëà	 
FILIAL_IS_EDIT	numeric(1)	No	No	âîçìîæíîñòü ïðàâêè ÷óæèõ äàííûõ	 
FILIAL_PATH	text	No	No	ïóòè ê DBF	 

T_glossary
Column List
Code	Type	P	M	Label	 
GLOS_NAME	varchar(60)	Yes	Yes	íàèìåíîâàíèå	 
GLOS_ALIAS	char(15)	No	No	óñëîâíîå îáîçíà÷åíèå	 
GLOS_TYPE	char(2)	No	No	òèï	 
GLOS_TYPELEN	numeric(3)	No	No	äëèíà	 
GLOS_TYPELEN2	numeric(2)	No	No	òî÷íîñòü	 
GLOS_NEXT	int	No	No	ññûëêà	 
GLOS_LIST	text	No	No	ñïèñîê	 

T_GRAPH_CHANGES
Column List
Code	Type	P	M	Label	 
NED	numeric(9)	Yes	Yes	id ðàáî÷åé íåäåëè	 
CHANGE_DATA	datetime	Yes	Yes	äàòà	 
DAY_HOURS	numeric(4,2)	No	No	êîëè÷åñòâî äíåâíûõ ÷àñîâ	 
NIGHT_HOURS	numeric(4,2)	No	No	êîëè÷åñòâî íî÷íûõ ÷àñîâ	 

T_GRAPH_DAYS
Column List
Code	Type	P	M	Label	 
NED	numeric(9)	Yes	Yes	id ðàáî÷åé íåäåëè	 
DAY_NUM	numeric(2)	Yes	Yes	íîìåð äíÿ â ãðàôèêå	 
DAY_HOURS	numeric(4,2)	No	No	êîëè÷åñòâî äíåâíûõ ÷àñîâ	 
NIGHT_HOURS	numeric(4,2)	No	No	êîëè÷åñòâî íî÷íûõ ÷àñîâ	 
EVNG_HOURS	numeric(4,2)	No	No	âå÷åðíèå ÷àñû	 

T_group_user
Column List
Code	Type	P	M	Label	 
FILIAL_USER	char(2)	Yes	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	Yes	Yes	íîìåð ïîëüçîâàòåëÿ	 
FILIAL_GROUP	char(2)	Yes	Yes	íîìåð ôèëèàëà ãðóïïû	 
GROUP_ID	char(32)	Yes	Yes	íîìåð ïîëüçîâàòåëÿ ãðóïïû	 

T_GRP_SETUP
Column List
Code	Type	P	M	Label	 
KLS_ID	numeric(9)	Yes	Yes	ID ãðóïïû òîâàðà	 
SPR_ORDER	int	Yes	Yes	Âíóòðåííèé íîìåð íåâèäèìîãî ïîëÿ	 

T_HOLIDAYS
Column List
Code	Type	P	M	Label	 
HOLIDAY_DAY	numeric(2)	Yes	Yes	÷èñëî	 
HOLIDAY_MONTH	numeric(2)	Yes	Yes	ìåñÿö	 
YEAR_BEG	numeric(4)	No	No	ñ êàêîãî ãîäà äåéñòâóåò	 
YEAR_END	numeric(4)	No	No	ïî êàêîé ãîä äåéñòâóåò	 
COMM	varchar(250)	No	No	êîììåíòàðèé	 

T_image_list
Column List
Code	Type	P	M	Label	 
IMAGE_TYPE	numeric(1)	Yes	Yes	Òèï êàðòèíêè (1-ãë. ìåíþ, 2 - ïîëüçîâàòåëüñêàÿ...)	 
IMAGE_NUM	int	Yes	Yes	íîìåð êàðòèíêè	 
IMAGE_NAME	varchar(60)	No	No	íàèìåíîâàíèå êàðòèíêè	 
IMAGE_BLOB	image	No	No	êàðòèíêà	 
IMAGE_BLOB_PARAMS	text	No	No	ïàðàìåòðû êàðòèíêè	 
IMAGE_PROPERTY	varchar(250)	No	No	ñâîéñòâî êàðòèíêè (äëÿ êàëåíäàðÿ)	 

T_itemlist
Column List
Code	Type	P	M	Label	 
ITEM_CODE	int	Yes	Yes	íîìåð êëàññà	 
ITEM_COCLASSNAME	varchar(60)	No	Yes	èìÿ êëàññà	 
ITEM_VISIBLE	numeric(1)	No	Yes	âèäèìîñòü	 
ITEM_PROXYTYPE	char(1)	No	Yes	òèï êëàññà	 
ITEM_NAME	varchar(60)	No	No	îïèñàíèå êëàññà	 
ITEM_HELPID	int	No	No	id help'a	 
ITEM_PROJECT	int	No	No	â êàêîì ïðîåêòå ìîæíî èñïîëüçîâàòü ÷åðåç Äèçàéíåð (>0 - òîëüêî äëÿ êîíêð.ïð., 0-äëÿ âñåõ, null-íå äëÿ Äèçàéíåðà)	 

T_job
Column List
Code	Type	P	M	Label	 
JOB_NUM	int	Yes	Yes	íîìåð çàäàíèÿ	 
JOB_NAME	varchar(60)	No	No	íàèìåíîâàíèå çàäàíèÿ	 
JOB_TYPE	numeric(1)	No	Yes	ïåðèîäè÷íîñòü	 
JOB_DAY	numeric(2)	No	Yes	äåíü çàïóñêà	 
JOB_TIME	numeric(5,2)	No	Yes	âðåìÿ çàïóñêà	 
JOB_ACTIVE	numeric(1)	No	Yes	àêòèâíîñòü	 
JOB_USER_ID	char(32)	No	Yes	ïîëüçîâàòåëü	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 

T_job_journal
Column List
Code	Type	P	M	Label	 
STEP_ID	numeric(9,0)	Yes	Yes	èäåíòèôèêàòîð çàïèñè	 
JOB_NUM	int	No	Yes	íîìåð çàäàíèÿ	 
STEP_NUM	int	No	Yes	íîìåð øàãà	 
JOB_START	datetime	No	Yes	âðåìÿ çàïóñêà	 
JOB_SUCCESS	numeric(1)	No	No	ðåçóëüòàò (1-âûïîëíåíî/ 0-íå âûïîëíåíî)	 
JOB_MESSAGE	text	No	No	òåêñò ñîîáùåíèÿ îá îøèáêå	 
STEP_STRING	text	No	No	âûïîëíÿåìàÿ ôîðìóëà	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 

T_kls_all
Column List
Code	Type	P	M	Label	 
KLS_ID	numeric(9,0)	Yes	Yes	id çíà÷åíèÿ ñïðàâî÷íèêà	 
KLSREF_NUM	int	No	Yes	íîìåð ñïðàâî÷íèêà	 
NUMB_ID	int	No	No	id åäèíèöû èçìåðåíèÿ	 
KLS_END	datetime	No	No	îãðàíè÷åíèå âèäèìîñòè	 
KLS_NUM	varchar(20)	No	Yes	ïîëüçîâàòåëüñêèé íîìåð	 
KLS_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå	 
KLS_DIGIT_NUM	numeric(20)	No	No	Íîìåð ïðåäñòàâëåííûé êàê ÷èñëî	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
KLS_SERVICE	varchar(20)	No	No	ïîëüçîâàòåëüñêèé íîìåð (äëÿ ñë. öåëåé)	 
SEND	numeric(1)	No	No	èçìåíåíà ëè çàïèñü (äëÿ êîðïîð. Null-äà)	 
USER_ID	char(32)	No	No	íîìåð ïîëüçîâàòåëÿ	 
FILIAL_NUM	char(2)	No	No	ôèëèàë-ñîçäàòåëü	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 
KLS_ISEDIT	numeric(1)	No	No	ìîæíî ëè èçìåíÿòü äàííóþ çàïèñü	 
BRANCH	numeric(9)	No	No	ïðåäïðèÿòèå	 
PAR_ID	numeric(9)	No	No	id çíà÷åíèÿ ñïðàâî÷íèêà ðîäèòåëÿ	 
NUMB_ID2	int	No	No	id åäèíèöû èçìåðåíèÿ	 
CREAT_DATE	datetime	No	No	âðåìÿ ñîçäàíèÿ	 
REGIST_PERIOD	datetime	No	No	ïåðèîä ðåãèñòðàöèè (äëÿ äîêóìåíòîâ)	 
REGIST_DATE	datetime	No	No	äàòà äîêóìåíòà	 
BARCODE	varchar(20)	No	No	øòðèõ-êîä	 

T_kls_all_del
Column List
Code	Type	P	M	Label	 
KLSDEL_ID	numeric(9,0)	Yes	Yes	àâòîèíêð. ïîëå äëÿ ïåðâè÷íîãî êëþ÷à	 
KLSREF_NUM	int	No	Yes	íîìåð ñïðàâî÷íèêà	 
PARENT1	varchar(20)	No	No	ðîäèòåëü1	 
PARENT2	varchar(20)	No	No	ðîäèòåëü2	 
PARENT3	varchar(20)	No	No	ðîäèòåëü3	 
PARENT4	varchar(20)	No	No	ðîäèòåëü4	 
PARENT5	varchar(20)	No	No	ðîäèòåëü5	 
PARENT6	varchar(20)	No	No	ðîäèòåëü6	 
KLS_NUM	varchar(20)	No	No	ïîëüçîâàòåëüñêèé íîìåð	 
KLS_NAME	varchar(60)	No	No	íàèìåíîâàíèå	 
FILIAL_NUM	char(2)	No	No	Íîìåð ôèëèàëà	 
SEND	numeric(1)	No	No	èçìåíåíà ëè çàïèñü (äëÿ êîðïîð. Null-äà)	 
BRANCH	numeric(9)	No	No	ïðåäïðèÿòèå	 
DOKDATE	datetime	No	No	äàòà äëÿ ñïðàâî÷íèêîâ ïî ïåðèîäàì	 
CREAT_DATE	datetime	No	No	âðåìÿ ñîçäàíèÿ	 

T_Kls_curs
Column List
Code	Type	P	M	Label	 
CURR_NUM	int	Yes	Yes	íîìåð âàëþòû	 
KURS_DATE	datetime	Yes	Yes	Äàòà êóðñà	 
KURS_CB	numeric(19,10)	No	Yes	Êóðñ ÖÁ	 
KURS_MMVB	numeric(19,10)	No	Yes	Êóðñ ÌÌÂÁ	 
KURS_NAL	numeric(19,10)	No	Yes	Êóðñ íàë	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 

T_kls_form
Column List
Code	Type	P	M	Label	 
KEY_MENU	varchar(60)	Yes	Yes	ïîëíûé ïóòü ê ïóíêòó ìåíþ	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSFORM_NUM	char(20)	Yes	Yes	íîìåð ôîðìû	 
PERIOD	datetime	Yes	Yes	ïåðèîä íà÷àëà ÓÏ	 
NEW_FORM	numeric(1)	Yes	Yes		 
KLSFORM_NAME	varchar(60)	No	No	íàèìåíîâàíèå	 
KLSFORM_DIGIT_NUM	numeric(20)	No	No	ïîëüçîâàòåëüñêèé íîìåð â ÷èñëîâîì âèäå	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
NUMB_COPY	numeric(2)	No	No	êîëè÷åñòâî êîïèé íà ïå÷àòü	 
STORED_RESULT	numeric(1)	No	No	ñîõðàíÿòü ëè ðåçóëüòàòû ðàñ÷åòà	 
AUTO_PRINT	numeric(1)	No	No	çàïóñê íà ïå÷àòü (1-àâòî, 2-ðó÷íîé)	 
AUTO_EXIT	numeric(1)	No	No	âûõîä èç ïå÷àòè (1-àâòî, 2-ðó÷íîé)	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 

T_kls_form_blob
Column List
Code	Type	P	M	Label	 
KEY_MENU	varchar(60)	Yes	Yes	ïîëíûé ïóòü ê ïóíêòó ìåíþ	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSFORM_NUM	char(20)	Yes	Yes	íîìåð	 
PERIOD	datetime	Yes	Yes	ïåðèîä íà÷àëà ÓÏ	 
NEW_FORM	numeric(1)	Yes	Yes		 
KLSFORM_BLOB	image	No	No	ôîðìà èç Formula1	 
BLOB_PARAMS	text	No	No	ïàðàìåòðû øàáëîíà	 

T_kls_form_branch
Column List
Code	Type	P	M	Label	 
KEY_MENU	varchar(60)	Yes	Yes	ïîëíûé ïóòü ê ïóíêòó ìåíþ	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSFORM_NUM	char(20)	Yes	Yes	íîìåð	 
PERIOD	datetime	Yes	Yes	ïåðèîä íà÷àëà ÓÏ	 
NEW_FORM	numeric(1)	Yes	Yes		 
BRANCH	varchar(250)	Yes	Yes	Ñïèñîê id ïðåäïðèÿòèé ÷åðåç çàï-þ, îòñîðòèðîâàííûé ïî âîçðàñòàíèþ	 
PERIOD_DOC	datetime	Yes	Yes	Ïåðèîä õðàíåíèÿ ðàññ÷èòàííîãî äîêóìåíòà	 
KLSFORM_DOC	image	No	No	ðàññ÷èòàííûé äîêóìåíò	 

T_kls_group
Column List
Code	Type	P	M	Label	 
KLSREF_NUM	int	Yes	Yes	íîìåð ñïðàâî÷íèêà	 
KLSREF_NUM_KLS	int	Yes	Yes	íîìåð ñïðàâî÷íèêà, âõîäÿùåãî â ãðóïïó	 

T_kls_import
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
ENTRY_NUM	int	Yes	Yes	íîìåð çàïèñè	 
S_KLSREF_NUM	text	No	No	íîìåð ñïðàâî÷íèêà	 
S_KLS_FORMULA	text	No	No	ôîðìóëà äëÿ çíà÷åíèÿ ñïðàâî÷íèêà	 

T_Kls_kls
Column List
Code	Type	P	M	Label	 
KLSREF_NUM	int	Yes	Yes	íîìåð ñïðàâî÷íèêà	 
KLSREF_TYP	int	No	Yes	Òèï ñïðàâî÷íèêà	 
KLSREF_PARENT	int	No	No	íîìåð ñïðàâî÷íèêà - ññûëêà íà ðîäèòåëÿ	 
KLSREF_NAME	varchar(60)	No	Yes	íàìåíîâàíèå ñïðàâî÷íèêà	 
KLSREF_SNAME	varchar(20)	No	Yes	Êðàòêîå íàèìåíîâàíèå	 
KLSREF_ALIAS	char(15)	No	Yes	Alias ñïðàâî÷íèêà, èñïîëüçóåìûé â ôîðìóëàõ	 
KLSREF_NUMB	numeric(1)	No	No	åñòü ëè êîë-âî â ñïðàâî÷íèêå	 
KLSREF_NUMTYPE	numeric(1)	No	No	òèï íóìåðàöèè (ñêâîçíàÿ, íåñêâîçíàÿ)	 
KLSREF_ANALYTIC	numeric(1)	No	No	àíàëèòè÷åñêèé ëè ñïðàâî÷íèê	 
KLSREF_PICTURE	varchar(30)	No	Yes	Øàáëîí äëÿ âûâîäà íîìåðà âî ââîäå	 
KLSREF_PICT_FILIAL	numeric(1)	No	No	Ïðåäë-òü íîâûé íîìåð ñ ó÷åòîì âñåõ ôèëèàëîâ(1) èëè òîëüêî âíóòðè ñâîåãî(2)	 
KLSREF_TITLE_NUM	varchar(20)	No	Yes	êàê ïîêàçûâàåòñÿ â çàãîëîâêàõ íîìåð (íàïðèìåð: êîä)	 
KLSREF_TITLE_NAME	varchar(60)	No	Yes	êàê ïîêàçûâàåòñÿ â çàãîëîâêàõ íàèìåíîâàíèå (íàïðèìåð: ôàìèëèÿ)	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
KLSREF_ISEDIT	int	No	No	âîçìîæíîñòü ïðàâêè	 
KLSREF_IMPORT_ACTION	numeric(1)	No	No	Äåéñòâèÿ ñ ïåðåäàííûìè çàïèñÿìè 1-ïðèíèìàòü âñå,2-òîëüêî íîâûå,3-íå ïðèíèìàòü	 
KLSREF_EXPORT_OPER	numeric(1)	No	No	Ïðèçíàê ýêñïîðòèðóåìûõ ïîëåé (òîëüêî äëÿ ýêñïîðòà îïåðàöèé)	 
KLSREF_BRANCH	numeric(1)	No	No	Âîçìîæíîñòü ðàçäåëåíèÿ ïî íåñêîëüêèì ïðåäïðèÿòèÿì (1-íåò, 2-äà, 3-äà, íåñêâîçíàÿ íóìåðàöèÿ)	 
KLSREF_PROTOCOL	numeric(1)	No	No	âåäåíèå ïðîòîêîëà èçìåíåíèé 0-íåò, 1-äà	 
PROJECT_NUM	varchar(250)	No	No	ñïèñîê çàäà÷	 
DOKTYP_ID	int	No	No	ññûëêà íà æóðíàë	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 
KLSREF_BARCODE	numeric(1)	No	No	åñòü ëè øòðèõ-êîä â ñïðàâî÷íèêå	 
KLSREF_TREE	numeric(1)	No	No	ïðèçíàê ñïðàâî÷íèêà ñ äåðåâüÿìè (0-íåò, 1 - äà)	 
KLSREF_HISTORY	numeric(1)	No	No	èñòîðèÿ èçìåíåíèé	 

T_kls_oper
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
KLSOPER_DATEEND	datetime	No	Yes	Äàòà êîíöà	 
KLSOPER_NAME	varchar(60)	No	No	íàèìåíîâàíèå	 
KLSOPER_START_PERIOD	numeric(1)	No	Yes	ïåðèîäè÷íîñòü	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
QUALITY_MARK	int	No	No	ôëàã ïðàâèëüíîñòè íàñòðîéêè	 
KLSOPER_ENTER	numeric(1)	No	No	Ïîñëå ââîäà	 
KLSOPER_SOURCE	int	No	No	çàäà÷à - èñòî÷íèê äàííûõ äëÿ èìïîðòà	 
KLSOPER_XLS_SHEET	varchar(60)	No	No	èìÿ ëèñòà (äëÿ èìïîðòà èç âí. îò÷åòîâ)	 
KLSOPER_XLS_FIRST_STR	int	No	No	íîìåð ïåðâîé ñòðîêè (äëÿ èìïîðòà èç âí. îò÷åòîâ)	 
KLSOPER_XLS_FIRST_COL	char(2)	No	No	íîìåð ïåðâîé êîëîíêè (äëÿ èìïîðòà èç âí. îò÷åòîâ)	 
KLSOPER_XLS_LAST_COL	char(2)	No	No	íîìåð ïîñëåäíåé êîëîíêè	 
KLSOPER_XLS_FILE	text	No	No	èìÿ ïîñëåäíåãî ôàéëà (äëÿ èìïîðòà èç âí. îò÷åòîâ)	 
KLSOPER_IS_PART	numeric(1)	No	No	Âûïîëíÿòü âñå çàïèñè èëè ïî âûáîðó	 
KLSOPER_KIND	int	No	No	âèä îïåðàöèè (ïðèìåíÿåòñÿ â òîðãîâëå)	 
KLSOPER_DOC_GRP	text	No	No	ñïèñîê ïîëåé äëÿ ãðóïïèðîâêè ïî äîêóìåíòó	 
KLSOPER_DOC_SUM	text	No	No	ñïèñîê ïîëåé äëÿ ñóììèðîâàíèÿ ïî äîêóìåíòó	 
KLSOPER_DOC_USL	text	No	No	óñëîâèå îòáîðà çàïèñåé ïî äîêóìåíòó	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 
KLSOPER_DELIMIT	varchar(10)	No	No	ðàçäåëèòåëü äëÿ òåêñò-õ ôàéëîâ äëÿ èìïîðòà èç ïðîèçâ-õ îò÷åòîâ	 
KLSOPER_CELLS	varchar(10)	No	No	êîëè÷åñòâî ïóñòûõ ÿ÷ååê	 

T_last_num
Column List
Code	Type	P	M	Label	 
TABLE_NAME	char(30)	Yes	Yes	èìÿ òàáëèöû	 
SPR_NUM	int	Yes	Yes	íîìåð ñïðàâî÷íèêà	 
FILTER_NUM	varchar(100)	Yes	Yes	ðîäèòåëü èëè óñëîâèå äëÿ ïðàâèëüíîãî èäåíòèôèöèðîâàíèÿ íîìåðà	 
LAST_NUM	numeric(20)	No	Yes	ïîñëåäíèé  çàïèñàííûé  íîìåð	 

T_list_acc
Column List
Code	Type	P	M	Label	 
KEY_MENU	varchar(60)	Yes	Yes	ïîëíûé ïóòü ê ïóíêòó ìåíþ	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
LIST_NUM	int	Yes	Yes	Íîìåð íàáîðà	 
LIST_NAME	varchar(20)	No	No	Íàèìåíîâàíèå íàáîðà	 
LIST_DATA	text	No	No	Íàáîð ñ÷åòîâ	 
INPUT_DATE	datetime	No	No		 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 

T_LIST_DEDUCTION
Column List
Code	Type	P	M	Label	 
PRIV_ID	numeric(9)	Yes	Yes	óíèêàëüíûé èäåíòèôèêàòîð (autoincreament)	 
TAB_ID	numeric(9)	No	Yes	id òàáåëüíîãî íîìåðà	 
PERIOD_BEG	datetime	No	Yes	ïåðèîä íà÷àëà äåéñòâèÿ âû÷åòà	 
PERIOD_END	datetime	No	Yes	ïåðèîä îêîí÷àíèÿ äåéñòâèÿ âû÷åòà	 
DEDUCTION	numeric(9)	No	No	id âû÷åòà	 
SUMMA	numeric(19,2)	No	No	ñóììà âû÷åòà	 
COMM	varchar(100)	No	No	êîììåíòàðèé	 
BRANCH	numeric(9)	No	No	ID ïðåäïðèÿòèÿ	 

T_menu
Column List
Code	Type	P	M	Label	 
TASK_NUM	int	Yes	Yes	id çàäà÷è	 
MENU_NUM	int	Yes	Yes	íîìåð ìåíþ	 
MENU_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå ìåíþ	 
MENU_MEMO	text	No	No	êàêàÿ-òî èíôîðìàöèÿ	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 

T_message
Column List
Code	Type	P	M	Label	 
MESSAGE_ID	numeric(9,0)	Yes	Yes		 
FILIAL_USER	char(2)	Yes	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	Yes	Yes	íîìåð ïîëüçîâàòåëÿ	 
MESSAGE_TYPE	numeric(1)	No	Yes	òèï, 0 - ñîîáùåíèå, 1 - íàïîìèíàíèå	 
MESSAGE_NUM	int	No	Yes	íîìåð ñîîáùåíèÿ	 
MESSAGE_TEXT	varchar(250)	No	No	òåêñò ñîîáùåíèÿ	 
MESSAGE_MONTH	numeric(2)	No	No	ìåñÿö	 
MESSAGE_DAY	numeric(2)	No	No	äåíü	 
MESSAGE_TIME	numeric(4,2)	No	No	âðåìÿ	 
MESSAGE_NAME	varchar(60)	No	No	Íàèìåíîâàíèå ñîîáùåíèÿ	 
MESSAGE_YEAR	numeric(4)	No	No	ãîä	 
MESSAGE_PATH_WAV	text	No	No	ïóòü ê çâóêîâîìó ôàéëó	 
MESSAGE_PREV_TIME	numeric(5)	No	No	âðåìÿ ïðåäâàðèòåëüíîãî ñîîáùåíèÿ	 
MESSAGE_PREV_ONLY	numeric(1)	No	No	âûäàâàòü ëè îñíîâíîå ñîîáùåíèå (1 - äà, 2- íåò)	 
IMAGE_TYPE	numeric(1)	No	No	Òèï êàðòèíêè (1-ãë. ìåíþ, 2 - ïîëüçîâàòåëüñêàÿ...)	 
IMAGE_NUM	int	No	No	íîìåð êàðòèíêè	 
FILIAL_USER_FROM	char(2)	No	No	íîìåð ôèëèàëà ïîëüçîâàòåëÿ îò êîãî ñîîáùåíèå	 
USER_ID_FROM	char(32)	No	No	íîìåð ïîëüçîâàòåëÿ îò êîãî ñîîáùåíèå	 
INPUT_DATE	datetime	No	No	äàòà ââîäà íàïîìèíàíèÿ	 

T_MIN_SALARY
Column List
Code	Type	P	M	Label	 
SALARY_DATE	datetime	Yes	Yes	ïåðèîä	 
SALARY_MONEY	numeric(19,2)	No	No	ìèíèìàëüíàÿ ç/ï	 

T_mreport
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ãðóïïû çàäà÷	 
PERIOD	datetime	Yes	Yes	ïåðèîä íà÷àëà ÓÏ	 
ALBUM_NUM	int	Yes	Yes	íîìåð àëüáîìà	 
REPORT_NUM	int	Yes	Yes	íîìåð îò÷åòà íà ÌÍ	 
REPORT_NAME	varchar(60)	No	No	íàèìåíîâàíèå îò÷åòà íà ÌÍ	 
REPORT_FILE	varchar(250)	No	No	ôàéë îò÷åòà íà ÌÍ	 
REPORT_TYPE	int	No	No	òèï îò÷åòà íà ÌÍ	 
REPORT_BLOB	image	No	No	øàáëîí ôîðìû	 

T_NALOG_SCALE
Column List
Code	Type	P	M	Label	 
BRANCH	numeric(9)	Yes	Yes	id êîìïàíèè	 
NALOG_ID	numeric(9)	Yes	Yes	id íàëîãà	 
SCALE_YEAR	numeric(4)	Yes	Yes	ãîä äåéñòâèÿ	 
SCALE_NUM	varchar(20)	Yes	Yes	íîìåð øêàëû	 
SCALE_NAME	varchar(60)	No	No	íàèìåíîâàíèå øêàëû	 
SUM_MIN	numeric(15,2)	No	No	íèæíÿÿ ãðàíèöà	 
SUM_MAX	numeric(15,2)	No	No	âåðõíÿÿ ãðàíèöà	 
FORM	text	No	No	ôîðìóëà	 
SCALE_DIGIT_NUM	numeric(20)	No	No	Íîìåð ïðåäñòàâëåííûé êàê ÷èñëî	 

T_nodedatatree
Column List
Code	Type	P	M	Label	 
USER_ID	char(32)	Yes	Yes	èäåíòèôèêàòîð ïîëüçîâàòåëÿ	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
KEY1	varchar(60)	Yes	Yes	êëþ÷1, îáû÷íî íîìåð Proxi èëè èìÿ êëàññà	 
KEY2	varchar(60)	Yes	Yes	êëþ÷ 2, îáû÷íî ñ÷åò, ñïðàâî÷íèê èëè ðàçäåë	 
KEY_ADVANSED	varchar(60)	Yes	Yes	êëþ÷ äîïîëíèòåëüíûé, íàïðèìåð óðîâåíü îáîðîòêè èëè âèä Æ-îðäåðà	 
KEY_MENU	varchar(60)	Yes	Yes	ïîëíûé ïóòü ê ïóíêòó ìåíþ	 
NDT_NUM	int	Yes	Yes	íîìåð ïðîñìîòðà	 
NDT_NAME	varchar(60)	No	No	íàèìåíîâàíèå ïðîñìîòðà	 
TYPE_KEY2	numeric(2)	No	No	òèï òîãî ÷òî ëåæèò â Key2 (1-ñ÷åò, 2-ñïðàâî÷íèê, 3-ðàçäåë)	 
NDT_DATA	text	No	No	áèíàðíîå ïðåäñòàâëåíèå ïðîñìîòðà (ñî ñòîðîíû çàäà÷è)	 
NDT_CONSTRDATA	text	No	No	áèíàðíîå ïðåäñòàâëåíèå ïðîñìîòðà (ñî ñòîðîíû êîíñòðóêòîðà)	 
NDT_SEQUENS	varchar(10)	No	No	äîïëëíèòåëüíàÿ èíô-öèÿ ïî ïðîñìîòðó (ïðèìåð - ïîñëåäîâàòåëüíîñòü àí.óð.)	 
NDT_MAX_LEVEL	int	No	No	ìàêñèìàëüíûé âèäèìûé óðîâåíü îáîðîòêè	 
NDT_TYPE	int	No	No	òèï ïðîñìîòðà	 
NDT_ACC_LEN	numeric(2)	No	No	ðàçðÿäíîñòü ñ÷åòà	 
NDT_TURN_LEVEL	numeric(1)	No	No	Óðîâåíü ðàçâîðîòà ñàëüäî	 
NDT_PLAY	text	No	No	ñ çàïèñüþ äëÿ "ïðîèãðûâàíèÿ"	 

T_nsystem
Column List
Code	Type	P	M	Label	 
TASK_NUM	int	Yes	Yes	id çàäà÷è	 
PERIOD	datetime	Yes	Yes	ïåðèîä íà÷àëà äåéñòâèÿ íàñòðîéêè	 
NSYSTEM_NUM	int	Yes	Yes	íîìåð íàñòðîéêè	 
BRANCH	numeric(9)	Yes	Yes	Ïðåäïðèÿòèå	 
NSYSTEM_NAME	varchar(60)	No	Yes	èìÿ íàñòðîéêè	 
NSYSTEM_VALUE	text	No	No	çíà÷åíèå íàñòðîéêè	 
NSYSTEM_TEXT	text	No	No	ñïèñîê âîçìîæíûõ çíà÷åíèé	 
NSYSTEM_TYPE	int	No	No	òèï çíà÷åíèÿ (ïåðå÷èñëåíèå, ÷èñëî, ñòðîêà è ò.ä)	 

T_numb
Column List
Code	Type	P	M	Label	 
NUMB_ID	int	Yes	Yes	id åäèíèöû èçìåðåíèÿ	 
NUMB_BASE_ID	int	No	No	id åäèíèöû èçìåðåíèÿ - áàçîâîé	 
NUMB_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå åä.èçìåðåíèÿ	 
NUMB_KOEF	numeric(15,6)	No	Yes	êîýô-ò ïåðåñ÷åòà äëÿ êîðåëèðóåìûõ åäèíèö èçìåðåíèÿ	 
NUMB_SNAME	char(7)	No	Yes	êðàòêîå íàèìåíîâàíèå åä.èçìåðåíèÿ	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 

T_oper_0_9
Column List
Code	Type	P	M	Label	 
OPER_IDENT	char(26)	Yes	Yes	óíèêàëüíûé èä. îïåðàöèè	 
PERIOD	datetime	No	Yes	Ïåðèîä - ïåðâîå ÷èñëî ìåñÿöà	 
OPER_ID	numeric(9,0)	No	Yes	àâòîèíêðåìåíòíîå ïîëå îïåðàöèè	 
KLSOPER_NUM	int	No	No	Íîìåð îïåðàöèè	 
VID_NUM	int	No	No	âèä äåÿòåëüíîñòè	 
KLSOPER_TYPE	numeric(2)	No	No	òèï îïåðàöèè	 
FILIAL_NUM	char(2)	No	No	íîìåð ôèëèàëà	 
TASK_NUM	int	No	Yes		 
ORDER_NUM	int	No	No	ðàçäåë ó÷åòà	 
REESTR_NUM	varchar(250)	No	No	íîìåðà æóðíàëîâ ðåãèñòðàöèè, ó÷àñòâóþùèõ â îïåðàöèè	 
DOKTYP_ID	int	No	No	òèï äîêóìåíòà	 
DOC	varchar(30)	No	No	íîìåð äîêóìåíòà	 
ENTRY_DATE	datetime	No	No	äàòà äîêóìåíòà	 
SEND	numeric(1)	No	No	èçìåíåíà ëè çàïèñü (äëÿ êîðïîð. Null-äà)	 
DOC_DIGIT_NUM	numeric(20)	No	No	íîìåð äîêóìåíòà â âèäå ÷èñëà	 
OPER_DATE	datetime	No	No	ïåðèîä ðåãèñòàöèè äîêóìåíòà	 
INPUT_DATE	datetime	No	No	äàòà ââîäà (ñëóæåáíàÿ)	 
CREAT_DATE	datetime	No	No	äàòà ñîçäàíèÿ (ñëóæåáíàÿ)	 
PROCESS_DOC	varchar(250)	No	No	Èíôîðìàöèÿ îá îáðàáîòàííûõ äîêóìåíòàõ	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 
USER_ID	varchar(32)	No	No	íîìåð ïîëüçîâàòåëÿ	 
EXT_NUM	int	No	No	íîìåð âíåøíåé çàäà÷è	 
KLSOPER_CHOICE	varchar(250)	No	No	Âûïîëíåííûå áëîêè îïåðàöèè	 
BRANCH	numeric(9)	No	No	ïðåäïðèÿòèå	 
KLSOPER_KIND	int	No	No	âèä îïåðàöèè (ïðèìåíÿåòñÿ â òîðãîâëå)	 
BASIS_DOC	varchar(250)	No	No	ñïèñîê äîêóìåíòîâ-îñíîâàíèé	 

T_oper_close
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
ENTRY_NUM	int	Yes	Yes	íîìåð çàïèñè	 
ENTRY_DATE	text	No	No	äàòà ïðîâîäêè	 
STATUS_NUM	text	No	No	ô-ëÿ äëÿ ñòàòóñà ïðîâîäêè	 
DT	text	No	No	ô-ëà äëÿ äåáåòà	 
KT	text	No	No	ô-ëà äëÿ êðåäèòà	 
AN1	varchar(20)	No	No	èñïîëüçîâàíèå àíàëèòèêè1	 
AN2	varchar(20)	No	No	èñïîëüçîâàíèå àíàëèòèêè2	 
AN3	varchar(20)	No	No	èñïîëüçîâàíèå àíàëèòèêè3	 
AN4	varchar(20)	No	No	èñïîëüçîâàíèå àíàëèòèêè4	 
AN5	varchar(20)	No	No	èñïîëüçîâàíèå àíàëèòèêè5	 
AN6	varchar(20)	No	No	èñïîëüçîâàíèå àíàëèòèêè6	 
AN7	varchar(20)	No	No	èñïîëüçîâàíèå àíàëèòèêè7	 
USL_DT	text	No	No	óñëîâèå ïî äåáåòó	 
USL_KT	text	No	No	óñëîâèå ïî êðåäèòó	 
PARAM_DT	text	No	No	ïàðàìåòðû äëÿ åáåòà	 
PARAM_KT	text	No	No	ïàðàìåòðû äëÿ êðåäèòà	 
COMENT	text	No	No	ô-ëà äëÿ êîììåíòàðèÿ	 

T_oper_copy
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
ENTRY_NUM	int	Yes	Yes	íîìåð ïðîâîäêè	 
ENTRY_NAME	varchar(60)	No	No	íàèìåíîâàíèå ïðîâîäêè	 
N_FROM	varchar(20)	No	No	íàèìåíîâàíèå áëîêà (èñòî÷íèê)	 
N_TO	varchar(20)	No	No	íàèìåíîâàíèå áëîêà (àïðèåìíèê)	 
FROM_DT	varchar(21)	No	No	Äò (èñòî÷íèê)	 
FROM_KT	varchar(21)	No	No	Êò (ïðèåìíèê)	 
TO_DT	varchar(21)	No	No	Äò (ïðèåìíèê)	 
TO_KT	varchar(21)	No	No	Êò (ïðèåìíèê)	 
N_TO_DT	varchar(20)	No	No	íàèìåíîâàíèå áëîêà (Àíàëèòèêè Äò)	 
N_TO_KT	varchar(20)	No	No	íàèìåíîâàíèå áëîêà (Àíàëèòèêè Êò)	 
FROM_AN	text	No	No	Óñëîâèå îòáîðà	 
TO_DT_AN1	text	No	No	àíàëèòèêà Äò 1 (ïðèåìíèê)	 
TO_DT_AN2	text	No	No	àíàëèòèêà Äò 2 (ïðèåìíèê)	 
TO_DT_AN3	text	No	No	àíàëèòèêà Äò 3 (ïðèåìíèê)	 
TO_DT_AN4	text	No	No	àíàëèòèêà Äò 4 (ïðèåìíèê)	 
TO_DT_AN5	text	No	No	àíàëèòèêà Äò 5 (ïðèåìíèê)	 
TO_DT_AN6	text	No	No	àíàëèòèêà Äò 6 (ïðèåìíèê)	 
TO_DT_AN7	text	No	No	àíàëèòèêà Äò 7 (ïðèåìíèê)	 
TO_KT_AN1	text	No	No	àíàëèòèêà Êò 1 (ïðèåìíèê)	 
TO_KT_AN2	text	No	No	àíàëèòèêà Êò 2 (ïðèåìíèê)	 
TO_KT_AN3	text	No	No	àíàëèòèêà Êò 3 (ïðèåìíèê)	 
TO_KT_AN4	text	No	No	àíàëèòèêà Êò 4 (ïðèåìíèê)	 
TO_KT_AN5	text	No	No	àíàëèòèêà Êò 5 (ïðèåìíèê)	 
TO_KT_AN6	text	No	No	àíàëèòèêà Êò 6 (ïðèåìíèê)	 
TO_KT_AN7	text	No	No	àíàëèòèêà Êò 7 (ïðèåìíèê)	 
N_COUNT	varchar(20)	No	No	Íàèìåíîâàíèå áëîêà (ñòîèìîñòü)	 
QUANTITY1	text	No	No	ô-öèÿ äëÿ ðàñ÷åòà ïåðâîãî êîëè÷åñòâà	 
QUANTITY2	text	No	No	ô-öèÿ äëÿ ðàñ÷åòà âòîðîãî êîëè÷åñòâà	 
CURR_NUM	text	No	No	ô-öèÿ äëÿ ðàñ÷åòà íîìåðà âàëþòû	 
CURR_KURS	text	No	No	ô-öèÿ äëÿ ðàñ÷åòà êóðñà âàëþòû	 
PRICE	text	No	No	ôîðìóëà äëÿ ðàñ÷åòà öåíû	 
CURR_SUMMA	text	No	No	ô-öèÿ äëÿ ðàñ÷åòà  ñóììû â âàëþòå	 
SUMMA	text	No	No	ô-öèÿ äëÿ ðàñ÷åòà ñóììû	 
COMENT	text	No	No	ô-öèÿ äëÿ ðàñ÷åòà êîììåíòàðèÿ	 
USL	text	No	No	ô-öèÿ äëÿ ðàñ÷åòà óñëîâèÿ çàïèñè ïðîâîäêè	 
FIELD_PROPERTY	varchar(250)	No	No	óïàêîâàííûå ïàðàìåòðû	 
IS_LOG	numeric(1)	No	No	íóæåí ëè ôàéë ðàñ÷åòà	 
STATUS_NUM	text	No	No	ñòàòóñ çàïèñè	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 

T_oper_del
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ãðóïïû çàäà÷	 
OPER_IDENT	char(26)	Yes	Yes	èäåíòèôèêàòîð îïåðàöèè	 
SEND	numeric(1)	No	No	èçìåíåíà ëè çàïèñü (äëÿ êîðïîð. Null-äà)	 

T_oper_doc
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
ENTRY_NUM	int	Yes	Yes	íîìåð çàïèñè	 
REGSPR_ALIAS	varchar(20)	Yes	Yes	óñëîâíîå îáîçíà÷åíèå ïîëÿ äîêóìåíòà	 
REGSPR_NAME	varchar(60)	No	No	íàèìåíîâàíèå ïîëÿ	 
FIELD_FORMULA	text	No	No	ôîðìóëà	 
FIELD_PROPERTY	char(10)	No	No	ñâîéñòâà  (ïîä÷åðêèâàíèå, âèäèìîñòü, àâòî è ò. ä.)	 
FIELD_SPR_FORMULA	text	No	No	ôîðìóëà ïðîñìîòðà ñïðàâî÷íèêà ( óíèêàëüíûé ïðîñìîòð)	 

T_oper_export
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
ENTRY_NUM	int	Yes	Yes	íîìåð ïðîâîäêè	 
ENTRY_NAME	varchar(60)	No	No	íàèìåíîâàíèå ïðîâîäêè	 
FROM_DT	varchar(21)	No	No	Äò (îòêóäà)	 
FROM_KT	varchar(21)	No	No	Êò (îòêóäà)	 
TO_DT	varchar(21)	No	No	Äò (êóäà)	 
TO_KT	varchar(21)	No	No	Êò (êóäà)	 
FROM_DT_AN1	text	No	No	àíàëèòèêà Äò 1 (îòêóäà)	 
FROM_DT_AN2	text	No	No	àíàëèòèêà Äò 2 (îòêóäà)	 
FROM_DT_AN3	text	No	No	àíàëèòèêà Äò 3 (îòêóäà)	 
FROM_DT_AN4	text	No	No	àíàëèòèêà Äò 4 (îòêóäà)	 
FROM_DT_AN5	text	No	No	àíàëèòèêà Äò 5 (îòêóäà)	 
FROM_DT_AN6	text	No	No	àíàëèòèêà Äò 6 (îòêóäà)	 
FROM_DT_AN7	text	No	No	àíàëèòèêà Äò 7 (îòêóäà)	 
FROM_KT_AN1	text	No	No	àíàëèòèêà Êò 1 (îòêóäà)	 
FROM_KT_AN2	text	No	No	àíàëèòèêà Êò 2 (îòêóäà)	 
FROM_KT_AN3	text	No	No	àíàëèòèêà Êò 3 (îòêóäà)	 
FROM_KT_AN4	text	No	No	àíàëèòèêà Êò 4 (îòêóäà)	 
FROM_KT_AN5	text	No	No	àíàëèòèêà Êò 5 (îòêóäà)	 
FROM_KT_AN6	text	No	No	àíàëèòèêà Êò 6 (îòêóäà)	 
FROM_KT_AN7	text	No	No	àíàëèòèêà Êò 7 (îòêóäà)	 
TO_DT_AN1	text	No	No	àíàëèòèêà Äò 1 (êóäà)	 
TO_DT_AN2	text	No	No	àíàëèòèêà Äò 2 (êóäà)	 
TO_DT_AN3	text	No	No	àíàëèòèêà Äò 3 (êóäà)	 
TO_DT_AN4	text	No	No	àíàëèòèêà Äò 4 (êóäà)	 
TO_DT_AN5	text	No	No	àíàëèòèêà Äò 5 (êóäà)	 
TO_DT_AN6	text	No	No	àíàëèòèêà Äò 6 (êóäà)	 
TO_DT_AN7	text	No	No	àíàëèòèêà Äò 7 (êóäà)	 
TO_KT_AN1	text	No	No	àíàëèòèêà Êò 1 (êóäà)	 
TO_KT_AN2	text	No	No	àíàëèòèêà Êò 2 (êóäà)	 
TO_KT_AN3	text	No	No	àíàëèòèêà Êò 3 (êóäà)	 
TO_KT_AN4	text	No	No	àíàëèòèêà Êò 4 (êóäà)	 
TO_KT_AN5	text	No	No	àíàëèòèêà Êò 5 (êóäà)	 
TO_KT_AN6	text	No	No	àíàëèòèêà Êò 6 (êóäà)	 
TO_KT_AN7	text	No	No	àíàëèòèêà Êò 7 (êóäà)	 
FIELD_PROPERTY	varchar(250)	No	No	óïàêîâàííûå ïàðàìåòðû	 
IS_LOG	numeric(1)	No	No	íóæåí ëè ôàéë ðàñ÷åòà	 
ENTRY_TYPE	numeric(1)	No	No	òèï èìïîðòà (1-ïðÿìîé, 2-îáðàòíûé)	 
N_FROM	varchar(20)	No	No	íàèìåíîâàíèå áëîêà (îòêóäà)	 
N_TO	varchar(20)	No	No	íàèìåíîâàíèå áëîêà (êóäà)	 
N_FROM_DT_AN	varchar(20)	No	No	íàèìåíîâàíèå áëîêà àíàëèòèêà Äò(îòêóäà)	 
N_FROM_KT_AN	varchar(20)	No	No	íàèìåíîâàíèå áëîêà àíàëèòèêà Êò(îòêóäà)	 
N_TO_DT_AN	varchar(20)	No	No	íàèìåíîâàíèå áëîêà àíàëèòèêà Äò(êóäà)	 
N_TO_KT_AN	varchar(20)	No	No	íàèìåíîâàíèå áëîêà àíàëèòèêà Êò(êóäà)	 
STATUS_NUM	text	No	No	ñòàòóñ çàïèñè	 
USL_IMPORT	text	No	No	óñëîâèå äëÿ èìïîðòà	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 

T_oper_import
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
ENTRY_NUM	int	Yes	Yes	íîìåð çàïèñè	 
S_DT	text	No	No	äåáåò	 
S_KT	text	No	No	Êðåäèò	 
S_DOKTYP_ID	text	No	No	ô-öèÿ ðàñ÷åòà òèïà äîêóìåíòà	 
S_DOC	text	No	No	ô-öèÿ ðàñ÷åòà íîìåðà äîêóìåíòà	 
S_ENTRY_DATE	text	No	No	ô-öèÿ ðàñ÷åòà äàòû äîêóìåíòà	 
S_DT_AN1	text	No	No	ô-ëà àíàëèòèêè Äò 1	 
S_DT_AN2	text	No	No	ô-ëà àíàëèòèêè Äò 2	 
S_DT_AN3	text	No	No	ô-ëà àíàëèòèêè Äò 3	 
S_DT_AN4	text	No	No	ô-ëà àíàëèòèêè Äò 4	 
S_DT_AN5	text	No	No	ô-ëà àíàëèòèêè Äò 5	 
S_DT_AN6	text	No	No	ô-ëà àíàëèòèêè Äò 6	 
S_DT_AN7	text	No	No	ô-ëà àíàëèòèêè Äò 7	 
S_KT_AN1	text	No	No	ô-ëà àíàëèòèêè Êò 1	 
S_KT_AN2	text	No	No	ô-ëà àíàëèòèêè Êò 2	 
S_KT_AN3	text	No	No	ô-ëà àíàëèòèêè Êò 3	 
S_KT_AN4	text	No	No	ô-ëà àíàëèòèêè Êò 4	 
S_KT_AN5	text	No	No	ô-ëà àíàëèòèêè Êò 5	 
S_KT_AN6	text	No	No	ô-ëà àíàëèòèêè Êò 6	 
S_KT_AN7	text	No	No	ô-ëà àíàëèòèêè Êò 7	 
S_CURR_NUM	text	No	No	ô-öèÿ ðàñ÷åòà íîìåðà âëþòû	 
S_CURR_KURS	text	No	No	ô-öèÿ ðàñ÷åòà êóðñà âàëþòû	 
S_CURR_SUMMA	text	No	No	ô-öèÿ ðàñ÷åòà ñóììû â âàëþòå	 
S_QUANTITY2	text	No	No	ô-öèÿ ðàñ÷åòà êîëè÷åñòâà 2	 
S_QUANTITY1	text	No	No	ô-öèÿ ðàñ÷åòà êîëè÷åñòâà 1	 
S_PRICE	text	No	No	ô-öèÿ ðàñ÷åòà öåíû	 
S_SUMMA	text	No	No	ô-öèÿ ðàñ÷åòà ñóììû	 
S_COMENT	text	No	No	ô-öèÿ ðàñ÷åòà êîììåíòàðèÿ	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 

T_oper_prdoc
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
PRDOCTYP_NUM	int	Yes	Yes	íîìåð âèäà äîêóìåíòà	 

T_oper_record
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
ENTRY_NUM	int	Yes	Yes	íîìåð çàïèñè	 
ENTRY_NAME	varchar(60)	No	No	íàèìåíîâàíèå çàïèñè	 
RECORD_KIND	int	No	No	âèä çàïèñè (äîêóìåíò èëè ïðîâîäêà)	 
RECORD_STATUS	int	No	No	äëÿ äîêóìåíòîâ-íîìåð, äëÿ ïðîâîäîê öèêëè÷íîñòü	 
CYCLE_NUM	int	No	No	íîìåð öèêëà (äëÿ öèêëè÷åñêîé ïðîâîäêè)	 
DOC_REGISTRY	int	No	No	íîìåð âèäà äîêóìåíòà	 
TEMPLATE_NUM	varchar(60)	No	No	íîìåð øàáëîíà äîêóìåíòà (÷òî ïå÷àòàòü)	 
NUMB_COPY	varchar(250)	No	No	ôîðìóëà êîëè÷åñòâà êîïèé íà ïå÷àòü	 
AUTO_PRINT	numeric(1)	No	No	àâòîïå÷àòü (1-àâòî, 2-ðó÷íîé)	 
AUTO_EXIT	numeric(1)	No	No	àâòîâûõîä ïîñëå ïå÷àòè (1-àâòî, 2-ðó÷íîé)	 
FIRST_ENTRY	int	No	No	íîìåð ïåðâîé çàïèñè äëÿ ÁÁ	 
USL_IMPORT	text	No	No	óñëîâèÿ âûïîëíåíèÿ ïðîâîäêè èìïîðòà èç ïðîèçâîëüíûõ îò÷åòîâ	 
RECORD_CATEGORY	int	No	No	êàòåãîðèÿ (ïðèõîä, ðàñõîä ...)	 
RECORD_MAKET	int	No	No	íîìåð ìàêåòà äëÿ äàííîé çàïèñè	 
RECORD_SCREEN	numeric(1)	No	No	òèï ýêðàíà ââîäà - àíêåòíûé èëè ãðóïïîâîé	 
RECORD_IS_CHOICE	numeric(1)	No	No	Ïðèçíàê âûáîðà	 
RECORD_DEP_CHOICE	int	No	No	Âûïîëíÿòü ïðè âûáîðå	 
STATUS_NUM	text	No	No	Ñòàòóñ çàïèñè	 
BRANCH_NUM	text	No	No	Íîìåð ïðåäïðèÿòèÿ (ôîðìóëà)	 
RECORD_DOC_FORMULA	text	No	No	ôîðìóëà äëÿ àâòîçàïîëíåíèÿ	 
RECORD_DOC_USL	text	No	No	óñëîâèå íà öèêëè÷åñêóþ ÷àñòü	 
RECORD_DOC_GRP	text	No	No	ïîëÿ äëÿ ãðóïïèðîâêè (âûïèñêà äîê-à íà îñíîâàíèè ãðóïïû äîê-â)	 
RECORD_DOC_SUM	text	No	No	ïîëÿ äëÿ ñóììèðîâàíèÿ(âûïèñêà äîê-à íà îñíîâàíèè ãðóïïû äîê-â)	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 

T_order
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
ORDER_NAME	varchar(60)	No	No	íàèìåíîâàíèå ðàçäåëà	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 

T_order_kls_form
Column List
Code	Type	P	M	Label	 
KEY_MENU	varchar(60)	Yes	Yes	ïîëíûé ïóòü ê ïóíêòó ìåíþ	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
ORDER_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå ðàçäåëà	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
ORDER_PROTOCOL	numeric(1)	No	No	âåäåíèå ïðîòîêîëà èçìåíåíèé 0-íåò, 1-äà	 

T_order_list_acc
Column List
Code	Type	P	M	Label	 
KEY_MENU	varchar(60)	Yes	Yes	ïîëíûé ïóòü ê ïóíêòó ìåíþ	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
ORDER_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå ðàçäåëà	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 

T_order_point
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ãðóïïû çàäà÷	 
ORDERPOINT_NUM	int	Yes	Yes	íîìåð ðàçäåëà	 
ORDERPOINT_NAME	varchar(60)	No	No	íàèìåíîâàíèå ðàçäåëà	 
INPUT_DATE	datetime	No	No	äàòà ââîäà (ñëóæåáíàÿ)	 

T_Ost_0_9
Column List
Code	Type	P	M	Label	 
PERIOD	datetime	Yes	Yes	Ïåðèîä - ïåðâîå ÷èñëî ìåñÿöà	 
TASK_NUM	int	Yes	Yes	id çàäà÷è	 
ACC_NUM	varchar(21)	Yes	Yes	ñ÷åò	 
AN1	numeric(9)	Yes	Yes	àíàëèòèêà 1 óð.	 
AN2	numeric(9)	Yes	Yes	àíàëèòèêà 2 óð.	 
AN3	numeric(9)	Yes	Yes	àíàëèòèêà 3 óð.	 
AN4	numeric(9)	Yes	Yes	àíàëèòèêà 4 óð.	 
AN5	numeric(9)	Yes	Yes	àíàëèòèêà 5 óð.	 
AN6	numeric(9)	Yes	Yes	àíàëèòèêà 6 óð.	 
AN7	numeric(9)	Yes	Yes	àíàëèòèêà 7 óð.	 
CURR_NUM	int	Yes	Yes	íîìåð âàëòû	 
BRANCH	numeric(9)	Yes	Yes	Ïðåäïðèÿòèå	 
STATUS_NUM	int	Yes	Yes	ñòàòóñ çàïèñè	 
SUMMA	numeric(19,2)	No	Yes	ñóììà	 
CURR_SUMMA	numeric(19,2)	No	No	ñóììà â âàëþòå	 
QUANTITY1	numeric(19,7)	No	No	êîëè÷åñòâî 1	 
QUANTITY2	numeric(19,7)	No	No	êîëè÷åñòâî 2	 

T_PERC_ACC
Column List
Code	Type	P	M	Label	 
PERC_ACC_ID	numeric(9)	Yes	Yes	óíèêàëüíûé èäåíòèôèêàòîð (autoincreament)	 
KLS_NUM	varchar(20)	No	Yes	íîìåð ëèöåâîãî ñ÷åòà	 
PERIOD_BEG	datetime	No	Yes	ïåðèîä íà÷àëà äåéñòâèÿ ÂÎ	 
PERIOD_END	datetime	No	No	ïåðèîä îêîí÷àíèÿ äåéñòâèÿ ÂÎ	 
DATA_BEG	datetime	No	No	ôàêòè÷åñêàÿ äàòà íà÷àëà äåéñòâèÿ ÂÎ	 
DATA_END	datetime	No	No	ôàêòè÷åñêàÿ äàòà îêîí÷àíèÿ äåéñòâèÿ ÂÎ	 
SUMMA	numeric(19,3)	No	No	ñóììà ëèöåâîãî ñ÷åòà	 
VO_ID	numeric(9)	No	No	id âèäà îïëàò	 
SHIFR_COST	numeric(9)	No	No	id øèôðà çàòðàò	 
SHIFR_NACH	numeric(9)	No	No	id øèôðà íà÷èñëåíèé	 
KLS_ID	numeric(9)	No	No	ññûëêà íà ñïðàâî÷íèêè (242-ïåðå÷èñëåíèÿ â áàíê, 243- àëèìåíòû)	 
BRANCH	numeric(9)	No	No	ID ïðåäïðèÿòèÿ	 
USER_ID	char(32)	No	No		 
FILIAL_USER	char(2)	No	No		 
SOURCE_PROFIT	numeric(9)	No	No	id èñòî÷íèêà âûïëàòû (214 ñïð)	 

T_PERC_LEAVE
Column List
Code	Type	P	M	Label	 
PERC_LEAVE_ID	numeric(9)	Yes	Yes	óíèêàëüíûé èäåíòèôèêàòîð (autoincreament)	 
TAB_ID	numeric(9)	No	Yes	id òàáåëüíîãî íîìåðà ñîòðóäíèêà	 
PERIOD_BEG	datetime	No	Yes	ïåðèîä íà÷àëà äåéñòâèÿ âèäà îòïóñêà	 
PERIOD_END	datetime	No	No	ïåðèîä îêîí÷àíèÿ äåéñòâèÿ âèäà îòïóñêà	 
DATA_BEG	datetime	No	No	ôàêòè÷åñêàÿ äàòà íà÷àëà äåéñòâèÿ âèäà îòïóñêà	 
DATA_END	datetime	No	No	ôàêòè÷åñêàÿ äàòà îêîí÷àíèÿ äåéñòâèÿ âèäà îòïóñêà	 
SUMMA	numeric(19,3)	No	No	÷èñëî êàëåíäàðíûõ äíåé îòïóñêà	 
LEAVE_ID	numeric(9)	No	No	id âèäà îòïóñêà	 
BRANCH	numeric(9)	No	No	ID ïðåäïðèÿòèÿ	 
USER_ID	char(32)	No	No		 
FILIAL_USER	char(2)	No	No		 
COMM	varchar(250)	No	No	êîììåíòàðèé	 

T_period_88
Column List
Code	Type	P	M	Label	 
PERIOD	datetime	Yes	Yes	Ïåðèîä - ïåðâîå ÷èñëî ìåñÿöà	 
N_BASE	numeric(6)	No	Yes	íîìåð âðåìåííîé ãðóïïû	 
P_TODAY	char(1)	No	Yes	òåêóùèé ïåðèîä	 
PERIOD_TYPE	numeric(1)	No	No	òèï ïåðèîäà (0-îáû÷íûé, 1-ñìåíà ÓÏ ñ ïåðåñ÷åòîì, 2 -áåç ïåðåñ÷åòà, 3-îñòàòêè, 4-êîððåêò)	 
PERIOD_COMMENT	varchar(250)	No	No	êîììåíòàðèé	 
PERIOD_CORP	numeric(1)	No	No	ïðèçíàê ïðàâêè ïðîâîäîê â ïåðèîäå	 

T_point
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ãðóïïû çàäà÷	 
ORDERPOINT_NUM	int	Yes	Yes	íîìåð ðàçäåëà	 
POINT_ALIAS	char(15)	Yes	Yes	óñëîâíîå îáîçíà÷åíèå ïîêàçàòåëÿ	 
POINT_PERIOD	datetime	Yes	Yes	ïåðèîä íà÷àëà ÓÏ	 
POINT_NAME	varchar(60)	No	No	íàèìåíîâàíèå ïîêàçàòåëÿ	 
POINT_FORMULA	text	No	No	ôîðìóëà	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 

T_point_result
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ãðóïïû çàäà÷	 
ORDERPOINT_NUM	int	Yes	Yes	íîìåð ðàçäåëà	 
POINT_ALIAS	char(15)	Yes	Yes	óñëîâíîå îáîçíà÷åíèå ïîêàçàòåëÿ	 
POINT_PERIOD	datetime	Yes	Yes	ïåðèîä íà÷àëà ÓÏ	 
RESULT_PERIOD	datetime	Yes	Yes	ïåðèîä õðàíåíèÿ ðåçóëüòàòà ïîêàçàòåëÿ	 
BRANCH	varchar(250)	Yes	Yes	Ñïèñîê id ïðåäïðèÿòèé ÷åðåç çàï-þ, îòñîðòèðîâàííûé ïî âîçðàñòàíèþ	 
RESULT_POINT	varchar(250)	No	No	ðåçóëüòàò ðàññ÷åòà ïîêàçàòåëÿ	 

T_prdoc_type
Column List
Code	Type	P	M	Label	 
PRDOCTYP_NUM	int	Yes	Yes	íîìåð âèäà äîêóìåíòà	 
PRDOCTYP_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå ïå÷.äîêóìåíòà	 
PRDOCTYP_BLOB	image	No	No	ôîðìà èç Formula1 èëè Crystal Report (íå çíàþ ÿ)	 
PRDOCTYP_TYPE	int	No	Yes	òèï äîêóìåíòà (1-âûõîäíûå,2-âíóòð)	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
PRDOCTYP_CHART	text	No	No	èíôîðìàöèÿ äëÿ äèàãðàìì	 
NUMB_COPY	numeric(2)	No	No	êîëè÷åñòâî êîïèé íà ïå÷àòü	 
STORED_RESULT	numeric(1)	No	No	ñîõðàíÿòü ëè ðåçóëüòàòû ðàñ÷åòà	 
AUTO_PRINT	numeric(1)	No	No	çàïóñê íà ïå÷àòü (1-àâòî, 2-ðó÷íîé)	 
AUTO_EXIT	numeric(1)	No	No	âûõîä èç ïå÷àòè (1-àâòî, 2-ðó÷íîé)	 
BLOB_PARAMS	text	No	No	ïàðàìåòðû øàáëîíà	 

T_predef_ref
Column List
Code	Type	P	M	Label	 
KLSREF_TYP	int	Yes	Yes	Òèï ñïðàâî÷íèêà	 
KLSREF_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå	 
KLSREF_SNAME	char(15)	No	Yes	Êðàòêîå íàèìåíîâàíèå	 
KLSREF_ALIAS	varchar(60)	No	Yes	Alias ñïðàâî÷íèêà, èñïîëüçóåìûé â ôîðìóëàõ	 
KLSREF_NUMB	numeric(1)	No	No	åñòü ëè êîë-âî â ñïðàâî÷íèêå	 
KLSREF_NUMTYPE	numeric(1)	No	No	òèï íóìåðàöèè (ñêâîçíàÿ, íåñêâîçíàÿ)	 
KLSREF_ANALYTIC	numeric(1)	No	No	àíàëèòè÷åñêèé ëè ñïðàâî÷íèê	 
KLSREF_PICTURE	varchar(20)	No	No	Øàáëîí äëÿ âûâîäà íîìåðà âî ââîäå	 
KLSREF_TITLE_NUM	varchar(20)	No	No	êàê ïîêàçûâàåòñÿ â çàãîëîâêàõ íîìåð (íàïðèìåð: êîä)	 
KLSREF_TITLE_NAME	varchar(60)	No	No	êàê ïîêàçûâàåòñÿ â çàãîëîâêàõ íàèìåíîâàíèå (íàïðèìåð: ôàìèëèÿ)	 
IS_SINGLE	numeric(1)	No	No	åäèíñòâåííîñòü	 
IS_DELETE	numeric(1)	No	No	ìîæíî ëè óäàëèòü	 
PROJECT_NUM	int	No	No	íîìåð ïðîåêòà	 
KLSREF_ISEDIT	int	No	No	âîçìîæíîñòü ïðàâêè	 

T_predef_ref_spr
Column List
Code	Type	P	M	Label	 
KLSREF_TYP	int	Yes	Yes	Òèï ñïðàâî÷íèêà	 
SPR_SNAME	varchar(60)	Yes	Yes	íàèìåíîâàíèå ïîëåé ñïðàâî÷íèêîâ (ðåàëüíîå)	 
SPR_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå ïîëåé ñïðàâî÷íèêîâ (ïîëüçîâàòåëüñêèå)	 
SPR_ALIAS	char(15)	No	Yes	íàèìåíîâàíèå ïîëåé ñïðàâî÷íèêîâ (ïîëüçîâàòåëüñêèå óñë.îáîçíà÷åíèÿ)	 
SPR_TYPE	char(2)	No	Yes	òèï ïîëåé ñïðàâî÷íèêîâ	 
SPR_TYPELEN	numeric(3)	No	Yes	Êîë-âî ñèìâîëîâ (äëèíà)	 
SPR_TYPELEN2	numeric(2)	No	Yes	Êîë-âî ñèìâîëîâ ïîñëå çàïÿòîé	 
SPR_NULL	int	No	Yes	ïîëå-ññûëêà íà äð.ñïðàâî÷íèê	 
SPR_DEFAULT	varchar(100)	No	No	Çíà÷åíèå ïî óìîë÷àíèþ äëÿ ïîëåé NOT NULL	 
SPR_NEXT	int	No	Yes	ïîëå-ññûëêà íà äð.ñïðàâî÷íèê	 
SPR_LIST	text	No	No	çíà÷åíèÿ äëÿ ïîëåé òèïà ñïèñîê	 
SPR_ORDER	integer	No	No	ïîðÿäîê ïîëåé	 
TABLE_NAME	varchar(20)	No	No	èìÿ òàáëèöû, â êîòîðîé ñîäåðæèòñÿ ïîëå	 
SPR_UNIQUE	numeric(1)	No	No	êîíòðîëü óíèêàëüíîñòè çíà÷åíèÿ (1-íåò, 2 - äà) ïî óìîë÷àíèþ "íåò"	 
PROJECT_NUM	int	No	No	íîìåð ïðîåêòà , äëÿ êîòîðîãî ïîëå	 

T_PRICE
Column List
Code	Type	P	M	Label	 
KLS_ID	numeric(9)	Yes	Yes	id òîâàðà (ññûëêà íà ñïðâàî÷íèê òîâàðîâ)	 
PRICE_DATE	datetime	Yes	Yes	Äàòà ïðàéñà	 
CURR_NUM	int	Yes	Yes	Íîìåð âàëþòû (ññûëêà íà ñïðàâî÷íèê âàëþò)	 
BRANCH	numeric(9)	Yes	Yes	id ïðåäïðèÿòèÿ	 
QUANTITY2	numeric(19,7)	No	No	Êîëè÷åñòâî ìåëêîîïòîâîå	 
QUANTITY3	numeric(19,7)	No	No	Êîëè÷åñòâî îïòîâîå	 
PRICE1	numeric(19,7)	No	No	Öåíà ðîçíè÷íàÿ ðóáëåâàÿ	 
PRICE2	numeric(19,7)	No	No	Öåíà ìåëêîîïòîâàÿ ðóáëåâàÿ	 
PRICE3	numeric(19,7)	No	No	Öåíà îïòîâàÿ ðóáëåâàÿ	 
CURR_KURS	numeric(19,10)	No	No	êóðñ âàëþòû	 
PRICE_VAL1	numeric(19,7)	No	No	Öåíà ðîçíè÷íàÿ âàëþòíàÿ	 
PRICE_VAL2	numeric(19,7)	No	No	Öåíà ìåëêîîïòîâàÿ âàëþòíàÿ	 
PRICE_VAL3	numeric(19,7)	No	No	Öåíà îïòîâàÿ âàëþòíàÿ	 
STATUS	numeric(1)	No	No	Ïðèçíàê : äåéñòâóåò/ íå äåéñòâóåò	 
USER_ID	char(32)	No	No	àâòîð	 
USER_ID_EDIT	char(32)	No	No	ðåäàêòîð	 
CREAT_DATE	timestamp	No	No	äàòà ñîçäàíèÿ çàïèñè	 
INPUT_DATE	timestamp	No	No	äàòà èçìåíåíèÿ çàïèñè	 

T_project
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
PROJECT_NAME	varchar(60)	No	Yes	èìÿ ïðîåêòà	 
PROJECT_VERSION	varchar(20)	No	No	íîìåð âåðñèè	 
PROJECT_ACC_LEN	numeric(2)	No	Yes	ðàçðÿäíîñòü ñ÷åòà	 
PROJECT_VID	int	No	No	òåêùèé âèä äåÿòåëüíîñòè	 
PROJECT_LETTER	char(5)	No	No	ïåðâàÿ áóêâà ñëóæåáíîãî ñ÷åòà	 
PROJECT_PROPERTY	varchar(250)	No	No	ñâîéñòâà ïðîåêòà	 
PROJECT_PROTOCOL	numeric(1)	No	No	âåäåíèå ïðîòîêîëà èçìåíåíèé 0-íåò, 1-äà	 

T_projecttree
Column List
Code	Type	P	M	Label	 
PT_ID	numeric(9,0)	Yes	Yes	àâòîèíêðåìåíòíîå ïîëå	 
PT_PARENTID	numeric(9)	No	Yes	ññûëêà íà ðîäèòåëÿ	 
PT_ORDER	int	No	Yes	íîìåð ïóíêòà ìåíþ (êàê íà ýêðàíå)	 
PT_LEVEL1	numeric(3)	No	Yes	ññûëêà íà 1-é óðîâåíü	 
PT_LEVEL2	numeric(3)	No	Yes	ññûëêà íà 2-é óðîâåíü	 
PT_LEVEL3	numeric(3)	No	Yes	ññûëêà íà 3-é óðîâåíü	 
PT_LEVEL4	numeric(3)	No	Yes	ññûëêà íà 4-é óðîâåíü	 
PT_CODE	int	No	Yes	êîä ïóíêòà ìåíþ (âñå ññûëêè íà íåãî!)	 
PT_VISIBLENAME	varchar(60)	No	Yes	ñàìî íàèìåíîâàíèå	 
PT_CAPTION1	varchar(60)	No	No	ïîëíîå íàèìåíîâàíèå	 
PT_CAPTION2	varchar(60)	No	No	êðàòêîå íàèìåíîâàíèå	 
PT_ARGUMENT	text	No	No	àðãóìåíòû âûçîâà êëàññà	 
PT_HLP_CODE	varchar(60)	No	No	èíôîðìàöèÿ î ïðèâÿçàííîì HELPå	 
ITEM_CODE	int	No	No	íîìåð êëàññà	 
UNDERLINE	numeric(1)	No	No	ïîä÷åðêèâàíèå	 
IMAGE_TYPE	numeric(1)	No	No	Òèï êàðòèíêè (1-ãë. ìåíþ, 2 - ïîëüçîâàòåëüñêàÿ...)	 
IMAGE_NUM	int	No	No	íîìåð êàðòèíêè	 
PT_PLAY	text	No	No	ñòðîêà ñ çàïèñüþ äëÿ "ïðîèãðûâàíèÿ"	 

T_protocol_log
Column List
Code	Type	P	M	Label	 
PROTOCOL_ID	numeric(9,0)	Yes	Yes	óíèêàëüíûé èäåíòèôèêàòîð	 
PROTOCOL_DATE	datetime	No	Yes	äàòà ïðîòîêîëà	 
PROTOCOL_HOST	varchar(250)	No	No	èìÿ HOST-ìàøèíû	 
PROTOCOL_LOGIN	varchar(60)	No	Yes	ëîãèí ïîëüçîâàòåëÿ	 
PROTOCOL_TYPE	numeric(1)	No	Yes	òèï çàïèñè (0-èçìåíåííàÿ/1-óäàëåííàÿ)	 

T_reestr_del
Column List
Code	Type	P	M	Label	 
DOKTYP_ID	int	Yes	Yes	íîìåð òèïà äîêóìåíòà	 
REGIST_NUM	char(20)	Yes	Yes	íîìåð äîêóìåíòà	 
REGIST_PERIOD	datetime	Yes	Yes	ïåðèîä ðåãèñòðàöèè	 
BRANCH	numeric(9)	Yes	Yes	ïðåäïðèÿòèå	 
SEND	numeric(1)	No	No	èçìåíåíà ëè çàïèñü (äëÿ êîðïîð. Null-äà)	 
OPER_IDENT	char(26)	No	No	èäèíòèôèêàòîð îïåðàöèè	 

T_ref_spr
Column List
Code	Type	P	M	Label	 
KLSREF_NUM	int	Yes	Yes	íîìåð ñïðàâî÷íèêà	 
SPR_NUM	int	Yes	Yes	Íîìåð ïîëÿ	 
SPR_SNAME	varchar(60)	No	Yes	íàèìåíîâàíèå ïîëåé ñïðàâî÷íèêîâ (ðåàëüíîå)	 
SPR_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå ïîëåé ñïðàâî÷íèêîâ (ïîëüçîâàòåëüñêèå)	 
SPR_ALIAS	char(15)	No	Yes	íàèìåíîâàíèå ïîëåé ñïðàâî÷íèêîâ (ïîëüçîâàòåëüñêèå óñë.îáîçíà÷åíèÿ)	 
SPR_TYPE	char(2)	No	Yes	òèï ïîëåé ñïðàâî÷íèêîâ	 
SPR_TYPELEN	numeric(3)	No	Yes	Êîë-âî ñèìâîëîâ (äëèíà)	 
SPR_TYPELEN2	numeric(2)	No	Yes	Êîë-âî ñèìâîëîâ ïîñëå çàïÿòîé	 
SPR_NULL	int	No	Yes	ïîëå-ññûëêà íà äð.ñïðàâî÷íèê	 
SPR_DEFAULT	varchar(100)	No	No	Çíà÷åíèå ïî óìîë÷àíèþ äëÿ ïîëåé NOT NULL	 
SPR_NEXT	int	No	Yes	ïîëå-ññûëêà íà äð.ñïðàâî÷íèê	 
SPR_SERVISE	numeric(1)	No	No	Ñëóæåáíîå èëè ïîëüçîâàòåëüñêîå	 
SPR_CARGO0	varchar(30)	No	No	ðàñøèôðîâêà 0 äëÿ bit	 
SPR_CARGO1	varchar(30)	No	No	ðàñøèôðîâêà 1 äëÿ bit	 
SPR_LIST	text	No	No	çíà÷åíèÿ äëÿ ïîëåé òèïà ñïèñîê	 
SPR_ORDER	integer	No	No	ïîðÿäîê ââîäà ïîëÿ	 
TABLE_NAME	varchar(30)	No	No	èìÿ òàáëèöû, ãäå íàõîäèòñÿ êîëîíêà	 
SPR_UNIQUE	numeric(1)	No	No	êîíòðîëü óíèêàëüíîñòè çíà÷åíèÿ (1-íåò, 2 - äà) ïî óìîë÷àíèþ "íåò"	 
PROJECT_NUM	int	No	No	íîìåð ïðîåêòà , äëÿ êîòîðîãî ïîëå	 
SPR_PROPERTY	varchar(250)	No	No	Ñâîéñòâà (àâòî, âèäèìîñòü è ò. ä.)	 
SPR_FORMULA	text	No	No	Ôîðìóëà	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà/èçìåíåíèÿ (ñëóæåáíàÿ)	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 
SPR_IMPORT_SEARCH	numeric(1)	No	No	Ïðèçíàê ïîèñêà ïî ïîëþ ñóùåñòâóþùèõ çàïèñåé äëÿ êîðïîðàòîðà (0-íåò, 1-äà)	 

T_reg_print
Column List
Code	Type	P	M	Label	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
REG_CLASS	varchar(60)	Yes	Yes	óíèêàëüíîå èìÿ êëàññà	 
REG_NUM	varchar(60)	Yes	Yes	ðåæèì çàäà÷è	 
REG_ADVANSED	varchar(60)	Yes	Yes	äîïîëíèòåëüíîå ïîëå äëÿ êëþ÷à (ïðèìåð - óðîâåíü îáîðîòêè)	 
PRINT_NUM	int	Yes	Yes	íîìåð øàáëîíà	 
NEW_FORM	numeric(1)	Yes	Yes		 
PRINT_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå øàáëîíà	 
PRINT_TYPE	int	No	No	òèï äîêóìåíòà (êðàòêèé, ïîëíûé è ò.ä.)	 
INPUT_DATE	datetime	No	Yes	ñëóæåáíàÿ äàòà ââîäà	 
NDT_TYPE	int	No	Yes	øàáëîí äëÿ âñåõ òèïîâ ïðîñìòîðîâ èëè äëÿ óêàçàííîãî	 
REG_TYPE	int	No	No	òèï ðåæèìà çàäà÷è (ñ÷åò 1, ñïðàâî÷íèê 2, ðàçäåë 3, ðååñòð 4)	 
NUMB_COPY	numeric(2)	No	No	êîëè÷åñòâî êîïèé íà ïå÷àòü	 
STORED_RESULT	numeric(1)	No	No	ñîõðàíÿòü ëè ðåçóëüòàòû ðàñ÷åòà	 
AUTO_PRINT	numeric(1)	No	No	çàïóñê íà ïå÷àòü (1-àâòî, 2-ðó÷íîé)	 
AUTO_EXIT	numeric(1)	No	No	âûõîä èç ïå÷àòè (1-àâòî, 2-ðó÷íîé)	 
PRINT_FORMAT	numeric(1)	No	No		 

T_reg_print_blob
Column List
Code	Type	P	M	Label	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
REG_CLASS	varchar(60)	Yes	Yes	óíèêàëüíîå èìÿ êëàññà	 
REG_NUM	varchar(60)	Yes	Yes	ðåæèì çàäà÷è	 
REG_ADVANSED	varchar(60)	Yes	Yes	äîïîëíèòåëüíîå ïîëå äëÿ êëþ÷à (ïðèìåð - óðîâåíü îáîðîòêè)	 
PRINT_NUM	int	Yes	Yes	íîìåð øàáëîíà	 
NEW_FORM	numeric(1)	Yes	Yes		 
PRINT_BLOB	image	No	No	øàáëîí äîêóìåíòà	 
BLOB_PARAMS	text	No	No	ïàðàìåòðû øàáëîíà	 

T_reg_print_branch
Column List
Code	Type	P	M	Label	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
REG_CLASS	varchar(60)	Yes	Yes	óíèêàëüíîå èìÿ êëàññà	 
REG_NUM	varchar(60)	Yes	Yes	ðåæèì çàäà÷è	 
REG_ADVANSED	varchar(60)	Yes	Yes	äîïîëíèòåëüíîå ïîëå äëÿ êëþ÷à (ïðèìåð - óðîâåíü îáîðîòêè)	 
PRINT_NUM	int	Yes	Yes	íîìåð øàáëîíà	 
NEW_FORM	numeric(1)	Yes	Yes		 
BRANCH	varchar(250)	Yes	Yes	íîìåð ïðåäïðèÿòèÿ (âîçìîæåí ñïèñîê)	 
PRINT_SPEC	varchar(250)	Yes	Yes	Óòî÷íåíèå (äëÿ äîêóìåíòîâ - íîìåð + ïåðèîä ðåãèñòðàöèè)	 
PRINT_DOC	image	No	No	ðàññ÷èòàííûé äîêóìåíò	 
INPUT_DATE	datetime	No	Yes		 

T_REKV
Column List
Code	Type	P	M	Label	 
DOKTYP_ID	int	Yes	Yes	id  òèïà äîê-òà	 
REKV_TYPE	numeric(1)	Yes	Yes	òèï ðåêâèçèòà (1-øàïêà, 2-òàáëèöà, 3-ïîäâàë)	 
REKV_ORDER	numeric(9)	Yes	Yes	ïîðÿäîê âûâîäà	 
REKV_ALIAS	varchar(20)	No	Yes	óñëîâíîå îáîçíà÷åíèå	 
REKV_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå	 
REKV_FORMULA	text	No	No	ôîðìóëà	 
REKV_EMPTY_PASS	numeric(1)	No	No	íå çàïîëíÿòü åñëè ïóñò (1 - äà, 2 -íåò)	 
REKV_EMPTY_ERROR	numeric(1)	No	No	ïðèçíàê îøèáêè íà ïóñòîòå (1 - äà, 2 - íåò)	 
REKV_USL_FORMULA	text	No	No	óñëîâèå çàïîëíåíèÿ - ôîðìóëà	 

T_reserv_num
Column List
Code	Type	P	M	Label	 
USER_ID	char(32)	Yes	Yes	id ïîëüçîâàòåëÿ	 
TABLE_NAME	char(30)	Yes	Yes	èìÿ òàáëèöû	 
SPR_NUM	int	Yes	Yes	íîìåð ñïðàâî÷íèêà	 
FILTER_NUM	varchar(100)	Yes	Yes	ðîäèòåëü èëè óñëîâèå äëÿ ïðàâèëüíîãî èäåíòèôèöèðîâàíèÿ íîìåðà	 
RESERV_NUM	char(30)	Yes	Yes	çàðåçåðâèðîâàííûé íîìåð	 
RESERV_TYPE	numeric(1)	No	No	òèï áëîêèðîâêè (0-èñêëþ÷èòåëüíàÿ, 1-íà ÷òåíèå)	 
TASK_NUM	int	No	No	íîìåð çàäà÷è	 
USER_SPID	int	No	No	id êîííåêòà	 
RESERV_DIGIT_NUM	numeric(20)	No	No	÷èñëîâîé íîìåð	 

T_rule
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
ENTRY_NUM	int	Yes	Yes	íîìåð çàïèñè	 
RULE_ALIAS	varchar(20)	Yes	Yes	àëèàñ ïîëÿ	 
RULE_TYPE	numeric(2)	Yes	Yes	òèï ïðàâèëà (0-áèçíåñ ïðàâèëî, 1-ìàðøðóòèçàöèÿ)	 
RULE_NUM	int	Yes	Yes	íîìåð ïðàâèëà	 
RULE_NAME	varchar(60)	No	No	íàèìåíîâàíèå ïðàâèëà	 
RULE_STATUS	numeric(1)	No	No	ñòàòóñ ïðàâèëà (1-îøèáêà, 2-ïðåäóïðåæäåíèå, 3-ñîîáùåíèå)	 
RULE_FORMULA	text	No	No	ôîðìóëà ïðàâèëà (óñëîâèå)	 
RULE_TEXT	text	No	No	òåêñò ñîîáùåíèÿ	 
RULE_WORK	numeric(2)	No	No	âûïîëíÿòü  (0-äîáàâëåíèå,  1- êîððåêòèðîâêà, 2 - âñåãäà)	 

T_SALBOOK_ENTRY
Column List
Code	Type	P	M	Label	 
KLS_ID	numeric(9)	Yes	Yes	Id æóðíàëà îðäåðà(209 ñïð-ê)	 
SBE_NUM	int	Yes	Yes	Íîìåð	 
SBE_NAME	varchar(60)	No	No	Íàèìåíîâàíèå	 
SBE_GROUPBY	numeric(1)	No	No	Ãðóïïèðîâàòü (äà/íåò)	 
SBE_BRANCH	text	No	No	Ïðåäïðèÿòèå	 
SBE_PODR	text	No	No	Ïîäðàçäåëåíèå	 
SBE_TAB	text	No	No	Òàáåëüíûé	 
SBE_VO	text	No	No	Âèä îïëàò	 
SBE_SHIFR_NACH	text	No	No	Øèôð íà÷èñëåíèé	 
SBE_SHIFR_COST	text	No	No	Øèôð çàòðàò	 
SBE_SOURCE_PROFIT	text	No	No	Èñòî÷íèê ôèíàíñèðîâàíèÿ	 
SBE_COMM	text	No	No	Êîììåíòàðèé	 
SBE_DT	varchar(21)	No	No	Äåáåò	 
SBE_KT	varchar(21)	No	No	Êðåäèò	 
SBE_DT_AN1	text	No	No	Àíàëèòèêà Äò1	 
SBE_DT_AN2	text	No	No	Àíàëèòèêà Äò2	 
SBE_DT_AN3	text	No	No	Àíàëèòèêà Äò3	 
SBE_DT_AN4	text	No	No	Àíàëèòèêà Äò4	 
SBE_DT_AN5	text	No	No	Àíàëèòèêà Äò5	 
SBE_DT_AN6	text	No	No	Àíàëèòèêà Äò6	 
SBE_DT_AN7	text	No	No	Àíàëèòèêà Äò7	 
SBE_KT_AN1	text	No	No	Àíàëèòèêà Êò1	 
SBE_KT_AN2	text	No	No	Àíàëèòèêà Êò2	 
SBE_KT_AN3	text	No	No	Àíàëèòèêà Êò3	 
SBE_KT_AN4	text	No	No	Àíàëèòèêà Êò4	 
SBE_KT_AN5	text	No	No	Àíàëèòèêà Êò5	 
SBE_KT_AN6	text	No	No	Àíàëèòèêà Êò6	 
SBE_KT_AN7	text	No	No	Àíàëèòèêà Êò7	 
SBE_DT_AN1_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò1	 
SBE_DT_AN2_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò2	 
SBE_DT_AN3_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò3	 
SBE_DT_AN4_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò4	 
SBE_DT_AN5_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò5	 
SBE_DT_AN6_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò6	 
SBE_DT_AN7_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò7	 
SBE_KT_AN1_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò1	 
SBE_KT_AN2_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò2	 
SBE_KT_AN3_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò3	 
SBE_KT_AN4_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò4	 
SBE_KT_AN5_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò5	 
SBE_KT_AN6_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò6	 
SBE_KT_AN7_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò7	 

T_SALBOOK_LIST
Column List
Code	Type	P	M	Label	 
KLS_ID	numeric(9)	Yes	Yes	Id æóðíàëà îðäåðà(209 ñïð-ê)	 
SBL_NUM	int	Yes	Yes	Íîìåð	 
SBL_NAME	varchar(60)	No	No	Íàèìåíîâàíèå	 
SBL_FORMULA	text	No	No	Ôîðìóëà	 
SBL_DT	varchar(21)	No	No	Äåáåò	 
SBL_KT	varchar(21)	No	No	Êðåäèò	 
SBL_DT_AN1	text	No	No	Àíàëèòèêà Äò1	 
SBL_DT_AN2	text	No	No	Àíàëèòèêà Äò2	 
SBL_DT_AN3	text	No	No	Àíàëèòèêà Äò3	 
SBL_DT_AN4	text	No	No	Àíàëèòèêà Äò4	 
SBL_DT_AN5	text	No	No	Àíàëèòèêà Äò5	 
SBL_DT_AN6	text	No	No	Àíàëèòèêà Äò6	 
SBL_DT_AN7	text	No	No	Àíàëèòèêà Äò7	 
SBL_KT_AN1	text	No	No	Àíàëèòèêà Êò1	 
SBL_KT_AN2	text	No	No	Àíàëèòèêà Êò2	 
SBL_KT_AN3	text	No	No	Àíàëèòèêà Êò3	 
SBL_KT_AN4	text	No	No	Àíàëèòèêà Êò4	 
SBL_KT_AN5	text	No	No	Àíàëèòèêà Êò5	 
SBL_KT_AN6	text	No	No	Àíàëèòèêà Êò6	 
SBL_KT_AN7	text	No	No	Àíàëèòèêà Êò7	 
SBL_COMM	text	No	No	Êîììåíòàðèé	 
SBL_DT_AN1_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò1	 
SBL_DT_AN2_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò2	 
SBL_DT_AN3_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò3	 
SBL_DT_AN4_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò4	 
SBL_DT_AN5_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò5	 
SBL_DT_AN6_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò6	 
SBL_DT_AN7_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò7	 
SBL_KT_AN1_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò1	 
SBL_KT_AN2_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò2	 
SBL_KT_AN3_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò3	 
SBL_KT_AN4_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò4	 
SBL_KT_AN5_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò5	 
SBL_KT_AN6_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò6	 
SBL_KT_AN7_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò7	 

T_semafor
Column List
Code	Type	P	M	Label	 
SEM_REGIM	varchar(250)	Yes	Yes	ðåæèì (÷òî ïðîèñõîäèò)	 
USER_ID	char(32)	Yes	Yes	id ïîëüçîâàòåëÿ	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
SEM_PROCESS	int	No	No	ïðîöåññ (êàê ïðîèñõîäèò)	 
USER_SPID	int	No	No	id êîííåêòà	 

T_shedule_backup
Column List
Code	Type	P	M	Label	 
SHB_NUM	int	Yes	Yes	íîìåð çàäàíèÿ	 
SHB_NAME	varchar(60)	No	No	íàèìåíîâàíèå çàäàíèÿ	 
SHB_TYPE_PERIOD	numeric(1)	No	No	Ïåðèîäè÷íîñòü	 
SHB_DAY	numeric(2)	No	No	Äåíü	 
SHB_TIME	datetime	No	No	Âðåìÿ	 
SHB_PATH	text	No	No	ôàéë(ïóòü)	 
SHB_DATE	datetime	No	No	äàòà ïîñëåäíåãî çàïóñêà	 
SHB_OK	numeric(1)	No	No	óñïåøíîñòü âûïîëíåíèÿ	 

T_spr_rule
Column List
Code	Type	P	M	Label	 
KLSREF_NUM	int	Yes	Yes	íîìåð ñïðàâî÷íèêà	 
RULE_ALIAS	varchar(20)	Yes	Yes	àëèàñ ïîëÿ	 
RULE_NUM	int	Yes	Yes	íîìåð ïðàâèëà	 
RULE_NAME	varchar(60)	No	No	íàèìåíîâàíèå ïðàâèëà	 
RULE_STATUS	numeric(1)	No	No	ñòàòóñ ïðàâèëà (0-îøèáêà, 1-ïðåäóïðåæäåíèå, 2-ñîîáùåíèå)	 
RULE_FORMULA	text	No	No	ôîðìóëà ïðàâèëà (óñëîâèå)	 
RULE_TEXT	text	No	No	òåêñò ñîîáùåíèÿ	 
RULE_TYPE	numeric(1)	No	No	Òèï ïðàâèëà (âåçäå, äîáàâëåíèå, êîððåêòèðîâêà)	 

T_STAFF
Column List
Code	Type	P	M	Label	 
STAFF_ID	numeric(9)	Yes	Yes	óíèêàëüíûé èäåíòèôèêàòîð (autoincreament)	 
PODR_ID	numeric(9)	No	Yes	id ïîäðàçäåëåíèÿ	 
POST_ID	numeric(9)	No	Yes	id äîëæíîñòè	 
TAB_ID	numeric(9)	No	Yes	id òàáåëüíîãî íîìåðà	 
KLS_NUM	char(20)	No	Yes	íîìåð ëèöåâîãî ñ÷åòà	 
PERIOD_BEG	datetime	No	Yes	ïåðèîä íà÷àëà ðàáîòû	 
PERIOD_END	datetime	No	No	ïåðèîä îêîí÷àíèÿ ðàáîòû	 
BEG_WORK	datetime	No	Yes	ôàêòè÷åñêàÿ äàòà íà÷àëà ðàáîòû	 
END_WORK	datetime	No	No	ôàêòè÷åñêàÿ äàòà îêîí÷àíèÿ ðàáîòû	 
NED_ID	numeric(9)	No	Yes	id ðàáî÷åé íåäåëè	 
POST_INFO	varchar(30)	No	No	èíôîðìàöèÿ î äîëæíîñòè (1-îñíîâíàÿ,2-ñîâìåñòèòåëü)	 
QUANTITY	numeric(19,2)	No	No	ñòàâêà	 
RATE	numeric(19,2)	No	No	ñòàâêà	 
KLS_DIGIT_NUM	numeric(20)	No	No	÷èñëîâîé íîìåð ëèöåâîãî ñ÷åòà	 
BRANCH	numeric(9)	No	No		 
IN_STAFF	numeric(2)	No	No		 
FACT_BEG_WORK	datetime	No	No	Ôàêòè÷åñêàÿ äàòà  ïðèåìà íà ðàáîòó â äàííîå ïðåäïðèÿòèå	 
FACT_END_WORK	datetime	No	No	Ôàêòè÷åñêàÿ äàòà  óâîëüíåíèÿ èç äàííîãî ïðåäïðèÿòèÿ	 

T_STAFF_DISTRIBUTION
Column List
Code	Type	P	M	Label	 
PODR_ID	numeric(9)	Yes	Yes	Id ïîäðàçäåëåíèÿ	 
POST_ID	numeric(9)	Yes	Yes	Id äîëæíîñòè	 
TAB_ID	numeric(9)	Yes	Yes	Id òàáåëüíîãî íîìåðà	 
QUANTITY	numeric(19,2)	No	No	Êîëè÷åñòâî ñòàâîê	 
RATE	numeric(19,3)	No	No	Ñòàâêà	 
ADDITION1	numeric(19,2)	No	No	Íàäáàâêà1	 
ADDITION2	numeric(19,2)	No	No	Íàäáàâêà2	 
ADDITION3	numeric(19,2)	No	No	Íàäáàâêà3	 
DATE_BEG	datetime	No	No	Äàòà íà÷àëà	 
DATE_END	datetime	No	No	Äàòà îêîí÷àíèÿ	 
STAFF_TYPE	numeric(1)	No	No	Ñòàòóñ (â øòàòå/ çà øòàòîì)	 
USER_ID	char(32)	No	No		 
FILIAL_USER	char(2)	No	No		 
STAFF_NUM	int	Yes	Yes	Íîìåð øòàòíîãî	 
ADDITION4	numeric(19,2)	No	No	Íàäáàâêà4	 
ADDITION5	numeric(19,2)	No	No	Íàäáàâêà5	 
ADDITION6	numeric(19,2)	No	No	Íàäáàâêà6	 
ADDITION7	numeric(19,2)	No	No	Íàäáàâêà7	 
ADDITION8	numeric(19,2)	No	No	Íàäáàâêà8	 
ADDITION9	numeric(19,2)	No	No	Íàäáàâêà9	 
ADDITION10	numeric(19,2)	No	No	Íàäáàâêà10	 

T_STAFF_LIST
Column List
Code	Type	P	M	Label	 
STAFF_NUM	int	Yes	Yes	Íîìåð øòàòíîãî	 
STAFF_NAME	varchar(60)	No	No	Íàèìåíîâàíèå øòàòíîãî	 
STAFF_DATE_BEG	datetime	No	No	Äàòà ïðèíÿòèÿ	 
STAFF_DATE_END	datetime	No	No	Äàòà îêîí÷àíèÿ	 
STAFF_STATUS	numeric(1)	No	No	Ñòàòóñ (äåéñòâóþùèå, àðõèâ, ïðîåêò)	 
USER_ID	char(32)	No	No	id ïîëüçîâàòåëÿ	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 

T_STAFF_TABLE
Column List
Code	Type	P	M	Label	 
PODR_ID	numeric(9)	Yes	Yes	Id ïîäðàçäåëåíèÿ	 
POST_ID	numeric(9)	Yes	Yes	Id äîëæíîñòè	 
QUANTITY	numeric(19,2)	No	No	Êîëè÷åñòâî ñòàâîê	 
RATE_MIN	numeric(19,3)	No	No	Ñòàâêà ìèíèìàëüíàÿ	 
RATE_MAX	numeric(19,3)	No	No	Ñòàâêà ìàêñèìàëüíàÿ	 
RATE	numeric(19,3)	No	No	Ñòàâêà ðåêîìåíäóåìàÿ	 
ADDITION1	numeric(19,2)	No	No	Íàäáàâêà1	 
ADDITION2	numeric(19,2)	No	No	Íàäáàâêà2	 
ADDITION3	numeric(19,2)	No	No	Íàäáàâêà3	 
DATE_BEG	datetime	No	No	Äàòà íà÷àëà	 
DATE_END	datetime	No	No	Äàòà îêîí÷àíèÿ	 
PRIORITY	numeric(2)	No	No	Ïðèîðèòåò (äëÿ ñîðòèðîâêè)	 
USER_ID	char(32)	No	No	id ïîëüçîâàòåëÿ	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 
STAFF_NUM	int	Yes	Yes	Íîìåð øòàòíîãî	 
ADDITION4	numeric(19,2)	No	No	Íàäáàâêà4	 
ADDITION5	numeric(19,2)	No	No	Íàäáàâêà5	 
ADDITION6	numeric(19,2)	No	No	Íàäáàâêà6	 
ADDITION7	numeric(19,2)	No	No	Íàäáàâêà7	 
ADDITION8	numeric(19,2)	No	No	Íàäáàâêà8	 
ADDITION9	numeric(19,2)	No	No	Íàäáàâêà9	 
ADDITION10	numeric(19,2)	No	No	Íàäáàâêà10	 

T_status
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ãðóïïû çàäà÷	 
STATUS_NUM	int	Yes	Yes	ñòàòóñ	 
STATUS_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå ñòàòóñà	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 

T_step
Column List
Code	Type	P	M	Label	 
JOB_NUM	int	Yes	Yes	íîìåð çàäàíèÿ	 
STEP_NUM	int	Yes	Yes	íîìåð øàãà	 
STEP_NAME	varchar(60)	No	No	íàèìåíîâàíèå øàãà	 
STEP_STRING	text	No	No	Ñòðîêà çàïóñêà	 
STEP_ACTIVE	numeric(1)	No	Yes	àêòèâíîñòü	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	No	íîìåð ïîëüçîâàòåëÿ	 

T_TAB_ACCOUNT_0_9
Column List
Code	Type	P	M	Label	 
KLS_NUM	varchar(20)	Yes	Yes	íîìåð ëèöåâîãî ñ÷åòà	 
PODR_ID	numeric(9)	Yes	Yes	id ïîäðàçäåëåíèÿ	 
TAB_ACCOUNT_DATE	datetime	Yes	Yes	äàòà	 
TAB_WORK_ID	numeric(9)	Yes	Yes	id âèäà ðàáîò	 
POST_ID	numeric(9)	No	Yes	id äîëæíîñòè	 
TAB_ACCOUNT_HOURS	numeric(4,2)	No	No	êîëè÷åñòâî îòðàáîòàííûõ ÷àñîâ	 
KLSOPER_NUM	int	No	No	Íîìåð îïåðàöèè èìïîðòà	 

T_TAB_IMPORT
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
ORDER_NUM	int	Yes	Yes	id  ðàçäåëà	 
KLSOPER_TYPE	numeric(2)	Yes	Yes	òèï îïåðàöèè (ñòàíäàðòíàÿ,àâòî è ò.ä.)	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
VID_NUM	int	Yes	Yes	âèä äåÿòåëüíîñòè	 
KLSOPER_NUM	int	Yes	Yes	Íîìåð íàñòðîéêè îïåðàöèè	 
KLSOPER_DATEBEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
ENTRY_NUM	int	Yes	Yes	íîìåð çàïèñè	 
S_DATE	text	No	No	Äàòà (ôîðìóëà)	 
S_TABN	text	No	No	Íîìåð ëèöåâîãî ñ÷åòà (ôîðìóëà)	 
S_WORK	text	No	No	Âèä ðàáîòû (ôîðìóëà)	 
S_HOURS	text	No	No	×àñû (ôîðìóëà)	 

T_Task
Column List
Code	Type	P	M	Label	 
TASK_NUM	int	Yes	Yes	id çàäà÷è	 
PROJECT_NUM	int	No	No	íîìåð ïðîåêòà	 
TASK_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå çàäà÷è	 
TASK_VERSION	varchar(20)	No	No	íîìåð âåðñèè	 
TASK_TYPE	int	No	No	òèï çàäà÷è	 
HASP_KEY	int	No	No	êîä â êëþ÷å HASP	 

T_task_entity
Column List
Code	Type	P	M	Label	 
TASK_NUM	int	Yes	Yes	id çàäà÷è	 
ENTITY_NUM	int	Yes	Yes	íîìåð ñóùíîñòè	 
ENTITY_NAME	varchar(60)	No	Yes	íàèìåíîâàíèå ñóùíîñòè	 
WITH_PERIOD	numeric(1)	No	No	Åñòü ëè ïåðèîäû ó äàííîé íàñòðîéêè	 

T_user_acc
Column List
Code	Type	P	M	Label	 
ACCESS_ID	numeric(9,0)	Yes	Yes	id äëÿ ïåðâè÷íîãî êëþ÷à	 
ACCESS_NUM	varchar(21)	No	No	íîìåð á/ñ÷åòà	 
ACCESS	numeric(1)	No	Yes	äîñòóï	 
PROJECT_NUM	int	No	No	íîìåð ïðîåêòà	 
USER_ID	char(32)	No	Yes	id ïîëüçîâàòåëÿ	 

T_user_doc
Column List
Code	Type	P	M	Label	 
ACCESS_ID	numeric(9,0)	Yes	Yes	id äëÿ ïåðâè÷íîãî êëþ÷à	 
ACCESS_NUM	int	No	No	id  òèïà äîê-òà	 
USER_ID	char(32)	No	Yes	id ïîëüçîâàòåëÿ	 
ACCESS	numeric(1)	No	Yes	äîñòóï	 

T_user_entity
Column List
Code	Type	P	M	Label	 
ACCESS_ID	numeric(9,0)	Yes	Yes	id äëÿ ïåðâè÷íîãî êëþ÷à	 
TASK_NUM	int	No	No	id çàäà÷è	 
ENTITY_NUM	int	No	No	íîìåð ñóùíîñòè	 
ACCESS	numeric(1)	No	Yes	äîñòóï	 
USER_ID	char(32)	No	Yes	id ïîëüçîâàòåëÿ	 
PERIOD_BEG	datetime	No	No	ïåðèîä íà÷àëà äåéñòâèÿ	 
PERIOD_END	datetime	No	No	ïåðèîä îêîí÷àíèÿ äåéñòâèÿ	 

T_user_inside
Column List
Code	Type	P	M	Label	 
USER_ID	char(32)	Yes	Yes	íîìåð ïîëüçîâàòåëÿ	 
TASK_NUM	int	Yes	Yes	íîìåð çàäà÷è	 
USER_SPID	int	Yes	Yes	id êîííåêòà ïîëüçîâàòåëÿ	 
USER_HOST	varchar(250)	No	No	èìÿ HOST-ìàøèíû	 
USER_DATA	varchar(250)	No	No	äîï. äàííûå	 
USER_KEY	varchar(250)	No	No	èíôîðìàöèÿ î êëþ÷å	 

T_user_kls
Column List
Code	Type	P	M	Label	 
ACCESS_ID	numeric(9,0)	Yes	Yes	id äëÿ ïåðâè÷íîãî êëþ÷à	 
ACCESS_NUM	int	No	No	íîìåð ñïðàâî÷íèêà	 
ACCESS	numeric(1)	No	Yes	äîñòóï	 
USER_ID	char(32)	No	No	id ïîëüçîâàòåëÿ	 

T_user_klsall
Column List
Code	Type	P	M	Label	 
ACCESS_ID	numeric(9,0)	Yes	Yes	id äëÿ ïåðâè÷íîãî êëþ÷à	 
KLSREF_NUM	int	No	Yes	íîìåð ñïðàâî÷íèêà	 
USER_ID	char(32)	No	Yes	id ïîëüçîâàòåëÿ	 
ACCESS	int	No	No	äîñòóï	 
KLS_ID	numeric(9)	No	No	ññûëêà íà èäåíòèôèêàòîð çàïèñè â ñïðàâî÷íèêå	 

T_user_klsform
Column List
Code	Type	P	M	Label	 
ACCESS_ID	numeric(9,0)	Yes	Yes	id äëÿ ïåðâè÷íîãî êëþ÷à	 
KEY_MENU	varchar(60)	No	No	ïîëíûé ïóòü ê ïóíêòó ìåíþ	 
ORDER_NUM	int	No	No	id  ðàçäåëà	 
KLSFORM_NUM	char(20)	No	No	íîìåð	 
PERIOD	datetime	No	No	ïåðèîä íà÷àëà ÓÏ	 
NEW_FORM	numeric(1)	No	No		 
ACCESS	numeric(1)	No	No	äîñòóï	 
USER_ID	varchar(32)	No	No	id ïîëüçîâàòåëÿ	 

T_user_orderform
Column List
Code	Type	P	M	Label	 
ACCESS_ID	numeric(9,0)	Yes	Yes	id äëÿ ïåðâè÷íîãî êëþ÷à	 
KEY_MENU	varchar(60)	No	No	ïîëíûé ïóòü ê ïóíêòó ìåíþ	 
ACCESS_NUM	int	No	No	id  ðàçäåëà	 
ACCESS	numeric(1)	No	No	äîñòóï	 
USER_ID	varchar(32)	No	No	id ïîëüçîâàòåëÿ	 

T_user_pt
Column List
Code	Type	P	M	Label	 
ACCESS_ID	numeric(9,0)	Yes	Yes	id äëÿ ïåðâè÷íîãî êëþ÷à	 
ACCESS	numeric(1)	No	Yes	äîñòóï	 
PT_ID	numeric(9)	No	No	àâòîèíêðåìåíòíîå ïîëå	 
USER_ID	char(32)	No	No	id ïîëüçîâàòåëÿ	 

T_user_vid
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
VID_NUM	int	No	No	Íîìåð âèäà äåÿòåëüíîñòè	 
USER_ID	char(32)	Yes	Yes	id ïîëüçîâàòåëÿ	 

T_users_blob
Column List
Code	Type	P	M	Label	 
FILIAL_USER	char(2)	Yes	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	Yes	Yes	íîìåð ïîëüçîâàòåëÿ	 
INFO	image	No	No	BLOB ñ èíôîðìàöèåé	 
USER_LAST_DATE	datetime	No	No	ïðåäåë âèäèìîñòè ïîëüçîâàòåëÿ	 
USER_FULLNAME	varchar(60)	No	No	ïîëíîå èìÿ ïîëüçîâàòåëÿ	 
USER_LOGIN	char(30)	No	No	ëîãèí ïîëüçîâàòåëÿ	 
USER_SPID	int	No	No	id ñåäèíåíèÿ ïîëüçîâàòåëÿ	 
USER_STG_GUID	char(32)	No	No	íîìåð ïîëüçîâàòåëÿ (Guid) â õðàíèëèùå äàííûõ	 
USER_HOST	varchar(250)	No	No	èìÿ HOST-ìàøèíû	 
USER_DATA	varchar(250)	No	No	äîï. äàííûå	 
USER_TEL	char(30)	No	No	òåëåôîí	 
USER_COMM	varchar(250)	No	No	êîììåíòàðèé	 
USER_TYPE	numeric(1)	No	No	Òèï (0-ïîëüçîâàòåëü, 1-ãðóïïà)	 
USER_ACCESS	numeric(1)	No	No	Âñå ïðàâà (1-Äà, èíà÷å -Íåò)	 
USER_READONLY	numeric(1)	No	No	Íàñòðîéêà äîñòóïà (1- êàê íàñòðîåí, 2 - òîëüêî ïðîñìîòð)	 
BROWSE_USER_ID	char(32)	No	No	íîìåð ïîëüçîâàòåëÿ äëÿ ïðîñìîòðîâ	 

T_vid
Column List
Code	Type	P	M	Label	 
PROJECT_NUM	int	Yes	Yes	íîìåð ïðîåêòà	 
VID_NUM	int	Yes	Yes	Íîìåð âèäà äåÿòåëüíîñòè	 
VID_NAME	varchar(60)	No	Yes	Íàèìåíîâàíèå âèäà äåÿòåëüíîñòè	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 

R_a_1
	Name:	R_a_1
	Code:	R_A_1
	Label:	Íàñòðîéêà ñ÷åòà-ñïðàâî÷íèê
	Parent:	T_KLS_KLS
	Child:	T_ACC_SETUP
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_ACC_SETUP
		KLSREF_NUM	  =  	ACC_AN3
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_a_2
	Name:	R_a_2
	Code:	R_A_2
	Label:	Íàñòðîéêà ñ÷åòà-ñïðàâî÷íèê
	Parent:	T_KLS_KLS
	Child:	T_ACC_SETUP
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_ACC_SETUP
		KLSREF_NUM	  =  	ACC_AN6
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_a_3
	Name:	R_a_3
	Code:	R_A_3
	Label:	Íàñòðîéêà ñ÷åòà-ñïðàâî÷íèê
	Parent:	T_KLS_KLS
	Child:	T_ACC_SETUP
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_ACC_SETUP
		KLSREF_NUM	  =  	ACC_AN1
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_a_4
	Name:	R_a_4
	Code:	R_A_4
	Label:	Íàñòðîéêà ñ÷åòà-ñïðàâî÷íèê
	Parent:	T_KLS_KLS
	Child:	T_ACC_SETUP
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_ACC_SETUP
		KLSREF_NUM	  =  	ACC_AN5
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_a_5
	Name:	R_a_5
	Code:	R_A_5
	Label:	Íàñòðîéêà ñ÷åòà-ñïðàâî÷íèê
	Parent:	T_KLS_KLS
	Child:	T_ACC_SETUP
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_ACC_SETUP
		KLSREF_NUM	  =  	ACC_AN7
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_a_6
	Name:	R_a_6
	Code:	R_A_6
	Label:	Íàñòðîéêà ñ÷åòà-ñïðàâî÷íèê
	Parent:	T_KLS_KLS
	Child:	T_ACC_SETUP
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_ACC_SETUP
		KLSREF_NUM	  =  	ACC_AN4
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_a_7
	Name:	R_a_7
	Code:	R_A_7
	Label:	Íàñòðîéêà ñ÷åòà-ñïðàâî÷íèê
	Parent:	T_KLS_KLS
	Child:	T_ACC_SETUP
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_ACC_SETUP
		KLSREF_NUM	  =  	ACC_AN2
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_ac_klskls
	Name:	R_ac_klskls
	Code:	R_AC_KLSKLS
	Label:	
	Parent:	T_KLS_KLS
	Child:	T_USER_KLSALL
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_USER_KLSALL
		KLSREF_NUM	  =  	KLSREF_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_acc_acc
	Name:	R_acc_acc
	Code:	R_ACC_ACC
	Label:	ñ÷åò-ñ÷åò
	Parent:	T_ACCOUNT
	Child:	T_ACC_SETUP
	Cardinality:	1, n
	Join:	T_ACCOUNT		T_ACC_SETUP
		PROJECT_NUM	  =  	PROJECT_NUM
		ACC_NUM	  =  	ACC_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_access_acc
	Name:	R_access_acc
	Code:	R_ACCESS_ACC
	Label:	
	Parent:	T_ACCOUNT
	Child:	T_USER_ACC
	Cardinality:	0, n
	Join:	T_ACCOUNT		T_USER_ACC
		PROJECT_NUM	  =  	PROJECT_NUM
		ACC_NUM	  =  	ACCESS_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_access_doc
	Name:	R_access_doc
	Code:	R_ACCESS_DOC
	Label:	
	Parent:	T_DOKTYP
	Child:	T_USER_DOC
	Cardinality:	0, n
	Join:	T_DOKTYP		T_USER_DOC
		DOKTYP_ID	  =  	ACCESS_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_album_branch
	Name:	R_album_branch
	Code:	R_ALBUM_BRANCH
	Label:	
	Parent:	T_ALBUM
	Child:	T_ALBUM_BRANCH
	Cardinality:	0, n
	Join:	T_ALBUM		T_ALBUM_BRANCH
		PROJECT_NUM	  =  	PROJECT_NUM
		PERIOD	  =  	PERIOD
		ALBUM_NUM	  =  	ALBUM_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_album_mreport
	Name:	R_album_mreport
	Code:	R_ALBUM_MREPORT
	Label:	àëüáîìû - îò÷åòû
	Parent:	T_ALBUM
	Child:	T_MREPORT
	Cardinality:	0, n
	Join:	T_ALBUM		T_MREPORT
		PROJECT_NUM	  =  	PROJECT_NUM
		PERIOD	  =  	PERIOD
		ALBUM_NUM	  =  	ALBUM_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_alter_help
	Name:	R_alter_help
	Code:	R_ALTER_HELP
	Label:	äåðåâî ïðîåêòà - àëüòåðíàòèâíûå íîìåðà ïîìîùè
	Parent:	T_PROJECTTREE
	Child:	T_ALTER_HELP
	Cardinality:	0, n
	Join:	T_PROJECTTREE		T_ALTER_HELP
		PT_ID	  =  	PT_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_b_curr_0_9
	Name:	R_b_curr_0_9
	Code:	R_B_CURR_0_9
	Label:	ïðîâîäêè-âàëþòà
	Parent:	T_CURR
	Child:	T_BAL_0_9
	Cardinality:	0, n
	Join:	T_CURR		T_BAL_0_9
		CURR_NUM	  =  	CURR_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_b_doctyp_0_9
	Name:	R_b_doctyp_0_9
	Code:	R_B_DOCTYP_0_9
	Label:	ïðîâîäêè-òèï äîêóìåíòà
	Parent:	T_DOKTYP
	Child:	T_BAL_0_9
	Cardinality:	0, n
	Join:	T_DOKTYP		T_BAL_0_9
		DOKTYP_ID	  =  	DOKTYP_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_b_prd_0_9
	Name:	R_b_prd_0_9
	Code:	R_B_PRD_0_9
	Label:	ïåðèîä-îïåðàöèè
	Parent:	T_PERIOD_88
	Child:	T_OPER_0_9
	Cardinality:	0, n
	Join:	T_PERIOD_88		T_OPER_0_9
		PERIOD	  =  	PERIOD
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_CALC_INK
	Name:	R_CALC_INK
	Code:	R_CALC_INK
	Label:	Ñâÿçü ïîçèöèé ñ êîëè÷åñòâîì
	Parent:	T_CALC_ITEM
	Child:	T_CALC_INC
	Cardinality:	0, n
	Join:	T_CALC_ITEM		T_CALC_INC
		CALC_ITEM_ID	  =  	CALC_ITEM_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_CALC_ITEM
	Name:	R_CALC_ITEM
	Code:	R_CALC_ITEM
	Label:	Ñâÿçü çàãîëîâêîâ êàëüê. êàðò ñ ïîçèöèÿìè
	Parent:	T_CALC_LINK
	Child:	T_CALC_ITEM
	Cardinality:	0, n
	Join:	T_CALC_LINK		T_CALC_ITEM
		CALC_ID	  =  	T_C_CALC_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_CALC_LINK
	Name:	R_CALC_LINK
	Code:	R_CALC_LINK
	Label:	Ñâÿçü ñî ñïðàâî÷íèêîì êîìïîíåíòîâ/èçäåëèé
	Parent:	T_KLS_ALL
	Child:	T_CALC_LINK
	Cardinality:	0, n
	Join:	T_KLS_ALL		T_CALC_LINK
		KLS_ID	  =  	KLS_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_CALC_OPER_IMPORT
	Name:	R_CALC_OPER_IMPORT
	Code:	R_CALC_OPER_IMPORT
	Label:	
	Parent:	T_OPER_RECORD
	Child:	T_CALC_IMPORT
	Cardinality:	0, n
	Join:	T_OPER_RECORD		T_CALC_IMPORT
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
		ENTRY_NUM	  =  	ENTRY_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_curr_curs
	Name:	R_curr_curs
	Code:	R_CURR_CURS
	Label:	âàëþòà-êóðñ
	Parent:	T_CURR
	Child:	T_KLS_CURS
	Cardinality:	0, n
	Join:	T_CURR		T_KLS_CURS
		CURR_NUM	  =  	CURR_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_DOK_REKV
	Name:	R_DOK_REKV
	Code:	R_DOK_REKV
	Label:	
	Parent:	T_DOKTYP
	Child:	T_REKV
	Cardinality:	0, n
	Join:	T_DOKTYP		T_REKV
		DOKTYP_ID	  =  	DOKTYP_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_doktyp_next_setup
	Name:	R_doktyp_next_setup
	Code:	R_DOKTYP_NEXT_SETUP
	Label:	Ñïèñîê ïîëåé äëÿ ñáîðà æóðíàëîâ ðåãèñòðàöèè
	Parent:	T_DOKTYP_SPR
	Child:	T_DOKTYP_NEXT_SETUP
	Cardinality:	0, n
	Join:	T_DOKTYP_SPR		T_DOKTYP_NEXT_SETUP
		DOKTYP_ID	  =  	DOKTYP_ID
		SPR_NUM	  =  	SPR_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_doktyp_project
	Name:	R_doktyp_project
	Code:	R_DOKTYP_PROJECT
	Label:	Íàñòðîéêà äîêìåíòîâ - ãðóïïû çàäà÷
	Parent:	T_PROJECT
	Child:	T_DOKTYP
	Cardinality:	0, n
	Join:	T_PROJECT		T_DOKTYP
		PROJECT_NUM	  =  	PROJECT_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_doktyp_spr
	Name:	R_doktyp_spr
	Code:	R_DOKTYP_SPR
	Label:	äîêóìåíòû - ïîëÿ äîêóìåíòà
	Parent:	T_DOKTYP
	Child:	T_DOKTYP_SPR
	Cardinality:	0, n
	Join:	T_DOKTYP		T_DOKTYP_SPR
		DOKTYP_ID	  =  	DOKTYP_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_entry_record_exec
	Name:	R_entry_record_exec
	Code:	R_ENTRY_RECORD_EXEC
	Label:	
	Parent:	T_OPER_RECORD
	Child:	T_ENTRY_EXEC
	Cardinality:	0, n
	Join:	T_OPER_RECORD		T_ENTRY_EXEC
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
		ENTRY_NUM	  =  	ENTRY_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_exp_job_kls
	Name:	R_exp_job_kls
	Code:	R_EXP_JOB_KLS
	Label:	
	Parent:	T_EXPORT_JOB
	Child:	T_EXPORT_KLS
	Cardinality:	0, n
	Join:	T_EXPORT_JOB		T_EXPORT_KLS
		JOB_NUM	  =  	JOB_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_EXPKLS_EXPDBF
	Name:	R_EXPKLS_EXPDBF
	Code:	R_EXPKLS_EXPDBF
	Label:	Ññûëêà íà íàñòðîéêó ýêñïîðòà
	Parent:	T_EXPORT_KLS
	Child:	T_EXPORT_DBF
	Cardinality:	0, n
	Join:	T_EXPORT_KLS		T_EXPORT_DBF
		JOB_NUM	  =  	JOB_NUM
		EXP_NUM	  =  	EXP_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_EXPORT_KLSKLS
	Name:	R_EXPORT_KLSKLS
	Code:	R_EXPORT_KLSKLS
	Label:	Ññûëêà íà íîìåð ñïðàâî÷íèêà
	Parent:	T_KLS_KLS
	Child:	T_EXPORT_KLS
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_EXPORT_KLS
		KLSREF_NUM	  =  	KLSREF_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_group_user
	Name:	R_group_user
	Code:	R_GROUP_USER
	Label:	Ãðóïïû - ïîëüçîâàòåëè
	Parent:	T_USERS_BLOB
	Child:	T_GROUP_USER
	Cardinality:	0, n
	Join:	T_USERS_BLOB		T_GROUP_USER
		FILIAL_USER	  =  	FILIAL_GROUP
		USER_ID	  =  	GROUP_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_KLS_CALC_CH
	Name:	R_KLS_CALC_CH
	Code:	R_KLS_CALC_CH
	Label:	
	Parent:	T_KLS_ALL
	Child:	T_CALC_CHANGE
	Cardinality:	0, n
	Join:	T_KLS_ALL		T_CALC_CHANGE
		KLS_ID	  =  	T_K_KLS_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_KLS_CALC_CHANGE_CH
	Name:	R_KLS_CALC_CHANGE_CH
	Code:	R_KLS_CALC_CHANGE_CH
	Label:	
	Parent:	T_KLS_ALL
	Child:	T_CALC_CHANGE
	Cardinality:	0, n
	Join:	T_KLS_ALL		T_CALC_CHANGE
		KLS_ID	  =  	KLS_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_KLS_CALC_ITEM
	Name:	R_KLS_CALC_ITEM
	Code:	R_KLS_CALC_ITEM
	Label:	
	Parent:	T_KLS_ALL
	Child:	T_CALC_ITEM
	Cardinality:	0, n
	Join:	T_KLS_ALL		T_CALC_ITEM
		KLS_ID	  =  	KLS_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_KLS_CALC_N
	Name:	R_KLS_CALC_N
	Code:	R_KLS_CALC_N
	Label:	
	Parent:	T_KLS_ALL
	Child:	T_CALC_NONE
	Cardinality:	0, n
	Join:	T_KLS_ALL		T_CALC_NONE
		KLS_ID	  =  	KLS_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_KLS_CALC_NONE_CH
	Name:	R_KLS_CALC_NONE_CH
	Code:	R_KLS_CALC_NONE_CH
	Label:	
	Parent:	T_KLS_ALL
	Child:	T_CALC_NONE
	Cardinality:	0, n
	Join:	T_KLS_ALL		T_CALC_NONE
		KLS_ID	  =  	T_K_KLS_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_kls_form_blob
	Name:	R_kls_form_blob
	Code:	R_KLS_FORM_BLOB
	Label:	
	Parent:	T_KLS_FORM
	Child:	T_KLS_FORM_BLOB
	Cardinality:	0, n
	Join:	T_KLS_FORM		T_KLS_FORM_BLOB
		KEY_MENU	  =  	KEY_MENU
		ORDER_NUM	  =  	ORDER_NUM
		KLSFORM_NUM	  =  	KLSFORM_NUM
		PERIOD	  =  	PERIOD
		NEW_FORM	  =  	NEW_FORM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_kls_form_branch
	Name:	R_kls_form_branch
	Code:	R_KLS_FORM_BRANCH
	Label:	
	Parent:	T_KLS_FORM
	Child:	T_KLS_FORM_BRANCH
	Cardinality:	0, n
	Join:	T_KLS_FORM		T_KLS_FORM_BRANCH
		KEY_MENU	  =  	KEY_MENU
		ORDER_NUM	  =  	ORDER_NUM
		KLSFORM_NUM	  =  	KLSFORM_NUM
		PERIOD	  =  	PERIOD
		NEW_FORM	  =  	NEW_FORM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_kls_group
	Name:	R_kls_group
	Code:	R_KLS_GROUP
	Label:	
	Parent:	T_KLS_KLS
	Child:	T_KLS_GROUP
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_KLS_GROUP
		KLSREF_NUM	  =  	KLSREF_NUM_KLS
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_kls_kls_all
	Name:	R_kls_kls_all
	Code:	R_KLS_KLS_ALL
	Label:	ñïðàâî÷íèê-íàñòðîéêà
	Parent:	T_KLS_KLS
	Child:	T_KLS_ALL
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_KLS_ALL
		KLSREF_NUM	  =  	KLSREF_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_kls_on_kls
	Name:	R_kls_on_kls
	Code:	R_KLS_ON_KLS
	Label:	èåðàðõèÿ
	Parent:	T_KLS_KLS
	Child:	T_KLS_KLS
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_KLS_KLS
		KLSREF_NUM	  =  	KLSREF_PARENT
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_kls_oper_copy
	Name:	R_kls_oper_copy
	Code:	R_KLS_OPER_COPY
	Label:	ñïèñîê îïåðàöèé - ñïèñîê ïðîâîäîê äëÿ êîïèðîâàíèÿ
	Parent:	T_KLS_OPER
	Child:	T_OPER_COPY
	Cardinality:	0, n
	Join:	T_KLS_OPER		T_OPER_COPY
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_kls_oper_export
	Name:	R_kls_oper_export
	Code:	R_KLS_OPER_EXPORT
	Label:	ñïèñîê îïåðàöèé - ñïèñîê ïðîâîäîê ýêñïîðòà
	Parent:	T_KLS_OPER
	Child:	T_OPER_EXPORT
	Cardinality:	0, n
	Join:	T_KLS_OPER		T_OPER_EXPORT
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_kls_oper_order
	Name:	R_kls_oper_order
	Code:	R_KLS_OPER_ORDER
	Label:	
	Parent:	T_ORDER
	Child:	T_KLS_OPER
	Cardinality:	0, n
	Join:	T_ORDER		T_KLS_OPER
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_kls_oper_record
	Name:	R_kls_oper_record
	Code:	R_KLS_OPER_RECORD
	Label:	Ñïèñîê îïåðàöèé-ñïèñîê çàïèñåé â íèõ
	Parent:	T_KLS_OPER
	Child:	T_OPER_RECORD
	Cardinality:	0, n
	Join:	T_KLS_OPER		T_OPER_RECORD
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_kls_ref
	Name:	R_kls_ref
	Code:	R_KLS_REF
	Label:	Ññûëêà íà äîï. ïîëÿ
	Parent:	T_KLS_KLS
	Child:	T_REF_SPR
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_REF_SPR
		KLSREF_NUM	  =  	KLSREF_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_kls_spr_rule
	Name:	R_kls_spr_rule
	Code:	R_KLS_SPR_RULE
	Label:	Ñïðàâî÷íèê - áèçíåñ-ïðàâèëà
	Parent:	T_KLS_KLS
	Child:	T_SPR_RULE
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_SPR_RULE
		KLSREF_NUM	  =  	KLSREF_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_klsall_klsall
	Name:	R_klsall_klsall
	Code:	R_KLSALL_KLSALL
	Label:	
	Parent:	T_KLS_ALL
	Child:	T_KLS_ALL
	Cardinality:	0, n
	Join:	T_KLS_ALL		T_KLS_ALL
		KLS_ID	  =  	PAR_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_klsall_numb
	Name:	R_klsall_numb
	Code:	R_KLSALL_NUMB
	Label:	Ñïðàâî÷íèê-åä. èçìåðåíèÿ
	Parent:	T_NUMB
	Child:	T_KLS_ALL
	Cardinality:	0, n
	Join:	T_NUMB		T_KLS_ALL
		NUMB_ID	  =  	NUMB_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_klsall_numb2
	Name:	R_klsall_numb2
	Code:	R_KLSALL_NUMB2
	Label:	âòîðàÿ åäèíèöà èçìåðåíèÿ
	Parent:	T_NUMB
	Child:	T_KLS_ALL
	Cardinality:	0, n
	Join:	T_NUMB		T_KLS_ALL
		NUMB_ID	  =  	NUMB_ID2
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_klsall_user
	Name:	R_klsall_user
	Code:	R_KLSALL_USER
	Label:	
	Parent:	T_USERS_BLOB
	Child:	T_KLS_ALL
	Cardinality:	0, n
	Join:	T_USERS_BLOB		T_KLS_ALL
		FILIAL_USER	  =  	FILIAL_USER
		USER_ID	  =  	USER_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_message_image
	Name:	R_message_image
	Code:	R_MESSAGE_IMAGE
	Label:	Ñîîáùåíèÿ - êàðòèíêè
	Parent:	T_IMAGE_LIST
	Child:	T_MESSAGE
	Cardinality:	0, n
	Join:	T_IMAGE_LIST		T_MESSAGE
		IMAGE_TYPE	  =  	IMAGE_TYPE
		IMAGE_NUM	  =  	IMAGE_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_numb_numb
	Name:	R_numb_numb
	Code:	R_NUMB_NUMB
	Label:	Ññûëêà åä.èçì. íà çàâèñèìóþ
	Parent:	T_NUMB
	Child:	T_NUMB
	Cardinality:	0, n
	Join:	T_NUMB		T_NUMB
		NUMB_ID	  =  	NUMB_BASE_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_o_prd_0_9
	Name:	R_o_prd_0_9
	Code:	R_O_PRD_0_9
	Label:	îñòàòêè-ïåðèîä
	Parent:	T_PERIOD_88
	Child:	T_OST_0_9
	Cardinality:	0, n
	Join:	T_PERIOD_88		T_OST_0_9
		PERIOD	  =  	PERIOD
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_oper_doc
	Name:	R_oper_doc
	Code:	R_OPER_DOC
	Label:	
	Parent:	T_KLS_OPER
	Child:	T_OPER_PRDOC
	Cardinality:	0, n
	Join:	T_KLS_OPER		T_OPER_PRDOC
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_oper_entr_0_9
	Name:	R_oper_entr_0_9
	Code:	R_OPER_ENTR_0_9
	Label:	îïåðàöèÿ-ïðîâîäêà
	Parent:	T_OPER_0_9
	Child:	T_BAL_0_9
	Cardinality:	1, n
	Join:	T_OPER_0_9		T_BAL_0_9
		OPER_IDENT	  =  	OPER_IDENT
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_oper_import
	Name:	R_oper_import
	Code:	R_OPER_IMPORT
	Label:	Çàïèñè - ïðîâîäêè èìïîðòà èç ïðîèçâîëüíûõ îò÷åòîâ
	Parent:	T_OPER_RECORD
	Child:	T_OPER_IMPORT
	Cardinality:	0, n
	Join:	T_OPER_RECORD		T_OPER_IMPORT
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
		ENTRY_NUM	  =  	ENTRY_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_oper_prdoc_type
	Name:	R_oper_prdoc_type
	Code:	R_OPER_PRDOC_TYPE
	Label:	
	Parent:	T_PRDOC_TYPE
	Child:	T_OPER_PRDOC
	Cardinality:	0, n
	Join:	T_PRDOC_TYPE		T_OPER_PRDOC
		PRDOCTYP_NUM	  =  	PRDOCTYP_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_oper_record_doc
	Name:	R_oper_record_doc
	Code:	R_OPER_RECORD_DOC
	Label:	
	Parent:	T_OPER_RECORD
	Child:	T_OPER_DOC
	Cardinality:	0, n
	Join:	T_OPER_RECORD		T_OPER_DOC
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
		ENTRY_NUM	  =  	ENTRY_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_oper_record_rule
	Name:	R_oper_record_rule
	Code:	RELATION_153355
	Label:	
	Parent:	T_OPER_RECORD
	Child:	T_RULE
	Cardinality:	0, n
	Join:	T_OPER_RECORD		T_RULE
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
		ENTRY_NUM	  =  	ENTRY_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_order_kls_form
	Name:	R_order_kls_form
	Code:	R_ORDER_KLS_FORM
	Label:	
	Parent:	T_ORDER_KLS_FORM
	Child:	T_KLS_FORM
	Cardinality:	0, n
	Join:	T_ORDER_KLS_FORM		T_KLS_FORM
		KEY_MENU	  =  	KEY_MENU
		ORDER_NUM	  =  	ORDER_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	No

R_PERIOD_BAL_0_9
	Name:	R_PERIOD_BAL_0_9
	Code:	R_PERIOD_BAL_0_9
	Label:	Ïåðèîä-ïðîâîäêè
	Parent:	T_PERIOD_88
	Child:	T_BAL_0_9
	Cardinality:	0, n
	Join:	T_PERIOD_88		T_BAL_0_9
		PERIOD	  =  	PERIOD
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_prdef_typ
	Name:	R_prdef_typ
	Code:	R_PRDEF_TYP
	Label:	
	Parent:	T_PREDEF_REF
	Child:	T_KLS_KLS
	Cardinality:	0, n
	Join:	T_PREDEF_REF		T_KLS_KLS
		KLSREF_TYP	  =  	KLSREF_TYP
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_predef_fields
	Name:	R_predef_fields
	Code:	R_PREDEF_FIELDS
	Label:	
	Parent:	T_PREDEF_REF
	Child:	T_PREDEF_REF_SPR
	Cardinality:	0, n
	Join:	T_PREDEF_REF		T_PREDEF_REF_SPR
		KLSREF_TYP	  =  	KLSREF_TYP
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_prj_account
	Name:	R_prj_account
	Code:	R_PRJ_ACCOUNT
	Label:	
	Parent:	T_PROJECT
	Child:	T_ACCOUNT
	Cardinality:	0, n
	Join:	T_PROJECT		T_ACCOUNT
		PROJECT_NUM	  =  	PROJECT_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_prj_predef_ref
	Name:	R_prj_predef_ref
	Code:	R_PRJ_PREDEF_REF
	Label:	
	Parent:	T_PROJECT
	Child:	T_PREDEF_REF
	Cardinality:	0, n
	Join:	T_PROJECT		T_PREDEF_REF
		PROJECT_NUM	  =  	PROJECT_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_prj_task
	Name:	R_prj_task
	Code:	R_PRJ_TASK
	Label:	
	Parent:	T_PROJECT
	Child:	T_TASK
	Cardinality:	0, n
	Join:	T_PROJECT		T_TASK
		PROJECT_NUM	  =  	PROJECT_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_prj_user_vid
	Name:	R_prj_user_vid
	Code:	R_PRJ_USER_VID
	Label:	
	Parent:	T_PROJECT
	Child:	T_USER_VID
	Cardinality:	0, n
	Join:	T_PROJECT		T_USER_VID
		PROJECT_NUM	  =  	PROJECT_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_prj_vid
	Name:	R_prj_vid
	Code:	R_PRJ_VID
	Label:	
	Parent:	T_PROJECT
	Child:	T_VID
	Cardinality:	0, n
	Join:	T_PROJECT		T_VID
		PROJECT_NUM	  =  	PROJECT_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_proj_const
	Name:	R_proj_const
	Code:	R_PROJ_CONST
	Label:	ãðóïïà çàäà÷ - êîíñòàíòû
	Parent:	T_PROJECT
	Child:	T_CONST
	Cardinality:	0, n
	Join:	T_PROJECT		T_CONST
		PROJECT_NUM	  =  	PROJECT_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_project_order
	Name:	R_project_order
	Code:	R_PROJECT_ORDER
	Label:	
	Parent:	T_PROJECT
	Child:	T_ORDER
	Cardinality:	0, n
	Join:	T_PROJECT		T_ORDER
		PROJECT_NUM	  =  	PROJECT_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_projecttree_image
	Name:	R_projecttree_image
	Code:	R_PROJECTTREE_IMAGE
	Label:	Ïóíêòû ìåíþ-êàðòèíêè
	Parent:	T_IMAGE_LIST
	Child:	T_PROJECTTREE
	Cardinality:	0, n
	Join:	T_IMAGE_LIST		T_PROJECTTREE
		IMAGE_TYPE	  =  	IMAGE_TYPE
		IMAGE_NUM	  =  	IMAGE_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_protocol_creestr
	Name:	R_protocol_creestr
	Code:	R_PROTOCOL_CREESTR
	Label:	
	Parent:	T_PROTOCOL_LOG
	Child:	T_BAK_CREESTR
	Cardinality:	0, n
	Join:	T_PROTOCOL_LOG		T_BAK_CREESTR
		PROTOCOL_ID	  =  	PROTOCOL_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_RECORD_CLOSE
	Name:	R_RECORD_CLOSE
	Code:	R_RECORD_CLOSE
	Label:	
	Parent:	T_OPER_RECORD
	Child:	T_OPER_CLOSE
	Cardinality:	0, n
	Join:	T_OPER_RECORD		T_OPER_CLOSE
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
		ENTRY_NUM	  =  	ENTRY_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_record_entry
	Name:	R_record_entry
	Code:	R_RECORD_ENTRY
	Label:	Íàñòðîéêà îïåðàöèè çàïèñü - ïðîâîäêà
	Parent:	T_OPER_RECORD
	Child:	T_BAL_SETUP
	Cardinality:	0, n
	Join:	T_OPER_RECORD		T_BAL_SETUP
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
		ENTRY_NUM	  =  	ENTRY_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_record_kls_import
	Name:	R_record_kls_import
	Code:	R_RECORD_KLS_IMPORT
	Label:	
	Parent:	T_OPER_RECORD
	Child:	T_KLS_IMPORT
	Cardinality:	0, n
	Join:	T_OPER_RECORD		T_KLS_IMPORT
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
		ENTRY_NUM	  =  	ENTRY_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_reg_print_blob
	Name:	R_reg_print_blob
	Code:	R_REG_PRINT_BLOB
	Label:	
	Parent:	T_REG_PRINT
	Child:	T_REG_PRINT_BLOB
	Cardinality:	0, n
	Join:	T_REG_PRINT		T_REG_PRINT_BLOB
		TASK_NUM	  =  	TASK_NUM
		REG_CLASS	  =  	REG_CLASS
		REG_NUM	  =  	REG_NUM
		REG_ADVANSED	  =  	REG_ADVANSED
		PRINT_NUM	  =  	PRINT_NUM
		NEW_FORM	  =  	NEW_FORM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_reg_print_branch
	Name:	R_reg_print_branch
	Code:	R_REG_PRINT_BRANCH
	Label:	
	Parent:	T_REG_PRINT
	Child:	T_REG_PRINT_BRANCH
	Cardinality:	0, n
	Join:	T_REG_PRINT		T_REG_PRINT_BRANCH
		TASK_NUM	  =  	TASK_NUM
		REG_CLASS	  =  	REG_CLASS
		REG_NUM	  =  	REG_NUM
		REG_ADVANSED	  =  	REG_ADVANSED
		PRINT_NUM	  =  	PRINT_NUM
		NEW_FORM	  =  	NEW_FORM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_STAFF_DISTRIBUTION
	Name:	R_STAFF_DISTRIBUTION
	Code:	R_STAFF_DISTRIBUTION
	Label:	øòàòíîå - ðàññòàíîâêà
	Parent:	T_STAFF_TABLE
	Child:	T_STAFF_DISTRIBUTION
	Cardinality:	0, n
	Join:	T_STAFF_TABLE		T_STAFF_DISTRIBUTION
		STAFF_NUM	  =  	STAFF_NUM
		PODR_ID	  =  	PODR_ID
		POST_ID	  =  	POST_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_STAFF_LIST_TABLE
	Name:	R_STAFF_LIST_TABLE
	Code:	R_STAFF_LIST_TABLE
	Label:	øòàòíîå - ñïèñîê øòàòíûõ
	Parent:	T_STAFF_LIST
	Child:	T_STAFF_TABLE
	Cardinality:	0, n
	Join:	T_STAFF_LIST		T_STAFF_TABLE
		STAFF_NUM	  =  	STAFF_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_tab_import_oper
	Name:	R_tab_import_oper
	Code:	R_TAB_IMPORT_OPER
	Label:	Èìïîðò òàáåëÿ - îïåðàöèè
	Parent:	T_OPER_RECORD
	Child:	T_TAB_IMPORT
	Cardinality:	0, n
	Join:	T_OPER_RECORD		T_TAB_IMPORT
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDER_NUM	  =  	ORDER_NUM
		KLSOPER_TYPE	  =  	KLSOPER_TYPE
		TASK_NUM	  =  	TASK_NUM
		VID_NUM	  =  	VID_NUM
		KLSOPER_NUM	  =  	KLSOPER_NUM
		KLSOPER_DATEBEG	  =  	KLSOPER_DATEBEG
		ENTRY_NUM	  =  	ENTRY_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_task_entity
	Name:	R_task_entity
	Code:	R_TASK_ENTITY
	Label:	
	Parent:	T_TASK
	Child:	T_TASK_ENTITY
	Cardinality:	0, n
	Join:	T_TASK		T_TASK_ENTITY
		TASK_NUM	  =  	TASK_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_task_menu
	Name:	R_task_menu
	Code:	R_TASK_MENU
	Label:	
	Parent:	T_TASK
	Child:	T_MENU
	Cardinality:	0, n
	Join:	T_TASK		T_MENU
		TASK_NUM	  =  	TASK_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_task_nsys
	Name:	R_task_nsys
	Code:	R_TASK_NSYS
	Label:	
	Parent:	T_TASK
	Child:	T_NSYSTEM
	Cardinality:	0, n
	Join:	T_TASK		T_NSYSTEM
		TASK_NUM	  =  	TASK_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_task_ost_0_9
	Name:	R_task_ost_0_9
	Code:	R_TASK_OST_0_9
	Label:	Çàäà÷à - îñòàòêè
	Parent:	T_TASK
	Child:	T_OST_0_9
	Cardinality:	0, n
	Join:	T_TASK		T_OST_0_9
		TASK_NUM	  =  	TASK_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R_user_entity_access
	Name:	R_user_entity_access
	Code:	R_USER_ENTITY_ACCESS
	Label:	
	Parent:	T_TASK_ENTITY
	Child:	T_USER_ENTITY
	Cardinality:	0, n
	Join:	T_TASK_ENTITY		T_USER_ENTITY
		TASK_NUM	  =  	TASK_NUM
		ENTITY_NUM	  =  	ENTITY_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_user_kls_user
	Name:	R_user_kls_user
	Code:	R_USER_KLS_USER
	Label:	
	Parent:	T_KLS_KLS
	Child:	T_USER_KLS
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_USER_KLS
		KLSREF_NUM	  =  	ACCESS_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_user_klsforrm
	Name:	R_user_klsforrm
	Code:	R_USER_KLSFORRM
	Label:	
	Parent:	T_KLS_FORM
	Child:	T_USER_KLSFORM
	Cardinality:	0, n
	Join:	T_KLS_FORM		T_USER_KLSFORM
		KEY_MENU	  =  	KEY_MENU
		ORDER_NUM	  =  	ORDER_NUM
		KLSFORM_NUM	  =  	KLSFORM_NUM
		PERIOD	  =  	PERIOD
		NEW_FORM	  =  	NEW_FORM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

r_user_mess_from
	Name:	r_user_mess_from
	Code:	R_USER_MESS_FROM
	Label:	
	Parent:	T_USERS_BLOB
	Child:	T_MESSAGE
	Cardinality:	0, n
	Join:	T_USERS_BLOB		T_MESSAGE
		FILIAL_USER	  =  	FILIAL_USER_FROM
		USER_ID	  =  	USER_ID_FROM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_user_orderforrm
	Name:	R_user_orderforrm
	Code:	R_USER_ORDERFORRM
	Label:	
	Parent:	T_ORDER_KLS_FORM
	Child:	T_USER_ORDERFORM
	Cardinality:	0, n
	Join:	T_ORDER_KLS_FORM		T_USER_ORDERFORM
		KEY_MENU	  =  	KEY_MENU
		ORDER_NUM	  =  	ACCESS_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_user_pt
	Name:	R_user_pt
	Code:	R_USER_PT
	Label:	
	Parent:	T_PROJECTTREE
	Child:	T_USER_PT
	Cardinality:	0, n
	Join:	T_PROJECTTREE		T_USER_PT
		PT_ID	  =  	PT_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_user_vid_vid
	Name:	R_user_vid_vid
	Code:	R_USER_VID_VID
	Label:	
	Parent:	T_VID
	Child:	T_USER_VID
	Cardinality:	0, n
	Join:	T_VID		T_USER_VID
		PROJECT_NUM	  =  	PROJECT_NUM
		VID_NUM	  =  	VID_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

R_users_mess
	Name:	R_users_mess
	Code:	RELATION_158715
	Label:	
	Parent:	T_USERS_BLOB
	Child:	T_MESSAGE
	Cardinality:	0, n
	Join:	T_USERS_BLOB		T_MESSAGE
		FILIAL_USER	  =  	FILIAL_USER
		USER_ID	  =  	USER_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R2_group_user2
	Name:	R2_group_user2
	Code:	R2_GROUP_USER2
	Label:	Ãðóïïû - ïîëüçîâàòåëè
	Parent:	T_USERS_BLOB
	Child:	T_GROUP_USER
	Cardinality:	0, n
	Join:	T_USERS_BLOB		T_GROUP_USER
		FILIAL_USER	  =  	FILIAL_USER
		USER_ID	  =  	USER_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

R2_kls_group2
	Name:	R2_kls_group2
	Code:	R2_KLS_GROUP2
	Label:	
	Parent:	T_KLS_KLS
	Child:	T_KLS_GROUP
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_KLS_GROUP
		KLSREF_NUM	  =  	KLSREF_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

T_job_step
	Name:	T_job_step
	Code:	T_JOB_STEP
	Label:	
	Parent:	T_JOB
	Child:	T_STEP
	Cardinality:	0, n
	Join:	T_JOB		T_STEP
		JOB_NUM	  =  	JOB_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

T_KLS_ALL_BARCODE
	Name:	T_KLS_ALL_BARCODE
	Code:	T_KLS_ALL_BARCODE
	Label:	
	Parent:	T_KLS_ALL
	Child:	T_BARCODE
	Cardinality:	0, n
	Join:	T_KLS_ALL		T_BARCODE
		KLS_ID	  =  	KLS_ID
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	No
	Change parent allowed for the child Table:	Yes

T_kls_kls_barcode
	Name:	T_kls_kls_barcode
	Code:	T_KLS_KLS_BARCODE
	Label:	
	Parent:	T_KLS_KLS
	Child:	T_BARCODE
	Cardinality:	0, n
	Join:	T_KLS_KLS		T_BARCODE
		KLSREF_NUM	  =  	KLSREF_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

T_order_list_acc
	Name:	T_order_list_acc
	Code:	T_ORDER_LIST_ACC
	Label:	
	Parent:	T_ORDER_LIST_ACC
	Child:	T_LIST_ACC
	Cardinality:	0, n
	Join:	T_ORDER_LIST_ACC		T_LIST_ACC
		KEY_MENU	  =  	KEY_MENU
		ORDER_NUM	  =  	ORDER_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

T_order_point
	Name:	T_order_point
	Code:	T_ORDER_POINT
	Label:	
	Parent:	T_ORDER_POINT
	Child:	T_POINT
	Cardinality:	0, n
	Join:	T_ORDER_POINT		T_POINT
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDERPOINT_NUM	  =  	ORDERPOINT_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

T_point_result
	Name:	T_point_result
	Code:	T_POINT_RESULT
	Label:	
	Parent:	T_POINT
	Child:	T_POINT_RESULT
	Cardinality:	0, n
	Join:	T_POINT		T_POINT_RESULT
		PROJECT_NUM	  =  	PROJECT_NUM
		ORDERPOINT_NUM	  =  	ORDERPOINT_NUM
		POINT_ALIAS	  =  	POINT_ALIAS
		POINT_PERIOD	  =  	POINT_PERIOD
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes

T_step_journal
	Name:	T_step_journal
	Code:	T_STEP_JOURNAL
	Label:	
	Parent:	T_STEP
	Child:	T_JOB_JOURNAL
	Cardinality:	0, n
	Join:	T_STEP		T_JOB_JOURNAL
		JOB_NUM	  =  	JOB_NUM
		STEP_NUM	  =  	STEP_NUM
	Modification rule for parent Table:	Restrict
	Deletion rule for parent Table:	Restrict
	Parent mandatory for the child Table:	Yes
	Change parent allowed for the child Table:	Yes