arg_extsys

Contains information about external system objects mapped to UFAM objects

Column Name Column Datatype Column Null Option Column Comment
esid integer not null External system ID. First part of the primary key.
object_uuid byte(16) not null Mapped object. Second part of the primary key. Foreign key to one of the following fields: ca_company.company_uuid, ca_contact.contact_uuid, ca_location.location_uuid, ca_owned_resource.own_resource_uuid, ca_model_def.model_uuid, arg_legaldoc.legaldoc_uuid
esivid smallint not null Version. Third part of the primary key. Second part of the primary key. Foreign key to one of the following fields: arg_itemver.ivid, arg_assetver.avivid
esobty smallint with null Object type
esvalue1 nvarchar(50) with null Match Value 1
esvalue2 nvarchar(50) with null Match Value 2
esvalue3 nvarchar(50) with null Match Value 3
esvalue4 nvarchar(50) with null Match Value 4
esvalue5 nvarchar(50) with null Match Value 5
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.