Table for Source Reference field on Completed Transaction page - SCM Cloud — Cloud Customer Connect
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

Table for Source Reference field on Completed Transaction page - SCM Cloud

in Reporting and Analytics for SCM 8 comments

Summary:

Hello,

We are building a custom BI report on review completed transaction page and looking for a table and column name for SOURCE REFERENCE field.


Content (please ensure you mask any confidential information):

We are building a custom BI report on review completed transaction page and looking for a table and column name for SOURCE REFERENCE field, its a numeric field for transactions like Transfer Order and MR no. for Movement order and ADJ for Account Alias transaction types etc.

Like for Account alias, INV_GENERIC_DISPOSTION table has segment1 field but for other transactions its not there.

CST_INV_TRANSACTIONS also has txn_source_ref_doc_number which shows the correct source reference number for few transactions (Account alias, MR, Transfer Order) but only if costing is done.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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