Name Type MSSql Type Oracle Type DB2 Nullable Description
OYR_OH_Idnr int NUMBER(38,0) int false reference to the object header (OH)
OYR_Lnr smallint NUMBER(38,0) smallint false ascending number
OYR_Action varchar (30) VARCHAR2 (30 CHAR) varchar(30) true sync action
OYR_StatusCheck varchar (30) VARCHAR2 (30 CHAR) varchar(30) true sync state for which this rules are valid
OYR_OperatorCheck char (2) CHAR (2 CHAR) char(2) true comparison operator > < = ...
OYR_ValueCheck int NUMBER(38,0) int false value to compare
OYR_StatusSet varchar (30) VARCHAR2 (30 CHAR) varchar(30) true sync state to be set after application of the rule
OYR_OperatorSet char (2) CHAR (2 CHAR) char(2) true operator to apply + - =
OYR_ValueSet int NUMBER(38,0) int false value to use

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_OYR OYR_OH_Idnr, OYR_Lnr true true true false

Foreign Keys:

Name Local References Foreign References
FK_OYR_OH OYR_OH_Idnr OH_Idnr

Return to the Index File