| View Name: | MARIContractPositionPayment |
| Based on table: | MPVKVertraegePositionenAkd |
| Group: | Group: Contract |
| Description: | Contract Management: Contract positions accounting lines (due date, phase ...) |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ConditionID | Kondition INT Primary |
internal ID | |
| ContractPositionID | Vertragsposition INT Index |
Link to contract position | MARIContractPositions.ContractPositionID |
| ConditionOrder | Reihenfolge SMALLINT |
order | |
| Description | Bezeichnung NVARCHAR (50) |
Text | |
| UserType | VerwendungsTyp INT |
0=Sales, 1=Purcahse Order, 2=A/P Invoice | |
| AccountingType | Abrechnungstyp SMALLINT |
Type of condition (Phase, due date...) | clsImportProjectContractPositionAccountingPos_eAccountingType |
| CycleMode | Rhythmus INT |
Cycle mode | clsImportProjectContractPosition_eMaintenancePeriodic |
| StartPeriod | StartPeriode INT |
MARIPeriods.StartPeriod | |
| EndPeriod | EndPeriode INT |
MARIPeriods.EndPeriod | |
| DueDate | Stichtag Datetime |
||
| DueDateManual | StichtagManuell SMALLINT (0=false,-1=true) |
||
| ProRataNumberOfPeriods | ProRataNumberOfPeriods INT |
||
| RecurrentAccounting | WartungsPeriodik INT |
clsImportProjectContractPosition_eMaintenancePeriodic | |
| ServiceStartDate | WartungStart Datetime |
||
| ServiceEndDate | WartungEnde Datetime |
||
| PhaseID | PhasenID INT Index |
MARIProjectPhases.PhaseID | |
| PercentageValue | AnteilProzent NUMERIC(19,6) |
||
| PartValue | AnteilWert NUMERIC(19,6) |
||
| PartQuantity | AnteilMenge NUMERIC(19,6) |
||
| Status | Status SMALLINT |
1=Open, 2=Closed | clsImportProjectContractPositionAccountingPos_ePosAccountingStatus |
| Status2 | ERStatus INT |
||
| ConditionFreeText | Freitext NVARCHAR (50) |
||
| RefBelPosID | RefBelPosID INT Index |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIContractPosition2DocumentPosition | Contract Management: Contract document position to document position link |
| MARIContractInstallmentPlan | Contract Management: Contract Invoicing plan |