| View Name: | MARIPurchaseProcessDocumentPositionsTax |
| Based on table: | MPEKVertraegeBelegePositionenSteuer |
| Group: | Group: MPEKVertraegeBelege |
| Description: | Purchase Process: Purchase Document (Positions+Tax) |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| MARIDocID | MPBelID INT Index |
MARIPurchaseProcessDocument.MARIDocID | |
| MARIDocPosID | MPBelPosID INT Index |
MARIPurchaseProcessDocumentPositions.MARIDocPosID | |
| MARIDocPosTaxID | MPBelPosSteuerID INT Primary |
||
| TaxCode | Steuercode NVARCHAR (10) |
||
| STATaxCode | SteuercodeSTA NVARCHAR (10) |
OSTA.Code | |
| STAType | SteuerTypSTA INT |
OSTA.Type | |
| TaxRate | Steuersatz NUMERIC(19,6) |
||
| TaxManual | SteuerManuell SMALLINT |
||
| TaxWtLiable | TaxWtLiable SMALLINT |
||
| TaxBaseLC | SteuerBasisLC NUMERIC(19,6) |
||
| TaxBaseFC | SteuerBasisFC NUMERIC(19,6) |
||
| TaxBaseSys | SteuerBasisSys NUMERIC(19,6) |
||
| TaxValueLC | SteuerBetragLC NUMERIC(19,6) |
||
| TaxValueFC | SteuerBetragFC NUMERIC(19,6) |
||
| TaxValueSys | SteuerBetragSys NUMERIC(19,6) |