You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Where is Source Reference stored in the Review Completed Txns screen?

in Reporting and Analytics for SCM 3 comments

Summary:

In the Review Completed Transactions screen we have a ‘Source Reference’ column. I am unable to understand where this is stored in the sql base tables.

Content (please ensure you mask any confidential information):

Querying INV_Material_TXNS.. I see the record with the same transaction ID, all data matches up except for the Transaction_Source_ID & Transaction_Reference.. in the UI it is 1431933 & in the table it is 1446434.

ould someone please advise why the source reference in the review completed transactions screen does not match any field in the INV_MATERIAL_TXNS table?

Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!