| Table Name: | MPGebindeZeile |
| View Name: | MARIContainerLine |
| Group: | Group: Container |
| Description: | Container Lines to see the goods in the container |
| ClassID: | 1058. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| GebindeZeilenID | ContainerLineID INT Primary |
||
| GebindeDetailZeilenID | ContainerDetailLineID INT Primary |
||
| GebindeID | ContainerID INT Index |
MPGebinde.GebindeID | |
| Position | Position INT Index |
||
| ZeilenTyp | LineType SMALLINT Index |
||
| DetailTyp | DetailType INT |
||
| Mandant | Company SMALLINT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Schluessel | ClassKey NVARCHAR (50) Index |
||
| SchluesselDetail | ClassSubKey NVARCHAR (20) |
||
| Matchcode | Matchcode NVARCHAR (200) Index |
||
| VertragsID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| Vertragsposition | ContractPositionID INT Index |
MPVKVertraegePositionen.Vertragsposition | |
| EKVorgangsID | PurchaseProcessID INT Index |
MPEKVertraege.VertragsID | |
| EKVorgangsposition | PurchaseProcessPositionID INT |
MPEKVertraegePositionen.Vertragsposition | |
| SerienChargenMode | BatchMode SMALLINT |
||
| PosStatus | PosStatus INT |
MPHotlineSettings.ID (WHERE Setting=32) | |
| Menge | Quantity NUMERIC(19,6) |
||
| MengeAnzahl | QuantityCount NUMERIC(19,6) |
||
| MengeAnzahlText | QuantityCountText NVARCHAR (100) |
||
| Wirkung | Effect INT |
||
| MPBelID | MARIDocID INT Index |
MPVKVertraegeBelege.MPBelID | |
| MPBelPosID | MARIDocPosID INT Index |
MPVKVertraegeBelegePositionen.MPBelPosID | |
| DocumentDraftID | DocumentDraftID INT Index |
MPDocumentDraftHead.DocumentDraftID | |
| DocumentDraftPosID | DocumentDraftPosID INT Index |
MPDocumentDraftPosition.DocumentDraftPosID | |
| DocumentDraftPosLinkID | DocumentDraftPosLinkID INT Index |
MPDocumentDraftPositionLink.DocumentDraftPosLinkID | |
| BruttoGewicht | GrossWeight NUMERIC(19,6) |
||
| Volumen | Volume NUMERIC(19,6) |
||
| AnzahlPakete | NumberOfPakages SMALLINT |
||
| Kennzeichen | Markings NVARCHAR (100) |
||
| ArtVerpackung | MethodOfPacking NVARCHAR (100) |
||
| BezeichnungGut | NatureOfGoods NVARCHAR (100) |
||
| StatistischeWarennummern | IntrastatNumbers NVARCHAR (100) |
||
| DruckMode | PrintMoe SMALLINT |
||
| PlanGebindeKategorie | PlanContainerCategory INT |
MPGebindeKategorie.ContainerCategory | |
| PlanGebindeMenge | PlanContainerID SMALLINT |
MPGebinde.GebindeID | |
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) |
| Table | Description |
|---|---|
| MPDocumentDraftPositionLink | Linked positions in the sales contract and or purchase process |
| MPGebindeZeileSerieCharge | Linked batches of serialnumbers for a line in the container |