LG_STDUNITCOST

Alanlar ve Açıklamaları

Field Name Field Type Field Size Field Offset Türkçe Açıklama Expression
LOGICALREF Longint 4 0 Standart birim maliyeti log. Ref. Standart Unit Cost Logical Reference
CARDTYPE Byte 1 4 Kart Türü Card Type
CARDREF Longint 4 5 Kart Referansı Card Reference
PERIODREF Longint 4 9 Periyot ref. Period Reference
FACTORYNR Integer 2 13 Fabrika Numarası Plant Number
UNITCOST Double 8 15 Birim maliyeti Unit Cost
REPUNITCOST Double 8 23 RD birim maliyeti Reporting Currency Unit Cost
TRUNITCOST Double 8 31 İD birim maliyeti Transaction Currency Unit Cost
TRCURR Byte 1 39 İD Türü Transaction Currency Type
TRRATE Double 8 40 İşlem dövizi kuru Transaction Currency Exchange Rate
REPORTRATE Double 8 48 RD Kuru Reporting Currency Exchange Rate
LINENO_ Longint 4 56 Satır Numarası Line Number
SITEID Integer 2 60 Veri Merkezi Data Processing Site
RECSTATUS Integer 2 62 Kayıt Durumu Record Status
ORGLOGICREF Longint 4 64 Orijinal Kayıt Log. Ref. Original Record Logical Reference

İlişkiler – Relations

Level Product ID Resource ID Special Code Source Field Destination Table Destination Field Relation Type Extra Condition
1 0 883   CARDREF L_ITEMS LOGICALREF one-to-one CARDTYPE = 1
1 0 883   CARDREF L_WORKSTAT LOGICALREF one-to-one CARDTYPE = 2
1 0 883   CARDREF L_EMPLOYEE LOGICALREF one-to-one CARDTYPE = 3
1 0 883   PERIODREF L_STDCOSTPERIOD 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 Unique + Not Null 1 CARDTYPE Ascending
1 0 Index2 Unique + Not Null 2 CARDREF Ascending
1 0 Index2 Unique + Not Null 3 PERIODREF Ascending
1 0 Index2 Unique + Not Null 4 FACTORYNR Ascending
1 0 Index3 Duplicate + Not Null 1 PERIODREF Ascending

>