| View Name: | MARITempReportDocumentPayment |
| Based on table: | MPTmpRptPrintZKD |
| Group: | Group: TempReportDocumentHeader |
| Description: | Reporting: Temporary Table: Document Payment Conditions |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ConnectionID | ConnectionID INT Primary |
||
| ID | ID INT Primary |
||
| CashingText | Inkassotext NVARCHAR (50) |
||
| CashingDescription | Inkassobezeichnung NVARCHAR (50) |
||
| CashDiscountDays1 | SkontoTage1 SMALLINT |
||
| CashDiscountDateText1 | DatumText1 NVARCHAR (20) |
||
| CashDiscountPercent1 | SkontoProzent1 NUMERIC(19,6) |
||
| CashDiscountAmount1Fc | BetragSkonto1 NUMERIC(19,6) |
||
| CashDiscountDays2 | SkontoTage2 SMALLINT |
||
| CashDiscountDateText2 | DatumText2 NVARCHAR (20) |
||
| CashDiscountPercent2 | SkontoProzent2 NUMERIC(19,6) |
||
| CashDiscountAmount2Fc | BetragSkonto2 NUMERIC(19,6) |
||
| DaysText | TageText NVARCHAR (10) |
||
| PercentText | ProzentText NVARCHAR (20) |
||
| CurrencyFc | Wkz NVARCHAR (5) |
ISO Currency Code | |
| NetDays | NettoTage SMALLINT |
||
| NetDueDateText | DatumTextNetto NVARCHAR (100) |
||
| NetText | NettoText NVARCHAR (100) |
||
| NetAmountFc | BetragNetto NUMERIC(19,6) |
||
| NetDaysText | NettoTageText NVARCHAR (100) |
||
| CurrencyEUR | WkzEuro NVARCHAR (5) |
||
| CashDiscountAmount1EUR | BetragSkonto1Euro NUMERIC(19,6) |
||
| CashDiscountAmount2EUR | BetragSkonto2Euro NUMERIC(19,6) |
||
| NetAmountEUR | BetragNettoEuro NUMERIC(19,6) |
||
| EqualsToText | EntsprichtText NVARCHAR (100) |
||
| UntilText | BisText NVARCHAR (100) |
||
| ImmediateText | SofortText NVARCHAR (100) |
||
| NetDueDate | Nettodatum Datetime |
||
| CashDiscountDate1 | Skontodatum1 Datetime |
||
| CashDiscountDate2 | Skontodatum2 Datetime |
||
| ValueDateText | Valutatext NVARCHAR (100) |
||
| ValueDate | Valutadatum Datetime |
||
| CreditCardCompany | KKGesellschaft NVARCHAR (50) |
||
| CreditCardCompanyText | KKGesellschaftText NVARCHAR (20) |
||
| CreditCardNumber | KKNummer NVARCHAR (20) Index |
||
| CreditCardNumberText | KKNummerText NVARCHAR (20) |
||
| CreditCardDueDate | KKGueltigkeit NVARCHAR (10) |
||
| CreditCardDueDateText | KKGueltigkeitText NVARCHAR (20) |
||
| CreditCardUser | KKInhaber NVARCHAR (50) |
||
| CreditCardUserText | KKInhaberText NVARCHAR (20) |
||
| LineType | ZeilenTyp INT |
1=Payment Conditions,2=Defined Purchase Downpayments 3=Linked Downpayments, 4=Installments | |
| InstallmentPercent | RateProzent NUMERIC(19,6) |