LG_CLFLINE

Alanlar ve Açıklamaları

Field Name Field Type Field Size Field Offset Türkçe Açıklama Expression
LOGICALREF Longint 4 0 Cari Hesap Hareketi Logical Ref. Account Receivable / Payable Transaction Logical Reference
CLIENTREF Longint 4 4 Cari Hesap Ref. Account Receivable / Payable Reference
CLACCREF Longint 4 8 Cari Hesap Muhasebe Hesabı Ref. Account Receivable / Payable General Ledger Account Reference
CLCENTERREF Longint 4 12 Cari Hesap Masraf Merkezi Ref. Account Receivable / Payable Overhead Pool Reference
CASHCENTERREF Longint 4 16 Kasa masraf merkezi ref. Safe Deposit Overhead Pool Reference
CASHACCOUNTREF Longint 4 20 Kasa muhasebe hesabı ref. Safe Deposit General Ledger Account Reference
VIRMANREF Longint 4 24 Virman satırı ref. Remittance Line Reference
SOURCEFREF Longint 4 28 Tanımlanmış modülde fiş referansı Specified Voucher Reference of Specified Module
DATE_ Longint 4 32 Tarih Date
DEPARTMENT Integer 2 36 Bölüm Department
BRANCH Integer 2 38 İşyeri Division
MODULENR Integer 2 40 Modül Numarası; 10 Kasa Module Number ;10 kasa
TRCODE Integer 2 42 Hareket türü Transaction Type
LINENR Integer 2 44 Hareket türü: virman Transaction Type is Remittance
SPECODE ZString 11 46 Özel Kod Aux. Code
CYPHCODE ZString 11 57 Yetki Kodu Auth. Code
TRANNO ZString 9 68 Hareket numarası Transaction Number
DOCODE ZString 9 77 Belge Numarası Document Number
LINEEXP ZString 51 86 Hareket açıklaması Transaction Description
ACCOUNTED Byte 1 137 Muhasebeleştirildi Posted to General Ledger
SIGN Integer 2 138 Borç/Alacak İşareti Debit / Credit Sign
AMOUNT Double 8 140 Tutar Amount
TRCURR Byte 1 148 İD Türü Transaction Currency Type
TRRATE Double 8 149 İşlem dövizi kuru Transaction Currency Exchange Rate
TRNET Double 8 157 İşlem dövizi tutarı Transaction Currency Amount
REPORTRATE Double 8 165 RD Kuru Reporting Currency Exchange Rate
REPORTNET Double 8 173 RD Tutarı Reporting Currency Amount
EXTENREF Longint 4 181 Dosya Uzantısı Referansı Extension File Reference
PAYDEFREF Longint 4 185 Ödeme Planı Referansı Payment Plan Reference
ACCFICHEREF Longint 4 189 Genel Muhasebe Fişi Referansı General Ledger Voucher Reference
PRINTCNT Integer 2 193 Basılmış Toplam Hesap Total Count of Printed
CAPIBLOCK_CREATEDBY Integer 2 195 Oluşturan Created By
CAPIBLOCK_CREADEDDATE Longint 4 197 Oluşturulma Tarihi Created Date
CAPIBLOCK_CREATEDHOUR Integer 2 201 Oluşturulma Saati Created Hour
CAPIBLOCK_CREATEDMIN Integer 2 203 Oluşturulma Dakikası Created Minute
CAPIBLOCK_CREATEDSEC Integer 2 205 Oluşturulma Saniyesi Created Second
CAPIBLOCK_MODIFIEDBY Integer 2 207 Değiştiren Modified By
CAPIBLOCK_MODIFIEDDATE Longint 4 209 Değiştirilme Tarihi Modified Date
CAPIBLOCK_MODIFIEDHOUR Integer 2 213 Değiştirilme Saati Modified Hour
CAPIBLOCK_MODIFIEDMIN Integer 2 215 Değiştirilme Dakikası Modified Minute
CAPIBLOCK_MODIFIEDSEC Integer 2 217 Değiştirilme Saniyesi Modified Second
CANCELLED Byte 1 219 İptal Edilmiş Cancelled
TRGFLAG Byte 1 220 Trigger işareti ;0 Trigger kullanılacak;1 Trigger kullanılmayacak Trigger Flag ;0 Trigger Will Be Used;1 Trigger Won’t Be Used
TRADINGGRP ZString 17 221 Ticari İşlem Grubu Trading Option
LINEEXCTYP Integer 2 238 Döviz Türü (Satır) F. Currency Type (Line)
ONLYONEPAYLINE Byte 1 240 Tek satırlı ödeme planı One Lined Payment Plan
DISCFLAG Byte 1 241 İndirim Satırı İşareti Discount Line Flag
DISCRATE Double 8 242 İndirim Oranı Discount Rate
VATRATE Double 8 250 KDV oranı VAT Rate
CASHAMOUNT Double 8 258 Nakit (İndirimli) Cash (Discounted)
DISCACCREF Longint 4 266 İndirim Genel Muhasebe Hesabı Ref. Discount General Ledger Account Reference
DISCCENREF Longint 4 270 İndirim Masraf Merkezi Ref. Discount Overhead Pool Reference
VATRACCREF Longint 4 274 KDV muhasebe hesabı ref. VAT General Ledger Account Reference
VATRCENREF Longint 4 278 KDV masraf merkezi ref. VAT Overhead Pool Reference
PAYMENTREF Longint 4 282 Ödeme Planı Referansı Payment Plan Reference
VATAMOUNT Double 8 286 KDV tutarı VAT Amount
SITEID Integer 2 294 Veri Merkezi Data Processing Site
RECSTATUS Integer 2 296 Kayıt Durumu Record Status
ORGLOGICREF Longint 4 298 Orijinal Kayıt Log. Ref. Original Record Logical Reference
INFIDX Double 8 302 Enflasyon Endeksi Inflation Index
POSCOMMACCREF Longint 4 310 Genel Muhasebe Hesapları Referansı General Ledger Accounts Reference
POSCOMMCENREF Longint 4 314 Masraf Merkezi Referansı Overhead Pools Reference
POINTCOMMACCREF Longint 4 318 Genel Muhasebe Hesapları Referansı General Ledger Accounts Reference
POINTCOMMCENREF Longint 4 322 Masraf Merkezi Referansı Overhead Pools Reference
CHEQINFO ZString 121 326 Çek Bilgisi Check Info
CREDITCNO ZString 25 447 Açıklama 2 Definition2
CLPRJREF Longint 4 472 Proje Referansı PROJECT Reference

İlişkiler – Relations

Level Product ID Resource ID Special Code Source Field Destination Table Destination Field Relation Type Extra Condition
2 3 716   SOURCEFREF L_CSTRANS LOGICALREF one-to-one TRCODE=3 AND MODULENR=61
2 3 716   SOURCEFREF L_CLFICHE LOGICALREF one-to-one (TRCODE=01, 02, 03, 04, 05,06,12,14) AND MODULENR=5
2 3 716   SOURCEFREF L_INVOICE LOGICALREF one-to-one (TRCODE=31,32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44,56) AND MODULENR=4
2 3 716   CLACCREF L_EMUHACC LOGICALREF one-to-one  
2 3 716   CLCENTERREF L_EMCENTER LOGICALREF one-to-one  
2 3 716   CASHCENTERREF L_EMCENTER LOGICALREF one-to-one  
2 3 716   CASHACCOUNTREF L_EMUHACC LOGICALREF one-to-one  
2 3 716   PAYDEFREF L_PAYPLANS LOGICALREF one-to-one  
2 3 716   ACCFICHEREF L_EMFICHE LOGICALREF one-to-one  
2 3 716   CLIENTREF L_CLCARD LOGICALREF one-to-one  
2 3 716   SOURCEFREF L_BNFLINE LOGICALREF one-to-one (TRCODE = 20 , 21) MODULENR = 7
2 3 716   PAYMENTREF L_PAYPLANS LOGICALREF one-to-one  
2 3 716   DISCACCREF L_EMUHACC LOGICALREF one-to-one  
2 3 716   DISCCENREF L_EMCENTER LOGICALREF one-to-one  
2 3 716   VATRACCREF L_EMUHACC LOGICALREF one-to-one  
2 3 716   VATRCENREF L_EMCENTER LOGICALREF one-to-one  
2 3 716   VIRMANREF L_CLFLINE LOGICALREF one-to-one  
2 3 716   SOURCEFREF L_KSLINES LOGICALREF one-to-one MODULENR=10
2 3 716   POSCOMMACCREF L_EMUHACC LOGICALREF one-to-one  
2 3 716   POINTCOMMCENREF L_EMCENTER LOGICALREF one-to-one  
2 3 716   POINTCOMMACCREF L_EMUHACC LOGICALREF one-to-one  
2 3 716   POINTCOMMCENREF L_EMCENTER LOGICALREF one-to-one  
2 3 716   CLPRJREF L_PROJECT LOGICALREF one-to-one  

Indexler

Level Product ID Index Name Attributes Segment No Segment Field Sense
2 3 Index1 Unique + Not Null 1 LOGICALREF Ascending
2 3 Index2 Duplicate + Not Null 1 TRCODE Ascending
2 3 Index2 Duplicate + Not Null 2 TRANNO Ascending
2 3 Index2 Duplicate + Not Null 3 LINENR Ascending
2 3 Index3 Duplicate + Not Null 1 DATE_ Ascending
2 3 Index3 Duplicate + Not Null 2 TRCODE Ascending
2 3 Index3 Duplicate + Not Null 3 TRANNO Ascending
2 3 Index4 Duplicate + Not Null 1 CLIENTREF Ascending
2 3 Index4 Duplicate + Not Null 2 DATE_ Ascending
2 3 Index4 Duplicate + Not Null 3 MODULENR Ascending
2 3 Index4 Duplicate + Not Null 4 TRCODE Ascending
2 3 Index5 Duplicate + Not Null 1 MODULENR Ascending
2 3 Index5 Duplicate + Not Null 2 SOURCEFREF Ascending
2 3 Index6 Duplicate + Not Null 1 ACCFICHEREF Ascending
2 3 Index7 Duplicate + Not Null 1 SOURCEFREF Ascending
2 3 Index7 Duplicate + Not Null 2 LINENR Ascending

>