| Table Name: | MPGebinde |
| View Name: | MARIContainer |
| Group: | |
| Description: | Definition of a container carrying other goods |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| GebindeID | ContainerID INT Primary |
||
| GebindeKategorie | ContainerCategory INT Index |
MPGebindeKategorie.GebindeKategorie | |
| Bezeichnung | Description NVARCHAR (50) Index |
||
| Mandant | Company SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| Projekt | ProjectNumber NVARCHAR (20) Index |
MPProjektstamm.Projektnummer | |
| VertragsID | ContractID INT Index |
MPVKVertraege.VertragsID | |
| Vertragsposition | ContractPositionID INT |
MPVKVertraegePositionen.Vertragsposition | |
| EKVorgangsID | PurchaseProcessID INT Index |
MPEKVertraege.VertragsID | |
| EKVorgangsposition | PurchaseProcessPositionID INT |
MPEKVertraegePositionen.Vertragsposition | |
| FrachtEKVorgangsID | FreightPurchaseProcessID INT Index |
MPEKVertraege.VertragsID | |
| FrachtEKVorgangsPosition | FreightPurchaseProcessPositionID INT |
MPEKVertraegePositionen.Vertragsposition | |
| FrachtFuehrerCardCode | CarrierCardCode NVARCHAR (20) |
OCRD.CardCode | |
| FrachtFuehrerAnsprech | CarrierContactPerson INT |
OCPR.CntctCode | |
| EigentuemerCardCode | OwnerCardCode NVARCHAR (20) |
OCRD.CardCode | |
| EigentuemerAnsprech | OwnerContactPerson INT |
OCPR.CntctCode | |
| GebindeStatus | ContainerStatus SMALLINT Index |
MPHotlineSettings.ID (WHERE Setting=31) | |
| GruppenID1 | GroupID1 INT Index |
MPGruppen.GruppenID (WHERE Gruppenart=10703) | |
| GruppenID2 | GroupID2 INT Index |
MPGruppen.GruppenID (WHERE Gruppenart=10704) | |
| GruppenID3 | GroupID3 INT Index |
MPGruppen.GruppenID (WHERE Gruppenart=10705) | |
| Height1 | Height1 NUMERIC(19,6) |
||
| Hght1Unit | Hght1Unit SMALLINT |
||
| Width1 | Width1 NUMERIC(19,6) |
||
| Wdth1Unit | Wdth1Unit SMALLINT |
||
| Length1 | Length1 NUMERIC(19,6) |
||
| Len1Unit | Len1Unit SMALLINT |
||
| Volume | Volume NUMERIC(19,6) |
||
| VolUnit | VolUnit SMALLINT |
||
| Weight1 | Weight1 NUMERIC(19,6) |
||
| Wght1Unit | Wght1Unit SMALLINT |
||
| Height2 | Height2 NUMERIC(19,6) |
||
| Hght2Unit | Hght2Unit SMALLINT |
||
| Width2 | Width2 NUMERIC(19,6) |
||
| Wdth2Unit | Wdth2Unit SMALLINT |
||
| Length2 | Length2 NUMERIC(19,6) |
||
| Len2Unit | Len2Unit SMALLINT |
||
| Volume2 | Volume2 NUMERIC(19,6) |
||
| Vol2Unit | Vol2Unit SMALLINT |
||
| Weight2 | Weight2 NUMERIC(19,6) |
||
| Wght2Unit | Wght2Unit SMALLINT |
||
| Erstanlage | CreateDate Datetime |
||
| ErstanlageID | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Aenderung | ChangeDate Datetime |
||
| AenderungID | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| InAktiv | Inactive SMALLINT (0=false,-1=true) Index |
||
| GebindeMemo | ContainerMemo NTEXT |
||
| GebindeHinweis | ContainerHint NTEXT |
||
| GebindeProtokoll | ContainerLog NTEXT |
||
| GebindeEinstellungen | ContainerSettings NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPEKVertraegeBelege | Purchase Process: Purchase Document (Header) |
| MPGebindeAdresse | Addtional information for trucks as container for shipping |
| MPGebindeLocation | Current location of a container |
| MPGebindeZeile | Container Lines to see the goods in the container |
| MPGebindeZeileSerieCharge | Linked batches of serialnumbers for a line in the container |
| MPVKVertraegeBelege | Contract Management: Sales Documents |