Çàðïëàòà - Ïåðñîíàë

Author: 
Version: 
Date: 

Table List
Code	Label	 
T_EXPERIENCE	Ñâåäåíèÿ î ñòàæå	 
T_EXPERIENCE_PFR	Ñòàæ äëÿ ÏÔÐ è ñâåäåíèÿ î ïðåä-õ ìåñòàõ ðàáîòû	 
T_GRAPH_CHANGES	Òàáëèöà èçìåíåíèé ãðàôèêà (íå èñïîëüçóåòñÿ)	 
T_GRAPH_DAYS	Îïèñàíèå  ãðàôèêà ðàáî÷åé íåäåëè ïî äíÿì	 
T_HOLIDAYS	òàáëèöà îôèöèàëüíûõ ïðàçäíèêîâ	 
T_KLS_OPER	Íàñòðîéêà îïåðàöèé	 
T_LIST_DEDUCTION	Ñïèñîê âû÷åòîâ ïî ñîòðóäíèêàì	 
T_MIN_SALARY	Òàáëèöà ìèíèìàëüíûõ çàðîáîòíûõ ïëàò	 
T_NALOG_SCALE	Øêàëû íàëîãîâ	 
T_OPER_RECORD	Ñïèñîê çàïèñåé â îïåðàöèè	 
T_ORDER	Êëàññèôèêàòîð ðàçäåëîâ â çàäà÷àõ	 
T_PERC_ACC	äàííûå äëÿ ðàñ÷åòà çàðïëàòû	 
T_PERC_ACC_IMPORT	Èìïîðò äàííûõ äëÿ ðàñ÷åòà çàðàáîòíîé ïëàòû	 
T_PERC_LEAVE	äàííûå äëÿ ðàñ÷åòà îòïóñêà	 
T_PROJECT	Òàáëèöà ïðîåêòîâ	 
T_SALBOOK_ENTRY	Íàñòðîéêà æóðíàëîâ îðäåðîâ â çàðïëàòå - ïðîâîäêè	 
T_SALBOOK_LIST	Íàñòðîéêà æóðíàëîâ îðäåðîâ â çàðïëàòå - ïåðå÷èñëåíèÿ	 
T_STAFF	Èñïîëíåíèí øòàòíîãî ðàñïèñàíèÿ	 
T_STAFF_DISTRIBUTION	Ðàññòàíîâêà øòàòíîãî ðàñïèñàíèÿ	 
T_STAFF_LIST	Ñïèñîê øòàòíûõ ðàñïèñàíèé	 
T_STAFF_TABLE	Øòàòíîå ðàñïèñàíèå	 
T_TAB_ACCOUNT_0_9	Äàííûå òàáåëÿ (õðàíÿòñÿ ïî-êâàðòàëüíî)	 
T_TAB_IMPORT	Èìïîðò òàáåëÿ èç ïðîèçâîëüíûõ îò÷åòîâ	 

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_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_HOLIDAYS
Column List
Code	Type	P	M	Label	 
HOLIDAY_DAY	numeric(2)	Yes	Yes	÷èñëî	 
HOLIDAY_MONTH	numeric(2)	Yes	Yes	ìåñÿö	 
HOLIDAY_TYPE	numeric(1)	No	No	òèï äíÿ (0-ïðàçäíèê/1-âûõîäíîé/2-ðàáî÷èé)	 
YEAR_BEG	numeric(4)	No	No	ñ êàêîãî ãîäà äåéñòâóåò	 
YEAR_END	numeric(4)	No	No	ïî êàêîé ãîä äåéñòâóåò	 
COMM	varchar(250)	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	Yes	íàèìåíîâàíèå	 
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	âèä îïåðàöèè (ïðèìåíÿåòñÿ â òîðãîâëå)	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	íîìåð ïîëüçîâàòåëÿ	 
KLSOPER_DOC_GRP	text	No	No	ñïèñîê ïîëåé äëÿ ãðóïïèðîâêè ïî äîêóìåíòó	 
KLSOPER_DOC_SUM	text	No	No	ñïèñîê ïîëåé äëÿ ñóììèðîâàíèÿ ïî äîêóìåíòó	 
KLSOPER_DOC_USL	text	No	No	óñëîâèå îòáîðà çàïèñåé ïî äîêóìåíòó	 
KLSOPER_DELIMIT	varchar(10)	No	No	ðàçäåëèòåëü äëÿ òåêñò-õ ôàéëîâ äëÿ èìïîðòà èç ïðîèçâ-õ îò÷åòîâ	 
KLSOPER_CELLS	varchar(10)	No	No	êîëè÷åñòâî ïóñòûõ ÿ÷ååê	 
KLSOPER_TEXT	text	No	No	òåêñò sql- çàïðîñà äëÿ èìïîðòà èç ODBC - èñòî÷íèêà	 

T_LIST_DEDUCTION
Column List
Code	Type	P	M	Label	 
PRIV_ID	numeric(9,0)	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_MIN_SALARY
Column List
Code	Type	P	M	Label	 
SALARY_DATE	datetime	Yes	Yes	ïåðèîä	 
SALARY_MONEY	numeric(19,2)	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_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	Yes	íàèìåíîâàíèå ðàçäåëà	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 

T_PERC_ACC
Column List
Code	Type	P	M	Label	 
PERC_ACC_ID	numeric(9,0)	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 øèôðà íà÷èñëåíèé	 
SOURCE_PROFIT	numeric(9)	No	No	id èñòî÷íèêà âûïëàòû (214 ñïð)	 
KLS_ID	numeric(9)	No	No	ññûëêà íà ñïðàâî÷íèêè (242-ïåðå÷èñëåíèÿ â áàíê, 243- àëèìåíòû)	 
BRANCH	numeric(9)	No	No	ID ïðåäïðèÿòèÿ	 
USER_ID	char(32)	No	Yes		 
FILIAL_USER	char(2)	No	Yes		 
NOTE	varchar(60)	No	No	ïðèìå÷àíèå	 
KLSOPER_NUM	int	No	No	Íîìåð îïåðàöèè èìïîðòà	 

T_PERC_ACC_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_KLS_NUM	text	No	No	íîìåð ëèöåâîãî ñ÷åòà	 
S_DATA_BEG	text	No	No	äàòà íà÷àëà äåéñòâèÿ	 
S_DATA_END	text	No	No	äàòà îêîí÷àíèÿ äåéñòâèÿ	 
S_SUMMA	text	No	No	ñóììà ëèöåâîãî ñ÷åòà	 
S_VO_ID	text	No	No	âèä îïëàò	 
S_SHIFR_COST	text	No	No	øèôð çàòðàò	 
S_SHIFR_NACH	text	No	No	øèôð íà÷èñëåíèé	 
S_SOURCE_PROFIT	text	No	No	èñòî÷íèê ôèíàíñèðîâàíèÿ	 
S_KLS_ID	text	No	No	ïåðå÷èñëåíèÿ â áàíê èëè àëèìåíòû	 
S_NOTE	text	No	No	ïðèìå÷àíèå	 
TYPE_ADD	numeric(1)	No	No	òèï äîáàâëåíèÿ	 

T_PERC_LEAVE
Column List
Code	Type	P	M	Label	 
PERC_LEAVE_ID	numeric(9,0)	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	Yes		 
FILIAL_USER	char(2)	No	Yes		 
COMM	varchar(250)	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_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_DT	varchar(21)	No	No	Äåáåò	 
SBE_KT	varchar(21)	No	No	Êðåäèò	 
SBE_DT_AN1_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò1	 
SBE_DT_AN1	text	No	No	Àíàëèòèêà Äò1	 
SBE_DT_AN2_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò2	 
SBE_DT_AN2	text	No	No	Àíàëèòèêà Äò2	 
SBE_DT_AN3_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò3	 
SBE_DT_AN3	text	No	No	Àíàëèòèêà Äò3	 
SBE_DT_AN4_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò4	 
SBE_DT_AN4	text	No	No	Àíàëèòèêà Äò4	 
SBE_DT_AN5_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò5	 
SBE_DT_AN5	text	No	No	Àíàëèòèêà Äò5	 
SBE_DT_AN6_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò6	 
SBE_DT_AN6	text	No	No	Àíàëèòèêà Äò6	 
SBE_DT_AN7_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò7	 
SBE_DT_AN7	text	No	No	Àíàëèòèêà Äò7	 
SBE_KT_AN1_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò1	 
SBE_KT_AN1	text	No	No	Àíàëèòèêà Êò1	 
SBE_KT_AN2_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò2	 
SBE_KT_AN2	text	No	No	Àíàëèòèêà Êò2	 
SBE_KT_AN3_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò3	 
SBE_KT_AN3	text	No	No	Àíàëèòèêà Êò3	 
SBE_KT_AN4_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò4	 
SBE_KT_AN4	text	No	No	Àíàëèòèêà Êò4	 
SBE_KT_AN5_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò5	 
SBE_KT_AN5	text	No	No	Àíàëèòèêà Êò5	 
SBE_KT_AN6_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò6	 
SBE_KT_AN6	text	No	No	Àíàëèòèêà Êò6	 
SBE_KT_AN7_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò7	 
SBE_KT_AN7	text	No	No	Àíàëèòèêà Êò7	 
SBE_COMM	text	No	No	Êîììåíòàðèé	 

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_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò1	 
SBL_DT_AN1	text	No	No	Àíàëèòèêà Äò1	 
SBL_DT_AN2_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò2	 
SBL_DT_AN2	text	No	No	Àíàëèòèêà Äò2	 
SBL_DT_AN3_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò3	 
SBL_DT_AN3	text	No	No	Àíàëèòèêà Äò3	 
SBL_DT_AN4_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò4	 
SBL_DT_AN4	text	No	No	Àíàëèòèêà Äò4	 
SBL_DT_AN5_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò5	 
SBL_DT_AN5	text	No	No	Àíàëèòèêà Äò5	 
SBL_DT_AN6_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò6	 
SBL_DT_AN6	text	No	No	Àíàëèòèêà Äò6	 
SBL_DT_AN7_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Äò7	 
SBL_DT_AN7	text	No	No	Àíàëèòèêà Äò7	 
SBL_KT_AN1_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò1	 
SBL_KT_AN1	text	No	No	Àíàëèòèêà Êò1	 
SBL_KT_AN2_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò2	 
SBL_KT_AN2	text	No	No	Àíàëèòèêà Êò2	 
SBL_KT_AN3_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò3	 
SBL_KT_AN3	text	No	No	Àíàëèòèêà Êò3	 
SBL_KT_AN4_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò4	 
SBL_KT_AN4	text	No	No	Àíàëèòèêà Êò4	 
SBL_KT_AN5_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò5	 
SBL_KT_AN5	text	No	No	Àíàëèòèêà Êò5	 
SBL_KT_AN6_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò6	 
SBL_KT_AN6	text	No	No	Àíàëèòèêà Êò6	 
SBL_KT_AN7_KLS	int	No	No	Íîìåð ñïðàâî÷íèêà äëÿ àíàëèòèêè Êò7	 
SBL_KT_AN7	text	No	No	Àíàëèòèêà Êò7	 
SBL_COMM	text	No	No	Êîììåíòàðèé	 

T_STAFF
Column List
Code	Type	P	M	Label	 
STAFF_ID	numeric(9,0)	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	äàòà îêîí÷àíèÿ ðàáîòû	 
FACT_BEG_WORK	datetime	No	No	Ôàêòè÷åñêàÿ äàòà  ïðèåìà íà ðàáîòó â äàííîå ïðåäïðèÿòèå	 
FACT_END_WORK	datetime	No	No	Ôàêòè÷åñêàÿ äàòà  óâîëüíåíèÿ èç äàííîãî ïðåäïðèÿòèÿ	 
NED_ID	numeric(9)	No	Yes	id ðàáî÷åé íåäåëè	 
POST_INFO	varchar(30)	No	No	èíôîðìàöèÿ î äîëæíîñòè (1-îñíîâíàÿ,2-ñîâìåñòèòåëü)	 
QUANTITY	numeric(5,2)	No	No	øòàòíûå åäèíèöû	 
RATE	numeric(19,3)	No	No	ñòàâêà	 
KLS_DIGIT_NUM	numeric(20)	No	No	÷èñëîâîé íîìåð ëèöåâîãî ñ÷åòà	 
BRANCH	numeric(9)	No	No		 
IN_STAFF	numeric(2)	No	No		 
GROUP_PAY	numeric(9)	No	No	ãðóïïà ðàñ÷åòà	 
TARIFF_SCALE	numeric(9)	No	No	òàðèôíàÿ ñåòêà	 
TARIFF_CLASS	numeric(9)	No	No	òàðèôíûé ðàçðÿä	 

T_STAFF_DISTRIBUTION
Column List
Code	Type	P	M	Label	 
STAFF_NUM	int	Yes	Yes	Íîìåð øòàòíîãî	 
PODR_ID	numeric(9)	Yes	Yes	Id ïîäðàçäåëåíèÿ	 
POST_ID	numeric(9)	Yes	Yes	Id äîëæíîñòè	 
TARIFF_SCALE	numeric(9)	Yes	Yes	òàðèôíàÿ ñåòêà	 
TARIFF_CLASS	numeric(9)	Yes	Yes	òàðèôíûé ðàçðÿä	 
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	 
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	 
ADDITION11	numeric(19,2)	No	No	Íàäáàâêà11	 
ADDITION12	numeric(19,2)	No	No	Íàäáàâêà12	 
ADDITION13	numeric(19,2)	No	No	Íàäáàâêà13	 
ADDITION14	numeric(19,2)	No	No	Íàäáàâêà14	 
ADDITION15	numeric(19,2)	No	No	Íàäáàâêà15	 
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		 

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	íîìåð ôèëèàëà	 
ADDITION_COUNT	numeric(2)	No	No	êîëè÷åñòâî íàäáàâîê	 
ADDITION1_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 1	 
ADDITION2_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 2	 
ADDITION3_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 3	 
ADDITION4_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 4	 
ADDITION5_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 5	 
ADDITION6_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 6	 
ADDITION7_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 7	 
ADDITION8_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 8	 
ADDITION9_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 9	 
ADDITION10_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 10	 
ADDITION11_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 11	 
ADDITION12_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 12	 
ADDITION13_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 13	 
ADDITION14_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 14	 
ADDITION15_NAME	varchar(30)	No	No	íàèìåíîâàíèå íàäáàâêè 15	 

T_STAFF_TABLE
Column List
Code	Type	P	M	Label	 
STAFF_NUM	int	Yes	Yes	Íîìåð øòàòíîãî	 
PODR_ID	numeric(9)	Yes	Yes	Id ïîäðàçäåëåíèÿ	 
POST_ID	numeric(9)	Yes	Yes	Id äîëæíîñòè	 
TARIFF_SCALE	numeric(9)	Yes	Yes	òàðèôíàÿ ñåòêà	 
TARIFF_CLASS	numeric(9)	Yes	Yes	òàðèôíûé ðàçðÿä	 
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	 
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	 
ADDITION11	numeric(19,2)	No	No	Íàäáàâêà11	 
ADDITION12	numeric(19,2)	No	No	Íàäáàâêà12	 
ADDITION13	numeric(19,2)	No	No	Íàäáàâêà13	 
ADDITION14	numeric(19,2)	No	No	Íàäáàâêà14	 
ADDITION15	numeric(19,2)	No	No	Íàäáàâêà15	 
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	íîìåð ôèëèàëà	 

T_TAB_ACCOUNT_0_9
Column List
Code	Type	P	M	Label	 
KLS_NUM	varchar(20)	Yes	Yes	íîìåð ëèöåâîãî ñ÷åòà	 
TAB_ACCOUNT_DATE	datetime	Yes	Yes	äàòà	 
TAB_WORK_ID	numeric(9)	Yes	Yes	id âèäà ðàáîò	 
PODR_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	Íîìåð îïåðàöèè èìïîðòà	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
USER_ID	char(32)	No	Yes	id ïîëüçîâàòåëÿ	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
COMM	varchar(250)	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	×àñû (ôîðìóëà)	 

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_perc_acc_oper
	Name:	R_perc_acc_oper
	Code:	R_PERC_ACC_OPER
	Label:	
	Parent:	T_OPER_RECORD
	Child:	T_PERC_ACC_IMPORT
	Cardinality:	0, n
	Join:	T_OPER_RECORD		T_PERC_ACC_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_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_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
		TARIFF_SCALE	  =  	TARIFF_SCALE
		TARIFF_CLASS	  =  	TARIFF_CLASS
	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