MARIContract

View Name:	MARIContract
Based on table:	MPVKVertraege
Group:	Group: Contract
Description:	Contract Management: Contract Master Data + Service Master Data
ClassID:	71. See Overview of ClassIDs by table.

Field	Table(Germ.field)/Type	Description	Related
ContractID	VertragsID INT Primary
ContractNumber	Vertragsnummer NVARCHAR (20) Index
ContractType	Vertragsart SMALLINT Index		clsImportProjectContract_eContractTypes
ProjectNumber	Projektnummer NVARCHAR (20) Index		MARIProjectMaster.ProjectNumber
StandardAccounting	Abrechnungstyp INT		clsImportProjectContract_eAccountingType
VolumeEffect	Volumenbehandlung SMALLINT		clsImportProjectContract_eVolumeHandling
AutoPlanningMode	Planungsbehandlung SMALLINT		clsImportProjectContract_eProjectHandling
PlanningVersion	Planungsversion INT		MARIProjectPlanningVersions.PlanningVersion
BaseContract	Basisvertrag INT		MARIContract.BaseContract
ContractGroup1	Vertragsgruppe INT		MARIGroups.ContractGroup1 (WHERE Gruppenart=10008) clsImportGroups_eGroupType
ContractGroup2	Vertragsgruppe2 INT		MARIGroups.ContractGroup2 (WHERE Gruppenart=10014) clsImportGroups_eGroupType
ContractGroup3	Vertragsgruppe3 INT		MARIGroups.ContractGroup3 (WHERE Gruppenart=10015) clsImportGroups_eGroupType
Customer	KHKKunde NVARCHAR (20)		OCRD.CardCode
Company	KHKMandant SMALLINT		MARISysConnections.Company (WHERE ConnectionType=6)
ProcessLink	KHKVorID INT
Description	Bezeichnung NVARCHAR (100) Index
ContractDate	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)
OrderProbability	AuftragsWahrscheinlichkeit Single
Status	Status INT
Currency	Wkz NVARCHAR (3)	ISO Currency Code of the contract
ExchangeRate	WkzKurs Float	exchange rate between (MARI)Sys and Foreign Currency
ExchangeRateHandling	WkzKursHandling INT	Fix by contract or by daily rate
CurrencyLoc	WKZLoc NVARCHAR (3)	local currency of the company
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)
SalesPriceList	PreislisteVK INT
SalesPriceListCurrencyCode	PreislisteVKWKZ NVARCHAR (3)
PurchasePriceList	PreislisteEK INT
PurchasePriceListCurrencyCode	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
A1AddressName	A1AdressName NVARCHAR (50)
A1AddressName2	A1AdressName2 NVARCHAR (50)
A1AddressName3	A1AdressName3 NVARCHAR (50)
A1Building	A1GebaeudeStockwerk NTEXT
A1AdressMemo	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)
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
PaymentNetCondition	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)
Incoterm	Incoterm NVARCHAR (4)
DeferredTax	DeferrTax SMALLINT (0=false,-1=true)		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
StandardWarehouse	StandardLager NVARCHAR (8)		OWHS.WhsCode
StandardTaxCode	StandardSteuer NVARCHAR (8)
ShipmentType	ShipmentType INT
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 Index
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

MARIProject Database Structure