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