| Table Name: | MPTmpRptPrintPositionen |
| View Name: | MARITempReportDocumentPos |
| Group: | Group: TempReportDocumentHeader |
| Description: | Reporting: Temporary Table: Document Positions |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ConnectionID | ConnectionID INT Primary |
||
| MPBelID | MARIDocID INT Primary |
MPVKVertraegeBelege.MPBelID | |
| ID | ID INT Primary |
||
| PositionsTyp | PositionType INT |
||
| Position | PositionText NVARCHAR (50) |
||
| Artikelnummer | ItemCode NVARCHAR (50) |
OITM.ItemCode | |
| SubCatNum | SubCatalogNum NVARCHAR (50) |
||
| SourceKeyType | SourceKeyType INT |
||
| SourceKey | SourceKey NVARCHAR (20) |
||
| Bezeichnung1 | Description1 NVARCHAR (200) |
||
| Bezeichnung2 | Description2 NVARCHAR (200) |
||
| Lieferwoche | DeliveryWeekText NVARCHAR (8) |
||
| Lieferzeit | LeadTime INT |
||
| Lieferdatum | DeliveryDate Datetime |
||
| MietStartDatum | RentalStartDate Datetime |
||
| MietEndDatum | RentalEndDate Datetime |
||
| Menge | QuantityText NVARCHAR (20) |
||
| MengeZahl | QuantityNumber NUMERIC(19,6) |
||
| Mengeneinheit | UoM NVARCHAR (20) |
||
| BestellMenge | OrderQuantityText NVARCHAR (20) |
||
| BestellMengeZahl | OrderQuantityNumber NUMERIC(19,6) |
||
| MengeAnzahl | QuantityCount NUMERIC(19,6) |
||
| MengeDauer | QuantityDuration NUMERIC(19,6) |
||
| MengeAnzahlEinheit | QuantityCountUnit NVARCHAR (20) |
||
| MengeAnzahlText | QuantityCountText NVARCHAR (100) |
||
| MengenFormelID | QuantityFormularID INT Index |
MPSetupMengenFormel.MengenFormelID | |
| BasisAnzahl | BasisAnzahl NUMERIC(19,6) |
||
| Einzelpreis | NetUnitPriceFC NUMERIC(19,6) |
||
| Gesamtpreis | NetTotalFC NUMERIC(19,6) |
||
| Steuercode | TaxCode NVARCHAR (10) |
||
| Steuerbetrag | TaxValueFC NUMERIC(19,6) |
||
| Steuersatz | TaxRate NUMERIC(19,6) |
||
| TaxWtLiable | TaxWtLiable SMALLINT (0=false,-1=true) |
||
| TaxUsage | TaxUsage INT |
||
| TaxCSTcode | TaxCSTcode NVARCHAR (4) |
||
| TaxCFOPcode | TaxCFOPcode NVARCHAR (6) |
||
| LocationID | LocationID INT |
||
| Rabatt | DiscountPercent NUMERIC(19,6) |
||
| Rabattbetrag | DiscountValueFc NUMERIC(19,6) |
||
| Langtext | AccountingInfo NTEXT |
||
| Dimensionstext | PositionInfo NTEXT |
||
| Mengenberechnung | QuantityCalculation NVARCHAR (100) |
||
| Mengeneinheiten | QuantityUnits NVARCHAR (50) |
||
| Preiseinheit | PriceUnit INT |
||
| Lagerort | Warehouse NVARCHAR (110) |
OWHS.WhsCode | |
| LagerPlaetze | BinLocations NTEXT |
||
| LagerplatzAnzahl | BinLocationsCount INT |
||
| Quelllager | SourceWarehouse NVARCHAR (110) |
OWHS.WhsCode | |
| QuelllagerAnzahl | SourceWarehouseCount INT |
||
| PreiseinheitText | PriceUnitText NVARCHAR (15) |
||
| RabattText | DiscountText NVARCHAR (100) |
||
| ProzentText | PercentText NVARCHAR (3) |
||
| StuecklistenText | BillOfMaterialText NVARCHAR (20) |
||
| BestelldatenText | OrderDateText NVARCHAR (30) |
||
| Bestellnummer | OrderNumber NVARCHAR (40) |
||
| Referenzbezeichnung1 | ReferenceDescription1 NVARCHAR (100) |
||
| Referenzbezeichnung2 | ReferenceDescription2 NVARCHAR (100) |
||
| EinzelpreisEuro | UnitPriceEUR NUMERIC(19,6) |
||
| GesamtpreisEuro | TotalEUR NUMERIC(19,6) |
||
| RabattbetragEuro | DiscountValueEUR NUMERIC(19,6) |
||
| SteuerbetragEuro | TaxValueEUR NUMERIC(19,6) |
||
| WkzEuro | CurrencyEUR NVARCHAR (50) |
||
| Termin | DateInfo Datetime |
||
| Restmenge | RemainingQuantity NUMERIC(19,6) |
||
| RestmengenText | RemainingQuantityText NVARCHAR (30) |
||
| GrundEinheit | BaseUnit NVARCHAR (5) |
||
| GrundPreis | BasePrice NUMERIC(19,6) |
||
| GrundpreisText | BasePriceText NVARCHAR (50) |
||
| MengePack | QuantityPackText NVARCHAR (20) |
||
| MengePackZahl | QuantityPack NUMERIC(19,6) |
||
| BestellMengePack | PurchaseQuantityPackText NVARCHAR (20) |
||
| BestellMengePackZahl | PurchaseQuantityPack NUMERIC(19,6) |
||
| RestmengePack | BacklockQuantityPack NUMERIC(19,6) |
||
| MengeneinheitPack | UnitPack NVARCHAR (20) |
||
| SeriennummernFlagg | SerialNumberFlag SMALLINT (0=false,-1=true) |
||
| ItemFreeText | ItemFreeText NVARCHAR (100) |
||
| ItemDetails | ItemDetails NTEXT |
||
| Projektnummer | ProjectNumber NVARCHAR (20) |
MPProjektstamm.Projektnummer | |
| Vertrag | ContractID INT |
MPVKVertraege.VertragsID | |
| Vertragsposition | ContractPositionID INT |
MPVKVertraegePositionen.Vertragsposition | |
| MPBelPosID | MARIDocPosID INT |
MPVKVertraegeBelegePositionen.MPBelPosID | |
| QualityStatus | QualityStatus INT |
MPQualityStatus.QualityStatus (WHERE ClassID=71) | |
| QualityStatusText | QualityStatusText NVARCHAR (50) |
MPQualityStatus.Matchcode | |
| VisibleMode | VisibleMode SMALLINT |
||
| DocLineNum | DocLineNum INT |
SBO Document Line Num | |
| DocLineSeq | DocLineSeq INT |
||
| ProfitCenter | ProfitCenter NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=1) | |
| ProfitCenterName | ProfitCenterName NVARCHAR (50) |
||
| ProjectCode | ProjectCode NVARCHAR (20) |
||
| ProjectCodeName | ProjectCodeName NVARCHAR (50) |
||
| OcrCode2 | OcrCode2 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=2) | |
| OcrCode2Name | OcrCode2Name NVARCHAR (50) |
||
| OcrCode3 | OcrCode3 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=3) | |
| OcrCode3Name | OcrCode3Name NVARCHAR (50) |
||
| OcrCode4 | OcrCode4 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=4) | |
| OcrCode4Name | OcrCode4Name NVARCHAR (50) |
||
| OcrCode5 | OcrCode5 NVARCHAR (20) |
OOCR.OcrCode (WHERE [DimCode]=5) | |
| OcrCode5Name | OcrCode5Name NVARCHAR (50) |
||
| PictureImage | PictureImage Image |
||
| VendorNum | VendorNum NVARCHAR (17) |
||
| WartungStart | ServiceStartDate Datetime |
||
| WartungEnde | ServiceEndDate Datetime |
||
| BaseDocEntry | BaseDocEntry INT |
INV1.DocEntry | |
| BaseDocNum | BaseDocNum INT |
OINV.DocNum | |
| BaseDocType | BaseDocType INT |
OINV. | |
| BaseDocLineType | BaseDocLineType INT |
INV1.LineType | |
| BaseDocLineNum | BaseDocLineNum INT |
INV1.LineNum | |
| BaseDocDate | BaseDocDate Datetime |
||
| Height1 | Height1 NVARCHAR (20) |
||
| Hght1Unit | Hght1Unit NVARCHAR (20) |
||
| Width1 | Width1 NVARCHAR (20) |
||
| Wdth1Unit | Wdth1Unit NVARCHAR (20) |
||
| Length1 | Length1 NVARCHAR (20) |
||
| Len1Unit | Len1Unit NVARCHAR (20) |
||
| Volume | Volume NVARCHAR (20) |
||
| VolUnit | VolUnit NVARCHAR (20) |
||
| Weight1 | Weight1 NVARCHAR (20) |
||
| Wght1Unit | Wght1Unit NVARCHAR (20) |