Differenze tra le versioni di "BIRT View"
Da itm wiki.
| Riga 2: | Riga 2: | ||
The paragraphs below report the standard view collection and explains the relation between data’s | The paragraphs below report the standard view collection and explains the relation between data’s | ||
| − | == | + | == COMPANY VIEW == |
| − | This view report some company information | + | This view report some company information. The View's name is: _STD_COMPANY_VIEW |
The information reported are shown in the following table: | The information reported are shown in the following table: | ||
| + | {| class="wikitable" | ||
| + | ! Field Name !! Field Type !! Description | ||
| + | |- | ||
| + | |COMPANY_ID || int (4)|| | ||
| + | |- | ||
| + | |id || int (4)|| | ||
| + | |- | ||
| + | |CODE || int (4)|| | ||
| + | |- | ||
| + | |NAME || nvarchar (400)|| | ||
| + | |- | ||
| + | |parent_id || int (4)|| | ||
| + | |- | ||
| + | |CLSTATUS_ID || int (4)|| | ||
| + | |- | ||
| + | |CLIENT_STATUS || nvarchar (8000)|| | ||
| + | |- | ||
| + | |CLTYPE_ID || int (4)|| | ||
| + | |- | ||
| + | |CLIENT_TYPE || nvarchar (512)|| | ||
| + | |- | ||
| + | |CREATOR_ID || int (4)|| | ||
| + | |- | ||
| + | |NATION_ID || int (4)|| | ||
| + | |- | ||
| + | |NATION || nvarchar (512)|| | ||
| + | |- | ||
| + | |LANGUAGE_ID || int (4)|| | ||
| + | |- | ||
| + | |LANGUAGE || nvarchar (512)|| | ||
| + | |- | ||
| + | |PAYMENTTERM_ID || int (4)|| | ||
| + | |-|PAYMENTTERM || nvarchar (512)|| | ||
| + | |- | ||
| + | |REMARK || nvarchar (400)|| | ||
| + | |- | ||
| + | |TAX_NUMBER || nvarchar (100)|| | ||
| + | |- | ||
| + | |AII || bit (1)|| | ||
| + | |- | ||
| + | |creationDate || datetime (8)|| | ||
| + | |- | ||
| + | |creationuser || nvarchar (512)|| | ||
| + | |- | ||
| + | |revisionDate || datetime (8)|| | ||
| + | |- | ||
| + | |revisionUser || nvarchar (512)|| | ||
| + | |} | ||
| + | == CLIENT VIEW == | ||
| − | == | + | == CLIENT ORGANIZATION UNIT VIEW == |
| − | == | + | == RESOURCE VIEW == |
| − | == | + | == PROJECT SERVICE VIEW == |
| − | == PROJECT | + | === PROJECT SERVICE ACTIVITY VIEW === |
| − | == | + | == TICKET VIEW == |
| − | == | + | === TICKET ACTIVITY VIEW === |
| − | === | + | === TICKET CONFIGURATION ITEM VIEW === |
| − | == | + | == TIMESHEET VIEW == |
| − | |||
| − | |||
Versione delle 08:55, 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 |
|---|---|---|
| COMPANY_ID | int (4) | |
| id | int (4) | |
| CODE | int (4) | |
| NAME | nvarchar (400) | |
| parent_id | int (4) | |
| CLSTATUS_ID | int (4) | |
| CLIENT_STATUS | nvarchar (8000) | |
| CLTYPE_ID | int (4) | |
| CLIENT_TYPE | nvarchar (512) | |
| CREATOR_ID | int (4) | |
| NATION_ID | int (4) | |
| NATION | nvarchar (512) | |
| LANGUAGE_ID | int (4) | |
| LANGUAGE | nvarchar (512) | |
| PAYMENTTERM_ID | int (4) | |
| REMARK | nvarchar (400) | |
| TAX_NUMBER | nvarchar (100) | |
| AII | bit (1) | |
| creationDate | datetime (8) | |
| creationuser | nvarchar (512) | |
| revisionDate | datetime (8) | |
| revisionUser | nvarchar (512) |
