| View Name: | MARIItemProperties |
| Based on table: | MPArtikelKennzeichen |
| Group: | |
| Description: | Item Master: Additional fields for maintenance and purchase order |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ItemCode | Artikelnummer NVARCHAR (50) Primary |
OITM.ItemCode | |
| Company | Mandant INT Primary |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| MaintenanceType | WartungsTyp INT |
clsImportProjectContractPosition_eMaintenanceType | |
| RecurrentAccounting | WartungsPeriodik INT |
clsImportProjectContractPosition_eMaintenancePeriodic | |
| MaintenancePercent | WartungsSatz NUMERIC(19,6) |
||
| MaintenanceItem | WartungsArtikel NVARCHAR (50) |
OITM.ItemCode | |
| ServiceDueDateType | WartungsStichtagsTyp SMALLINT |
||
| ServiceDueDateOffset | WartungsStichtagsOffset SMALLINT |
||
| CostMarginImputed | KostenAufschlagKalkulatorisch Float |
||
| SalesMarginImputed | VerkaufsAufschlagKalkulatorisch Float |
||
| DefaultQualityProcessPurchase | EKQualityProcess INT |
MARIQualityProcess.DefaultQualityProcessPurchase (WHERE ClassID=71) | |
| DefaultQualityProcesSales | VKQualityProcess INT |
MARIQualityProcess.DefaultQualityProcesSales (WHERE ClassID=103) | |
| CalculationMethod | CalculationMethod INT |
MARIContractCalculation.CalculationMethod | |
| LandedCostMethod | KostenKorrekturLieferant INT |
||
| TaxSetting1 | TaxSetting1 INT |
||
| TaxSetting2 | TaxSetting2 NVARCHAR (50) |
||
| TaxSetting3 | TaxSetting3 NVARCHAR (50) |
||
| CommissionMode | ProvisionsMode INT |
clsImportProjectContractPosition_eCommisionMode | |
| CommissionPercent | ProvisionsProzent NUMERIC(19,6) |
0.5=50% | |
| CommissionPercent2 | ProvisionsProzent2 NUMERIC(19,6) |
0.5=50% | |
| ProductConfigurationID | ProductConfigurationID INT |
||
| CECGroupID | CECGroupID INT |
MARICustomerServiceObjectCategory.CECGroupID | |
| CreateDate | Erstanlage Datetime |
||
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (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 |
MARISysProRata.ProRataIDSales | |
| ProRataIDPurchase | ProRataIDPurchase INT |
MARISysProRata.ProRataIDPurchase | |
| AccrualRuleIDSales | AccrualRuleIDSales INT |
||
| AccrualRuleIDPurchase | AccrualRuleIDPurchase INT |
||
| PurchaseTypePurchasePos | EKLieferart INT |
Default PurchaseType for a purchase process position | |
| PurchaseTypeSalesPos | VKLieferart INT |
Default PurchaseType for a sales contract position | |
| ContainerCategory | GebindeKategorie INT |
MARIContainerCategory.ContainerCategory | |
| QuantityFormularID | MengenFormelID INT |
MARISetupQuantityFormular.QuantityFormularID | |
| UpdateStamp | UpdateStamp INT |