Ïðîèçâîäñòâî

Author: 
Version: 
Date: 

Table List
Code	Label	 
T_CALC_CHANGE	Òàáëèöà âîçìîæíûõ çàìåí	 
T_CALC_IMPORT	Íàñòðîéêà èìïîðòà äëÿ ñïåöèôèêàöèé	 
T_CALC_ITEM	Ïîçèöèè ñïåöèôèêàöèé	 
T_CALC_NONE	Îòñóòñòâóþùèå êîìïîíåíòû	 
T_KLS_ALL	Ñïðàâî÷íèêè	 
T_KLS_OPER	Íàñòðîéêà îïåðàöèé	 
T_OPER_RECORD	Ñïèñîê çàïèñåé â îïåðàöèè	 
T_ORDER	Êëàññèôèêàòîð ðàçäåëîâ â çàäà÷àõ	 
T_PROJECT	Òàáëèöà ïðîåêòîâ	 

t_calc_change
Column List
Code	Type	P	M	Label	 
CALC_CHANGE_ID	numeric(9,0)	Yes	Yes	Èäåíòèôèêàòîð çàïèñè id	 
KLS_ID	numeric(9)	No	No	id çíà÷åíèÿ ñïðàâî÷íèêà	 
ITEM	int	No	Yes	Íîìåð çàìåíû	 
PERIOD_BEG	datetime	No	No	Íà÷àëî äåéñòâèÿ	 
PERIOD_END	datetime	No	No	Îêîí÷àíèå äåéñòâèÿ	 
KLS_ID_CHANGE	numeric(9)	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(32)	No	No	Ïîëüçîâàòåëü	 
FILIAL_NUM	char(2)	No	No	ôèëèàë ñîçäàòåëü	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 

T_CALC_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_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_BRUTTO	text	No	No	Êîëè÷åñòâî (ôîðìóëà)	 
S_BRUTTO2	text	No	No	Âõîä (áðóòòî) ïî 2 êàòåãîðèè (ôîðìóëà)	 
S_BRUTTO3	text	No	No	Âõîä (áðóòòî) ïî 3 êàòåãîðèè (ôîðìóëà)	 
S_NETTO	text	No	No	Âûõîä (íåòòî) ïî 1 êàòåãîðèè (ôîðìóëà)	 
S_NETTO2	text	No	No	Âûõîä (íåòòî) ïî 2 êàòåãîðèè (ôîðìóëà)	 
S_NETTO3	text	No	No	Âûõîä (íåòòî) ïî 1 êàòåãîðèè (ôîðìóëà)	 
S_NOT_CALC	text	No	No	ïðèçíàê ðàñ÷åòà (ôîðìóëà)	 
S_SUMMA	text	No	No	ôîðìóëà äëÿ ðàñ÷åòà ñóììû	 

t_calc_item
Column List
Code	Type	P	M	Label	 
CALC_ITEM_ID	numeric(9,0)	Yes	Yes	Èäåíòèôèêàòîð çàïèñè id	 
KLS_ID	numeric(9)	No	No	id çíà÷åíèÿ ñïðàâî÷íèêà	 
CALC_ID	numeric(9)	No	Yes	Ññûëêà íà ñïåöèôèêàöèþ	 
ITEM	int	No	No	Íîìåð ïî ïîðÿäêó	 
SUBITEM	int	No	No	Ïîðÿäîê âíóòðè Íîìåðà ï/ï (ìèíèì. - îñíîâíàÿ çàïèñü)	 
SPEC_ID	numeric(9)	No	No	Ññûëêà íà ñïåöèôèêàöèþ êîìïîíåíòà	 
EXPENSE_ID	numeric(9)	No	No	Ññûëêà íà ñòàòüþ çàòðàò	 
NOT_CALC	numeric(1)	No	No	Ïðèçíàê: íå ðàññ÷èòûâàòü	 
S_SUMMA	text	No	No	Ôîðìóëà äëÿ ðàñ÷åòà ñóììû	 
INPUT_DATE	datetime	No	Yes	Äàòà ïîñëåäíåé êîððåêòèðîâêè	 
USER_ID	varchar(32)	No	No	Ïîëüçîâàòåëü	 
FILIAL_NUM	char(2)	No	No	ôèëèàë ñîçäàòåëü	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 
BRUTTO	numeric(19,7)	No	No	Âõîä (áðóòòî) ïî 1 êàòåãîðèè	 
BRUTTO2	numeric(19,7)	No	No	Âõîä (áðóòòî) ïî 2 êàòåãîðèè	 
BRUTTO3	numeric(19,7)	No	No	Âõîä (áðóòòî) ïî 3 êàòåãîðèè	 
NETTO	numeric(19,7)	No	No	Âûõîä (íåòòî) ïî 1 êàòåãîðèè	 
NETTO2	numeric(19,7)	No	No	Âûõîä (íåòòî) ïî 2 êàòåãîðèè	 
NETTO3	numeric(19,7)	No	No	Âûõîä (íåòòî) ïî 3 êàòåãîðèè	 

t_calc_none
Column List
Code	Type	P	M	Label	 
CALC_NONE_ID	numeric(9,0)	Yes	Yes	Èäåíòèôèêàòîð çàïèñè id	 
KLS_ID	numeric(9)	No	No	id çíà÷åíèÿ ñïðàâî÷íèêà	 
PERIOD_BEG	datetime	No	No	Íà÷àëî äåéñòâèÿ	 
PERIOD_END	datetime	No	No	Îêîí÷àíèå äåéñòâèÿ	 
KLS_ID_CHANGE	numeric(9)	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	Äàòà ïîñëåäíåé êîððåêòèðîâêè	 
S_FORMULA	varchar(250)	No	No	Ôîðìóëà ðàñ÷åòà	 
USER_ID	varchar(32)	No	No	Ïîëüçîâàòåëü	 
FILIAL_NUM	char(2)	No	No	ôèëèàë ñîçäàòåëü	 
FILIAL_USER	char(2)	No	No	íîìåð ôèëèàëà	 

T_kls_all
Column List
Code	Type	P	M	Label	 
KLS_ID	numeric(9)	Yes	Yes	id çíà÷åíèÿ ñïðàâî÷íèêà	 
KLS_END	datetime	No	Yes	äàòà âûáûòèÿ	 
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	ïîëüçîâàòåëüñêèé íîìåð (äëÿ ñë. öåëåé)	 
FILIAL_NUM	char(2)	No	No	ôèëèàë-ñîçäàòåëü	 
KLS_ISEDIT	numeric(1)	No	No	ìîæíî ëè èçìåíÿòü äàííóþ çàïèñü	 
SEND	numeric(1)	No	No	èçìåíåíà ëè çàïèñü (äëÿ êîðïîð. Null-äà)	 
BRANCH	numeric(9)	No	No	ïðåäïðèÿòèå	 
CREAT_DATE	datetime	No	No	âðåìÿ ñîçäàíèÿ	 
REGIST_PERIOD	datetime	No	No	ïåðèîä ðåãèñòðàöèè (äëÿ äîêóìåíòîâ)	 
REGIST_DATE	datetime	No	No	äàòà äîêóìåíòà	 
BARCODE	varchar(20)	No	No	øòðèõ-êîä	 
BNK_CODE	varchar(15)	No	No	êîä äëÿ ôîðìèðîâàíèÿ ïîðÿäêîãî íîìåðà ëèöåâîãî ñ÷åòà	 
BNK_CODE2	varchar(15)	No	No	êîä 2 äëÿ ôîðìèðîâàíèÿ ïîðÿäêîãî íîìåðà ëèöåâîãî ñ÷åòà	 

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	âèä îïåðàöèè (ïðèìåíÿåòñÿ â òîðãîâëå)	 
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	êîëè÷åñòâî ïóñòûõ ÿ÷ååê	 
KLSOPER_TEXT	text	No	No	òåêñò sql- çàïðîñà äëÿ èìïîðòà èç ODBC - èñòî÷íèêà	 
BRANCH_NUM	varchar(4000)	No	No	Ñïèñîê íîìåðîâ êîìïàíèé ÷åðåç çàïÿòóþ, äëÿ êîòîðûõ èñïîëüçóåòñÿ îïåðàöèÿ	 
TASK_LIST	varchar(250)	No	No	Ñïèñîê çàäà÷	 
KLSOPER_LOG	numeric(1)	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_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-äà	 

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_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	  =  	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_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_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