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