| View Name: | MARIPurchaseProcessDownPayments |
| Based on table: | MPEKVertraegeAnzahlungen |
| Group: | Group: MPEKVertraege |
| Description: | Purchase Process: Down Payments |
| ClassID: | 331. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| DownPaymentID | Anzahlung INT Primary |
||
| DownPaymentType | AnzahlungsTyp INT |
clsPublicEnums_eContractDownPaymentLineType | |
| ContractID | VertragsID INT Index |
MARIPurchaseProcess.ContractID | |
| DownPaymentOrder | Reihenfolge SMALLINT |
||
| Description | Bezeichnung NVARCHAR (50) |
||
| Description2 | Bezeichnung2 NVARCHAR (100) |
||
| AccountingType | Abrechnungstyp SMALLINT |
||
| DocumentTypeID | Belegart INT |
||
| DueDate | Stichtag Datetime |
||
| PhaseID | PhasenID INT Index |
MARIProjectPhases.PhaseID | |
| PercentageValue | AnteilProzent NUMERIC(19,6) |
||
| PartValue | AnteilWert NUMERIC(19,6) |
||
| PartValueRest | AnteilWertRest NUMERIC(19,6) |
||
| PaymentRequest | GezahltGestellt NUMERIC(19,6) |
||
| PaymentReceived | GezahltErhalten NUMERIC(19,6) |
||
| Status | Status SMALLINT |
||
| TaxCode | Steuercode NVARCHAR (10) |
||
| TaxRate | Steuersatz NUMERIC(19,6) |
||
| TaxClass | Steuerklasse SMALLINT |
||
| TaxManual | SteuerManuell SMALLINT (0=false,-1=true) |
||
| GLAccount | Sachkonto NVARCHAR (20) |
OACT.AcctCode | |
| TaxWtLiable | TaxWtLiable SMALLINT (0=false,-1=true) |
||
| TaxUsage | TaxUsage INT |
||
| TaxCSTcode | TaxCSTcode NVARCHAR (4) |
||
| TaxCFOPcode | TaxCFOPcode NVARCHAR (6) |
||
| DocDate | Belegdatum Datetime |
||
| MARIDocID | MPBelID INT Index |
MARIPurchaseProcessDocument.MARIDocID | |
| OpenItemNumber | OPNr NVARCHAR (50) |
||
| RetainerMin | VorschussMin NUMERIC(19,6) |
||
| RetainerMax | VorschussMax NUMERIC(19,6) |
||
| RetentionMode | RetentionMode INT |
||
| AccountingInfo | Langtext NTEXT |
||
| PositionInfo | Dimensionstext NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIPurchaseProcessPaymentPlan | Purchase Process: Payment plan (not used in PO) |