MARIContractPositions

View Name:	MARIContractPositions
Based on table:	MPVKVertraegePositionen
Group:	Group: Contract
Description:	Contract Management: Contract positions (also service master positions)
ClassID:	74. See Overview of ClassIDs by table.

Field	Table(Germ.field)/Type	Description	Related
ContractPositionID	Vertragsposition INT Primary
ContractID	VertragsID INT Index	Contract	MARIContract.ContractID
ParentID	ParentID INT Index		MARIContractPositions.ParentID
PositionID	Position SMALLINT Index	Position ID
Indent	Indent INT
Position	PositionText NVARCHAR (50)	Position text "1.2.3"
PositionType	PosTyp SMALLINT		clsImportProjectContractPosition_eContractPositionType
ServiceNumber	Leistungsnummer NVARCHAR (20) Index		MARIServices.ServiceNumber
ItemCode	KHKArtikel NVARCHAR (50)		OITM.ItemCode
Company	KHKMandant SMALLINT		MARISysConnections.Company (WHERE ConnectionType=6)
TravelCategory	ReisekostenArt NVARCHAR (20)		MARITravelExpenseTypes.TravelCategory
EquipmentCategory	EquipmentCategory INT		MARIEquipmentCategory.EquipmentCategory
EquipmentSubject	EquipmentSubject NVARCHAR (20)		MARIEquipmentCategorySubject.EquipmentSubject
EquipmentParentPos	EquipmentParentPos INT
WorkpackageNumber	ArbeitspaketNumber NVARCHAR (20)		MARIWorkPackage.WorkpackageNumber
SalesContractPosition	VKPosIndex INT
SalesContractPositionText	VKPosIndexText NVARCHAR (20)
Description1	Bezeichnung1 NVARCHAR (200)
Description2	Bezeichnung2 NVARCHAR (200)
Matchcode	Matchcode NVARCHAR (200) Index
Quantity	Menge NUMERIC(19,6)	Qty = BaseQty*Parent Qty
MaximumQuantity	MengeMax NUMERIC(19,6)
MaxQuantityType	MengeMaxTyp TINYINT
DefaultQuantity	MengeVorgabe NUMERIC(19,6)
QuantityType	MengenTyp INT		clsImportProjectContractPosition_eQuantityType
QuantityOption	MengenOptionen SMALLINT (0=false,-1=true)	Flags for Quantity 2=Edittable 4=Max Quantity 8=Default Quantity 16=Quantity is invoiceable 32=Quantity from fixed price 64=Qty is mandatory 128=BOM quantity
SummaryMode	ZusammenfassungMode INT
BaseQuantity	BasisMenge NUMERIC(19,6)	Qty by contract (sub contract)
QuantityCount	MengeAnzahl NUMERIC(19,6)	Quantity of equipment for rental
QuantityCountText	MengeAnzahlText NVARCHAR (100)
QuantityFormularID	MengenFormelID INT Index		MARISetupQuantityFormular.QuantityFormularID
BasisAnzahl	BasisAnzahl NUMERIC(19,6)
RoundingMethodID	RundungsMethode INT		MARIContractRoundingDefinition.RoundingMethodID (WHERE ClassID=71)
CalculationMethod	CalculationMethod INT Index		MARIContractCalculation.CalculationMethod
NetUnitPriceFC	Einzelpreis NUMERIC(19,6)
UnitPriceFC	EinzelPreisFW NUMERIC(19,6)
PriceType	PreisTyp SMALLINT		clsImportProjectContractPosition_eSalesPriceType
PriceOption	PreisOptionen SMALLINT (0=false,-1=true)
UnitPriceDocument	EinzelpreisBeleg NUMERIC(19,6)
DiscountPercent	Rabatt NUMERIC(19,6)
POUnitPrice	EKEinzelpreis NUMERIC(19,6)	Purchase Price in MARI System Currency. When EKPreisTyp=manual
POPriceType	EKPreisTyp SMALLINT		clsImportProjectContractPosition_ePurchasePriceType
POUnitPriceFC	EKEinzelpreisFW NUMERIC(19,6)	Purchase Price in special currency
POPriceCurrency	EKPreisWKZ NVARCHAR (3)
POPriceExchangeRate	EKPreisKurs Float
POPriceExchangeHandling	EKPreisKursHandling INT
POPriceOption	EKPreisOptionen SMALLINT
POMode	EKModus INT
POPriceSurplus	EKPreisAufschlag NUMERIC(19,6)
CostMarginImputed	KostenAufschlagKalkulatorisch Float
SalesMarginImputed	VerkaufsAufschlagKalkulatorisch Float
StandardAccountingType	Abrechnungstyp INT
AccountingDate	AbrechnungTag SMALLINT
Vendor	Lieferant NVARCHAR (20)		OCRD.CardCode
PurchaseType	Lieferart SMALLINT		clsImportProjectContractPosition_ePurchaseMode
IssueMethod	AusgabeMethode INT
DeliveryDate	Lieferdatum Datetime
LeadTime	Lieferzeit INT
RentalStartDate	MietStartDatum Datetime
Warehouse	Lagerort NVARCHAR (10)		OWHS.WhsCode
SourceWarehouse	QuellLagerOrt NVARCHAR (10)		OWHS.WhsCode
SourceContractPosID	KHKVorPosID INT Index
ExternalNumber	Fremdnummer NVARCHAR (40)
DegreeOfCompletion	Fertigstellungsgrad Single
UsesDegreeOfCompleation	HatFertigstellungsgrad SMALLINT (0=false,-1=true)
TimeSurcharges	Zuschlaege NVARCHAR (255)
AccountingInfo	Langtext NTEXT
PositionInfo	Dimensionstext NTEXT
OptionMemo	OptionMemo NTEXT
EntitledDiscount	Rabattfaehig SMALLINT (0=false,-1=true)
UoM	Mengeneinheit NVARCHAR (20)
ActiveType	AktivTyp SMALLINT
BPCatalogNumber	BPCatalogNumber NVARCHAR (50)
DocumentHandling	BelegHandling INT
HasExternalNumber	HatFremdnummer SMALLINT (0=false,-1=true)
IndexTreatment	IndexBehandlung SMALLINT
HasNumber	HatNummer SMALLINT (0=false,-1=true)
NumberRangeFrom	NummernKreisVon INT
NumberRangeTo	NummernKreisBis INT
OrderFlag	SortierKZ SMALLINT
RevenueReturnAccountDefinition	ERDefinition INT
BaseContractPosition	GVPosID INT Index		MARIContractPositions.BaseContractPosition
BalanceOrdered	GGMengeBestellt NUMERIC(19,6)
BalanceDelivered	GGMengeGeliefert NUMERIC(19,6)
BalanceInvoiced	GGMengeRechnung NUMERIC(19,6)
BalanceLastDocReference	GGDocReference INT
TaxCode	Steuercode NVARCHAR (10)
TaxRate	Steuersatz NUMERIC(19,6)
TaxClass	Steuerklasse SMALLINT
TaxManual	SteuerManuell SMALLINT (0=false,-1=true)
GLAccountManual	SachkontoManuell SMALLINT (0=false,-1=true)
GLAccount	Sachkonto NVARCHAR (20)		OACT.AcctCode
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)
TaxWtLiable	TaxWtLiable SMALLINT (0=false,-1=true)
TaxUsage	TaxUsage INT
TaxCSTcode	TaxCSTcode NVARCHAR (4)
TaxCFOPcode	TaxCFOPcode NVARCHAR (6)
LocationID	LocationID INT Index
ProductID	ProduktID INT Index		MARISupportProduct.ProductID
CostHandling	Kostenbehandlung INT
CostPercentage	KostenProzent NUMERIC(19,6)
CostReduction	KostenAbschlag NUMERIC(19,6)
PayrollType	Lohnart NVARCHAR (20)		MARIPayrollTypes.PayrollType
MaintenanceType	WartungsTyp INT
RecurrentAccounting	WartungsPeriodik INT		clsImportProjectContractPosition_eMaintenancePeriodic
MaintenancePercent	WartungsSatz NUMERIC(19,6)
MaintenanceBasicPrice	WartungBasisPreis NUMERIC(19,6)
MaintenanceReference	WartungsReferenz INT
ServiceStartDate	WartungStart Datetime
ServiceEndDate	WartungEnde Datetime
ServiceDueDateType	WartungsStichtagsTyp SMALLINT		clsImportProjectContractPosition_eMaintenanceDueDateType
ServiceDueDateOffset	WartungsStichtagsOffset SMALLINT
ServiceContractEnd	WartungsVertragsEnde Datetime
QualityProcess	QualityProcess INT
QualityProcessSales	QualityProcessVK INT		MARIQualityProcess.QualityProcessSales
QualityStatus	QualityStatus INT
Alternative	AlternativPosition SMALLINT (0=false,-1=true)
DisplayInDocMode	AnzeigeImBelegFlagg INT
InvoiceHandling	AbrechnungsHandling INT
SubContractID	SubVertragsID INT Index		MARIContract.SubContractID
SubContractPosition	SubVertragsPosition INT		MARIContractPositions.SubContractPosition
SourceSalesDocPosID	QuellVKBelPosID INT Index		MARIContractDocumentPositions.SourceSalesDocPosID
CommissionMode	ProvisionsMode INT
CommissionPercent	ProvisionsProzent NUMERIC(19,6)
ContractCommissionID	ContractCommissionID INT Index
AddOnCategory	AddOnCategory INT		MARITimeBookingAddOnCategory.AddOnCategory
WorkItemPosition	WorkItemPosition INT
ProRataID	ProRataID INT Index		MARISysProRata.ProRataID (WHERE ProRataType=478)
AccrualRuleID	AccrualRuleID INT Index		MARISysProRata.AccrualRuleID (WHERE ProRataType=661)
ERPResourceCode	ERPResourceCode NVARCHAR (50) Index		ORSC.ResCode
TravelTimeMode	ReiseZeitenMode INT	Mode for timekeeping to enable the entry of travel time
TravelTimeSalesFactor	ReiseZeitenErloeseFaktor NUMERIC(19,6)	percentage to add travel time to service quanttiy
Height1	Height1 NUMERIC(19,6)
Hght1Unit	Hght1Unit SMALLINT
Width1	Width1 NUMERIC(19,6)
Wdth1Unit	Wdth1Unit SMALLINT
Length1	Length1 NUMERIC(19,6)
Len1Unit	Len1Unit SMALLINT
Volume	Volume NUMERIC(19,6)
VolUnit	VolUnit SMALLINT
Weight1	Weight1 NUMERIC(19,6)
Wght1Unit	Wght1Unit SMALLINT
CustomerDocumentMode	KundenDokumente SMALLINT (0=false,-1=true)
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