Differenze tra le versioni di "BIRT View"

Da itm wiki.
Riga 1: Riga 1:
−
itmSUITE(r) propose to a customer a set of Standard view to facilitate the reporting development.
+
itmSUITE® propose to a customer a set of Standard view to facilitate the reporting development.
 
The paragraphs below report the standard view collection and explains the relation between data’s
 
The paragraphs below report the standard view collection and explains the relation between data’s
  
Riga 142: Riga 142:
 
{| class="wikitable"
 
{| class="wikitable"
 
! Field Name !! Field Type !! Description
 
! Field Name !! Field Type !! Description
 +
|-
 +
|COMPANY_ID || int (4)||  Company Id
 +
|-
 +
|id || int (4)||  Resource Id
 +
|-
 +
|CODE || int (4)||  Resource internal identifier
 +
|-
 +
|LOGIN || nvarchar (400)||  Resource login
 +
|-
 +
|NAME || nvarchar (400)||  Resource name
 +
|-
 +
|SURNAME || nvarchar (400)|| Resource surname
 +
|-
 +
|FULLNAME || nvarchar (802)||  Resource surname  + name
 +
|-
 +
|RESOURCE_STATUS_ID || int (4)|| Resource Status id
 +
|-
 +
|RESOURCE_STATUS || nvarchar (512)||  Resource Status name
 +
|-
 +
|CREATOR_ID || int (4)|| Resource Creator id
 +
|-
 +
|NATION_ID || int (4)||  Resource Nation id
 +
|-
 +
|NATION || nvarchar (512)|| Nation
 +
|-
 +
|CLIENT_ID || int (4)||  Id of client the resource belongs to
 +
|-
 +
|CLIENT || nvarchar (400)||  Name of client the resource belongs to
 +
|-
 +
|ORGANIZATION_UNIT_ID || int (4)||  Organization Unit id the resource belongs to
 +
|-
 +
|PATH || nvarchar (8000)||  Organization Unit path
 +
|-
 +
|SALEROLE_ID || int (4)||  Sale Role id, this information can drive sales revenue amount
 +
|-
 +
|SALES_ROLE || nvarchar (512)||  Sale Role name
 +
|-
 +
|SUPPLIER_ID || int (4)|| Id of supplier the resource belongs to
 +
|-
 +
|SUPPLIER || nvarchar (400)|| Name of supplier the resource belongs to
 +
|-
 +
|PURCHASEROLE_ID || int (4)||  Purchase Role id, this information can drive Purchase cost amount
 +
|-
 +
|PURCHASE_ROLE || nvarchar (512)|| Purchase Role name
 +
|-
 +
|BIRTH_DAY || datetime (8)||  Resource birth day
 +
|-
 +
|BIRTH_PLACE || nvarchar (400)|| Resource birth Place
 +
|-
 +
|EXTERNALCODE || nvarchar (400)|| Field used to store external resource reference 
 +
|-
 +
|RESTYPE_ID || int (4)|| Id of Resource type
 +
|-
 +
|VIP_TYPE || int (4)||  Resource type name
 +
|-
 +
|CANDECLAREHOLIDAY || bit (1)|| Flag that identify if the resource can declare his own holiday
 +
|-
 +
|CANDECLAREILLNESS || bit (1)|| Flag that identify if the resource can declare his own illness 
 +
|-
 +
|IS_EDIT_RESOURCE_DATA || bit (1)|| This flag enable the resource to modify his own data
 +
|-
 +
|IS_PERSONAL_VIEW_RIGHT || bit (1)|| This flag enable the resource to define personal view
 +
|-
 +
|CMS_ACCESS || bit (1)|| This flag enable the resource to access the Configuration Management System
 +
|-
 +
|USER_MAPPING_MODE || nvarchar (510)||
 +
|-
 +
|EXT_CMDB_MODIFY || bit (1)|| 
 +
|-
 +
|EXT_CMDB_VIEW || bit (1)|| 
 +
|-
 +
|creationDate || datetime (8)||  Record creation date, Automatic field
 +
|-
 +
|creationuser || nvarchar (512)||  Record creation user, Automatic field
 +
|-
 +
|revisionDate || datetime (8)||  Record creation date, Automatic field
 +
|-
 +
|revisionUser || nvarchar (512)||  Record creation user, Automatic field
 +
|}
  
−
|}
 
 
== PROJECT SERVICE VIEW ==
 
== PROJECT SERVICE VIEW ==
 
This view report some company information. The View's name is: _STD_PROJECT_SERVICE_VIEW
 
This view report some company information. The View's name is: _STD_PROJECT_SERVICE_VIEW
Riga 176: Riga 254:
  
 
|}
 
|}
 +
=== TICKET CUSTOM FIELD VIEW ===
 +
This view report some company information. The View's name is: _STD_TICKET_CUSTOM_FIELDS_VIEW
 +
 +
The information reported are shown in the following table:
 +
{| class="wikitable"
 +
! Field Name !! Field Type !! Description
 +
 +
|}
 +
 +
 
=== TICKET CONFIGURATION ITEM VIEW ===
 
=== TICKET CONFIGURATION ITEM VIEW ===
 
This view report some company information. The View's name is: _STD_TICKET_CONFIGURATION_ITEM_VIEW
 
This view report some company information. The View's name is: _STD_TICKET_CONFIGURATION_ITEM_VIEW
Riga 186: Riga 274:
 
== TIMESHEET VIEW ==
 
== TIMESHEET VIEW ==
 
This view report some company information. The View's name is: _STD_TIMESHEET_VIEW
 
This view report some company information. The View's name is: _STD_TIMESHEET_VIEW
 +
 +
The information reported are shown in the following table:
 +
{| class="wikitable"
 +
! Field Name !! Field Type !! Description
 +
 +
|}
 +
 +
=== SERVICE CATALOGUE REQUEST (SRCS)VIEW ===
 +
This view report some company information. The View's name is: _STD_PROJECT_SERVICE_ACTIVITY_VIEW
  
 
The information reported are shown in the following table:
 
The information reported are shown in the following table:

Versione delle 17:17, 8 mar 2018

itmSUITE® propose to a customer a set of Standard view to facilitate the reporting development. The paragraphs below report the standard view collection and explains the relation between data’s

COMPANY VIEW

This view report some company information. The View's name is: _STD_COMPANY_VIEW

The information reported are shown in the following table:

Field Name Field Type Description
ID int (4) Company Id
NAME nvarchar (400) Name of the company
DESCRIPTION nvarchar (400) Description of the company
STATUS nvarchar (510) Company Status
APPLICATION_URL nvarchar (512) Applicaiton url, use to set a detail link information in notification
CONTACTS nvarchar (400) Email of Application referent
TIMEZONE nvarchar (64) Company Time Zone
DURATION_FORMAT nvarchar (510) Unit of measure of Timesheet declaration
LABOURUNIT_ID int (4) id of Labor
LABOUR_UNIT nvarchar (8000) Unit of Measure of Labor. This is the unit of measure use in Budget estimation

CLIENT VIEW

This view report some company information. The View's name is: _STD_CLIENT_VIEW

The information reported are shown in the following table:

Field Name Field Type Description
COMPANY_ID int (4) Company Id
ID int (4) Client Id
CODE int (4) Company internal identifier
NAME nvarchar (400) Client Name
PARENT_ID int (4) Parent Client id
CLSTATUS_ID int (4) Status id
CLIENT_STATUS nvarchar (8000) Status name
CLTYPE_ID int (4) Id of client type
CLIENT_TYPE nvarchar (512) Client Type
CREATOR_ID int (4) Client Creator id
NATION_ID int (4) Country id
NATION nvarchar (512) Country Name
LANGUAGE_ID int (4) Language Id
LANGUAGE nvarchar (512) Language Name
PAYMENTTERM_ID int (4) Payment terms id
PAYMENTTERM nvarchar (512) Payment terms
REMARK nvarchar (400) REMARKs
TAX_NUMBER nvarchar (100) Vat number
AII bit (1) Flag stated that All Invoice has been Issued
creationDate datetime (8) Record creation date, Automatic field
creationuser nvarchar (512) Record creation user, Automatic field
revisionDate datetime (8) Record creation date, Automatic field
revisionUser nvarchar (512) Record creation user, Automatic field

CLIENT ORGANIZATION UNIT VIEW

This view report some company information. The View's name is: _STD_CLIENT_ORGANIZATION_UNIT_VIEW

The information reported are shown in the following table:

Field Name Field Type Description
ID int (4) Organization Unit Id
CODE int (4) Organization Unit internal identifier
NAME nvarchar (512) Organization Unit name
STATUS nvarchar (510) Organization Unit status
CLIENT_ID int (4) Reference to client the Organization Unit belongs to
PARENT_ID int (4) Reference to father Organization Unit
PATH nvarchar (8000) Chain of Organization Unit
CUSTOM_FIELD_1 nvarchar (2048) Custom field available to store metadata
CUSTOM_FIELD_2 nvarchar (2048) Custom field available to store metadata
CUSTOM_FIELD_3 nvarchar (2048) Custom field available to store metadata
CUSTOM_FIELD_4 nvarchar (2048) Custom field available to store metadata
CUSTOM_FIELD_5 nvarchar (2048) Custom field available to store metadata
CUSTOM_FIELD_6 nvarchar (2048) Custom field available to store metadata
ADDRESS nvarchar (400) Organization Unit Address
POSTAL_CODE nvarchar (200) Organization Unit Postal Code
CITY nvarchar (200) Organization Unit City
REGION nvarchar (200) Organization Unit Region
NATION nvarchar (512) Organization Unit Nation
PHONE nvarchar (200) Organization Unit Phone number
FAX nvarchar (200) Organization Unit Fax number
MAIL nvarchar (200) Organization Unit Email address
REMARK nvarchar (400) Organization Unit Address remark

RESOURCE VIEW

This view report some company information. The View's name is: _STD_RESOURCE_VIEW

The information reported are shown in the following table:

Field Name Field Type Description
COMPANY_ID int (4) Company Id
id int (4) Resource Id
CODE int (4) Resource internal identifier
LOGIN nvarchar (400) Resource login
NAME nvarchar (400) Resource name
SURNAME nvarchar (400) Resource surname
FULLNAME nvarchar (802) Resource surname + name
RESOURCE_STATUS_ID int (4) Resource Status id
RESOURCE_STATUS nvarchar (512) Resource Status name
CREATOR_ID int (4) Resource Creator id
NATION_ID int (4) Resource Nation id
NATION nvarchar (512) Nation
CLIENT_ID int (4) Id of client the resource belongs to
CLIENT nvarchar (400) Name of client the resource belongs to
ORGANIZATION_UNIT_ID int (4) Organization Unit id the resource belongs to
PATH nvarchar (8000) Organization Unit path
SALEROLE_ID int (4) Sale Role id, this information can drive sales revenue amount
SALES_ROLE nvarchar (512) Sale Role name
SUPPLIER_ID int (4) Id of supplier the resource belongs to
SUPPLIER nvarchar (400) Name of supplier the resource belongs to
PURCHASEROLE_ID int (4) Purchase Role id, this information can drive Purchase cost amount
PURCHASE_ROLE nvarchar (512) Purchase Role name
BIRTH_DAY datetime (8) Resource birth day
BIRTH_PLACE nvarchar (400) Resource birth Place
EXTERNALCODE nvarchar (400) Field used to store external resource reference
RESTYPE_ID int (4) Id of Resource type
VIP_TYPE int (4) Resource type name
CANDECLAREHOLIDAY bit (1) Flag that identify if the resource can declare his own holiday
CANDECLAREILLNESS bit (1) Flag that identify if the resource can declare his own illness
IS_EDIT_RESOURCE_DATA bit (1) This flag enable the resource to modify his own data
IS_PERSONAL_VIEW_RIGHT bit (1) This flag enable the resource to define personal view
CMS_ACCESS bit (1) This flag enable the resource to access the Configuration Management System
USER_MAPPING_MODE nvarchar (510)
EXT_CMDB_MODIFY bit (1)
EXT_CMDB_VIEW bit (1)
creationDate datetime (8) Record creation date, Automatic field
creationuser nvarchar (512) Record creation user, Automatic field
revisionDate datetime (8) Record creation date, Automatic field
revisionUser nvarchar (512) Record creation user, Automatic field

PROJECT SERVICE VIEW

This view report some company information. The View's name is: _STD_PROJECT_SERVICE_VIEW

The information reported are shown in the following table:

Field Name Field Type Description

PROJECT SERVICE ACTIVITY VIEW

This view report some company information. The View's name is: _STD_PROJECT_SERVICE_ACTIVITY_VIEW

The information reported are shown in the following table:

Field Name Field Type Description

TICKET VIEW

This view report some company information. The View's name is: _STD_TICKET_VIEW

The information reported are shown in the following table:

Field Name Field Type Description

TICKET ACTIVITY VIEW

This view report some company information. The View's name is: _STD_TICKET_ACTIVITY_VIEW

The information reported are shown in the following table:

Field Name Field Type Description

TICKET CUSTOM FIELD VIEW

This view report some company information. The View's name is: _STD_TICKET_CUSTOM_FIELDS_VIEW

The information reported are shown in the following table:

Field Name Field Type Description


TICKET CONFIGURATION ITEM VIEW

This view report some company information. The View's name is: _STD_TICKET_CONFIGURATION_ITEM_VIEW

The information reported are shown in the following table:

Field Name Field Type Description

TIMESHEET VIEW

This view report some company information. The View's name is: _STD_TIMESHEET_VIEW

The information reported are shown in the following table:

Field Name Field Type Description

SERVICE CATALOGUE REQUEST (SRCS)VIEW

This view report some company information. The View's name is: _STD_PROJECT_SERVICE_ACTIVITY_VIEW

The information reported are shown in the following table:

Field Name Field Type Description
Estratto da "http://wiki.itmsuite.eu/index.php?title=BIRT_View&oldid=3668"