E9.2 SQL Table for Document Type and Description

[Selva89]

Hi all,

I'm new to JDE and deals with data; I am trying to figure out SQL table to view the document type and it's description. I'm clueless which table to look for. I want to make join with document type used in Sales, Purchase, Contract, Customer and Vendor ledgers.

Please help me out with SQL tables.

Thanks in advance.

 

[StewartSchatz]

Welcome to JDE!
I'm no developer but that seems like a pretty big ask to just have given to you.
Give this site a try: https://jde.erpref.com

 

[peterbruce]

Hi Selva89,

The are a few parts to Document Types. They are defined in the UDC table F0005 (00/DT). There is also the Document Type Master - F40039. There is also the application Work With Document Type (P40040). For more information you can look these up in the JDE manuals and/or search for them in JDEList.

 

[eydeak]

The document type UDC is 00-DT in table F0005 (User Defined Code Values). The UDC code has significant leading spaces that you need to account for if you are trying to do a table join at the database level. When you are coding with the JDE tools, it handles that in the background. Here is a sample SQL to pull in the document type description for orders:

select SDKCOO, SDDOCO, SDDCTO, SDLNID, DRDL01, DRDL02
from TESTDTA.F4211 left outer join
(select trim(DRKY) as KY, DRDL01, DRDL02
from TESTCTL.F0005
where DRSY = '00' and DRRT = 'DT'
) as UDC on TESTDTA.F4211.SDDCTO = UDC.KY
where SDTRDJ > 123000

Regards,
Ellen