Vorheriges Thema: Tabelle "usp_outage_type"Nächstes Thema: Tabelle "USP_Preferences"


Tabelle „usp_owned_resource“

Enthält Informationen zu der eigenen Ressource.

Attribut

DB-Feld

Datentyp

SREL-Verweise

Markierungen

argis_id

nr_argis_id

STRING

 

 

assoc_projex

assoc_projex

BREL

projex.id

 

audit_userid

audit_userid

LOCAL SREL

cnt

 

assoc_in

assoc_in

QREL

cr

 

assoc_pr

assoc_pr

QREL

cr

 

bm_rep

nr_bm_rep

INTEGER

busrep id

 

bm_label

nr_bmlabel

STRING

 

 

bm_macro_smag

bm_macro_smag

LOCAL STRING 0

 

 

bm_status

nr_bms

INTEGER

busstat status_no

 

expiration_date

nr_exp_dt

LOCAL_TIME

 

 

financial_num

nr_financial_id

STRING

 

 

nsm_id

nsm_id

STRING 40

 

 

contact_1

nr_nx_ref_1

UUID

ca_contact uuid

 

contact_2

nr_nx_ref_2

UUID

ca_contact uuid

 

contact_3

nr_nx_ref_3

UUID

ca_contact uuid

 

linked_id_usp_owned_resource

linked_id_usp_owned_resource

UUID

 

 

smag_1

nr_nx_string1

STRING

 

 

smag_2

nr_nx_string2

STRING

 

 

smag_3

nr_nx_string3

STRING

 

 

smag_4

nr_nx_string4

STRING

 

 

smag_5

nr_nx_string5

STRING

 

 

smag_6

nr_nx_string6

STRING

 

 

priority

nr_pr_id

INTEGER

pri enum

 

name_type

nr_prim_skt_id

INTEGER

 

 

service_type

nr_service_type

STRING

srv_desc code

 

sla

nr_sla_id

INTEGER

 

 

warranty_end

nr_wrty_end_dt

LOCAL_TIME

 

 

warranty_start

nr_wrty_st_dt

LOCAL_TIME

 

 

ID

owned_resource_uuid

UUID