LG_ACCDISTDETLN

Alanlar ve Açıklamaları

Field Name Field Type Field Size Field Offset Türkçe Açıklama Expression
LOGICALREF Longint 4 0 Logical Reference Logical Reference
ACCFICHEREF Longint 4 4 EMFICHE LOGICALREF EMFICHE LOGICALREF
LINENR Integer 2 8 Satır Numarası Line Number
ACCOUNTREF Longint 4 10 EMUHACC LOGICALREF EMUHACC LOGICALREF
PREVLINEREF Longint 4 14 Proje Log. Ref. PROJECT LOGICALREF
CENTERREF Longint 4 18 EMCENTER LOGICALREF EMCENTER LOGICALREF
PROJECTREF Longint 4 22 Proje Log. Ref. PROJECT LOGICALREF
BRANCH Integer 2 26 İşyeri Division
DISTRATE Double 8 28 Dağıtım Oranı Distribution Rate
CREDEBNET Double 8 36 Borç/Alacak Net Tutar Debit / Credit Net Amount
EMUCREDEBNET Double 8 44 Borç/Alacak Net Tutar (EURO) Debit / Credit Net Amount (EURO)
TRCURR Byte 1 52 İD Türü Transaction Currency Type
TRRATE Double 8 53 İşlem dövizi kuru Transaction Currency Exchange Rate
TRNET Double 8 61 İşlem dövizi tutarı Transaction Currency Amount
REPORTRATE Double 8 69 RD Kuru Reporting Currency Exchange Rate
REPORTNET Double 8 77 RD Tutarı Reporting Currency Amount
LINEEXCTYP Integer 2 85 Döviz Türü (Satır) F. Currency Type (Line)
TRCODE Integer 2 87 Fiş türü Voucher Type
DATE_ Longint 4 89 Tarih Date
TSIGN Integer 2 93 Borç/Alacak İşareti Debit / Credit Sign
CANCELLED Byte 1 95 İptal Edilmiş Cancelled
SITEID Integer 2 96 Veri Merkezi Data Processing Site
RECSTATUS Integer 2 98 Kayıt Durumu Record Status
ORGLOGICREF Longint 4 100 Orijinal Kayıt Log. Ref. Original Record Logical Reference
WFSTATUS Longint 4 104 Kullanımda Değil Not In Use

İ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
2 0 Index1 Unique + Not Null 1 LOGICALREF Ascending
2 0 Index2 Duplicate + Not Null 1 PREVLINEREF Ascending
2 0 Index3 Duplicate + Not Null 1 CENTERREF Ascending
2 0 Index3 Duplicate + Not Null 2 DATE_ Ascending
2 0 Index3 Duplicate + Not Null 3 TSIGN Ascending
2 0 Index4 Duplicate + Not Null 1 PROJECTREF Ascending
2 0 Index4 Duplicate + Not Null 2 DATE_ Ascending
2 0 Index4 Duplicate + Not Null 3 TSIGN Ascending

>