| Table Name: | MPArtikelKennzeichen |
| View Name: | MARIItemProperties |
| Group: | |
| Description: | Item Master: Additional fields for maintenance and purchase order |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Artikelnummer | ItemCode NVARCHAR (50) Primary |
OITM.ItemCode | |
| Mandant | Company INT Primary |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| WartungsTyp | MaintenanceType INT |
clsImportProjectContractPosition_eMaintenanceType | |
| WartungsPeriodik | RecurrentAccounting INT |
clsImportProjectContractPosition_eMaintenancePeriodic | |
| WartungsSatz | MaintenancePercent NUMERIC(19,6) |
||
| WartungsArtikel | MaintenanceItem NVARCHAR (50) |
OITM.ItemCode | |
| WartungsStichtagsTyp | ServiceDueDateType SMALLINT |
||
| WartungsStichtagsOffset | ServiceDueDateOffset SMALLINT |
||
| KostenAufschlagKalkulatorisch | CostMarginImputed Float |
||
| VerkaufsAufschlagKalkulatorisch | SalesMarginImputed Float |
||
| EKQualityProcess | DefaultQualityProcessPurchase INT |
MPQualityProcess.QualityProcess (WHERE ClassID=71) | |
| VKQualityProcess | DefaultQualityProcesSales INT |
MPQualityProcess.QualityProcess (WHERE ClassID=103) | |
| CalculationMethod | CalculationMethod INT |
MPContractCalculation.CalculationMethod | |
| KostenKorrekturLieferant | LandedCostMethod INT |
||
| TaxSetting1 | TaxSetting1 INT |
||
| TaxSetting2 | TaxSetting2 NVARCHAR (50) |
||
| TaxSetting3 | TaxSetting3 NVARCHAR (50) |
||
| ProvisionsMode | CommissionMode INT |
clsImportProjectContractPosition_eCommisionMode | |
| ProvisionsProzent | CommissionPercent NUMERIC(19,6) |
0.5=50% | |
| ProvisionsProzent2 | CommissionPercent2 NUMERIC(19,6) |
0.5=50% | |
| ProductConfigurationID | ProductConfigurationID INT |
||
| CECGroupID | CECGroupID INT |
MPCustomerEquipmentCardCategory.CECGroupID | |
| Erstanlage | CreateDate Datetime |
||
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| OcrCode1 | OcrCode1 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=1) | |
| OcrCode2 | OcrCode2 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=2) | |
| OcrCode3 | OcrCode3 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=3) | |
| OcrCode4 | OcrCode4 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=4) | |
| OcrCode5 | OcrCode5 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=5) | |
| ProRataIDSales | ProRataIDSales INT |
MPSysProRata.ProRataID | |
| ProRataIDPurchase | ProRataIDPurchase INT |
MPSysProRata.ProRataID | |
| AccrualRuleIDSales | AccrualRuleIDSales INT |
||
| AccrualRuleIDPurchase | AccrualRuleIDPurchase INT |
||
| EKLieferart | PurchaseTypePurchasePos INT |
Default PurchaseType for a purchase process position | |
| VKLieferart | PurchaseTypeSalesPos INT |
Default PurchaseType for a sales contract position | |
| GebindeKategorie | ContainerCategory INT |
MPGebindeKategorie.GebindeKategorie | |
| MengenFormelID | QuantityFormularID INT |
MPSetupMengenFormel.MengenFormelID | |
| UpdateStamp | UpdateStamp INT |