Extender update with SQL

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Jothi Krishnan N 1,897 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Suggested answer

Vaidy Mohan 351 on at

Like (0)

Report
Copy link

Link copied!

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. :-)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Tim Foster 8,515 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Vaidy Mohan 351 on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Suggested answer

Vaidy Mohan 351 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No