| View Name: | MARIContainer |
| Based on table: | MPGebinde |
| Group: | |
| Description: | Definition of a container carrying other goods |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| ContainerID | GebindeID INT Primary |
||
| ContainerCategory | GebindeKategorie INT Index |
MARIContainerCategory.ContainerCategory | |
| Description | Bezeichnung NVARCHAR (50) Index |
||
| Company | Mandant SMALLINT Index |
MARISysConnections.Company (WHERE ConnectionType=6) | |
| ProjectNumber | Projekt NVARCHAR (20) Index |
MARIProjectMaster.ProjectNumber | |
| ContractID | VertragsID INT Index |
MARIContract.ContractID | |
| ContractPositionID | Vertragsposition INT |
MARIContractPositions.ContractPositionID | |
| PurchaseProcessID | EKVorgangsID INT Index |
MARIPurchaseProcess.PurchaseProcessID | |
| PurchaseProcessPositionID | EKVorgangsposition INT |
MARIPurchaseProcessPositions.PurchaseProcessPositionID | |
| FreightPurchaseProcessID | FrachtEKVorgangsID INT Index |
MARIPurchaseProcess.FreightPurchaseProcessID | |
| FreightPurchaseProcessPositionID | FrachtEKVorgangsPosition INT |
MARIPurchaseProcessPositions.FreightPurchaseProcessPositionID | |
| CarrierCardCode | FrachtFuehrerCardCode NVARCHAR (20) |
OCRD.CardCode | |
| CarrierContactPerson | FrachtFuehrerAnsprech INT |
OCPR.CntctCode | |
| OwnerCardCode | EigentuemerCardCode NVARCHAR (20) |
OCRD.CardCode | |
| OwnerContactPerson | EigentuemerAnsprech INT |
OCPR.CntctCode | |
| ContainerStatus | GebindeStatus SMALLINT Index |
MARISupportSettings.ContainerStatus (WHERE Setting=31) | |
| GroupID1 | GruppenID1 INT Index |
MARIGroups.GroupID1 (WHERE Gruppenart=10703) | |
| GroupID2 | GruppenID2 INT Index |
MARIGroups.GroupID2 (WHERE Gruppenart=10704) | |
| GroupID3 | GruppenID3 INT Index |
MARIGroups.GroupID3 (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 |
||
| CreateDate | Erstanlage Datetime |
||
| CreateUser | ErstanlageID NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | Aenderung Datetime |
||
| ChangeUser | AenderungID NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Inactive | InAktiv SMALLINT (0=false,-1=true) Index |
||
| ContainerMemo | GebindeMemo NTEXT |
||
| ContainerHint | GebindeHinweis NTEXT |
||
| ContainerLog | GebindeProtokoll NTEXT |
||
| ContainerSettings | GebindeEinstellungen NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARIPurchaseProcessDocument | Purchase Process: Purchase Document (Header) |
| MARIContractDocument | Contract Management: Sales Documents |
| MARIContainerAddress | Addtional information for trucks as container for shipping |
| MARIContainerLocation | Current location of a container |
| MARIContainerLine | Container Lines to see the goods in the container |
| MARIContainerBatchSN | Linked batches of serialnumbers for a line in the container |