BIRT View
Da itm wiki.
Versione del 8 mar 2018 alle 08:55 di Francesco.bertuletti (discussione | contributi)
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) |
