LG_MRPPROPOSAL

Alanlar ve Açıklamaları

Field Name Field Type Field Size Field Offset Türkçe Açıklama Expression
LOGICALREF Longint 4 0 MRP Önerisi Log. Ref. MRP Proposal Logical Reference
PROPOSALTYPE Integer 2 4 Öneri türü ;0 Verilen sipariş;1 Üretim emri;2 Fason siparişi Proposal Type ;0 Purchase Order;1 Production Order;2 Subcontracting Order
PROPOSALDATE Longint 4 6 Öneri tarihi Proposal Date
ITEMREF Longint 4 10 Malzeme Kartı Referansı Item Card Reference
UNITREF Longint 4 14 Birim referansı Unit Reference
AMOUNT Double 8 18 Tutar Amount
CLREF Longint 4 26 Müşteri Ref. Client Reference
BOMREF Longint 4 30 Ürün Reçetesi Referansı Bill Of Material Reference
REVREF Longint 4 34 Ürün Reçetesi Revizyonu Referansı Bill Of Material Revision Reference
PEGGEDAMOUNT Double 8 38 Gerçekleşen miktar Realized Amount
PARENTPROPREF Longint 4 46 Ana Öneri ref. Parent Proposal Reference
SOURCETYPE Integer 2 50 Kaynak türü; 1 MPS; 2 MRP Source Type ;1 MPS;2 MRP
SOURCEREF Longint 4 52 Kaynak ref. Source Reference
MOVEDTODEMAND Byte 1 56 Talep Kısmına Move To Demand

İlişkiler – Relations

Level Product ID Resource ID Special Code Source Field Destination Table Destination Field Relation Type Extra Condition
1 0 803   CLREF L_CLCARD LOGICALREF one-to-one  
1 0 803   ITEMREF L_ITEMS LOGICALREF one-to-one  
1 0 803   UNITREF L_UNITSETL LOGICALREF one-to-one  
1 0 803   BOMREF L_BOMASTER LOGICALREF one-to-one  
1 0 803   REVREF L_BOMREVSN LOGICALREF one-to-one  
1 0 803   PARENTPROPREF L_MRPPROPOSAL LOGICALREF one-to-one  
1 0 803   SOURCEREF L_MRPHEAD 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 ITEMREF Ascending
1 0 Index2 Duplicate + Not Null 2 PROPOSALDATE Ascending

>