| Table Name: | MPVKVertraegeAnzahlungen |
| View Name: | MARIContractDownPayments |
| Group: | Group: Contract |
| Description: | Contract Management: Contract Down Payments |
| ClassID: | 332. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| Anzahlung | DownPaymentID INT Primary |
||
| AnzahlungsTyp | DownPaymentType INT |
1=Down Payment | clsPublicEnums_eContractDownPaymentLineType |
| VertragsID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| Reihenfolge | LineOrder SMALLINT |
||
| Bezeichnung | Description NVARCHAR (50) |
||
| Bezeichnung2 | Description2 NVARCHAR (100) |
||
| Abrechnungstyp | AccountingType SMALLINT |
1=Due Date, 2=Phase | |
| Belegart | DocumentTypeID INT |
||
| Stichtag | DueDate Datetime |
||
| PhasenID | PhaseID INT Index |
MPProjektPhasen.PhasenID | |
| AnteilProzent | PercentageValue NUMERIC(19,6) |
100 = 100% | |
| AnteilWert | PartValue NUMERIC(19,6) |
||
| AnteilWertRest | PartValueRest NUMERIC(19,6) |
||
| GezahltGestellt | PayedCreated NUMERIC(19,6) |
||
| GezahltErhalten | PayedReceived NUMERIC(19,6) |
||
| Status | Status SMALLINT |
||
| Steuercode | TaxCode NVARCHAR (10) |
||
| Steuersatz | TaxRate NUMERIC(19,6) |
||
| Steuerklasse | TaxClass SMALLINT |
||
| SteuerManuell | TaxManual SMALLINT (0=false,-1=true) |
||
| Sachkonto | GLAccount NVARCHAR (20) |
OACT.AcctCode | |
| TaxWtLiable | TaxWtLiable SMALLINT (0=false,-1=true) |
||
| TaxUsage | TaxUsage INT |
||
| TaxCSTcode | TaxCSTcode NVARCHAR (4) |
||
| TaxCFOPcode | TaxCFOPcode NVARCHAR (6) |
||
| Belegdatum | DocDate Datetime |
||
| MPBelID | MARIDocID INT Index |
MPVKVertraegeBelege.MPBelID | |
| OPNr | OpenItemNumber NVARCHAR (50) |
||
| VorschussMin | RetentionMin NUMERIC(19,6) |
||
| VorschussMax | RetentionMax NUMERIC(19,6) |
||
| RetentionMode | RetentionMode INT |
0=With out retention value, 1=Subtract retention first | |
| Langtext | AccountingInfo NTEXT |
||
| Dimensionstext | PositionInfo NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPVKVertraegeZahlungsplan | Contract Management: Contract Invoicing plan |