Avatar OE 2024 Update 19
Product Requirements and Recommendations
Avatar CWS
required
Avatar OE
required
RADplus
required
Recommended Update Level
Avatar CWS 2024 Monthly Release 2024.01.01
Avatar OE 2024 Monthly Release 2024.01.01
RADplus 2024 Monthly Release 2024.01.01
Product Update Description
An issue is resolved in the table 'OrderEntry.table_order_group' where the field 'ORDERID' has a datatype of "Numeric" instead of "String", which could result in incorrect handling of non-numeric 'ORDERID' values in reports and queries, and makes it more difficult to use this field to JOIN to other tables where the 'ORDERID' field is correctly defined as datatype "String". Because changing the datatype of an existing field in a table can cause existing reports and queries to fail, a new property called 'ORDERID_string' is added to this table. The 'ORDERID_string' field contains the 'Order Code' for each component order within an 'Order Group' in a field that is defined as datatype "String". This new field can be used to JOIN to other tables that have an 'ORDERID' field that is defined as datatype "String".
Required Updates
None
Included Updates
None
| Table | Column | Change |
|---|---|---|
| OrderEntry.tableordergroup | ORDERID_string | added |
| OrderEntry.tableordergroup | data_entry_offset | added |
| OrderEntry.tableordergroup | data_entry_time_j | added |
| OrderEntry.tableordergroup | data_entry_timezone_info_all | added |
| OrderEntry.tableordergroup | data_entry_timezone_short | added |
| OrderEntry.tableordergroup | data_entry_utc | added |