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