| View Name: | MARIContractDownPayments |
| Based on table: | MPVKVertraegeAnzahlungen |
| Group: | Group: Contract |
| Description: | Contract Management: Contract Down Payments |
| ClassID: | 332. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| DownPaymentID | Anzahlung INT Primary |
||
| DownPaymentType | AnzahlungsTyp INT |
1=Down Payment | clsPublicEnums_eContractDownPaymentLineType |
| ContractID | VertragsID INT Index |
MARIContract.ContractID | |
| LineOrder | Reihenfolge SMALLINT |
||
| Description | Bezeichnung NVARCHAR (50) |
||
| Description2 | Bezeichnung2 NVARCHAR (100) |
||
| AccountingType | Abrechnungstyp SMALLINT |
1=Due Date, 2=Phase | |
| DocumentTypeID | Belegart INT |
||
| DueDate | Stichtag Datetime |
||
| PhaseID | PhasenID INT Index |
MARIProjectPhases.PhaseID | |
| PercentageValue | AnteilProzent NUMERIC(19,6) |
100 = 100% | |
| PartValue | AnteilWert NUMERIC(19,6) |
||
| PartValueRest | AnteilWertRest NUMERIC(19,6) |
||
| PayedCreated | GezahltGestellt NUMERIC(19,6) |
||
| PayedReceived | 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 |
MARIContractDocument.MARIDocID | |
| OpenItemNumber | OPNr NVARCHAR (50) |
||
| RetentionMin | VorschussMin NUMERIC(19,6) |
||
| RetentionMax | VorschussMax NUMERIC(19,6) |
||
| RetentionMode | RetentionMode INT |
0=With out retention value, 1=Subtract retention first | |
| AccountingInfo | Langtext NTEXT |
||
| PositionInfo | Dimensionstext NTEXT |
||
| OptionMemo | OptionMemo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIContractInstallmentPlan | Contract Management: Contract Invoicing plan |