Subledger Source Document Type in Journal Entry Query

[kedalenechong]

Hi All

How to get a corresponding mapping between these two Origin values in Journal Entry Query Statement and Subledger Journal Entry so we know which Origin Number in JE belongs to AP Invoice PU Origin?

Kedalene Chong

[Felipe_Lima · Accepted solution]

Hi @kedalenechong ,

Yes. TransType is what you're looking for. A simple CASE statement will deal with it. See a very basic example below. You'll have to adapt it to your needs.

SELECT
	CASE TransType 
		WHEN '13' THEN 'SI'
		WHEN '14' THEN 'CN'
		WHEN '15' THEN 'DN'
		WHEN '18' THEN 'PU'
		WHEN '19' THEN 'PC'
		-- Include the other types based on the TransType (Object Type) list I shared
	END AS 'Origin'
	-- Then the rest of your query...
FROM OJDT

BR,
Felipe