backup_ services_ contact_uuid

SREL

cnt

Specifies the name of the contact responsible for backup services.

billing_contact_ uuid

SREL

cnt

Specifies the name of the contact responsible for billing.

disaster_ recovery_ contact_uuid

SREL

cnt

Specifies the name of the contact responsible for disaster recovery services.

id

id

UUID

network_contact_uuid

SREL

cnt

Specifies the name of the contact responsible for network operations.

producer_id

producer_id

LOCAL STRING 30

persistent_id

persid

LOCAL STRING 60

chgnr

chgnr

LREL

chg asset

issnr

issnr

LREL

iss asset

cntref

cntref

LREL

cnt:PDM cenv

orgref

orgref

LREL

org:PDM oenv

acquire_date

acquire_date

LOCAL_TIME

asset_source_ uuid

asset_source_ uuid

UUID

loc_cabinet

cabinet_location

STRING

company_bought_ for_uuid

company_bought_for_uuid

UUID

ca_company company_uuid

expense_code

cost_center

INTEGER

ca_resource_ cost_center id

creation_date

creation_date

LOCAL_TIME

creation_system

creation_system

STRING

creation_user

creation_user

STRING

delete_time

delete_time

LOCAL_TIME

department

department

INTEGER

ca_resource_ department id

exclude_ registration

exclude_ registration

INTEGER

expense_code

expense_code

SREL

cost_cntr

loc_floor

floor_location

STRING

gl_code

gl_code

integer

support_contact1_uuid

SREL

cnt

Specifies the name of the first contact responsible for support services.

support_contact2_uuid

SREL

cnt

Specifies the name of the second contact responsible for support services.

support_contact3_uuid

SREL

cnt

Specifies the name of the third contact responsible for support services.

system_name

host_name

STRING

delete_flag

inactive

integer

actbool enum

install_date

installation_date

LOCAL_TIME

alarm_id

ip_address

STRING

last_mod

last_update_date

LOCAL_TIME

last_mod_by

last_update_user

STRING

license_number

license_ information

STRING

license_uuid

license_uuid

UUID

location

location_uuid

UUID

ca_location location_uuid

mac_address

mac_address

STRING 64

dns_name

dns_name

STRING 100

repair_org

maintenance_ org_uuid

UUID

ca_organization uuid

vendor_repair

maintenance_ vendor_uuid

UUID

ca_company company_uuid

manufacturer

manufacturer_ uuid

UUID

ca_company company_uuid

model

model_uuid

UUID

ca_model_def model_uuid

product_version

product_version

STRING 16

operating_system

operating_system

INTEGER

org_bought_for_ uuid

org_bought_for_ uuid

UUID

ca_organization uuid

id

own_resource_ uuid

UUID

UNIQUE REQUIRED KEY

product_version

product_version

STRING

purchase_order_id

purchase_order_id

STRING

requisition_id

requisition_id

STRING

resource_alias

resource_alias

STRING

class

resource_class

INTEGER

ca_resource_ class id

resource_contact

resource_contact_uuid

UUID

ca_contact uuid

description

resource_ description

STRING

ufam

ufam

INTEGER

is_selected

is_selected

LOCAL INTEGER

family

resource_family

INTEGER

ca_resource_ family id

name

resource_name

STRING

resource_owner_ uuid

resource_owner_ uuid

UUID

ca_contact uuid

asset_count

resource_quantity

INTEGER

status

resource_status

INTEGER

ca_resource_ status id

asset_num

resource_tag

STRING

child_hier

child_hier

BREL

hier.parent

parent_hier

parent_hier

BREL

hier.child

asset_log

asset_log

BREL

nr_com.asset_ id

assoc_cr

assoc_cr

QREL

cr

all_creq

all_creq

BREL

cr.affected_ resource

all_open_creq

all_open_creq

QREL

cr

bm_child_hier

bm_child_hier

QREL

bmhier

bm_parent_hier

bm_parent_hier

QREL

bmhier

assoc_reqs

assoc_reqs

QREL

cr

service_org

responsible_org_ uuid

UUID

ca_organization uuid

vendor_restore

responsible_ vendor_uuid

UUID

ca_company company_uuid

loc_room

room_location

STRING

serial_number

serial_number

STRING

loc_shelf

shelf_location

STRING

loc_slot

slot_location

STRING

status_date

status_date

LOCAL_TIME

supplier

supply_vendor_ uuid

UUID

ca_company company_uuid

version_number

version_number

INTEGER