MPDocumentDraftHead

Table Name:	MPDocumentDraftHead
View Name:	MARIDocumentDraftHead
Group:	Group: DocumentDraftHead
Description:	Header for the draft document
ClassID:	347. See Overview of ClassIDs by table.

Field	View(engl.field)/Type	Description	Related
DocumentDraftID	DocumentDraftID INT Primary
DocumentType	DocumentType INT		clsImportDraftDocument_eDraftDocumentType
DocumentViewMode	DocumentViewMode INT
DocumentTemplate	DocumentTemplate INT
DocumentCreationDate	DocumentCreationDate Datetime
DocumentDate	DocumentDate Datetime
DraftStatus	DraftStatus INT		clsImportDraftDocument_eDraftStatus
Period	Period INT		MPPerioden.PeriodeJahr
OptionMemo	OptionMemo NTEXT
ProcessDate	ProcessDate Datetime
ProcessID	ProcessID NVARCHAR (4)
DraftDocNumber	DraftDocNumber INT Index
DraftDocNumberVisible	DraftDocNumberVisible NVARCHAR (20)
Company	Company SMALLINT Index		MPSysConnections.CompanyID (WHERE ConnectionType=6)
BPLId	BPLId INT	BranchID	OINF.BPLId
DocSeries	DocSeries INT		NNM1.Seris
DocNumSegment	DocNumSegment INT		OINV.Secment
DocSeriesString	DocSeriesString NVARCHAR (3)		OINV.SeriesStr
DocSeriesSubString	DocSeriesSubString NVARCHAR (3)		OINV.SubStr
SequenceCode	SequenceCode INT		OINV.SeqCode
SequenceSerial	SequenceSerial INT
SequenceModel	SequenceModel NVARCHAR (10)	Field for Brazil	OINV.Model
DeferrTax	DeferrTax SMALLINT (0=false,-1=true)
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
FiscDocNum	FiscDocNum NVARCHAR (100)	Localization Poland	OPOR.FiscDocNum
PaymentRef	PaymentRef NVARCHAR (27)
DocYear	DocYear Datetime
ShipmentType	ShipmentType INT
A0AdressNr	A0AddressNr INT
A0Empfaenger	A0CardCode NVARCHAR (20) Index		OCRD.CardCode
A0Anrede	A0Salutation NVARCHAR (50)
A0Name1	A0Name1 NVARCHAR (100)
A0Name2	A0Name2 NVARCHAR (50)
A0Zusatz	A0Name3 NVARCHAR (50)
A0Einmalkunde	A0OneTimeCustomer SMALLINT
A0Matchcode	A0Matchcode NVARCHAR (100)
A0Strasse	A0Street NVARCHAR (100)
A0Hausnummer	A0StreetNumber NVARCHAR (100)
A0Land	A0Country NVARCHAR (3)
A0PLZ	A0ZIP NVARCHAR (20)
A0Ort	A0City NVARCHAR (100)
A0Bezirk	A0County NVARCHAR (100)
A0Bundesland	A0State NVARCHAR (3)
A0Gebaeude	A0Block NVARCHAR (100)
A0AnsprechpartnerID	A0ContactPerson INT		OCPR.CntctCode
A0AdressName	A0AddressName1 NVARCHAR (50)
A0AdressName2	A0AddressName2 NVARCHAR (50)
A0AdressName3	A0AddressName3 NVARCHAR (50)
A0GebaeudeStockwerk	A0Building NTEXT
A0AdressMemo	A0AddressMemo NTEXT
A0CardFName	A0CardFName NVARCHAR (100)
A0AddrType	A0AddrType NVARCHAR (100)
A0AdressLineNum	A0AddressLineNum INT
A0GlbLocNum	A0GlbLocNum NVARCHAR (50)
A0Longitude	A0Longitude Float
A0Latitude	A0Latitude Float
A1BusinessPartner	A1BusinessPartner NVARCHAR (20)		OCRD.CardCode
A1Anrede	A1Salutation NVARCHAR (50)
A1Name1	A1Name1 NVARCHAR (100)
A1Name2	A1Name2 NVARCHAR (50)
A1Zusatz	A1Name3 NVARCHAR (50)
A1Matchcode	A1Matchcode NVARCHAR (100)
A1Strasse	A1Street NVARCHAR (100)
A1Hausnummer	A1StreetNum NVARCHAR (100)
A1Land	A1Country NVARCHAR (3)
A1PLZ	A1ZIP NVARCHAR (20)
A1Ort	A1City NVARCHAR (100)
A1Bezirk	A1County NVARCHAR (100)
A1Bundesland	A1State NVARCHAR (3)
A1Gebaeude	A1Block NVARCHAR (100)
A1AnsprechpartnerID	A1ContactPerson INT		OCPR.CntctCode
A1AdressName	A1AddressName1 NVARCHAR (50)
A1AdressName2	A1AddressName2 NVARCHAR (50)
A1AdressName3	A1AddressName3 NVARCHAR (50)
A1GebaeudeStockwerk	A1Building NTEXT
A1AdressMemo	A1AddressMemo NTEXT
A1CardFName	A1CardFName NVARCHAR (100)
A1AddrType	A1AddrType NVARCHAR (100)
A1AdressLineNum	A1AddressLineNum INT
A1GlbLocNum	A1GlbLocNum NVARCHAR (50)
A1Longitude	A1Longitude Float
A1Latitude	A1Latitude Float
ApprovalMode	ApprovalMode SMALLINT Index
ApprovedOn	ApprovedOn Datetime
ApprovedBy	ApprovedBy NVARCHAR (4)		MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ApprovedByEmployee	ApprovedByEmployee NVARCHAR (20)		MPPersonenstamm.Personalnummer
ApprovalText	ApprovalText NTEXT
NetPositionTotalSys	NetPositionTotalSys NUMERIC(19,6)
NetPositionTotalLoc	NetPositionTotalLoc NUMERIC(19,6)
NetPositionTotalFc	NetPositionTotalFc NUMERIC(19,6)
NetValueSys	NetValueSys NUMERIC(19,6)
NetValueLoc	NetValueLoc NUMERIC(19,6)
NetValueFc	NetValueFc NUMERIC(19,6)
TotalValueSys	TotalValueSys NUMERIC(19,6)
TotalValueLoc	TotalValueLoc NUMERIC(19,6)
TotalValueFc	TotalValueFc NUMERIC(19,6)
TaxValueSys	TaxValueSys NUMERIC(19,6)
TaxValueLoc	TaxValueLoc NUMERIC(19,6)
TaxValueFc	TaxValueFc NUMERIC(19,6)
CurrencySys	CurrencySys NVARCHAR (3)
CurrencyLoc	CurrencyLoc NVARCHAR (3)
CurrencyFC	CurrencyFC NVARCHAR (3)
CurrencyRateLoc	CurrencyRateLoc Float
CurrencyRateFc	CurrencyRateFC Float
Reference1	Reference1 NVARCHAR (100)
Reference2	Reference2 NVARCHAR (100)
Reference3	Reference3 NVARCHAR (254)
RefDate1	RefDate1 Datetime
RefDate2	RefDate2 Datetime
RefDate3	RefDate3 Datetime
PaymentBlock	PaymentBlock SMALLINT (0=false,-1=true)
PaymentBlockRef	PaymentBlockRef INT
DiscountPercent	DiscountPercent NUMERIC(19,6)
DiscountBaseSys	DiscountBaseSys NUMERIC(19,6)
DiscountBaseLoc	DiscountBaseLoc NUMERIC(19,6)
DiscountBaseFc	DiscountBaseFc NUMERIC(19,6)
DiscountValueSys	DiscountValueSys NUMERIC(19,6)
DiscountValueLoc	DiscountValueLoc NUMERIC(19,6)
DiscountValueFc	DiscountValueFc NUMERIC(19,6)
AvailabilityCheck	AvailabilityCheck INT
AvailabilityCheckDate	AvailabilityCheckDate Datetime
CreateDate	CreateDate Datetime
CreateUser	CreateUser NVARCHAR (4)		MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
ChangeDate	ChangeDate Datetime
ChangeUser	ChangeUser NVARCHAR (4)		MPBenutzer.Benutzer (WHERE BenutzerTyp=1)
Memo	Memo NTEXT
UpdateStamp	UpdateStamp INT

Table	Description
MPDocumentDraftHeadApproval	Approval or workflow list for the draft document
MPDocumentDraftHeadLink	Linked contracts and purchase processes
MPDocumentDraftInstallments	Payment conditions and installments
MPDocumentDraftPosition	Positions based on the order of the paper document
MPDocumentDraftTax	Tax information
MPGebindeZeile	Container Lines to see the goods in the container

MARIProject Database Structure