Parsing Multi-Part Keys from Extender Tables

(0) Share

Report

Posted on by Don Clark

Am trying to figure out how to parse the multi-part keys from EXT00180. I have created a detail window that is a child window to the Items within Sales Transaction Entry. So my new window is a "breakdown" of a Sales Item.

The window has a two part Key

Document_Number + Line_Item_Sequence (Project)

Within the Extender tables GP seems to have combined the two key values into one string.

For example in EXT00180 the PT_UD_Key column contains STDINV226816384 Where STDINV2268 is the invoice_number (document number) and 16384 is the line item number

Are there some setup parameters that tell me how to parse out the invoice_number vs. the line item number? Or any other tips? Maybe the setup of extender window was wrong?

I've looked thru every EXT* table and don't see anywhere where the two key values are in separate columns?

Any help appreciated.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Don Clark 10 on at

Like (0)

Report
Copy link

Link copied!

I think I have discovered the way I should have been looking at this.

I was trying to parse out the invoice number so I could join back to the SOP HEADER TABLE (SOP10100).

Instead I can join back from the EXTENDER tables KEY column, to the SOP LINES TABLE (SOP10200) . SOP10200 has two columns, SOPNUMBE and LNITMSEQ. If I concatenate those two columns (after doing the necessary conversion to strings and trimming, I can join that to the PT_UD_KEY column in Extender.

From there I can join back to SOP10100 and pickup all my Invoice Header data.

Was this reply helpful? Yes No