Logo/Tablo Açıklamaları Yeni/L_DIIBLINE

L_DIIBLINE

Alanlar ve Açıklamaları

Level	Product ID	Field Name	Field Type	Field Size	Field Offset	Türkçe Açıklama	Expression
0	0	LOGICALREF	Longint	4	0	DIIB Satırı Log. Ref.	DIIBLINE Logical Reference
0	0	DIIBFICHEREF	Longint	4	4	Dahilde İşleme İzin Belgesi Ref.	Inward Processing License Reference
0	0	LINETYPE	Integer	2	8	Satır türü ;1: İthaline izin verilen malzeme;2: İhracı taahüt edilen malzeme	Line Type ;1: Permitted Importation Material;2: Subscribed Export Material
0	0	LINENO_	Integer	2	10	Satır Numarası	Line Number
0	0	GTIPCODE	ZString	25	12	GTIP Kodu	GTIP Code
0	0	UOMREF	Longint	4	37	Birim referansı	Units Reference
0	0	USREF	Longint	4	41	Birim Seti Referansı	Unit Sets Reference
0	0	AMOUNT	Double	8	45	Tutar	Amount
0	0	TRNET	Double	8	53	İşlem dövizi tutarı ;1: CIF İhtar;2: FOB Tutar	Transaction Currency Amount ;1: CIF Reminder;2: FOB Amount
0	0	TRCURR	Byte	1	61	İD Türü	Transaction Currency Type
0	0	USAGEAMOUNT	Double	8	62	Miktar	Quantity
0	0	LINEEXP	ZString	31	70	Satır Açıklaması	Line Description
0	0	SPECODE	ZString	11	101	Özel Kod	Aux. Code
0	0	SITEID	Integer	2	112	Veri Merkezi	Data Processing Site
0	0	RECSTATUS	Integer	2	114	Kayıt Durumu	Record Status
0	0	ORGLOGICREF	Longint	4	116	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
0	0	Index1	Unique + Not Null	1	LOGICALREF	Ascending
0	0	Index2	Unique + Not Null	1	DIIBFICHEREF	Ascending
0	0	Index2	Unique + Not Null	2	LINETYPE	Ascending
0	0	Index2	Unique + Not Null	3	LINENO_	Ascending
0	0	Index3	Duplicate + Not Null	1	LINETYPE	Ascending
0	0	Index3	Duplicate + Not Null	2	GTIPCODE	Ascending