business logic query MfgMessageByNumber (distinct)

Description

Query that will get the message details from the MFG/PRO database for the specified message number and language.

iiMessageNumber	integer	The MFG/PRO message number to retrieve the message details for.
icLanguageCode	character	The language code to get the message text for. This determines which instance of the message gets returned.

each msg_mstr where

msg_mstr.msg_nbr = iiMessageNumber AND
msg_mstr.msg_lang = icLanguageCode

field name	data type	db field	description
tcmsg_desc	character	msg_mstr.msg_desc	Message
tcmsg_lang	character	msg_mstr.msg_lang	Language
timsg_nbr	integer	msg_mstr.msg_nbr	Message Number
tcmsg_type	character	msg_mstr.msg_type	Type
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(msg_mstr)

QadFinancials