Differenze tra le versioni di "BIRT View"
| 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 | + | |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)|| | + | |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
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 |
|---|
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 |
|---|
