L_DEMANDPEGGING

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
DEMANDLINEREF Longint 4 4 Talep Satırı Log. Ref. DEMANDLINE LOGICALREF
DEMANDFICHEREF Longint 4 8 Talep Fişi Log. Ref. DEMANDFICHE LOGICALREF
PARENTTYPE Integer 2 12 Talep/Kaynak Türü; 0=Manüel 1=MPS 2=MRP Demand/Resource Type;0=Manual;1=MPS;2=MRP;0=Manual;1=MPS;2=MRP;0=Manual;1=MPS;2=MRP;0=Manual;1=MPS
PARENTREF Longint 4 14 MRPHEAD;Alt Tür = 1 ==> MRPHEAD;Childtype = 1 ==>
CHILDTYPE Integer 2 18 Talep Karşılama Türü; 0=Verilen sipariş;1=Üretim emri;2=Ambar fişi;3=Stoktan Karşılanan Demand Delivery Type;0=Purchase Order;1=Production Order;2=Warehouse Voucher;3=Fulfilled From Stock
CHILDREF Longint 4 20 ALTMALZREF;0=Manual;1=MPS;2=MRP;0=Manual;1=MPS;2=MRP;0=Manual;1=MPS;2=MRP;0=Manual;1=MPS CHILDREF;0=Manual;1=MPS;2=MRP;0=Manual;1=MPS;2=MRP;0=Manual;1=MPS;2=MRP;0=Manual;1=MPS
ITEMALTER Byte 1 24 Alternatif Malzeme Temini Alternative Material Procurement
ITEMREF Longint 4 25 Malzemeler Log. Ref. ITEMS LOGICALREF
UNITREF Longint 4 29 Birim seti log. Ref. UNITSETL LOGICALREF
MAINITEMREF Longint 4 33 Malzemeler Log. Ref. ITEMS LOGICALREF
MAINUNITREF Longint 4 37 Birim seti log. Ref. UNITSETL LOGICALREF
MEETAMNT Double 8 41 Karşılama Miktarı Delivery Quantity
MAINMEETAMNT Double 8 49 Sevkedilen Ana Malzeme Miktarı Delivered Main Material Quantity
ORDPERIOD Longint 4 57 Periyot numarası Period Number
CLIENTREF Longint 4 61 Müşteri Kartı Log. Ref. CLCARD LOGICALREF
BOMMASTERREF Longint 4 65   BOM MASTER LOGICAL REF
BOMREVREF Longint 4 69 Ürün Reçetesi Revizyonu Referansı BOMREVSN LOGICALREF
LINETYPE Byte 1 73 Satır Tipi Line Type
DETLINE Byte 1 74 Detay Satırı Detail Line
PREVLINEREF Longint 4 75 Talep Tespiti Log. Ref. DEMANDPEGGING LOGICALREF
PREVLINENO Integer 2 79 Üst Malzeme Sınıfı Satır Numarası Parent Material Class Line Number
LINENO_ Integer 2 81 Satır Numarası Line Number
SITEID Integer 2 83 Veri Merkezi Data Processing Site
RECSTATUS Integer 2 85 Kayıt Durumu Record Status
ORGLOGICREF Longint 4 87 Orijinal Kayıt Log. Ref. Original Record Logical Reference
PAYPLANREF Longint 4 91 Ödeme Planları Payment Plans
PRICE Double 8 95 Fiyat Price
PROJECTREF Longint 4 103 Proje Referansı PROJECT Reference

İlişkiler – Relations

Level Product ID Resource ID Special Code Source Field Destination Table Destination Field Relation Type Extra Condition
0 0 930   DEMANDLINEREF L_DEMANDLINE LOGICALREF one-to-one  
0 0 930   DEMANDFICHEREF L_DEMANDFICHE LOGICALREF one-to-one  
0 0 930   PARENTREF L_MRPHEAD LOGICALREF one-to-one  
0 0 930   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 PARENTTYPE Ascending
0 0 Index2 Duplicate + Not Null 2 PARENTREF Ascending
0 0 Index3 Duplicate + Not Null 1 CHILDTYPE Ascending
0 0 Index3 Duplicate + Not Null 2 CHILDREF Ascending
0 0 Index4 Duplicate + Not Null 1 DEMANDLINEREF Ascending
0 0 Index4 Duplicate + Not Null 2 CHILDTYPE Ascending
0 0 Index5 Duplicate + Not Null 1 LINETYPE Ascending
0 0 Index5 Duplicate + Not Null 2 DEMANDFICHEREF Ascending

>