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