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