Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
OYR_OH_Idnr int NUMBER(38,0) int int false ID of the sync object.
OYR_Lnr smallint NUMBER(38,0) smallint smallint false Sequenced number for sync rules.
OYR_Action varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true Defines the sync action.
OYR_StatusCheck varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true The sync state this rule is valid for.
OYR_OperatorCheck char (2) CHAR (2 CHAR) char(2) char (2) true The comparison operator for the check.
OYR_ValueCheck int NUMBER(38,0) int int false The value to compare with.
OYR_StatusSet varchar (30) VARCHAR2 (30 CHAR) varchar(30) varchar (30) true The sync state to be set after the application of the rule.
OYR_OperatorSet char (2) CHAR (2 CHAR) char(2) char (2) true The operator to apply. (e.g. +, -, =)
OYR_ValueSet int NUMBER(38,0) int int false The 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