We are passing create PO via web-services and want to insert extender values connected to PO Line Item scroll window. There are 3 values we are passing to Extender.
We are at a road block working with inserts to EXT001100 and EXT001101 and have a hard deadline. Do anyone have information you could share with us on how you inserted extender values with SQL?
I believe we are missing a PK that ties the Extender Window to the POP10110.
Thank you,
Donnette
*This post is locked for comments
Sorry, the field name for PO Line Seq. is "ORD" as Tim mentioned. You would need to store ORD (if it's part of the key fields) onto any of the "Extender_Key_Values_" fields.
@Donnette: PO line sequence would be stored in EXT01100 as part of the key fields, if you have added PO Line Seq as one. All we need to have is a correct link between EXT01100 and EXT01101 tables. That's nothing but the Extender_Record_ID.
So here it is: POP10110 (PO Line Work) table links with EXT01100 (Extender Record Header) table with key fields and an auto-generated Extender_Record_ID.
EXT01100 table then links with EXT01101 (Extender Record String) table with Extender_Record_ID as the key. Extender_Field_ID in EXT01101 table determines the string field and value for that particular window record; storing the right value on the right field that you see in additional window.
Can you properly, reliably add and retrieve the values to the Extender Window via the "front end" (GP Client)?
POP10110 has 3 key fields (PONUMBER, ORD, BRKFLD1) . Are you referencing them as keys in the definition of your Extender Window?
Tim
Hi V,
Thank you so much for this information.
How is the Purchase Order line number sequence Joined to the Extender Record ID?
Thank you,
Donnette
A bit tricky. You will first need to create an Extender Record Header for each PO additional information record. Each record in EXT01100 would require a unique "Record ID" that you must generate at runtime based on total number of records that are already there in this table.
I assume that all three values you want to pass are "string" values. In that case, you need only more table EXT01101. For each string value that you need to insert into EXT01101, you need the exact "Field ID". Otherwise, the whole record would become either incorrect or corrupt.
This is probably the simplest way I could think and explain. :-)
I'm not sure if I have done any SQL update on Extender table as it's been a while. but if you have doubts in linking tables on a Particular extender window, You can create a Extender View for the same window and then Click "Display SQL" button to see how tables are linked.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156