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