Name | Type MSSql | Type Oracle | Type DB2 | Nullable | Description |
---|---|---|---|---|---|
OSA_OH_Idnr | int | NUMBER(38,0) | int | false | reference to the object header (OH) |
OSA_StartType | varchar (200) | VARCHAR2 (200 CHAR) | varchar(200) | true | start type |
OSA_IntAccount | varchar (16) | VARCHAR2 (16 CHAR) | varchar(16) | true | account |
OSA_ActAtRun | smallint | NUMBER(38,0) | smallint | true | gereration at runtime? |
OSA_Period | smallint | NUMBER(38,0) | smallint | true | period in days |
OSA_StartTime | datetime | DATE | timestamp | true | starting time of the period |
OSA_RWhen | varchar (30) | VARCHAR2 (30 CHAR) | varchar(30) | true | ok state global result |
OSA_RExecute | varchar (200) | VARCHAR2 (200 CHAR) | varchar(200) | true | global altering object |
Name | Fields | Primary | Unique | Clustered | Nonclustered |
---|---|---|---|---|---|
PK_OSA | OSA_OH_Idnr | true | true | true | false |
Name | Local References | Foreign References |
---|---|---|
FK_OSA_OH | OSA_OH_Idnr | OH_Idnr |
Return to the Index File