MARIContractDocumentISCHead

View Name:	MARIContractDocumentISCHead
Based on table:	MPVKVertraegeBelegeILVKopf
Group:	Group: ContractDocument
Description:	Contract Management: Document Internal Service Charges Head

Field	Table(Germ.field)/Type	Description	Related
ISCDocumentID	ILVBelegID INT Primary
MARIDocID	MPBelID INT Index		MARIContractDocument.MARIDocID
ISCDocumentType	ILVBelegTyp INT
DocumentTypeText	Belegart NVARCHAR (50)
Batch	Stapel INT
ERPStatus	ERPStatus INT
ERPDocType	ERPDocType INT
ERPDocNum	ERPDocNum INT
ERPDocSeries	ERPDocSeries INT
ERPDocEntry	ERPDocEntry INT
ERPDocSeriesString	ERPDocSeriesString NVARCHAR (3)
ERPDocSeriesSubString	ERPDocSeriesSubString NVARCHAR (3)
ERPSequenceCode	ERPSequenceCode INT
ERPSequenceSerial	ERPSequenceSerial INT
ERPSequenceModel	ERPSequenceModel NVARCHAR (10)
ERPDeferrTax	ERPDeferrTax SMALLINT (0=false,-1=true)
ERPVatFirst	ERPVatFirst SMALLINT (0=false,-1=true)
ERPPaymentRef	ERPPaymentRef NVARCHAR (27)
ERPTransferDate	ERPUebergabedatum Datetime
ERPTransferUser	ERPUebergabeUser NVARCHAR (4)		MARIUser.ERPTransferUser (WHERE BenutzerTyp=1)
ERPTransactionID	ERPTan INT
ERPErrorCode	ERPErrorCode INT Index
ERPErrorText	ERPErrorText NTEXT
ERPBPLId	ERPBPLId 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
FiscDocNum	FiscDocNum NVARCHAR (100)	Localization Poland	OPOR.FiscDocNum
BusinessPartner	Geschaeftspartner NVARCHAR (20)		OCRD.CardCode
Company	Mandant SMALLINT Index		MARISysConnections.Company (WHERE ConnectionType=6)
OpenItemNumber	OPNr NVARCHAR (20)
DocDate	Belegdatum Datetime
DueDate	Faelligkeit Datetime
PostingDate	Buchungsdatum Datetime
Period	Periode INT	Period	MARIPeriods.Period
NetAmountSys	NettoSys NUMERIC(19,6)
NetAmountCompany	NettoMA NUMERIC(19,6)
NetAmountForeign	NettoFW NUMERIC(19,6)
BrutAmountSys	BruttoSys NUMERIC(19,6)
BrutAmountCompany	BruttoMA NUMERIC(19,6)
BrutAmountForgeign	BruttoFW NUMERIC(19,6)
TaxAmountSys	SteuerSys NUMERIC(19,6)
TaxCompCur	SteuerMA NUMERIC(19,6)
TaxFC	SteuerFW NUMERIC(19,6)
CurrencySys	WKZSys NVARCHAR (3)
CurrencyCompany	WKZMa NVARCHAR (3)
CurrencyForeign	WKZBeleg NVARCHAR (3)
ExchangeRateCompany	WkzMaKurs Float
ExchangeRateFC2Sys	WKzKursFw Float
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)
A0OneTimeAddress	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
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
A1AddressID	A1AdressNr INT
A1CardCode	A1Empfaenger NVARCHAR (20)		OCRD.CardCode
A1Salutation	A1Anrede NVARCHAR (50)
A1Name1	A1Name1 NVARCHAR (100)
A1Name2	A1Name2 NVARCHAR (50)
A1Name3	A1Zusatz NVARCHAR (50)
A1OneTimeAddress	A1Einmalkunde SMALLINT
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
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
ISCDocumentFollowID	ILVBelegIDNachfolger INT		MARIContractDocumentISCHead.ISCDocumentFollowID
ISCDocumentPreviousID	ILVBelegIDVorgaenger INT		MARIContractDocumentISCHead.ISCDocumentPreviousID
LocationID	LocationID INT
CIG_Code	CIG_Code INT
CUP_Code	CUP_Code INT Index
CreateDate	Erstanlage Datetime
CreateUser	ErstanlageID NVARCHAR (4)		MARIUser.CreateUser (WHERE BenutzerTyp=1)
ChangeDate	Aenderung Datetime
ChangeUser	AenderungID NVARCHAR (4)		MARIUser.ChangeUser (WHERE BenutzerTyp=1)
UpdateStamp	UpdateStamp INT

Table	Description
MARIJournalEntryExport	Journal Entries Export (Travel Expenses, Internal Service Charges, Work in Progress)
MARIJournalEntryExportCancel	Journal Entries Canceled Records (Travel Expenses, Internal Service Charges, Work in Progress)
MARIContractDocumentISCHead	Contract Management: Document Internal Service Charges Head

MARIProject Database Structure