Differenze tra le versioni di "BIRT View"
Riga 1: | Riga 1: | ||
− | + | 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
Indice
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 |
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 |
---|