MARIPurchaseProcess

View Name:	MARIPurchaseProcess
Based on table:	MPEKVertraege
Group:	Group: MPEKVertraege
Description:	Purchase Process: Header
ClassID:	103. See Overview of ClassIDs by table.

Field	Table(Germ.field)/Type	Description	Related
ContractID	VertragsID INT Primary	Unique ID (invisible)	MARIPurchaseProcess.ContractID
POProcessNo	Vertragsnummer NVARCHAR (20) Unique	Unique Number visible	MARIPurchaseProcess.POProcessNo
PurchaseProcessType	Vertragsart SMALLINT Index	Contract or Purchase process type	clsImportProjectContract_eContractTypes
StandardAccountingType	Abrechnungstyp INT		clsImportProjectContract_eAccountingType
ProjectNumber	Projektnummer NVARCHAR (20) Index		MARIProjectMaster.ProjectNumber
VolumeHandling	Volumenbehandlung SMALLINT		clsImportProjectContract_eVolumeHandling
AutoPlanningMode	Planungsbehandlung SMALLINT
PlanningVersion	Planungsversion INT	Link to a planning version for archive	MARIProjectPlanningVersions.PlanningVersion
BaseContract	Basisvertrag INT	Linked contract (only sales side)	MARIPurchaseProcess.BaseContract
PurchaseProcessGroup1	Vertragsgruppe INT		MARIGroups.PurchaseProcessGroup1 (WHERE Gruppenart=10016) clsImportGroups_eGroupType
PurchaseProcessGroup2	Vertragsgruppe2 INT		MARIGroups.PurchaseProcessGroup2 (WHERE Gruppenart=10017) clsImportGroups_eGroupType
PurchaseProcessGroup3	Vertragsgruppe3 INT		MARIGroups.PurchaseProcessGroup3 (WHERE Gruppenart=10018) clsImportGroups_eGroupType
Supplier	Lieferant NVARCHAR (20)		OCRD.CardCode
Company	Mandant SMALLINT		MARISysConnections.Company (WHERE ConnectionType=6)
BaseContractID	VorID INT
PurchaseProcessName	Bezeichnung NVARCHAR (100) Index
PurchaseProcessDate	Vertragsdatum Datetime
ReferenceNumber	Referenznummer NVARCHAR (100)
ReferenceSign	Referenzzeichen NVARCHAR (100)
SalesVolume	VKVolumen NUMERIC(19,6)
SalesVolumeFC	VKVolumenFW NUMERIC(19,6)
SalesVolumeLoc	VKVolumenLoc NUMERIC(19,6)
SalesVolumeService	VKVolumenLeistung NUMERIC(19,6)
SalesVolumeServiceFC	VKVolumenLeistungFW NUMERIC(19,6)
SalesVolumeServiceLoc	VKVolumenLeistungLoc NUMERIC(19,6)
SalesVolumeItem	VKVolumenArtikel NUMERIC(19,6)
SalesVolumeItemFC	VKVolumenArtikelFW NUMERIC(19,6)
SalesVolumeItemLoc	VKVolumenArtikelLoc NUMERIC(19,6)
SalesVolumeTravelExpenses	VKVolumenRK NUMERIC(19,6)
SalesVolumeTravelExpensesFC	VKVolumenRKFW NUMERIC(19,6)
SalesVolumeTravelExpensesLoc	VKVolumenRKLoc NUMERIC(19,6)
SalesVolumeEquipment	VKVolumenEquipment NUMERIC(19,6)
SalesVolumeEquipmentFC	VKVolumenEquipmentFW NUMERIC(19,6)
SalesVolumeEquipmentLoc	VKVolumenEquipmentLoc NUMERIC(19,6)
SalesVolumeExternalService	VKVolumenFremdLeistung NUMERIC(19,6)
SalesVolumeExternalServiceFC	VKVolumenFremdLeistungFW NUMERIC(19,6)
SalesVolumeExternalServiceLoc	VKVolumenFremdLeistungLoc NUMERIC(19,6)
ContractHandlingPercentage	ContractHandlingPercentage NUMERIC(19,6)
Completed	Erfuellt SMALLINT (0=false,-1=true)	Completed
OrderProbability	AuftragsWahrscheinlichkeit Single
Status	Status INT	Status value
Currency	Wkz NVARCHAR (3)	ISO Currency Code
ExchangeRate	WkzKurs Float
ExchangeRateHandling	WkzKursHandling INT
CurrencyLoc	WKZLoc NVARCHAR (3)
CurrencyRateSys2Loc	WKZKursSys2Loc Float	Rate between (MARI)Sys and foreign currency
CurrencyRateLoc2Fc	WKZKursLoc2FW Float	Rate between company local and foreign currency
ValidFrom	GueltigAb INT		MARIPeriods.ValidFrom
ValidTo	GueltigBis INT		MARIPeriods.ValidTo
ContractMemo	VertragsMemo NTEXT
ContractMemoLevel	VertragsMemoLevel SMALLINT
SalesEmployee	VertriebsMitarbeiter NVARCHAR (128)		OSLP.SlpCode
HandledBy	Bearbeiter NVARCHAR (128)		OUSR.USER_Code
LanguageKey	Sprache NVARCHAR (10)
LanguageID	SprachID INT
PaymentCondition	ZKD NVARCHAR (50)
PriceListSales	PreislisteVK INT
PriceListSalesCurrCode	PreislisteVKWKZ NVARCHAR (3)
PriceListPurchase	PreislisteEK INT
PriceListPurchaseCurrCode	PreislisteEKWKZ NVARCHAR (3)
PlanningDueDate	PlanungsStichtag Datetime
PlanningTeamSize	PlanungsTeamGroesse NUMERIC(19,6)
DiscountPercent	Rabatt1 NUMERIC(19,6)
DiscountPercent2	Rabatt2 NUMERIC(19,6)
DiscountPercent3	Rabatt3 NUMERIC(19,6)
Prospect	Interessent SMALLINT
A0Salutation	A0Anrede NVARCHAR (50)
A0Name1	A0Name1 NVARCHAR (100)
A0Name2	A0Name2 NVARCHAR (50)
A0Name3	A0Zusatz NVARCHAR (50)
A0Matchcode	A0Matchcode NVARCHAR (100)
A0Street	A0Strasse NVARCHAR (100)
A0StreetNumber	A0Hausnummer NVARCHAR (100)
A0Country	A0Land NVARCHAR (3)
A0ZIP	A0PLZ NVARCHAR (20)
A0City	A0Ort NVARCHAR (100)
A0County	A0Bezirk NVARCHAR (100)
A0State	A0Bundesland NVARCHAR (3)
A0Block	A0Gebaeude NVARCHAR (100)
A0ContactPerson	A0AnsprechpartnerID INT		OCPR.CntctCode
A0AddressName1	A0AdressName NVARCHAR (50)
A0AddressName2	A0AdressName2 NVARCHAR (50)
A0AddressName3	A0AdressName3 NVARCHAR (50)
A0Building	A0GebaeudeStockwerk NTEXT
A0AddressMemo	A0AdressMemo NTEXT
A0CardFName	A0CardFName NVARCHAR (100)
A0AddrType	A0AddrType NVARCHAR (100)
A0AddressLineNum	A0AdressLineNum INT
A0GlbLocNum	A0GlbLocNum NVARCHAR (50)
A0Longitude	A0Longitude Float
A0Latitude	A0Latitude Float
A1BusinessPartner	A1BusinessPartner NVARCHAR (20)		OCRD.CardCode
A1Salutation	A1Anrede NVARCHAR (50)
A1Name1	A1Name1 NVARCHAR (100)
A1Name2	A1Name2 NVARCHAR (50)
A1Name3	A1Zusatz NVARCHAR (50)
A1Matchcode	A1Matchcode NVARCHAR (100)
A1Street	A1Strasse NVARCHAR (100)
A1StreetNum	A1Hausnummer NVARCHAR (100)
A1Country	A1Land NVARCHAR (3)
A1ZIP	A1PLZ NVARCHAR (20)
A1City	A1Ort NVARCHAR (100)
A1County	A1Bezirk NVARCHAR (100)
A1State	A1Bundesland NVARCHAR (3)
A1Block	A1Gebaeude NVARCHAR (100)
A1ContactPerson	A1AnsprechpartnerID INT		OCPR.CntctCode
A1AddressName1	A1AdressName NVARCHAR (50)
A1AddressName2	A1AdressName2 NVARCHAR (50)
A1AddressName3	A1AdressName3 NVARCHAR (50)
A1Building	A1GebaeudeStockwerk NTEXT
A1AddressMemo	A1AdressMemo NTEXT
A1CardFName	A1CardFName NVARCHAR (100)
A1AddrType	A1AddrType NVARCHAR (100)
A1AddressLineNum	A1AdressLineNum INT
A1GlbLocNum	A1GlbLocNum NVARCHAR (50)
A1Longitude	A1Longitude Float
A1Latitude	A1Latitude Float
A2BusinessPartner	A2BusinessPartner NVARCHAR (20)	Pay To Address	OCRD.CardCode
A2Salutation	A2Anrede NVARCHAR (50)
A2Name1	A2Name1 NVARCHAR (100)
A2Name2	A2Name2 NVARCHAR (50)
A2Line3	A2Zusatz NVARCHAR (50)
A2Matchcode	A2Matchcode NVARCHAR (100)
A2Street	A2Strasse NVARCHAR (100)
A2StreetNum	A2Hausnummer NVARCHAR (100)
A2Country	A2Land NVARCHAR (3)
A2ZIP	A2PLZ NVARCHAR (20)
A2City	A2Ort NVARCHAR (100)
A2County	A2Bezirk NVARCHAR (100)
A2State	A2Bundesland NVARCHAR (3)
A2Block	A2Gebaeude NVARCHAR (100)
A2ContactPerson	A2AnsprechpartnerID INT		OCPR.CntctCode
A2AddressName1	A2AdressName NVARCHAR (50)
A2AddressName2	A2AdressName2 NVARCHAR (50)
A2AddressName3	A2AdressName3 NVARCHAR (50)
A2Building	A2GebaeudeStockwerk NTEXT
A2AddressMemo	A2AdressMemo NTEXT
A2CardFName	A2CardFName NVARCHAR (100)
A2AddrType	A2AddrType NVARCHAR (100)
A2AddressLineNum	A2AdressLineNum INT
A2FatherType	A2FatherType NVARCHAR (1)
A2GlbLocNum	A2GlbLocNum NVARCHAR (50)
A2Longitude	A2Longitude Float
A2Latitude	A2Latitude Float
A0EMailContactPerson	A0EMailAnsprechpartner INT
A1EMailContactPerson	A1EMailAnsprechpartner INT
A2EMailContactPerson	A2EMailAnsprechpartner INT
Header	Kopftext NTEXT
Footer	Fusstext NTEXT
PaymentConditionCount	ZahlungsKonditionenAnzahl INT
PaymentConditionB	Zahlungskond NVARCHAR (10)		OCTG.GroupNum
PaymentTerms	Inkassoart NVARCHAR (15)		OPYM.PayMethCod
PaymentNetConditions	Nettobedingung NVARCHAR (255)
CashDiscount1	Skontobedingung1 NVARCHAR (255)
CashDiscount2	Skontobedingung2 NVARCHAR (255)
CashDiscountPercent1	Skontoprozent1 NUMERIC(19,6)
CashDiscountPercent2	Skontoprozent2 NUMERIC(19,6)
PaymentRef	PaymentRef NVARCHAR (27)	Reference for BE/NL
Incoterm	Incoterm NVARCHAR (4)
DeferredTax	DeferrTax SMALLINT (0=false,-1=true)	OINF.DeferrTax	OINV.DeferrTax
ShipToCode	ShipToCode NVARCHAR (50)	V5.4 India Localization
AkquisitionProject	SammelProjekt NVARCHAR (20)		MARIProjectMaster.AkquisitionProject
AkquisitionPhase	SammelPhase INT		MARIProjectPhases.AkquisitionPhase
DocWorkflowID	DocWorkflow INT		MARISysDocWorkflow.DocWorkflowID
CommissionMode	ProvisionsMode INT	Select the bonus method	MARICommissionTypes.CommissionMode
StandardWarehouse	StandardLager NVARCHAR (8)		OWHS.WhsCode
ShipmentType	ShipmentType INT
StandardTaxCode	StandardSteuer NVARCHAR (8)
Assessment	BewertungsMode INT
ServiceRangeTemplate	LeistungsZeitraumVorlage INT	Enum
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)
ApprovalType	FreigabeTyp INT
Approver	Freigebender NVARCHAR (20) Index		MARIEmployeeMaster.Approver
ApprovalMode	Freigabe SMALLINT (0=false,-1=true) Index
ApprovedDate	FreigegebenAm Datetime
ApprovedUser	FreigegebenID NVARCHAR (4)		MARIUser.ApprovedUser (WHERE BenutzerTyp=1)
ApprovalText	Freigabetext NTEXT
CIG_Code	CIG_Code INT
CUP_Code	CUP_Code INT
Inactive	InAktiv SMALLINT (0=false,-1=true) Index	Hide dataset
CreateUser	ErstanlageID NVARCHAR (4)		MARIUser.CreateUser (WHERE BenutzerTyp=1)
CreateDate	Erstanlage Datetime
ChangeUser	AenderungID NVARCHAR (4)		MARIUser.ChangeUser (WHERE BenutzerTyp=1)
ChangeDate	Aenderung Datetime
HidePageFlag	HidePageFlag BIGINT
UpdateStamp	UpdateStamp INT

Table	Description
MARIPurchaseImportDocumentPos2POProcessPos	Purchase Order: Import external documents (Link to PO Process lines)
MARIPurchaseProcess	Purchase Process: Header
MARIPurchaseProcessDownPayments	Purchase Process: Down Payments
MARIPurchaseProcessDocument	Purchase Process: Purchase Document (Header)
MARIPurchaseProcessDocumentPrint	Purchase Process: Print history
MARIPurchaseProcessDocumentTax	Purchase Process: Purchase Document (Tax)
MARIPurchaseProcessPositions	Purchase Process: PO Process Position (equivilant to contract position)
MARIPurchaseProcessText	Purchase Process: Text definition (master data) for header, footer
MARIPurchaseProcessPaymentPlan	Purchase Process: Payment plan (not used in PO)
MARIProjectPlanningLines	Planning: Master Planning lines
MARIContractPosition2POPosition	Contract Management: Contract position to PO position link
MARIEquipmentDetails	Equipment: Master Data "date from" based
MARIEquipmentSubjectBooking	Time/Costbooking on Equipment data
MARIPurchaseProcessInstallments	Purchase Process: Installment Plan
MARIPurchaseProcessDocumentError	Purchase Process: Saved Errors
MARIDocumentDraftHeadLink	Linked contracts and purchase processes
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
MARIPurchaseProcessDocumentCommision	Purchase Process: Purchase Document Bonus definition
MARIPurchaseProcessDocumentCommisionPos	Purchase Process: Purchase Document Bonus position definition
MARIPurchaseProcessDocumentEInvoice	Purchase Process: Extra Information peparing an electronic document
MARIContainer	Definition of a container carrying other goods

MARIProject Database Structure