LG_CMPGNLINE

Alanlar ve Açıklamaları

Field Name Field Type Field Size Field Offset Türkçe Açıklama Expression
LOGICALREF Longint 4 0 Kampanya Satırı Logical Ref. Capaign Line Logical Reference
CAMPCARDREF Longint 4 4 Kampanya Kartı Referansı Campaign Card Reference
LINENR Integer 2 8 Satır Numarası Line Number
LINETYPE Integer 2 10 Satır Tipi ;1 İndirim;2 Masraf;3 Promosyon;4 Puan Line Type ;1 İndirim;2 Masraf;3 Promosyon;4 Puan
APPLYTYPE Integer 2 12 Uygulama Türü ; 0 Satıra; 1 Genele Application Type ;0 Satıra;1 Genele
CONDITEMCODE ZString 25 14 Koşul Malzeme Kodu Condition Item Code
CONDITION ZString 251 39 Koşul Condition
FORMULA ZString 251 290 Formül Formula
ITEMREF Longint 4 541 Malzeme Kartı Referansı Item Card Reference
USREF Longint 4 545 Birim Seti Referansı Unit Set Reference
UOMREF Longint 4 549 Birim referansı Unit Reference
PROMISCLASS Byte 1 553 Malzeme Sınıfı Is Material Class
LINEEXP ZString 31 554 Satır Açıklaması Line Description
ACCOUNTREF Longint 4 585 EMUHACC LOGICALREF EMUHACC LOGICALREF
CENTERREF Longint 4 589 EMCENTER LOGICALREF EMCENTER LOGICALREF

İlişkiler – Relations

Level Product ID Resource ID Special Code Source Field Destination Table Destination Field Relation Type Extra Condition
1 0 906   CAMPCARDREF L_CAMPAIGN LOGICALREF one-to-one  
1 0 906   USREF L_UNITSETF LOGICALREF one-to-one  
1 0 906   UOMREF L_UNITSETL LOGICALREF one-to-one  
1 0 906   ACCOUNTREF L_EMUHACC LOGICALREF one-to-one  
1 0 906   CENTERREF L_EMCENTER LOGICALREF one-to-one  

Indexler

Level Product ID Index Name Attributes Segment No Segment Field Sense
1 0 Index1 Unique + Not Null 1 LOGICALREF Ascending
1 0 Index2 Duplicate + Not Null 1 CAMPCARDREF Ascending
1 0 Index2 Duplicate + Not Null 2 LINENR Ascending

>