| Table Name: | MPSetupMengenFeldBasis |
| View Name: | MARISetupQuantityFieldBase |
| Group: | |
| Description: | Field definition for quantity formular |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| MengenFormelBasisFeldID | QuantityFieldBaseID INT Primary |
||
| MengenTyp | QuantityType INT Index |
||
| Bezeichnung | Description NVARCHAR (100) |
||
| MengenEinheitsTyp | QuantityUnitType SMALLINT |
||
| AktivMode | ActiveMode SMALLINT |
||
| Zaehler2Basis | Numerator2Base NUMERIC(19,6) |
||
| Nenner2Basis | Denominator2Base NUMERIC(19,6) |
||
| 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 |
|---|---|
| MPDocumentDraftPosition | Positions based on the order of the paper document |
| MPSetupMengenFeldBasisMandant | Link to UDF in the company |
| MPSetupMengenFormelFelder | Quantity Formular Lines |
| MPWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |