Differenze tra le versioni di "BIRT View"

Da itm wiki.
Riga 90: Riga 90:
 
{| class="wikitable"
 
{| class="wikitable"
 
! Field Name !! Field Type !! Description
 
! Field Name !! Field Type !! Description
−
|-|ID || int (4)||  Organization Unit Id
+
|-
−
|-|CODE || int (4)||  Organization Unit internal identifier
+
|ID || int (4)||  Organization Unit Id
−
|-|NAME || nvarchar (512)||  Organization Unit name
+
|-
−
|-|STATUS || nvarchar (510)||  Organization Unit  status
+
|CODE || int (4)||  Organization Unit internal identifier
−
|-|CLIENT_ID || int (4)||  Reference to client the Organization Unit  belongs to
+
|-
−
|-|PARENT_ID || int (4)||  Reference to father Organization Unit  
+
|NAME || nvarchar (512)||  Organization Unit name
−
|-|path || nvarchar (8000)||  Chain of Organization Unit  
+
|-
−
|-|CUSTOM_FIELD_1 || nvarchar (2048)|| Custom field available to store metadata
+
|STATUS || nvarchar (510)||  Organization Unit  status
−
|-|CUSTOM_FIELD_2 || nvarchar (2048)|| Custom field available to store metadata   
+
|-
−
|-|CUSTOM_FIELD_3 || nvarchar (2048)|| Custom field available to store metadata
+
|CLIENT_ID || int (4)||  Reference to client the Organization Unit  belongs to
−
|-|CUSTOM_FIELD_4 || nvarchar (2048)|| Custom field available to store metadata
+
|-
−
|-|CUSTOM_FIELD_5 || nvarchar (2048)|| Custom field available to store metadata  
+
|PARENT_ID || int (4)||  Reference to father Organization Unit  
−
|-|CUSTOM_FIELD_6 || nvarchar (2048)|| Custom field available to store metadata   
+
|-
−
|-|ADDRESS || nvarchar (400)|| Organization Unit Address
+
|PATH || nvarchar (8000)||  Chain of Organization Unit  
−
|-|POSTAL_CODE || nvarchar (200)||  Organization Unit Postal Code
+
|-
−
|-|CITY || nvarchar (200)||  Organization Unit City
+
|CUSTOM_FIELD_1 || nvarchar (2048)|| Custom field available to store metadata
−
|-|REGION || nvarchar (200)||  Organization Unit Region
+
|-
−
|-|NATION || nvarchar (512)||  Organization Unit Nation
+
|CUSTOM_FIELD_2 || nvarchar (2048)|| Custom field available to store metadata   
−
|-|PHONE || nvarchar (200)||  Organization Unit Phone number
+
|-
−
|-|FAX || nvarchar (200)||  Organization Unit Fax number
+
|CUSTOM_FIELD_3 || nvarchar (2048)|| Custom field available to store metadata
−
|-|MAIL || nvarchar (200)||  Organization Unit Email address
+
|-
−
|-|REMARK || nvarchar (400)||  Organization Unit Address remark
+
|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
 
|}
 
|}
  

Versione delle 16:44, 8 mar 2018

itmSUITE(r) 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

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 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
Estratto da "http://wiki.itmsuite.eu/index.php?title=BIRT_View&oldid=3666"