LG_ORFLINE

Alanlar ve Açıklamaları

Field Name Field Type Field Size Field Offset Türkçe Açıklama Expression
LOGICALREF Longint 4 0 Sipariş hareketi log. Ref. Order Transaction Logical Reference
STOCKREF Longint 4 4 Malzeme Kartı Referansı Item Card Reference
ORDFICHEREF Longint 4 8 Sipariş fişi Ref. Order Voucher Reference
CLIENTREF Longint 4 12 Cari Hesap Ref. Account Receivable / Payable Reference
LINETYPE Byte 1 16 Satır türü ;0 Malzeme satırı;1 Promosyon;2 İndirim;3 Masraf;4 Hizmet;5 Depozito;6 Karma koli satırı;7 Karma koli detayı;8 Sabit kıymet satırı LineType ;0 Item Line;1 Promotion;2 Discount;3 Surcharge;4 Service;5 Deposit;6 Mixed Case Line;7 Mixed Case Details;8 Fixed Asset Line
PREVLINEREF Longint 4 17 Üst Malzeme Sınıfı Satır Referansı Parent Material Class Line Reference
PREVLINENO Integer 2 21 Üst Malzeme Sınıfı Satır Numarası Parent Material Class Line Number
DETLINE Byte 1 23 Malzeme Sınıfı Detay Satırı Material Class Detail Line
LINENO_ Integer 2 24 Satır Numarası Line Number
TRCODE Integer 2 26 Fiş Türü ;1 Alınan siparişler;2 Verilen siparişler Voucher Type ;1 Sales Orders;2 Purchase Orders
DATE_ Longint 4 28 Tarih Date
TIME_ Longint 4 32 Zaman Time
GLOBTRANS Byte 1 36 İndirim / Masraf ve Promosyon Satırları ; 0 Satır; 1 Genel Discount / Surcharge and Promotion Lines ;0 Line;1 General
CALCTYPE Byte 1 37 Hesaplama Türü ; 0 Yüzde %; 1 Fonksiyon f(x); 2 Tutar TL Calculation Type ;0 Percentage %;1 Function f(x);2 Amount TL
CENTERREF Longint 4 38 Masraf Merkezi Ref. Overhead Pool Reference
ACCOUNTREF Longint 4 42 Genel Muhasebe Hesabı Ref. General Ledger Account Reference
VATACCREF Longint 4 46 KDV muhasebe hesabı ref. VAT General Ledger Account Reference
VATCENTERREF Longint 4 50 KDV masraf merkezi ref. VAT Overhead Pool Reference
PRACCREF Longint 4 54 Promosyon muhasebe hesabı ref. Promotion General Ledger Account Reference
PRCENTERREF Longint 4 58 Promosyom masraf merkezi ref. Promotion Over Pool Reference
PRVATACCREF Longint 4 62 Promosyon KDV Genel Muhasebe Hesabı Numarası General Ledger Account of Promotion VAT
PRVATCENREF Longint 4 66 Promosyon KDV Masraf Merkezi Ref. Overhead Pool Reference of Promotion VAT
PROMREF Longint 4 70 Promosyon kartı ref. Promotion Card Reference
SPECODE ZString 17 74 Özel Kod Aux. Code
DELVRYCODE ZString 5 91 Teslimat Kodu Delivery Code
AMOUNT Double 8 96 Miktar Quantity
PRICE Double 8 104 Fiyat Price
TOTAL Double 8 112 Toplam Total
SHIPPEDAMOUNT Double 8 120 Sevkedilen Miktar Delivered Quantity
DISCPER Double 8 128 İndirim yüzdesi Percentage of Discount
DISTCOST Double 8 136 Satıra Dağıtılan Maliyet (Karma Koli) Distributed Cost to Line (Mixed Case)
DISTDISC Double 8 144 Satıra Dağıtılan İndirim (Karma Koli) Distributed Discount to Line (Mixed Case)
DISTEXP Double 8 152 Satıra Dağıtılan Masraf (Karma Koli) Distributed Surcharge to Line (Mixed Case)
DISTPROM Double 8 160 Satıra Dağıtılan Promosyon (Karma Koli) Distributed Promotion to Line (Mixed Case)
VAT Double 8 168 KDV VAT
VATAMNT Double 8 176 Net KDV Tutarı Net VAT Amount
VATMATRAH Double 8 184 KDV matrahı VAT Base Amount
LINEEXP ZString 31 192 Satır Açıklaması Line Description
UOMREF Longint 4 223 Birim referansı Unit Reference
USREF Longint 4 227 Birim Seti Referansı Unit Set Reference
UINFO1 Double 8 231 Çevrim Katsayısı Conversion Factor
UINFO2 Double 8 239 Çevrim Katsayısı Conversion Factor
UINFO3 Double 8 247 Boyut Katsayısı Dimension Factor
UINFO4 Double 8 255 Boyut Katsayısı Dimension Factor
UINFO5 Double 8 263 Boyut Katsayısı Dimension Factor
UINFO6 Double 8 271 Boyut Katsayısı Dimension Factor
UINFO7 Double 8 279 Boyut Katsayısı Dimension Factor
UINFO8 Double 8 287 Boyut Katsayısı Dimension Factor
VATINC Byte 1 295 KDV dahil / hariç VAT Included / Excluded
CLOSED Byte 1 296 Sipariş kapandı Order is Closed
DORESERVE Byte 1 297 Malzeme Rezerve Edilecek Item Will be Reserved
INUSE Byte 1 298 Kullanımda In Use
DUEDATE Longint 4 299 Teslimat Tarihi Delivery Date
PRCURR Byte 1 303 Fiyatlandırma dövizi kuru Pricing Currency Exchange Rate
PRPRICE Double 8 304 Fiyat (Fiyatlandırma dövizi) Price of Pricing Currency
REPORTRATE Double 8 312 Fiyat (Raporlama dövizi) Price of Reporting Currency
BILLEDITEM Longint 4 320 Faturalanacak Malzeme Item That Need to be Billed
PAYDEFREF Longint 4 324 Ödeme Planı Referansı Payment Plan Reference
EXTENREF Longint 4 328 Dosya Uzantısı Referansı Extension File Reference
CPSTFLAG Byte 1 332 Karma Koli Satırı Mixed Case Line
SOURCEINDEX Integer 2 333 Ambar Numarası Warehouse Number
SOURCECOSTGRP Integer 2 335 Ambar maliyet grubu Warehouse Cost Group
BRANCH Integer 2 337 İşyeri Division
DEPARTMENT Integer 2 339 Bölüm Department
LINENET Double 8 341 Net Satır Toplamı Net Line Total
SALESMANREF Longint 4 349 Satış Temsilcisi Referansı Sales Representative Card Reference
STATUS Integer 2 353 Onay Bilgisi Approval Info
DREF Longint 4 355 Satır Dağıtım Şablonları Kayıt Referansı Lines Distribution Templates Record Reference
TRGFLAG Byte 1 359 Trigger işareti ;0 Trigger kullanılacak;1 Trigger kullanılmayacak Trigger Flag ;0 Trigger Will Be Used;1 Trigger Won’t Be Used
SITEID Integer 2 360 Veri Merkezi Data Processing Site
RECSTATUS Integer 2 362 Kayıt Durumu Record Status
ORGLOGICREF Longint 4 364 Orijinal Kayıt Log. Ref. Original Record Logical Reference
FACTORYNR Integer 2 368 Fabrika Numarası Plant Number
WFSTATUS Longint 4 370 Kullanımda Değil Not In Use
NETDISCFLAG Byte 1 374 Net İndirim Satırı ve Tutar İşareti Net Discount Line And Amount Flag
NETDISCPERC Double 8 375 Net İndirim Oranı (%) Net Discount Rate (%)
NETDISCAMNT Double 8 383 Net İndirim Tutarı Net Discount Amount
CONDITIONREF Longint 4 391 Satınalma / Satış koşulları ref. Purchase / Sales Condition Reference
DISTRESERVED Double 8 395 Dağıtım rezerve miktarı Reserved Distribution Amount
ONVEHICLE Double 8 403 Dağıtımda In Distribution
CAMPAIGNREFS1 Longint 4 411 Kampanya Kartı Referansı 1 Campaign Card Reference 1
CAMPAIGNREFS2 Longint 4 415 Kampanya Kartı Referansı 2 Campaign Card Reference 2
CAMPAIGNREFS3 Longint 4 419 Kampanya Kartı Referansı 3 Campaign Card Reference 3
CAMPAIGNREFS4 Longint 4 423 Kampanya Kartı Referansı 4 Campaign Card Reference 4
CAMPAIGNREFS5 Longint 4 427 Kampanya Kartı Referansı 5 Campaign Card Reference 5
POINTCAMPREF Longint 4 431 Kampanya puanı ref. Point Campaign Card Reference
CAMPPOINT Double 8 435 Kampanya Puanı Campaign Point
PROMCLASITEMREF Longint 4 443 Promosyon sınıfı ref. (kampanyadan) Promotion Class Reference Earned From Campaign
REASONFORNOTSHP Integer 2 447 Sevk edilememe nedeni Reason For Not Shipment
CMPGLINEREF Longint 4 449 Kampanya Satırı Referansı Campaign Line Reference
PRRATE Double 8 453 Fiyatlandırma dövizi kuru Pricing Currency Exchange Rate
GROSSUINFO1 Double 8 461 Bürüt Çevrim Katsayısı 1 Gross Conversion Factor1
GROSSUINFO2 Double 8 469 Bürüt Çevrim Katsayısı 2 Gross Conversion Factor2
CANCELLED Byte 1 477 İptal Edilmiş Cancelled
DEMPEGGEDAMNT Double 8 478 Talep karşılamada kullanılan miktar Quantity Used in Demand Delivery
TEXTINC Byte 1 486 Ayrıntılı Açıklama İçerir Contains Detail Description
OFFERREF Longint 4 487 Teklifler Ref. Offers Reference
ORDERPARAM Integer 2 491 Kullanımda Değil Not In Use
ITEMASGREF Longint 4 493 Kullanımda Değil Not In Use
EXIMAMOUNT Double 8 497 İthalat/İhracat Miktarı Import/Export Quantity
OFFTRANSREF Longint 4 505 Teklif işlemi log. Ref. Offer Transactions Logical Reference
ORDEREDAMOUNT Double 8 509 Sipariş miktarı Ordered quantity
ORGLOGOID ZString 25 517 Veri Merkezi Data Processing Site
TRCURR Byte 1 542 İD Türü Transaction Currency Type
TRRATE Double 8 543 İşlem dövizi kuru Transaction Currency Exchange Rate
WITHPAYTRANS Byte 1 551 Ödemeli / Ödemesiz? With payment / Without Payment?
PROJECTREF Longint 4 552 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 713   STOCKREF L_ITEMS LOGICALREF one-to-one LINETYPE = 0, 5, 6, 7
2 3 713   ORDFICHEREF L_ORFICHE LOGICALREF one-to-one  
2 3 713   CLIENTREF L_CLCARD LOGICALREF one-to-one  
2 3 713   CENTERREF L_EMCENTER LOGICALREF one-to-one  
2 3 713   ACCOUNTREF L_EMUHACC LOGICALREF one-to-one  
2 3 713   VATACCREF L_EMUHACC LOGICALREF one-to-one  
2 3 713   VATCENTERREF L_EMCENTER LOGICALREF one-to-one  
2 3 713   PRACCREF L_EMUHACC LOGICALREF one-to-one  
2 3 713   PRCENTERREF L_EMCENTER LOGICALREF one-to-one  
2 3 713   PRVATACCREF L_EMUHACC LOGICALREF one-to-one  
2 3 713   PRVATCENREF L_EMCENTER LOGICALREF one-to-one  
2 3 713   PROMREF L_PRCARDS LOGICALREF one-to-one  
2 3 713   UOMREF L_UNITSETL LOGICALREF one-to-one  
2 3 713   USREF L_UNITSETF LOGICALREF one-to-one  
2 3 713   PAYDEFREF L_PAYPLANS LOGICALREF one-to-one  
2 3 713   SALESMANREF L_SLSMAN LOGICALREF one-to-one  
2 3 713   DREF L_DISTTEMP LOGICALREF one-to-one  
2 3 713   PREVLINEREF L_ITEMS LOGICALREF one-to-one  
2 3 713   PREVLINENO L_ORFLINE LINENO_ one-to-one  
2 3 713   STOCKREF L_PRCARDS LOGICALREF one-to-one LINETYPE = 1
2 3 713   STOCKREF L_DECARDS LOGICALREF one-to-one LINETYPE = 2, 3
2 3 713   STOCKREF L_SRVCARD LOGICALREF one-to-one LINETYPE = 4
2 3 713   STOCKREF L_FAREGIST LOGICALREF one-to-one LINETYPE = 8
2 3 713   CAMPAIGNREFS1 L_CAMPAIGN LOGICALREF one-to-one  
2 3 713   CAMPAIGNREFS2 L_CAMPAIGN LOGICALREF one-to-one  
2 3 713   CAMPAIGNREFS3 L_CAMPAIGN LOGICALREF one-to-one  
2 3 713   CAMPAIGNREFS4 L_CAMPAIGN LOGICALREF one-to-one  
2 3 713   CAMPAIGNREFS5 L_CAMPAIGN LOGICALREF one-to-one  
2 3 713   POINTCAMPREF L_CAMPAIGN LOGICALREF one-to-one  
2 3 713   PROMCLASITEMREF L_ITEMS LOGICALREF one-to-one  
2 3 713   CMPGLINEREF L_CMPGNLINE LOGICALREF one-to-one  
2 3 713   OFFERREF L_OFFER LOGICALREF one-to-one  
2 3 713   OFFTRANSREF L_OFFTRNS LOGICALREF one-to-one  
2 3 713   PROJECTREF 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 STOCKREF Ascending
2 3 Index2 Duplicate + Not Null 2 DATE_ Ascending
2 3 Index2 Duplicate + Not Null 3 TIME_ Ascending
2 3 Index2 Duplicate + Not Null 4 TRCODE Ascending
2 3 Index2 Duplicate + Not Null 5 ORDFICHEREF Ascending
2 3 Index3 Duplicate + Not Null 1 DATE_ Ascending
2 3 Index3 Duplicate + Not Null 2 TIME_ Ascending
2 3 Index3 Duplicate + Not Null 3 TRCODE Ascending
2 3 Index3 Duplicate + Not Null 4 STOCKREF Ascending
2 3 Index3 Duplicate + Not Null 5 ORDFICHEREF Ascending
2 3 Index4 Duplicate + Not Null 1 ORDFICHEREF Ascending
2 3 Index4 Duplicate + Not Null 2 LINENO_ Ascending
2 3 Index5 Duplicate + Not Null 1 CLIENTREF Ascending
2 3 Index5 Duplicate + Not Null 2 DATE_ Ascending
2 3 Index5 Duplicate + Not Null 3 TIME_ Ascending
2 3 Index5 Duplicate + Not Null 4 TRCODE Ascending
2 3 Index6 Duplicate + Not Null 1 SALESMANREF Ascending
2 3 Index6 Duplicate + Not Null 2 STOCKREF Ascending
2 3 Index6 Duplicate + Not Null 3 TRCODE Ascending
2 3 Index7 Duplicate + Not Null 1 UOMREF Ascending
2 3 Index8 Duplicate + Not Null 1 ORDFICHEREF Ascending
2 3 Index8 Duplicate + Not Null 2 PREVLINEREF Ascending
2 3 Index8 Duplicate + Not Null 3 PREVLINENO Ascending
2 3 Index9 Duplicate + Not Null 1 OFFTRANSREF Ascending
2 3 Index10 Unique + Not Null 1 ORGLOGICREF Ascending
2 3 Index10 Unique + Not Null 2 LOGICALREF Ascending
2 3 Index10 Unique + Not Null 3 SITEID Ascending

>