arg_intrface

Contains information about integrations done with external systems using the ArgisRelay application

Column Name Column Datatype Column Null Option Column Comment
ifdssys nvarchar(50) not null Destination system id. First part of the primary key.
ifdbnbr smallint not null Internal sequence nbr. Second part of the primary key.
ifsrobj nvarchar(20) not null Source object id. Third part of the primary key.
ifseq smallint not null Seq in transaction set. Fourth part of the primary key.
ifdatest date not null Date stamp. Fifth part of the primary key.
ifrectyp integer with null Record type
ifdsobnm nvarchar(50) with null Destination sys obj name
ifdsobid nvarchar(50) with null Destination sys obj id
ifaction nvarchar(10) with null Action to be performed
ifcommnt nvarchar(50) with null Comments
ifdsfld nvarchar(50) with null Object field id
ifdstype nvarchar(5) with null Object field type
ifdsparm nvarchar(255) with null Object field parameter(s)
ifdstext nvarchar(2900) with null Object field text value
ifdsdate date with null Object field date value
ifdsnum float with null Object field number value
ifmsgtxt nvarchar(255) with null Message text
ifsntosc nvarchar(50) with null Send to system
ifsntofl nvarchar(50) with null Send to field
creation_user nvarchar(64) with null User or process that created the record.
creation_date integer with null Creation date
last_update_user nvarchar(64) with null Last update user
last_update_date integer with null Last update date
version_number integer with null Version number

Product Name: Unicenter Asset Portfolio Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.