BIRT View

Da itm wiki.

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

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) Flas 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