| View Name: | MARITempReportDocumentPosSerialNumbers |
| Based on table: | MPTmpRptPrintPositionenSerien |
| Group: | Group: TempReportDocumentHeader |
| Description: | Reporting: Temporary Table: Document Positions Serial Numbers |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ConnectionID | ConnectionID INT Primary |
||
| ID | ID INT Primary |
||
| Line | Line INT Primary |
||
| Type | Type INT |
||
| SysSerial | SysSerial INT |
||
| SuppSerial | SuppSerial NVARCHAR (36) |
||
| UniqueSerial | UniqueSerial NVARCHAR (36) |
||
| IntrSerial | IntrSerial NVARCHAR (36) |
||
| BatchID | BatchID NVARCHAR (36) |
||
| LotNumber | LotNumber NVARCHAR (36) |
||
| Quantity | Menge NUMERIC(19,6) |
||
| ExpDate | ExpDate Datetime |
||
| MnfDate | MnfDate Datetime |
||
| InDate | InDate Datetime |
||
| GrntStart | GrntStart Datetime |
||
| GrntExp | GrntExp Datetime |
||
| Warehouse | Warehouse NVARCHAR (110) |
OWHS.WhsCode | |
| BinLocationAbsID | BinLocationAbsID INT |
||
| BinCode | BinCode NVARCHAR (228) |
||
| SL1Code | SL1Code NVARCHAR (50) |
||
| SL2Code | SL2Code NVARCHAR (50) |
||
| SL3Code | SL3Code NVARCHAR (50) |
||
| SL4Code | SL4Code NVARCHAR (50) |
||
| FromWarehouse | FromWarehouse NVARCHAR (110) |
OWHS.WhsCode | |
| FromBinLocationAbsID | FromBinLocationAbsID INT |
||
| FromBinCode | FromBinCode NVARCHAR (228) |
||
| FromSL1Code | FromSL1Code NVARCHAR (50) |
||
| FromSL2Code | FromSL2Code NVARCHAR (50) |
||
| FromSL3Code | FromSL3Code NVARCHAR (50) |
||
| FromSL4Code | FromSL4Code NVARCHAR (50) |
||
| EquipmentCode | EquipmentCode NVARCHAR (20) |
MARIEquipmentMaster.EquipmentCode | |
| MPInsID | MPInsID INT |
MARICustomerServiceObject.MPInsID |