| View Name: | MARIPurchaseProcessInstallments |
| Based on table: | MPEKVertraegeZKD |
| Group: | Group: MPEKVertraege |
| Description: | Purchase Process: Installment Plan |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| PaymentConditionID | MPZKDID INT Primary |
||
| ContractID | VertragsID INT Index |
MARIPurchaseProcess.ContractID | |
| LineType | ZeilenTyp INT |
||
| PaymentCondition | Zahlungskond NVARCHAR (10) |
OCTG.GroupNum | |
| PaymentConditionDescription | Bezeichnung NVARCHAR (100) |
||
| PaymentTerms | Inkassoart NVARCHAR (15) |
OPYM.PayMethCod | |
| NetCondition | Nettobedingung NVARCHAR (255) |
||
| CashDiscount1 | Skontobedingung1 NVARCHAR (255) |
||
| CashDiscount2 | Skontobedingung2 NVARCHAR (255) |
||
| CashDiscountPercent1 | Skontoprozent1 NUMERIC(19,6) |
||
| CashDiscountPercent2 | Skontoprozent2 NUMERIC(19,6) |
||
| Standard | IstStandard SMALLINT |
||
| PaymentValue | Betrag NUMERIC(19,6) |
||
| InstallmentPercent | RateProzent NUMERIC(19,6) |
||
| DueDate | Faelligkeit Datetime |
||
| BaseDate | Basisdatum Datetime |
||
| CreditCardCompany | KKGesellschaft NVARCHAR (50) |
||
| CreditCardNumber | KKNummer NVARCHAR (20) |
||
| CreditCardDueDate | KKGueltigkeit SMALLINT |
||
| CreditCardValidFlag | KKGenehmigung NVARCHAR (20) |
||
| CreditCardUser | KKInhaber NVARCHAR (50) |
||
| UpdateStamp | UpdateStamp INT |