| View Name: | MARITempReportDocumentPos |
| Based on table: | MPTmpRptPrintPositionen |
| Group: | Group: TempReportDocumentHeader |
| Description: | Reporting: Temporary Table: Document Positions |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ConnectionID | ConnectionID INT Primary |
||
| MARIDocID | MPBelID INT Primary |
MARIContractDocument.MARIDocID | |
| ID | ID INT Primary |
||
| PositionType | PositionsTyp INT |
||
| PositionText | Position NVARCHAR (50) |
||
| ItemCode | Artikelnummer NVARCHAR (50) |
OITM.ItemCode | |
| SubCatalogNum | SubCatNum NVARCHAR (50) |
||
| SourceKeyType | SourceKeyType INT |
||
| SourceKey | SourceKey NVARCHAR (20) |
||
| Description1 | Bezeichnung1 NVARCHAR (200) |
||
| Description2 | Bezeichnung2 NVARCHAR (200) |
||
| DeliveryWeekText | Lieferwoche NVARCHAR (8) |
||
| LeadTime | Lieferzeit INT |
||
| DeliveryDate | Lieferdatum Datetime |
||
| RentalStartDate | MietStartDatum Datetime |
||
| RentalEndDate | MietEndDatum Datetime |
||
| QuantityText | Menge NVARCHAR (20) |
||
| QuantityNumber | MengeZahl NUMERIC(19,6) |
||
| UoM | Mengeneinheit NVARCHAR (20) |
||
| OrderQuantityText | BestellMenge NVARCHAR (20) |
||
| OrderQuantityNumber | BestellMengeZahl NUMERIC(19,6) |
||
| QuantityCount | MengeAnzahl NUMERIC(19,6) |
||
| QuantityDuration | MengeDauer NUMERIC(19,6) |
||
| QuantityCountUnit | MengeAnzahlEinheit NVARCHAR (20) |
||
| QuantityCountText | MengeAnzahlText NVARCHAR (100) |
||
| QuantityFormularID | MengenFormelID INT Index |
MARISetupQuantityFormular.QuantityFormularID | |
| BasisAnzahl | BasisAnzahl NUMERIC(19,6) |
||
| NetUnitPriceFC | Einzelpreis NUMERIC(19,6) |
||
| NetTotalFC | Gesamtpreis NUMERIC(19,6) |
||
| TaxCode | Steuercode NVARCHAR (10) |
||
| TaxValueFC | Steuerbetrag NUMERIC(19,6) |
||
| TaxRate | Steuersatz NUMERIC(19,6) |
||
| TaxWtLiable | TaxWtLiable SMALLINT (0=false,-1=true) |
||
| TaxUsage | TaxUsage INT |
||
| TaxCSTcode | TaxCSTcode NVARCHAR (4) |
||
| TaxCFOPcode | TaxCFOPcode NVARCHAR (6) |
||
| LocationID | LocationID INT |
||
| DiscountPercent | Rabatt NUMERIC(19,6) |
||
| DiscountValueFc | Rabattbetrag NUMERIC(19,6) |
||
| AccountingInfo | Langtext NTEXT |
||
| PositionInfo | Dimensionstext NTEXT |
||
| QuantityCalculation | Mengenberechnung NVARCHAR (100) |
||
| QuantityUnits | Mengeneinheiten NVARCHAR (50) |
||
| PriceUnit | Preiseinheit INT |
||
| Warehouse | Lagerort NVARCHAR (110) |
OWHS.WhsCode | |
| BinLocations | LagerPlaetze NTEXT |
||
| BinLocationsCount | LagerplatzAnzahl INT |
||
| SourceWarehouse | Quelllager NVARCHAR (110) |
OWHS.WhsCode | |
| SourceWarehouseCount | QuelllagerAnzahl INT |
||
| PriceUnitText | PreiseinheitText NVARCHAR (15) |
||
| DiscountText | RabattText NVARCHAR (100) |
||
| PercentText | ProzentText NVARCHAR (3) |
||
| BillOfMaterialText | StuecklistenText NVARCHAR (20) |
||
| OrderDateText | BestelldatenText NVARCHAR (30) |
||
| OrderNumber | Bestellnummer NVARCHAR (40) |
||
| ReferenceDescription1 | Referenzbezeichnung1 NVARCHAR (100) |
||
| ReferenceDescription2 | Referenzbezeichnung2 NVARCHAR (100) |
||
| UnitPriceEUR | EinzelpreisEuro NUMERIC(19,6) |
||
| TotalEUR | GesamtpreisEuro NUMERIC(19,6) |
||
| DiscountValueEUR | RabattbetragEuro NUMERIC(19,6) |
||
| TaxValueEUR | SteuerbetragEuro NUMERIC(19,6) |
||
| CurrencyEUR | WkzEuro NVARCHAR (50) |
||
| DateInfo | Termin Datetime |
||
| RemainingQuantity | Restmenge NUMERIC(19,6) |
||
| RemainingQuantityText | RestmengenText NVARCHAR (30) |
||
| BaseUnit | GrundEinheit NVARCHAR (5) |
||
| BasePrice | GrundPreis NUMERIC(19,6) |
||
| BasePriceText | GrundpreisText NVARCHAR (50) |
||
| QuantityPackText | MengePack NVARCHAR (20) |
||
| QuantityPack | MengePackZahl NUMERIC(19,6) |
||
| PurchaseQuantityPackText | BestellMengePack NVARCHAR (20) |
||
| PurchaseQuantityPack | BestellMengePackZahl NUMERIC(19,6) |
||
| BacklockQuantityPack | RestmengePack NUMERIC(19,6) |
||
| UnitPack | MengeneinheitPack NVARCHAR (20) |
||
| SerialNumberFlag | SeriennummernFlagg SMALLINT (0=false,-1=true) |
||
| ItemFreeText | ItemFreeText NVARCHAR (100) |
||
| ItemDetails | ItemDetails NTEXT |
||
| ProjectNumber | Projektnummer NVARCHAR (20) |
MARIProjectMaster.ProjectNumber | |
| ContractID | Vertrag INT |
MARIContract.ContractID | |
| ContractPositionID | Vertragsposition INT |
MARIContractPositions.ContractPositionID | |
| MARIDocPosID | MPBelPosID INT |
MARIContractDocumentPositions.MARIDocPosID | |
| QualityStatus | QualityStatus INT |
MARIQualityStatus.QualityStatus (WHERE ClassID=71) | |
| QualityStatusText | QualityStatusText NVARCHAR (50) |
MARIQualityStatus.QualityStatusText | |
| 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) |
||
| ServiceStartDate | WartungStart Datetime |
||
| ServiceEndDate | WartungEnde 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) |