peterbruce
Legendary Poster
JDEList,
When Find is clicked in P48201 (Work With Orders) (W48201F) and all fields are wild cards, the following SQL is executed and nothing is returned:
SELECT *
FROM PRODDTA.F4801 T0,PRODDTA.F4801T T1,PRODDTA.F40039 T2
WHERE T0.WADOCO = T1.WADOCO (+)
AND T2.DTDCT = T0.WADCTO
ORDER BY T0.WADOCO ASC
The reason nothing is returned is because the table PRODDTA.F40039 (Document Type Master) is empty. The application that appears to populate it is P40040 (Work With Document Type). The table F40039 existed in Xe before we upgraded. We either did not use it (ie. not required to access data in F4801 from P48201) and it was not populated (most likely) or when we upgraded, it was not converted.
What is the use of this table and how is it populated? If I populate it - will it have any effect beyond allowing access to data in the F4801 from P48201?
We only use work orders as they relate to job cost for project accounting.
When Find is clicked in P48201 (Work With Orders) (W48201F) and all fields are wild cards, the following SQL is executed and nothing is returned:
SELECT *
FROM PRODDTA.F4801 T0,PRODDTA.F4801T T1,PRODDTA.F40039 T2
WHERE T0.WADOCO = T1.WADOCO (+)
AND T2.DTDCT = T0.WADCTO
ORDER BY T0.WADOCO ASC
The reason nothing is returned is because the table PRODDTA.F40039 (Document Type Master) is empty. The application that appears to populate it is P40040 (Work With Document Type). The table F40039 existed in Xe before we upgraded. We either did not use it (ie. not required to access data in F4801 from P48201) and it was not populated (most likely) or when we upgraded, it was not converted.
What is the use of this table and how is it populated? If I populate it - will it have any effect beyond allowing access to data in the F4801 from P48201?
We only use work orders as they relate to job cost for project accounting.