| Table Name: | MPChargennummern |
| View Name: | MARIBatchnumbers |
| Group: | |
| Description: | Virtual Batch reservation for future real batches |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MPChargeID | MPBatchID INT Primary |
||
| ItemCode | ItemCode NVARCHAR (50) Index |
||
| Mandant | Company SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| ItemManagementType | ItemManagementType INT |
||
| DistNumber | DistNumber NVARCHAR (36) Index |
||
| MnfSerial | MnfSerial NVARCHAR (36) |
||
| LotNumber | LotNumber NVARCHAR (36) |
||
| ExpDate | ExpDate Datetime |
||
| MnfDate | MnfDate Datetime |
||
| InDate | InDate Datetime |
||
| GrntStart | GrntStart Datetime |
||
| GrntExp | GrntExp Datetime |
||
| Notes | Notes NTEXT |
||
| AutoCreationRule | AutoCreationRule INT |
||
| AutoCreationValue | AutoCreationValue NVARCHAR (255) |
||
| AutoCreationLastValue | AutoCreationLastValue INT |
||
| InAktiv | Inactive SMALLINT (0=false,-1=true) Index |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPDocumentDraftPositionLinkBatch | Used batches |
| MPDocumentDraftPositionLinkSerial | Used/reserved serial numbers |
| MPEKVertraegeBelegePositionenCharge | Purchase Process: Purchase Document (Positions+Batches) |
| MPEKVertraegeBelegePositionenSerie | Purchase Process: Purchase Document (Positions+Serial) |
| MPEKVertraegePositionenCharge | Purchase Process: Reservation of batches |
| MPGebindeZeileSerieCharge | Linked batches of serialnumbers for a line in the container |
| MPVKVertraegeBelegePositionenCharge | Contract Management: Document Positions Batches |
| MPVKVertraegeBelegePositionenSerie | Contract Management: Document Positions Serial Numbers |
| MPVKVertraegePositionenCharge | Contract Position Reservation of batches |
| MPWorkItemPositionSerial | Serialnumbers, Batchnumbers for work item positions |