Logo/Tablo Açıklamaları Yeni/LG_ITEMSUBS

LG_ITEMSUBS

Alanlar ve Açıklamaları

Level	Product ID	Field Name	Field Type	Field Size	Field Offset	Türkçe Açıklama	Expression
1	0	LOGICALREF	Longint	4	0	Malzeme Alternatifleri Ataması Log. Ref.	Item Alternatives Assignment Logical Reference
1	0	MAINITEMREF	Longint	4	4	Ana Malzeme Ref.	Main Item Reference
1	0	SUBITEMREF	Longint	4	8	Alternatif Malzeme Referansı	Alternative Item Reference
1	0	LINENO_	Integer	2	12	Satır Numarası	Line Number
1	0	PRIORITY	Integer	2	14	Öncelik	Priority
1	0	CONVFACT1	Double	8	16	Katsayı 1	Factor 1
1	0	CONVFACT2	Double	8	24	Katsayı 2	Factor 2
1	0	MAXQUANTITY	Double	8	32	Azami Miktar	Maximum Quantity
1	0	MINQUANTITY	Double	8	40	Asgari Miktar	Minimum Quantity
1	0	BEGDATE	Longint	4	48	Başlangıç tarihi	Start Date
1	0	ENDDATE	Longint	4	52	Bitiş Tarihi	End Date
1	0	SITEID	Integer	2	56	Veri Merkezi	Data Processing Site
Data Processing Site
Data Processing Site
1	0	RECSTATUS	Integer	2	58	Kayıt Durumu	Record Status
1	0	ORGLOGICREF	Longint	4	60	Orijinal Kayıt Log. Ref.	Original Record Logical Reference

İlişkiler - Relations

Level	Product ID	Resource ID	Special Code	Source Field	Destination Table	Destination Field	Relation Type	Extra Condition

Indexler

Level	Product ID	Index Name	Attributes	Segment No	Segment Field	Sense
1	0	Index1	Unique + Not Null	1	LOGICALREF	Ascending
1	0	Index2	Duplicate + Not Null	1	MAINITEMREF	Ascending
1	0	Index2	Duplicate + Not Null	2	SUBITEMREF	Ascending
1	0	Index2	Duplicate + Not Null	3	PRIORITY	Ascending
1	0	Index3	Duplicate + Not Null	1	SUBITEMREF	Ascending
1	0	Index3	Duplicate + Not Null	2	MAINITEMREF	Ascending
1	0	Index4	Duplicate + Not Null	1	MAINITEMREF	Ascending
1	0	Index4	Duplicate + Not Null	2	LINENO_	Ascending