| Table Name: | MPVKVertraegeBelegeZKD |
| View Name: | MARIContractDocumentInstallments |
| Group: | Group: ContractDocument |
| Description: | Contract Management: Document Payment Conditions |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MPBelZKDID | MARIContractDocumentPaymentLineID INT Primary |
||
| MPBelID | MARIDocID INT Index |
MPVKVertraegeBelege.MPBelID | |
| BelID | DocEntry INT Index |
||
| Mandant | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| ZeilenTyp | LineType INT |
||
| Zahlungskond | PaymentCondition NVARCHAR (10) |
OCTG.GroupNum | |
| Bezeichnung | Description NVARCHAR (100) |
||
| Inkassoart | PaymentTerms NVARCHAR (15) |
OPYM.PayMethCod | |
| Nettobedingung | PaymentNetCondition NVARCHAR (255) |
||
| Skontobedingung1 | CashDiscount1 NVARCHAR (255) |
||
| Skontobedingung2 | CashDiscount2 NVARCHAR (255) |
||
| Skontoprozent1 | CashDiscountPercent1 NUMERIC(19,6) |
||
| Skontoprozent2 | CashDiscountPercent2 NUMERIC(19,6) |
||
| IstStandard | Standard SMALLINT |
||
| PaymentValueSys | PaymentValueSys NUMERIC(19,6) |
||
| PaymentValueLoc | PaymentValueLoc NUMERIC(19,6) |
||
| Betrag | PaymentValueFc 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 |