| View Name: | MARIPurchaseProcessPositions |
| Based on table: | MPEKVertraegePositionen |
| Group: | Group: MPEKVertraege |
| Description: | Purchase Process: PO Process Position (equivilant to contract position) |
| ClassID: | 147. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ContractPositionID | Vertragsposition INT Primary |
MARIPurchaseProcessPositions.ContractPositionID | |
| ContractID | VertragsID INT Index |
MARIPurchaseProcess.ContractID | |
| ParentID | ParentID INT Index |
||
| SalesContractPosition | VKPosIndex INT Index |
||
| PositionID | Position SMALLINT Index |
||
| Indent | Indent INT |
||
| Position | PositionText NVARCHAR (50) |
||
| PositionType | PosTyp SMALLINT |
clsImportProjectContractPosition_eContractPositionType | |
| ServiceNumber | Leistungsnummer NVARCHAR (20) Index |
MARIServices.ServiceNumber | |
| ItemCode | Artikel NVARCHAR (50) |
OITM.ItemCode | |
| Company | Mandant SMALLINT |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| TravelCategory | ReisekostenArt NVARCHAR (20) |
MARITravelExpenseTypes.TravelCategory | |
| EquipmentCategory | EquipmentCategory INT |
MARIEquipmentCategory.EquipmentCategory | |
| EquipmentSubject | EquipmentSubject NVARCHAR (20) |
MARIEquipmentCategorySubject.EquipmentSubject | |
| EquipmentParentPos | EquipmentParentPos INT |
||
| WorkpackageNumber | ArbeitspaketNumber NVARCHAR (20) |
MARIWorkPackage.WorkpackageNumber | |
| Description1 | Bezeichnung1 NVARCHAR (200) |
||
| Description2 | Bezeichnung2 NVARCHAR (200) |
||
| Matchcode | Matchcode NVARCHAR (200) Index |
||
| Quantity | Menge NUMERIC(19,6) |
Quantity=BaseQty*ParentQty | |
| MaximumQuantity | MengeMax NUMERIC(19,6) |
||
| MaxQuantityType | MengeMaxTyp TINYINT |
||
| DefaultQuantity | MengeVorgabe NUMERIC(19,6) |
||
| QuantityType | MengenTyp INT |
||
| QuantityOption | MengenOptionen SMALLINT (0=false,-1=true) |
||
| BaseQuantity | BasisMenge NUMERIC(19,6) |
Quantity per contract | |
| QuantityCount | MengeAnzahl NUMERIC(19,6) |
Quantity of equipment for rental | |
| QuantityCountText | MengeAnzahlText NVARCHAR (100) |
||
| QuantityFormularID | MengenFormelID INT Index |
MARISetupQuantityFormular.QuantityFormularID | |
| BasisAnzahl | BasisAnzahl NUMERIC(19,6) |
||
| SummaryMode | ZusammenfassungMode INT |
||
| RoundingMethodID | RundungsMethode INT |
MARIContractRoundingDefinition.RoundingMethodID (WHERE ClassID=103) | |
| CalculationMethod | CalculationMethod INT Index |
MARIContractCalculation.CalculationMethod | |
| NetUnitPriceFC | Einzelpreis NUMERIC(19,6) |
||
| UnitPriceFC | EinzelPreisFW NUMERIC(19,6) |
||
| PriceType | PreisTyp SMALLINT |
||
| PriceOption | PreisOptionen SMALLINT (0=false,-1=true) |
||
| UnitPriceDocument | EinzelpreisBeleg NUMERIC(19,6) |
||
| DiscountPercent | Rabatt NUMERIC(19,6) |
||
| POUnitPrice | EKEinzelpreis NUMERIC(19,6) |
||
| POPriceType | EKPreisTyp SMALLINT |
||
| POUnitPriceFC | EKEinzelpreisFW NUMERIC(19,6) |
||
| POPriceCurrency | EKPreisWKZ NVARCHAR (3) |
||
| POPriceExchangeRate | EKPreisKurs Float |
||
| POPriceExchangeHandling | EKPreisKursHandling INT |
||
| POPriceOption | EKPreisOptionen SMALLINT |
||
| POMode | EKModus INT |
||
| POPriceSurplus | EKPreisAufschlag NUMERIC(19,6) |
||
| CostMarginImputed | KostenAufschlagKalkulatorisch Float |
||
| SalesMarginImputed | VerkaufsAufschlagKalkulatorisch Float |
||
| StandardAccountingType | Abrechnungstyp INT |
||
| AccountingDate | AbrechnungTag SMALLINT |
||
| Vendor | Lieferant NVARCHAR (20) |
OCRD.CardCode | |
| PurchaseType | Lieferart SMALLINT |
||
| IssueMethod | AusgabeMethode INT |
||
| DeliveryDate | Lieferdatum Datetime |
||
| LeadTime | Lieferzeit INT |
||
| RentalStartDate | MietStartDatum Datetime |
||
| Warehouse | Lagerort NVARCHAR (10) |
OWHS.WhsCode | |
| SourceWarehouse | QuellLagerOrt NVARCHAR (10) |
OWHS.WhsCode | |
| LinkedPositionType | VorPosID INT Index |
||
| ExternalNumber | Fremdnummer NVARCHAR (40) |
||
| DegreeOfCompletion | Fertigstellungsgrad Single |
||
| UsesDegreeOfCompleation | HatFertigstellungsgrad SMALLINT (0=false,-1=true) |
||
| TimeSurcharges | Zuschlaege NVARCHAR (255) |
||
| AccountingInfo | Langtext NTEXT |
||
| PositionInfo | Dimensionstext NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| EntitledDiscount | Rabattfaehig SMALLINT (0=false,-1=true) |
||
| UoM | Mengeneinheit NVARCHAR (20) |
||
| BPCatalogNumber | BPCatalogNumber NVARCHAR (50) |
||
| ActiveType | AktivTyp SMALLINT |
||
| DocumentHandling | BelegHandling INT |
||
| HasExternalNumber | HatFremdnummer SMALLINT (0=false,-1=true) |
||
| IndexTreatment | IndexBehandlung SMALLINT |
||
| HasNumber | HatNummer SMALLINT (0=false,-1=true) |
||
| NumberRangeFrom | NummernKreisVon INT |
||
| NumberRangeTo | NummernKreisBis INT |
||
| OrderFlag | SortierKZ SMALLINT |
||
| RevenueReturnAccountDefinition | ERDefinition INT |
||
| BaseContractPosition | GVPosID INT Index |
||
| BalanceOrdered | GGMengeBestellt NUMERIC(19,6) |
||
| BalanceDelivered | GGMengeGeliefert NUMERIC(19,6) |
||
| BalanceInvoiced | GGMengeRechnung NUMERIC(19,6) |
||
| BalanceLastDocReference | GGDocReference INT |
||
| TaxCode | Steuercode NVARCHAR (10) |
||
| TaxRate | Steuersatz NUMERIC(19,6) |
||
| TaxClass | Steuerklasse SMALLINT |
||
| TaxManual | SteuerManuell SMALLINT (0=false,-1=true) |
||
| GLAccountManual | SachkontoManuell SMALLINT (0=false,-1=true) |
||
| GLAccount | Sachkonto NVARCHAR (20) |
OACT.AcctCode | |
| 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) | |
| TaxWtLiable | TaxWtLiable SMALLINT (0=false,-1=true) |
||
| TaxUsage | TaxUsage INT |
||
| TaxCSTcode | TaxCSTcode NVARCHAR (4) |
||
| TaxCFOPcode | TaxCFOPcode NVARCHAR (6) |
||
| LocationID | LocationID INT Index |
||
| ProductID | ProduktID INT Index |
MARISupportProduct.ProductID | |
| CostHandling | Kostenbehandlung INT |
||
| CostPercentage | KostenProzent NUMERIC(19,6) |
||
| CostReduction | KostenAbschlag NUMERIC(19,6) |
||
| PayrollType | Lohnart NVARCHAR (20) |
MARIPayrollTypes.PayrollType | |
| MaintenanceType | WartungsTyp INT |
||
| RecurrentAccounting | WartungsPeriodik INT |
clsImportProjectContractPosition_eMaintenancePeriodic | |
| MaintenancePercent | WartungsSatz NUMERIC(19,6) |
||
| MaintenanceBasicPrice | WartungBasisPreis NUMERIC(19,6) |
||
| MaintenanceReference | WartungsReferenz INT |
||
| ServiceStartDate | WartungStart Datetime |
||
| ServiceEndDate | WartungEnde Datetime |
||
| ServiceDueDateType | WartungsStichtagsTyp SMALLINT |
||
| ServiceDueDateOffset | WartungsStichtagsOffset SMALLINT |
||
| ServiceContractEnd | WartungsVertragsEnde Datetime |
||
| QualityProcess | QualityProcess INT |
MARIQualityProcess.QualityProcess | |
| QualityProcessSales | QualityProcessVK INT |
MARIQualityProcess.QualityProcessSales | |
| QualityStatus | QualityStatus INT |
||
| Alternative | AlternativPosition SMALLINT (0=false,-1=true) |
||
| DisplayInDocMode | AnzeigeImBelegFlagg INT |
||
| InvoiceHandling | AbrechnungsHandling INT |
||
| SubContractID | SubVertragsID INT Index |
Link to a sub contract | |
| SubContractPosition | SubVertragsPosition INT |
Link to a sub contract Posiiotn | |
| SourceSalesDocPosID | QuellVKBelPosID INT Index |
MARIContractDocumentPositions.SourceSalesDocPosID | |
| CommissionMode | ProvisionsMode INT |
||
| CommissionPercent | ProvisionsProzent NUMERIC(19,6) |
||
| ContractCommissionID | ContractCommissionID INT Index |
||
| AddOnCategory | AddOnCategory INT |
MARITimeBookingAddOnCategory.AddOnCategory | |
| WorkItemPosition | WorkItemPosition INT |
||
| ProRataID | ProRataID INT Index |
MARISysProRata.ProRataID (WHERE ProRataType=479) | |
| AccrualRuleID | AccrualRuleID INT Index |
MARISysProRata.AccrualRuleID (WHERE ProRataType=662) | |
| ERPResourceCode | ERPResourceCode NVARCHAR (50) Index |
ORSC.ResCode | |
| TravelTimeMode | ReiseZeitenMode INT |
||
| TravelTimeSalesFactor | ReiseZeitenErloeseFaktor NUMERIC(19,6) |
||
| Height1 | Height1 NUMERIC(19,6) |
||
| Hght1Unit | Hght1Unit SMALLINT |
||
| Width1 | Width1 NUMERIC(19,6) |
||
| Wdth1Unit | Wdth1Unit SMALLINT |
||
| Length1 | Length1 NUMERIC(19,6) |
||
| Len1Unit | Len1Unit SMALLINT |
||
| Volume | Volume NUMERIC(19,6) |
||
| VolUnit | VolUnit SMALLINT |
||
| Weight1 | Weight1 NUMERIC(19,6) |
||
| Wght1Unit | Wght1Unit SMALLINT |
||
| CustomerDocumentMode | KundenDokumente SMALLINT (0=false,-1=true) |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| CreateDate | Erstanlage Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIPurchaseImportDocumentPos2POProcessPos | Purchase Order: Import external documents (Link to PO Process lines) |
| MARIPurchaseProcessPositions | Purchase Process: PO Process Position (equivilant to contract position) |
| MARIPurchaseProcessPositionDefinition | Purchase Process: Definition of extra fields by position type |
| MARIPurchaseProcessPositionEmployees | Purchase Process: Employees linked to a position |
| MARIPurchaseProcessPositionPhases | Purchase Process: Phases linked to a position |
| MARIPurchaseProcessPositionTextelements | Purchase Process: Text definition (master data) for positions |
| MARIPurchaseProcessPaymentPlan | Purchase Process: Payment plan (not used in PO) |
| MARIProjectItemBooking | Time Keeping: ProjectTimeKeepingItems: For items used in a project each entry is stored in this table. This table is also linked to the header: MPProjectBuchungskopf |
| MARIProjectTimeKeepingLinesServices | Time Keeping: ProjectTimeKeepingLinesServices: additional lines for the MPProjectBuchungserfassung for the project types: customer project and internal project with contract. This table stores the link to the contract and contract position |
| MARIProjectPlanningLines | Planning: Master Planning lines |
| MARIContractPosition2POPosition | Contract Management: Contract position to PO position link |
| MARIPurchaseProcessPositionEquipment | Purchase Process: Equipment linked to a position |
| MARIEquipmentDetails | Equipment: Master Data "date from" based |
| MARIEquipmentSubjectBooking | Time/Costbooking on Equipment data |
| MARIDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MARIPurchaseProcessPos2Service | Purchase Process: Link Position to Customer Service Object or parts |
| MARIProjectPlanningLinesLog | Planning: Master Planning lines History |
| MARIProjectWorkPackageEntry | Work Packages progress reporting by day |
| MARIPurchaseProcessDocumentCommisionPos | Purchase Process: Purchase Document Bonus position definition |
| MARIContainer | Definition of a container carrying other goods |