ER CTMS 041-076: Difference between revisions
(Created page with "<!-- MEDIA LANDSCAPE YES --> {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER041-076 }} {| class="wikitable" border="1" width="100%" |- bgcolor="sil...") |
No edit summary |
||
| Line 14: | Line 14: | ||
|Database Script | |Database Script | ||
|1.1 | |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 | |AT_WMS_PRODUCT_XREF_00278514.sql | ||
| Line 74: | Line 80: | ||
|" | |" | ||
|" | |" | ||
|} | |||
{| class="wikitable" border="1" width="100%" | |||
|- bgcolor="silver" | |||
!colspan="4" | 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. | |||
|} | |} | ||
Revision as of 17:48, 28 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.fmxOracle | 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. |
