E1: DD: Display Decimals Update for Data Item Class QTYINV and Data Dictionary Item QNTY
(Doc ID 626475.1)
Last updated on NOVEMBER 23, 2019
JD Edwards EnterpriseOne Tools - Version 8.98 and later Information in this document applies to any platform.
The following explains the functionality of the Display Decimals Update for Data Dictionary items belonging to data item class QTYINV (Inventory Quantities) and for Data Dictionary item QNTY (Bill of Materials).
Display Decimals Definition
Display decimals define how many decimal places are placed to the right of the decimal point when a numeric variable is displayed or used in a calculation. It is defined for numeric data dictionary items and can be set from zero (0) to eight (8).
How Data is Stored and Displayed
How data is stored and displayed is best explained in the screen-print example below for the input number 1.2345.
The decimal shifting occurs provided the Decimal Shift flag in the database data source definition is turned ON. It should be turned ON for EnterpriseOne tables residing in SQL, Oracle and DB2/400 databases, (all databases except for Microsoft Access databases)
This document details how to update the display decimals for Data Dictionary items belonging to data item class QTYINV (Inventory Quantities) and for Data Dictionary item QNTY (Bill of Materials).
This document is intended for the EnterpriseOne Data Dictionary administrator who will be responsible for making these type of data dictionary display decimal changes.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!