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