L_KSDISTDETLINES

Alanlar ve Açıklamaları

Field Name Field Type Field Size Field Offset Türkçe Açıklama Expression
LOGICALREF Longint 4 0 KSDISTDETLINES LOGICALREF KSDISTDETLINES LOGICALREF
CARDREF Longint 4 4 KSCARD LOGICALREF KSCARD LOGICALREF
CASHTRANSREF Longint 4 8 KSLINES LOGICALREF KSLINES LOGICALREF
LINENR Integer 2 12 Satır Numarası Line Number
CSDISTTEMPLINE Byte 1 14 Kasa hesabı; 0 Karşı hesap; 1 Kasa Safe Deposit Account?;0. Offset Account;1. Safe Deposit
ACCREF Longint 4 15 EMUHACC LOGICALREF EMUHACC LOGICALREF
CENTERREF Longint 4 19 EMCENTER LOGICALREF EMCENTER LOGICALREF
PROJECTREF Longint 4 23 Proje Log. Ref. PROJECT LOGICALREF
DISTRATE Double 8 27 Dağıtım Oranı Distribution Rate
DATE_ Longint 4 35 Tarih Date
TRCODE Integer 2 39 Hareket türü ;11,12 :Cari hesap,;21-22: Banka;31-39: Fatura,;61-64 : Çek/Senet,;71-74 Kasa Transaction Type ;11,12 :AR/AP,;21-22: Bank;31-39: Invoice,;61-64 : Check/P.Notes,;71-74 Safe Deposit
BRANCH Integer 2 41 İşyeri Division
DEPARTMENT Integer 2 43 Bölüm Department
AMOUNT Double 8 45 Tutar Amount
REPORTRATE Double 8 53 RD Kuru Reporting Currency Exchange Rate
REPORTNET Double 8 61 RD Tutarı Reporting Currency Amount
TRRATE Double 8 69 İşlem dövizi kuru Transaction Currency Exchange Rate
TRNET Double 8 77 İşlem dövizi tutarı Transaction Currency Amount
TRCURR Integer 2 85 İD Türü Transaction Currency Type
SIGN Integer 2 87 Borç/Alacak İşareti Debit / Credit Sign
LINEEXCTYP Integer 2 89 Döviz Türü (Satır) F. Currency Type (Line)
SITEID Integer 2 91 Veri Merkezi Data Processing Site
RECSTATUS Integer 2 93 Kayıt Durumu Record Status
ORGLOGICREF Longint 4 95 Orijinal Kayıt Log. Ref. Original Record Logical Reference
WFSTATUS Longint 4 99 Kullanımda Değil Not In Use
DISTTEMPLNTYP Integer 2 103 Kasa muhasebe dağıtım satır tipi ;1: Kasa;2: Hareket;3: KDV Safe Deposit G/L Distribution Line Type ;1: Safe Deposit;2: Transaction;3: VAT

İlişkiler – Relations

Level Product ID Resource ID Special Code Source Field Destination Table Destination Field Relation Type Extra Condition
0 0 940   CARDREF L_KSCARD LOGICALREF one-to-one  
0 0 940   CASHTRANSREF L_KSLINES LOGICALREF one-to-one  
0 0 940   ACCREF L_EMUHACC LOGICALREF one-to-one  
0 0 940   CENTERREF L_EMCENTER LOGICALREF one-to-one  
0 0 940   PROJECTREF L_PROJECT LOGICALREF one-to-one  

Indexler

Level Product ID Index Name Attributes Segment No Segment Field Sense
0 0 Index1 Unique + Not Null 1 LOGICALREF Ascending
0 0 Index2 Duplicate + Not Null 1 CASHTRANSREF Ascending
0 0 Index3 Duplicate + Not Null 1 CENTERREF Ascending
0 0 Index3 Duplicate + Not Null 2 DATE_ Ascending
0 0 Index3 Duplicate + Not Null 3 SIGN Ascending
0 0 Index4 Duplicate + Not Null 1 PROJECTREF Ascending
0 0 Index4 Duplicate + Not Null 2 DATE_ Ascending
0 0 Index4 Duplicate + Not Null 3 SIGN Ascending

>