Skip to Content
0
Dec 20, 2018 at 05:53 PM

Where are the descriptions of "Reason for Issuing Note" i.e. IssReason stored?

142 Views

Hello,

Referring to the field IssReason on all Credit/Debit Memos, in which table are the descriptions of the field IssReason stored? I know the current descriptions are:

1=Sales Return, 2=Post sale discount, 3=Deficiency in service, 4=Correction in invoice, 5=Change in POS, 6=Finalization of Provisional Assessment, 7=Others

But I would like to know which table they are stored in so that I don't have to use a CASE WHEN in a query and having to modify it if new descriptions are added in a future version.

Ref. http://www.saptables.net/?schema=BusinessOne9.3&column=IssReason