Differenze tra le versioni di "BIRT View"
| Riga 18: | Riga 18: | ||
! Field Name !! Field Type !! Description | ! Field Name !! Field Type !! Description | ||
|- | |- | ||
| − | |COMPANY_ID || int (4)|| | + | |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)|| | + | |REMARK || nvarchar (400)|| REMARKs |
|- | |- | ||
| − | |TAX_NUMBER || nvarchar (100)|| | + | |TAX_NUMBER || nvarchar (100)|| Vat number |
|- | |- | ||
| − | |AII || bit (1)|| | + | |AII || bit (1)|| Flas stated that All Invoice has been Issued |
|- | |- | ||
| − | |creationDate || datetime (8)|| | + | |creationDate || datetime (8)|| Record creation date, Automatic field |
|- | |- | ||
| − | |creationuser || nvarchar (512)|| | + | |creationuser || nvarchar (512)|| Record creation user, Automatic field |
|- | |- | ||
| − | |revisionDate || datetime (8)|| | + | |revisionDate || datetime (8)|| Record creation date, Automatic field |
|- | |- | ||
| − | |revisionUser || nvarchar (512)|| | + | |revisionUser || nvarchar (512)|| Record creation user, Automatic field |
|} | |} | ||
Versione delle 09:08, 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 |
|---|
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 |
|---|
