Name Type MSSql Type Oracle Type DB2 Type Postgresql Nullable Description
XRO_Client smallint NUMBER(38,0) smallint smallint false Client
XRO_AH_Idnr int NUMBER(38,0) int int false Run# of object
XRO_RType varchar (4) VARCHAR2 (4 CHAR) varchar(4) varchar (4) false Reporttype (ACT,LOG,...)
XRO_System varchar (32) VARCHAR2 (32 CHAR) varchar(32) varchar (32) false Name of system
XRO_OType varchar (8) VARCHAR2 (8 CHAR) varchar(8) varchar (8) false Object type (JOBS, JOBF)
XRO_Object varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of object
XRO_HostDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of destination host (for FT)
XRO_LoginDst varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true User name in operating system (Destination))
XRO_HostSrc varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true Name of host
XRO_LoginSrc varchar (200) VARCHAR2 (200 CHAR) varchar(200) varchar (200) true User name in operating system (Source)
XRO_TimeStamp1 datetime DATE timestamp timestamp true Start time (object)
XRO_TimeStamp4 datetime DATE timestamp timestamp true End time (object)
XRO_RetCode int NUMBER(38,0) int int true Return code (object)
XRO_Status int NUMBER(38,0) int int true State of object (ENDED_OK, ...)
XRO_RRetCode int NUMBER(38,0) int int true Return code report transfer (0=okay, 4=report incomplete, 8=failed)
XRO_ReportSize int NUMBER(38,0) int int true Size of report in byte
XRO_UserTime int NUMBER(38,0) int int true System info: UserTime object
XRO_KernelTime int NUMBER(38,0) int int true System info: KernelTime object
XRO_CpuTime int NUMBER(38,0) int int true System info: CpuTime object
XRO_Archive1 varchar (512) VARCHAR2 (512 CHAR) varchar(512) varchar (512) true Archive information 1
XRO_Archive2 varchar (512) VARCHAR2 (512 CHAR) varchar(512) varchar (512) true Archive information 2
XRO_CusStatus int NUMBER(38,0) int int true Customer state
XRO_FileFullPath varchar (1024) VARCHAR2 (1024 CHAR) varchar(1024) varchar (1024) true Full path name of output file

Indexes:

Name Fields Primary Unique Clustered Nonclustered
PK_XRO XRO_AH_Idnr, XRO_RType true true true false

Foreign Keys:

Name Local References Foreign References

Return to the Index File