| View Name: | MARIPurchaseProcessPaymentPlan |
| Based on table: | MPEKVertraegeZahlungsplan |
| Group: | Group: MPEKVertraege |
| Description: | Purchase Process: Payment plan (not used in PO) |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| PurchasePaymentPlanID | ZahlungsplanID INT Primary |
||
| ContractID | VertragsID INT Index |
MARIPurchaseProcess.ContractID | |
| PaymentPlanLineType | ZahlungsplanTyp SMALLINT |
||
| ContractPositionID | VKPosID INT Index |
MARIPurchaseProcessPositions.ContractPositionID | |
| AccountingID | AbrechnungID INT Index |
||
| DocumentDueDate | Belegstichtag Datetime |
||
| DueDate | Zahlungstag Datetime |
||
| Period | Periode INT |
MARIPeriods.Period | |
| ActiveType | AktivTyp INT |
||
| Quantity | Menge NUMERIC(19,6) |
||
| Amount | Betrag NUMERIC(19,6) |
||
| ValueFC | BetragFW NUMERIC(19,6) |
||
| Currency | WKZ NVARCHAR (3) |
ISO Currency Code | |
| EditMethodFlag | EditMethodFlagg INT |
||
| RetentionPercentage | RetentionPercentage NUMERIC(19,6) |
||
| RetentionPosition | RetentionPosition INT |
MARIPurchaseProcessPositions.RetentionPosition | |
| RetentionValue | RetentionValue NUMERIC(19,6) |
||
| DownPaymentID | DownPaymentID INT Index |
MARIPurchaseProcessDownPayments.DownPaymentID | |
| DownPaymentValue | DownPaymentValue NUMERIC(19,6) |
||
| UpdateStamp | UpdateStamp INT |