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