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