Material Item Pricing
Before running the F44H603 Material Item Pricing Table Conversion program (R44H96003), you must revise any JD Edwards World item price data to eliminate any records that do not satisfy the unique key requirement. Run the Item Pricing Pre-Conversion Review (R44H4459) to search for unique key violations between the Material Item Pricing tables for JD Edwards World (F4459) and JD Edwards EnterpriseOne (F44H603).
This table lists the keys for the Material Item Pricing tables:
F4459 (JD Edwards World) Keys |
F44H603 (JD Edwards EnterpriseOne) Keys |
|---|---|
1. CTYC (City) |
1. HBAREA (Area) |
2. LITM (2nd Item Number) |
2. ITM (Short ID Number) |
3. AN8 (Supplier Number) |
3. AN8 (Supplier Number) |
4. MCU (Subdivision) |
4. HBMCUS (Community) |
5. PRN (Price Revision Number) |
5. CPHASE (Phase) |
6. EFFF (Effective Date) |
The R44H4459 program reads all the records in table F4459 in this order:
CTYC
ITM
AN8
MCU
EFFF
The report prints a list of these key values that are in the current F4459 table, as well as the Short ID Number and Effective Date values.
To avoid duplicate key errors, you should either delete all but the current records, or change the effective dates to create a unique record prior to running the F44H603 Material Item Pricing Table Conversion program (R44H96003).