L_DIIBLINE

Alanlar ve Açıklamaları

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

>