| Table Name: | MPArtikelGruppenKennzeichen |
| View Name: | MARIItemGroupProperties |
| Group: | |
| Description: | Item Groups: Additional fields for maintenance and purchase order |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ArtikelGruppe | ItemGroup INT Primary |
||
| Mandant | Company INT Primary |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| WartungsTyp | MaintenanceType INT |
||
| WartungsPeriodik | RecurrentAccounting INT |
clsImportProjectContractPosition_eMaintenancePeriodic | |
| WartungsSatz | MaintenancePercent NUMERIC(19,6) |
||
| WartungsArtikel | MaintenanceItem NVARCHAR (50) |
||
| WartungsStichtagsTyp | ServiceDueDateType SMALLINT |
||
| WartungsStichtagsOffset | MaintenanceDueDateOffset SMALLINT |
||
| KostenAufschlagKalkulatorisch | CostMarginImputed Float |
||
| VerkaufsAufschlagKalkulatorisch | SalesMarginImputed Float |
||
| EKQualityProcess | DefaultQualityProcessPurchasing INT |
MPQualityProcess.QualityProcess (WHERE ClassID=103) | |
| VKQualityProcess | DefaultQualityProcessSales INT |
MPQualityProcess.QualityProcess (WHERE ClassID=71) | |
| CalculationMethod | CalculationMethod INT |
MPContractCalculation.CalculationMethod | |
| KostenKorrekturLieferant | LandedCostMethod INT |
||
| TaxSetting1 | TaxSetting1 INT |
||
| TaxSetting2 | TaxSetting2 NVARCHAR (50) |
||
| TaxSetting3 | TaxSetting3 NVARCHAR (50) |
||
| ProvisionsMode | CommissionMode INT |
||
| ProvisionsProzent | CommissionPercent NUMERIC(19,6) |
||
| ProvisionsProzent2 | CommissionPercent2 NUMERIC(19,6) |
||
| PurchaseEmployee | PurchaseEmployee NVARCHAR (20) |
||
| PurchaseMode | PurchaseMode INT |
||
| 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 |
Default pro rata rule for a new sales contract position | MPSysProRata.ProRataID |
| ProRataIDPurchase | ProRataIDPurchase INT |
Default pro rata rule for a purchase process position | 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 |