ER CTMS 041-076: Difference between revisions
No edit summary |
No edit summary |
||
| Line 20: | Line 20: | ||
A new system parameter called 'ORS_TYPE_DEF_GROUP_BY' with description 'List of the ORS types to default group by fields' will be used to identify ORS types that will default the 'Grp By' column from the master data to use in the report when the column itself may not be selected for display. | A new system parameter called 'ORS_TYPE_DEF_GROUP_BY' with description 'List of the ORS types to default group by fields' will be used to identify ORS types that will default the 'Grp By' column from the master data to use in the report when the column itself may not be selected for display. | ||
The initial values will be 'TYREKEYCUS,TYREKEYGRP' to default the 'Period', and the 'Customer' and 'Customer Group' fields respectively. | The initial values will be 'TYREKEYCUS,TYREKEYGRP' to default the 'Period', and the 'Customer' and 'Customer Group' fields respectively. | ||
The 'TYRE_KEY' reports will have separate types to report by 'Customer' or by 'Customer Group', they will be known as 'TYREKEYCUS' and 'TYREKEYGRP' respectively. | The 'TYRE_KEY' reports will have separate types to report by 'Customer' or by 'Customer Group', they will be known as 'TYREKEYCUS' and 'TYREKEYGRP' respectively. | ||
The 'Period' should be specified as a range of values in format 'YYYY-MM'. | The 'Period' should be specified as a range of values in format 'YYYY-MM'. | ||
The 'Customer' and the 'Customer Group' should be specified to optimise the production of the respective reports. | The 'Customer' and the 'Customer Group' should be specified to optimise the production of the respective reports. | ||
|- | |- | ||
Revision as of 17:08, 29 June 2022
EMERGENCY RELEASE - CTMS 11.0
RELNOTE ER041-076
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks |
|---|---|---|---|---|---|---|
| AT_ACC_SERVICES_00278541.sql | Database Script | 1.1 | 00278514 | 440451-32D | 3 | New ORS types 'STD_TIMES', 'TYREKEYCUS' and 'TYREKEYGRP' have been created.
A new system parameter called 'ORS_TYPE_DEF_GROUP_BY' with description 'List of the ORS types to default group by fields' will be used to identify ORS types that will default the 'Grp By' column from the master data to use in the report when the column itself may not be selected for display. The initial values will be 'TYREKEYCUS,TYREKEYGRP' to default the 'Period', and the 'Customer' and 'Customer Group' fields respectively. The 'TYRE_KEY' reports will have separate types to report by 'Customer' or by 'Customer Group', they will be known as 'TYREKEYCUS' and 'TYREKEYGRP' respectively. The 'Period' should be specified as a range of values in format 'YYYY-MM'. The 'Customer' and the 'Customer Group' should be specified to optimise the production of the respective reports. |
| AT_WMS_PRODUCT_XREF_00278514.sql | Database Script | 1.1 | " | " | " | " |
| DATA_ADM_SYSTEM_PARAM_00278514.sql | Database Script | 1.1 | " | " | " | " |
| DATA_1_ORS_SQL_00278514.sql | Database Script | 1.1 | " | " | " | " |
| DATA_2_ORS_MASTER_DATA_00278514.sql | Database Script | 1.1 | " | " | " | " |
| DP_ORS_FUNCS.sql | Oracle Reporting Suite Functions Database Package | 5.28 | " | " | " | " |
| DP_REPORTS.sql | Reports Database Package | 5.66 | " | " | " | " |
| ORS.fmx | Reporting Suite Form | 1.35 | " | " | " | " |
| New Parameters | |||
|---|---|---|---|
| Parameter Name | Config Level | Setting Value | Result |
| ORS_TYPE_DEF_GROUP_BY | SYSTEM | NOT NULL | The 'Grp By' tick boxes will be populated by default from the master data, for example, 'TYREKEYCUS,TYREKEYGRP'. |
| ORS_TYPE_DEF_GROUP_BY | SYSTEM | NULL | The 'Grp By' tick boxes will not be populated by default from the master data. |
