Framework:Objects to save data

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.