MARIContractDocument

View Name:	MARIContractDocument
Based on table:	MPVKVertraegeBelege
Group:	Group: ContractDocument
Description:	Contract Management: Sales Documents
ClassID:	66. See Overview of ClassIDs by table.

Field	Table(Germ.field)/Type	Description	Related
MARIDocID	MPBelID INT Primary
MARIDocType	MPBelegart INT Index		clsImportSalesContractDocument_eDocTypes
MARIDocTypeDetail	MPBelegartDetail INT
ContractID	MPVertragsID INT Index		MARIContract.ContractID
MARIPeriod	MPPeriode INT		MARIPeriods.MARIPeriod
OptionMemo	MPOptionMemo NTEXT
DocCreationDate	MPUebergabeDatum Datetime
DocCreationUser	MPUebergabeID NVARCHAR (4) Index	Field was named wrongly PostingDate	MARIUser.DocCreationUser (WHERE BenutzerTyp=1)
WithEffect	MPMitWirkung SMALLINT
PrintLabel	MPDruckkennzeichen INT
MARIDueDate	MPValutadatum Datetime
MARICollectionDocumentID	MPSammelBelID INT Index
DocEntry	BelID INT Index	OINV.DocEntry	OINV.DocEntry
Company	Mandant SMALLINT		MARISysConnections.Company (WHERE ConnectionType=6)
DocumentTypeID	Belegkennzeichen INT
DocumentTypeText	Belegart NVARCHAR (50)
DocumentYear	Belegjahr SMALLINT
DocumentNumber	Belegnummer INT Index	OINV.DocNum
MPDocumentStatus	MPBelegStatus INT
VisibleDocNum	VisibleDocNum NVARCHAR (20)
DocSeries	DocSeries INT	NNM1.Series
DocNumSegment	DocNumSegment INT	OINV.Secment Visible Doc Num	OINV.Secment
DocSeriesString	DocSeriesString NVARCHAR (3)	OINV.SeriesStr
DocSeriesSubString	DocSeriesSubString NVARCHAR (3)	OINV.SubStr
SequenceCode	SequenceCode INT	OINV.SeqCode->NFN1.SeqCode
SequenceSerial	SequenceSerial INT	OINV.Serial Brazil
SequenceModel	SequenceModel NVARCHAR (10)	OINV.Model Brazil	OINV.Model
DeferredTax	DeferrTax SMALLINT (0=false,-1=true)	OINF.DeferrTax	OINV.DeferrTax
ShipToCode	ShipToCode NVARCHAR (50)	V5.4 India Localization
GSTTranTyp	GSTTranTyp NVARCHAR (2)	V5.4 India Localization
BPLId	BPLId INT		OINF.BPLId
PTICode	PTICode NVARCHAR (5)	Localization Argentina	OPOR.PTICode
Letter	Letter NVARCHAR (1)	Localization Argentina	OPOR.Letter
FolNumFrom	FolNumFrom INT	Localization Argentina	OPOR.FolNumFrom
FolNumTo	FolNumTo INT	Localization Argentina	OPOR.FolNumTo
FolSeries	FolSeries INT	Localization Argentina	OPOR.FolSeries
Indicator	Indicator NVARCHAR (2)	Localization Argentina SELECT * FROM OIDC	OPOR.Indicator
ImportEnt	ImportEnt INT	Localization Argentina	OPOR.ImportEnt
INV12State	INV12State NVARCHAR (3)
INV12County	INV12County NVARCHAR (7)
FiscDocNum	FiscDocNum NVARCHAR (100)	Localization Poland	OPOR.FiscDocNum
VatFirst	VatFirst SMALLINT (0=false,-1=true)
JournalRemark	Buchungstext NVARCHAR (254)
ERPPeriod	Periode INT
Prospect	Interessent SMALLINT
A0AddressNr	A0AdressNr INT
A0CardCode	A0Empfaenger NVARCHAR (20)		OCRD.CardCode
A0Salutation	A0Anrede NVARCHAR (50)
A0Name1	A0Name1 NVARCHAR (100)
A0Name2	A0Name2 NVARCHAR (50)
A0Name3	A0Zusatz NVARCHAR (50)
A0SingleCustomer	A0Einmalkunde SMALLINT
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
A0EMailContactPerson	A0EMailAnsprechpartner INT
A1EMailContactPerson	A1EMailAnsprechpartner INT
FatherCard	FatherCard NVARCHAR (20)
FatherType	FatherType NVARCHAR (1)
CustomerGroup	Kundengruppe NVARCHAR (10)
PriceType	Preiskennzeichen SMALLINT
InvoiceCustomerCode	Rechnungsempfaenger NVARCHAR (20)
DeliveryWeek	Lieferwoche INT
DeliveryDate	Liefertermin Datetime	Delivery type doc=Date of delivery; invoice type documents=DueDate
RentalStartDate	MietStartDatum Datetime
SourceWareHouse	QuellLager NVARCHAR (8)		OWHS.WhsCode
SourceBinLocations	QuellLagerPlaetze NTEXT
CurrencySys	CurrencySys NVARCHAR (3)
CurrencyLoc	CurrencyLoc NVARCHAR (3)
CurrencyFC	WKz NVARCHAR (3)	ISO Currency Code
CurrencyRateSys2Loc	CurrencyRateSys2Loc Float
CurrencyRateLoc2Fc	CurrencyRateLoc2Fc Float
ExchangeRateFC2Sys	WKzKursFw Float
ExchangeRateSource	CurrencyRateSource INT
ExchangeRateDate	CurrencyRateDate Datetime
ExchangeRateHandling	WkzKursHandling INT
Incoterm	Incoterm NVARCHAR (4)
Revision	Revision NVARCHAR (20)
DocDate	Belegdatum Datetime
TaxDate	Steuerdatum Datetime
ServiceStartDate	LeistungszeitraumVon Datetime
ServiceEndDate	LeistungszeitraumBis Datetime
ServiceRangeTemplate	LeistungsZeitraumVorlage INT	Enum
SalesEmployee	VertriebsMitarbeiter NVARCHAR (128)		OSLP.SlpCode
HandledBy	Bearbeiter NVARCHAR (128)		OUSR.USER_Code
DiscountPercent	Rabatt1 NUMERIC(19,6)
DiscountValueSys	DiscountValueSys NUMERIC(19,6)
DiscountValueLoc	DiscountValueLoc NUMERIC(19,6)
DiscountValueFC	Rabattbetrag1 NUMERIC(19,6)
DiscountBaseSys	DiscountBaseSys NUMERIC(19,6)
DiscountBaseLoc	DiscountBaseLoc NUMERIC(19,6)
DiscountBaseFC	Rabattbasis1 NUMERIC(19,6)
PaymentBlock	PaymentBlock SMALLINT (0=false,-1=true)
PaymentBlockRef	PaymentBlockRef INT
ClosingDate	ClosingDate Datetime	Localisation Japan
Header	Kopftext NTEXT
Footer	Fusstext NTEXT
OcrCode1	Kostenstelle 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)
ProjectCode	Kostentraeger NVARCHAR (20)		OPRJ.PrjCode
LanguageCode	Sprache NVARCHAR (10)
LanguageID	SprachID INT
ReferenceDocumentID	ReferenzBelID INT Index
ReferenceNumber	Referenznummer NVARCHAR (100)
ReferenceSign	Referenzzeichen NVARCHAR (100)
NetValueSys	NetValueSys NUMERIC(19,6)
NetValueLoc	NetValueLoc NUMERIC(19,6)
NetValueFC	Nettobetrag NUMERIC(19,6)
TaxValueSys	TaxValueSys NUMERIC(19,6)
TaxValueLoc	TaxValueLoc NUMERIC(19,6)
TaxValueFC	Steuerbetrag NUMERIC(19,6)
TotalValueSys	TotalValueSys NUMERIC(19,6)
TotalValueLoc	TotalValueLoc NUMERIC(19,6)
TotalValueFc	Bruttobetrag NUMERIC(19,6)
TaxModeCode	Besteuerung SMALLINT
EUCountry	EULand NVARCHAR (2)
EUVATID	EUUStID NVARCHAR (32)
ERPLinkID	ERPVerweisID INT
ERPDocPosID	ERPVerweisZeile INT
ERPLinkType	ERPVerweisTyp INT
PurchaseSalesRefMARIDocID	VKEKInternRefMPBelID INT Index
PaymentRef	PaymentRef NVARCHAR (27)
Memo	Memo NTEXT
WorkflowStatus	WorflowStatus INT
ApprovalMode	Freigabe SMALLINT Index
ApprovedDate	FreigegebenAm Datetime
ApprovedUser	FreigegebenID NVARCHAR (4)		MARIUser.ApprovedUser (WHERE BenutzerTyp=1)
ApprovalText	Freigabetext NTEXT
JounralEntry	JournalBuchung INT
JournalEntryCancel	JournalStornoBuchung INT
DocumentCreator	BelegErsteller NVARCHAR (20)
RevisionReferenceDocumentID	RevisionsVorgaengerBelID INT Index
ShipmentType	ShipmentType INT
CIG_Code	CIG_Code INT
CUP_Code	CUP_Code INT Index
EInvoiceMode	EInvoiceMode INT
ContainerID	GebindeID INT Index		MARIContainer.ContainerID
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

MARIProject Database Structure