Framework:Objects to save data: Difference between revisions

From CoPlanner 10
Jump to navigationJump to search
VisualWikitext
Created page with 'The CoPlanner user can save data in tables and dimension objects. All data objects contain the following system fields: '''Standardfelder''' {| style=cellspacing="1" cellpadd…'
 
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
The CoPlanner user can save data in tables and dimension objects.
The CoPlanner user can save data in [[Framework:Tables|tables]] and [[Framework:Dimensions|dimension objects]].


All data objects contain the following system fields:
All data objects contain the following system fields:




'''Standardfelder'''
'''Standard fields'''


{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|100%}}}
{| class="wikitable" width={{{breite|100%}}}
|-
|- {{Tabellentitel}}
|width="200pt" style=background-color:#f6f6f6 |'''''Feld''''' 
|width="200pt" |Field
|style=background-color:#f6f6f6 |'''''Beschreibung'''''
|Description
|-
|-
|"COPSYS_ID"
|"COPSYS_ID"
|Eindeutiger Schlüssel der Tabelle. Ist immer ein positiver Ganzzahlwert
|Unique key of the table. It is always a positive integer.
|-
|-
|"COPSYS_CREDATE"
|"COPSYS_CREDATE"
|Datum der Erstellung des Datensatzes
|Date of the creation of the dataset
|-
|-
|"COPSYS_CREUSER"
|"COPSYS_CREUSER"
|ID des Users welcher den Datensatze erstellt hat
|ID of the user who created the dataset
|-
|-
|"COPSYS_MODDATE"
|"COPSYS_MODDATE"
|Datum der letzten Änderung
|Date of the last modification
|-
|-
|"COPSYS_MODUSER"
|"COPSYS_MODUSER"
|User welcher die letzte Änderung vorgenommen hat
|User who carried out the last modification
|-
|-
|"COPSYS_LOCKED"
|"COPSYS_LOCKED"
|Zahl welche bestimmt in welchem Sperrzustand sich der Datensatz befindet. 0=nicht gesperrt (default), 2 = gesperrt
|Number that determines the locking status of the dataset. 0=not locked (Default), 2 = locked
|-
|-
|"COPSYS_PLAN_ID"
|"COPSYS_PLAN_ID"
|ID des Planes zu dem dieser Datensatz gehört. Falls die Tabelle nicht planabhängig ist wird –1 gespeichert (Standardwert)
|ID of the plan to which this dataset belongs. If the table is not plan-dependant, –1 (default value) will be saved
|-
|-
|"COPSYS_KURS_ID"
|"COPSYS_KURS_ID"
|ID des Kurses, in welcher der Datensatz eingegeben wurde. (gespeichert wird immer in Einheitswährung!)
|ID of the exchange rate in which the dataset was entered. (saving is always carried out in uniform currency!)
|}
|}




'''Felder für Formeln'''
'''Fields for formulae'''


{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|100%}}}
{| class="wikitable" width={{{breite|100%}}}
|-
|- {{Tabellentitel}}
|width="200pt" style=background-color:#f6f6f6 |'''''Feld''''' 
|width="200pt" |Field
|style=background-color:#f6f6f6 |'''''Beschreibung'''''
|Description
|-
|-
|"COPSYS_HK_ROW"
|"COPSYS_HK_ROW"
|ID der Tabelle aus welcher dieser Datensatz erzeugt wurde (Falls Datensatz nicht über Formel erstellt wurde –1)
|ID of the table from which this dataset was generated (if dataset was not generated by a formula: –1)
|-
|-
|"COPSYS_HK_TABLE"
|"COPSYS_HK_TABLE"
|Tabelle (Systemname) aus welcher der Datensatz per Formel erstellt wurde. Falls manuell eingegeben Name der eigenen Tabelle
|Table (system name) from which the dataset was generated by a formula. In case of manual entry, name of own table
|-
|-
|"COPSYS_HK_FORMEL"
|"COPSYS_HK_FORMEL"
|COPSYSID der Formel  & „_„ & Aktuelle Iteration der Formel aus welcher der Datensatz generiert wurde. Falls nicht aus Formel „-1“.
|COPSYSID of the formula & „_„ & Current iteration of the formula from which the dataset was generated. If not from formula: “-1”.
|}
|}




'''Felder für Dimensionen'''
'''Fields for dimensions'''


{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|100%}}}
{| class="wikitable" width={{{breite|100%}}}
|-
|- {{Tabellentitel}}
|width="200pt" style=background-color:#f6f6f6 |'''''Feld''''' 
|width="200pt" |Field
|style=background-color:#f6f6f6 |'''''Beschreibung'''''
|Description
|-
|-
|"COPSYS_DIM_NAME"
|"COPSYS_DIM_NAME"
|Name des Dimensionselementes (Bei Tabellen wird der Text „Tab“ eingetragen.
|Name of the dimension element (for tables, the text “Tab” is entered).
|-
|-
|"COPSYS_DIM_ID"
|"COPSYS_DIM_ID"
|Eindeutige ID der Dimension. Bei Tabellen immer 0 (Standardwert)
|Unique ID of the dimension. In case of tables, always 0 (default value)
|-
|-
|"COPSYS_DIM_PID"
|"COPSYS_DIM_PID"
|Eindeutige ID des übergeordneten Elements in der Dimension. Bei Tabellen immer 2 (Standardwert)
|Unique ID of the superordinated (higher level) elements in the dimension. In case of tables, always 2 (default value)
|-
|-
|"COPSYS_ORDER"
|"COPSYS_ORDER"
|Reihenfolge des Elements innerhalb der selben Ebene unterhalb des Parentelementes. (Sortierung erfolgt nicht alphanumerisch)
|Order of the element within the same level underneath the parent element. (sorting not alphanumerical)
|}
|}




{| {{Bausteindesign1}}
{| {{Bausteindesign1}}
|-
|-
| <span style="color: darkblue;">'''Hinweis'''</span> &nbsp;Diese Systemfelder können nicht geändert werden und scheinen auch nicht im jeweiligen Designer auf. Wird eine Tabelle aus der [[Framework:Objektverwaltung|Objektverwaltung]] geöffnet, sind diese Felder jedoch sichtbar.
| <span style="color: darkblue;">'''Hint'''</span> &nbsp;These system fields cannot be changed and do not show up in the corresponding designer. However, if a table is opened from the object administration, these fields are visible.  
|}
|}


Latest revision as of 08:08, 6 March 2012

The CoPlanner user can save data in tables and dimension objects.

All data objects contain the following system fields:


Standard fields

Field Description
"COPSYS_ID" Unique key of the table. It is always a positive integer.
"COPSYS_CREDATE" Date of the creation of the dataset
"COPSYS_CREUSER" ID of the user who created the dataset
"COPSYS_MODDATE" Date of the last modification
"COPSYS_MODUSER" User who carried out the last modification
"COPSYS_LOCKED" Number that determines the locking status of the dataset. 0=not locked (Default), 2 = locked
"COPSYS_PLAN_ID" ID of the plan to which this dataset belongs. If the table is not plan-dependant, –1 (default value) will be saved
"COPSYS_KURS_ID" ID of the exchange rate in which the dataset was entered. (saving is always carried out in uniform currency!)


Fields for formulae

Field Description
"COPSYS_HK_ROW" ID of the table from which this dataset was generated (if dataset was not generated by a formula: –1)
"COPSYS_HK_TABLE" Table (system name) from which the dataset was generated by a formula. In case of manual entry, name of own table
"COPSYS_HK_FORMEL" COPSYSID of the formula & „_„ & Current iteration of the formula from which the dataset was generated. If not from formula: “-1”.


Fields for dimensions

Field Description
"COPSYS_DIM_NAME" Name of the dimension element (for tables, the text “Tab” is entered).
"COPSYS_DIM_ID" Unique ID of the dimension. In case of tables, always 0 (default value)
"COPSYS_DIM_PID" Unique ID of the superordinated (higher level) elements in the dimension. In case of tables, always 2 (default value)
"COPSYS_ORDER" Order of the element within the same level underneath the parent element. (sorting not alphanumerical)


Hint  These system fields cannot be changed and do not show up in the corresponding designer. However, if a table is opened from the object administration, these fields are visible.
Retrieved from "https://copsupport.coplanner.com/help10_en/index.php?title=Framework:Objects_to_save_data&oldid=12771"