Differenze tra le versioni di "BIRT View"

Da itm wiki.
Riga 8: Riga 8:
 
{| class="wikitable"
 
{| class="wikitable"
 
! Field Name !! Field Type !! Description
 
! 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
 
|}
 
|}
  
Riga 18: Riga 37:
 
! Field Name !! Field Type !! Description
 
! Field Name !! Field Type !! Description
 
|-
 
|-
|COMPANY_ID || int (4)||  Company id
+
|COMPANY_ID || int (4)||  Company Id
 
|-
 
|-
 
|id || int (4)||  Client Id
 
|id || int (4)||  Client Id
Riga 54: Riga 73:
 
|TAX_NUMBER || nvarchar (100)||  Vat number
 
|TAX_NUMBER || nvarchar (100)||  Vat number
 
|-
 
|-
|AII || bit (1)||  Flas stated that All Invoice has been Issued  
+
|AII || bit (1)||  Flag stated that All Invoice has been Issued  
 
|-
 
|-
 
|creationDate || datetime (8)||  Record creation date, Automatic field
 
|creationDate || datetime (8)||  Record creation date, Automatic field

Versione delle 09:49, 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

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