| Table Name: | MPEKVertraegePositionenAkd |
| View Name: | MARIPurchaseProcessPositionAccounting |
| Group: | Group: MPEKVertraege |
| Description: | Purchase Process: Accounting lines (due date, phase ...) |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Kondition | ConditionID INT Primary |
||
| Vertragsposition | ContractPositionID INT Index |
MPVKVertraegePositionen.Vertragsposition | |
| Reihenfolge | ConditionOrder SMALLINT |
||
| Bezeichnung | Description NVARCHAR (50) |
||
| VerwendungsTyp | UserType INT |
0=Sales, 1=Purcahse Order, 2=A/P Invoice | |
| Abrechnungstyp | AccountingType SMALLINT |
clsImportProjectContractPositionAcountingPos_eAccountingType | |
| Rhythmus | CycleMode INT |
||
| 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 |
||
| ERStatus | Status2 INT |
||
| Freitext | ConditionFreeText NVARCHAR (50) |
||
| RefBelPosID | RefBelPosID INT Index |
||
| UpdateStamp | UpdateStamp INT |