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

Author: Õðåííèêîâà È.Ñ.
Version: 23.1
Date: 

Table List
Code	Label	 
T_EXPERIENCE	Ñâåäåíèÿ î ñòàæå	 
T_EXPERIENCE_PFR	Ñòàæ äëÿ ÏÔÐ è ñâåäåíèÿ î ïðåä-õ ìåñòàõ ðàáîòû	 
T_GRAPH_CHANGES	Òàáëèöà èçìåíåíèé ãðàôèêà (íå èñïîëüçóåòñÿ)	 
T_GRAPH_DAYS	Îïèñàíèå  ãðàôèêà ðàáî÷åé íåäåëè ïî äíÿì	 
T_GRAPH_YEARS	Ãðàôèêè ïî äàòàì â ãîäàõ	 
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_ELBOOK	Ýëåêòðîííàÿ òðóäîâàÿ êíèæêà	 
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 - ïðîøëûå ìåñòà ðàáîòû)	 
BRANCH	numeric(9)	Yes	Yes	id ïðåäïðèÿòèÿ	 
TAB_ID	numeric(9)	Yes	Yes	Id ñîòðóäíèêà	 
EXPER_NUM	int	Yes	Yes	Íîìåð	 
EXPER_VID	numeric(1)	No	No	òèï çàïèñè (0-âõîäèò â ñòàæ, 1 - íå âõîäèò â ñòàæ)	 
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_CATEG_PAY	numeric(9)	No	No	Êàòåãîðèÿ ïëàòåëüùèêà (Ñïðàâî÷íèê 234)	 
EXPER_TER_USL	numeric(9)	No	No	Òåððèòîðèàëüíûå óñëîâèÿ (Ñïðàâî÷íèê 288)	 
EXPER_TER_USL2	numeric(9)	No	No	Òåððèòîðèàëüíûå óñëîâèÿ 2 (Ñïðàâî÷íèê 288)	 
EXPER_RATE	numeric(4,2)	No	No	Ðàéîííûé êîýôôèöèåíò (ïîäñò-ñÿ èç ñïð-êà òåððèò. óñëîâèé)	 
EXPER_SPEC_USL	numeric(9)	No	No	Îñîáûå óñëîâèÿ (Ñïðàâî÷íèê 289)	 
EXPER_WORK_EXPER	numeric(9)	No	No	Òðóäîâîé ñòàæ (Ñïðàâî÷íèê 290)	 
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(2)	No	No	(0-íå çàäàíî, 1-äåòè ,2- äåêðåò è ò ä)	 
EXPER_LONG_SERVICE	numeric(9)	No	No	Âûñëóãà ëåò (Ñïðàâî÷íèê 291)	 
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	Êîä ïîçèöèè ñïèñêà (Ñïðàâî÷íèê 292)	 
EXPER_CLASS_UT	numeric(9)	No	No	Êëàññ òðóäà (ñïðàâî÷íèê N277)	 
EXPER_INDEX	numeric(4,3)	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_GRAPH_YEARS
Column List
Code	Type	P	M	Label	 
GRAPH_DATE	datetime	Yes	Yes	äàòà	 
HOLIDAY	numeric(1)	No	Yes	òèï äíÿ (0-ðàáî÷èé, 1 - ïðàçäíè÷íûé)	 
WEEK1	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 1-ãî ãðàôèêà	 
WEEK2	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 2-ãî ãðàôèêà	 
WEEK3	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 3-ãî ãðàôèêà	 
WEEK4	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 4-ãî ãðàôèêà	 
WEEK5	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 5-ãî ãðàôèêà	 
WEEK6	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 6-ãî ãðàôèêà	 
WEEK7	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 7-ãî ãðàôèêà	 
WEEK8	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 8-ãî ãðàôèêà	 
WEEK9	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 9-ãî ãðàôèêà	 
WEEK10	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 10-ãî ãðàôèêà	 
WEEK11	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 11-ãî ãðàôèêà	 
WEEK12	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 12-ãî ãðàôèêà	 
WEEK13	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 13-ãî ãðàôèêà	 
WEEK14	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 14-ãî ãðàôèêà	 
WEEK15	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 15-ãî ãðàôèêà	 
WEEK16	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 16-ãî ãðàôèêà	 
WEEK17	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 17-ãî ãðàôèêà	 
WEEK18	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 18-ãî ãðàôèêà	 
WEEK19	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 19-ãî ãðàôèêà	 
WEEK20	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 20-ãî ãðàôèêà	 
WEEK21	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 21-ãî ãðàôèêà	 
WEEK22	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 22-ãî ãðàôèêà	 
WEEK23	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 23-ãî ãðàôèêà	 
WEEK24	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 24-ãî ãðàôèêà	 
WEEK25	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 25-ãî ãðàôèêà	 
WEEK26	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 26-ãî ãðàôèêà	 
WEEK27	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 27-ãî ãðàôèêà	 
WEEK28	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 28-ãî ãðàôèêà	 
WEEK29	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 29-ãî ãðàôèêà	 
WEEK30	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 30-ãî ãðàôèêà	 
WEEK31	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 31-ãî ãðàôèêà	 
WEEK32	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 32-ãî ãðàôèêà	 
WEEK33	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 33-ãî ãðàôèêà	 
WEEK34	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 34-ãî ãðàôèêà	 
WEEK35	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 35-ãî ãðàôèêà	 
WEEK36	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 36-ãî ãðàôèêà	 
WEEK37	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 37-ãî ãðàôèêà	 
WEEK38	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 38-ãî ãðàôèêà	 
WEEK39	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 39-ãî ãðàôèêà	 
WEEK40	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 40-ãî ãðàôèêà	 
WEEK41	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 41-ãî ãðàôèêà	 
WEEK42	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 42-ãî ãðàôèêà	 
WEEK43	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 43-ãî ãðàôèêà	 
WEEK44	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 44-ãî ãðàôèêà	 
WEEK45	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 45-ãî ãðàôèêà	 
WEEK46	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 46-ãî ãðàôèêà	 
WEEK47	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 47-ãî ãðàôèêà	 
WEEK48	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 48-ãî ãðàôèêà	 
WEEK49	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 49-ãî ãðàôèêà	 
WEEK50	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 50-ãî ãðàôèêà	 
WEEK51	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 51-ãî ãðàôèêà	 
WEEK52	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 52-ãî ãðàôèêà	 
WEEK53	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 53-ãî ãðàôèêà	 
WEEK54	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 54-ãî ãðàôèêà	 
WEEK55	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 55-ãî ãðàôèêà	 
WEEK56	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 56-ãî ãðàôèêà	 
WEEK57	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 57-ãî ãðàôèêà	 
WEEK58	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 58-ãî ãðàôèêà	 
WEEK59	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 59-ãî ãðàôèêà	 
WEEK60	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 60-ãî ãðàôèêà	 
WEEK61	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 61-ãî ãðàôèêà	 
WEEK62	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 62-ãî ãðàôèêà	 
WEEK63	numeric(4,2)	No	No		 
WEEK64	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 64-ãî ãðàôèêà	 
WEEK65	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 65-ãî ãðàôèêà	 
WEEK66	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 66-ãî ãðàôèêà	 
WEEK67	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 67-ãî ãðàôèêà	 
WEEK68	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 68-ãî ãðàôèêà	 
WEEK69	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 69-ãî ãðàôèêà	 
WEEK70	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 70-ãî ãðàôèêà	 
WEEK71	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 71-ãî ãðàôèêà	 
WEEK72	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 72-ãî ãðàôèêà	 
WEEK73	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 73-ãî ãðàôèêà	 
WEEK74	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 74-ãî ãðàôèêà	 
WEEK75	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 75-ãî ãðàôèêà	 
WEEK76	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 76-ãî ãðàôèêà	 
WEEK77	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 77-ãî ãðàôèêà	 
WEEK78	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 78-ãî ãðàôèêà	 
WEEK79	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 79-ãî ãðàôèêà	 
WEEK80	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 80-ãî ãðàôèêà	 
WEEK81	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 81-ãî ãðàôèêà	 
WEEK82	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 82-ãî ãðàôèêà	 
WEEK83	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 83-ãî ãðàôèêà	 
WEEK84	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 84-ãî ãðàôèêà	 
WEEK85	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 85-ãî ãðàôèêà	 
WEEK86	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 86-ãî ãðàôèêà	 
WEEK87	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 87-ãî ãðàôèêà	 
WEEK88	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 88-ãî ãðàôèêà	 
WEEK89	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 89-ãî ãðàôèêà	 
WEEK90	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 90-ãî ãðàôèêà	 
WEEK91	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 91-ãî ãðàôèêà	 
WEEK92	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 92-ãî ãðàôèêà	 
WEEK93	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 93-ãî ãðàôèêà	 
WEEK94	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 94-ãî ãðàôèêà	 
WEEK95	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 95-ãî ãðàôèêà	 
WEEK96	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 96-ãî ãðàôèêà	 
WEEK97	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 97-ãî ãðàôèêà	 
WEEK98	numeric(4,2)	No	No		 
WEEK99	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 99-ãî ãðàôèêà	 
WEEK100	numeric(4,2)	No	No	êîë-âî ÷àñîâ äëÿ 100-ãî ãðàôèêà	 
NIGHT_WEEK1	numeric(4,2)	No	No	êîë-âî íî÷íûõ ÷àñîâ äëÿ 1-ãî ãðàôèêà	 
NIGHT_WEEK2	numeric(4,2)	No	No		 
NIGHT_WEEK3	numeric(4,2)	No	No		 
NIGHT_WEEK4	numeric(4,2)	No	No		 
NIGHT_WEEK5	numeric(4,2)	No	No		 
NIGHT_WEEK6	numeric(4,2)	No	No		 
NIGHT_WEEK7	numeric(4,2)	No	No		 
NIGHT_WEEK8	numeric(4,2)	No	No		 
NIGHT_WEEK9	numeric(4,2)	No	No		 
NIGHT_WEEK10	numeric(4,2)	No	No		 
NIGHT_WEEK11	numeric(4,2)	No	No		 
NIGHT_WEEK12	numeric(4,2)	No	No		 
NIGHT_WEEK13	numeric(4,2)	No	No		 
NIGHT_WEEK14	numeric(4,2)	No	No		 
NIGHT_WEEK15	numeric(4,2)	No	No		 
NIGHT_WEEK16	numeric(4,2)	No	No		 
NIGHT_WEEK17	numeric(4,2)	No	No		 
NIGHT_WEEK18	numeric(4,2)	No	No		 
NIGHT_WEEK19	numeric(4,2)	No	No		 
NIGHT_WEEK20	numeric(4,2)	No	No		 
NIGHT_WEEK21	numeric(4,2)	No	No		 
NIGHT_WEEK22	numeric(4,2)	No	No		 
NIGHT_WEEK23	numeric(4,2)	No	No		 
NIGHT_WEEK24	numeric(4,2)	No	No		 
NIGHT_WEEK25	numeric(4,2)	No	No		 
NIGHT_WEEK26	numeric(4,2)	No	No		 
NIGHT_WEEK27	numeric(4,2)	No	No		 
NIGHT_WEEK28	numeric(4,2)	No	No		 
NIGHT_WEEK29	numeric(4,2)	No	No		 
NIGHT_WEEK30	numeric(4,2)	No	No		 
NIGHT_WEEK31	numeric(4,2)	No	No		 
NIGHT_WEEK32	numeric(4,2)	No	No		 
NIGHT_WEEK33	numeric(4,2)	No	No		 
NIGHT_WEEK34	numeric(4,2)	No	No		 
NIGHT_WEEK35	numeric(4,2)	No	No		 
NIGHT_WEEK36	numeric(4,2)	No	No		 
NIGHT_WEEK37	numeric(4,2)	No	No		 
NIGHT_WEEK38	numeric(4,2)	No	No		 
NIGHT_WEEK39	numeric(4,2)	No	No		 
NIGHT_WEEK40	numeric(4,2)	No	No		 
NIGHT_WEEK41	numeric(4,2)	No	No		 
NIGHT_WEEK42	numeric(4,2)	No	No		 
NIGHT_WEEK43	numeric(4,2)	No	No		 
NIGHT_WEEK44	numeric(4,2)	No	No		 
NIGHT_WEEK45	numeric(4,2)	No	No		 
NIGHT_WEEK46	numeric(4,2)	No	No		 
NIGHT_WEEK47	numeric(4,2)	No	No		 
NIGHT_WEEK48	numeric(4,2)	No	No		 
NIGHT_WEEK49	numeric(4,2)	No	No		 
NIGHT_WEEK50	numeric(4,2)	No	No		 
NIGHT_WEEK51	numeric(4,2)	No	No		 
NIGHT_WEEK52	numeric(4,2)	No	No		 
NIGHT_WEEK53	numeric(4,2)	No	No		 
NIGHT_WEEK54	numeric(4,2)	No	No		 
NIGHT_WEEK55	numeric(4,2)	No	No		 
NIGHT_WEEK56	numeric(4,2)	No	No		 
NIGHT_WEEK57	numeric(4,2)	No	No		 
NIGHT_WEEK58	numeric(4,2)	No	No		 
NIGHT_WEEK59	numeric(4,2)	No	No		 
NIGHT_WEEK60	numeric(4,2)	No	No		 
NIGHT_WEEK61	numeric(4,2)	No	No		 
NIGHT_WEEK62	numeric(4,2)	No	No		 
NIGHT_WEEK63	numeric(4,2)	No	No		 
NIGHT_WEEK64	numeric(4,2)	No	No		 
NIGHT_WEEK65	numeric(4,2)	No	No		 
NIGHT_WEEK66	numeric(4,2)	No	No		 
NIGHT_WEEK67	numeric(4,2)	No	No		 
NIGHT_WEEK68	numeric(4,2)	No	No		 
NIGHT_WEEK69	numeric(4,2)	No	No		 
NIGHT_WEEK70	numeric(4,2)	No	No		 
NIGHT_WEEK71	numeric(4,2)	No	No		 
NIGHT_WEEK72	numeric(4,2)	No	No		 
NIGHT_WEEK73	numeric(4,2)	No	No		 
NIGHT_WEEK74	numeric(4,2)	No	No		 
NIGHT_WEEK75	numeric(4,2)	No	No		 
NIGHT_WEEK76	numeric(4,2)	No	No		 
NIGHT_WEEK77	numeric(4,2)	No	No		 
NIGHT_WEEK78	numeric(4,2)	No	No		 
NIGHT_WEEK79	numeric(4,2)	No	No		 
NIGHT_WEEK80	numeric(4,2)	No	No		 
NIGHT_WEEK81	numeric(4,2)	No	No		 
NIGHT_WEEK82	numeric(4,2)	No	No		 
NIGHT_WEEK83	numeric(4,2)	No	No		 
NIGHT_WEEK84	numeric(4,2)	No	No		 
NIGHT_WEEK85	numeric(4,2)	No	No		 
NIGHT_WEEK86	numeric(4,2)	No	No		 
NIGHT_WEEK87	numeric(4,2)	No	No		 
NIGHT_WEEK88	numeric(4,2)	No	No		 
NIGHT_WEEK89	numeric(4,2)	No	No		 
NIGHT_WEEK90	numeric(4,2)	No	No		 
NIGHT_WEEK91	numeric(4,2)	No	No		 
NIGHT_WEEK92	numeric(4,2)	No	No		 
NIGHT_WEEK93	numeric(4,2)	No	No		 
NIGHT_WEEK94	numeric(4,2)	No	No		 
NIGHT_WEEK95	numeric(4,2)	No	No		 
NIGHT_WEEK96	numeric(4,2)	No	No		 
NIGHT_WEEK97	numeric(4,2)	No	No		 
NIGHT_WEEK98	numeric(4,2)	No	No		 
NIGHT_WEEK99	numeric(4,2)	No	No		 
NIGHT_WEEK100	numeric(4,2)	No	No		 
EVNG_WEEK1	numeric(4,2)	No	No	êîë-âî âå÷åðíèõ ÷àñîâ äëÿ 1-ãî ãðàôèêà	 
EVNG_WEEK2	numeric(4,2)	No	No		 
EVNG_WEEK3	numeric(4,2)	No	No		 
EVNG_WEEK4	numeric(4,2)	No	No		 
EVNG_WEEK5	numeric(4,2)	No	No		 
EVNG_WEEK6	numeric(4,2)	No	No		 
EVNG_WEEK7	numeric(4,2)	No	No		 
EVNG_WEEK8	numeric(4,2)	No	No		 
EVNG_WEEK9	numeric(4,2)	No	No		 
EVNG_WEEK10	numeric(4,2)	No	No		 
EVNG_WEEK11	numeric(4,2)	No	No		 
EVNG_WEEK12	numeric(4,2)	No	No		 
EVNG_WEEK13	numeric(4,2)	No	No		 
EVNG_WEEK14	numeric(4,2)	No	No		 
EVNG_WEEK15	numeric(4,2)	No	No		 
EVNG_WEEK16	numeric(4,2)	No	No		 
EVNG_WEEK17	numeric(4,2)	No	No		 
EVNG_WEEK18	numeric(4,2)	No	No		 
EVNG_WEEK19	numeric(4,2)	No	No		 
EVNG_WEEK20	numeric(4,2)	No	No		 
EVNG_WEEK21	numeric(4,2)	No	No		 
EVNG_WEEK22	numeric(4,2)	No	No		 
EVNG_WEEK23	numeric(4,2)	No	No		 
EVNG_WEEK24	numeric(4,2)	No	No		 
EVNG_WEEK25	numeric(4,2)	No	No		 
EVNG_WEEK26	numeric(4,2)	No	No		 
EVNG_WEEK27	numeric(4,2)	No	No		 
EVNG_WEEK28	numeric(4,2)	No	No		 
EVNG_WEEK29	numeric(4,2)	No	No		 
EVNG_WEEK30	numeric(4,2)	No	No		 
EVNG_WEEK31	numeric(4,2)	No	No		 
EVNG_WEEK32	numeric(4,2)	No	No		 
EVNG_WEEK33	numeric(4,2)	No	No		 
EVNG_WEEK34	numeric(4,2)	No	No		 
EVNG_WEEK35	numeric(4,2)	No	No		 
EVNG_WEEK36	numeric(4,2)	No	No		 
EVNG_WEEK37	numeric(4,2)	No	No		 
EVNG_WEEK38	numeric(4,2)	No	No		 
EVNG_WEEK39	numeric(4,2)	No	No		 
EVNG_WEEK40	numeric(4,2)	No	No		 
EVNG_WEEK41	numeric(4,2)	No	No		 
EVNG_WEEK42	numeric(4,2)	No	No		 
EVNG_WEEK43	numeric(4,2)	No	No		 
EVNG_WEEK44	numeric(4,2)	No	No		 
EVNG_WEEK45	numeric(4,2)	No	No		 
EVNG_WEEK46	numeric(4,2)	No	No		 
EVNG_WEEK47	numeric(4,2)	No	No		 
EVNG_WEEK48	numeric(4,2)	No	No		 
EVNG_WEEK49	numeric(4,2)	No	No		 
EVNG_WEEK50	numeric(4,2)	No	No		 
EVNG_WEEK51	numeric(4,2)	No	No		 
EVNG_WEEK52	numeric(4,2)	No	No		 
EVNG_WEEK53	numeric(4,2)	No	No		 
EVNG_WEEK54	numeric(4,2)	No	No		 
EVNG_WEEK55	numeric(4,2)	No	No		 
EVNG_WEEK56	numeric(4,2)	No	No		 
EVNG_WEEK57	numeric(4,2)	No	No		 
EVNG_WEEK58	numeric(4,2)	No	No		 
EVNG_WEEK59	numeric(4,2)	No	No		 
EVNG_WEEK60	numeric(4,2)	No	No		 
EVNG_WEEK61	numeric(4,2)	No	No		 
EVNG_WEEK62	numeric(4,2)	No	No		 
EVNG_WEEK63	numeric(4,2)	No	No		 
EVNG_WEEK64	numeric(4,2)	No	No		 
EVNG_WEEK65	numeric(4,2)	No	No		 
EVNG_WEEK66	numeric(4,2)	No	No		 
EVNG_WEEK67	numeric(4,2)	No	No		 
EVNG_WEEK68	numeric(4,2)	No	No		 
EVNG_WEEK69	numeric(4,2)	No	No		 
EVNG_WEEK70	numeric(4,2)	No	No		 
EVNG_WEEK71	numeric(4,2)	No	No		 
EVNG_WEEK72	numeric(4,2)	No	No		 
EVNG_WEEK73	numeric(4,2)	No	No		 
EVNG_WEEK74	numeric(4,2)	No	No		 
EVNG_WEEK75	numeric(4,2)	No	No		 
EVNG_WEEK76	numeric(4,2)	No	No		 
EVNG_WEEK77	numeric(4,2)	No	No		 
EVNG_WEEK78	numeric(4,2)	No	No		 
EVNG_WEEK79	numeric(4,2)	No	No		 
EVNG_WEEK80	numeric(4,2)	No	No		 
EVNG_WEEK81	numeric(4,2)	No	No		 
EVNG_WEEK82	numeric(4,2)	No	No		 
EVNG_WEEK83	numeric(4,2)	No	No		 
EVNG_WEEK84	numeric(4,2)	No	No		 
EVNG_WEEK85	numeric(4,2)	No	No		 
EVNG_WEEK86	numeric(4,2)	No	No		 
EVNG_WEEK87	numeric(4,2)	No	No		 
EVNG_WEEK88	numeric(4,2)	No	No		 
EVNG_WEEK89	numeric(4,2)	No	No		 
EVNG_WEEK90	numeric(4,2)	No	No		 
EVNG_WEEK91	numeric(4,2)	No	No		 
EVNG_WEEK92	numeric(4,2)	No	No		 
EVNG_WEEK93	numeric(4,2)	No	No		 
EVNG_WEEK94	numeric(4,2)	No	No		 
EVNG_WEEK95	numeric(4,2)	No	No		 
EVNG_WEEK96	numeric(4,2)	No	No		 
EVNG_WEEK97	numeric(4,2)	No	No		 
EVNG_WEEK98	numeric(4,2)	No	No		 
EVNG_WEEK99	numeric(4,2)	No	No		 
EVNG_WEEK100	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_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 - èñòî÷íèêà	 
BRANCH_NUM	varchar(4000)	No	No	Ñïèñîê id êîìïàíèé ÷åðåç çàïÿòóþ, äëÿ êîòîðûõ èñïîëüçóåòñÿ îïåðàöèÿ	 
TASK_LIST	varchar(250)	No	No	Ñïèñîê çàäà÷	 
KLSOPER_LOG	numeric(1)	No	No	âåäåòñÿ ëè ëîã	 

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	íîìåð ïîëüçîâàòåëÿ	 
TEMPLATE_NUM_WEB	varchar(60)	No	No	íîìåð øàáëîíà äîêóìåíòà (÷òî ïå÷àòàòü) äëÿ WEB-ïðîåêòà	 
CYCLE_REGSPR_ALIAS	varchar(30)	No	No	ïîëå öèêëà - óñëîâíîå îáîçíà÷åíèå öèêë. ïîëÿ äîêóìåíòà	 
CYCLE_FILTER	text	No	No	óñëîâèå îòáîðà äëÿ öèêëà	 
BROWSE_REESTR_ADD	numeric(1)	No	No	Äîáàâëÿòü ëè îïåðàöèþ â ïðîñìîòðå ÆÐ (1-Íåò, 2 - Äà)	 
BROWSE_REESTR_BASIS_ADD	numeric(1)	No	No	Äîáàâëÿòü ëè îïåðàöèþ â ïðîñìîòðå ÆÐ îñíîâàíèÿ(1-Íåò, 2 - Äà)	 

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 ñïð)	 
FREE_AN	numeric(9)	No	No	ñâîáîäíàÿ àíàëèòèêà	 
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	Íîìåð îïåðàöèè èìïîðòà	 
CODE_OSN	numeric(9)	No	No	ññûëêà íà ñïðàâî÷íèê 276 - êîä îñíîâàíèÿ (ÑÂ)	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 

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_PERIOD_BEG	text	No	No	ïåðèîä íà÷àëà äåéñòâèÿ	 
S_PERIOD_END	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_FREE_AN	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(6,3)	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	òàðèôíûé ðàçðÿä	 
IN_ELBOOK	numeric(1)	No	No	äåëàåòñÿ ëè çàïèñü â òðóäîâóþ êíèæêó	 
INPUT_DATE	datetime	No	Yes	äàòà ââîäà (ñëóæåáíàÿ)	 
FILIAL_USER	char(2)	No	Yes	íîìåð ôèëèàëà	 
USER_ID	char(32)	No	Yes	id ïîëüçîâàòåëÿ	 

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 òàáåëüíîãî íîìåðà	 
DATE_BEG	datetime	Yes	Yes	Äàòà íà÷àëà	 
DATE_END	datetime	No	Yes	Äàòà îêîí÷àíèÿ	 
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	 
STAFF_TYPE	numeric(1)	No	No	Ñòàòóñ (â øòàòå/ çà øòàòîì)	 
USER_ID	char(32)	No	No		 
FILIAL_USER	char(2)	No	No		 
TARIFF_SCALE_PERS	numeric(9)	No	Yes	òàðèôíàÿ ñåòêà	 
TARIFF_CLASS_PERS	numeric(9)	No	Yes	òàðèôíûé ðàçðÿä	 
COMENT	varchar(250)	No	No	Êîììåíòàðèé	 

T_STAFF_ELBOOK
Column List
Code	Type	P	M	Label	 
ELBOOK_GUID	char(36)	Yes	Yes		 
ELBOOK_NUM	integer	No	Yes	ïîðÿäêîâûé íîìåð	 
BRANCH	numeric(9)	No	Yes	id ïðåäïðèÿòèÿ	 
PODR_ID	numeric(9)	No	No	id ïîäðàçäåëåíèÿ	 
TAB_ID	numeric(9)	No	Yes	id òàáåëüíîãî íîìåðà	 
POST_ID	numeric(9)	No	No	äîëæíîñòü	 
POST_STATUS	int	No	No	ÿâëÿåòñÿ ëè ñîâìåñòèòåëåì (1-íåò, 2 - âíóòðåííèé, 3 - âíåøíèé)	 
ELBOOK_VID	integer	No	Yes	âèä ìåðîïðèÿòèÿ (1-ïðèåì íà ðàáîòó, 2- ïåðåâîä)	 
DATE_BEG	datetime	No	No	läàòà íà÷àëà äåéñòâèÿ ìåðåîïðèÿòèÿ	 
DATE_END	datetime	No	No		 
TER_USL	numeric(9)	No	No	Òåððèòîðèàëüíûå óñëîâèÿ (Ñïðàâî÷íèê 288)	 
KOD_CONTR_GPX	char(4)	No	No	Êîä ïî äîãîâîðó ÃÏÕ	 
REASON_UV_ID	numeric(9)	No	No	îñíîâàíèå äëÿ óâîëüíåíèÿ	 
COMM	varchar(500)	No	No	ñâåäåíèÿ î ìåðîïðèÿòèè	 
DOC_ID	numeric(9)	No	No	äîêóìåíò îñíîâàíèÿ	 
DOC_NUM	varchar(20)	No	No	íîìåð äîêóìåíòà îñíîâàíèÿ	 
DOC_DATE	datetime	No	No	äàòà äîêóìåíòà îñíîâàíèÿ	 
DOC2_ID	numeric(9)	No	No	äîêóìåíò îñíîâàíèÿ 2	 
DOC2_NUM	varchar(20)	No	No	íîìåð äîêóìåíòà îñíîâàíèÿ 2	 
DOC2_DATE	datetime	No	No	äàòà äîêóìåíòà îñíîâàíèÿ 2	 
CANCEL_TYPE	integer	No	No	ïðèçíàê îòìåíû ìåðîïðèÿòèÿ (0 - íåò, 1 - çàïèñü îòìåíåíà)	 
CANCEL_DATE	datetime	No	No	äàòà îòìåíû ìåðîïðèÿòèÿ	 
CANCEL_GUID	char(36)	No	No	èäåíòèôèêàòîð îòìåíåííîãî ìåðîïðèÿòèÿ	 
PERIOD_SEND	datetime	No	No	Ïåðèîä ïåðåäà÷è	 
DATE_SEND	datetime	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	íîìåð ôèëèàëà	 
COMENT	varchar(250)	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	êîììåíòàðèé	 
BRANCH	numeric(9)	No	Yes	id ïðåäïðèÿòèÿ	 

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