| Table Name: | MPVKVertraegeZahlungsplan |
| View Name: | MARIContractInstallmentPlan |
| Group: | Group: Contract |
| Description: | Contract Management: Contract Invoicing plan |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ZahlungsplanID | ContractPaymentPlanID INT Primary |
Unique ID | |
| VertragsID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| ZahlungsplanTyp | PaymentPlanType SMALLINT |
1=Automatic Line, 4=Retension Line, 5=Down Payment Line | clsPublicEnums_eContractInstallmentPlanLineType |
| VKPosID | ContractPositionID INT Index |
MPVKVertraegePositionen.Vertragsposition | |
| AbrechnungID | AccountingID INT Index |
Link to the billing position | MPVKVertraegePositionenAkd.Kondition |
| Belegstichtag | DocumentDueDate Datetime |
||
| Zahlungstag | DueDate Datetime |
||
| Periode | Period INT |
MPPerioden.PeriodeJahr | |
| AktivTyp | ActiveType INT |
||
| Menge | Quantity NUMERIC(19,6) |
||
| Betrag | Amount NUMERIC(19,6) |
Value of the invoicing position reduced by down payment and retention | |
| BetragFW | AmountFC NUMERIC(19,6) |
Value in contract currency | |
| WKZ | Currency NVARCHAR (3) |
Contract currency ISO Code | |
| EditMethodFlagg | EditMethodFlag INT |
Not used | |
| RetentionPercentage | RetentionPercentage NUMERIC(19,6) |
Percent value of the retention line | |
| RetentionPosition | RetentionPosition INT |
Link to the retention position | MPVKVertraegePositionen.Vertragsposition |
| RetentionValue | RetentionValue NUMERIC(19,6) |
Retention Value | |
| DownPaymentID | DownPaymentID INT Index |
Link to the down payment position | MPVKVertraegeAnzahlungen.Anzahlung |
| DownPaymentValue | DownPaymentValue NUMERIC(19,6) |
Down Payment Value | |
| UpdateStamp | UpdateStamp INT |