| View Name: | MARIBatchnumbers |
| Based on table: | MPChargennummern |
| Group: | |
| Description: | Virtual Batch reservation for future real batches |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| MPBatchID | MPChargeID INT Primary |
||
| ItemCode | ItemCode NVARCHAR (50) Index |
||
| Company | Mandant SMALLINT Index |
MARISysConnections.Company (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 |
||
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIDocumentDraftPositionLinkBatch | Used batches |
| MARIDocumentDraftPositionLinkSerial | Used/reserved serial numbers |
| MARIPurchaseProcessDocumentPositionsBatches | Purchase Process: Purchase Document (Positions+Batches) |
| MARIPurchaseProcessDocumentPositionsSerialNumbers | Purchase Process: Purchase Document (Positions+Serial) |
| MARIPurchaseProcessPositionBatch | Purchase Process: Reservation of batches |
| MARIContainerBatchSN | Linked batches of serialnumbers for a line in the container |
| MARIContractDocumentPositionsBatches | Contract Management: Document Positions Batches |
| MARIContractDocumentPositionsSerialNumbers | Contract Management: Document Positions Serial Numbers |
| MARIContractPositionPositionBatches | Contract Position Reservation of batches |
| MARIWorkItemPositionSerial | Serialnumbers, Batchnumbers for work item positions |