Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
APUD_AH_Idnr int NUMBER(38,0) int int false RunID
APUD_OPU_Lnr smallint NUMBER(38,0) smallint smallint false OPU_Lnr
APUD_VName varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Variable name of the Prompt Set Element
APUD_PName varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Prompt Set Name
APUD_HasList smallint NUMBER(38,0) smallint smallint true Has OPUDA entries for MULTI+Array (Checkbox, Checklist)
APUD_Value varchar(max) CLOB clob(20480 k) INLINE LENGTH 1024 COMPACT text true String representation of value
APUD_MsgNr int NUMBER(38,0) int int true Indicates whether the value has already been validated (-1 not checked, 0 check ok, >1 check wrong)
APUD_MsgInsert varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true Inserts f�r EPUD_MsgNr
APUD_Format varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) true Output-format of value
APUD_MultiSelect smallint NUMBER(38,0) smallint smallint true Multi select allowed
APUD_SeparatedBy char (1) CHAR (1 CHAR) char(1) char (1) true Value Separator for multi select without list
APUD_Quotes char (1) CHAR (1 CHAR) char(1) char (1) true Quote character
APUD_Order smallint NUMBER(38,0) smallint smallint true Display Order in GUI
APUD_OPSE_Lnr smallint NUMBER(38,0) smallint smallint true Prompt Set Element Line number (for UI order)
APUD_Key varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Used for XML-Variable contains key of the Variable-Object (OVW_VValue)
APUD_XPath varchar(1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar(1024) true XPath expression for XML-Variable

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_APUD APUD_AH_Idnr, APUD_OPU_Lnr, APUD_VName true true false false

Foreign Keys:

Name Local References Foreign References
FK_APUD_AH APUD_AH_Idnr AH_Idnr

Return to the Index File